Hi Tim,
If u can refer the database-schemas folder inside config folder of orion, u
will notice the valid mappings between the database field with orion ejb
CMP.
The ms-sql.xml file shows that the date field mapping is dis-allowed in the
orion mapping.
I too tried with timestamp and date.....didn't work.
To solve this problem, i got the date field thru' dateformat, and then
passed this field as String in CMP ... works fine.
U can try this.
Suresh Ajja
Java Developer
www.verchaska.com
mailto: [EMAIL PROTECTED]
----- Original Message -----
From: "Tim Squires" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 3:42 PM
Subject: NumberFormatException when using Date
> Hi Chaps,
>
> I have an CMP that returns a date object as one of the fields. When I
> include the CMP field in the ejb-jar.xml descriptor then access a finder
> method on the bean, a NumberFormatException is thrown. I've tried
changing
> the field to be a Timestamp but it has the same effect. I've also tried
> Orion 1.4.5 and 1.4.7. If I deploy the bean without the date field, it
all
> works fine.
>
> This is the mysql.xml line for date (please note I have tried date and
> datetime in both the db and mysql.xml):
>
> <type-mapping type="java.util.Date" name="datetime" />
> <type-mapping type="java.util.Timestamp" name="datetime" />
>
> Could someone tell me what I'm missing?
>
> I'm using MySQL 3.23.32, Orion 1.4.7, RH Linux 7.0 and mm mysql jdbc
driver
> v2.0.4.
> The error thrown is
>
> com.evermind.server.rmi.OrionRemoteException: Database error:
> java.lang.NumberFormatException; nested exception is:
java.sql.SQLException:
> java.lang.NumberFormatException
>
> Thanks,
> Tim.
>
>
>
>
> Tim Squires
> Wireless Data Services
> ----------------------------------------
> It's not what you know, it's who you tell.
>
>
