Re: Firebird with Cocoon

[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, and it causes an error. I submitted a patch a long time ago, but nobody seemed to pay any attention to it. I can forward it to you if you get the connection working. Are there any other errors related to the driver in the cocoon log? Maybe in the core or error log files?
Brian

On Wednesday, February 19, 2003, at 09:05 AM, Upayavira wrote:

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 (ExecuteSQL)
from Java Examples in a Nutshell, which wouldn't connect. By killing the server
and restarting it, I managed to get that to connect.

However, having done this, it has made no difference to Cocoon, which still gives:

Failed to obtain connection. Made 5 attempts with 5000ms interval

Here's my code from web.xml and cocoon.xconf and the sitemap:

web.xml:
<init-param>
<param-name>load-class</param-name>
<param-value>org.firebirdsql.jdbc.FBDriver</param-value>
</init-param>

cocoon.xconf:
<jdbc logger="core.datasources.FGETimetables" name="FGETimetables">
<pool-controller min="5" max="10"/>
<dburl>jdbc:firebirdsql://localhost/c:\\desktop\\DATABASE.GDB</dburl>
<user>XXX</user>
<password>YYY</password>
</jdbc>

sitemap.xmap:
<map:match pattern="sql">
<map:generate src="xml/sql.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="FGETimetables"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>

Any further hints would be greatly appreciated.

Regards, Upayavira

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>