Difference between revisions of "Database Resource"

From PresenceWiki
Jump to: navigation, search
Line 23: Line 23:
  
 
http://www.international-presence.com/images/docs/res/sql/sqlres_passwordupdate.png
 
http://www.international-presence.com/images/docs/res/sql/sqlres_passwordupdate.png
 +
 +
 +
== Overriding values via variables ==
 +
  
 
Note it is also possible to override the username and password and even SQL Resource for an SQL Node
 
Note it is also possible to override the username and password and even SQL Resource for an SQL Node

Revision as of 16:31, 22 January 2010

In the Connection Details tab we specify the name of the resource and the driver class, which may need to be imported via the jar manager.

After this the we need 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

Note, this tab also displays the internal Resource ID for this resource.

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 Global Password Update tab

provides a way 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


Overriding values via variables

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}

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} SQL node will use this value for the username in the connection

${control.database.password} SQL node will use this value for the password in the connection


For more info on how to connect to different types of database and how to aid connection pooling see Database Connectivity