write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum
3 6630While in CallableStatament using in the oracle my procedure is return no.of columns so in java how can i retrivbe the data and i wnat to view all data which is reetrive from my procedure
ADP,
1277Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.
6 6432I have written a program to connect to database using odbc.Can this Application run on any Platform????
2 2912Give me some example for getting connection from connection pooling in JBoss Server. Is Connection Pool default in Server or we have to create it? Who can create Connection Pool in a Team. How it will be accessed by the developer code?
TCS,
1 3280java.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"); } } }
CTS,
6 19876
What are the benefits of PreparedStatement over Statement?
How can you load the drivers?
What is jdbc odbc bridge?
How can we retrieve the file in the oracle database?
What do you understand by jdbc datasource?
What are the utilities of the callablestatement?
What are the 4 types of jdbc drivers?
Is jdbctemplate thread safe?
What are clob and blob data types in jdbc?
How vendor Naming registry supports JNDI?
What is preparedstatement in jdbc?
What is executequery in java?
What is connection data?
Is jdbc a web technology?
What is use of connection pooling?