You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Upayavira <uv...@upaya.co.uk> on 2003/02/19 01:36:16 UTC
Firebird with Cocoon
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 a connection string of the sort:
jdbc:firebirdsql://localhost:3050//c:/desktop/database.gdb
A connection test from IBConsole tells me that I'm using "WI-V6.2.794 Firebird
1.0".
Any pointers?
Thanks,
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: AW: Firebird with Cocoon
Posted by Upayavira <uv...@upaya.co.uk>.
> 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: log\test.log (The system cannot find the path
specified)
after some time ago having put the log4j jar into the lib folder. Any idea where it is
looking for the log\test.log file? Then it might be able to tell me more about what it
is doing.
Thanks for all of your help.
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: AW: Firebird with Cocoon
Posted by Upayavira <uv...@upaya.co.uk>.
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
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: AW: Firebird with Cocoon
Posted by Brian Johnson <jo...@yahoo.com>.
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 1.3). Suddenly
> everything was fine...
>
> Bye, Nils
>
>
> -----Ursprungliche Nachricht-----
> Von: Upayavira [mailto:uv@upaya.co.uk]
> Gesendet: Mittwoch, 19. Februar 2003 15:06
> An: Brian Johnson; cocoon-users@xml.apache.org
> Betreff: Re: Firebird with Cocoon
>
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
AW: Firebird with Cocoon
Posted by Nils Le?mann <ni...@students.uni-mannheim.de>.
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:uv@upaya.co.uk]
Gesendet: Mittwoch, 19. Februar 2003 15:06
An: Brian Johnson; cocoon-users@xml.apache.org
Betreff: Re: Firebird with Cocoon
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Firebird with Cocoon
Posted by Brian Johnson <jo...@yahoo.com>.
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Firebird with Cocoon
Posted by Upayavira <uv...@upaya.co.uk>.
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Firebird with Cocoon
Posted by Brian Johnson <jo...@yahoo.com>.
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
On Tuesday, February 18, 2003, at 07:36 PM, Upayavira wrote:
> 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 a connection string of the sort:
>
> jdbc:firebirdsql://localhost:3050//c:/desktop/database.gdb
>
> A connection test from IBConsole tells me that I'm using "WI-V6.2.794
> Firebird
> 1.0".
>
> Any pointers?
>
> Thanks,
>
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>