用过 ssh 框架结构的请进,急死了,球赛看完了,还没有搞懂配置问题。

datastore 2006-06-13 06:35:50
用的是 struts+spring+hibernate3 不知道是哪儿错了 贴出来让大家看看。谢谢各位了。
数据库是 sql server.
郁闷呀,那位帮帮小弟。先谢谢了。
告诉我帖子太长了。我分三段来写,主要把log详细的让大家帮助研究下。

Users.hbm.xml-----
<hibernate-mapping package="com.hibernate">

<class name="Users" table="users">
<id name="id" column="ID" type="java.lang.Integer">
<generator class="identity"/>
</id>

<property name="username" column="USERNAME" type="java.lang.String" not-null="true" />
<property name="password" column="PASSWORD" type="java.lang.String" not-null="true" />
</class>
---------------------------------
这是配置
</hibernate-mapping>


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"></ref>
</property>
<property name="mappingResources">
<list>
<value>com/hibernate/Users.hbm.xml</value>
<value>com/hibernate/User.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>

</bean>

这是错误的log


06-06-13 06:09:02,234 DEBUG TransactionSynchronizationManager( 137 ) - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@8e753c] for key [org.hibernate.impl.SessionFactoryImpl@b2db5b] bound to thread [http-8080-Processor25]
06-06-13 06:09:02,234 DEBUG TransactionSynchronizationManager( 137 ) - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@8e753c] for key [org.hibernate.impl.SessionFactoryImpl@b2db5b] bound to thread [http-8080-Processor25]
06-06-13 06:09:02,234 DEBUG HibernateTemplate( 358 ) - Found thread-bound Session for HibernateTemplate
06-06-13 06:09:02,250 DEBUG QueryPlanCache( 69 ) - unable to locate HQL query plan in cache; generating ( from users as users )
06-06-13 06:09:02,625 DEBUG QueryTranslatorImpl( 236 ) - parse() - HQL: from users as users
06-06-13 06:09:02,687 DEBUG AST( 252 ) - --- HQL AST ---
\-[QUERY] 'query'
\-[SELECT_FROM] 'SELECT_FROM'
\-[FROM] 'from'
\-[RANGE] 'RANGE'
+-[IDENT] 'users'
\-[ALIAS] 'users'

06-06-13 06:09:02,687 DEBUG ErrorCounter( 68 ) - throwQueryException() : no errors
06-06-13 06:09:02,906 DEBUG HqlSqlBaseWalker( 111 ) - select << begin [level=1, statement=select]
06-06-13 06:09:03,000 DEBUG HibernateTemplate( 382 ) - Not closing pre-bound Hibernate Session after HibernateTemplate
06-06-13 06:09:03,000 DEBUG RuleBasedTransactionAttribute( 119 ) - Applying rules to determine whether transaction should rollback on org.springframework.orm.hibernate3.HibernateQueryException: users is not mapped. [ from users as users ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users as users ]
06-06-13 06:09:03,000 DEBUG RuleBasedTransactionAttribute( 137 ) - Winning rollback rule is: null
06-06-13 06:09:03,000 DEBUG RuleBasedTransactionAttribute( 143 ) - No relevant rollback rule found: applying superclass default
06-06-13 06:09:03,000 DEBUG TransactionInterceptor( 280 ) - Invoking rollback for transaction on sonic.service.UsersManager.findAllUsers due to throwable [org.springframework.orm.hibernate3.HibernateQueryException: users is not mapped. [ from users as users ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users as users ]]
06-06-13 06:09:03,000 DEBUG HibernateTransactionManager( 673 ) - Triggering beforeCompletion synchronization
06-06-13 06:09:03,000 DEBUG HibernateTransactionManager( 581 ) - Initiating transaction rollback
06-06-13 06:09:03,000 DEBUG HibernateTransactionManager( 599 ) - Rolling back Hibernate transaction on Session [org.hibernate.impl.SessionImpl@1be8bf1]
06-06-13 06:09:03,000 DEBUG JDBCTransaction( 152 ) - rollback
06-06-13 06:09:03,031 DEBUG JDBCTransaction( 193 ) - re-enabling autocommit
06-06-13 06:09:03,031 DEBUG JDBCTransaction( 163 ) - rolled back JDBC Connection
06-06-13 06:09:03,031 DEBUG JDBCContext( 199 ) - after transaction completion
06-06-13 06:09:03,031 DEBUG ConnectionManager( 296 ) - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
06-06-13 06:09:03,031 DEBUG SessionImpl( 417 ) - after transaction completion
06-06-13 06:09:03,031 DEBUG HibernateTransactionManager( 697 ) - Triggering afterCompletion synchronization
06-06-13 06:09:03,031 DEBUG TransactionSynchronizationManager( 265 ) - Clearing transaction synchronization
06-06-13 06:09:03,031 DEBUG TransactionSynchronizationManager( 185 ) - Removed value [org.springframework.orm.hibernate3.SessionHolder@8e753c] for key [org.hibernate.impl.SessionFactoryImpl@b2db5b] from thread [http-8080-Processor25]
06-06-13 06:09:03,046 DEBUG TransactionSynchronizationManager( 185 ) - Removed value [org.springframework.jdbc.datasource.ConnectionHolder@1e867d6] for key [org.springframework.jdbc.datasource.DriverManagerDataSource@ccc621] from thread [http-8080-Processor25]
06-06-13 06:09:03,046 DEBUG DataSourceUtils( 201 ) - Resetting read-only flag of JDBC Connection [com.microsoft.jdbc.sqlserver.SQLServerConnection@a00fd]
06-06-13 06:09:03,046 DEBUG HibernateTransactionManager( 659 ) - Closing Hibernate Session [org.hibernate.impl.SessionImpl@1be8bf1] after transaction
06-06-13 06:09:03,046 DEBUG SessionFactoryUtils( 785 ) - Closing Hibernate Session
06-06-13 06:09:03,046 DEBUG SessionImpl( 268 ) - closing session
06-06-13 06:09:03,046 DEBUG ConnectionManager( 374 ) - performing cleanup
06-06-13 06:09:03,046 DEBUG ConnectionManager( 435 ) - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
06-06-13 06:09:03,062 DEBUG JDBCExceptionReporter( 40 ) - SQL Warning
java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to myData
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.get(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getWarnings(Unknown Source)
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:22)
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:443)
at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:379)
at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:318)
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:293)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doClose(SessionFactoryUtils.java:787)
at org.springframework.orm.hibernate3.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:775)
at org.springframework.orm.hibernate3.SessionFactoryUtils.releaseSession(SessionFactoryUtils.java:748)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:662)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:615)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:560)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:284)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
...全文
1010 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
pigo 2006-06-13
  • 打赏
  • 举报
