When using oracle 9i and JBoss 3.2.3 and trying to use a ejb create function to create a date I get an error with mysql.
| 2005-06-02 16:13:32,510 ERROR [STDERR] java.sql.SQLException: Fail to convert to internal representation | 2005-06-02 16:13:32,510 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) | 2005-06-02 16:13:32,510 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) | 2005-06-02 16:13:32,510 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) | 2005-06-02 16:13:32,510 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.getLongValue(OracleStatement.java:4367) | 2005-06-02 16:13:32,510 ERROR [STDERR] at oracle.jdbc.driver.OracleResultSetImpl.getLong(OracleResultSetImpl.java:529) | 2005-06-02 16:13:32,510 ERROR [STDERR] at com.snc.distribution.kingservices.KingPackageGeneratorProcess.process(Unknown Source) | 2005-06-02 16:13:32,510 ERROR [STDERR] at com.snc.distribution.kingservices.KingPackageGeneratorProcess.onMessage(Unknown Source) | 2005-06-02 16:13:32,510 ERROR [STDERR] at xflow.client.WorkflowProcess.onMessage(WorkflowProcess.java:103) | 2005-06-02 16:13:32,510 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:546) | 2005-06-02 16:13:32,510 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534) | Here is the code that generates this error: | currentItem = itemHome.create(itemInfo.getString(), itemInfo.getDate().getTime(), "STRING", new Long(3)); | | The itemInfo.getDate() returns a GregorianCalandar. We then get a Date object from that and pass it to the create. The oracle table looks like this Table items NUMBER id VARCHAR2(20) name DATE theDateModified VARCHAR2(250) description NUMBER(10) id It then blows up with the error above. any ideas what would cause this to happen. I don't want to hardcode it to just oracle because we sometimes use mysql to do development. Any suggestions? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3880058#3880058 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3880058 ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
