Pooled Data Connection based on c3p0
Consider adding these properties to the c3p0 data connection
pool properties and exposing them in your admin interface.
In large enterprises mis-configuring database connection settings
w/ the wrong password can cause the network security infrastructure
to shutdown access to boxes that you would like to have access
to.
In it's current implementation w/o the settings noted below a mis
configured username / passwd combination will cause 100's of
connections to be spawned up against a database server w/o anyway
of knowing that it failed - other than "Test Connection Failed"
message being displayed at the SaffronAdmin interface.
Have tested this against a TeraData jdbc connection which dis
allows further access after you get the passwd wrong 3
times.
<property name="acquireRetryAttempts" value="1" />
<property name="acquireRetryDelay" value="10000" />
<property name="breakAfterAcquireFailure" value="true" />
<property name="debugUnreturnedConnectionStackTraces" value="true" />
Support Staff 2 Posted by Jim Fleming on 30 Mar, 2010 01:53 PM
Patrick, You should be able to manually add them to your bean definition in the config file. I will add it as a SaffronAdmin feature request.
Thanks,
Jim
3 Posted by Harry Stovall on 31 Mar, 2010 12:13 AM
Hi Jim -
FYI, Patrick is on vacation.
Anyway, I think part of the issue was that if you make any change in SaffronAdmin then any additional properties that were added in the bean definition in saffron.xml would disappear. Specifically, we HAVE to set the password via SaffronAdmin to be encoded which will clobber the other settings that then would have to be added back into the XML.
Another related question: There is a file in /home/saffron/smb/conf: DatabaseResources.properties that has configuration for mysql & oracle. Is this file used at all? If so, is there some way to extend it and add the correct information for Teradata?
Thx
Harry
Support Staff 4 Posted by Jim Fleming on 01 Apr, 2010 08:36 PM
Harry, Got it on the setting, the LH ticket should address that. Regarding adding more templates, you canot do that. The mysql and oracle templates are the only ones. You can change them, but you cannot add a teradata template. Let us know if you want to be able to add more templates and we'll add it as a feature request.
Thanks,
Jim