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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: client-jdbc-t4
• Assignee: Unassigned
• Reporter: Kevin Xu
• Created: 09/May/18 05:51
• Updated: 10/May/18 19:14

Description

//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)

 

Issue Links

• links to: GitHub Pull Request #1556