Re: calling sybase stored procedures

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

Abgeschickt von Fernando am 31 August, 2005 um 18:04:18

Antwort auf: Re: calling sybase stored procedures von Danko am 21 Juli, 2005 um 09:34:42:

Hi ! X)

I´ve the same problem with Stmt.getParameterMetaData(), I can´t access to stored Procedures with oracle 9.2.
Danko, Do you know the solution ?

Thank you mery much.

Cheers

: 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

Antworten:

Ihre Antwort

Name:
E-Mail:

Subject:

Text:
: Hi ! X) : I´ve the same problem with Stmt.getParameterMetaData(), I can´t access to stored Procedures with oracle 9.2. : Danko, Do you know the solution ? : Thank you mery much. : Cheers : : 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

Optionale URL:
Link Titel:
Optionale Bild-URL:

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