Answer / devarathnam c,kotagudibanda(po

Hi...You can use one separate query for that purpose
i.e String query ="select count(*) from emp";
It will give u total no.of records in ResultSet.

Answer / balakrishna

Using ResultSet MetaData class

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 main steps in java to make JDBC connectivity?

0 Answers   UGC Corporation,

---

What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?

0 Answers  

---

Give an example for execution of sql statement.

0 Answers  

---

What is database null and Java null?

1 Answers  

---

what happens if connection is not closed?

7 Answers   CTS,

---

What is @entity in java?

0 Answers  

---

List the common jdbc exceptions ?

0 Answers  

---

what does batchUpdate does?

6 Answers   HCL,

---

Under what circumstances, that all four drivers are used?

0 Answers   TCS,

---

Why “no suitable driver” error occurs?

0 Answers  

---

What is hbm xml?

0 Answers  

---