| |
JDBC Configuration
Parameters |
| |
|
| |
|
 |
Make
changes in zeroCode: |
|
|
|
To make
your site compatible to a particular database, there are two things
you need to do. Pass database parameters in config.txt of zDE and
make changes in the resin.conf. |
|
|
|
I. |
Login to the zDE
and open the required site. In the zDE’s site root, you will find
a directory called config. Open it. click on config.txt on the right
pane. Click on it. The edit Site Configuration page opens up. You
need to provide relevant information under the section “Database
parameters”. Here is the information you need to provide: |
|
 |
Database type :
PostgreSQL, Point base, or DB2. |
|
|
JDBC driver's class
name |
|
|
JDBC connect string
(also called the JDBC URL): The URL can be passed in this format -
the protocol for connection, machine host name and optional port
number, and the relative path of the resource. Your JDBC driver will
come with instructions detailing how to form the URL for your
database. It might look similar to this - jdbc:mysql://db_server:3306/contacts/) |
|
|
Database server
name: The server that hosts the database |
|
|
Database user name |
|
|
Database password |
|
You
will want to control access to your data, unless security is not an
issue. The standard least common denominator for authentication to a
database is a pair of strings, an account and a password. The
account name and password you give the driver should have meaning
within your DBMS, where permissions should have been established to
govern access privileges. |
|
|
|
|
II. |
If you are adding a
new JDBC driver class, you also need to do the following:
Telnet to
the server. Access the directories: Yoursitename/webServer/resin/conf.
In the conf directory you will find a file called resin.conf. In
this file, add the class path for the JDBC driver class that you are
going to use. For e.g: <classpath id= “stdlib/jarfilename”/>.
|
|
|
|
|
Click
here for examples on how you set database parameters for DB2, PostgreSQL and Pointbase |
|
|
|
|
|
|
|
|
|
| |
|
