View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006697SymmetricDSBugpublic2025-01-10 07:262025-01-10 07:26
Reporterrichard@deepred.co.za Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.15.11 
Summary0006697: "SELECT NULL" support on Derby
Description"SELECT NULL", as implemented in the data recapture process, fails on Derby due to syntax error.
Steps To ReproduceA slight modification to the query might be an appropriate fix: SELECT CAST(NULL AS VARCHAR(255)) FROM ...
Additional Information2025-01-10 08:00:30,778 ERROR (JGPAAKGB-job-19) [org.jumpmind.symmetric.service.impl.PurgeService] Failed to execute purge, so aborting,
org.jumpmind.db.sql.SqlException: Syntax error: Encountered "null" at line 1, column 8.
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) ~[symmetric-db-3.15.11.jar:3.15.11]
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) ~[symmetric-db-3.15.11.jar:3.15.11]
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:377) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    at org.jumpmind.db.sql.JdbcSqlTransaction.queryForObject(JdbcSqlTransaction.java:202) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.DataService.getCsvDataFor(DataService.java:2848) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3641) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.DataService.reCaptureData(DataService.java:3587) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeByMinMax(PurgeService.java:650) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeStranded(PurgeService.java:444) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:152) ~[symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:105) [symmetric-core-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:47) [symmetric-client-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:202) [symmetric-client-3.15.11.jar:3.15.11]
    at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:268) [symmetric-client-3.15.11.jar:3.15.11]
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-6.1.14.jar:6.1.14]
    at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:96) [spring-context-6.1.14.jar:6.1.14]
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:?]
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source) [?:?]
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [?:?]
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
    at java.base/java.lang.Thread.run(Unknown Source) [?:?]
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "null" at line 1, column 8.
    at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:94) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:325) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.ClientStatement.executeQuery(ClientStatement.java:514) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.12.0.jar:2.12.0]
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.12.0.jar:2.12.0]
    at org.jumpmind.db.sql.JdbcSqlTransaction$1.execute(JdbcSqlTransaction.java:221) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:375) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    ... 19 more
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "null" at line 1, column 8.
    at org.apache.derby.client.am.ClientStatement.completeSqlca(ClientStatement.java:2116) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.net.NetStatementReply.parsePrepareError(NetStatementReply.java:579) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(NetStatementReply.java:145) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(NetStatementReply.java:54) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(StatementReply.java:41) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(NetStatement.java:156) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(ClientStatement.java:1702) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.ClientStatement.flowExecute(ClientStatement.java:2381) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.ClientStatement.executeQueryX(ClientStatement.java:520) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.derby.client.am.ClientStatement.executeQuery(ClientStatement.java:505) ~[derbyclient-10.16.1.1.jar:?]
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.12.0.jar:2.12.0]
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.12.0.jar:2.12.0]
    at org.jumpmind.db.sql.JdbcSqlTransaction$1.execute(JdbcSqlTransaction.java:221) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:375) ~[symmetric-jdbc-3.15.11.jar:3.15.11]
    ... 19 more
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-01-10 07:26 richard@deepred.co.za New Issue