Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

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

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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>
-----------------------------------------------
 
Sheriff
Posts: 10445
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator

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.
 
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
 
Mark Spritzler
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator

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
    Bookmark Topic Watch Topic
  • New Topic