0 Replies Latest reply on Jul 22, 2004 6:51 AM by sender

    type mismatch

      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?