RE: FW: Variable Length Field with DB2?400

"Xu, Jie (MED US)" <[email protected]>
Newsgroups gmane.comp.jakarta.ojb.user
Message-ID <FFD3D44937A26344B46553CC326B36BC0633131B@USMLVV1EXCTV04.ww005.siemens.net> 
Thanks, Armin.

Here is trace. You are right, it seems that AS400 JDBC driver is
truncating the data.

[11/28/06 7:42:51:566 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert
: com.siemens.med.hs.ms4.oc_file.Ocpmadi1VO@3eda3eda
[11/28/06 7:42:51:566 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@514f514f
[11/28/06 7:42:52:363 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert
: com.siemens.med.hs.ms4.oc_file.Ocpmadi1VO@58735873
[11/28/06 7:42:52:363 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@5eef5eef
[11/28/06 7:42:53:160 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert
: com.siemens.med.hs.ms4.oc_file.Ocpmadi1VO@66206620
[11/28/06 7:42:53:160 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@6c9c6c9c
[11/28/06 7:42:53:566 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery :
Query from class com.siemens.med.hs.ms4.oc_file.Ocpmalt1VO where [entity
= 100, unitRefNo = 50818, episodeSeqNo = 3]
[11/28/06 7:42:53:566 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@8cc08cc
[11/28/06 7:42:54:050 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert
: com.siemens.med.hs.ms4.oc_file.Ocpmalt1VO@73ff73ff
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R
java.sql.DataTruncation: Data truncation
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
java.lang.Throwable.<init>(Throwable.java)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
java.lang.Throwable.<init>(Throwable.java)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
java.sql.SQLException.<init>(SQLException.java:73)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
java.sql.SQLWarning.<init>(SQLWarning.java:66)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
java.sql.DataTruncation.<init>(DataTruncation.java:50)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
com.ibm.as400.access.AS400JDBCPreparedStatement.testDataTruncation(AS400
JDBCPreparedStatement.java)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setValue(AS400JDBCPrepar
edStatement.java)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setObject(AS400JDBCPrepa
redStatement.java)
[11/28/06 7:42:54:175 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPrepar
edStatement.java)[11/28/06 7:42:54:175 MST] 7a367a36 SystemOut     O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the insert (for a
com.siemens.med.hs.ms4.oc_file.Ocpmalt1VO): Data truncation
[11/28/06 7:42:54:175 MST] 7a367a36 SystemOut     O Data truncation

[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen
t(Unknown Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.platforms.PlatformDb2Impl.setObjectForStatement(Un
known Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.oc_file.dao.OcpmaltDAO.insert(OcpmaltDAO.java:49)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.oc_file.dao.DrugAlertsDAO.insertAlert(DrugAlertsD
AO.java:151)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.orders.OrderAlertProcess.writeAlertFiles(OrderAle
rtProcess.java:2208)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.portal.actions.WellAction.sendOrders(WellAction.j
ava:2331)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.portal.actions.WellAction.execute(WellAction.java
:1061)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
[11/28/06 7:42:54:191 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:76)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.siemens.med.hs.ms4.filters.SessionFilter.doFilter(SessionFilter.java
:291)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:132)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:71)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:974)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:564)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:200)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
19)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:276)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invo
ke(CacheableInvocationContext.java:116)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:186)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
618)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[11/28/06 7:42:54:207 MST] 7a367a36 SystemErr     R 	at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
[11/28/06 7:42:54:316 MST] 7a367a36 SystemOut     O 2006-11-28
07:42:54,238 ERROR [Servlet.Engine.Transports : 1] hs.ms4
(OcpmaltDAO.java:55)     - PersistenceBrokerException thrown in
OcpmaltDAO.insert():
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.DataTruncation: Data truncation
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.DataTruncation: Data truncation
	at java.lang.Throwable.<init>(Throwable.java)
	at
org.apache.commons.lang.exception.NestableRuntimeException.<init>(Nestab
leRuntimeException.java:111)
	at org.apache.ojb.broker.OJBRuntimeException.<init>(Unknown
Source)
	at
org.apache.ojb.broker.PersistenceBrokerException.<init>(Unknown Source)
	at
org.apache.ojb.broker.PersistenceBrokerSQLException.<init>(Unknown
Source)
	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
com.siemens.med.hs.ms4.oc_file.dao.OcpmaltDAO.insert(OcpmaltDAO.java:49)
	at
com.siemens.med.hs.ms4.oc_file.dao.DrugAlertsDAO.insertAlert(DrugAlertsD
AO.java:151)
	at
com.siemens.med.hs.ms4.orders.OrderAlertProcess.writeAlertFiles(OrderAle
rtProcess.java:2208)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.sendOrders(WellAction.j
ava:2331)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.execute(WellAction.java
:1061)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
	at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
	at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
	at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
	at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:76)
	at
com.siemens.med.hs.ms4.filters.SessionFilter.doFilter(SessionFilter.java
:291)
	at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:132)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:71)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:974)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:564)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:200)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
