Re: Stored procedures and prototypes problem
Re: Stored procedures and prototypes problem
- Subject: Re: Stored procedures and prototypes problem
- From: "Catarina Vieira Simoes" <email@hidden>
- Date: Tue, 5 Feb 2008 17:02:29 +0000
Hi Chuck,
Thanks for your email. :)
spName is the name of the output argument of the stored procedure.
In the model is defined as an attribute of the stored procedure entity and its external type is Number in Oracle (and integer in Postgres). its data type is Integer.
In the code it is a Number and it's added to the arguments dictionary (NSMutableDictionary) used by the method executeStoredProcedureNamed().
Catarina
On 05/02/2008, Chuck Hill <email@hidden> wrote:
What is spName? How is it defined?
On Feb 5, 2008, at 8:11 AM, Catarina Vieira Simoes wrote:
> Hi!
>
> The project I'm working on has a model which uses 2 prototypes to
> connect alternately and not at the same time to a postgresql db and
> to an oracle db (basically we have 2 different servers running the
> same application and one connects to an oracle db and the other to
> a posgresql db).
> I added a couple of stored procedures to the model and I was
> wondering if the prototypes are used as well to define the stored
> procedure external types. Or do I have to create different versions
> of the same stored procedure entity to each of the databases I'm
> using?
>
> Anyway, when I configure the application to use the Oracle
> database, set the stored procedures external types to Oracle types
> and call the stored procedure I get the following error:
>
> com.webobjects.jdbcadaptor.JDBCAdaptorException: Unable to
> determine JDBC type for attribute 'spName' when preparing ouput
> paramater for stored procedure.
> at
> com.webobjects.jdbcadaptor.JDBCColumn.registerAttributeForStoredProced
> ure(JDBCColumn.java:393)
> at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue
> (JDBCColumn.java:414)
> at
> com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindings
> AndExecute(JDBCChannel.java:224)
> at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression
> (JDBCChannel.java:297)
> at com.webobjects.jdbcadaptor.JDBCChannel.executeStoredProcedure
> (JDBCChannel.java:1294)
> at
> com.webobjects.eoaccess.EOUtilities._executeStoredProcedureNamed
> (EOUtilities.java:728)
> at
> com.webobjects.eoaccess.EOUtilities.executeStoredProcedureNamed
> (EOUtilities.java:695)
>
> The same thing happens when using the Postgresql and the
> appropriate psql types as the stored procedure external types.
> Any ideas about what's going on?
>
> Thank you in advance.
>
> Catarina
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> 40global-village.net
>
> This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden