Is oracle client required for jdbc connection?
No Answer is Posted For this Question
Be the First to Post Answer
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
Name the new features added in jdbc 4.0.
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What is represented by the connection object?
Is jdbc part of j2ee?
all Java qts are imp ?
What are the advantages of using preparedstatement in java?
Explain the locking system in jdbc?
What are the different classes through which JDBC represents statements?
What is the difference between ojdbc6 and ojdbc7?
How can you make the connection using jdbc?
Describe odbc?