hello all,
@Farid59: quote my message (Posted: Thu Mar 18, 2004 05:28 AM ) in this page, because
I think you have problem about your configuration.
I have a problem when my client have to access my database ( in the chapter 4 and 5 of
tutorial), and the server give me this error message:
17:39:49,594 INFO [STDOUT] Entering StoreAccessBean
17:39:49,595 INFO [STDOUT] Leaving StoreAccessBean
17:39:49,596 INFO [STDOUT] Entering StoreAccessDAOImpl.loginUser()
17:39:49,598 ERROR [STDERR] java.sql.SQLException: General error in statement [select
userid from storeaccess where username='ANDY' and password'PASSWD']
17:39:49,600 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source)
17:39:49,601 ERROR [STDERR] at org.hsqldb.Result.(Unknown Source)
17:39:49,602 ERROR [STDERR] at org.hsqldb.jdbcConnection.executeHSQL(Unknown
Source)
17:39:49,602 ERROR [STDERR] at org.hsqldb.jdbcConnection.execute(Unknown Source)
17:39:49,603 ERROR [STDERR] at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
17:39:49,604 ERROR [STDERR] at org.hsqldb.jdbcStatement.executeQuery(Unknown
Source)
17:39:49,605 ERROR [STDERR] at
org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source)
17:39:49,611 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
17:39:49,612 ERROR [STDERR] at
au.com.tusc.dao.StoreAccessDAOImpl.loginUser(StoreAccessDAOImpl.java:50)
17:39:49,613 ERROR [STDERR] at
au.com.tusc.session.StoreAccessSession.loginUser(StoreAccessSession.java:54)
17:39:49,614 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
17:39:49,614 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
17:39:49,615 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17:39:49,616 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
17:39:49,617 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
17:39:49,617 ERROR [STDERR] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
17:39:49,619 ERROR [STDERR] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
17:39:49,620 ERROR [STDERR] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
17:39:49,620 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
17:39:49,621 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
17:39:49,622 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
17:39:49,623 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
17:39:49,623 ERROR [STDERR] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
17:39:49,624 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
17:39:49,625 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
17:39:49,626 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
17:39:49,626 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
17:39:49,627 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17:39:49,628 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
17:39:49,629 ERROR [STDERR] at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
17:39:49,630 ERROR [STDERR] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
17:39:49,630 ERROR [STDERR] at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
17:39:49,631 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
17:39:49,632 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
17:39:49,633 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17:39:49,633 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
17:39:49,634 ERROR [STDERR] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
17:39:49,635 ERROR [STDERR] at
sun.rmi.transport.Transport$1.run(Transport.java:148)
17:39:49,638 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native
Method)
17:39:49,639 ERROR [STDERR] at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
17:39:49,640 ERROR [STDERR] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
17:39:49,641 ERROR [STDERR] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
17:39:49,642 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
17:39:49,642 INFO [STDOUT] Inside
StoreAccessDAOImpl.loginUser()java.sql.SQLException: General error in statement
[select userid from storeaccess where username='ANDY' and password'PASSWD']
17:39:49,643 INFO [STDOUT] Leaving StoreAccessDAOImpl.loginUser()
17:39:49,645 INFO [CachedConnectionManager] Closing a connection for you. Please
close them yourself: [EMAIL PROTECTED]
java.lang.Exception: STACKTRACE
at
org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:282)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:506)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at au.com.tusc.dao.StoreAccessDAOImpl.loginUser(StoreAccessDAOImpl.java:45)
at au.com.tusc.session.StoreAccessSession.loginUser(StoreAccessSession.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method
<a
href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826900#3826900";>View
the original post</a>
<a
href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826900>Reply
to the post</a>
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
