项目运行一个月了都很正常,今天登陆进去就报违反协议异常,不解,请各位赐教(在想,会不会是一些生僻字引起的?),异常如下
java.sql.SQLException:   违反协议 
at   oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java 
:124) 
at   oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java 
:161) 
at   oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:884) 
at   oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:132) 
at   oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:384) 
at   oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1 
035) 

解决方案 »

  1.   

    没遇到过这问题,网上查了查,供你参考:一是说字符编码出现了问题,所以报这异常,不过如果是简单的查询应该不会出现什么字符密码问题的。二说是驱动包有问题,所以换个驱动包,到ORACLE安装目录下,找到自带的JDBC驱动包,就是classes12.jar,再次运行
      

  2.   

    驱动问题吗?出现这种问题整个应用都挂掉了,重起应用就好了;之后专门压力测试问题也没再重现过
    再贴出异常:org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
    Caused by:
    org.hibernate.TransactionException: JDBC rollback failed
            at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
            at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:577)
            at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:631)
            at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:608)
            at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:328)
            at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
            at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
            at $Proxy50.getOprInfoByOprId(Unknown Source)
            at cmbq.console.struts.action.opr.ADMOPR0001.safeExecute(ADMOPR0001.java:95)
            at cmbq.console.struts.action.base.SafeAction.execute(SafeAction.java:83)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
            at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
            at com.huateng.filter.EncodeUtils.doFilter(EncodeUtils.java:30)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3242)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2010)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
    Caused by: java.sql.SQLException: 违反协议
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
            at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:150)
            at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:567)
            at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1145)
            at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
            at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
            ... 31 more