Very Computer

by **Luca** » Wed, 02 Oct 2002 23:40:36

Hello, does anyone knows how to run the following program? I try to
pass arguments into it but I get the following error,
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at data.main(Data.java:30)

The program is as below:

import java.net.URL;
import java.sql.*;

class data {
public static void main(String argv[]) {
if (argv.length == 0) {
System.err.println("Usage");
System.err.println("");
System.err.println("java jdbc_connect URL");
System.exit(1);

Quote:}

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = argv[0];

String user, pwd;
if (argv.length > 1) {
user = argv[1];

Quote:} else {
user = "";
}

if (argv.length > 2) {
pwd = argv[2];

Quote:} else {
pwd = "";
}

Connection con = DriverManager.getConnection(url, user, pwd);
con.close();
System.out.println("Connection successfully.");

Quote:}

catch( Exception e ) {
System.out.println(e.getMessage());
e.printStackTrace();

Quote:}
}
}

Thank you in advance.

Regards,
Lucas

by **Linda Radeck** » Thu, 03 Oct 2002 00:11:10

> Hello, does anyone knows how to run the following program? I try to
> pass arguments into it but I get the following error,
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(DriverManager.java:532)
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
> at data.main(Data.java:30)

> The program is as below:

[Your program]

What have you passed in as argument? Anyway, you'll need
to pass the DSN, e.g like jdbc:odbc:<datasourceYouReferTo>
when you run it. Hope this helps

Linda
--

/

by **Luca** » Thu, 03 Oct 2002 23:46:00

> > Hello, does anyone knows how to run the following program? I try to
> > pass arguments into it but I get the following error,
> > java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(DriverManager.java:532)
> > at java.sql.DriverManager.getConnection(DriverManager.java:171)
> > at data.main(Data.java:30)

> > The program is as below:

> [Your program]

> What have you passed in as argument? Anyway, you'll need
> to pass the DSN, e.g like jdbc:odbc:<datasourceYouReferTo>
> when you run it. Hope this helps

> Linda

Hi Linda,
Thank you very much for your help. It works.

Regards,
Lucas

Very Computer

Java Database Program

Java Database Program

Java Database Program

Java Database Program