Re: JDBC Connectivity..

Hi,

20Jun2005 @ 11:58 Minal thusly spake
> I am noting down the steps..which I performed during installation and
> for using JDBC....
> 1. DO we have to use ./configure with-java ?
> because when I use that I get error that it failed. Is this the reason I
> am not able to eshtablish the connectivity...
> In O'reily book it is mentioned that we have to build the driver...How
> does one do that??
> I have copied the postgresql driver in /usr/local/tomcat/common/lib
> directory..
> also set the class path...restarted the tomcat and used the java file as
> shown below...

java can't find the driver,
what postgresql driver are you using, should be a jar file,
do a listing of the jar file to see if Driver is in there,
'jar -tvf jarfile'

I'm using postgresql-8.0-310.jdbc3.jar

hth,

Luke
>
> 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
>
> Am I going wrong anywhere??
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
............._..
.| .| |.|/.|_ .
.|__.|_|.|\.|_ .
:61 421 276 282: