Hi

I am trying to get an example using Castor up and running and am having
problems using stored procedures.  (I get
org.exolab.castor.jdo.PersistenceException: Complex type not accepted!
exception)

When I try run a select stored procedure (that takes the id as the parameter
and returns all the fields specifically named), it bombs when I call
hasMore() on the QueryResult returned.

[snip]
//OQLQuery gameOql = db.getOQLQuery("select g from game.Game g where
gameID=$1");
OQLQuery gameOql = db.getOQLQuery("CALL procSelGame($1) AS game.Game");
QueryResults results = gameOql.execute();
while (results.hasMore()) {
 // ....
}
[snip]

The strange thing is that the first OQL returns the correct results (using
the select oql instead of the stored proc).

I suspected this might also have something to do with the mapping of my
database and objects, but none of the field mappings include any complex
types (only integers and strings).

Has anyone else experienced this, or could give me any pointers on what to
do to solve this problem?

Thanks
Dagmar.

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to