Hypersonic Database Access Problems...
jakelee May 12, 2004 2:27 AMHi, all,
I am going through chapter 3 of that TUSC J2EE tutorial (Eclipse/JBoss).
For some reason: it returned null.
*************Result**************
Request from client :
Reply from Server: Your userid is null
********************************
Errors in Console:
----------------------------------------------------------------------
00:05:37,738 INFO [STDOUT] Entering StoreAccessBean
00:05:37,738 INFO [STDOUT] Leaving StoreAccessBean
00:05:37,768 INFO [STDOUT] Entering StoreAccessDAOImpl.init()
00:05:37,768 INFO [STDOUT] Leaving StoreAccessDAOImpl.init()
00:05:37,768 INFO [STDOUT] Entering StoreAccessDAOImpl.init()
00:05:37,778 ERROR [STDERR] java.sql.SQLException: Table not found: STOREACCESS in statement [select userid from STOREACCESS where username = 'ANDY' and password = 'PASSWD']
00:05:37,778 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source)
00:05:37,778 ERROR [STDERR] at org.hsqldb.jdbcResultSet.(Unknown Source)
00:05:37,778 ERROR [STDERR] at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
00:05:37,778 ERROR [STDERR] at org.hsqldb.jdbcConnection.execute(Unknown Source)
00:05:37,778 ERROR [STDERR] at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
00:05:37,788 ERROR [STDERR] at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
00:05:37,788 ERROR [STDERR] at org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source)
00:05:37,788 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
00:05:37,788 ERROR [STDERR] at au.com.tusc.dao.StoreAccessDAOImpl.loginUser(StoreAccessDAOImpl.java:56)
00:05:37,788 ERROR [STDERR] at au.com.tusc.session.StoreAccessSession.loginUser(StoreAccessSession.java:60)
00:05:37,788 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
00:05:37,788 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
00:05:37,788 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00:05:37,788 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
00:05:37,788 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
00:05:37,788 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
00:05:37,788 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
00:05:37,798 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
00:05:37,798 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00:05:37,798 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
00:05:37,798 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
00:05:37,798 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
00:05:37,798 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
00:05:37,798 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
00:05:37,798 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
00:05:37,798 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
00:05:37,798 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
00:05:37,798 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
00:05:37,798 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:148)
00:05:37,798 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
00:05:37,798 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
00:05:37,798 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
00:05:37,798 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
00:05:37,798 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
00:05:37,798 INFO [STDOUT] Inside StoreAccessDAOImpl.loginUser()java.sql.SQLException: Table not found: STOREACCESS in statement [select userid from STOREACCESS where username = 'ANDY' and password = 'PASSWD']
00:05:37,798 INFO [STDOUT] Leaving StoreAccessDAOImpl.loginUser()
-------------------------------------------------------------------------------
Please let me know if you can help...thankx a lot...
J-
FYI - StoreAccessBean.java
/*
* Created on May 11, 2004
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package au.com.tusc.session;
import javax.ejb.SessionBean;
import javax.ejb.SessionContext;
/**
* @ejb.bean name="StoreAccess"
* jndi-name="StoreAccessBean"
* type="Stateless"
*
* @ejb.dao class="au.com.tusc.session.StoreAccessDAO"
* impl-class="au.com.tusc.dao.StoreAccessDAOImpl"
*
* @ejb.resource-ref res-ref-name="jdbc/DefaultDS"
* res-type="javax.sql.Datasource"
* res-auth="Container"
*
* @jboss.resource-ref res-ref-name="jdbc/DefaultDS"
* jndi-name="java:/DefaultDS"
*
* **/
public abstract class StoreAccessBean implements SessionBean {
protected SessionContext ctx;
/**
* @ejb.interface-method
* view-type="remote"
* @dao.call name="loginUser"
**/
public String loginUser (String username, String password){
System.out.println("Entering StoreAccessBean");
System.out.println("Leaving StoreAccessBean");
return null;
}
/**
* Sets the session context
* @param javax.ejb.SessionContext the new ctx value
* @ejb.method stSessionContext
**/
public void setSessionContext(javax.ejb.SessionContext ctx) {
this.ctx = ctx;
}
/**
* Unsets the session context
* @param javax.ejb.SessionContext ctx value
* @ejb.method unsetSessionContext
**/
public void unsetSessionContext() {
this.ctx = null;
}
}