What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question is when that precompiled statement will be execute or comiple?................
TCS,
6 10462After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse
2 4573Hi to all.. well i want to make a standalone application which can use the concept of connection pooling, constraint is that i have not to use any application server like weblogic etc. Please help me out. Thaks in advance.
3 5683which scenarios we go for jdbc,and which scenario we go for connection polling and wat r advantages and disadvantages using connection pooling.
TCS,
2 5429dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me
2 4433i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?
HSBC,
8 18755
What is jdbc connection interface?
Explain the role of driver in jdbc.
What is the difference between jdbc and jndi?
What are the classes and methods used for sending sql statements to database?
How to connect html page to database using jdbc?
What are the higher level apis under development on top of jdbc currently?
What happens if we don't close the connection in jdbc?
What are the different types of drivers under jdbc?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
What is jdbc vs odbc?
When do we use execute method in java jdbc?
How many packages are available in jdbc api?
What are the different types of interfaces in the api component?
What is encrypted connection?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?