Re: Firebird with Cocoon

2003-02-19 Thread Brian Johnson
there succeeded in connecting Cocoon to a Firebird database? It just times out on me if I use the org.firebirdsql.jdbc.FBDriver driver, or tells me that I am using an unsupported JDBC 2.0 feature if I use the interbase.interclient.Driver driver. I'm using a connection string of the sort

Re: Firebird with Cocoon

2003-02-19 Thread Upayavira
Dear Brian, It may be a problem with your connection string. This is working for me: jdbc:firebirdsql:localhost/3050:/home/firebird/mydatabase.gdb Can you connect with the driver using JDBC outside of Cocoon? Brian This is my first foray into JDBC. I have just tried the JDBC sample

Re: Firebird with Cocoon

2003-02-19 Thread Brian Johnson
Everything looks ok in your config files. It's strange that you had to restart the server... what version of Firebird are you using? Maybe it's a problem with the server?? Also, there is a bug in the SQLTransformer that affects Firebird. The connection gets closed before the data is retrieved,

AW: Firebird with Cocoon

2003-02-19 Thread Nils Le?mann
Hi Upayavira, i've had some problems similary to yours connecting cocoon to firebird. The only solution for me was to switch to java 1.4 (from 1.3). Suddenly everything was fine... Bye, Nils -Ursprungliche Nachricht- Von: Upayavira [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 19

Re: AW: Firebird with Cocoon

2003-02-19 Thread Brian Johnson
That's a good point. I am also using 1.4, and I've never tried it with 1.3. Brian On Wednesday, February 19, 2003, at 10:20 AM, Nils Le?mann wrote: Hi Upayavira, i've had some problems similary to yours connecting cocoon to firebird. The only solution for me was to switch to java 1.4 (from

Re: AW: Firebird with Cocoon

2003-02-19 Thread Upayavira
That's a good point. I am also using 1.4, and I've never tried it with 1.3. Brian Hmmph. Just got Cocoon running with Java 1.4.1_01, and it still does exactly the same thing. It has just started reporting: log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException:

Re: AW: Firebird with Cocoon

2003-02-19 Thread Upayavira
Brian, I've finally got Firebird working, by switching from the SQLTransformer to the ESQL logicsheet. What a relief! Can you send me the patch for the SQLTransformer? I'll see if that's part of it. Thanks for your help. Regards, Upayavira

Re: AW: Firebird with Cocoon

2003-02-19 Thread Brian Johnson
If you want to change it for both, just remove conn.close() and conn = null in the finally block of the Query.exceute() method in the SQLTransformer. conn.close() is called in Query.close() and should not be called in execute(). On Wednesday, February 19, 2003, at 02:43 PM, Upayavira wrote:

Firebird with Cocoon

2003-02-18 Thread Upayavira
Dear All, Has anyone out there succeeded in connecting Cocoon to a Firebird database? It just times out on me if I use the org.firebirdsql.jdbc.FBDriver driver, or tells me that I am using an unsupported JDBC 2.0 feature if I use the interbase.interclient.Driver driver. I'm using