Abgeschickt von Danko am 21 Juli, 2005 um 09:34:42:
Antwort auf: calling sybase stored procedures von Andy Cooke am 20 Juli, 2005 um 18:54:19:
Hi,
JDBCLogger.append() (line 568) with the exception should not be executed in procedure configuration. Are you sure you have set the procedure parameter to something other than null?
Each parameter of the sproc must be supplied. This has nothing to do with the actual table.
Hope that helps.
Danko
: Hi Danko,
: I've been trying to use the JDBCAppender in conjunction with a stored procedure I've written that is in our sybase db.
: The sproc expects all but the id field in the table - rather than accepting this from the caller, it works out its own unique id.
: When I try calling the sproc (setting up the Appender programmatically, rather than using an xml config file) I hit a couple of problems:
: 1) I get the error message:
: "The moveToInsertRow() method is not supported for ResultSets of type CONCUR_READ_ONLY."
: which is thrown by JDBCLogger.append() (line 568). Is the Logger expecting something that our jdbc driver (jconnect5.2) isn't set up for? Is there a work around for this, short of altering the JDBCLogger source?
: 2) I'm not sure how to call the sproc with particular parameters - the appender seems to expect that the sproc will be called with parameters that match the column names of the table, and that all columns should be supplied - any idea how I can customise this?
: thanks for any tips you can give,
: cheers,
: Andy Cooke