Re: Exception Error - Please help I've tried everything! - Mailing list pgsql-jdbc

Hi Greg!

Try "java -cp .;postgresql.jar PostgresqlClient"

On Windows the separator char for the classpath is ; not :. And it works
for me only if the . is the first element of the classpath.

Hope this helps,
Sebastian

Greg Peters wrote:
> OK. This is driving me crazy. I have the postgresql.jar file in the same
> directory. This is my directory listing:
>
>
> C:\Documents and Settings\java\GregScratch\src>dir
> Volume in drive C has no label.
> Volume Serial Number is B468-3FBB
>
> Directory of C:\Documents and Settings\java\GregScratch\src
>
> 27/11/2006  06:25 PM    <DIR>          .
> 27/11/2006  06:25 PM    <DIR>          ..
> 26/11/2006  10:36 PM               726 CheckString.java
> 24/11/2006  11:51 PM               140 helloworldapp.java
> 26/11/2006  05:11 PM           402,906 postgresql.jar
> 27/11/2006  06:25 PM             1,179 PostgresqlClient.class
> 27/11/2006  06:25 PM               545 PostgresqlClient.java
> 26/11/2006  02:49 PM               617 SetPoints.java
> 26/11/2006  01:44 AM               641 VolcanoApplication.java
> 26/11/2006  01:44 AM               432 VolcanoRobot.java
>               8 File(s)        407,186 bytes
>               2 Dir(s)  165,819,129,856 bytes free
>
> C:\Documents and Settings\java\GregScratch\src>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> I tried running:
>
> jar tf postgresql.jar
>
> and got:
>
> C:\Documents and Settings\java\GregScratch\src>jar tf postgresql.jar
> META-INF/
> META-INF/MANIFEST.MF
> org/
> org/postgresql/
> org/postgresql/Driver$1.class
> org/postgresql/Driver$ConnectThread.class
> org/postgresql/Driver.class
> org/postgresql/PGConnection.class
> org/postgresql/PGNotification.class
> org/postgresql/PGRefCursorResultSet.class
> org/postgresql/PGResultSetMetaData.class
> org/postgresql/PGStatement.class
> org/postgresql/core/
> org/postgresql/core/BaseConnection.class
> org/postgresql/core/BaseResultSet.class
> org/postgresql/core/BaseStatement.class
> org/postgresql/core/ConnectionFactory.class
> org/postgresql/core/Encoding.class
> org/postgresql/core/Field.class
> org/postgresql/core/Notification.class
> org/postgresql/core/Oid.class
> org/postgresql/core/PGBindException.class
> org/postgresql/core/PGStream$1.class
> org/postgresql/core/PGStream.class
> org/postgresql/core/ParameterList.class
> org/postgresql/core/ProtocolConnection.class
> org/postgresql/core/Query.class
> org/postgresql/core/QueryExecutor.class
> org/postgresql/core/ResultCursor.class
> org/postgresql/core/ResultHandler.class
> org/postgresql/core/UTF8Encoding.class
> org/postgresql/core/Utils.class
> org/postgresql/core/types/
> org/postgresql/core/types/PGBigDecimal.class
> org/postgresql/core/types/PGBoolean.class
> org/postgresql/core/types/PGByte.class
> org/postgresql/core/types/PGDouble.class
> org/postgresql/core/types/PGFloat.class
> org/postgresql/core/types/PGInteger.class
> org/postgresql/core/types/PGLong.class
> org/postgresql/core/types/PGNumber.class
> org/postgresql/core/types/PGShort.class
> org/postgresql/core/types/PGString.class
> org/postgresql/core/types/PGType.class
> org/postgresql/core/types/PGUnknown.class
> org/postgresql/core/v2/
> org/postgresql/core/v2/ConnectionFactoryImpl$SimpleResultHandler.class
> org/postgresql/core/v2/ConnectionFactoryImpl.class
> org/postgresql/core/v2/FastpathParameterList.class
> org/postgresql/core/v2/ProtocolConnectionImpl.class
> org/postgresql/core/v2/QueryExecutorImpl$1.class
> org/postgresql/core/v2/QueryExecutorImpl$2.class
> org/postgresql/core/v2/QueryExecutorImpl$3.class
> org/postgresql/core/v2/QueryExecutorImpl.class
> org/postgresql/core/v2/SimpleParameterList.class
> org/postgresql/core/v2/V2Query.class
> org/postgresql/core/v3/
> org/postgresql/core/v3/CompositeParameterList.class
> org/postgresql/core/v3/CompositeQuery.class
> org/postgresql/core/v3/ConnectionFactoryImpl$1.class
> org/postgresql/core/v3/ConnectionFactoryImpl$UnsupportedProtocolException.class
>
> org/postgresql/core/v3/ConnectionFactoryImpl.class
> org/postgresql/core/v3/Portal.class
> org/postgresql/core/v3/ProtocolConnectionImpl.class
> org/postgresql/core/v3/QueryExecutorImpl$1.class
> org/postgresql/core/v3/QueryExecutorImpl$2.class
> org/postgresql/core/v3/QueryExecutorImpl$3.class
> org/postgresql/core/v3/QueryExecutorImpl$ErrorTrackingResultHandler.class
> org/postgresql/core/v3/QueryExecutorImpl.class
> org/postgresql/core/v3/SimpleParameterList.class
> org/postgresql/core/v3/SimpleQuery.class
> org/postgresql/core/v3/V3ParameterList.class
> org/postgresql/core/v3/V3Query.class
> org/postgresql/ds/
> org/postgresql/ds/PGConnectionPoolDataSource.class
> org/postgresql/ds/PGPoolingDataSource$1.class
> org/postgresql/ds/PGPoolingDataSource.class
> org/postgresql/ds/PGSimpleDataSource.class
> org/postgresql/ds/common/
> org/postgresql/ds/common/BaseDataSource.class
> org/postgresql/ds/common/PGObjectFactory.class
> org/postgresql/ds/common/PooledConnectionImpl$ConnectionHandler.class
> org/postgresql/ds/common/PooledConnectionImpl$StatementHandler.class
> org/postgresql/ds/common/PooledConnectionImpl.class
> org/postgresql/fastpath/
> org/postgresql/fastpath/Fastpath.class
> org/postgresql/fastpath/FastpathArg.class
> org/postgresql/geometric/
> org/postgresql/geometric/PGbox.class
> org/postgresql/geometric/PGcircle.class
> org/postgresql/geometric/PGline.class
> org/postgresql/geometric/PGlseg.class
> org/postgresql/geometric/PGpath.class
> org/postgresql/geometric/PGpoint.class
> org/postgresql/geometric/PGpolygon.class
> org/postgresql/jdbc2/
> org/postgresql/jdbc2/AbstractJdbc2Array.class
> org/postgresql/jdbc2/AbstractJdbc2Blob.class
> org/postgresql/jdbc2/AbstractJdbc2BlobClob$LOIterator.class
> org/postgresql/jdbc2/AbstractJdbc2BlobClob.class
> org/postgresql/jdbc2/AbstractJdbc2Clob.class
> org/postgresql/jdbc2/AbstractJdbc2Connection$1.class
> org/postgresql/jdbc2/AbstractJdbc2Connection$TransactionCommandHandler.class
>
> org/postgresql/jdbc2/AbstractJdbc2Connection.class
> org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.class
> org/postgresql/jdbc2/AbstractJdbc2ResultSet$CursorResultHandler.class
> org/postgresql/jdbc2/AbstractJdbc2ResultSet$NullObject.class
> org/postgresql/jdbc2/AbstractJdbc2ResultSet$PrimaryKey.class
> org/postgresql/jdbc2/AbstractJdbc2ResultSet.class
> org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.class
> org/postgresql/jdbc2/AbstractJdbc2Statement$BatchResultHandler.class
> org/postgresql/jdbc2/AbstractJdbc2Statement$StatementResultHandler.class
> org/postgresql/jdbc2/AbstractJdbc2Statement.class
> org/postgresql/jdbc2/EscapedFunctions.class
> org/postgresql/jdbc2/ResultWrapper.class
> org/postgresql/jdbc2/TimestampUtils$1.class
> org/postgresql/jdbc2/TimestampUtils$ParsedTimestamp.class
> org/postgresql/jdbc2/TimestampUtils.class
> org/postgresql/jdbc2/TypeInfoCache.class
> org/postgresql/jdbc2/optional/
> org/postgresql/jdbc2/optional/ConnectionPool.class
> org/postgresql/jdbc2/optional/PoolingDataSource.class
> org/postgresql/jdbc2/optional/SimpleDataSource.class
> org/postgresql/jdbc3/
> org/postgresql/jdbc3/AbstractJdbc3Blob.class
> org/postgresql/jdbc3/AbstractJdbc3Clob.class
> org/postgresql/jdbc3/AbstractJdbc3Connection.class
> org/postgresql/jdbc3/AbstractJdbc3DatabaseMetaData.class
> org/postgresql/jdbc3/AbstractJdbc3ResultSet.class
> org/postgresql/jdbc3/AbstractJdbc3Statement.class
> org/postgresql/jdbc3/Jdbc3Array.class
> org/postgresql/jdbc3/Jdbc3Blob.class
> org/postgresql/jdbc3/Jdbc3CallableStatement.class
> org/postgresql/jdbc3/Jdbc3Clob.class
> org/postgresql/jdbc3/Jdbc3Connection.class
> org/postgresql/jdbc3/Jdbc3ConnectionPool.class
> org/postgresql/jdbc3/Jdbc3DatabaseMetaData.class
> org/postgresql/jdbc3/Jdbc3PoolingDataSource.class
> org/postgresql/jdbc3/Jdbc3PreparedStatement.class
> org/postgresql/jdbc3/Jdbc3ResultSet.class
> org/postgresql/jdbc3/Jdbc3ResultSetMetaData.class
> org/postgresql/jdbc3/Jdbc3SimpleDataSource.class
> org/postgresql/jdbc3/Jdbc3Statement.class
> org/postgresql/jdbc3/PSQLParameterMetaData.class
> org/postgresql/jdbc3/PSQLSavepoint.class
> org/postgresql/largeobject/
> org/postgresql/largeobject/BlobInputStream.class
> org/postgresql/largeobject/BlobOutputStream.class
> org/postgresql/largeobject/LargeObject.class
> org/postgresql/largeobject/LargeObjectManager.class
> org/postgresql/ssl/
> org/postgresql/ssl/MakeSSL.class
> org/postgresql/ssl/NonValidatingFactory$NonValidatingTM.class
> org/postgresql/ssl/NonValidatingFactory.class
> org/postgresql/ssl/WrappedFactory.class
> org/postgresql/util/
> org/postgresql/util/Base64.class
> org/postgresql/util/GT.class
> org/postgresql/util/MD5Digest.class
> org/postgresql/util/PGInterval.class
> org/postgresql/util/PGbytea.class
> org/postgresql/util/PGmoney.class
> org/postgresql/util/PGobject.class
> org/postgresql/util/PGtokenizer.class
> org/postgresql/util/PSQLDriverVersion.class
> org/postgresql/util/PSQLException.class
> org/postgresql/util/PSQLState.class
> org/postgresql/util/PSQLWarning.class
> org/postgresql/util/ServerErrorMessage.class
> org/postgresql/util/StreamWrapper.class
> org/postgresql/util/UnixCrypt.class
> org/postgresql/xa/
> org/postgresql/xa/PGXAConnection.class
> org/postgresql/xa/PGXADataSource.class
> org/postgresql/xa/PGXAException.class
> org/postgresql/xa/RecoveredXid.class
> org/postgresql/translation/
> org/postgresql/translation/messages_cs.class
> org/postgresql/translation/messages_de.class
> org/postgresql/translation/messages_es.class
> org/postgresql/translation/messages_fr.class
> org/postgresql/translation/messages_it.class
> org/postgresql/translation/messages_nl.class
> org/postgresql/translation/messages_pl.class
> org/postgresql/translation/messages_pt_BR.class
> org/postgresql/translation/messages_ru.class
> org/postgresql/translation/messages_tr.class
> org/postgresql/translation/messages_zh_CN.class
> org/postgresql/translation/messages_zh_TW.class
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
> This is PostgressqlClient.java as it currently stands:
>
>
> import java.sql.*;
>
> public class PostgresqlClient{
>    public static void main(String[] Arguments)
>        throws ClassNotFoundException, SQLException{
>
>        String driver = "org.postgresql.Driver";
>        String url ="jdbc:postgresql:CSG";
>        String user = "root";
>        String pwd = "password";
>
>        Class.forName(driver);
>
>        Connection con = DriverManager.getConnection(url, user, pwd);
>        System.err.println("Connection complete");
>
>        con.close();
>    }
> }
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
> This is some of the commands I have tried and their results:
>
>
>
> C:\Documents and Settings\java\GregScratch\src>java -cp postgresql.jar:.
> PostgresqlClient.class
> Exception in thread "main" java.lang.NoClassDefFoundError:
> PostgresqlClient/class
>
> C:\Documents and Settings\java\GregScratch\src>java -cp postgresql.jar:.
> PostgresqlClient.class
> Exception in thread "main" java.lang.NoClassDefFoundError:
> PostgresqlClient/class
>
> C:\Documents and Settings\java\GregScratch\src>java -cp postgresql.jar.
> PostgresqlClient.class
> Exception in thread "main" java.lang.NoClassDefFoundError:
> PostgresqlClient/class
>
> C:\Documents and Settings\java\GregScratch\src>java -cp postgresql.jar
> PostgresqlClient.class
> Exception in thread "main" java.lang.NoClassDefFoundError:
> PostgresqlClient/class
>
> C:\Documents and Settings\java\GregScratch\src>java -cp
> postgresql.jarPostgresqlClient
> Exception in thread "main" java.lang.NoClassDefFoundError: PostgresqlClient
>
> C:\Documents and Settings\java\GregScratch\src>java -cp postgresql.jar:.
> PostgresqlClient
> Exception in thread "main" java.lang.NoClassDefFoundError: PostgresqlClient
>
> C:\Documents and Settings\java\GregScratch\src>
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> This is what NB says (and I think I have added the module correctly):
>
> 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)
>
> Any ideas????
>
> I have tried several versions of the postgresql module from the website
> too.
>
> Cheers,
>
> Greg.
>