Hi Torsten!
I won't answer your question, sorry. But I would like to warn you, that
we had some major problems with the supplied JDBC driver for Interbase.
It behaved _different_ than the console and did not understand all the
needed syntax ! Also you have to be very careful with Interbase with
such names like "User" or "Password" (keywords) for tables or fields.
Interbase seems not be able to detect, when this is a keyword and when a
name.
Just my $.02
Tobias
Torsten Terp wrote:
>
> Hi,
>
> I have configured jboss to use interbase as a datasource like it is
> described in
> the prelimanary jBoss 2.0 manual. When I start jboss i get the following
> error:
>
> [Default] Error starting service
> 'DefaultDomain:name=InterBaseDB,service=XADataSource':
> javax.management.RuntimeErrorException: Error thrown in operation start
>
> From jboss.properties:
>
> jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,interb
> ase.interclient.Driver
>
> From jboss.conf:
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,
> interclient-core.jar" CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="InterBaseDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> From jboss.jcml:
>
> <mbean name="DefaultDomain:service=XADataSource,name=InterBaseDB">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:interbase://localhost/e:/emp.gdb</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">SYSDBA</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">masterkey</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
>
> When starting the driver loads fine:
>
> ...
> Classpath extension] Initialized
> JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> JDBC] Loaded JDBC-driver:interbase.interclient.Driver
> Webserver] Initializing
> Webserver] Initialized
> ...
>
> But when InterBase should start this happens:
>
> [InterBaseDB] Starting
> [InterBaseDB] XA Connection pool InterBaseDB bound to java:/InterBaseDB
> [Default] Error starting service
> 'DefaultDomain:name=InterBaseDB,service=XADataSource':
> javax.management.RuntimeErrorException: Error thrown in operation start
>
> Does anybody know whats wrong???????
>
> Thanks in advance...
>
> ^terp
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]