Skip to content

Instantly share code, notes, and snippets.

@albinkjellin
Last active August 29, 2015 14:27
Show Gist options
  • Save albinkjellin/cedf274a35135417629b to your computer and use it in GitHub Desktop.
Save albinkjellin/cedf274a35135417629b to your computer and use it in GitHub Desktop.
Sample config for setting up ssl jdbc with postrgresql with the mulesoft database connector
<db:generic-config name="Generic_Database_Configuration" doc:name="Generic Database Configuration" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://${db.host}:${db.port}/testssl?user=${db.user}&amp;password=${db.password}&amp;sslmode=verify-full&amp;sslrootcert=${app.home}/classes/rds-combined-ca-bundle.pem"/>
<http:listener-config name="HTTP_Listener_Configuration" host="0.0.0.0" port="8081" doc:name="HTTP Listener Configuration"/>
<flow name="postgress-ssl">
<http:listener config-ref="HTTP_Listener_Configuration" path="/trigger" doc:name="HTTP"/>
<db:select config-ref="Generic_Database_Configuration" doc:name="Database">
<db:parameterized-query><![CDATA[select * from test;]]></db:parameterized-query>
</db:select>
<object-to-string-transformer doc:name="Object to String"/>
</flow>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment