Skip to content

Instantly share code, notes, and snippets.

@adrianhsieh

adrianhsieh/jdbc_connector.xml

Created September 22, 2012 19:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save adrianhsieh/3767588 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save adrianhsieh/3767588 to your computer and use it in GitHub Desktop.
Download ZIP
JDBC Connector Config
Raw
jdbc_connector.xml
<jdbc-ee:connector name="apache-derby" dataSource-ref="datasource" validateConnections="false" queryTimeout="-1" pollingFrequency="0" doc:name="Database">
<jdbc-ee:query key="insertRecord" value="INSERT INTO table1 (Name, External_ID__c, Value__c, Last_Modified) VALUES (#[map-payload:name], #[map-payload:externalid], #[map-payload:value], #[map-payload:lastmodified])"/>
<jdbc-ee:query key="selectRecord" value="SELECT Name, External_ID__c, Value__c FROM table1 ORDER BY Last_Modified"/>
</jdbc-ee:connector>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment