Answer / sathya

Yes,its possible to use the same instance provided the
Result Set of the first Statement is fetchd out.

Answer / sachin

To make batch updates using a single statement with several
sets of input parameters, follow these basic steps:

Disable AutoCommit for the Connection object.
Invoke the prepareStatement method to create a
PreparedStatement object for the SQL statement with input
parameters.
For each set of input parameter values:
Execute setXXX methods to assign values to the input
parameters.
Invoke the addBatch method to add the set of input
parameters to the batch.
Invoke the executeBatch method to execute the statements
with all sets of parameters.
Check for errors. If no errors occurred:
Get the number of rows that were updated by each execution
of the SQL statement from the array that the executeBatch
invocation returns.
Invoke the commit method to commit the changes.

What is meant by connection string?

0 Answers  

---

Why do you use a data source object for a connection?

0 Answers  

---

What is jdbc and jdbc drivers?

0 Answers  

---

How to execute bulk number of queries at once?

3 Answers   Wipro,

---

What is drivermanager in jdbc?

0 Answers  

---

dear 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 Answers  

---

What is jdbc odbc connection?

0 Answers  

---

What do you mean by database connection pooling?

0 Answers  

---

What is Connection Pooling ??? How we set up a particular connection within connection pooling ????

2 Answers   Cognizant,

---

i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?

8 Answers   HSBC,

---

How many isolation levels are supported in JDBC and what are they?

1 Answers  

---

How to check null value in JDBC?

1 Answers   CTS,

---