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 12371After 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 5632Hi 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 6885which scenarios we go for jdbc,and which scenario we go for connection polling and wat r advantages and disadvantages using connection pooling.
TCS,
2 6530dear 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 5357i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?
HSBC,
8 21345
How many ways can you update a result set?
What is hbm xml?
What is the different between ResultSet and RowSet?
Describe odbc?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What is drivermanager in java?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
How to insert and delete a row programmatically? (new feature in JDBC 2.0)
What are the common tasks of JDBC?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
What is the meaning of batch updates?
Is there another way of dealing with the result set that could execute faster?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
How can we disable a constraint ?
What is isolation level? How to set it?