Unable to connect MS SQL server via Java Class

Question

I am getting error when I try to connect database

Error:com.microsoft.sqlserver.jdbc.SQLServerConnection cannot be cast to
Ptakip.Connection

Ptakip is my Package

Connection is my Class

Here is the Connection Class Code ;

 import java.sql.*;

public class Connection {
private Connection cn;

public Connection connector( )
{


try {

    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
     Connection  cn =  (Connection)     
  DriverManager.getConnection("jdbc:sqlserver://localhost\\MyServer:     
  1433;databaseName=TEST;user=Glassfish;password=pass;");

    System.out.println("connected");
  }

   catch(Exception ex) {

   System.out.println("Error:" +  ex.getMessage());
   System.out.println(cn);

  }
    return cn;

   }

 }

score 0 · Accepted Answer · answered Apr 10 '14 at 12:52

0

your class has the same name as the class in the package java.sql that's why u have this conflict ,juste try to change the name to Connexion ,it should work

answered Apr 10 '14 at 12:52

foboss

430
4
14

Or just cast with the full class Name: `Connection cn = (java.sql.Connection) DriverManager.getConnection(...)` – Pablo Lozano Apr 10 '14 at 13:11
Thanks Pablo , it was my mistake which I did , I am connected now. Thanks very Much – user3498019 Apr 10 '14 at 14:04

score 0 · Answer 2 · answered Apr 10 '14 at 13:06

0

Try to make a connection like this. it may help you

String url = "jdbc:mysql://localhost:3306/"; 
String dbName = "demo” 
String driver = "com.mysql.jdbc.Driver"; 
String userName = "root"; 
String password = "mypasswd"; 
try { 
Class.forName(driver).newInstance();
 Connection conn = DriverManager.getConnection(url+dbName,userName,password);
 conn.close(); 
}catch (Exception e) { 
e.printStackTrace(); 
} 
} 
}

answered Apr 10 '14 at 13:06

SAURABH_12

2,262
1
19
19

Thansk Saurab your way is ok , my mistake was using the same class names – user3498019 Apr 10 '14 at 19:34

Unable to connect MS SQL server via Java Class

2 Answers2