This statement connect to a database. The connection is saved in a variable,
whose name is the first parameter, which is optional. If no name given, it is saved
in the default connection, $$con . The JDBC URL and database user name and password
are specified following the to keyword.
JDBC driver class names usually do not be loaded explicitly like in Java programs,
because JudoScript has knowledge about the following drivers and pick one from the
JDBC URL (and the list will grow to cover new ones that come to attention):
JDBC DB ID | JDBC Driver Class |
cloudscape | COM.cloudscape.core.JDBCDriver |
db2 | COM.ibm.db2.jdbc.net.DB2Driver |
hsqldb | org.hsqldb.jdbcDriver |
idb | org.enhydra.instantdb.jdbc.idbDriver |
informix-sqli | com.informix.jdbc.IfxDriver |
jtds | org.sourceforge.jtds.jdbc.Driver |
microsoft | com.microsoft.jdbc.sqlserver.SQLServerDriver |
msql | com.imaginary.sql.msql.MsqlDriver |
mysql | com.mysql.jdbc.Driver, org.gjt.mm.mysql.Driver |
odbc | sun.jdbc.odbc.JdbcOdbcDriver |
oracle | oracle.jdbc.driver.OracleDriver |
pointbase | com.pointbase.jdbc.jdbcUniversalDriver |
postgres95 | postgres95.PGDriver |
postgresql | org.postgresql.Driver, postgresql.Driver |
sapdb | com.sap.dbtech.jdbc.DriverSapDB |
solid | solid.jdbc.SolidDriver |
sqlbase | centura.java.sqlbase.SqlbaseDriver |
sybase | com.sybase.jdbc2.jdbc.SybDriver |