Howdy Folks,
what is the best solution to import large amounts of records into an MySQL or Oracle Database. I Think there are two ways :
Insert every record with an persistent connection
Create on BIG SQL-Statement and query the Database
Iam not sure wich is performing better ? Is there any Best Practice Solutions for this kind of operation ??
My singleton business object is defined in Global:
public class Global : HttpApplication
{
public static BusinessForm BusinessFormLayer;
void Application_Start(object sender, EventArgs e)
{
FormDalProvider concreteProvider = FormDalProvider.Instance;
BusinessForumLayer = new BusinessForum(concreteProvider);
}
}
My page:
<asp:ObjectDataSource ID="objThreads" runat="server"
SelectMethod="GetForms"
SelectCountMethod="GetFormsCount"
TypeName="Global.BusinessFormLayer"
EnablePaging="true"
SortParameterName="sortExpression">
In Visual Studio debug mode it's possible to hover over variables to show their value and then right-click to "Copy", "Copy Expression" or "Copy Value".
In case the variable is an object and not just a basic type, there's a + sign to expand and explore the object. It there a way to copy all that into the clipboard?
I'd like to mock up object data, not the objects themselves. In other words, I would like to generate a collection of n objects and pass it into a function which generates random data strings and numbers. Is there anything to do this? Think of it as a Lorem Ipsum for object data. Constraints around numerical ranges etc. are not necessary, but would be a bonus.
I want to override the method of "session_store" in ActionController::SessionManagement::ClassMethods.
In my overrides, I need the "request" object which has a lot of useful information such as host name, domain name, etc...
Do you have any idea to get the "request" object in that method.
My rails version is 2.3.5. Thank you in advance.
What is the difference between the following 2 ways to allocate and init an object?
AController *tempAController = [[AController alloc] init];
self.aController = tempAController;
[tempAController release];
and
self.aController= [[AController alloc] init];
Most of the apple example use the first method. Why would you allocate, init and object and then release immediately?
i have the following code
Private Sub select_color_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles select_color.Click
Dim ocolor As New ColorDialog
ocolor.ShowDialog()
Me.BackColor = ocolor.Color
End Sub
and it changes the background color of form to the color i select in colordialogue...
now i want to change the BGColor of shockwaveobject in this way...however i can change the BGColor of shockwave object manually in toolbox but i want to change it by color dialogue how can i do that...
I am using ASP.NET C# with mySql database. What is the best way for implementation of login system like Membership and Role. Membership and Role dont work with mySql database.
I have set up my website to use ASP.NET Membership. it all works fine when trying to use it on my development machine but when I put it on the web server and try to log in, I get this error :
"Failed to update database "C:\INETPUB\WWWROOT\APP_DATA\ASPNETDB.MDF" because the database is read-only. "
i have an input form which connected to database...
after that i want to make a form to show all data which have been input to database..and this data will show in table and also i can sort the data by name or by date...
please help me...
Hello,
i got this situation:
- class user with hasMany Roles and belongsTo Roles
- class Role with hasMans User
how can i get the roles belongs to a user, object user is given,
how can i get objects in a many-to-many szanario?
findByX doesn't work, it's affect just one table, but i need a "find" or something else to find Object overall / over many tables.
can anyone help me? and excuse my no propper english^^
I'm trying to build a visio addin that allows me to get a list of tables when a database reverse engineer is run.
I'm using the Microsoft.Office.Interop.Visio library.
I can find a list of shapes on the page, but this gives me every single shape on the page and every single piece of text. i would like to have a list of just the database tables (their physical names) in the document.
I have a database which users should not be able to alter data in unless they use the specific app. I know best practice is to use windows authentication however that would mean that users could then connect to the database using any other data enabled app and change values which would then not be audited.
Unfortunately SQL 2008 with its inbuilt auditing is not available.
Any ideas how to ensure that users cannot change anything unless its through the controlling app?
Is there a way in objective-c/Cocoa to alloc an object when the class name isn't know until run-time. I seem to remember something about this a while ago, but can't find anything on it now.
Something like:
[[@"MyClass" alloc] init];
I seem to recall a function that would return some kind of class id based on a string that can then be used to alloc the object.
I have a MySQL database on my server and I"m pretty sure it's an int over flow on one table with an auto_increment field that's crashing it.
I can delete the table, it's not very important, but I can't get into the server.
Is there anyway to delete that database from the file system or without logging into MySQL?
HELP! THE WORLD IS ENDING!
Hi,
I have been told, roumerred, but can't find any documented evidence that it will invalidates your support contract with Microsoft Dynamics CRM 4.0 if you modify the database by scripting data into the database manually using TSQL.
Can anyone help with a link or confirmation that this is true.
Thanks in Advance
Iain
Hi all,
I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p?
The db is on sql 2005.
Any help would be great.
Is there a simple method for copying a database diagram from one database server to another?
I have a diagram on a development server that needs to be moved to the production server.
Thanks
(Sql server 2005, SSMS2005 Express)
I'm trying to implement a singleton class, that holds a com object inside it. Class implements IDisposable interface, but when I try to implement a finalization method, I get an exception of access to com object from another thread.
This happens because clr uses a different thread when finalizes objects.
Is there any way to implement such a thing or maybe I just doing something wrong?
I installed a MongoDB database on my server. My server is in 32Bit and I can't change it soon.
When you use MongoDB in a 32Bit architecture you have a limit of 2,5Go of data, as mentionned in this MongoDB blog post.
The thing is that I have several database. So how can I know if I am close or not to this limit ?
Hi I need to backup MySQL database and then deploy it on another MySQL server.
The problem is, I need it backup without data , just script which creates database, tables, procedures, users, resets autoincrements etc. ...
I tried MySQL administrator tool (Windows) and UNchecked "complete inserts check box", but it still created it ...
Thanks in advance