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
- 5448 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 retrieve the file in the oracle database?
What are the common JDBC problems that you got and how do you solved them?
What are the common jdbc exceptions?
If I use the JDBC API, do I have to use ODBC underneath?
How do we call a stored procedure from jdbc?
What do you understand by jdbc statements?
What are the types of statements in jdbc?
Is jdbc open source?
Briefly tell about the jdbc architecture.
What does jdbc do?
What is sqlwarning and discuss the procedure of retrieving warnings?
What is odbc and jdbc drivers?
What are the higher level apis under development on top of jdbc currently?
What are collection pools?
What are the methods which can verify the cursor particular position?
