hibernate+jsf+spring+sql server2000
Dao里面public List findMain(String zlqx) {
//zlqx = "ab";
log.debug("finding HhzlApplyMain instance with value: " + zlqx);
try {
String userName = CurrentUser.getUserName();
String queryString = "from HhzlApplyMain as model where model.flag "
+ " in ('"+ zlqx + "') and model.id.id='A1001000007' and exists (select 1 from Opship as TOS where TOS.id.shipid = model.id.shipid and TOS.id.opname='"
+ userName +"')";
//
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
执行到:getHibernateTemplate().find(queryString);的时候报错16:04:28,906 INFO TrimString:132 - could not read column value from result set: shipid46_; [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
16:04:28,906 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: HY010
16:04:28,906 ERROR JDBCExceptionReporter:72 - [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
16:04:28,953 INFO XmlBeanDefinitionReader:303 - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
16:04:29,015 INFO SQLErrorCodesFactory:128 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
16:04:29,046 ERROR HhzlApplyMainDaoImpl:91 - find by property name failed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select hhzlapplym0_.shipid as shipid46_, hhzlapplym0_.id as id46_, hhzlapplym0_.yqgcdd as yqgcdd46_, hhzlapplym0_.sqr as sqr46_, hhzlapplym0_.sqrq as sqrq46_, hhzlapplym0_.czqm as czqm46_, hhzlapplym0_.czqmrq as czqmrq46_, hhzlapplym0_.ysqm as ysqm46_, hhzlapplym0_.ysrq as ysrq46_, hhzlapplym0_.flag as flag46_, hhzlapplym0_.a_shyj as a11_46_, hhzlapplym0_.a_shqm as a12_46_, hhzlapplym0_.a_qmrq as a13_46_, hhzlapplym0_.b_shyj as b14_46_, hhzlapplym0_.b_shqm as b15_46_, hhzlapplym0_.b_qmrq as b16_46_, hhzlapplym0_.scbm as scbm46_, hhzlapplym0_.jcrq as jcrq46_, hhzlapplym0_.scdd as scdd46_, hhzlapplym0_.yjrq as yjrq46_, hhzlapplym0_.gcfs as gcfs46_, hhzlapplym0_.ghfs as ghfs46_, hhzlapplym0_.ysyj as ysyj46_, hhzlapplym0_.inoutflag as inoutflag46_, hhzlapplym0_.sqyy as sqyy46_ from pms_db_test.dbo.hhzl_apply_main hhzlapplym0_ where (hhzlapplym0_.flag in ('00')) and hhzlapplym0_.id='A1001000007' and (exists (select 1 from opship opship1_ where opship1_.shipid=hhzlapplym0_.shipid and opship1_.opname='Administrator'))]; SQL state [HY010]; error code [0]; [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
Dao里面public List findMain(String zlqx) {
//zlqx = "ab";
log.debug("finding HhzlApplyMain instance with value: " + zlqx);
try {
String userName = CurrentUser.getUserName();
String queryString = "from HhzlApplyMain as model where model.flag "
+ " in ('"+ zlqx + "') and model.id.id='A1001000007' and exists (select 1 from Opship as TOS where TOS.id.shipid = model.id.shipid and TOS.id.opname='"
+ userName +"')";
//
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
执行到:getHibernateTemplate().find(queryString);的时候报错16:04:28,906 INFO TrimString:132 - could not read column value from result set: shipid46_; [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
16:04:28,906 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: HY010
16:04:28,906 ERROR JDBCExceptionReporter:72 - [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
16:04:28,953 INFO XmlBeanDefinitionReader:303 - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
16:04:29,015 INFO SQLErrorCodesFactory:128 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
16:04:29,046 ERROR HhzlApplyMainDaoImpl:91 - find by property name failed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select hhzlapplym0_.shipid as shipid46_, hhzlapplym0_.id as id46_, hhzlapplym0_.yqgcdd as yqgcdd46_, hhzlapplym0_.sqr as sqr46_, hhzlapplym0_.sqrq as sqrq46_, hhzlapplym0_.czqm as czqm46_, hhzlapplym0_.czqmrq as czqmrq46_, hhzlapplym0_.ysqm as ysqm46_, hhzlapplym0_.ysrq as ysrq46_, hhzlapplym0_.flag as flag46_, hhzlapplym0_.a_shyj as a11_46_, hhzlapplym0_.a_shqm as a12_46_, hhzlapplym0_.a_qmrq as a13_46_, hhzlapplym0_.b_shyj as b14_46_, hhzlapplym0_.b_shqm as b15_46_, hhzlapplym0_.b_qmrq as b16_46_, hhzlapplym0_.scbm as scbm46_, hhzlapplym0_.jcrq as jcrq46_, hhzlapplym0_.scdd as scdd46_, hhzlapplym0_.yjrq as yjrq46_, hhzlapplym0_.gcfs as gcfs46_, hhzlapplym0_.ghfs as ghfs46_, hhzlapplym0_.ysyj as ysyj46_, hhzlapplym0_.inoutflag as inoutflag46_, hhzlapplym0_.sqyy as sqyy46_ from pms_db_test.dbo.hhzl_apply_main hhzlapplym0_ where (hhzlapplym0_.flag in ('00')) and hhzlapplym0_.id='A1001000007' and (exists (select 1 from opship opship1_ where opship1_.shipid=hhzlapplym0_.shipid and opship1_.opname='Administrator'))]; SQL state [HY010]; error code [0]; [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:847)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:839)
at com.oceanus.navigate.dao.impl.HhzlApplyMainDaoImpl.findMain(HhzlApplyMainDaoImpl.java:89)
at com.oceanus.navigate.service.impl.HhzlApplyMainServiceImpl.findMain(HhzlApplyMainServiceImpl.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy27.findMain(Unknown Source)
at com.oceanus.navigate.view.bean.HhzlApplyFirstBean.getMainAll(HhzlApplyFirstBean.java:84)
at com.oceanus.navigate.view.bean.HhzlApplyFirstBean.init(HhzlApplyFirstBean.java:54)
at com.oceanus.common.view.bean.BaseBean.setServiceLocator(BaseBean.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at javax.el.BeanELResolver.setValue(BeanELResolver.java:108)
at javax.el.CompositeELResolver.setValue(CompositeELResolver.java:68)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$501(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$6.invoke(FacesCompositeELResolver.java:132)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.invoke(FacesCompositeELResolver.java:148)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.setValue(FacesCompositeELResolver.java:128)
at org.apache.myfaces.config.ManagedBeanBuilder.initializeProperties(ManagedBeanBuilder.java:256)
at org.apache.myfaces.config.ManagedBeanBuilder.buildManagedBean(ManagedBeanBuilder.java:88)
at org.apache.myfaces.el.unified.resolver.ManagedBeanResolver.createManagedBean(ManagedBeanResolver.java:196)
at org.apache.myfaces.el.unified.resolver.ManagedBeanResolver.getValue(ManagedBeanResolver.java:162)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$301(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$4.invoke(FacesCompositeELResolver.java:108)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.invoke(FacesCompositeELResolver.java:148)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:104)
at org.apache.myfaces.el.VariableResolverImpl.resolveVariable(VariableResolverImpl.java:61)
at org.apache.myfaces.el.convert.VariableResolverToELResolver.getValue(VariableResolverToELResolver.java:93)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$301(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$4.invoke(FacesCompositeELResolver.java:108)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:104)
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:61)
at org.apache.el.parser.AstValue.getValue(AstValue.java:107)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIOutput.getValue(UIOutput.java:68)
at org.apache.myfaces.shared_impl.renderkit.RendererUtils.getValue(RendererUtils.java:327)
at org.apache.myfaces.shared_impl.renderkit.RendererUtils.getStringValue(RendererUtils.java:275)
at org.apache.myfaces.renderkit.html.HtmlHiddenRenderer.encodeEnd(HtmlHiddenRenderer.java:55)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:556)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:250)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:246)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:246)
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.actuallyRenderView(JspViewHandlerImpl.java:423)
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:380)
at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:189)
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:140)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:152)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:256)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:362)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:488)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.oceanus.common.filter.PmsFilter.doFilter(PmsFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
at org.hibernate.type.StringType.get(StringType.java:18)
at com.oceanus.common.data.TrimString.get(TrimString.java:12)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.type.ComponentType.hydrate(ComponentType.java:506)
at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:229)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:554)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:856)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
... 83 more
16:04:29,062 ERROR HhzlApplyMainServiceImpl:64 - Could not find getNavigateCompanyList()
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select hhzlapplym0_.shipid as shipid46_, hhzlapplym0_.id as id46_, hhzlapplym0_.yqgcdd as yqgcdd46_, hhzlapplym0_.sqr as sqr46_, hhzlapplym0_.sqrq as sqrq46_, hhzlapplym0_.czqm as czqm46_, hhzlapplym0_.czqmrq as czqmrq46_, hhzlapplym0_.ysqm as ysqm46_, hhzlapplym0_.ysrq as ysrq46_, hhzlapplym0_.flag as flag46_, hhzlapplym0_.a_shyj as a11_46_, hhzlapplym0_.a_shqm as a12_46_, hhzlapplym0_.a_qmrq as a13_46_, hhzlapplym0_.b_shyj as b14_46_, hhzlapplym0_.b_shqm as b15_46_, hhzlapplym0_.b_qmrq as b16_46_, hhzlapplym0_.scbm as scbm46_, hhzlapplym0_.jcrq as jcrq46_, hhzlapplym0_.scdd as scdd46_, hhzlapplym0_.yjrq as yjrq46_, hhzlapplym0_.gcfs as gcfs46_, hhzlapplym0_.ghfs as ghfs46_, hhzlapplym0_.ysyj as ysyj46_, hhzlapplym0_.inoutflag as inoutflag46_, hhzlapplym0_.sqyy as sqyy46_ from pms_db_test.dbo.hhzl_apply_main hhzlapplym0_ where (hhzlapplym0_.flag in ('00')) and hhzlapplym0_.id='A1001000007' and (exists (select 1 from opship opship1_ where opship1_.shipid=hhzlapplym0_.shipid and opship1_.opname='Administrator'))]; SQL state [HY010]; error code [0]; [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:847)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:839)
at com.oceanus.navigate.dao.impl.HhzlApplyMainDaoImpl.findMain(HhzlApplyMainDaoImpl.java:89)
at com.oceanus.navigate.service.impl.HhzlApplyMainServiceImpl.findMain(HhzlApplyMainServiceImpl.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy27.findMain(Unknown Source)
at com.oceanus.navigate.view.bean.HhzlApplyFirstBean.getMainAll(HhzlApplyFirstBean.java:84)
at com.oceanus.navigate.view.bean.HhzlApplyFirstBean.init(HhzlApplyFirstBean.java:54)
at com.oceanus.common.view.bean.BaseBean.setServiceLocator(BaseBean.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at javax.el.BeanELResolver.setValue(BeanELResolver.java:108)
at javax.el.CompositeELResolver.setValue(CompositeELResolver.java:68)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$501(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$6.invoke(FacesCompositeELResolver.java:132)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.invoke(FacesCompositeELResolver.java:148)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.setValue(FacesCompositeELResolver.java:128)
at org.apache.myfaces.config.ManagedBeanBuilder.initializeProperties(ManagedBeanBuilder.java:256)
at org.apache.myfaces.config.ManagedBeanBuilder.buildManagedBean(ManagedBeanBuilder.java:88)
at org.apache.myfaces.el.unified.resolver.ManagedBeanResolver.createManagedBean(ManagedBeanResolver.java:196)
at org.apache.myfaces.el.unified.resolver.ManagedBeanResolver.getValue(ManagedBeanResolver.java:162)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$301(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$4.invoke(FacesCompositeELResolver.java:108)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.invoke(FacesCompositeELResolver.java:148)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:104)
at org.apache.myfaces.el.VariableResolverImpl.resolveVariable(VariableResolverImpl.java:61)
at org.apache.myfaces.el.convert.VariableResolverToELResolver.getValue(VariableResolverToELResolver.java:93)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.access$301(FacesCompositeELResolver.java:46)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver$4.invoke(FacesCompositeELResolver.java:108)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.invoke(FacesCompositeELResolver.java:148)
at org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:104)
at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:61)
at org.apache.el.parser.AstValue.getValue(AstValue.java:107)
at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIOutput.getValue(UIOutput.java:68)
at org.apache.myfaces.shared_impl.renderkit.RendererUtils.getValue(RendererUtils.java:327)
at org.apache.myfaces.shared_impl.renderkit.RendererUtils.getStringValue(RendererUtils.java:275)
at org.apache.myfaces.renderkit.html.HtmlHiddenRenderer.encodeEnd(HtmlHiddenRenderer.java:55)
下面这句中的1有问题,你改成*试试
select 1 from Opship as TOS where TOS.id.shipid = model.id.shipid and TOS.id.opname='"
sql文执行肯定没有问题,而且错误的不止一本程序,以前测试没有问题的程序有的也出现了这个问题。
还有如果执行无法查出数据,就可以正常执行了,怀疑是这几个表的xml映射文件有问题,因为有的就可以正常执行。
解决方法:这是老板的jdbc驱动的问题,你更换新版的sqljdbc 的驱动就行了。 jdbc 3.0的.
具体使用,看这个常用数据库的链接方法