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

In reply to DBD::JDBC fails to drop/create tables by amirn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.