[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: JBoss 3.2.5 MySQL 4.0 finder Method gives a Finder Excep

[pintovc]

So I finally turned on the DEBUG and here is what I got in the detailed stack trace

20:55:31,324 DEBUG [UserProfile#findAll] Executing SQL: SELECT t0_o.id FROM UserProfile t0_o
20:55:31,324 DEBUG [LocalManagedConnectionFactory] Using properties: {user=root, password=--hidden--}
20:55:31,809 DEBUG [UserProfile#findAll] Find failed
java.sql.SQLException: null,  message from server: "Unknown column 't0_o.id' in 'field list'"
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:197)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:116)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:41)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:590)
	at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:332)
	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:322)
	at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:626)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)



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

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