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
- 5349 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 do I check in my code whether a maximum limit of database connections have been reached?
Is jdbc part of j2ee?
What is odbc and jdbc in dbms?
What are the basic exceptions in jdbc?
Is there another way of dealing with the result set that could execute faster?
Give an example for execution of sql statement.
What is jdbc and explain jdbc architecture?
What is JDBC DataSource and what are it’s benefits?
Explain the process of creating tables using NetBeans IDE?
What is statement and preparedstatement in java?
What does the jdbc databasemetadata interface?
What is jdbc servlet?
Explain creation of statement object with connection method create method with help of an example.
How does jdbc connect to database?
How do I set properties for a JDBC driver and where are the properties stored?
