I am following the Getting Started with JBoss to install Duke's Bank example. I am using JBoss 3.2.3, jdk 1.4.1, j2ee 1.3. But I hit problem when using ant to create table. Finally I have to use the HSQL DB Manager to type in the create table statements. Then I continue to use ant to insert and list, which is successful.
After deployment, I login the bank the customer id and password as stated in the book. But it stoped with the following displayed on the browser:
Server Error
Your request cannot be completed. The server got the following error:
EJBException:; nested exception is: javax.ejb.EJBException: getAccountsOfCustomer: ejbLoad: Wrong data type: type: TIMESTAMP (93) expected: DATE value: 2000-02-28 23:03:20.0; nested exception is: javax.ejb.EJBException: ejbLoad: Wrong data type: type: TIMESTAMP (93) expected: DATE value: 2000-02-28 23:03:20.0
Checking the table with the db manager again and the only column related to date time in table ACCOUNT is the begin_balance_timestamp which is defined as TIMESTAMP. And the value is same as above.
Anybody know what's wrong? What is TIMESTAMP(93) stands for?