Group,
I have searched the forums for any resolutions to this problem and haven't found any.
I am simply trying to configure a connection pool for an Oracle database on JBoss
3.0.1RC1. I followed the Quick Start guide's instructions on how to do this. The only
changes made to the example where to use the thin driver and make the nessecary
changes to use JAAS instead of a user/password in the service xml. This is the server
xml file that I dervied from the example:
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<server>
<!-- ==================================================================== -->
<!-- ConnectionManager setup for xa oracle dbs -->
<!-- Thanks to igor fedorenko <[EMAIL PROTECTED]> -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- YOU MUST CHANGE THE XidFactoryMBean config to this: -->
<mbean code="org.jboss.tm.XidFactory" name="jboss:service=XidFactory">
<attribute name="Pad">true</attribute>
</mbean>
<!-- ==================================================================== -->
<mbean code="org.jboss.resource.connectionmanager.XATxConnectionManager"
name="jboss.jca:service=XaTxCM,name=XAOracleDS">
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=XaTxDS,name=XAOracleDS">
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva
JDBC XATransaction ResourceAdapter</depends>
<!--real attributes-->
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property
name="XADataSourceProperties"
type="java.lang.String">URL=jdbc:oracle:thin:@10.32.12.71:1521:prod</config-property>
<config-property
name="XADataSourceClass"
type="java.lang.String">oracle.jdbc.xa.client.OracleXADataSource</config-property>
<!--set these only if you want only
default logins, not through JAAS -->
<!--
<config-property name="UserName"
type="java.lang.String"/>
<config-property name="Password"
type="java.lang.String"/>
-->
<!--
Do not try to set transaction isolation level here or you'll get
java.sql.SQLException: ORA-01453: SET TRANSACTION must be first
statement of transaction
Read committed is a default isolation level for Oracle, so there
is not real need to set it here. I'll take a look into it later
...maybe.
<config-property name="TransactionIsolation"
type="java.lang.String">TRANSACTION_READ_COMMITTED</config-property>
-->
</properties>
</attribute>
<attribute name="JndiName">jts.sempraProd</attribute>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=XaTxPool,name=XAOracleDS">
<attribute name="MinSize">2</attribute>
<attribute name="MaxSize">100</attribute>
<attribute
name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--criteria indicates if Subject (from security
domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<!-- Include a login module configuration named InformixXaDbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "InformixXaDbRealm">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name = "principal">yourprincipal</module-option>
<module-option name = "userName">yourusername</module-option>
<module-option name = "password">yourpassword</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=XATxCM,name=InformixXaDS</module-option>
</login-module>
</authentication>
</application-policy>
NOTE: the application-policy name attribute must match SecurityDomainJndiName, and
the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you are configuring here.
-->
<!--uncomment out this line if you are using the InformixXaDbRealm
above -->
<attribute
name="SecurityDomainJndiName">java:/jaas/OracleXADBRealm</attribute>
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
</mbean>
</server>
This is the login-config.xml fragment that I added:
<application-policy name="OracleXADBRealm">
<authentication>
<login-module
code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required">
<module-option name="principal">webapp</module-option>
<module-option name="userName">webapp</module-option>
<module-option
name="password">webappprod</module-option>
<module-option
name="managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=XAOracleDS</module-option>
</login-module>
</authentication>
</application-policy>
When the server is started it produces the following messages and stack trace:
16:24:49,620 INFO [MainDeployer] Starting deployment of package: file:/D:/java/
jboss-3.0.1RC1/server/default/deploy/oracle-service-sempra-prod.xml
16:24:49,673 INFO [MainDeployer] deployment waiting for deployer: file:/D:/java
/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempra-prod.xml
16:24:49,674 INFO [MainDeployer] Deployment of package: file:/D:/java/jboss-3.0
.1RC1/server/default/deploy/oracle-service-sempra-prod.xml is waiting for an app
ropriate deployer.
16:24:49,692 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
Packages waiting for a deployer:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]Incompletely deployed packages:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
<none>
16:24:49,840 INFO [URLDeploymentScanner] Started
16:24:49,852 INFO [MainDeployer] Deployed package: file:/D:/java/jboss-3.0.1RC1
/server/default/conf/jboss-service.xml
16:24:49,897 ERROR [Server] start failed
Incomplete Deployment listing:
Packages waiting for a deployer:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]Incompletely deployed packages:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
<none>
at org.jboss.deployment.MainDeployer.checkIncompleteDeployments(Compiled
Code)@12d62830
at org.jboss.deployment.MainDeployer.deploy(Compiled Code)@11b3cb90
at org.jboss.deployment.MainDeployer.deploy(Compiled Code)@11b3cae0
at java.lang.reflect.Method.invoke(Native Method)@1189285e
at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(Compiled Code
)@11b34410
at org.jboss.mx.server.MBeanServerImpl.invoke(Compiled Code)@11b342c0
at org.jboss.system.server.ServerImpl.doStart(Compiled Code)@1192acc0
at org.jboss.system.server.ServerImpl.start(Compiled Code)@1192aa70
at org.jboss.Main.boot(Compiled Code)@118d0250
at org.jboss.Main$1.run(Compiled Code)@118d0100
at java.lang.Thread.run(Compiled Code)@11733730
at java.lang.Thread.startThreadFromVM(Compiled Code)@117335e0
--- End of stack trace
16:24:50,196 ERROR [STDERR] Incomplete Deployment listing:
Packages waiting for a deployer:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]Incompletely deployed packages:
[org.jboss.deployment.DeploymentInfo@c6bbeab9 { url=file:/D:/java/jboss-3.0.1RC1
/server/default/deploy/oracle-service-sempra-prod.xml }
deployer: null
status: null
watch: file:/D:/java/jboss-3.0.1RC1/server/default/deploy/oracle-service-sempr
a-prod.xml
lastDeployed: 1026764689674
lastModified: 1026764689675
mbeans:
]MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
<none>
16:24:50,339 ERROR [STDERR] at org.jboss.deployment.MainDeployer.checkIncomp
leteDeployments(Compiled Code)@12d62830
16:24:50,380 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(Comp
iled Code)@11b3cb90
16:24:50,387 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(Comp
iled Code)@11b3cae0
16:24:50,401 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method
)@1189285e
16:24:50,415 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatc
her.invoke(Compiled Code)@11b34410
16:24:50,436 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(Co
mpiled Code)@11b342c0
16:24:50,442 ERROR [STDERR] at org.jboss.system.server.ServerImpl.doStart(Co
mpiled Code)@1192acc0
16:24:50,456 ERROR [STDERR] at org.jboss.system.server.ServerImpl.start(Comp
iled Code)@1192aa70
16:24:50,470 ERROR [STDERR] at org.jboss.Main.boot(Compiled Code)@118d0250
16:24:50,484 ERROR [STDERR] at org.jboss.Main$1.run(Compiled Code)@118d0100
16:24:50,492 ERROR [STDERR] at java.lang.Thread.run(Compiled Code)@11733730
16:24:50,500 ERROR [STDERR] at java.lang.Thread.startThreadFromVM(Compiled C
ode)@117335e0
16:24:50,557 ERROR [STDERR] --- End of stack trace
For some reason, no deployer is found to match this service. I have tried variations
of the xml for non-JAAS authentication and for the non-XA version of the Oracle
driver. All attempts yield the same error. Any ideas where to check from here?
Karl Koster
[EMAIL PROTECTED]
Sempra Energy Trading
203-355-5182
**********************************************************************
This e-mail contains privileged attorney-client communications and/or confidential
information, and is only for the use by the intended recipient. Receipt by an
unintended recipient does not constitute a waiver of any applicable privilege.
Reading, disclosure, discussion, dissemination, distribution or copying of this
information by anyone other than the intended recipient or his or her employees or
agents is strictly prohibited. If you have received this communication in error,
please immediately notify us and delete the original material from your computer.
Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the
utilities owned by SET's parent company. SET is not regulated by the California
Public Utilities Commission and you do not have to buy SET's products and services to
continue to receive quality regulated service from the utilities.
**********************************************************************
-------------------------------------------------------
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
