|
who could tell me how the jboss.jcml should be like if i want
to use 2 jdbc:odbc datasource in jboss?
how will the mbean look like?
The 2 datasource use the same database driver: jdbc:odbc
suggest there is 2 entitybean .each one presents a table in its
datasource.
entitybeanA : jdbc:odbc:test1 ,tablename:
testtable1
entitybeanB: jdbc:odbc:test2 ,tablename:
testtable2
i had thought the following code will be ok:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=JetEngineDB"> <attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute
name="PoolName">InterBaseDS</attribute> <attribute
name="URL">jdbc:odbc:ejbdatasouce11</attribute>
<attribute name="JDBCUser"></attribute> <attribute
name="Password"></attribute> </mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=JetEngineDB"> <attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute
name="PoolName">InterBaseDS</attribute> <attribute
name="URL">jdbc:odbc:ejbdatasouce22</attribute>
<attribute name="JDBCUser"></attribute> <attribute
name="Password"></attribute> </mbean>
but however it doesn't work.
how can i configure the jbss.jcml file .
thx in advance
|