calling sybase stored procedures

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]

Abgeschickt von Andy Cooke am 20 Juli, 2005 um 18:54:19

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

Antworten:

Re: calling sybase stored procedures Danko 09:34:42 21/7/2005 (1)
- Re: calling sybase stored procedures Fernando 18:04:18 31/8/2005 (0)

Ihre Antwort

Name:
E-Mail:

Subject:

Text:
: 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

Optionale URL:
Link Titel:
Optionale Bild-URL:

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]