Assume you are using the default configuration and have JBoss installed in
/jboss.
1. Stop server
2. Drop classes12.jar in /jboss/server/default/lib so that it's available at
startup.
3. Copy /jboss/docs/examples/jca/oracle-service.xml to
/jboss/server/default/deploy
4. Substitute your host and sid values for "youroraclehost" and "yoursid" in
oracle-service.xml:
<config-property name="ConnectionURL" type="java.lang.String">
jdbc:oracle:thin:@youroraclehost:1521:yoursid
</config-property>
5. Substitute your schema name and password:
<config-property name="UserName"
type="java.lang.String">yourschemaname</config-property>
<config-property name="Password"
type="java.lang.String">yourschemapassword</config-property>
3. Restart server
----- Original Message -----
From: "Marco Tedone" <[EMAIL PROTECTED]>
To: "JBoss-user-list" <[EMAIL PROTECTED]>
Sent: Wednesday, February 12, 2003 5:34 PM
Subject: [JBoss-user] [Newbie] Oracle Datasource
Hi, i'm referring to my previous email when i was asking help about the
Oracle Datasource.
Instead of a normal connection i switched to an XA connection, following the
template under %JBOSS_HOME%/docs/examples/jca. I hope to have followed all
the instructions correctly and that's what i obtained(could someone tell me
if my connection has been configured correctly? My service is named
xmlop-oraxa-service.xml):
01:18:21,104 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/xmlop-oraxa-service.xml
01:18:21,104 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/jboss-local-jdbc.rar
01:18:21,174 WARN [ServiceController]
jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
does not implement any Service methods
01:18:21,174 WARN [ServiceController]
jboss.jca:service=LocalTxDS,name=hsqldbDS does not implement any Service
methods
01:18:21,174 INFO [LocalTxConnectionManager] Creating
01:18:21,204 INFO [LocalTxConnectionManager] Created
01:18:21,234 INFO [LocalTxConnectionManager] Starting
01:18:21,274 INFO [DefaultDS] Bound connection factory for resource adapter
'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
01:18:21,274 INFO [LocalTxConnectionManager] Started
01:18:21,274 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/jboss-local-jdbc.rar
01:18:21,274 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/jboss-xa.rar
01:18:21,304 INFO [RARMetaData] Loading Minerva Resource Adapter for JDBC 2
XAdrivers
01:18:21,304 INFO [RARMetaData] Required license terms present. See
deployment descriptor.
01:18:21,324 WARN [ServiceController]
jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction
ResourceAdapter does not implement any Service methods
01:18:21,324 WARN [ServiceController]
jboss.jca:service=XATxDS,name=XAOracleDS does not implement any Service
methods
01:18:21,324 INFO [XATxConnectionManager] Creating
01:18:21,334 INFO [XATxConnectionManager] Created
01:18:21,334 INFO [XATxConnectionManager] Starting
01:18:21,364 INFO [JaasSecurityManagerService] Created
securityMgr=org.jboss.security.plugins.JaasSecurityManager@10e687b
01:18:21,364 INFO [JaasSecurityManagerService] setCachePolicy,
c=org.jboss.util.TimedCachePolicy@ed9f47
01:18:21,364 INFO [JaasSecurityManagerService] Added InformixXaDbRealm,
org.jboss.security.plugins.SecurityDomainContext@73f0d8 to map
01:18:21,384 INFO [XAOracleDS] Bound connection factory for resource
adapter 'Minerva JDBC XATransaction ResourceAdapter' to JNDI name
'java:/XAOracleDS'
01:18:21,384 INFO [XATxConnectionManager] Started
01:18:21,384 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/jboss-xa.rar
01:18:21,384 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/jms-ra.rar
01:18:21,424 WARN [ServiceController]
jboss.jca:service=RARDeployment,name=JMS Adapter does not implement any
Service methods
01:18:21,424 WARN [ServiceController] jboss.jca:service=XaTxDS,name=jmsra
does not implement any Service methods
01:18:21,424 INFO [XATxConnectionManager] Creating
01:18:21,434 INFO [XATxConnectionManager] Created
01:18:21,444 INFO [XATxConnectionManager] Starting
01:18:21,454 INFO [JaasSecurityManagerService] Created
securityMgr=org.jboss.security.plugins.JaasSecurityManager@96b5c2
01:18:21,454 INFO [JaasSecurityManagerService] setCachePolicy,
c=org.jboss.util.TimedCachePolicy@76db09
01:18:21,454 INFO [JaasSecurityManagerService] Added JmsXARealm,
org.jboss.security.plugins.SecurityDomainContext@1265109 to map
01:18:21,494 INFO [JmsXA] Bound connection factory for resource adapter
'JMS Adapter' to JNDI name 'java:/JmsXA'
01:18:21,494 INFO [XATxConnectionManager] Started
01:18:21,494 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/jms-ra.rar
01:18:21,504 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/ejb-management.jar
01:18:21,785 INFO [EjbModule] Creating
01:18:21,835 INFO [EjbModule] Deploying MEJB
01:18:22,025 INFO [EjbModule] Created
01:18:22,025 INFO [EjbModule] Starting
01:18:22,085 INFO [EjbModule] Started
01:18:22,085 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/ejb-management.jar
01:18:22,095 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/jmx-ejb-adaptor.jar
01:18:22,195 INFO [EjbModule] Creating
01:18:22,205 INFO [EjbModule] Deploying jmx/ejb/Adaptor
01:18:22,245 INFO [EjbModule] Created
01:18:22,245 INFO [EjbModule] Starting
01:18:22,275 INFO [EjbModule] Started
01:18:22,275 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/jmx-ejb-adaptor.jar
01:18:22,285 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/OneSalary.jar
01:18:22,365 INFO [EjbModule] Creating
01:18:22,385 INFO [EjbModule] Deploying Salary
01:18:22,405 INFO [EjbModule] Created
01:18:22,405 INFO [EjbModule] Starting
01:18:22,415 INFO [EjbModule] Started
01:18:22,415 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/OneSalary.jar
01:18:22,415 INFO [MainDeployer] Starting deployment of package:
file:/D:/OpenSources/jboss/server/default/deploy/jmx-console.war/
01:18:22,476 INFO [EmbeddedCatalinaService41] deploy, ctxPath=/jmx-console,
war Url=file:/D:/OpenSources/jboss/server/default/deploy/jmx-console.war/
01:18:22,486 INFO [Engine] WebappLoader[/jmx-console]: Deploying class
repositories to work directory
D:\OpenSources\jboss\tomcat-4.1.x\work\MainEngine\localhost\jmx-console
01:18:22,496 INFO [Engine] WebappLoader[/jmx-console]: Deploy class files
/WEB-INF/classes to
D:\OpenSources\jboss\server\default\deploy\jmx-console.war\WEB-IN
F\classes
01:18:22,626 INFO [Engine] ContextConfig[/jmx-console]: Added certificates
-> request attribute Valve
01:18:22,766 INFO [EmbeddedCatalinaService41] Using Java2 parent
classloader delegation: true
01:18:22,766 INFO [Engine] StandardManager[/jmx-console]: Seeding random
number generator class java.security.SecureRandom
01:18:22,766 INFO [Engine] StandardManager[/jmx-console]: Seeding of random
number generator has been completed
01:18:22,766 INFO [Engine] StandardWrapper[/jmx-console:default]: Loading
container servlet default
01:18:22,766 INFO [Engine] StandardWrapper[/jmx-console:invoker]: Loading
container servlet invoker
01:18:22,776 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/deploy/jmx-console.war/
01:18:22,786 INFO [URLDeploymentScanner] Started
01:18:22,786 INFO [MainDeployer] Deployed package:
file:/D:/OpenSources/jboss/server/default/conf/jboss-service.xml
01:18:22,786 INFO [Server] JBoss (MX MicroKernel) [3.0.4 Date:200211021607]
Sta
rted in 0m:11s:46ms
Thanks in advance and sorry for all this code.
Marco
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
