-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsimple.js
More file actions
49 lines (42 loc) · 1.22 KB
/
simple.js
File metadata and controls
49 lines (42 loc) · 1.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
var JDBC = require('jdbc');
var jinst = require('jdbc/lib/jinst');
if (!jinst.isJvmCreated()) {
jinst.addOption("-Xrs");
jinst.setupClasspath(['/home/machbase/machbase_home/lib/machbase.jar']);
}
var config = {
url :'jdbc:machbase://localhost:5656/mhdb',
drivername: 'com.machbase.jdbc.MachDriver',
minpoolsize: 10,
maxpoolsize: 100,
user: 'SYS',
password: 'MANAGER',
properties: {}
};
var machdb = new JDBC(config);
machdb.initialize(function(err) {
if (err) {
console.log(err);
}
});
machdb.reserve(function(err, connObj) {
var conn = connObj.conn;
conn.createStatement(function(err, statement) {
if (err) {
callback(err);
} else {
statement.executeQuery("SELECT * FROM v$tables limit 3;", function(err, resultset) {
if (err) {
callback(err)
} else {
// Convert the result set to an object array.
resultset.toObjArray(function(err, results) {
if (results.length > 0) {
console.log(results);
}
});
}
});
}
});
});