回复
你的hql有问题:

from users as users

改成-->

from com.hibernate.Users as users

form后面跟的是个完整的类名,包括package.

datastore 2006-06-13
  • 打赏
  • 举报
回复
问题2 当我用user 表的时候,同样的代码出现的错误是:
---更加郁闷。 两个问题同样的代码错误现象不同,
------------------到底是什么问题呀?

javax.servlet.ServletException: unexpected token: [ near line 1, column 7 [ from [user] as u ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: [ near line 1, column 7 [ from [user] as u ]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: [ near line 1, column 7 [ from [user] as u ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: [ near line 1, column 7 [ from [user] as u ]
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:652)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:413)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
sonic.DAO.impl.UserDAOImpl.findAllUser(UserDAOImpl.java:53)
sonic.service.impl.UserManagerImpl.findAllUser(UserManagerImpl.java:24)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
$Proxy5.findAllUser(Unknown Source)
sonic.LoginAction.execute(LoginAction.java:40)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
datastore 2006-06-13
  • 打赏
  • 举报
回复
接上
06-06-13 06:09:03,078 WARN JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to myData
06-06-13 06:09:03,078 WARN JDBCExceptionReporter( 48 ) - SQL Warning: 5701, SQLState: 01000
06-06-13 06:09:03,078 WARN JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'myData'。
06-06-13 06:09:03,093 WARN JDBCExceptionReporter( 48 ) - SQL Warning: 0, SQLState:
06-06-13 06:09:03,109 WARN JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
06-06-13 06:09:03,109 WARN JDBCExceptionReporter( 48 ) - SQL Warning: 5703, SQLState: 01000
06-06-13 06:09:03,109 WARN JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将语言设置改为 简体中文。
06-06-13 06:09:03,109 DEBUG JDBCContext( 199 ) - after transaction completion
06-06-13 06:09:03,109 DEBUG ConnectionManager( 296 ) - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
06-06-13 06:09:03,125 DEBUG SessionImpl( 417 ) - after transaction completion
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 134 ) - getMessage(zh_CN,unhandledException)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 226 ) - loadLocale(zh_CN)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 248 ) - Loading resource 'org/apache/struts/action/ActionResources_zh_CN.properties'
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 273 ) - Loading resource completed
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 226 ) - loadLocale(zh)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 248 ) - Loading resource 'org/apache/struts/action/ActionResources_zh.properties'
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 273 ) - Loading resource completed
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 226 ) - loadLocale()
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 248 ) - Loading resource 'org/apache/struts/action/ActionResources.properties'
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 273 ) - Loading resource completed
.......
06-06-13 06:09:03,203 DEBUG PropertyMessageResources( 286 ) - Saving message key '.verifyMessageResourcesConfigs.invalid
06-06-13 06:09:03,203 WARN RequestProcessor( 509 ) - Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateQueryException
06-06-13 06:09:03,218 ERROR [action]( 253 ) - Servlet.service() for servlet action threw exception
org.springframework.orm.hibernate3.HibernateQueryException: users is not mapped. [ from users as users ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users as users ]
org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users as users ]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:157)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:265)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3049)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2938)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:846)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
at sonic.DAO.impl.UsersDAOImpl.findAllUsers(UsersDAOImpl.java:53)
at sonic.service.impl.UsersManagerImpl.findAllUsers(UsersManagerImpl.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)

67,512

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