Difference between revisions of "Database Resource"
Line 9: | Line 9: | ||
for instance in the case shown, you could override the username and password by creating a file props.txt | for instance in the case shown, you could override the username and password by creating a file props.txt | ||
− | + | user=admin | |
− | + | password=presadmin | |
http://www.international-presence.com/images/docs/res/sql/sqlres_connectiondetails.png | http://www.international-presence.com/images/docs/res/sql/sqlres_connectiondetails.png | ||
Line 37: | Line 37: | ||
${control.database.user} | ${control.database.user} | ||
+ | |||
${control.database.password} | ${control.database.password} | ||
For more info on how to connect to different types of database and how to aid connection pooling see [[Database Connectivity]] | For more info on how to connect to different types of database and how to aid connection pooling see [[Database Connectivity]] |
Revision as of 16:16, 22 January 2010
There are 3 tabs to the database resource.
The first tab you specify the driver class, which may need to be imported via the jar manager.
After this the connection url which may or may not include the database name.
The properties file is if you wish to set the connection properties via a file,
for instance in the case shown, you could override the username and password by creating a file props.txt
user=admin password=presadmin
http://www.international-presence.com/images/docs/res/sql/sqlres_connectiondetails.png
A test of the connection should reveal:-
http://www.international-presence.com/images/docs/res/sql/sqlres_connected.png
As it is common to store the username and password in the SQL Node, rather than the Resource, the 3rd tab on the Resource dialog can be useful when you wish to update the username and password for all SQL Nodes that use this SQL Resource
http://www.international-presence.com/images/docs/res/sql/sqlres_passwordupdate.png
Note it is also possible to override the username and password and even SQL Resource for an SQL Node via presence variables, namely:-
http://www.international-presence.com/images/docs/res/sql/sqlres_vars.png
We set the variables before an SQL Node
${control.database.override}
If this is specified then the SQL Node will use the SQL Resource with this ID rather than its specified resource The ID for a resource can be found on the Connection tab of the SQL Resource
${control.database.user}
${control.database.password}
For more info on how to connect to different types of database and how to aid connection pooling see Database Connectivity