preparedstatement p= new preparedstatement is it possible ?

10 Answers   Fidelity, IBM, Infrasys,

---

There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

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 are the 4 types of jdbc drivers?

0 Answers  

---

Can we return resultset in java?

0 Answers  

---

How do you create Connection?

5 Answers   HCL,

---

What is Apache DBCP API?

0 Answers  

---

Compare jdbc and odbc and how is jdbc required in this context.

0 Answers  

---

How to connect multiple database in jdbc?

0 Answers  

---

What is meant by connection string?

0 Answers  

---

What is metadata in programming?

0 Answers  

---

What is JDBC Connection? Explain steps to get Database connection in a simple java program.

0 Answers  

---