Hibernate: select informatio0_.资讯编号 as 资讯编号2_, informatio0_.信息类型1 as 信息类型2_2_, informatio0_.信息类型2 as 信息类型3_2_, informatio0_.信息标题 as 信息标题2_, informatio0_.信息图片 as 信息图片2_, informatio0_.发布人 as 发布人2_, informatio0_.发布日期 as 发布日期2_, informatio0_.信息内容 as 信息内容2_, informatio0_.上级类型 as 上级类型2_, informatio0_.点击率 as 点击率2_ from system.wz_information informatio0_ where informatio0_.信息类型2='服务信息' Hibernate: select user0_.用户编号 as 用户编号10_, user0_.用户名 as 用户名10_, user0_.密码 as 密码10_, user0_.姓名 as 姓名10_, user0_.角色编号 as 角色编号10_, user0_.地址 as 地址10_, user0_.状态 as 状态10_, user0_.创建日期 as 创建日期10_ from system.wz_user user0_ where user0_.用户名='system' and user0_.密码='system' Hibernate: select userrole0_.角色编号 as 角色编号13_0_, userrole0_.角色名称 as 角色名称13_0_, userrole0_.角色描述 as 角色描述13_0_, userrole0_.角色状态 as 角色状态13_0_ from system.wz_userrole userrole0_ where userrole0_.角色编号=? Hibernate: select sysrolerig0_.角色编号 as 角色编号1_, sysrolerig0_.权限编号 as 权限编号1_, userright1_.权限编号 as 权限编号11_0_, userright1_.权限父级编号 as 权限父级编号11_0_, userright1_.权限类型 as 权限类型11_0_, userright1_.权限 as 权限11_0_, userright1_.权限连接地址 as 权限连接地址11_0_, userright1_.权限描述 as 权限描述11_0_ from system.wz_role_right sysrolerig0_ left outer join system.userright userright1_ on sysrolerig0_.权限编号=userright1_.权限编号 where sysrolerig0_.角色编号=? 2010-4-12 13:15:48 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet action threw exception java.sql.SQLException: ORA-00933: SQL 命令未正确结束
javax.servlet.ServletException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not initialize a collection: [dw.entity.UserRole.sysRoleRights#125]; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [dw.entity.UserRole.sysRoleRights#125]
可能是 where sysrolerig0_.角色编号 = ? 出现的问题,楼主检查一下sql的最后的“?”是哪里来的。。
Hibernate: select user0_.用户编号 as 用户编号10_, user0_.用户名 as 用户名10_, user0_.密码 as 密码10_, user0_.姓名 as 姓名10_, user0_.角色编号 as 角色编号10_, user0_.地址 as 地址10_, user0_.状态 as 状态10_, user0_.创建日期 as 创建日期10_ from system.wz_user user0_ where user0_.用户名='system' and user0_.密码='system'
Hibernate: select userrole0_.角色编号 as 角色编号13_0_, userrole0_.角色名称 as 角色名称13_0_, userrole0_.角色描述 as 角色描述13_0_, userrole0_.角色状态 as 角色状态13_0_ from system.wz_userrole userrole0_ where userrole0_.角色编号=?
Hibernate: select sysrolerig0_.角色编号 as 角色编号1_, sysrolerig0_.权限编号 as 权限编号1_, userright1_.权限编号 as 权限编号11_0_, userright1_.权限父级编号 as 权限父级编号11_0_, userright1_.权限类型 as 权限类型11_0_, userright1_.权限 as 权限11_0_, userright1_.权限连接地址 as 权限连接地址11_0_, userright1_.权限描述 as 权限描述11_0_ from system.wz_role_right sysrolerig0_ left outer join system.userright userright1_ on sysrolerig0_.权限编号=userright1_.权限编号 where sysrolerig0_.角色编号=?
2010-4-12 13:15:48 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00933: SQL 命令未正确结束