Hi
When I change the POM to use ojdbc8 Jar then I am getting the below error
2017-08.18 04:42:02.647-0700: ERROR: Failed to create status log entry: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO table name (s_id, f_id, p_id, t_type, d_addr, st, desc, f_size) VALUES (88568, ?, ?, ?, ?, ?, ?, ?)]; SQL state [99999]; error code [17068]; Invalid argument(s) in call; nested exception is java.sql.SQLException: Invalid argument(s) in call
2017-08.18 04:42:02.647-0700: CAUSE: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO table name (s_id, f_id, p_id, t_type, d_addr, st, desc, f_size) VALUES (88568, ?, ?, ?, ?, ?, ?, ?)]; SQL state [99999]; error code [17068]; Invalid argument(s) in call; nested exception is java.sql.SQLException: Invalid argument(s) in call
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO QA_DF_OWNER.df_statuslog (stl_id, feed_id, partner_id, trans_type, dest_addr, status, description, file_size) VALUES (88568, ?, ?, ?, ?, ?, ?, ?)]; SQL state [99999]; error code [17068]; Invalid argument(s) in call; nested exception is java.sql.SQLException: Invalid argument(s) in call
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:843)
at org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:188)
Caused by: java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.driver.AutoKeyInfo.getNewSql(AutoKeyInfo.java:187)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:4342)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
Any clue what could be the reason?
Regards
Abhishek