javax.servlet.UnavailableException: Initializing application data source org.apache.struts.action.DATA_SOURCE

[Anthony Martin]

I'm attempting to use the new Firebird SQL Driver to access my Interbase
database.  I've been using InterClient, which is a Type III driver.
Firebird SQL Driver is Type IV, which is more desirable.

Here's information about the Firebird SQL Driver:
<http://www.xlprueba.com.ar/marce/setup_fb_java.htm>

I was hoping for a drop-in replacement for InterClient, but no such luck.
Here is my struts-config.xml DataSource node:

<data-source key="DataSource.TEST0">
        <set-property property="autoCommit" value="false" />
        <set-property property="description" value="Demo DataBase" />
        <set-property property="driverClass"
value="org.firebirdsql.jdbc.FBDriverr" />
        <set-property property="maxCount" value="8" />
        <set-property property="minCount" value="0" />
        <set-property property="url"
value="jdbc:firebirdsql:localhost/3050:c:/progra~1/trams/database/demodata.g
db" />
        <set-property property="user" value="SYSDBA" />
        <set-property property="password" value="masterkey" />
</data-source>
<data-source key="DataSource.TEST1">
        <set-property property="autoCommit" value="false" />
        <set-property property="description" value="Demo DataBase" />
        <set-property property="driverClass"
value="interbase.interclient.Driver" />
        <set-property property="maxCount" value="8" />
        <set-property property="minCount" value="0" />
        <set-property property="url"
value="jdbc:interbase://localhost/c:/progra~1/trams/database/demodata.gdb"
/>
        <set-property property="user" value="SYSDBA" />
        <set-property property="password" value="masterkey" />
</data-source>

I can use TEST1 just fine.  But the startup phase yields the following stack
trace:

javax.servlet.UnavailableException: Initializing application data source
DataSource.TEST0
        at
org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServ
let.java:850)
        at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:419)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        .
        .
        .

I've already tested the Firebird SQL Driver outside Struts.  They have a
demonstration on their web site, and it does indeed work by itself.  I just
can't embed it here.


Anthony

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