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.registerAttributeForStoredProcedure(
JDBCColumn.java:393)
at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java
:414)
at
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute
(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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
