Integrating with JBuilder and Interbase is easy, from our config files:
Change standardjaws.xml so that it starts like this:
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>java:/DefaultDS</datasource>
<type-mapping>InterBase</type-mapping>
<debug>true</debug>
<default-entity>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<select-for-update>false</select-for-update>
</default-entity>
And leave the rest unchanged.
Make sure your driver gets loaded (put its jar in lib/ext). Replace the
default datastore in jboss.jcml:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProv
ider">
<attribute name="Drivers">interbase.interclient.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XA
DataSource,name=DefaultDS">
<attribute name="PoolName">DefaultDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADa
taSourceImpl</attribute>
<attribute
name="Properties">user=yourdbuser;password=yourdbpasswd</attribute>
<attribute
name="URL">jdbc:interbase://radon//home/idewe/planning-j2ee.gdb</
attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="JDBCUser" />
<attribute name="Password" />
<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>
Leave the rest unchanged (remove, comment the original default
datastore).
That should do it.
Sven
PS: I think jboss+interbase is a great solution, since they are both
opensource/free. Interbase is a real DB, unlike HyperSonic SQL which is
only good for testing/development.
---
Sven Van Caekenberghe - mailto:[EMAIL PROTECTED]
Beta Nine - software engineering - http://www.beta9.be
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
