[jBoss-User] Oracle pool

[Darius Davidavicius]

Hello,

I trying to create oracle connection pool and i have some problems.
I would be happy for any sugestions:

I use WindowsNt4 SP6; jBoss 2.0 BETA-PROD-02; Oracle 8.1.6.0.0

in the directory %JBOSS_HOME%\lib\ext i copyed all files from %ORA8_HOME%\jdbc\lib
there are list all these files: classes111.zip; classes12.zip; jndi.zip; jta.zip;nls_charset11.zip; nls_charset12.zip

in JBoss.properties i put:
jdbc.drivers=oracle.jdbc.driver.OracleDriver

in the jboss.conf i put:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="OraclePool">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>

in the jboss.jcml i can found:
<mbean name="DefaultDomain:service=XADataSource,name=OraclePool">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:oci8:@DARIUS:1521:instance</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">DDD</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">x1234567</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">false</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 i starting JBoss server i see such logs:

[Console logging] Logging started
[File logging] Logging started
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
[Info] System: Windows NT 4.0,x86
[JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:jdbc.idbDriver
[Webserver] Initializing
[Webserver] Initialized
.
.
.
[Transaction manager] Starting
[Transaction manager] Started
[XADataSource] Starting
[XADataSource] XA Connection pool Hypersonic bound to Hypersonic
[XADataSource] Started
[XADataSource] Starting
[XADataSource] XA Connection pool OraclePool bound to OraclePool
[Default] Error starting service 'DefaultDomain:name=OraclePool,service=XADataSo
urce': javax.management.RuntimeErrorException: Error thrown in operation start
[Container factory] Starting
[Container factory] Started
.
.
.
[Default] 20 services and 4 other MBeans started.
[Default] Shutdown hook added
[Default] jBoss 2.0 BETA-PROD-02 Started


Thanks in advance,
Darius Davidavicius