How is database middleware used to access legacy databases?
Answer / guest
Database middleware enables legacy databases to be accessed
from Java by translating between JDBC and the drivers that are
supported by the legacy databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
Give steps to connect to the db using jdbc?
Why is jdbc used?
how to retrieve sql exceptions
What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver?
What are the flow statements of jdbc?
Is there any limitation for no of statments executed with in batchupdate?
How many ways can you update a result set?
What is database deadlock ?
Write a program JDBCcode forfetching student database with SQL.
Can we use the one instance of Statment to execute more than one query ?
RowSetInternal caller and returns void. What can I do in the readData method?
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"); } } }