[
https://issues.apache.org/jira/browse/DERBY-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13827020#comment-13827020
]
Mano commented on DERBY-2859:
-----------------------------
Hi Rick,
It is not working for datatype BLOB. I have tried the same example with blob
type. It gives me same error.
My code:
Connection conn = DriverManager.getConnection(
"jdbc:derby:db;" );
conn.prepareStatement( "create table t( a int, b blob )"
).execute();
PreparedStatement ps = conn.prepareStatement( "insert into t
values ( ?, ? )" );
ps.setInt( 1, 1 );
File image = new File("C:/Users/mmenam/Desktop/Menam.png");
byte[] imageData = new byte[(int) image.length()];
ps.setBlob(2, new SerialBlob(imageData));
ps.execute();
ps.close();
PreparedStatement ps2 = conn.prepareStatement("CALL
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE( ?,?,?,?,?,?,? )" );
It is throwing exception from this line itself.
CLOB is working for me too. I am only using BLOB(large/medium). Thanks for your
time.
> 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)
