mysql syntaxerror_MySQLSyntaxErrorException 的问题

Hibernate: select category2x0_.id as id0_0_, category2x0_.en_name as en2_0_0_, category2x0_.cn_name as cn3_0_0_ from t1 category2x0_ where category2x0_.id=?

Hibernate: select subcategor0_.parent_id as parent1_1_, subcategor0_.t1 as t4_1_, subcategor0_.turn as turn1_, category2x1_.id as id0_0_, category2x1_.en_name as en2_0_0_, category2x1_.cn_name as cn3_0_0_ from t11 subcategor0_ left outer join t1 category2x1_ on subcategor0_.t1=category2x1_.id where subcategor0_.parent_id=?

Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not initialize a collection: [cn.nefu.pojo.Category2.subCategorys#1]

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)

at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)

at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)

at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)

at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)

at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)

at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:755)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:229)

at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)

at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:47)

at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:41)

at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)

at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)

at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)

at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)

at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:177)

at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)

at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)

at org.hibernate.impl.SessionImpl.get(SessionImpl.java:799)

at org.hibernate.impl.SessionImpl.get(SessionImpl.java:792)

at cn.nefu.dao.CategoryDao2.findCategoriesById(CategoryDao2.java:15)

at cn.nefu.dao.CategoryDao2.main(CategoryDao2.java:21)

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'subcategor0_.t1' in 'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)

at org.hibernate.loader.Loader.doQuery(Loader.java:662)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)

... 21 more

这异常是什么意思啊。怎么解决啊。

还有最后那行...21 more  怎么让他显示完全啊。。。。显示完全有用吗？

2010年4月20日 14:58