Erro de inserção no banco

Front-end
#1
  1. Boa análise para todos!


java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.luxfacta.framework.servlet.PostServlet.doPost(PostServlet.java:217)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:534)
Caused by: java.lang.Exception: Insert statement error:insert into FVI_T_HIST_MEDICAMENTO ( VAD_ID_HMD, HMD_DOSAGEM_TOTAL, UNI_ID_HMD, MSU_ID_HMD, HMD_ID, HMD_HORA_ULT_DOSE, HMD_HORA_PRI_DOSE, HMD_DOSE, HMD_DATA_TERMINO, HMD_DATA_PRI_DOSE, FRE_ID_HMD, REL_ID ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). Dump: (0,1,class java.lang.Integer) (1,575.5,class java.lang.Float) (2,1,class java.lang.Integer) (3,-1,class java.lang.Integer) (4,22,class java.lang.Integer) (5,19:20,class java.lang.String) (6,03:35,class java.lang.String) (7,50.0,class java.lang.Float) (8,26/12/2007,class java.lang.String) (9,18/04/2007,class java.lang.String) (10,1,class java.lang.Integer) (11,82,class java.lang.Integer) 

Base Error:com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -530, SQLSTATE: 23503, SQLERRMC: DB2INST1.FVI_T_HIST_MEDICAMENTO.SQL080226151417130
	at com.luxfacta.framework.database.Worker.insert(Worker.java:255)
	at com.luxfacta.farmaco.logic.MedSuspeitoLogic.save(MedSuspeitoLogic.java:186)
	... 31 more
java.lang.Exception: Insert statement error:insert into FVI_T_HIST_MEDICAMENTO ( VAD_ID_HMD, HMD_DOSAGEM_TOTAL, UNI_ID_HMD, MSU_ID_HMD, HMD_ID, HMD_HORA_ULT_DOSE, HMD_HORA_PRI_DOSE, HMD_DOSE, HMD_DATA_TERMINO, HMD_DATA_PRI_DOSE, FRE_ID_HMD, REL_ID ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?). Dump: (0,1,class java.lang.Integer) (1,575.5,class java.lang.Float) (2,1,class java.lang.Integer) (3,-1,class java.lang.Integer) (4,22,class java.lang.Integer) (5,19:20,class java.lang.String) (6,03:35,class java.lang.String) (7,50.0,class java.lang.Float) (8,26/12/2007,class java.lang.String) (9,18/04/2007,class java.lang.String) (10,1,class java.lang.Integer) (11,82,class java.lang.Integer) 

Base Error:com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -530, SQLSTATE: 23503, SQLERRMC: DB2INST1.FVI_T_HIST_MEDICAMENTO.SQL080226151417130
	at com.luxfacta.framework.database.Worker.insert(Worker.java:255)
	at com.luxfacta.farmaco.logic.MedSuspeitoLogic.save(MedSuspeitoLogic.java:186)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.luxfacta.framework.servlet.PostServlet.doPost(PostServlet.java:217)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:534)
#2

posta o código ai…

tenta debugar o sql, mostrando pra ver se esta tudo ok.

o teu banco de dados esta rodando…

#3

É suporte agora?

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzala/rzalaccl.htm

Boa análise. :?

#4

Cara, me desculpe, talvez não tenha a mesma experiência que vc, mas digo que abri o link que vc passou e não achei nada relativo ao erro que está dando aqui.

#5

Ok, vamos detalhar mais um pouco, então:

[quote]Table 16. Class Code 23: Constraint Violation

SQLSTATE Value / Meaning / SQLCODE Values
…
23503 / The insert or update value of a foreign key is invalid. / -530[/quote]

#6

OK, obrigado.

#7