[castor-user] Problems with OQLQuery result set using MySQL 5.X?

[Michael Stabler]

Has anyone had a problem with invalid Types being sent to result sets from OQLQueries? I am using MySQL’s Connector/J 3.1.7.   When executing something like myResultSet = myOQLQuery.execute( ), I get an SQL exception nested in a PersistenceException. Generally, the SQL exception is being caused by an Invalid Type ‘246 returned for some integer-type fields.   This only happens when I execute the SQL statement via the OQLQuery. If I run the same command directly through the Connector, everything works fine. If I use MySQL’s command line, everything works fine. I haven’t tried it yet using the OQLQuery pass-through feature. Going to try that next just for confirmation.   Thanks in advance,   Michael Stabler Software Engineer [EMAIL PROTECTED] 202.863.3580 www.cssiinc.com