From: | Nithin Chakravarthi <nithin(at)embdestech(dot)co(dot)in> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Error:java.lang.ClassNotFoundException: org.postgresql.Driver |
Date: | 2016-03-29 11:04:32 |
Message-ID: | CAE3Q90zo6SngbxbKOVa+tvtot21ioYWd3N_YCz_S+FN9ZZC8ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi All,
I am working on java project to insert and fetch data from postgresql
database. While using jbdc I am getting error
"
*java.lang.ClassNotFoundException: org.postgresql.Driver at
java.net.URLClassLoader.findClass(URLClassLoader.java:381) at
java.lang.ClassLoader.loadClass(ClassLoader.java:424) at
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) at
java.lang.ClassLoader.loadClass(ClassLoader.java:357) at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:264) at
SqlConnection.sql_connection(SqlConnection.java:29) at
ServerConnection.run(ServerConnection.java:205) at
java.lang.Thread.run(Thread.java:745)"*
FYI I am using multiple source files. Main function is defined in one file
and I am using postgresql connection in another file
Here is my src
*"private static final String DB_URL =
"jdbc:postgresql://127.0.0.1:5432/testdb
<http://127.0.0.1:5432/testdb>"; public int sql_connection(String
outletid, String messageid, String checkid,int msgarry,String
message,PrintStream os) { String []lines =
message.split("\\?"); String [] separated =
lines[0].split("\\|"); //for(int
i=0;i<4;i++)
//System.out.println("received msg from client
:"+separated[i]); msgformation pack = new
msgformation(); System.out.println("sizes---: "
+separated.length+" ---Arry Received: "+ msgarry);
if(separated.length==msgarry){
try{ System.out.println("Connecting
to database..."); Properties
password = new Properties();
password.put("user","postgress");
password.put("password","postgress");
password.put("host","localhost");
Class.forName("org.postgresql.Driver");
//DriverManager.register(org.postgresql.Driver());
ServerMain.conn = DriverManager.getConnection(DB_URL,password);"*
I have exported class path as
*"export CLASSPATH=./Server.jar:~/Downloads/postgresql-9.3-1103.jdbc3.jar"*
Server.jar is main executable file.
So please help me to solve this issue.
Thanks & Regards,
*M. Nithin Chakravrthi*
Software Engineer
*EmbDes Technologies Pvt Ltd*
#124,2nd Floor,Hosur Main Road, Madiwala,| Bangalore-68 | Karnataka, India
Tel: 080-25537562 | Mob: +91-8050597236
*Website <http://www.embdestech.co.in/> | Email
<nithin(at)embdestech(dot)co(dot)in> | Map
<https://www.google.com/maps/place/EmbDes+Technologies/@12.9198502,77.6193159,17z/data=!3m1!4b1!4m2!3m1!1s0x3bae16a453b13761:0xce1f1676aabdc528?hl=en>*
From | Date | Subject | |
---|---|---|---|
Next Message | Álvaro Hernández Tortosa | 2016-03-29 11:13:19 | Re: Error:java.lang.ClassNotFoundException: org.postgresql.Driver |
Previous Message | Pavel Raiskup | 2016-03-22 13:20:12 | Re: Complicated re-distribution of pgjdbc the "open source way" |