Hi, I have a DataGridView connected to a Database. It is filled like this: Me.KeywordsTableAdapter.Fill(Me.DbDataSet1.keywords) I can see all the data inside DataGridView. Now I can select something and if I press on DELETE (Keyboard) the entries are gone (AllowUserToDeleteRows = true), but they are still in the Database (mdb file) ...
Hi, I am using PostgreSQL 8.4. I really like the new unnest() and array_agg() features; it is about time they realize the dynamic processing potential of their Arrays! Anyway, I am working on web server back ends that uses long Arrays a lot. Their will be two successive processes which will each occur on a different physical machine. E...
Hi all, I am trying to make a cocoa application which will have form like fields and will be used to store and retrieve values from table in MySql database at some local linux server. I want to know that is there any connectivity tool in cocoa which I can use or I have to design API for it?? Thanks, Miraaj ...
Hi whats the difference between the database connection made from a stand alone code and that made from a web application deployed in sun java web server. The code used to connect to the database, when run as separately the db connection is successful. But the same code inside my web application when deployed is not able to make the ...
I am using pylot to stress test a web app I created. The test simulates 100 users logging in the app and the test lasts 200 secs. On average, approx. 4800 requests are made to the server and same number of connections to MySql, each of which executes 5 queries so we are talking about 24K queries during the test. The queries are simple a...
SQL Server books online states the following about visibility (scope?) of temporary tables: Temporary Tables You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions. I want to understand how the scope of the global...
I have a problem in the connection between db2 and birt. I found an answer that said: This may have nothing to do with BIRT specifically. Perhaps your query to retrieve the data. Have you tried using the jdbc driver stand alone in a simple Java program to try and retrieve the data? This may be easier to debug (as you can...
I have a SQL Server 2008 on a server which goes out on the internet through a domain name computer.example.com, I want to develop a .net app on my PC and to connect to that database through SSMS - to create tables and so on... And I still want a connection string which can be accessed from anywhere - I'm thinking at a http ...
Is it possible to access the Data Connection added to the project in the code? I know that it is possible to access DataSets created using visual designer but I would like to access the connection only. Edit: It is possible to add Data Connection to the project in VS2008 via Tools > Connect to Database. I would like to access this co...
Hi, I'm using Linq to SQL and read in a blog post about closing database connections as soon as possible. As an example, they showed a variable being converted to a list (using .ToList()) instead of actually returning the Linq query. I have the below code: public static bool HasPassword(string userId) { ProjDataContext db = new...
Traditionally when using a DbCommand when retrieving data from a sproc, something like the following is good practice: DbCommand cmdDbCommand... dbGetData = DatabaseFactory.CreateDatabase("MyDatabase"); cmdDbCommand = dbGetData.GetStoredProcCommand("MySproc"); . . . try { ... } catch (System.Exception ex) { if (cmdDbCommandcmdDbComm...
Hi, I'm testing database programming in vb.NET 2008 at the moment and try to find a way to use a database connection in different forms, so e.g. I put the the database-connection-component into one of the forms. I know, I could access it by e.g. form1.databaseconnection.xxx, but is this the best way or can I "put" the connection into ...
Is there a way to display database open dialog from SQL server in my .NET application (the same way I can display a file open dialog, or font dialog) ? ...
Database i am using is MySQL 5.1. I specified, i believe, right connectionstring in my web.config. but when i run my web app. it throws this exception:- MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('root'@'%') does not exist Any help. Why am i getting this? ...
After periods of inactivity on my website (Using Spring 2.5 and MySql), I get the following error: org.springframework.dao.RecoverableDataAccessException: The last packet sent successfully to the server was 52,847,830 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/...
Is there a way to check if a database connection is open? I am trying to check the connectionState but it shows ConnectionState as Open even when database is down. private bool IsValidConnection(IDbConnection connection) { return (connection != null && connection.State == ConnectionState.Open); } ...
Hello, Should I initialize the database cursor once per each Apache thread, or should I initialize one in every function available to HTTP clients? What happens when the client terminates the connection (i.e. user closes the browser tab)? Does the server-side function that was processing the request continue normally until it returns, ...
I have a singleton db connection which I get with: $dbConnect = myDatabase::getInstance(); which is easy enough. My question is what is the least rhetorical and legitimate way of using this connection in functions and classes? It seems silly to have to declare the variable global, pass it into every single function, and/or recrea...
I am trying to get Weblogic 9.2.3 to talk to a legacy RedBrick database and am having trouble. I have the redbrick.jar file from the software installation and have added to my APP_RUNTIME_CLASSPATH and my MANIFEST_CLASSPATH. This is my jConnect template line: <url>jdbc:rbw:protocol:${DB_LT_SERVER}:${DB_LT_PORT}/${DB_LT_NAME}</url> <dr...
I've been trying to get a c3p0 db connection pool configured for Jetty, but I keep getting a ClassNotFoundException: 2010-03-14 19:32:12.028:WARN::Failed startup of context WebAppContext@fccada@fccada/phpMyAdmin,file:/usr/local/jetty/webapps/phpMyAdmin/,file:/usr/local/jetty/webapps/phpMyAdmin/ java.lang.ClassNotFoundException: org.mort...