Re: [JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1)
Thanks. That did it. -Steve Stephen Coy wrote: You need to set up a security policy in conf/login-config.xml: application-policy name = HRXDBRealm authentication login-module code = org.jboss.resource.security.ConfiguredIdentityLoginModule flag = required module-option name = principalyourprincipalname/module-option module-option name = userNameyouroracleusername/module-option module-option name = passwordyouroraclepassword/module-option module-option name = managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name= HRXOracleDS /module-option /login-module /authentication /application-policy and change the line below to: attribute name=SecurityDomainJndiNamejava:/jaas/HRXDBRealm/attribute On Tuesday, April 16, 2002, at 09:17 AM, Stephen Davidson wrote: attribute name=SecurityDomainJndiNamejava:/jaas/HsqlDbRealm/attribute ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1)
Greetings. I am trying to generate a connection to an Oracle Database. I am getting a large stack trace trying to use the attached oracle-service.xml file. Suggestions? -Steve 18:11:39,588 INFO [STDOUT] ConnectionManager.init:Platform = JBoss 18:11:39,589 INFO [STDOUT] ConnectionManager.ConnectionManager: DEBUG_JDBC = false 18:11:39,607 INFO [STDOUT] Looking up: java:/jdbc/pool/hrnexus 18:11:39,609 INFO [STDOUT] ConnectionManager: TimeElapsed = 2 18:11:40,618 ERROR [STDERR] java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException: Unable to create DB connection for url: jdbc:oracle:thin:192.168.2.11:1521:ORCL, user: sa, exception: java.sql.SQLException: Null user or password not supported in THIN driver 18:11:40,619 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCDataSource.java:114) 18:11:40,620 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.getConnection(DBConnection.java:173) 18:11:40,620 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.makeConnection(DBConnection.java:191) 18:11:40,621 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.executePreparedSQLQuery(DBConnection.java:398) 18:11:40,621 ERROR [STDERR] at com.hrnexus.security.ejb.UserService.checkCompany(UserService.java:556) 18:11:40,622 ERROR [STDERR] at com.hrnexus.security.ejb.UserEJB.ejbFindByPrimaryKey(UserEJB.java:763) 18:11:40,622 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method) 18:11:40,622 ERROR [STDERR] at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:636) 18:11:40,623 ERROR [STDERR] at org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:330) 18:11:40,623 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:262) 18:11:40,624 ERROR [STDERR] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:687) 18:11:40,624 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method) 18:11:40,625 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:) 18:11:40,625 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:230) 18:11:40,625 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:176) 18:11:40,626 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) 18:11:40,626 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79) 18:11:40,627 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44) 18:11:40,627 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:98) 18:11:40,628 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167) 18:11:40,628 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:104) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:109) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) 18:11:40,630 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:727) 18:11:40,631 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055) 18:11:40,631 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:492) 18:11:40,631 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98) 18:11:40,632 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102) 18:11:40,632 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:73) 18:11:40,633 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:76) 18:11:40,633 ERROR [STDERR] at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:185) 18:11:40,634 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:96) 18:11:40,634 ERROR [STDERR] at $Proxy258.findByPrimaryKey(Unknown Source) 18:11:40,634 ERROR [STDERR] at com.hrnexus.security.shared.ThinUserProxy.getUserEJB(ThinUserProxy.java:589) 18:11:40,635 ERROR [STDERR] at com.hrnexus.security.shared.ThinUserProxy.getUser(ThinUserProxy.java:562) 18:11:40,635 ERROR [STDERR] at com.hrnexus.security.servlet.LoginServlet.logIn(LoginServlet.java:266) 18:11:40,636 ERROR [STDERR] at
Re: [JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1)
Hello, Since you have this entry: attribute name=CriteriaByContainer/attribute DB login/password information is obtained from server/default/conf/login-config.xml, not from oracle-service.xml. Add a OracleDbRealm entry in login-config.xml. Download the oracle-service.xml example file from here: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jbosscx/src/etc/example-config/ Ricardo Arguello - Original Message - From: Stephen Davidson [EMAIL PROTECTED] To: jboss-user [EMAIL PROTECTED] Sent: Monday, April 15, 2002 6:17 PM Subject: [JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1) Greetings. I am trying to generate a connection to an Oracle Database. I am getting a large stack trace trying to use the attached oracle-service.xml file. Suggestions? -Steve 18:11:39,588 INFO [STDOUT] ConnectionManager.init:Platform = JBoss 18:11:39,589 INFO [STDOUT] ConnectionManager.ConnectionManager: DEBUG_JDBC = false 18:11:39,607 INFO [STDOUT] Looking up: java:/jdbc/pool/hrnexus 18:11:39,609 INFO [STDOUT] ConnectionManager: TimeElapsed = 2 18:11:40,618 ERROR [STDERR] java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException: Unable to create DB connection for url: jdbc:oracle:thin:@192.168.2.11:1521:ORCL, user: sa, exception: java.sql.SQLException: Null user or password not supported in THIN driver 18:11:40,619 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCDataSource.java:114) 18:11:40,620 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.getConnection(DBConnection.java:173) 18:11:40,620 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.makeConnection(DBConnection.java:191) 18:11:40,621 ERROR [STDERR] at com.hrnexus.common.ejb.DBConnection.executePreparedSQLQuery(DBConnection.java:398) 18:11:40,621 ERROR [STDERR] at com.hrnexus.security.ejb.UserService.checkCompany(UserService.java:556) 18:11:40,622 ERROR [STDERR] at com.hrnexus.security.ejb.UserEJB.ejbFindByPrimaryKey(UserEJB.java:763) 18:11:40,622 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method) 18:11:40,622 ERROR [STDERR] at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:636) 18:11:40,623 ERROR [STDERR] at org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:330) 18:11:40,623 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:262) 18:11:40,624 ERROR [STDERR] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:687) 18:11:40,624 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method) 18:11:40,625 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:) 18:11:40,625 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:230) 18:11:40,625 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:176) 18:11:40,626 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) 18:11:40,626 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79) 18:11:40,627 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44) 18:11:40,627 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:98) 18:11:40,628 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167) 18:11:40,628 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:104) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:109) 18:11:40,629 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487) 18:11:40,630 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:727) 18:11:40,631 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055) 18:11:40,631 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:492) 18:11:40,631 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98) 18:11:40,632 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102) 18:11:40,632 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:73) 18:11:40,633 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:76) 18:11
Re: [JBoss-user] Stupid User? JCA Problem with Oracle Database (JBoss V3.0RC1)
You need to set up a security policy in conf/login-config.xml: application-policy name = HRXDBRealm authentication login-module code = org.jboss.resource.security.ConfiguredIdentityLoginModule flag = required module-option name = principalyourprincipalname/module-option module-option name = userNameyouroracleusername/module-option module-option name = passwordyouroraclepassword/module-option module-option name = managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name= HRXOracleDS /module-option /login-module /authentication /application-policy and change the line below to: attribute name=SecurityDomainJndiNamejava:/jaas/HRXDBRealm/attribute On Tuesday, April 16, 2002, at 09:17 AM, Stephen Davidson wrote: attribute name=SecurityDomainJndiNamejava:/jaas/HsqlDbRealm/attribute ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user