Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5357 Views
- I also Faced
- E-Mail Answers
Answer Posted / cheemu
Looks like you forgot to mention the database name in your
database URL
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can we execute stored procedures using callablestatement?
What is jdbc stand for?
How can you know about drivers and database information ?
What is jdbc architecture?
What are the types of statements in jdbc?
What is hbm xml?
Explain the locking system in jdbc & its types?
What is isolation level? How to set it?
What happens if connection is not closed in jdbc?
What is the use of dialect?
Explain the locking system in jdbc?
Why would you use setautocommit(false) in jdbc?
Give an example of code used for setting up connection with a driver.
How many types of jdbc drivers are available?
What are the higher level apis under development on top of jdbc currently?
