Hi Lance,

Following code fails with inet's sybase driver. It works well with jconn2.jar. Could you please look into it.

Thanks,
Mitesh

   private void testSybaseTimeStamp(Connection conn) throws SQLException {
       try {
           //Create the Table
           Statement s = conn.createStatement();
           String sqlStatement;
           try {
               sqlStatement = "DROP TABLE DATATYPES";
               System.out.println(sqlStatement);
               s.executeUpdate(sqlStatement);
           } catch (SQLException e) {
               System.out.println("Table does not exist...");
           }
           sqlStatement = "CREATE TABLE DATATYPES(PK INT NOT NULL, TIMESTAMPDATA DATETIME) ";
           System.out.println(sqlStatement);
           s.executeUpdate(sqlStatement);

           sqlStatement = "INSERT INTO DATATYPES (PK, TIMESTAMPDATA) VALUES(?,?)";
           System.out.println(sqlStatement);
           PreparedStatement ps = conn.prepareStatement(sqlStatement);

           //Initialize arbitrary timestamp value
           //If setNanons is not called, the error disappears
           java.sql.Timestamp timestamp=new java.sql.Timestamp(900000L);
           timestamp.setNanos(123456);
           System.out.println("");
           ps.setInt(1,1); //PK
           ps.setTimestamp(2, timestamp); //TIMESTAMPDATA
           ps.addBatch();
           ps.executeBatch();
                     //ps.executeUpdate(); //If batching is not used, the error disappears

       } catch (SQLException e) {
           SQLException currentException = e;
           do {
               System.out.println("Exception is" + currentException);
               System.out.println("getErrorCode()" + currentException.getErrorCode());
               System.out.println("getSQLState()" + currentException.getSQLState());
               currentException = currentException.getNextException();
           } while (currentException != null);
       }
   }




I have a testcase where timestamp coloumn is explicitly used.It is mapped to java.sql.Timestamp.
When I try to do an insert through cmp, I get this error from Sybase inet driver.This test passes with Oracle inet,and Pointbase.

[#|2004-01-13T15:20:41.000-0800|SEVERE|sun-appserver-pe8.0|javax.enterprise.system.container.ejb|_ThreadID=11;|EJB5071: Some remote or transactional roll back exception occurred
com.sun.jdo.api.persistence.support.JDODataStoreException: JDO76400: Got a JDBC SQLException while executing the SQL statement:
SQL statement<insert into "DATATYPESTEST"("DATATYPESID", "PADDATA", "CURRENTDATEDATA", "NAMESDATA", "BITTEST", "DATETEST", "FIRSTTEST", "REALDATA", "BOOLEANDATA", "BYTEDATA", "CHARACTERDATA", "SHORTDATA", "INTEGERDATA", "LONGDATA", "FLOATDATA", "DOUBLEDATA", "SQLDATEDATA", "UTILDATEDATA", "TIMEDATA", "TIMESTAMPDATA", "BIGDECIMALDATA", "BIGINTEGERDATA") values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)> with input values: java.lang.String:DATA1, <null>, <null>, <null>, <null>, <null>, <null>, <null>, java.lang.Boolean:true, java.lang.Byte:127, java.lang.Character:c, java.lang.Short:32767, java.lang.Integer:2147483647, java.lang.Long:9223372036854775807, java.lang.Float:3.4028235E38, <null>, java.sql.Date:1976-09-15, java.util.Date:Wed Sep 15 00:00:00 PDT 1976, <null>, java.sql.Timestamp:1977-03-09 15:52:00.000123456, java.math.BigDecimal:3, <null>.
Please examine the SQLException for more information.
NestedException: java.sql.BatchUpdateException: [sehdev] Syntax error during implicit conversion of VARCHAR value '1977-03-09 15:52:00.000123456' to a DATETIME field.

FailedObjectArray: [s1peqe.ejb.cmp.datatypes.DataTypesBean914238719_JDOState@1077092]
-Deepa
###@###.### 2004-01-13
###@###.### 2004-01-15