2022.2

Thesyntaxwillbespecifictothedatabase,ormorepreciselytheJDBCconnector.CurrentlyDatamap-
persupportsthefollowingJDBCconnectors:
l
com.mysql.cj.jdbc.Driver
l
sun.jdbc.odbc.JdbcOdbcDriver
l
com.microsoft.sqlserver.jdbc.SQLServerDriver
l
oracle.jdbc.OracleDriver
user
Stringthatrepresentsthenameofthedatabaseuseronwhosebehalftheconnectionisbeingmade.
Thisisusedforauthentication.
password
Stringthatrepresentstheuser'spassword.Thisisusedforauthentication.
Example
Here'sanexampleofhowtoconnecttoamySQLdatabaseandretrieveadatavalue.
con = db.connect('jdbc:mysql://localhost:3306/mycompany','root','admin');
statement = con.createStatement();
values = statement.executeQuery("select * from datavalue");
if (values.next())
values.getString("data");
else
'nothing';
values.close();
statement.close();
con.close();
logger
Globalobjectthatallowsloggingmessagessuchaserror,warningorinformationalmessages.
Methods
Thefollowingtabledescribesthemethodsoftheloggerobject.
Method Parameters Description
error() message:String Logsanerrormessage
info() message:String Logsaninformationalmessage
warn() message:String Logsawarningmessage
record
Thecurrentrecordinthemaindataset.
Page 390