[
https://issues.apache.org/jira/browse/SYNAPSE-1057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16178340#comment-16178340
]
Vanjikumaran Sivajothy commented on SYNAPSE-1057:
-------------------------------------------------
Configuration for reproducing the issue.
{code}
<dblookup>
<connection>
<pool>
<password>admin</password>
<user>test123</user>
<url>jdbc:mysql://localhost:3306/TESTDB</url>
<driver>com.mysql.jdbc.Driver</driver>
</pool>
</connection>
<statement>
<sql>SELECT * FROM employee WHERE name =?</sql>
<parameter value="STRINGVALUE" type="INTEGER"/>
<result name="company_id" column="id"/>
</statement>
</dblookup>
{code}
Observation
{code}
ERROR {org.apache.synapse.mediators.db.DBLookupMediator} - Error executing
statement : SELECT * FROM employee WHERE name =? against DataSource :
jdbc:mysql://localhost:3306/TESTDB
{org.apache.synapse.mediators.db.DBLookupMediator}
java.lang.NumberFormatException: For input string: "STRINGVALUE"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.parseInt(Integer.java:527)
at
org.apache.synapse.mediators.db.AbstractDBMediator.getPreparedStatement(AbstractDBMediator.java:338)
at
org.apache.synapse.mediators.db.DBLookupMediator.processStatement(DBLookupMediator.java:45)
{code}
> Spelling mistake and un handled exceptions
> ------------------------------------------
>
> Key: SYNAPSE-1057
> URL: https://issues.apache.org/jira/browse/SYNAPSE-1057
> Project: Synapse
> Issue Type: Bug
> Components: Core
> Reporter: Vanjikumaran Sivajothy
> Assignee: Vanjikumaran Sivajothy
> Priority: Minor
> Labels: patch
> Fix For: FUTURE
>
> Attachments: SYNAPSE1057.patch
>
>
> When DBLookup/DBreport exception happens, The flow doesn't go to
> faultSequence as the handled exception.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@synapse.apache.org
For additional commands, e-mail: dev-h...@synapse.apache.org
