Hi All I'm trying a different approach at asking my question because it seems no-one has anything to say about ComplexType errors while using stored procedures:
Does anyone have a working example of using Castor with stored procedures to do a database select? I would like a decent example that I could work from to try figure out my original problem. (The offical documentation lacks on the topic of stored procs, and an internet search brings back little.) It would be great to have a copy of the working stored procedure as well so I can see if the issue is with the format. (And perhaps a copy of the mapping too.) Thanks Dagmar ----Original Message----- From: Dagmar Timler [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 01:54 To: [EMAIL PROTECTED] Subject: [castor-dev] stored procedures & "Complex type not accepted!" exception 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 ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
