Re: [jBoss-User] Oracle pool

[Darius Davidavicius]

I still have problem creating oracle pool.
Now error looks like:

[XADataSource] Starting
[XADataSource] XA Connection pool OraclePool bound to OraclePool
[XADataSource] java.sql.SQLException: Io exception: Connection refused(DESCRIPTI
ON=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))
)
[XADataSource] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
14)
[XADataSource] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
56)

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

classes12.zip is in ClassPath - %JBOSS_HOME%\lib\ext

in my jboss.jcml
<mbean name="DefaultDomain:service=XADataSource,name=OraclePool">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@DARIUS:1521:instance</attribute>
<attribute name="Password">scott</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">tiger</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Blocking">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="TimestampUsed">false</attribute>
</mbean>

Thanks in advance for sugestions
D&D