Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Invalid JDBC escape syntax [with JDTS Driver]
Invalid JDBC escape syntax [with JDTS Driver] [message #178599] Tue, 18 July 2006 18:17 Go to next message
Tyrone Hed is currently offline Tyrone Hed
Messages: 79
Registered: July 2009
Member
Folks,
On a report that previously ran with a Microsoft Driver, I have
experienced the following exception. In short, it has been unable to
replace my prepared statement parameter. I will give the exception and
then the .rptdesign file.

Thank you,
Ty

EXCEPTION


INFO: Data Engine starts up
16:04:28,896 INFO [STDOUT] Jul 18, 2006 4:04:28 PM
org.eclipse.birt.data.engine.odaconsumer.Driver setLogConfiguration
INFO: ODA driver does not have valid trace logging defined in the plug-in
options or plugin.xml file.
16:04:28,997 INFO [STDOUT] Jul 18, 2006 4:04:28 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=sun.jdbc.odbc.JdbcOdbcDriver, connectionFactory=null
16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver ,
connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver
INFO: Loading JDBC driver class: net.sourceforge.jtds.jdbc.Driver
16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver
INFO: Loaded JDBC driver class in class path:
net.sourceforge.jtds.jdbc.Driver
16:04:29,208 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery

SEVERE: Cannot prepare statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:79)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
at
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at
org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
at $RenderBody_148.renderComponent($RenderBody_148.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
at $Body_143.renderComponent($Body_143.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
at $Shell_141.renderComponent($Shell_141.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
at
org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
at
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
at
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
at
org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
at
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
at
org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
at
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
at
$WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
at
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
at
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
at
$WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
at
$WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
at
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
at
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
at
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
at
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
at
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
at
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
$ServletRequestServicer_10c83a9ecb1.service($ServletRequestS ervicer_10c83a9ecb1.java)
at
org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
at
org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Inval
16:04:29,208 INFO [STDOUT] id JDBC escape syntax at line position 148 '}'
character expected.
at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
at
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
... 88 more
16:04:29,238 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.engine.data.dte.DteDataEngine execute
SEVERE: Failed to prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[
SELECT
(
CASE
WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
THEN CLAIM1.CLAIM_IID
ELSE CLAIM1.SUBMITTED_CLAIM_IID
END
) AS 'ClaimDS CLAIM_IID',
CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
CLAIM1.CLAIM_EID AS 'Claim Id',
CLAIM1.ACCOUNT_EID AS 'Account Id',
ACCOUNT.NAME AS 'Account',
CLAIM1.PLAN_EID AS 'Plan Id',
INSURANCE_PLAN.DESCRIPTION AS 'Plan',
PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
PATIENT.GENDER AS 'Gender',
CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
CLAIM1.BATCH_EID AS 'Batch',
ENTERPRISE.NAME AS 'Enterprise',
CLAIM1.CONTEXT AS 'Environment',
CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
CLAIM1.CLAIM_STATUS AS 'Claim Status',
CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Sub Proc Code',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Adj Proc Code',
CLAIM1.IS_MODIFIED AS 'Modified From Claim',
CLAIM_LINE.SERVICE_UNITS AS 'Units',
CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
PRACTITIONER.FIRST_NAME AS 'Provider FName',
PRACTITIONER.LAST_NAME AS 'Provider LName',
CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
CLAIM_LINE.RVU AS 'RVU',
CLAIM_LINE.DISPOSITION AS 'Disposition',
CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order',
MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
CLAIM_LINE.RULESET_NAME AS 'Ruleset',
CLAIM_LINE.STATUS AS 'Status',
(
SELECT
SUM(CLAIM_LINE.CHARGED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Sub Charge',
(
SELECT
SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Adj Charge',
(
CASE
WHEN
(
(
SELECT
COUNT(DISTINCT CLAIM_IID)
FROM
CLAIM
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
OR
SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
) > 1
AND
CLAIM1.IS_MODIFIED = 'N'
)
THEN 0
ELSE 1
END
) SHOW_RESULTS
FROM
CLAIM CLAIM1
INNER JOIN
CLAIM_LINE
ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
INNER JOIN
ENTERPRISE
ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
LEFT OUTER JOIN
PROCEDURE_CODE
ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
LEFT OUTER JOIN
CLAIM_LINE_MODIFIER
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
LEFT OUTER JOIN
MODIFIER_CODE
ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
LEFT OUTER JOIN
CLAIM_LINE_DIAGNOSIS
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
LEFT OUTER JOIN
DIAGNOSIS_CODE
ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
LEFT OUTER JOIN
INSURANCE_PLAN
ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
LEFT OUTER JOIN
ACCOUNT
ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
LEFT OUTER JOIN
CLAIM_LINE_EDIT
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
LEFT OUTER JOIN
PATIENT
ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
LEFT OUTER JOIN
PRACTITIONER
ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
WHERE 1 = ?
]
Error preparing SQL statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
org.eclipse.birt.data.engine.core.DataException: Failed to prepare the
following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[
SELECT
(
CASE
WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
THEN CLAIM1.CLAIM_IID
ELSE CLAIM1.SUBMITTED_CLAIM_IID
END
) AS 'ClaimDS CLAIM_IID',
CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
CLAIM1.CLAIM_EID AS 'Claim Id',
CLAIM1.ACCOUNT_EID AS 'Account Id',
ACCOUNT.NAME AS 'Account',
CLAIM1.PLAN_EID AS 'Plan Id',
INSURANCE_PLAN.DESCRIPTION AS 'Plan',
PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
PATIENT.GENDER AS 'Gender',
CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
CLAIM1.BATCH_EID AS 'Batch',
ENTERPRISE.NAME AS 'Enterprise',
CLAIM1.CONTEXT AS 'Environment',
CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
CLAIM1.CLAIM_STATUS AS 'Claim Status',
CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Sub Proc Code',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Adj Proc Code',
CLAIM1.IS_MODIFIED AS 'Modified From Claim',
CLAIM_LINE.SERVICE_UNITS AS 'Units',
CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
PRACTITIONER.FIRST_NAME AS 'Provider FName',
PRACTITIONER.LAST_NAME AS 'Provider LName',
CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
CLAIM_LINE.RVU AS 'RVU',
CLAIM_LINE.DISPOSITION AS 'Disposition',
CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order'
16:04:29,249 INFO [STDOUT] ,
MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
CLAIM_LINE.RULESET_NAME AS 'Ruleset',
CLAIM_LINE.STATUS AS 'Status',
(
SELECT
SUM(CLAIM_LINE.CHARGED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Sub Charge',
(
SELECT
SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Adj Charge',
(
CASE
WHEN
(
(
SELECT
COUNT(DISTINCT CLAIM_IID)
FROM
CLAIM
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
OR
SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
) > 1
AND
CLAIM1.IS_MODIFIED = 'N'
)
THEN 0
ELSE 1
END
) SHOW_RESULTS
FROM
CLAIM CLAIM1
INNER JOIN
CLAIM_LINE
ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
INNER JOIN
ENTERPRISE
ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
LEFT OUTER JOIN
PROCEDURE_CODE
ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
LEFT OUTER JOIN
CLAIM_LINE_MODIFIER
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
LEFT OUTER JOIN
MODIFIER_CODE
ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
LEFT OUTER JOIN
CLAIM_LINE_DIAGNOSIS
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
LEFT OUTER JOIN
DIAGNOSIS_CODE
ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
LEFT OUTER JOIN
INSURANCE_PLAN
ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
LEFT OUTER JOIN
ACCOUNT
ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
LEFT OUTER JOIN
CLAIM_LINE_EDIT
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
LEFT OUTER JOIN
PATIENT
ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
LEFT OUTER JOIN
PRACTITIONER
ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
WHERE 1 = ?
]
Error preparing SQL statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:79)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
at
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at
org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
at $RenderBody_148.renderComponent($RenderBody_148.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
at $Body_143.renderComponent($Body_143.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
at $Shell_141.renderComponent($Shell_141.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
at
org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
at
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
at
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
at
org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
at
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
at
org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
at
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
at
$WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
at
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
at
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
at
$WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
at
$WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
at
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
at
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
at
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
at
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
at
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
at
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at $ServletRequestServicer_10c83a9ecb1.se
16:04:29,249 INFO [STDOUT] rvice($ServletRequestServicer_10c83a9ecb1.java)
at
org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
at
org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error
preparing SQL statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
... 85 more
Caused by: java.sql.SQLException: Invalid JDBC escape syntax at line
position 148 '}' character expected.
at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
at
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
... 88 more
16:04:29,359 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
SEVERE: Cannot prepare statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.GridItemExecutor.exe cute(GridItemExecutor.java:82)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitGridItem(ReportExecutorVisitor.java:172)
at
org.eclipse.birt.report.engine.ir.GridItemDesign.accept(Grid ItemDesign.java:117)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essListBand(ListItemExecutor.java:149)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essHeader(ListItemExecutor.java:217)
at
org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:84)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:101)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
at
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at
org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
at $RenderBody_148.renderComponent($RenderBody_148.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
at $Body_143.renderComponent($Body_143.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
at $Shell_141.renderComponent($Shell_141.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
at
org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
at
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
at
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
at
org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
at
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
at
org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
at
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
at
$WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
at
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
at
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
at
$WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
at
$WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
at
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
at
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
at
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
at
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
at
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
at
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
at
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
at
$ServletRequestServicer_10c83a9ecb1.service($ServletRequestS ervicer_10c83a9ecb1.java)
at
org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
at
org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at org.ap
16:04:29,369 INFO [STDOUT]
ache.catalina.core.StandardEngineValve.invoke(StandardEngine Valve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Invalid JDBC escape syntax at line
position 148 '}' character expected.
at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
at
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
... 94 more
16:04:29,369 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
org.eclipse.birt.report.engine.data.dte.DteDataEngine execute
SEVERE: Failed to prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[
SELECT
(
CASE
WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
THEN CLAIM1.CLAIM_IID
ELSE CLAIM1.SUBMITTED_CLAIM_IID
END
) AS 'ClaimDS CLAIM_IID',
CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
CLAIM1.CLAIM_EID AS 'Claim Id',
CLAIM1.ACCOUNT_EID AS 'Account Id',
ACCOUNT.NAME AS 'Account',
CLAIM1.PLAN_EID AS 'Plan Id',
INSURANCE_PLAN.DESCRIPTION AS 'Plan',
PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
PATIENT.GENDER AS 'Gender',
CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
CLAIM1.BATCH_EID AS 'Batch',
ENTERPRISE.NAME AS 'Enterprise',
CLAIM1.CONTEXT AS 'Environment',
CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
CLAIM1.CLAIM_STATUS AS 'Claim Status',
CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Sub Proc Code',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Adj Proc Code',
CLAIM1.IS_MODIFIED AS 'Modified From Claim',
CLAIM_LINE.SERVICE_UNITS AS 'Units',
CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
PRACTITIONER.FIRST_NAME AS 'Provider FName',
PRACTITIONER.LAST_NAME AS 'Provider LName',
CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
CLAIM_LINE.RVU AS 'RVU',
CLAIM_LINE.DISPOSITION AS 'Disposition',
CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order',
MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
CLAIM_LINE.RULESET_NAME AS 'Ruleset',
CLAIM_LINE.STATUS AS 'Status',
(
SELECT
SUM(CLAIM_LINE.CHARGED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Sub Charge',
(
SELECT
SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Adj Charge',
(
CASE
WHEN
(
(
SELECT
COUNT(DISTINCT CLAIM_IID)
FROM
CLAIM
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
OR
SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
) > 1
AND
CLAIM1.IS_MODIFIED = 'N'
)
THEN 0
ELSE 1
END
) SHOW_RESULTS
FROM
CLAIM CLAIM1
INNER JOIN
CLAIM_LINE
ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
INNER JOIN
ENTERPRISE
ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
LEFT OUTER JOIN
PROCEDURE_CODE
ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
LEFT OUTER JOIN
CLAIM_LINE_MODIFIER
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
LEFT OUTER JOIN
MODIFIER_CODE
ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
LEFT OUTER JOIN
CLAIM_LINE_DIAGNOSIS
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
LEFT OUTER JOIN
DIAGNOSIS_CODE
ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
LEFT OUTER JOIN
INSURANCE_PLAN
ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
LEFT OUTER JOIN
ACCOUNT
ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
LEFT OUTER JOIN
CLAIM_LINE_EDIT
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
LEFT OUTER JOIN
PATIENT
ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
LEFT OUTER JOIN
PRACTITIONER
ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
WHERE 1 = ?
]
Error preparing SQL statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
org.eclipse.birt.data.engine.core.DataException: Failed to prepare the
following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[
SELECT
(
CASE
WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
THEN CLAIM1.CLAIM_IID
ELSE CLAIM1.SUBMITTED_CLAIM_IID
END
) AS 'ClaimDS CLAIM_IID',
CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
CLAIM1.CLAIM_EID AS 'Claim Id',
CLAIM1.ACCOUNT_EID AS 'Account Id',
ACCOUNT.NAME AS 'Account',
CLAIM1.PLAN_EID AS 'Plan Id',
INSURANCE_PLAN.DESCRIPTION AS 'Plan',
PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
PATIENT.GENDER AS 'Gender',
CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
CLAIM1.BATCH_EID AS 'Batch',
ENTERPRISE.NAME AS 'Enterprise',
CLAIM1.CONTEXT AS 'Environment',
CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
CLAIM1.CLAIM_STATUS AS 'Claim Status',
CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Sub Proc Code',
(
CASE
WHEN
(
SELECT
COUNT(PROCEDURE_CODE)
FROM
PROCEDURE_CODE
WHERE
PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
AND
CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Adj Proc Code',
CLAIM1.IS_MODIFIED AS 'Modified From Claim',
CLAIM_LINE.SERVICE_UNITS AS 'Units',
CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
PRACTITIONER.FIRST_NAME AS 'Provider FName',
PRACTITIONER.LAST_NAME AS 'Provider LName',
CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
CLAIM_LINE.RVU AS 'RVU',
CLAIM_LINE.DISPOSITION AS 'Disposition',
CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order'
16:04:29,379 INFO [STDOUT] ,
MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
CLAIM_LINE.RULESET_NAME AS 'Ruleset',
CLAIM_LINE.STATUS AS 'Status',
(
SELECT
SUM(CLAIM_LINE.CHARGED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Sub Charge',
(
SELECT
SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
FROM
CLAIM_LINE
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
AND
CLAIM1.IS_MODIFIED = 'N'
GROUP BY
CLAIM_IID
) AS 'Total Adj Charge',
(
CASE
WHEN
(
(
SELECT
COUNT(DISTINCT CLAIM_IID)
FROM
CLAIM
WHERE
CLAIM_IID = CLAIM1.CLAIM_IID
OR
SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
) > 1
AND
CLAIM1.IS_MODIFIED = 'N'
)
THEN 0
ELSE 1
END
) SHOW_RESULTS
FROM
CLAIM CLAIM1
INNER JOIN
CLAIM_LINE
ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
INNER JOIN
ENTERPRISE
ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
LEFT OUTER JOIN
PROCEDURE_CODE
ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
LEFT OUTER JOIN
CLAIM_LINE_MODIFIER
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
LEFT OUTER JOIN
MODIFIER_CODE
ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
LEFT OUTER JOIN
CLAIM_LINE_DIAGNOSIS
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
LEFT OUTER JOIN
DIAGNOSIS_CODE
ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
LEFT OUTER JOIN
INSURANCE_PLAN
ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
LEFT OUTER JOIN
ACCOUNT
ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
LEFT OUTER JOIN
CLAIM_LINE_EDIT
ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
LEFT OUTER JOIN
PATIENT
ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
LEFT OUTER JOIN
PRACTITIONER
ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
WHERE 1 = ?
]
Error preparing SQL statement.
Invalid JDBC escape syntax at line position 148 '}' character expected.
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.GridItemExecutor.exe cute(GridItemExecutor.java:82)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitGridItem(ReportExecutorVisitor.java:172)
at
org.eclipse.birt.report.engine.ir.GridItemDesign.accept(Grid ItemDesign.java:117)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essListBand(ListItemExecutor.java:149)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essHeader(ListItemExecutor.java:217)
at
org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:84)
at
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:101)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
at
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
at
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at
org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
at $RenderBody_148.renderComponent($RenderBody_148.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
at $Body_143.renderComponent($Body_143.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
at $Shell_141.renderComponent($Shell_141.java)
at
org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
at
org.apache.tapestry.BaseC
[Solved!] Invalid JDBC escape syntax [with JDTS Driver] [message #179201 is a reply to message #178599] Thu, 20 July 2006 15:06 Go to previous messageGo to next message
Tyrone Hed is currently offline Tyrone Hed
Messages: 79
Registered: July 2009
Member
Tyrone Hed wrote:

> Folks,
> On a report that previously ran with a Microsoft Driver, I have
> experienced the following exception. In short, it has been unable to
> replace my prepared statement parameter. I will give the exception and
> then the .rptdesign file.

> Thank you,
> Ty

> EXCEPTION


> INFO: Data Engine starts up
> 16:04:28,896 INFO [STDOUT] Jul 18, 2006 4:04:28 PM
> org.eclipse.birt.data.engine.odaconsumer.Driver setLogConfiguration
> INFO: ODA driver does not have valid trace logging defined in the plug-in
> options or plugin.xml file.
> 16:04:28,997 INFO [STDOUT] Jul 18, 2006 4:04:28 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadDriverExtensions
> INFO: Found JDBC driverinfo extension:
> driverClass=sun.jdbc.odbc.JdbcOdbcDriver, connectionFactory=null
> 16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadDriverExtensions
> INFO: Found JDBC driverinfo extension:
> driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
> 16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadDriverExtensions
> INFO: Found JDBC driverinfo extension:
> driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver ,
>
connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
> 16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadAndRegisterDriver
> INFO: Loading JDBC driver class: net.sourceforge.jtds.jdbc.Driver
> 16:04:29,017 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
> loadAndRegisterDriver
> INFO: Loaded JDBC driver class in class path:
> net.sourceforge.jtds.jdbc.Driver
> 16:04:29,208 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery

> SEVERE: Cannot prepare statement.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
>
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
> at
>
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
> at
>
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
> at
>
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
> at
>
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
> at
>
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
> at
>
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:79)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
> at
>
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at
>
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
> at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at
> org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
> at $RenderBody_148.renderComponent($RenderBody_148.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
> at $Body_143.renderComponent($Body_143.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
> at $Shell_141.renderComponent($Shell_141.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
> at
> org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
> at
>
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
> at
>
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
> at
> org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
> at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
> at
>
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
> at
> org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
> at
>
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
> at
> $WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
> at
>
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
> at
>
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
> at
> $WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
> at
> $WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
> at
>
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
> at
>
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
> at
>
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
> at
>
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
> at
>
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
> at
>
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
$ServletRequestServicer_10c83a9ecb1.service($ServletRequestS ervicer_10c83a9ecb1.java)
> at
> org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
> at
> org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
>
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
> at
>
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
>
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: Inval
> 16:04:29,208 INFO [STDOUT] id JDBC escape syntax at line position 148 '}'
> character expected.
> at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
> at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
> at
>
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
> at
>
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
> ... 88 more
> 16:04:29,238 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.engine.data.dte.DteDataEngine execute
> SEVERE: Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [
> SELECT
> (
> CASE
> WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
> THEN CLAIM1.CLAIM_IID
> ELSE CLAIM1.SUBMITTED_CLAIM_IID
> END
> ) AS 'ClaimDS CLAIM_IID',
> CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
> CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
> CLAIM1.CLAIM_EID AS 'Claim Id',
> CLAIM1.ACCOUNT_EID AS 'Account Id',
> ACCOUNT.NAME AS 'Account',
> CLAIM1.PLAN_EID AS 'Plan Id',
> INSURANCE_PLAN.DESCRIPTION AS 'Plan',
> PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
> PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
> PATIENT.GENDER AS 'Gender',
> CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
> CLAIM1.BATCH_EID AS 'Batch',
> ENTERPRISE.NAME AS 'Enterprise',
> CLAIM1.CONTEXT AS 'Environment',
> CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
> CLAIM1.CLAIM_STATUS AS 'Claim Status',
> CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
> CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
> CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
> CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
> CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
> PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Sub Proc Code',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Adj Proc Code',
> CLAIM1.IS_MODIFIED AS 'Modified From Claim',
> CLAIM_LINE.SERVICE_UNITS AS 'Units',
> CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
> CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
> CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
> PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
> PRACTITIONER.FIRST_NAME AS 'Provider FName',
> PRACTITIONER.LAST_NAME AS 'Provider LName',
> CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
> CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
> CLAIM_LINE.RVU AS 'RVU',
> CLAIM_LINE.DISPOSITION AS 'Disposition',
> CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
> CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
> CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
> CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
> CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
> CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order',
> MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
> DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
> CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
> CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
> CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
> CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
> CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
> CLAIM_LINE.RULESET_NAME AS 'Ruleset',
> CLAIM_LINE.STATUS AS 'Status',
> (
> SELECT
> SUM(CLAIM_LINE.CHARGED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Sub Charge',
> (
> SELECT
> SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Adj Charge',
> (
> CASE
> WHEN
> (
> (
> SELECT
> COUNT(DISTINCT CLAIM_IID)
> FROM
> CLAIM
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> OR
> SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
> ) > 1
> AND
> CLAIM1.IS_MODIFIED = 'N'
> )
> THEN 0
> ELSE 1
> END
> ) SHOW_RESULTS
> FROM
> CLAIM CLAIM1
> INNER JOIN
> CLAIM_LINE
> ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
> INNER JOIN
> ENTERPRISE
> ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
> LEFT OUTER JOIN
> PROCEDURE_CODE
> ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_MODIFIER
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
> LEFT OUTER JOIN
> MODIFIER_CODE
> ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_DIAGNOSIS
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
> LEFT OUTER JOIN
> DIAGNOSIS_CODE
> ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
> LEFT OUTER JOIN
> INSURANCE_PLAN
> ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
> LEFT OUTER JOIN
> ACCOUNT
> ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
> LEFT OUTER JOIN
> CLAIM_LINE_EDIT
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
> LEFT OUTER JOIN
> PATIENT
> ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
> LEFT OUTER JOIN
> PRACTITIONER
> ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
> WHERE 1 = ?
> ]
> Error preparing SQL statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> org.eclipse.birt.data.engine.core.DataException: Failed to prepare the
> following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [
> SELECT
> (
> CASE
> WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
> THEN CLAIM1.CLAIM_IID
> ELSE CLAIM1.SUBMITTED_CLAIM_IID
> END
> ) AS 'ClaimDS CLAIM_IID',
> CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
> CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
> CLAIM1.CLAIM_EID AS 'Claim Id',
> CLAIM1.ACCOUNT_EID AS 'Account Id',
> ACCOUNT.NAME AS 'Account',
> CLAIM1.PLAN_EID AS 'Plan Id',
> INSURANCE_PLAN.DESCRIPTION AS 'Plan',
> PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
> PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
> PATIENT.GENDER AS 'Gender',
> CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
> CLAIM1.BATCH_EID AS 'Batch',
> ENTERPRISE.NAME AS 'Enterprise',
> CLAIM1.CONTEXT AS 'Environment',
> CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
> CLAIM1.CLAIM_STATUS AS 'Claim Status',
> CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
> CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
> CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
> CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
> CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
> PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Sub Proc Code',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Adj Proc Code',
> CLAIM1.IS_MODIFIED AS 'Modified From Claim',
> CLAIM_LINE.SERVICE_UNITS AS 'Units',
> CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
> CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
> CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
> PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
> PRACTITIONER.FIRST_NAME AS 'Provider FName',
> PRACTITIONER.LAST_NAME AS 'Provider LName',
> CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
> CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
> CLAIM_LINE.RVU AS 'RVU',
> CLAIM_LINE.DISPOSITION AS 'Disposition',
> CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
> CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
> CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
> CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
> CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
> CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order'
> 16:04:29,249 INFO [STDOUT] ,
> MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
> DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
> CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
> CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
> CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
> CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
> CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
> CLAIM_LINE.RULESET_NAME AS 'Ruleset',
> CLAIM_LINE.STATUS AS 'Status',
> (
> SELECT
> SUM(CLAIM_LINE.CHARGED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Sub Charge',
> (
> SELECT
> SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Adj Charge',
> (
> CASE
> WHEN
> (
> (
> SELECT
> COUNT(DISTINCT CLAIM_IID)
> FROM
> CLAIM
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> OR
> SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
> ) > 1
> AND
> CLAIM1.IS_MODIFIED = 'N'
> )
> THEN 0
> ELSE 1
> END
> ) SHOW_RESULTS
> FROM
> CLAIM CLAIM1
> INNER JOIN
> CLAIM_LINE
> ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
> INNER JOIN
> ENTERPRISE
> ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
> LEFT OUTER JOIN
> PROCEDURE_CODE
> ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_MODIFIER
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
> LEFT OUTER JOIN
> MODIFIER_CODE
> ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_DIAGNOSIS
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
> LEFT OUTER JOIN
> DIAGNOSIS_CODE
> ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
> LEFT OUTER JOIN
> INSURANCE_PLAN
> ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
> LEFT OUTER JOIN
> ACCOUNT
> ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
> LEFT OUTER JOIN
> CLAIM_LINE_EDIT
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
> LEFT OUTER JOIN
> PATIENT
> ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
> LEFT OUTER JOIN
> PRACTITIONER
> ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
> WHERE 1 = ?
> ]
> Error preparing SQL statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
>
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
> at
>
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
> at
>
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
> at
>
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
> at
>
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
> at
>
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
> at
>
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:79)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
> at
>
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at
>
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
> at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at
> org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
> at $RenderBody_148.renderComponent($RenderBody_148.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
> at $Body_143.renderComponent($Body_143.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
> at $Shell_141.renderComponent($Shell_141.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
> at
> org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
> at
>
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
> at
>
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
> at
> org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
> at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
> at
>
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
> at
> org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
> at
>
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
> at
> $WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
> at
>
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
> at
>
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
> at
> $WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
> at
> $WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
> at
>
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
> at
>
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
> at
>
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
> at
>
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
> at
>
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
> at
>
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at $ServletRequestServicer_10c83a9ecb1.se
> 16:04:29,249 INFO [STDOUT] rvice($ServletRequestServicer_10c83a9ecb1.java)
> at
> org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
> at
> org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
>
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
> at
>
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
>
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error
> preparing SQL statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> ... 85 more
> Caused by: java.sql.SQLException: Invalid JDBC escape syntax at line
> position 148 '}' character expected.
> at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
> at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
> at
>
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
> at
>
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
> ... 88 more
> 16:04:29,359 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
> SEVERE: Cannot prepare statement.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:139)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:209)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:166)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
>
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:194)
> at
>
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:300)
> at
>
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExecutor.prepareOdiQuery(PreparedExtendedDSQuer y.java:277)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:672)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
> at
>
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
> at
>
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
> at
>
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
> at
>
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
> at
>
org.eclipse.birt.report.engine.executor.GridItemExecutor.exe cute(GridItemExecutor.java:82)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitGridItem(ReportExecutorVisitor.java:172)
> at
>
org.eclipse.birt.report.engine.ir.GridItemDesign.accept(Grid ItemDesign.java:117)
> at
>
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essListBand(ListItemExecutor.java:149)
> at
>
org.eclipse.birt.report.engine.executor.ListItemExecutor.acc essHeader(ListItemExecutor.java:217)
> at
>
org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:84)
> at
>
org.eclipse.birt.report.engine.executor.ListItemExecutor.exe cute(ListItemExecutor.java:101)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitListItem(ReportExecutorVisitor.java:96)
> at
>
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(List ItemDesign.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
> at
>
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at
>
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. getHTMLReport(PeReportRenderer.java:110)
> at
>
com.ingenix.freya.web.components.reporting.PeReportRenderer. renderComponent(PeReportRenderer.java:68)
> at $PeReportRenderer_167.renderComponent($PeReportRenderer_167. java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at
> org.apache.tapestry.components.RenderBody.renderComponent(Re nderBody.java:44)
> at $RenderBody_148.renderComponent($RenderBody_148.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Body.renderComponent(Body.java:129)
> at $Body_143.renderComponent($Body_143.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.AbstractComponent.renderBody(AbstractCom ponent.java:434)
> at org.apache.tapestry.html.Shell.renderComponent(Shell.java:11 5)
> at $Shell_141.renderComponent($Shell_141.java)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at
> org.apache.tapestry.BaseComponent.renderComponent(BaseCompon ent.java:92)
> at
> org.apache.tapestry.AbstractComponent.render(AbstractCompone nt.java:617)
> at org.apache.tapestry.AbstractPage.renderPage(AbstractPage.jav a:275)
> at
> org.apache.tapestry.engine.RequestCycle.renderPage(RequestCy cle.java:366)
> at
>
org.apache.tapestry.services.impl.ResponseRendererImpl.rende rResponse(ResponseRendererImpl.java:71)
> at
>
$ResponseRenderer_10c83a9ec93.renderResponse($ResponseRender er_10c83a9ec93.java)
> at
> org.apache.tapestry.engine.DirectService.service(DirectServi ce.java:137)
> at $IEngineService_10c83a9ed02.service($IEngineService_10c83a9e d02.java)
> at
>
org.apache.tapestry.services.impl.EngineServiceOuterProxy.se rvice(EngineServiceOuterProxy.java:66)
> at
> org.apache.tapestry.engine.AbstractEngine.service(AbstractEn gine.java:248)
> at
>
org.apache.tapestry.services.impl.InvokeEngineTerminator.ser vice(InvokeEngineTerminator.java:60)
> at
> $WebRequestServicer_10c83a9ecdb.service($WebRequestServicer_ 10c83a9ecdb.java)
> at
>
org.apache.tapestry.services.impl.DisableCachingFilter.servi ce(DisableCachingFilter.java:48)
> at
>
$WebRequestServicerFilter_10c83a9ecdd.service($WebRequestSer vicerFilter_10c83a9ecdd.java)
> at
> $WebRequestServicer_10c83a9ecdf.service($WebRequestServicer_ 10c83a9ecdf.java)
> at
> $WebRequestServicer_10c83a9ecd7.service($WebRequestServicer_ 10c83a9ecd7.java)
> at
>
org.apache.tapestry.services.impl.WebRequestServicerPipeline Bridge.service(WebRequestServicerPipelineBridge.java:56)
> at
>
$ServletRequestServicer_10c83a9ecbd.service($ServletRequestS ervicer_10c83a9ecbd.java)
> at
>
org.apache.tapestry.request.DecodedRequestInjector.service(D ecodedRequestInjector.java:55)
> at
>
$ServletRequestServicerFilter_10c83a9ecb9.service($ServletRe questServicerFilter_10c83a9ecb9.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.multipart.MultipartDecoderFilter.service (MultipartDecoderFilter.java:52)
> at
>
$ServletRequestServicerFilter_10c83a9ecb7.service($ServletRe questServicerFilter_10c83a9ecb7.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
org.apache.tapestry.services.impl.SetupRequestEncoding.servi ce(SetupRequestEncoding.java:53)
> at
>
$ServletRequestServicerFilter_10c83a9ecbb.service($ServletRe questServicerFilter_10c83a9ecbb.java)
> at
>
$ServletRequestServicer_10c83a9ecbf.service($ServletRequestS ervicer_10c83a9ecbf.java)
> at
>
$ServletRequestServicer_10c83a9ecb1.service($ServletRequestS ervicer_10c83a9ecb1.java)
> at
> org.apache.tapestry.ApplicationServlet.doService(Application Servlet.java:123)
> at
> org.apache.tapestry.ApplicationServlet.doPost(ApplicationSer vlet.java:168)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
>
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:159)
> at
>
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at org.ap
> 16:04:29,369 INFO [STDOUT]
> ache.catalina.core.StandardEngineValve.invoke(StandardEngine Valve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
>
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: Invalid JDBC escape syntax at line
> position 148 '}' character expected.
> at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:41 5)
> at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:96 5)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:106 3)
> at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156 )
> at
>
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
> at
>
net.sourceforge.jtds.jdbc.JtdsCallableStatement.<init>(JtdsCallableStatement.java:66)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2155)
> at
>
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareCall(Connec tionJDBC2.java:2141)
> at
>
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:135)
> ... 94 more
> 16:04:29,369 INFO [STDOUT] Jul 18, 2006 4:04:29 PM
> org.eclipse.birt.report.engine.data.dte.DteDataEngine execute
> SEVERE: Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [
> SELECT
> (
> CASE
> WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
> THEN CLAIM1.CLAIM_IID
> ELSE CLAIM1.SUBMITTED_CLAIM_IID
> END
> ) AS 'ClaimDS CLAIM_IID',
> CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
> CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
> CLAIM1.CLAIM_EID AS 'Claim Id',
> CLAIM1.ACCOUNT_EID AS 'Account Id',
> ACCOUNT.NAME AS 'Account',
> CLAIM1.PLAN_EID AS 'Plan Id',
> INSURANCE_PLAN.DESCRIPTION AS 'Plan',
> PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
> PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
> PATIENT.GENDER AS 'Gender',
> CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
> CLAIM1.BATCH_EID AS 'Batch',
> ENTERPRISE.NAME AS 'Enterprise',
> CLAIM1.CONTEXT AS 'Environment',
> CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
> CLAIM1.CLAIM_STATUS AS 'Claim Status',
> CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
> CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
> CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
> CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
> CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
> PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Sub Proc Code',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Adj Proc Code',
> CLAIM1.IS_MODIFIED AS 'Modified From Claim',
> CLAIM_LINE.SERVICE_UNITS AS 'Units',
> CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
> CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
> CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
> PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
> PRACTITIONER.FIRST_NAME AS 'Provider FName',
> PRACTITIONER.LAST_NAME AS 'Provider LName',
> CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
> CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
> CLAIM_LINE.RVU AS 'RVU',
> CLAIM_LINE.DISPOSITION AS 'Disposition',
> CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
> CLAIM_LINE.REFERENCE_LINES AS 'Ref Line ID',
> CLAIM_LINE.MODEL_LINE AS 'Model Line ID',
> CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
> CLAIM_LINE_MODIFIER.ADJUSTED_MODIFIER_CODE AS 'Adj Modifier Code',
> CLAIM_LINE_MODIFIER.MODIFIER_ORDER AS 'Modifier Order',
> MODIFIER_CODE.DESCRIPTION AS 'Modifier Description',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
> CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_ORDER AS 'Diagnosis Order',
> DIAGNOSIS_CODE.DESCRIPTION AS 'Diagnosis Description',
> CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
> CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
> CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
> CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
> CLAIM_LINE.PRIOR_AUTHORIZATION_CODE AS 'Pre-Auth',
> CLAIM_LINE.RULESET_NAME AS 'Ruleset',
> CLAIM_LINE.STATUS AS 'Status',
> (
> SELECT
> SUM(CLAIM_LINE.CHARGED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Sub Charge',
> (
> SELECT
> SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
> FROM
> CLAIM_LINE
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> AND
> CLAIM1.IS_MODIFIED = 'N'
> GROUP BY
> CLAIM_IID
> ) AS 'Total Adj Charge',
> (
> CASE
> WHEN
> (
> (
> SELECT
> COUNT(DISTINCT CLAIM_IID)
> FROM
> CLAIM
> WHERE
> CLAIM_IID = CLAIM1.CLAIM_IID
> OR
> SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
> ) > 1
> AND
> CLAIM1.IS_MODIFIED = 'N'
> )
> THEN 0
> ELSE 1
> END
> ) SHOW_RESULTS
> FROM
> CLAIM CLAIM1
> INNER JOIN
> CLAIM_LINE
> ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
> INNER JOIN
> ENTERPRISE
> ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
> LEFT OUTER JOIN
> PROCEDURE_CODE
> ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE = PROCEDURE_CODE.PROCEDURE_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_MODIFIER
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
> LEFT OUTER JOIN
> MODIFIER_CODE
> ON CLAIM_LINE_MODIFIER.MODIFIER_CODE = MODIFIER_CODE.MODIFIER_CODE
> LEFT OUTER JOIN
> CLAIM_LINE_DIAGNOSIS
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
> LEFT OUTER JOIN
> DIAGNOSIS_CODE
> ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE = DIAGNOSIS_CODE.DIAGNOSIS_CODE
> LEFT OUTER JOIN
> INSURANCE_PLAN
> ON CLAIM1.PLAN_EID = INSURANCE_PLAN.INSURANCE_PLAN_EID
> LEFT OUTER JOIN
> ACCOUNT
> ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
> LEFT OUTER JOIN
> CLAIM_LINE_EDIT
> ON CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_EDIT.CLAIM_LINE_IID
> LEFT OUTER JOIN
> PATIENT
> ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
> LEFT OUTER JOIN
> PRACTITIONER
> ON CLAIM_LINE.PRACTITIONER_IID = PRACTITIONER.PRACTITIONER_IID
> WHERE 1 = ?
> ]
> Error preparing SQL statement.
> Invalid JDBC escape syntax at line position 148 '}' character expected.
> org.eclipse.birt.data.engine.core.DataException: Failed to prepare the
> following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [
> SELECT
> (
> CASE
> WHEN CLAIM1.SUBMITTED_CLAIM_IID IS NULL
> THEN CLAIM1.CLAIM_IID
> ELSE CLAIM1.SUBMITTED_CLAIM_IID
> END
> ) AS 'ClaimDS CLAIM_IID',
> CLAIM1.CLAIM_IID AS 'Orig CLAIM_IID',
> CLAIM_LINE.CLAIM_LINE_IID AS 'ClaimDS CLAIM_LINE_IID',
> CLAIM1.CLAIM_EID AS 'Claim Id',
> CLAIM1.ACCOUNT_EID AS 'Account Id',
> ACCOUNT.NAME AS 'Account',
> CLAIM1.PLAN_EID AS 'Plan Id',
> INSURANCE_PLAN.DESCRIPTION AS 'Plan',
> PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
> PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
> PATIENT.GENDER AS 'Gender',
> CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
> CLAIM1.BATCH_EID AS 'Batch',
> ENTERPRISE.NAME AS 'Enterprise',
> CLAIM1.CONTEXT AS 'Environment',
> CLAIM1.LAST_ANALYSIS_DATE AS 'Analysis Date',
> CLAIM1.CLAIM_STATUS AS 'Claim Status',
> CLAIM_LINE.CLAIM_LINE_EID AS 'Line Id',
> CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
> CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
> CLAIM_LINE.SUBMITTED_PROCEDURE_CODE AS 'Sub Proc Code',
> CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
> PROCEDURE_CODE.DESCRIPTION AS 'Proc Code Desc',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.SUBMITTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Sub Proc Code',
> (
> CASE
> WHEN
> (
> SELECT
> COUNT(PROCEDURE_CODE)
> FROM
> PROCEDURE_CODE
> WHERE
> PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
> AND
> CATEGORY = 'CP'
> ) = 0
> THEN 0
> ELSE 1
> END
> ) AS 'AMA Adj Proc Code',
> CLAIM1.IS_MODIFIED AS 'Modified From Claim',
> CLAIM_LINE.SERVICE_UNITS AS 'Units',
> CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
> CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
> CLAIM_LINE.REVENUE_CODE AS 'Revenue Code',
> PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
> PRACTITIONER.FIRST_NAME AS 'Provider FName',
> PRACTITIONER.LAST_NAME AS 'Provider LName',
> CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
> CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
> CLAIM_LINE.RVU AS 'RVU',
> CLAIM_LINE.DISPOSITION AS 'Disposition',
> CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line
(Solved) Invalid JDBC escape syntax [with JDTS Driver] [message #179213 is a reply to message #178599] Thu, 20 July 2006 15:43 Go to previous message
Tyrone Hed is currently offline Tyrone Hed
Messages: 79
Registered: July 2009
Member
Folks,

This turned out to be a problem in that I was referring to a stored
procedure dataset in the .rptdesign file rather than the correct JDBC one.


(This is the right jdbc class if you're NOT using a stored procedure)

<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Claim Data Set" id="6">


Thank you,
Ty
Previous Topic:chart series dataset altering
Next Topic:Building a URL fails when using MBCS
Goto Forum:
  


Current Time: Wed Apr 23 02:49:51 EDT 2014

Powered by FUDForum. Page generated in 0.04630 seconds