aspose file tools*
The moose likes JBoss/WildFly and the fly likes Oracle connection with JBOSS problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Oracle connection with JBOSS problem." Watch "Oracle connection with JBOSS problem." New topic
Author

Oracle connection with JBOSS problem.

Rohit Kelkar
Ranch Hand

Joined: Sep 16, 2002
Posts: 38
I need to connect my Oracle DB to JBoss.
I have placed the class12.zip in jboss/lib/ext dir. These are the relevant jboss.jcml changes.

<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=KeySequenceDS">
<attribute name="PoolName">KeySequenceDS</attribute>
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="URL">jdbc racle:thin:@localhost:1521:keysequence</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">scott</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">tiger</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>
</mbean>

However I am getting the error
[ERROR,XAConnectionFactory] Can't get an XAConnection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNU
M=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Any help will be great.
Thanks.
Ajith Kallambella
Sheriff

Joined: Mar 17, 2000
Posts: 5782
Moving to JBoss forum...


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Rohit Kelkar
Ranch Hand

Joined: Sep 16, 2002
Posts: 38
Thanks the problem is taken care of.
I was giving the wrong DB name.
 
Consider Paul's rocket mass heater.
 
subject: Oracle connection with JBOSS problem.