Hi,

I have the PERL DBD JDBC server up and running and my perl scripts creates a connection successfully including using select/insert/delete commands. When I am passing create/drop table commands it returns an error as below. Any idea?

[Thread-26] 15:53:03,778 WARN - Error 
java.sql.SQLException: An exception occurred when executing the follow
+ing query: "drop table SRC.RPT1_DVT_WORK.webtrx_T11_expected_ban_pre_
+v". Cause: Query already resolved. [parser-2901050] [Log ID: 13d22e00
+-c2f4-4c0b-b7b3-964640943929] [jdbc-1906510] 
 at cs.jdbc.driver.PreparedStatementImpl.execute(PreparedStatementImpl
+.java:522) 
 at com.vizdom.dbd.jdbc.Connection.handleRequest(Connection.java:744) 
 at com.vizdom.dbd.jdbc.Connection.run(Connection.java:233) 
 at java.lang.Thread.run(Thread.java:748) 
Caused by: java.sql.SQLException: Query already resolved. [parser-2901
+050] [Log ID: 13d22e00-c2f4-4c0b-b7b3-964640943929] 
 at cs.jdbc.driver.PreparedStatementImpl.execute(PreparedStatementImpl
+.java:519) 
 ... 3 more 
Caused by: java.sql.SQLException: Query already resolved. [parser-2901
+050] [Log ID: 13d22e00-c2f4-4c0b-b7b3-964640943929] 
 at cs.jdbc.driver.ClientChannelConnection.checkErrorResponse(ClientCh
+annelConnection.java:1099) 
 at cs.jdbc.driver.ClientChannelConnection.invokeCommand(ClientChannel
+Connection.java:1051) 
 at cs.jdbc.driver.ClientChannelConnection.execplan(ClientChannelConne
+ction.java:1399) 
 at cs.jdbc.driver.PreparedStatementImpl.execute(PreparedStatementImpl
+.java:490) 
 ... 3 more 
[Thread-26] 15:53:03,778 TRACE - Sending error: An exception occurred 
+when executing the following query: "drop table SRC.RPT1_DVT_WORK.web
+trx_T11_expected_ban_pre_v". Cause: Query already resolved. [parser-2
+901050] [Log ID: 13d22e00-c2f4-4c0b-b7b3-964640943929] [jdbc-1906510]
[download]

2018-05-02 Athanasius added code tags

Comment on DBD::JDBC fails to drop/create tables Download Code