Difference between revisions of "Database Resource"

From PresenceWiki
Jump to: navigation, search
Line 1: Line 1:
Here we will discuss database connections.
+
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
 
http://www.international-presence.com/images/docs/res/sql/sqlres_connectiondetails.png

Revision as of 16:05, 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

http://www.international-presence.com/images/docs/res/sql/sqlres_passwordupdate.png

http://www.international-presence.com/images/docs/res/sql/sqlres_connected.png

http://www.international-presence.com/images/docs/res/sql/sqlres_vars.png

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