[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Problems after upgrading to 4.2.2 with MySQL and BLOB

[C-Box]

Hi,

we just upgraded our JBoss from 4.0.2 to 4.2.2.

Our MySQL is 5.0.51a --> all tables are INNODB because of transactions.

Within our database we do have a table that has two BLOB fields inside holding some binaries (one is a JRXML-file = JasperReportDesign-Object and one is the compiled design as as so called JASPER-file  = JasperReport-Object) and some other fields (varchar and integer).

'ID', 'int(11)', 'NO', 'PRI', '', ''
  | 'Bezeichnung', 'varchar(100)', 'YES', '', '', ''
  | 'Design', 'longblob', 'YES', '', '', ''
  | 'Report', 'longblob', 'YES', '', '', ''
  | 'BusinessObjectID', 'int(11)', 'YES', '', '', ''
  | 'ReportTyp', 'int(11)', 'YES', '', '', ''
  | 'AfpsLockID', 'int(11)', 'YES', '', '', ''
  | 'AfpsVersion', 'int(11)', 'YES', '', '', ''
  | 

We do use CMP logic.

The TypeMapping within standardjbosscmp.xml hasn't changed from 4.0.2 to 4.2.2 for the MySQL mapping:

for BLOB we always use:
 <mapping>
  |             <java-type>java.lang.Object</java-type>
  |             <jdbc-type>BLOB</jdbc-type>
  |             <sql-type>LONGBLOB</sql-type>           
  |          </mapping>

When I want to change one record within that table I get an exception, that says that the getInt method of the ResultSetImpl can't get an int from a field. I already created my own finder "findById" to not use the standard builtin findByPrimaryKey finder --> but without success - same error:

here is the finder:

  | <query>
  |         <query-method>
  |           <method-name>findById</method-name>
  |           <method-params>
  |             <method-param>java.lang.Integer</method-param>
  |           </method-params>
  |         </query-method>
  |         <ejb-ql>SELECT OBJECT(o) FROM DruckVorlageReport AS o WHERE o.id = ?1</ejb-ql>
  |       </query>


and here the exception:


  | 
  | 2008-05-05 10:25:47,104 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DruckVorlageReport#findById] Find failed
  | javax.ejb.EJBException: Internal error getting results for field member businessObjectID
  | at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:498)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:432)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand$EagerCollectionFactory.createCollection(JDBCAbstractQueryCommand.java:765)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:265)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:144)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:61)
  | 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:604)
  | 	at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:315)
  | 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:236)
  | 	at org.jboss.ejb.EntityContainer.findSingleObject(EntityContainer.java:1099)
  | 	at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:676)
  | ....
  | 
  | 
  | Caused by: java.sql.SQLException: Invalid value for getInt() - ' <?xml version="1.0" encoding="UTF-8"?>
  | 
  | ... here the whole content of the column "design" is shown what is the JRXML file stored in the BLOB column "design"
  | ....
  | 
  | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  | 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  | 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
  | 	at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2709)

the select statement that JBoss use seems to be okay:

2008-05-05 10:25:47,089 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.DruckVorlageReport#findById] Executing SQL: SELECT t0_o.ID, t0_o.Bezeichnung, t0_o.Design, t0_o.Report, t0_o.BusinessObjectID, t0_o.ReportTyp, t0_o.AfpsVersion, t0_o.AfpsLockID FROM druckvorlagereport t0_o WHERE (t0_o.ID = ?)

I already updated the mysql-driver to mysql-connector-java-5.1.6-bin.jar but without success.

Has anybody a glue what's going wrong?
If I use direct sql code with the connection to get a resultset it works like a charm, so I guess it can't be a driver problem.
Seems that JBoss trys to convert my blob field into an int to find the record... but why????

When I debug, I can see, that up to the call of the finder all arguments are correct (so no wrong input).

Would be nice to get some response.
regards from Germany

Christian

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4148593#4148593

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4148593