Package com.adaptris.core.json.jdbc

Class UpsertJsonObject

java.lang.Object
com.adaptris.core.ServiceImp
com.adaptris.core.jdbc.JdbcService
com.adaptris.core.services.jdbc.JdbcMapInsert
com.adaptris.core.services.jdbc.JdbcMapUpsert
com.adaptris.core.json.jdbc.UpsertJsonObject
All Implemented Interfaces:
AdaptrisComponent, ComponentLifecycle, ComponentLifecycleExtension, ConfigComment, ConnectedService, MessageEventGenerator, Service, StateManagedComponent
Direct Known Subclasses:
UpsertJsonObjects
@ComponentProfile(summary="Insert/Update a JSON object into a database", tag="service,json,jdbc", since="3.6.5") public class UpsertJsonObject extends JdbcMapUpsert
Convenience service for inserting/updating a JSON object into a database.

Creates an insert or update statement based on the contents of the JSON object. { "firstname":"carol", "lastname":"smith", "dob":"2017-01-03", "id": "1234"} will effectively execute the following statement INSERT INTO table (firstname,lastname,dob,id) VALUES (?,?,?,?) or UPDATE table SET firstname=?, lastname=?, dob=? WHERE id = ?; if 1234 already exists as a row.

Note that no parsing/assertion of the column names will be done, so if they are invalid SQL columns then it's going to be fail. Additionally, nested JSON objects will be rendered as strings before being passed into the appropriate statement; so { "firstname":"alice", "lastname":"smith", "address": { "address" : "Buckingham Palace", "postcode":"SW1A 1AA"}} would still be 3 parameters, the address parameter will be '{ "address" : "Buckingham Palace", "postcode":"SW1A 1AA"}'

Since:
3.6.5

In the adapter configuration file this class is aliased as json-jdbc-upsert which is the preferred alternative to the fully qualified classname when building your configuration.

  • Constructor Details

    • UpsertJsonObject

      public UpsertJsonObject()

  • Method Details

    • doService

      public void doService(AdaptrisMessage msg) throws ServiceException
      Throws:
      ServiceException

    • getNullConverter

      public NullConverter getNullConverter()
      Returns:
      the nullConverter

    • setNullConverter

      public void setNullConverter(NullConverter nc)
      Specify the behaviour when a NullNode is encountered.
      Parameters:
      nc - the NullConverter to set, the default is effectively the string "null" as returned by NullNode#asText()