Re: Stored procedures and prototypes problem
Re: Stored procedures and prototypes problem
- Subject: Re: Stored procedures and prototypes problem
- From: Francis Labrie <email@hidden>
- Date: Tue, 5 Feb 2008 12:50:47 -0500
Hi,
Catarina Vieira Simoes wrote: 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. [...]
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?
Unfortunately, EOPrototypes are not supported for stored procedure (up to WebObject 5.3, maybe 5.4 as well). :-( I've already send enhancement requests (rdar://4421477 and rdar://5084090) to get this support in WebObjects two year ago.
-- Francis Labrie Saint-Bruno-de-Montarville, Quebec, Canada |
_______________________________________________
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