CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
DBD::JDBC fails to drop/create tables

 



amirn
New User

Apr 28, 2018, 1:23 AM

Post #1 of 1 (3763 views)
DBD::JDBC fails to drop/create tables Can't Post

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 following 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-2901050] [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-2901050] [Log ID: 13d22e00-c2f4-4c0b-b7b3-964640943929]
at cs.jdbc.driver.ClientChannelConnection.checkErrorResponse(ClientChannelConnection.java:1099)
at cs.jdbc.driver.ClientChannelConnection.invokeCommand(ClientChannelConnection.java:1051)
at cs.jdbc.driver.ClientChannelConnection.execplan(ClientChannelConnection.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.webtrx_T11_expected_ban_pre_v". Cause: Query already resolved. [parser-2901050] [Log ID: 13d22e00-c2f4-4c0b-b7b3-964640943929] [jdbc-1906510]

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives