Re: Postgresql-JDBC connectivity

I set the classpath, copied in the lib folder of web-inf. If I try to
run a simple java program shown below:
import java.sql.*;

public class Example1
{
public static void main(String[] argv)
{
System.out.println("Checking if Driver is registerd");
try
{
Class.forName("org.postgresql.Driver");
}
catch(ClassNotFoundException cnfe)
{
System.out.println("Couldn't find the Driver");
cnfe.printStackTrace();
System.exit(1);
}
System.out.println("registered the Driver OK, so lets make a
connection");
Connection c = null;
try
{
c=
DriverManager.getConnection("jdbc:postgresql://localhost/trainneedcorp","postgres","admin");

}
catch(SQLException se)
{
System.out.println("Couldnt connect");
se.printStackTrace();
System.exit(1);
}
if(c != null)
System.out.println("WE CONNECTED");
else
System.out.println("Reaching here is not done");
}
}
I get the following error:

java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at Example1.main(Example1.java:10)

Dave Cramer wrote:

> Hi,
>
> How are you trying to connect, what is the error message,
> specifically which lib directory of jakarta did you copy it into?
>
> Dave
> On 16-Jun-05, at 2:46 AM, Minal wrote:
>
>> Hi...
>> I am novice user of Postgresql8.0.3. I managed to export the
>> database from sql server. We have all our application in JSP. I want
>> to install the org.postgresql.driver..
>> I completed the following steps...
>> 1.Downloaded the jar file from http://jdbc.postgres.org
>> 2. Copied it in the lib folder of Jakarta..
>> 3. Edited the pages to use the Driver..am still not able to connect...
>>
>> Where am I going wrong??
>> Minalac
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>>
>
>