19)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:276)
	at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
	at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invo
ke(CacheableInvocationContext.java:116)
	at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:186)
	at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
	at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
Caused by:
java.sql.DataTruncation: Data truncation
	at java.lang.Throwable.<init>(Throwable.java)
	at java.lang.Throwable.<init>(Throwable.java)
	at java.sql.SQLException.<init>(SQLException.java:73)
	at java.sql.SQLWarning.<init>(SQLWarning.java:66)
	at java.sql.DataTruncation.<init>(DataTruncation.java:50)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.testDataTruncation(AS400
JDBCPreparedStatement.java)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setValue(AS400JDBCPrepar
edStatement.java)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setObject(AS400JDBCPrepa
redStatement.java)
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPrepar
edStatement.java)
	at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen
t(Unknown Source)
	at
org.apache.ojb.broker.platforms.PlatformDb2Impl.setObjectForStatement(Un
known Source)
	at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
com.siemens.med.hs.ms4.oc_file.dao.OcpmaltDAO.insert(OcpmaltDAO.java:49)
	at
com.siemens.med.hs.ms4.oc_file.dao.DrugAlertsDAO.insertAlert(DrugAlertsD
AO.java:151)
	at
com.siemens.med.hs.ms4.orders.OrderAlertProcess.writeAlertFiles(OrderAle
rtProcess.java:2208)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.sendOrders(WellAction.j
ava:2331)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.execute(WellAction.java
:1061)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
	at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
	at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
	at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
	at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:76)
	at
com.siemens.med.hs.ms4.filters.SessionFilter.doFilter(SessionFilter.java
:291)
	at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:132)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:71)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:974)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:564)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:200)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
19)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:276)
	at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
	at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invo
ke(CacheableInvocationContext.java:116)
	at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:186)
	at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
	at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
2006-11-28 07:42:54,316 ERROR [Servlet.Engine.Transports : 1] hs.ms4
(DrugAlertsDAO.java:166)     - Data access exception raised in access
altDAO.insert()
2006-11-28 07:42:54,332 ERROR [Servlet.Engine.Transports : 1] hs.ms4
(DataAccessException.java:46)     - An exception has been caused by:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.DataTruncation: Data truncation
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.DataTruncation: Data truncation
	at java.lang.Throwable.<init>(Throwable.java)
	at
org.apache.commons.lang.exception.NestableRuntimeException.<init>(Nestab
leRuntimeException.java:111)
	at org.apache.ojb.broker.OJBRuntimeException.<init>(Unknown
Source)
	at
org.apache.ojb.broker.PersistenceBrokerException.<init>(Unknown Source)
	at
org.apache.ojb.broker.PersistenceBrokerSQLException.<init>(Unknown
Source)
	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
com.siemens.med.hs.ms4.oc_file.dao.OcpmaltDAO.insert(OcpmaltDAO.java:49)
	at
com.siemens.med.hs.ms4.oc_file.dao.DrugAlertsDAO.insertAlert(DrugAlertsD
AO.java:151)
	at
com.siemens.med.hs.ms4.orders.OrderAlertProcess.writeAlertFiles(OrderAle
rtProcess.java:2208)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.sendOrders(WellAction.j
ava:2331)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.execute(WellAction.java
:1061)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
	at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
	at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
	at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
	at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:76)
	at
com.siemens.med.hs.ms4.filters.SessionFilter.doFilter(SessionFilter.java
:291)
	at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:132)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:71)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:974)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:564)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:200)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
19)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:276)
	at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
	at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invo
ke(CacheableInvocationContext.java:116)
	at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:186)
	at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
	at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
