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

IMVHO, I completely got rid of issues like this when I started
using Maven (or Gradle or equivalent).

I'd recommend you to do the same (and by the way, use a more modern
version of the driver).

Álvaro

--
Álvaro Hernández Tortosa

-----------
8Kdata

On 29/03/16 13:04, Nithin Chakravarthi wrote:
> 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
> <mailto:nithin(at)embdestech(dot)co(dot)in> |Map
> <https://www.google.com/maps/place/EmbDes+Technologies/@12.9198502,77.6193159,17z/data=%213m1%214b1%214m2%213m1%211s0x3bae16a453b13761:0xce1f1676aabdc528?hl=en>*