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 18:35:44 +0000
On 5 Feb 2008, at 17:37, Chuck Hill wrote:
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?
The model has a prototype, but there's no way (at least at the WOLips
interface level) to use the prototypes to define the stored procedure
attribute type. And that was one of my questions.
The other question has to do with that error message. I'm using
prototypes and set the database to Oracle and defined the stored
procedure with the appropriate Oracle types and still WO can't figure
out (I presume) at the adaptor level the JDBC type...
What am I doing wrong here?! :)
Catarina
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.registerAttributeForStoredProce
d
> ure(JDBCColumn.java:393)
> at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue
> (JDBCColumn.java:414)
> at
>
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBinding
s
> 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
--
http://velouria.org/writings
_______________________________________________
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