aspose file tools*
The moose likes Object Relational Mapping and the fly likes Problem in putting a dataSource for the Oracle 9i database on JBoss for entity beans Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic
Author

Problem in putting a dataSource for the Oracle 9i database on JBoss for entity beans

Amit Chauhan
Greenhorn

Joined: Jun 26, 2007
Posts: 27
Please can anybody tell me what is the cause of this Error :



13:35:53,484 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.jca:service=XATxCM,name=OracleDS
State: CONFIGURED
I Depend On:
jboss.jca:service=ManagedConnectionPool,name=OracleDS
jboss.jca:service=CachedConnectionManager
jboss:service=TransactionManager
Depends On Me:
jboss.jca:service=DataSourceBinding,name=OracleDS

ObjectName: jboss.jca:service=ManagedConnectionPool,name=OracleDS
State: CONFIGURED
I Depend On:
jboss.jca:service=ManagedConnectionFactory,name=OracleDS
Depends On Me:
jboss.jca:service=XATxCM,name=OracleDS

ObjectName: jboss.jca:service=ManagedConnectionFactory,name=OracleDS
State: CONFIGURED
I Depend On:
jboss.jca:service=RARDeployment,name='jboss-xa-jdbc.rar'
Depends On Me:
jboss.jca:service=ManagedConnectionPool,name=OracleDS

ObjectName: jboss.jca:service=DataSourceBinding,name=OracleDS
State: CONFIGURED
I Depend On:
jboss.jca:service=XATxCM,name=OracleDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=RARDeployment,name='jboss-xa-jdbc.rar'
State: NOTYETINSTALLED
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=OracleDS



******* I have already completed the following steps before starting the Server :


1) copy oracle-ds.xml from jboss/docs/examples/jca to jboss/server/xxx/deploy (edit the client connection and user/pass fields).
2) make sure your persistence.xml file specifies Oracle as the datasource.
3) download ojdbc14.jar and put it in jboss/server/xxx/lib (has Oracle drivers).



My ds.xml file looks like this :
-----------------------------------
<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: oracle-xa-ds.xml,v 1.13 2004/09/15 14:37:40 loubyansky Exp $ -->

<!-- ===================================================================== -->
<!-- ATTENTION: DO NOT FORGET TO SET Pad=true IN transaction-service.xml -->
<!-- ===================================================================== -->

<datasources>
<xa-datasource>
<jndi-name>OracleDS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc racle:thin:@127.0.0.1:1521:XE</xa-datasource-property>
<xa-datasource-property name="User">system</xa-datasource-property>
<xa-datasource-property name="Password">ashu</xa-datasource-property>
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->
<no-tx-separate-pools/>

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</xa-datasource>

<mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
name="jboss.jca:service=OracleXAExceptionFormatter">
<depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
</mbean>

</datasources>
-----------------------------------------------
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10287
    
169

ObjectName: jboss.jca:service=RARDeployment,name='jboss-xa-jdbc.rar'
State: NOTYETINSTALLED


Did you do any other changes to your JBoss setup? Specifically did you delete the jboss-xa-jdbc.rar from the deploy folder? Can you check whether this jboss-xa-jdbc.rar is present in the %JBOSS_HOME%/server/default/deploy folder.


[My Blog] [JavaRanch Journal]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

I am going to move this to the JBoss forum as MBeans not being deployed or dependencies in this case is JBoss specific and not related to ORM.

Thanks

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Originally posted by Mark Spritzler:
I am going to move this to the JBoss forum as MBeans not being deployed or dependencies in this case is JBoss specific and not related to ORM.

Thanks

Mark


Actually, I am going to close this thread as it is the second duplicate he has posted on this topic.

Please refrain from duplicate posting. Posting your question once in the correct forum is all you need.

Mark
 
 
subject: Problem in putting a dataSource for the Oracle 9i database on JBoss for entity beans