[jboss-user] [JNDI/Naming/Network] - java.sql.SQLException: Bigger type length than Maximum

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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4065638#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...