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.
I suggest you to fill up an enhancement request too at: <https://
bugreport.apple.com/>.
--
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
