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
- 5321 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
What is the advantage of namedparameterjdbctemplate?
What is the meaning of batch updates?
What is a jdbc url?
Which interface is responsible for transaction management in jdbc?
Which type of driver provides jdbc access via one or more odbc drivers?
What class.forname does, while loading the drivers?
What are temp tables ?
List some new features available in jdbc 4.0?
How many types of JDBC Drivers are present and what are they?
How can I manage special characters when I execute an insert query?
Is jdbc connection secure?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
What is isolation level? How to set it?
How to check jdbc connection in linux?
What is database deadlock ? How can we avoid them?
