[
https://issues.apache.org/jira/browse/DERBY-6418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826806#comment-13826806
]
Mano edited comment on DERBY-6418 at 11/19/13 6:54 PM:
-------------------------------------------------------
Hi Anders,
I tried upgrading to 10.3.1.4. It is giving me same error.
Mr. Rick Hillegas also suggested the same but something is still going wrong.
Please take a look. Thank you.
Apache Derby Network Server - 10.3.1.4 - (561794) started and ready to accept
connections on port 1527 at 2013-11-19 18:42:41.965 GMT
Exception in thread "main" java.sql.SQLSyntaxErrorException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.pari.db.DerbyConnection.<init>(DerbyConnection.java:95)
at com.pari.db.DerbyConnection.main(DerbyConnection.java:191)
Caused by: org.apache.derby.client.am.SqlException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepare(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 3 more
was (Author: mano.menam):
Hi Anders,
I tried to upgrading to 10.3.1.4. It is giving me same error.
Mr. Rick Hillegas also suggested the same but something is still going wrong.
Please take a look. Thank you.
Apache Derby Network Server - 10.3.1.4 - (561794) started and ready to accept
connections on port 1527 at 2013-11-19 18:42:41.965 GMT
Exception in thread "main" java.sql.SQLSyntaxErrorException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at com.pari.db.DerbyConnection.<init>(DerbyConnection.java:95)
at com.pari.db.DerbyConnection.main(DerbyConnection.java:191)
Caused by: org.apache.derby.client.am.SqlException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepare(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 3 more
> 'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE' is not recognized as a
> function or procedure
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-6418
> URL: https://issues.apache.org/jira/browse/DERBY-6418
> Project: Derby
> Issue Type: Bug
> Reporter: Mano
> Priority: Blocker
>
> I am using derby database. Using a prepared statement and executing. I dont
> have problem with non-BLOB field tables. If a table has a blob and trying to
> export to a file. Then this error comes. Please help me resolve it. I think I
> am not giving the statement properly. Please guide me. Attaching my code
> here. Thanks in advance.
> java.sql.PreparedStatement statement = connect.prepareStatement("CALL
> SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(?,?,?,?,?,?,?)");
> statement.setString(1, null);
> statement.setString(2, "xyz");
> statement.setString(3, "c:/derbytest/xyz.csv");
> statement.setString(4, null);
> statement.setString(5, null);
> statement.setString(6, null);
> statement.setString(7, "c:/derbytest/xyz.dat");
> statement.executeUpdate();
> statement.close();
> Here is the error: Caused by: org.apache.derby.client.am.SqlException:
> 'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE' is not recognized as a
> function or procedure. at
> org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at
> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
> Source) at
> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
> Source) at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown
> Source) at org.apache.derby.client.net.StatementReply.readPrepare(Unknown
> Source) at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown
> Source) at org.apache.derby.client.am.Statement.readPrepare(Unknown Source)
> at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown
> Source) at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
> Source) ... 3 more
--
This message was sent by Atlassian JIRA
(v6.1#6144)
