Give an example for execution of sql statement.
No Answer is Posted For this Question
Be the First to Post Answer
What are temp tables ?
What is JDBC API and when do we use it?
Give an example for execution of sql statement.
What is database connection pooling? Advantages of using a connection pool?
What is isolation level? How to set it?
i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me
Differentiate between stored procedure and functions?
Different statements in JDBC?
How we say that PreparedStatment is Precompiled? where it will be compiled?
What are the benefits of PreparedStatement over Statement?
What is statement and preparedstatement in java?
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