PlugIns JdbcSlim UserGuide 3HowtoConfigureTheDatabaseConnection
In case you need to pass more parameters then user and password to open the database connection
then you can define these in a separate list and pass this list with the parameter dbProperties to the jdbc open connection function
| Define Properties | DatabaseProperties |
| key | value |
| USER | na |
| PASSWORD | na |
| Define Properties | ConnectionWithProperties |
| key | value |
| jdbcDriver | org.h2.Driver |
| DBURL | jdbc:h2:mem:h2db;DB_CLOSE_DELAY=-1 |
| DBProperties | DatabaseProperties |
| CMD |
| SQLCommand | ConnectionWithProperties | select * from TestData where ID = '1' | Query | |
| ID | Name | Phone | City | Profession |
| 1 | Bill | 12345 | Berlin | Doctor |