Title: RE: [JBoss-user] Multiple Datasources oracle

I think it may be having a problem with the extra / after the Oracle in the other data source try using jdbc/OracleBA instead.

Paul

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen White (EHPT)

Sent: 20 June 2001 16:14
To: 'jboss'
Subject: [JBoss-user] Multiple Datasources oracle


Hi All,
Im currently trying to set up two data sources for BMP applications.
Iv added the following in the jboss.jcmp :-
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=jdbc/Oracle/BA">
  <attribute name="PoolName">jdbc/Oracle/BA</attribute>
  <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
  <attribute name="URL">jdbc:oracle:thin:@KSPC953:1521:EHSWHIT</attribute>
  <attribute name="LoggingEnabled">true</attribute>
  <attribute name="JDBCUser">scott</attribute>
  <attribute name="Password">tiger</attribute>
</mbean>


<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=jdbc/Oracle">
  <attribute name="PoolName">jdbc/Oracle</attribute>
  <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
  <attribute name="URL">jdbc:oracle:thin:@KSPC953:1521:EHSWHIT</attribute>
  <attribute name="LoggingEnabled">true</attribute>
  <attribute name="JDBCUser">EHSWHIT</attribute>
  <attribute name="Password">orange</attribute>
</mbean>
So what I want is a datasource with jdbc/Oracle JNDI name and then jdbc/Oracle/BA..
When I just use one (jdbc/Oracle) everyhtings fine but when I include the second :-
[jdbc/Oracle/BA] Starting
[jdbc/Oracle/BA] XA Connection pool jdbc/Oracle/BA bound to java:/jdbc/Oracle/BA
[jdbc/Oracle/BA] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl.

[jdbc/Oracle/BA] No transaction right now.
[jdbc/Oracle/BA] Pool jdbc/Oracle/BA [0/0/Unlimited] gave out new object: org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@2acc65

[jdbc/Oracle/BA] Pool jdbc/Oracle/BA [0/1/Unlimited] returned object org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@2acc65 to the pool.

[jdbc/Oracle/BA] Started
[jdbc/Oracle] Starting
[jdbc/Oracle] Stopped
[jdbc/Oracle] javax.naming.NameAlreadyBoundException
[jdbc/Oracle]   at org.jnp.server.NamingServer.bind(NamingServer.java:130)
[jdbc/Oracle]   at org.jnp.server.NamingServer.bind(NamingServer.java:95)
[jdbc/Oracle]   at org.jnp.interfaces.NamingContext.bind(NamingContext.java:314)
[jdbc/Oracle]   at org.jnp.interfaces.NamingContext.bind(NamingContext.java:286)
[jdbc/Oracle]   at org.jboss.jdbc.XADataSourceLoader.bind(XADataSourceLoader.java:373)
[jdbc/Oracle]   at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:325)
[jdbc/Oracle]   at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[jdbc/Oracle]   at java.lang.reflect.Method.invoke(Native Method)
[jdbc/Oracle]   at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[jdbc/Oracle]   at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[jdbc/Oracle]   at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[jdbc/Oracle]   at java.lang.reflect.Method.invoke(Native Method)
[jdbc/Oracle]   at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[jdbc/Oracle]   at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[jdbc/Oracle]   at org.jboss.Main.<init>(Main.java:217)
[jdbc/Oracle]   at org.jboss.Main$1.run(Main.java:121)
[jdbc/Oracle]   at java.security.AccessController.doPrivileged(Native Method)
[jdbc/Oracle]   at org.jboss.Main.main(Main.java:117)
Iv trawled through the messages on the board and have found nothing to solve my probs so please if any one replies dont tell me to search the message board... (-:If there is a message that solves this prob please could you provide a search word so I can find it.

Looking forward,
Stephen
** ** ** ** ** ** ** ** ** ** ** ** **
Stephen White - Designer
Direct : 00 46 31 74 62191
Mobile : 0706 89 33 43
Epost : [EMAIL PROTECTED]
EHPT Sweden AB, 405 34 G�teborg
** ** ** ** ** ** ** ** ** ** ** ** **

Reply via email to