JDBC Connection Cheatsheet
Whether directly accessing a database or setting up a DataSource in a container, the developer must know the name of the driver and the connection string. The following table lists the most common databases with their driver name and a sample connection string To load the driver, you can call the Class.forName method: Class.forName("org.hsqldb.jdbcDriver");
For direct connections, use the DriverManager and pass the connection string, username and password:
DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/dbname", "sa", "");
The actual steps for adding a DataSource to your container will vary