[jboss-user] [JNDI/Naming/Network] - java.sql.SQLException: Bigger type length than Maximum
Rajesh.Gajula
do-not-reply at jboss.com
Thu Jul 19 01:09:20 EDT 2007
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#4065638
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4065638
More information about the jboss-user
mailing list