Re: [JBoss-user] Authentication Problem

[Scott M S. <sco...@jb...>]

The query is going against the DefaultDS, not the RestaurantDS. Show
the full stack trace.

-- 
xxxxxxxxxxxxxxxxxxxxxxxx
Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx

Jack Lauman wrote:

> I am trying to move an app from 3.0.7 to 3.2.3RC1 and am getting the
> following error.  Apparently it's trying to connect to hsqldb
> instead of the mysql db named java:/RestaurantDS.  The app works
> correctly under 3.0.7.
> 
> I would appreciate any help in resolving this.  I have included a short
> stack trace, login-config.xml and restaurant-ds.xml.
> 
> Thanks,
> 
> Jack
> 
> 
> <--snip-->
> [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3RC1
> (build: CVSTag=JBoss_3_2_3_RC1 date=200311101720)] Started in
> 1m:35s:493ms
> INFO  [STDOUT] 95508 [main] INFO org.jboss.system.server.Server  - JBoss
> (MX MicroKernel) [3.2.3RC1 (build: CVSTag=JBoss_3_2_3_RC1
> date=200311101720)] Started in 1m:35s:493ms
> DEBUG [org.apache.tomcat.util.threads.ThreadPool] Getting new thread
> data
> INFO  [STDOUT] 399044 [TP-Processor3] DEBUG
> org.apache.tomcat.util.threads.ThreadPool  - Getting new thread data
> INFO  [org.jboss.security.plugins.JaasSecurityManagerService] Created
> securityMgr=org.jboss.security.plugins.JaasSecurityManager@805298
> INFO  [STDOUT] 399210 [TP-Processor4] INFO
> org.jboss.security.plugins.JaasSecurityManagerService  - Created
> securityMgr=org.jboss.security.plugins.JaasSecurityManager@805298
> INFO  [org.jboss.security.plugins.JaasSecurityManagerService]
> setCachePolicy, c=org.jboss.util.TimedCachePolicy@ae7b77
> INFO  [STDOUT] 399212 [TP-Processor4] INFO
> org.jboss.security.plugins.JaasSecurityManagerService  - setCachePolicy,
> c=org.jboss.util.TimedCachePolicy@ae7b77
> INFO  [org.jboss.security.plugins.JaasSecurityManagerService] Added
> RestaurantSecurityRealm,
> org.jboss.security.plugins.SecurityDomainContext@12bc407 to map
> INFO  [STDOUT] 399213 [TP-Processor4] INFO
> org.jboss.security.plugins.JaasSecurityManagerService  - Added
> RestaurantSecurityRealm,
> org.jboss.security.plugins.SecurityDomainContext@12bc407 to map
> ERROR [org.jboss.security.auth.spi.DatabaseServerLoginModule] Query
> failed
> java.sql.SQLException: Table not found: USER in statement [SELECT
> Password FROM User WHERE UserID = 'jlauman']
> 	at org.hsqldb.Trace.getError(Unknown Source)
> 	at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
> 	at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
> 	at org.hsqldb.jdbcConnection.execute(Unknown Source)
> 	at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
> 	at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
> 	at org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source)
> 	at
> org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
> 	at
> org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:100)
> 	at
> org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:150)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> <--snip-->
>