I am trying to connect to mysql from java web application in eclipse. Connection con = null; try { //DriverManager.registerDriver(new com.开发者_如何学编程mysql.jdbc.Driver());
Is ResultSet Thread safe? My question arises because in my program i have useddifferent statement for each query i have declared a ResultSet as an local variable but it gives me a error of Operation
I just want to make sure that if I use the following, I am opening a separate DB session and not resuing the same o开发者_开发知识库ne (for testing I need individual sessions).
We are using Eclipselink for ORM, but we have a need for some more lightweight database interactions that are more equivalent to JDBC. My question is whether Eclipselink supports such an idiom and whe
Is it safe to do connection.createStatement().executeQuery(String query);, or should each java.sql.Statement object be created and closed by \"hand\" on every use, even if the connection is closed in
I have a spring/jdbc/oracle 10g application. The Oracle server database timezone is set to GMT + 2 JVM timezone is GMT + 2 (even though it doesn\'t matter in my case).
When using JDBC and accessing primitive types via a result set, is there a more elegant way to deal with the null/0 than the following:
How can I programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC?
I want to get to the value I am finding using the COUNT command of SQL. Normally I enter the column name I want to access into the getInt() getString() method, what do I do in this case when there is
I need to see the query being sent to Oracle from a Java program. In the PostgreSQL JDBC driver, toString() does the job, but the same does not apply to prepared statements from Oracle JDBC implementa