Does multiple concurrent open statements per connection are
supported by the JDBC-ODBC Bridge?
Answers were Sorted based on User's Feedback
Answer / alladi sudhir
No JDBC-ODBC Bridge Driver supports only one Statement at
a time.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / rds
Yes. However theoritically the answer is "NO". Per
Connection there is only one Statement object is allowed.
However, i have tried using 2 statement, i did not find any
exception thorwn, in JDK 1.4(I am using).
Is This Answer Correct ? | 2 Yes | 1 No |
What is encrypted connection?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What is getconnection method in java?
What is the use of getGeneratedKeys() method in Statement?
Explain about column name and getter method?
What is an odbc driver?
How do I find whether a parameter exists in the request object?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
Diff bet.. Function and Trigger?
What is JDBC Savepoint? How to use it?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }
Where is jdbc url mysql?