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] [Commented] (DERBY-2859) Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
Date Tue, 19 Nov 2013 18:47:21 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826797#comment-13826797
] 

Mano commented on DERBY-2859:
-----------------------------

I am still getting the same error. Please take a look. Can you also make sure my procedure
format is correct. I have also tried export_Query, same result. Please comment. Thanks.

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

> Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2859
>                 URL: https://issues.apache.org/jira/browse/DERBY-2859
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL, Tools
>    Affects Versions: 10.3.1.4
>            Reporter: Rick Hillegas
>            Priority: Minor
>              Labels: derby_triage10_5_2
>
> If you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE, you
get an error message telling you that SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE is an
unknown procedure. Instead, you should get an error message which tells you that the signature
can't be matched to a known overload of the procedure:
> ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
> (
>   'select * from lobtable where updateCount in( 2, 4 )',
>   'LOBTABLE',
>   '/export/home/rick/junk/test-export-table1.dat',
>   null,
>   null,
>   null,
>   '/export/home/rick/junk/test-export-query1-lobs.dat'
> );
> ERROR 42Y03: 'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message