这是什么错误，程序连接另一个oracle，运行正常，换了一个oracle就报错了。

2021-03-02 15:33:36,482 [471304833@qtp-897422675-2] ERROR 500.jsp

-PreparedStatementCallback; SQL [select u.uuid u.account,u.deptId,u.authName,u.passwd,u.authother2,u.authother1,u.birthday,u.phone,u.authother0,u.isValid,u.sso,u.caImage,u.deptCodeTree,u.usertype userType,u.deptCode,u.deptId,d.authName deptName,(SELECT count(1) FROM AUTH_USERDEPT WHERE USERID=u.uuid) scope from AUTH_MODEL_USER u left join AUTH_MODEL_DEPT d on u.deptCode=d.AUTHOTHER0 where upper(u.account)=?]; IO 错误: Unexpected packet; nested exception is java.sql.SQLException: IO 错误: Unexpected packet
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select u.uuid id,u.account,u.deptId,u.authName,u.passwd,u.authother2,u.authother1,u.birthday,u.phone,u.authother0,u.isValid,u.sso,u.caImage,u.deptCodeTree,u.usertype userType,u.deptCode,u.deptId,d.authName deptName,(SELECT count(1) FROM AUTH_USERDEPT WHERE USERID=u.uuid) scope from AUTH_MODEL_USER u left join AUTH_MODEL_DEPT d on u.deptCode=d.AUTHOTHER0 where upper(u.account)=?]; IO 错误: Unexpected packet; nested exception is java.sql.SQLException: IO 错误: Unexpected packet
   at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
   at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:733)
   at com.vingsoft.jsec.cac.service.security.JsecServiceDBImpl.getUserByLoginName(JsecServiceDBImpl.java:64)
   at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl.loadUserByUsername(UserDetailsServiceImpl.java:50)
   at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl$$FastClassByCGLIB$$9eef634e.invoke(<generated>)
   at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
   at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
   at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl$$EnhancerByCGLIB$$5ad597e8.loadUserByUsername(<generated>)
   at org.springframework.security.core.userdetails.UserDetailsByNameServiceWrapper.loadUserDetails(UserDetailsByNameServiceWrapper.java:53)
   at org.springframework.security.cas.authentication.CasAuthenticationProvider.loadUserByAssertion(CasAuthenticationProvider.java:149)
   at org.springframework.security.cas.authentication.CasAuthenticationProvider.authenticateNow(CasAuthenticationProvider.java:132)
   at org.springframework.security.cas.authentication.CasAuthenticationProvider.authenticate(CasAuthenticationProvider.java:117)
   at org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:130)
   at org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:48)
   at org.springframework.security.cas.web.CasAuthenticationFilter.attemptAuthentication(CasAuthenticationFilter.java:104)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
   at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
   at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
   at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
   at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
   at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
   at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
   at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
   at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
   at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
   at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
   at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
   at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
   at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
   at org.mortbay.jetty.Server.handle(Server.java:326)
   at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
   at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
   at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
   at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
   at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
   at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
   at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: java.sql.SQLException: IO 错误: Unexpected packet
   at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:3009)
   at oracle.sql.CLOB.getChars(CLOB.java:402)
   at oracle.sql.CLOB.getSubString(CLOB.java:274)
   at oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:476)
   at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1118)
   at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:174)
   at org.springframework.jdbc.support.JdbcUtils.getResultSetValue(JdbcUtils.java:142)
   at org.springframework.jdbc.core.BeanPropertyRowMapper.getColumnValue(BeanPropertyRowMapper.java:308)
   at org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:246)
   at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
   at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
   at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
   ... 53 more
Caused by: oracle.net.ns.NetException: Unexpected packet
   at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:252)
   at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
   at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:103)
   at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1551)
   at oracle.jdbc.driver.T4C8TTILobd.unmarshalLobData(T4C8TTILobd.java:450)
   at oracle.jdbc.driver.T4C8TTILob.readLOBD(T4C8TTILob.java:767)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:349)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
   at oracle.jdbc.driver.T4C8TTIClob.read(T4C8TTIClob.java:240)
   at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:2996)

wdc13403

【求助】Java桌面程序如何发放接口给其他桌面程序，用来传输数据！

3条回答

为你推荐