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

[Werner Guttmann]

Michael,

whilst I don't have any first-hand experience with mySQL 5.0 yet, can you please provide us with some sample code that shows what you are trying to achieve ?

Regards
Werner

--Original Message Text---
From: Michael Stabler
Date: Mon, 11 Apr 2005 15:23:06 -0400



Has anyone had a problem with invalid Types being sent to result sets from OQLQueries? I am using MySQLs 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 MySQLs command line, everything works fine. I havent 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