#7 woddy jdbc Postgres jdk117

[Christian Engler]

Hi,
am gettig a bit confused now,

kontor-13 always insists on
>Meldung: 'Error during excecution: 'No suitable driver''<
wich seems pretty common.
The actual snapshot does not. But during creatDB.sh
there is a
>SQLException: No Columns reported for table
'CLASSTABLES'"<

for testing purpose I`d prefer 13
using
debian woody
postgresql 72
blackdown 1.1.7_v3
sun's swing-1.1.1fcs
various jdbc drivers :
there is one comming with woddy
/usr/share/java/postgresql-7.2.jar
witch is the same than the actual from the postgres
site (pg72jdbc1.jar)
and it works when
#testing swing/examples/TableExample
#using the snapshot

but kontor-13 says
[SQLINFO..] <de.ios.framework.db2.TransactionData> :
Initialize Connections...
[SQLINFO..] <de.ios.framework.db2.TransactionData> :
Getting internal server-connection...
[SQLINFO..] <de.ios.framework.db2.TransactionData> :
Getting 1 new Connection...
[SQLINFO..] <java.sql.DriverManager> :
DriverManager.getConnection("jdbc:postgresql://localhost:5432/iosdb")
[SQLINFO..] <java.sql.DriverManager> :
DriverManager.initialize: jdbc.drivers =
org.postgresql.Driver
[SQLINFO..] <java.sql.DriverManager> :
DriverManager.Initialize: loading org.postgresql.Driver
[SQLINFO..] <java.sql.DriverManager> :
DriverManager.Initialize: load failed:
java.lang.IllegalArgumentException: org.postgresql.Driver
[SQLINFO..] <java.sql.DriverManager> : JDBC
DriverManager initialized
[SQLINFO..] <java.sql.DriverManager> : getConnection:
no suitable driverPostgresql docu says sth like
put the right JDBC Driver to Classpath
"bin/kontor.server:" JDBC=/opt/java/pg72jdbc1.jar #and
there it really is
put the right URL
"etc/kontor.server"
kontor.db.db=jdbc:postgresql://localhost:5432/iosdb
and load the driver
"etc/kontor.server" jdbc.drivers=org.postgresql.Driver
"etc/kontor.client" jdbc.drivers=org.postgresql.Driver
I eaven tried it without org (can this really work at all)

SUN docu says the 'No suitable driver' either means
wrong URL or wrong driver.
But URL is right: with the swing example I can use my
IP, localhost,hostname ..
"/etc/postgresql/postgresql.conf"
local all
trust
host all 127.0.0.1 255.0.0.0
trust
host all 192.168.1.3 255.255.255.255
trust

and the driver works too. Also using Blackdown.

Strange enough IBM-jdk118 always brings a
"Speicherzugrifsfehler"
with is a kind of a stack Problem (maybe thats a hint)
woddys SUN java runs too.

hope to get a good hint

Christian