Page History

Image RemovedImage Added

Figure 1 : JDBC Action Menu

Image RemovedImage Added

Figure 2 : JDBC Datalist Action
Properties

Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above.
Example: com.mysql.jdbc.Driver

Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above.
Example: jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.

Insert your SQL statement here. Use syntax like {id} in query to inject the selected row key. Use {uuid} to generate a unique id (or primary key). Examples:

INSERT INTO app_fd_sample (id, c_clicked) VALUES ( {uuid}, {id} );

UPDATE app_fd_sample SET c_clicked = CONCAT(c_clicked, ',', {id}) WHERE id = {id};

DELETE FROM app_fd_myTable WHERE id = {id}