Hi fellow programmers.
Couple of weeks ago i had problems configuring interbase.
I havent done an extensive testing but this configuration seems to work:
1- More information on the mapping can be found at:
http://www.inprise.com/devsupport/appserver/faq/CMP_Data_Access.html
And a overall information on this database at:
http://www.inprise.com/devsupport/appserver/faq/
2- from the mailing list i found:
define datasource in jboss.conf (as above)
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,interclient.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String"
VALUE="jdbc:interbase://localhost/e:/dev/db.gdb">
<ARG TYPE="java.lang.String" VALUE="Interbase">
<ARG TYPE="java.lang.String" VALUE="interbase.interclient.Driver">
<ARG TYPE="java.lang.String" VALUE="sysdba">
<ARG TYPE="java.lang.String" VALUE="masterkey">
</MLET>
add a resource ref in ejb-jar.xml
<resource-ref>
<description />
<res-ref-name>jdbc/interbase</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and tie it to the pool in jboss.xml
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>jdbc/interbase</res-name>
<jndi-name>Interbase</jndi-name>
</resource-manager>
</resource-managers>
your code will refer to this as "java:comp/env/jdbc/interbase"
And most important:
when configuring the database : USE the Database dialect 1 for the tables.
Hope this going to help
henry voyer
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
