SEO

Hi, i'm new in jdbc and
my problem is, the driver doesn't load,
the code is:

public static void connect(){
try{
Class.forName("org.postgresql.Driver");
}catch(ClassNotFoundException cnfex){
System.err.println("driver load fail");

//the problem is here, i don't know what library i need and what i need to
do with the classpath to this works,
//when compile to bytecode the error message is:
/*
driver load fail
Exception in thread "main" java.lang.NullPointerException
at DB.DBAccess.connect(DBAccess.java:45)
at DB.DBAccess.begin(DBAccess.java:81)
at Simulator.main(Simulator.java:23)
*/
}

String url = "jdbcostgresql://localhost/projeto";
Properties props = new Properties();
props.setProperty("user","postgres");
props.setProperty("password","postgres");

try{
Connection con = DriverManager.getConnection(url, props);
}catch(SQLException sql){}

try{
statement = con.createStatement();
}catch(SQLException sql){}


/*try{
con = DriverManager.getConnection("postgresrojeto:loca lhost",
"postgres", "usuario1");
}
catch(SQLException sql){}
*/

}
If anyone have some idea about it thanks a lot, this is my last chance to
solve this problem,
i have tryed many other forms to solve this, but i still have the problem

--
************************************************** ****
"Ciência da computação está tão relacionada
aos computadores quanto a Astronomia aos
telescópios, Biologia aos microscópios, ou
Química aos tubos de ensaio. A Ciência não
estuda ferramentas. Ela estuda como nós
as utilizamos, e o que descobrimos com elas."
(Edsger W. Dijkstra)
************************************************** *****

Wagner <wagner.and 'at' gmail.com> writes:

> Hi, i'm new in jdbc and
> my problem is, the driver doesn't load,
> the code is:
>
> public static void connect(){
> try{
> Class.forName("org.postgresql.Driver");
> }catch(ClassNotFoundException cnfex){
> System.err.println("driver load fail");
>
> //the problem is here, i don't know what library i need and what i need to
> do with the classpath to this works,

As documented in multiple places, you have to put the
postgresql.jar in your classpath. This depends on your java
environment, but generally you can achieve this by using the
"-cp" argument to the "java" program you invoke.

--
Guillaume Cottenceau

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly