Ok i found the solution... It's a bug in JBoss 2.2.1 that doesn't allow
automatic persitence of
*java.sql.Date* field type with InstantDB (but i quite sure that the issue
come from the jboss persistentManager not from the DB) . I had to rename all
my java.sql.Date in java.util.Date and it works ! ...
So maybe in the next release this bug will be fixed, we hope so ...
Sami.
----- Original Message -----
From: "Sami JABER" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 1:13 PM
Subject: bug with Custom finder and Date
> hil all,
> I have a Custom finder mapped with 2 date field as follow in my bean:
> (bean) public java.sql.Date _endDate; (/bean)
> my table course_session is well-typed with instantDB Date sql type and
when
> i call
> CMP findByTimebox(cid, startDate, endDate) method, the query is performed
> like this
> (see console output)
> the parameter start_date and en_date is interpreted like an array of bad
> stuffs ...
> the jaws type mappings for instantDb is ok.
> Any idea ?
>
> Sami.
> my custom finder in jaws.xml:
> <query>COURSE_ID = {0} AND START_DATE > {1} AND END_DATE < {2}</query>
>
>
> Console output:
> [EmbeddedTomcat] Find by TimeBox 2001-06-07 2001-11-30
> [CourseSession] Thread-14 SELECT OID FROM COURSE_SESSION WHERE COURSE_ID
=
> EJB AND START_DATE > [3,-84,-19,0,5,115,114,0,25,
>
>
00,79,98,106,101,99,116,124,-67,30,-105,-19,99,-4,62,2,0,3,73,0,4,104,97,115
> ,104,91,0,8,108,111,99,66,121,116,101,115,116,0,2,91,66,91
>
>
,91,117,114,0,2,91,66,-84,-13,23,-8,6,8,84,-32,2,0,0,120,112,0,0,0,31,-84,-1
> 9,0,5,116,0,19,104,116,116,112,58,47,47,115,106,97,98,101,
>
>
,-19,0,5,115,114,0,13,106,97,118,97,46,115,113,108,46,68,97,116,101,20,-6,70
> ,104,63,53,102,-105,2,0,0,120,114,0,14,106,97,118,97,46,11
> 20,112,119,8,0,0,0,-26,-14,87,50,46,120] ) AND END_DATE <
> [3,-84,-19,0,5,115,114,0,25,106,97,118,97,46,114,109,105,46,77,97,
>
>
5,-19,99,-4,62,2,0,3,73,0,4,104,97,115,104,91,0,8,108,111,99,66,121,116,101,
> 115,116,0,2,91,66,91,0,8,111,98,106,66,121,116,101,115,113
>
>
8,84,-32,2,0,0,120,112,0,0,0,31,-84,-19,0,5,116,0,19,104,116,116,112,58,47,4
> 7,115,106,97,98,101,114,58,56,48,56,51,47,113,0,126,0,0,11
>
,115,113,108,46,68,97,116,101,20,-6,70,104,63,53,102,-105,2,0,0,120,114,0,14
> ,106,97,118,97,46,117,116,105,108,46,68,97,116,101,104,106
>
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
