db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mano (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6418) 'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE' is not recognized as a function or procedure
Date Tue, 19 Nov 2013 05:53:23 GMT
Mano created DERBY-6418:
---------------------------

             Summary: '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)

Mime
View raw message