Connecting ... The Database field

Related Topics:  Connecting  |  The Driver File field |  Contents

The Database field specifies three things:

jdbc:server:	//serv3.xyz.org/	maxd
PROTOCOL	MACHINE NAME	DATABASE NAME

• which connection protocol to use
• the name of the machine on which the database server is running
• the name of the database

The formatting of the string is crucial, it is important to ensure the : and / characters are placed correctly.

jdbc:oracle://localhost/maxd
jdbc:postgresql://myhost.mylab.myfirm.com/maxd-public
jdbc:mysql://192.168.220.42/maxd

The connection protocol is always jdbc: followed by a string identifying the database server type, for example:

    jdbc:mysql:
    jdbc:oracle:
    jdbc:postgresql:
    jdbc:Microsoft:sqlserver:

The name of the machine is specified in the same way as with website addresses, for example:

   //myhost.mylab.myfirm.com/
   //192.168.220.42/
   //localhost/

The special value localhost can be used when the database server is running on the same machine as maxdLoad.

The final part of the string is the name of the database. This is the name that was used when the database was created, it is usually maxd.