MySQL:
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/DBNAME

Oracle:
driver=oracle.jdbc.driver.OracleDriver

jdbc:oracle:<drivertype>:<username/password>@<database>
example: jdbc:oracle:thin:scott/tiger@myhost:1521/orcl

Another possibility is to replace <database> with TNS name, or simply put the whole TNS entry (then you don't need tnsnames.ora):

url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1524))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBNAME)))





