-
1. Re: JBoss CMP 2.0 and Date type
dsilcox69 May 2, 2003 7:32 AM (in response to frits.jensen)I'm not a GURU but have had a small amt of success with date type fields...what is your underlying database?
-
2. Re: JBoss CMP 2.0 and Date type
frits.jensen May 2, 2003 7:49 AM (in response to frits.jensen)for development just HyperSonic, but eventually Oracle9i
-
3. Re: JBoss CMP 2.0 and Date type
cepage May 2, 2003 9:12 AM (in response to frits.jensen)Don't know anything about Hypersonic, but for Sybase I was able to get dates to work by adding the following mapping to my standardjbosscmp-jdbc.xml
. <java-type>java.util.Date</java-type>
. <jdbc-type>TIMESTAMP</jdbc-type>
. <sql-type>DATETIME</sql-type> -
4. Re: JBoss CMP 2.0 and Date type
frits.jensen May 3, 2003 1:26 PM (in response to frits.jensen)Thanks, I will try that
-
5. Re: JBoss CMP 2.0 and Date type
frits.jensen May 6, 2003 4:42 PM (in response to frits.jensen)Just to make the final point. Using EJB2.0 one have to code finders that uses Date types - in the proprietary deployment descriptors. It will work in the ejb-jar.xml in JBoss, but it is not acc. to spec and it is not portable anyway. So code the querys in JBoss using the jboss-jdbc.xml At Oracle 9ias this will be the orion-ejb.xml