Skip to content

Instantly share code, notes, and snippets.

@ricston-git
Last active December 12, 2015 10:48
Show Gist options
  • Save ricston-git/4761352 to your computer and use it in GitHub Desktop.
Save ricston-git/4761352 to your computer and use it in GitHub Desktop.
groovy expression does not return null
<flow name="myFlow">
...
<jdbc:outbound-endpoint queryKey="insertElement" connector-ref="jdbcConnector" />
...
</flow>
<jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
<jdbc:query key="insertElement" value="INSERT INTO MyTable (id, date) VALUES (#[function:uuid], #[groovy:result = (payload.date == null ? null : com.ricston.XmlUtils.toSqlDate(payload.date))])"/>
</jdbc:connector>
<jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
<jdbc:query key="insertElement" value="INSERT INTO MyTable (id, date) VALUES (#[function:uuid], #[groovy:payload.date == null ? null : com.ricston.XmlUtils.toSqlDate(payload.date)])"/>
</jdbc:connector>
Exception stack is:
1. Unable to convert between org.mule.transport.NullPayload and JAVA_OBJECT.(SQL Code: 0, SQL State: + 22005) (java.sql.SQLException)
net.sourceforge.jtds.jdbc.Support:533 (null)
2. Failed to route event via endpoint: DefaultOutboundEndpoint{endpointUri=jdbc://insertElement, connector=EEJdbcConnector
...
********************************************************************************
Root Exception stack trace:
java.sql.SQLException: Unable to convert between org.mule.transport.NullPayload and JAVA_OBJECT.
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment