by Joget, Inc.
FREE
1000
DESCRIPTION

The JDBC Options Binder Plugins allows you to use SQL Select statements, to retrieve and populate 3 types of form elements.

The data could come from the default Joget database or an external database source of your choice.

You can use the JDBC Options Binder plugin on the following form elements:

  • Checkbox
  • Radio
  • SelectBox

If an "external database source" is required, you will need to specify the following:

  • Custom JDBC Driver
  • Custom JDBC URL
  • Custom JDBC Username & Password

Example of a SQL Select statement:

SELECT id, c_CountryName FROM app_fd_country

Do download all three plugins sets as they work together:

Note: In a Joget database, your actual table name is prefix with "app_fd_" and column name prefix with "c_".

Read more at Joget Knowledge Base

  

Notes

  • Joget Enterprise v6 & DX comes preinstalled with JDBC plugins and the v6 & DX plugins are not compatible with v5 JDBC plugins..
  • In a Joget database, your actual table name is prefix with "app_fd_" and column name prefix with "c_". Read more at Joget Knowledge Base

 

What's New

  • Updated on 01-Mac-2016 for fix on Custom Datasource.
  • Updated on 23-Oct-2019 for Joget v6 Professional and Enterprise. This JDBC binder will display with binder name "... (Marketplace)" appended.

  

Steps To Import This Plugin

  1. Click "Download" on this plugin screen (It will be a .jar file).
  2. Go to your Joget localhost or server, in Joget Console navigate to "Admin Bar>Systems Settings>Manage Plugins" and click "Upload Plugins" button.
  3. In "Upload Plugin", select the plugin .jar file you just downloaded, then click "Upload".
  4. Depending on the plugin type, you can now view your new plugin in your form or datalist or userview.
  5. Remember to always uninstall the old plugin before uploading a new version.
  6. The Joget Knowledge Base has more information on managing and developing plugins.

 

Additional Plugin Information
October 23, 2019
FREE
365
v5.0.2
Developer Info
Joget, Inc.
Write a review
Reviews
Print