did you verify, whether you can access firebird with any other JDBC application, e.g. DBVisualiser, because I could imagine, that it is a problem of the JDBC driver.Von: Alexander Schatten
but if there is not a very good reason for using Firebird, I would not recommend it.
Alex -
thank you very much! Unfortunately I will have to access an existing Firebird database via Cocoon ... you are right, it seems that there are some severe problems with Firebird. And in the mailing list archives I found a couple of notes that do not sound encouraging either, e.g. problems with the SQL transformer. But it seems that others were able to connect Cocoon to the Firebird database and then ran into problems. What bugs me is, why can't I even load the driver class and have Cocoon run? As I said, I'm a cocoon newbie (and don't know much about tomcat, either). But I had no problem establishing and using the Oracle DB connection - so I wonder what I'm doing wrong with Firebird. I'm afraid it must be some silly beginner's mistake.
Usually you had to install Interbase/Firebire , then the Interclient (Server) part of the JDBC driver, and then the client side JDBC driver, though there *should* be a JDBC 4 driver available meanwhile, but I am not sure.
What was the usual problem in our setups was, that the versions of interclient and interbase/firebire had to fit together precisely.
so verify first of all, whether JDBC connection works, check DBVisualizer for that purpose (as an example)
(or maybe better, try to export the data from firebird and import it into PostgreSQL, eventually using ODBC)
alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
