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
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user