Loading Driver automatically

[faisal hameed]

I am using sql DataBase.I create connection using the following code.How can i load driver automatically without makin DSN in DataSources(ODBC).And how can i use my table in my Project Folder instead of in Sql folder, where i install sql server.

   
    static Connection con = null;
    static Statement st = null;

    public static void createConnection() {
        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String conURL = "jdbc:odbc:DBServlet";  //DBServlet is my DSN name
            String loginName = "mitf08m023";
            String pwd = "123";
            con = DriverManager.getConnection(conURL, loginName, pwd);
            System.out.println("Connection Open ");
            st = con.createStatement();
            System.out.println("Statement Created ");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 

[Ashwin Bangar]

Hello Faisal,
You are using Type-1 Driver for JDBC connection, instead of that try to use thin driver i.e. Type-3 driver. in that you have to specify the "vendor related url".
One more thing is that you are using sql, what does that mean, MS-Sql server or MySql or Oracle or something else...
so depending on the Sql you are using you have to specify the url in
String conURL = "jdbc:Odbc:dBServlet";