JDBC Connectivity..
От | Minal |
---|---|
Тема | JDBC Connectivity.. |
Дата | |
Msg-id | 42B661F6.4040009@yes2etl.com обсуждение исходный текст |
Ответы |
Re: JDBC Connectivity..
Re: JDBC Connectivity.. |
Список | pgsql-jdbc |
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... 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??
В списке pgsql-jdbc по дате отправления: