URL Syntax (Including User Name and Password)

The first connection method specifies all connection parameters in a URL string including the user name and password.

java.sql.DriverManager.getConnection(url)

where:

String url =

"jdbc:allbase://host[:port]/database?UID=uid&PWD=pwd"

"[&TRACE=trace]";

host: Name or IP address of the sever host.
port: Optional port number on which the JDBC Monitor is listening. If not specified, the default part number 31700 is used.
database: ALLBASE/SQL or IMAGE/SQL database name.
uid: Server host userid that is authorized to access the database.
pwd: Server host password that matches the user id provided above.
trace: Optional trace values separated by the vertical bar "|" character. For more information on tracing, see the Troubleshooting section.




	NOTE: This connection method may result in the user name and password being logged in various places, as URLs are commonly logged on various web servers and proxy servers. The URL is also logged if tracing is turned on. For this reason, the second connection method is preferred.

Technical documentation