Database problem with Duke's Bank example
nickdegraeve Nov 25, 2004 6:22 AMI just can't seem to get the banking example to work. This time it's apparently a database error.
Error in browser:
Server Error
Your request cannot be completed. The server got the following error:
null
Stack trace:
[...]
08:45:52,684 INFO [STDOUT] Debug: AccountBean makeConnection
08:45:52,687 ERROR [LogInterceptor] EJBException in method: public abstract java.util.Collection com.sun.ebank.ejb.account.AccountHome.findByCustomerId(java.lang.String) throws javax.ejb.FinderException,java.rmi.RemoteException
javax.ejb.EJBException: ejbFindByCustomerId Unable to connect to database. Could not dereference object
at com.sun.ebank.ejb.account.AccountBean.ejbFindByCustomerId(Unknown Source)
[...]
08:45:52,733 ERROR [Engine] ApplicationDispatcher[/bank] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.links_jsp._jspService(links_jsp.java:68)
[...]
I followed the instructions in the tutorial and edited hsqldb-ds.xml:
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url> <driver-class>org.hsqldb.jdbcDriver</driver-class> <user-name>sa</user-name> <password></password> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <idle-timeout-minutes>5</idle-timeout-minutes> <track-statements/> <security-domain>HsqlDbRealm</security-domain> <prepared-statement-cache-size>32</prepared-statement-cache-size> <depends>jboss:service=Hypersonic,database=localDB</depends> </local-tx-datasource> <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic"> <attribute name="Port">1701</attribute> <attribute name="Silent">true</attribute> <attribute name="Database">default</attribute> <attribute name="Trace">false</attribute> <attribute name="No_system_exit">true</attribute> </mbean> </datasources>
The Ant-scripts for creating tables and data exit without errors. I can start the HSQL Database Manager Tool and run some SQL queries that return data.
I have to say that when I start JBoss I get in the sartup log a message that may shed some light on the problem:
[...]
Depends On Me:
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss:service=Hypersonic,database=localDB
state: NOTYETINSTALLED
I Depend On:
Depends On Me: jboss.jca:service=ManagedConnectionFactory,name=DefaultDS
I probably forgot to set something in the configuration files but I have no idea what.