Datasource Configuration

Overall Changes

The “En/Disable” button is sort of confusing. Can’t we have a button that is grey’ed out, and based on the datasource in question is enabled with the text “Enable” or “Disable” ?

Attributes

• Name
• JNDI
• Enabled
• Statistics enabled
• Driver

Remove: Datasource-class, Driver-class, Share Prepared Statements, Statement Cache Size

Connection

• Connection URL
• New Connection SQL
• Transaction Isolation
• Use JTA
• Use CCM

Pool

• Min Pool Size
• Initial Pool Size
• Max Pool Size
• Prefill
• Flush strategy
• Strict Minimum
• Use fast fail

Remove: Idle Timeout, Track statements
Add: Initial pool size, Use fast fail

Flush strategy is a drop-down

• FailingConnectionOnly (default)
• InvalidIdleConnections
• IdleConnections
• Gracefully
• EntirePool
• AllInvalidIdleConnections
• AllIdleConnections
• AllGracefully
• AllConnections

Capacity policies will not be part of the first cut.

Security

Add: Allow Multiple Users, Reauthentication plugin

Validation

Validation Millis → Background Validation Millis

Timeouts

• Use tryLock() → Use try lock
• Set Tx Query Timeout → Set Transaction Query Timeout

Statements (new tab)

• Track Statements (allowed values: true, false, nowarn)
• Share Prepared Statements
• Prepared Statement Cache Size