<% var db = new Database("jdbc:h2:tmp/demo", "admin", "admin"); db.query("INSERT INTO demo VALUES('WSO2','59 Flower Rd'), ('WSO2 UK', 'Emsworth, Hampshire, UK');"); var result = db.query("SELECT * FROM demo"); print(result); %>
The Database Object is used to connect to a relational database through jaggery and provides most of the default functionality and manipulation through the below members/functions. Jaggery out of the box support H2 database engine, and with little configuration supports MySql and Oracle.
In-order to connect to other database engines, you need to place the connector libs (MySql lib, Oracle lib) into Jaggery runtime. you can copy these files to {JAGGERY_HOME}/carbon/repository/components/lib/
Operation | Returns | Description |
---|---|---|
Database(connectionUrl, | Database | var db = new Database("jdbc:h2:demo", "admin", "admin");Returns Database object for database communication var config = { defaultAutoCommit: boolean, defaultReadOnly: boolean, defaultTransactionIsolation: "String", defaultCatalog: "String", maxActive: number, maxIdle: number, minIdle: number, initialSize: number, maxWait: number, testOnBorrow: boolean, testOnReturn: boolean, testWhileIdle: boolean, validationQuery: "String", accessToUnderlyingConnectionAllowed: boolean, logAbandoned: boolean, connectionProperties: "String", initSQL: "String", validationInterval: number, maxAge: number, suspectTimeout: number } var db = new Database("jdbc:h2:demo", "admin", "admin", config);Returns Database object for database communication with optional configurations |
query(query, callback) | String | db.query("SELECT * FROM myTable", function(results) {}) Query result will be returned to the callback |
commit() | None | db.commit()SQL transaction commit |
rollback() | None | db.rollback()SQL transaction rollback |
close() | None | db.close()SQL connection close |