Error:java.lang.ClassNotFoundException: org.postgresql.Driver

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>*

Responses

Browse pgsql-jdbc by date

  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"