
Database Query
Components User's Guide
63
6
Click
OK
. The new data source is added to the list in the Project | Data Sources view.
The data source is stored as a .nds file in Collage, in the System \ Data Sources
deploy folder.
JDBC
Driver
Name and class
path, if
necessary, of
the database
driver to use
Choose a database driver from the drop-down
list, such as
Sybase
, or choose the
Specify
class name
option, then enter the class name
and path to the driver. For example, the path to
the Sybase JDBC driver which Collage uses
internally is:
com.sybase.jdbc2.jdbc.SybDriver
Collage then uses the class path to load the
driver from the file that contains it, which is
either stored in Collage and defined in the
Fetch
Driver from Asset
field, or is external but in
the class path for Tomcat, or whichever
application server you use to host Collage.
Asset
driver
The asset in
Collage that
contains the
JDBC driver
class file
Choose this option if you want Collage to load
the JDBC driver from an asset in Collage. Then,
browse to select this asset. To use this option,
you must upload the JAR file that contains the
driver to Collage.
IMPORTANT!
If you do not choose this
option, the JDBC driver must be in the class
path for Tomcat, or whichever application
server you use to host Collage.
Username
The username
for the
database, which
the JDBC driver
will pass to the
database server
Enter the administrator username for the
database.
Password
The password
for the
database, which
the JDBC driver
will pass to the
database server
Enter the administrator password for the
database.
Add
Any additional
parameters and
values required
by the JDBC
driver
Enter the
Name
and
Value
for each parameter,
then click the
Add
button. All parameters are
then listed below. You can delete any of the
parameters from the list. For example, on
Sybase, this might include a
ServiceName
parameter, which Sybase uses to locate and
connect to a specific database, as defined by the
value of this parameter.
Field Description Guidelines
Kommentare zu diesen Handbüchern