[Kontor-user] Linux-Kontor Install

[<chr...@t-...>]

Hi Ron,

as written in your "Linux-Kontor ( Redhat - Debian / PostgreSQL ) Install
HOWTO" on page 52:

"If your installation is (I want to say this delicately...) SCREWED
(...but I won't) you will probably get something like:
   SQLException (java.sql.SQLException):
And some other messages, along with a trace... If that doesn't help you
resolve your problem, copy it, send it to me or the list,
and we will help you resolve your problem (all assistance subject to the
"jerk" rule stated above)."

I send you now my error-message:

13.09.2004 09:09:53.341 [EXCEPTION] <DBObjectSQLServerScript> :
******************************** EXCEPTION ********************************
 Nesting(Runtime)Exception (de.ios.framework.basic.ServerException):
 Meldung: 'Error during excecution: 'No suitable driver''
 Intern:
 SQLException (java.sql.SQLException):
 Meldung: 'No suitable driver'
 Code: 0
 Status: '08001'


 Trace:
 java.sql.SQLException: No suitable driver
  at java.sql.DriverManager.getConnection(DriverManager.java:103)
  at java.sql.DriverManager.getConnection(DriverManager.java:126)
  at de.ios.framework.db2.TransactionData.getNewConnection(DBTransactionServer.java:1296)
  at de.ios.framework.db2.TransactionData.init(DBTransactionServer.java:737)
  at de.ios.framework.db2.TransactionData.<init>(DBTransactionServer.java:694)
  at de.ios.framework.db2.DBTransactionServer.init(DBTransactionServer.java:587)
  at de.ios.framework.db2.DBObjectSQLServer.init(DBObjectSQLServer.java:1428)
  at de.ios.framework.db2.DBObjectSQLServer.<init>(DBObjectSQLServer.java:1403)
  at de.ios.framework.db2.DBObjectSQLServerScript.main(DBObjectSQLServerScript.java:1346)
***************************************************************************

Because I followed your tipp on page 53:

"Then go to the file "/opt/kontor-13/IoS/kontor/etc/kontor.server" and make
sure you described your "postgresql.jar" file correctly (line 36... notice
the "ql" on postgres...)
kontor.db.db=jdbc:postgresql://[SERVER]:5432/iosdb

But it's as you want :-)

Now I wonder about my postgresql.jar, because your source mentioned on
page 15 (http://www.jens.de/kontor/postgresql.jar) doesn't exist any more
(the whole domain) so I took the jdbc7.0-1.1.jar from
http://jdbc.postgresql.org/download.html for PostgreSQL 7.0.x and JDK1.1.x
and renamed it.

I use Linux-Kontor 13, jdk 1.1.8, swing-1.1.1fcs and PostgreSQL 7.0.3
with SuSE Linux 7.1. The
directories jdbc and swing-1.1.1fcs are in the jdk-dir (/usr/lib/jdk1.1.8)
and symlinked in /usr/lib also.

Thx in advance for help

Christoph Hackstein