[
https://issues.apache.org/jira/browse/TRAFODION-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16470972#comment-16470972
]
ASF GitHub Bot commented on TRAFODION-3063:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1556
> 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
> Priority: Major
>
> //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)
