What is wrong here

[Angela D'souza]

The following code gives me exception. I have jdk1.3 installed on my computer.

import java.net.URL;
import java.sql.*;
//begin class
public class jdbc_connect
{
   public static void main(String args[])
   {
      if(args.length == 0)
      {
System.out.println("Usage:");
System.out.println("");
System.out.println("java jdbc_connect");
System.exit(1);
      }
      try
      {
Class.forName("textFileDriver");
Class.forName("jdbc.odbc.JdbcodbcDriver");
Class.forName("imaginary.sql.iMsqlDriver:");
String url = args[0];
        String user, pwd;
if(args.length > 1)
{
   user = args[1];
}
else
{
   user = "";
}
if(args.length > 2)
{
   pwd = args[2];
}
else
{
   pwd = "";
}
Connection con = DriverManager.getConnection(url, user, pwd);
con.close();
System.out.println("Connection Successful");
    }
   catch(Exception e)
   {
     System.out.println(e.getMessage());
    }
 }
}

[ Edited by Dave to format code ]
[ April 18, 2002: Message edited by: David O'Meara ]

[Dave Vick]

Angela
What exception does it give you?
Is it a ClassNotFoundException because it cant find the classes 'textFileDriver' and 'imaginary.sql.iMsqlDriver:'. Or does the colon on the end of the second one have something to do wtih it?

[Angela D'souza]

It gives exception ClassNotFoundException with classes 'tectFileDriver'
Thanks
Angela

[Mahesh Mamani]

Hi Angela,
Pls check your classpath again.
You could set the Classpath using the following:
On Unix :
set CLASSPATH=$CLASSPATH;<path>
On Windows:
set classpath=%classspath%:<path>
Hope it helps.

Mahesh

[Angela D'souza]

What should I set in Classpath?
Thanks,
Angela

[Jamie Robertson]

Originally posted by Angela D'souza:
What should I set in Classpath?
Thanks,
Angela

the classpath has the path's to all needed java classes that you use. There should be a classpath entry pointing to sun's java classes ( jdk ), you should have also have an entry to the place where your jdbc drivers reside. If you downloaded your mySQL drivers to c:/jdbc/drivers/<driver_name>.zip then you should have a classpath entry in your autoexec.bat file of 'c:/jdbc/drivers;' which will allow your java programs to find the java classes that your driver uses to implement the JDBC interface.
if you are using sun's jdbc dbc drivers then you will not have to alter your classpath, but you must set up the database as an ODBC datasource before you can connect to it.
Jamie