Re: Stored procedures and prototypes problem
Re: Stored procedures and prototypes problem
- Subject: Re: Stored procedures and prototypes problem
- From: Chuck Hill <email@hidden>
- Date: Tue, 5 Feb 2008 09:37:15 -0800
On Feb 5, 2008, at 9:02 AM, Catarina Vieira Simoes wrote:
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.
Does it have a prototype?
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)
> Help/Unsubscribe/Update your Subscription:
> 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:
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