[jira] [Created] (TRAFODION-3063) Drivers cannot support date format like '2018-02-15:15:28:16' for batch insertion

[Kevin Xu (JIRA)]

Kevin Xu created TRAFODION-3063:
-----------------------------------

             Summary: Drivers cannot support date format like 
'2018-02-15:15:28:16' for batch insertion
                 Key: TRAFODION-3063
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3063
             Project: Apache Trafodion
          Issue Type: Bug
          Components: client-jdbc-t4
            Reporter: Kevin Xu


//table ddl

CREATE TABLE TRAFODION.SCH.A
 ( 
 C1 TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED
 )
 ATTRIBUTES ALIGNED FORMAT 
;

//code for reproducing

Connection conn = DriverManager.getConnection(url, "trafodion", "traf123");
PreparedStatement ps = conn.prepareStatement("insert into a VALUES (?)");
ps.setObject(1,"2018-03-22:19:10:25");
ps.addBatch();
ps.executeBatch();
conn.close();

 

//Output

java.sql.BatchUpdateException: Batch Update Failed, See next exception for 
details

        at 
org.trafodion.jdbc.t4.TrafT4PreparedStatement.executeBatch(TrafT4PreparedStatement.java:322)

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)