Re: Exception Error - Please help I've tried everything!

Hi Greg,

Here are a couple ideas.

*. You can verify that you have a good jar file by running:
           jar tf postgresql.jar
      - org.postgresql.Driver should be listed in the jar contents.

*. You're launching your app with the wrong command line:
          $ java -cp postgresql.jar PostgresqlClient.class
         Exception in thread "main" java.lang.NoClassDefFoundError:
PostgresqlClient/class

       Use this instead:
              $ java -cp postgresql.jar:. PostgresqlClient
        Exception in thread "main" java.sql.SQLException: No suitable
driver
         at java.sql.DriverManager.getConnection(DriverManager.java:545)
         at java.sql.DriverManager.getConnection(DriverManager.java:171)
         at PostgresqlClient.main(PostgresqlClient.java:15)

Finally - that last error is because you're using an incorrectly
formatted URL.
Set
                String url = "jdbc:postgresql:littleware://localhost:
5432";

$ javac PostgresqlClient.java

I don't have a 'root' user - but this will hopefully get you a little
closer ...

$ java -cp postgresql.jar:. PostgresqlClient
Exception in thread "main" org.postgresql.util.PSQLException: FATAL:
role "root" does not exist
         at
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages
(ConnectionFactoryImpl.java:443)
         at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl
(ConnectionFactoryImpl.java:98)
         at org.postgresql.core.ConnectionFactory.openConnection
(ConnectionFactory.java:65)
         at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>
(AbstractJdbc2Connection.java:116)
         at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>
(AbstractJdbc3Connection.java:30)
         at org.postgresql.jdbc3.Jdbc3Connection.<init>
(Jdbc3Connection.java:24)
         at org.postgresql.Driver.makeConnection(Driver.java:369)
         at org.postgresql.Driver.connect(Driver.java:245)
         at java.sql.DriverManager.getConnection(DriverManager.java:525)
         at java.sql.DriverManager.getConnection(DriverManager.java:171)
         at PostgresqlClient.main(PostgresqlClient.java:15)

On Nov 26, 2006, at 1:48 AM, Greg Peters wrote:

> Hello all,
>
> I'm trying to get the following simple program to run just to
> confirm a connection to the database:
>
> //PostgresqlClient.java
> import java.sql.*;
>
> public class PostgresqlClient{
>     public static void main(String[] arguments)
>         throws ClassNotFoundException, SQLException{
>
>         String driver = "org.postgresql.Driver";
>         String url ="localhost";
>         String user = "root";
>         String pwd = "password";
>
>         Class.forName(driver);
>
>         Connection con = DriverManager.getConnection(url, user, pwd);
>         System.err.println("Connection complete");
>
>         con.close();
>     }
> }
>
>
> I keep getting the folowing errors:
>
> Exception in thread "main" java.lang.ClassNotFoundException:
> org.postgresql.Driver
>         at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
>         at java.security.AccessController.doPrivileged (Native Method)
>         at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>         at sun.misc.Launcher$AppClassLoader.loadClass
> (Launcher.java :268)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
>         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:
> 319)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName (Class.java:164)
>         at PostgresqlClient.main(PostgresqlClient.java:12)
> Java Result: 1
> BUILD SUCCESSFUL (total time: 0 seconds)
>
> I have tried adding the postgresql.jar file to my CLASSPATH, and
> have also tried copying the postgresql.jar file to the same
> directory as the PostgresqlClient.java and PostgresqlClient.class
> directories. I have also tried running the following from the
> command line:
>
> java -classpath postgresql.jar PostgresqlClient.class
>
> I am using jdk1.5.0_09 and have tried using nearly all the
> available postgresql.jar files available.
>
> Any advice would be most appreciated.
>
> Cheers,
>
> Greg Peters....
>
>
>
>
>
>
>