Hi Karl.
There were only two instances that I had this error occur.
1) Incorrect syntax in my oracle-service.xml file (you did name this
oracle-service.xml, right? JBoss sometimes does weird behaviour if you don't name
these files something-service.xml).
2) (More frequent) The username/password you specify for Oracle don't match a valid
User/Password for the Oracle Database. (Use something like SQLPlus and see if you can
login using webapp/webappprod
as you User/Password.
-Steve
Karl Koster wrote:
> 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
>
>
--
Java Developer
Looking for a new job opportunity
214-724-7741
-------------------------------------------------------
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
