Hello all,
If anyone had this problem please help! I have to use connection pool in
jboss in order to use Transactions(is that right?). I am using Java
context.lookup to locate my connection pool(java:/MySQLDB) and i get the
error of the poolname not beeing bound although when i start up jboss it
says "[MySQLDB] XA Connection pool MySQLDB bound to java:/MySQLDB".
I am using mySQL database.
here is what i did:
in jboss.properties i added:
jdbc.drivers=org.gjt.mm.mysql.Driver,oracle.jdbc.driver.OracleDriver
in jaws file i added:
<jaws>
<datasource>MySQLDB</datasource>
<type-mapping>mySQL</type-mapping>
</jaws>
in jboss.conf i added:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="MySQLDB">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
in jboss.jcml i added (notice that PoolName is missing. for some reason
although i add poolname as an attribute it will be deleted when i start up
jboss):
<server>
<mbean name="DefaultDomain:service=XADataSource,name=MySQLDB">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser" />
<attribute name="MaxSize">0</attribute>
<attribute name="Password" />
<attribute name="URL">jdbc:mysql://localhost/CogeniaDB</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>
<attribute name="Properties"></attribute>
</mbean>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