Caused by:
java.sql.DataTruncation: Data truncation
	at java.lang.Throwable.<init>(Throwable.java)
	at java.lang.Throwable.<init>(Throwable.java)
	at java.sql.SQLException.<init>(SQLException.java:73)
	at java.sql.SQLWarning.<init>(SQLWarning.java:66)
	at java.sql.DataTruncation.<init>(DataTruncation.java:50)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.testDataTruncation(AS400
JDBCPreparedStatement.java)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setValue(AS400JDBCPrepar
edStatement.java)
	at
com.ibm.as400.access.AS400JDBCPreparedStatement.setObject(AS400JDBCPrepa
redStatement.java)
	at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPrepar
edStatement.java)
	at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen
t(Unknown Source)
	at
org.apache.ojb.broker.platforms.PlatformDb2Impl.setObjectForStatement(Un
known Source)
	at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at
com.siemens.med.hs.ms4.oc_file.dao.OcpmaltDAO.insert(OcpmaltDAO.java:49)
	at
com.siemens.med.hs.ms4.oc_file.dao.DrugAlertsDAO.insertAlert(DrugAlertsD
AO.java:151)
	at
com.siemens.med.hs.ms4.orders.OrderAlertProcess.writeAlertFiles(OrderAle
rtProcess.java:2208)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.sendOrders(WellAction.j
ava:2331)
	at
com.siemens.med.hs.ms4.portal.actions.WellAction.execute(WellAction.java
:1061)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
	at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
	at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
	at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
	at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
	at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
	at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:76)
	at
com.siemens.med.hs.ms4.filters.SessionFilter.doFilter(SessionFilter.java
:291)
	at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:132)
	at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:71)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:974)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:564)
	at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:200)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
19)
	at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:276)
	at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
	at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invo
ke(CacheableInvocationContext.java:116)
	at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:186)
	at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
	at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
618)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)


"Jay" Jie Xu
Siemens MED

Office: 801-539-4642
Mobile: 801-856-4402
Fax: 801-533-8004


-----Original Message-----
From: Armin Waibel [mailto:[email protected]]
Sent: Monday, November 27, 2006 6:11 PM
To: OJB Users List
Subject: Re: FW: Variable Length Field with DB2?400

Hi Jay,

Xu, Jie (MED US) wrote:
> Folks,
>
>
> We use OJB as the data access bridge to access DB2/400 data in our Web
> application. In some of our DB2/400 tables, we define the variable
> length field, such as VARCHAR(4096) which allow up to 4096 characters.
> We use the following field definition in OJB,
>
>
> <field-descriptor
>
>
>     id="7"
>
>
>     name="screenMsg"
>
>
>     column="ALMSGT"
>
>
>     jdbc-type="VARCHAR"
>
>     length="4096"
>
> />
>
> But, when try to insert record, "Data truncated" error received with
the
> String length only about 160. If the String length is short, we do not
> have the problem. Any suggestion or advices?
>

OJB doesn't truncate any String objects. I think this is a jdbc-driver
or DB table issue. Did you checked the DB table, is the column really
VARCHAR(4096)? Could you post stack trace?

regards,
Armin


>
> Thank you very much
>
>
> "Jay" Jie Xu
>
>
>
>
>
------------------------------------------------------------------------
----
> This message and any included attachments are from Siemens Medical
Solutions
>
> and are intended only for the addressee(s).
>
> The information contained herein may include trade secrets or
privileged or
>
> otherwise confidential information. Unauthorized review, forwarding,
printing,
>
> copying, distributing, or using such information is strictly
prohibited and may
>
> be unlawful. If you received this message in error, or have reason to
believe
>
> you are not authorized to receive it, please promptly delete this
message and
>
> notify the sender by e-mail with a copy to
[email protected]
>
>
> Thank you

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


----------------------------------------------------------------------------
This message and any included attachments are from Siemens Medical Solutions
and are intended only for the addressee(s).
The information contained herein may include trade secrets or privileged or
otherwise confidential information. Unauthorized review, forwarding, printing,
copying, distributing, or using such information is strictly prohibited and may
be unlawful. If you received this message in error, or have reason to believe
you are not authorized to receive it, please promptly delete this message and
notify the sender by e-mail with a copy to [email protected]

Thank you
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.