On a system running jdk-1.3.1-p8, the postgresql.jar file from database/postgresql-jdbc does not contain several classes essential for supporting MetaData functions. Fix: The following patch needs to be added to the port: How-To-Repeat: # cd /usr/ports/database/postgresql-jdbc # make # cd work/postgresql-7.3.2/src/interfaces/jdbc/jars # java -cp postgresql-examples.jar:postgresql.jar examples/metadata Exception in thread "main" java.lang.NoClassDefFoundError: examples/metadata
Oops. The "How-To-Repeat" last line should really read: # java -cp postgresql.jar:postgresql-examples.jar example.metadata jdbc:postgresql:database user password PostgreSQL metdata tester v6.4 rev 1 Exception in thread "main" java.lang.NoClassDefFoundError: org/postgresql/jdbc1/AbstractJdbc1Connection at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:120) at example.metadata.<init>(metadata.java:125) at example.metadata.main(metadata.java:289) Cheers. -- Jonathan Chen <jonc@chen.org.nz> ---------------------------------------------------------------------- Power corrupts, Absolute Power is pretty neat
Adding to audit trail from pending/48619. : Message-Id: <13270000.1046071268@palle.girgensohn.se> : Date: Mon, 24 Feb 2003 08:21:08 +0100 : From: Palle Girgensohn <girgen@pingpong.net> : : Hi Jonathan! : : Thanks, I'll check this ASAP! It seems it should go into the postgresql : distribution as well, not just the FreeBSD port... I'll have a look at it!
State Changed From-To: open->closed Fixed by PR 48878 resolution.