java.sql.SQLException: Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival] -- ,[DTofMessageInsertion] -- ,[DTofMessage] ,[StatusCode] ,[Insurance1] ,[Insurance2] ,[Sex] ,[ReceivingFacility] ,[DOB]) VALUES ('LastName' ,'FirstName' ,'Doctor' ,'PCP' ,? ,? -- ,<PrimaryKey, numeric(18,0),> ,CONVERT(datetime,SUBSTRING("?",1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) -- ,? -- ,? ,'?' ,'?' ,'insuranceelement2' ,'?' ,'?' ,CONVERT(datetime,SUBSTRING('?',1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) ) Parameters: [0732043, 000038426102, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, A08, , F, 1, 19610302, 19610302, 19610302, 19610302, 19610302]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via mirthcorp.com by Unknown author, 1 year ago
Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival
via MuleSoft JIRA by Juan Manuel Sanmarco, 1 year ago
Invalid column type Query: INSERT INTO FPA.ESPECIES (rest of the query here)...
via MuleSoft JIRA by Juan Manuel Sanmarco, 1 year ago
Invalid column type Query: INSERT INTO FPA.ESPECIES (rest of the query here)...
via Google Groups by Chirapol Mathawaphan, 4 months ago
*Unknown column '$' in 'field list'* Query: INSERT INTO ASYNCQ_DLINK14 (created, created_by, updated, updated_by, msg_id, msg_payload, msg_status) VALUES (now(),'esbadmin',now(),'esbadmin','123',${payload}, 'Created') Parameters: []
via osdir.com by Unknown author, 1 year ago
ORA-00932: inconsistent datatypes: expected FILE got CHAR Query: INSERT INTO dbutilstest(col1) values (?) Parameters: [null]
via Google Groups by Richard Swart, 4 months ago
ORA-02049: timeout: distributed transaction waiting for lock Query: update CUSTOM_QUEUE_TABLE set STATUS='Processing', date_updated=sysdate where MESSAGE_ID = ? Parameters: [1]
java.sql.SQLException: Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival] -- ,[DTofMessageInsertion] -- ,[DTofMessage] ,[StatusCode] ,[Insurance1] ,[Insurance2] ,[Sex] ,[ReceivingFacility] ,[DOB]) VALUES ('LastName' ,'FirstName' ,'Doctor' ,'PCP' ,? ,? -- ,<PrimaryKey, numeric(18,0),> ,CONVERT(datetime,SUBSTRING("?",1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) -- ,? -- ,? ,'?' ,'?' ,'insuranceelement2' ,'?' ,'?' ,CONVERT(datetime,SUBSTRING('?',1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) ) Parameters: [0732043, 000038426102, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, A08, , F, 1, 19610302, 19610302, 19610302, 19610302, 19610302]
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:130)
at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:157)
at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:166)
at org.mule.impl.MuleSession.sendEvent(MuleSession.java:191)
at org.mule.impl.MuleSession.sendEvent(MuleSession.java:130)
at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:85)
at org.mule.routing.outbound.FilteringMulticastingRouter.route(FilteringMulticastingRouter.java:99)
at org.mule.routing.outbound.OutboundMessageRouter$1.doInTransaction(OutboundMessageRouter.java:78)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:48)
at org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:247)
at org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:209)
at org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:277)
at org.mule.impl.MuleSession.sendEvent(MuleSession.java:201)
at org.mule.routing.inbound.InboundMessageRouter.send(InboundMessageRouter.java:161)
at org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:128)
at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:493)
at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:272)
at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:231)
at com.webreach.mirth.connectors.file.FileMessageReceiver.processFile(FileMessageReceiver.java:219)
at com.webreach.mirth.connectors.file.FileMessageReceiver.poll(FileMessageReceiver.java:138)
at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:118)
at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago

Know the solutions? Share your knowledge to help other developers to debug faster.