1 Reply Latest reply on Jul 20, 2007 2:53 AM by Rajesh

    java.sql.SQLException: Bigger type length than Maximum

    Rajesh Newbie

      Hi,

      I have an application deployed in jboss cluster and deployment fine.
      when i tried to access the fields in the application , i got the below exceptions in the logs ..

      INFO | jvm 5 | 2007/07/19 04:38:25 | 04:38:25,343 ERROR [ManualAdjustmentAction] Error in action classINFO | jvm 5 | 2007/07/19 04:38:25 | com.ge.hc.osb.exception.OSBException: SQL Exception :
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.dao.ManualAdjustmentDAO.getDetailList(ManualAdjustmentDAO.java:117)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.service.ManualAdjustmentService.getDetailList(ManualAdjustmentService.java:50)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.action.ManualAdjustmentAction.viewManualAdjustmentPage(ManualAdjustmentAction.java:113)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at java.lang.reflect.Method.invoke(Method.java:585)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.action.OSBActionServlet.process(OSBActionServlet.java:94)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.action.AuthorizationFilter.doFilter(AuthorizationFilter.java:109)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.web.tomcat.tc5.sso.ClusteredSingleSignOn.invoke(ClusteredSingleSignOn.java:366)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at java.lang.Thread.run(Thread.java:595)
      INFO | jvm 5 | 2007/07/19 04:38:25 | Caused by: java.sql.SQLException: Bigger type length than Maximum
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:884)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2201)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1050)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:111)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor(T4CTTIdcb.java:103)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalOneRow(T4CResultSetAccessor.java:167)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:791)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:707)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:529)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:783)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1026)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2884)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2975)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4111)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:183)
      INFO | jvm 5 | 2007/07/19 04:38:25 | at com.ge.hc.osb.dao.ManualAdjustmentDAO.getDetailList(ManualAdjustmentDAO.java:86)
      INFO | jvm 5 | 2007/07/19 04:38:25 | ... 38 more


      FYI .. am using 10.0.1.3 ojdbc.jar file in the server, and even i tried with 10.0.1.5 driver , Still i am getting the same exception.

      It will be great if you can gimme any suggestions or solution ?

      thanks,
      -Raj