org.hibernate.exception.SQLGrammarException: could not execute query
com.dbwen.system.service.impl.ProviderServiceImpl.getProvider(ProviderServiceImpl.java:26)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy5.getProvider(Unknown Source)
com.dbwen.system.web.action.ProviderAction.provider(ProviderAction.java:96)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(
org.hibernate.exception.SQLGrammarException: could not execute...
这是个sql语法错误 错误在你ProviderServiceImpl类的getProvider方法中，26行，你把那前后几行的代码贴出来，不然看不出错误
org.hibernate.exception.SQLGrammarException: could not execute...
1，直接看，应该是你拼时间的时候出错了，你不要直接把时间拼到HQL里面，使用?占位符，使用query.setParameter方法来设置参数值试试；2，HQL是不能直接在数据库里面直接运行的。
org.hibernate.exception.SQLGrammarException: could not execute...
这是我的配置信息，你可以参考下 <property name="hibernate.query.factory_class"> org.hibernate.hql.classic.ClassicQueryTranslatorFactory <\/property> <property name="connection.username">jkems<\/property> <property name="connection.url"> jdbc:oracle:thin:@192.168.5.245:1521:oracle ...
org.hibernate.exception.SQLGrammarException: could not execute...
email表的annex是非基本数据类型，不能select进行查询
org.hibernate.exception.SQLGrammarException: could not execute...
这个应该是hibernate打印的sql语句，只看这个看不出问题，还得看你代码里面的hql语句。
...org.hibernate.exception.SQLGrammarException: could not execute...
"DZJC_SYS_PKG"."GETSJHM" 这2个是字段，还是TBL名？应该是你的映射文件有问题，或者，数据库定义的TBL名OR字段名无法匹配。
运行flex查看网页时,
org.hibernate.exception.SQLGrammarException : could not execute query 查询语句有问题
org.hibernate.exception.SQLGrammarException: could not execute...
from Userinfo where username='abc'试试
org.hibernate.exception.SQLGrammarException: could not execute...
你会不会是在这个customer类里定义了变量是其他类的外键，然后在其他类里和这个类里的这个变量类型不一样啊！？
org.hibernate.exception.SQLGrammarException: could not execute...
z这么明显的提示SQLGrammarException不去找 String hql="from User where userName="+user.getUserName()+" and userPassword="+user.getUserPassword()";
