JDBCConn.prototype.open = function (callback, isAutoCommit) {
var self = this;
if (isAutoCommit == undefined) {
isAutoCommit = true;
}
if (self._config.user || self._config.password) {
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, self._config.user, self._config.password, function (err, conn) {
if (err) {
return callback(err);
} else {
conn.setAutoCommit(isAutoCommit);
self._conn = conn;
return callback(null, conn);
}
});
} else {
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, function (err, conn) {
if (err) {
return callback(err);
} else {
conn.setAutoCommit(isAutoCommit);
self._conn = conn;
return callback(null, conn);
}
});
}
};
Database.prototype.executeUpdate = function (sql) {
const self = this;
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, function (getConnectionError, conn) {
if (getConnectionError) {
self.emit('execute', getConnectionError, null);
} else {
conn.createStatement(function (createStatementError, statement) {
if (createStatementError) {
self.emit('execute', createStatementError, null);
console.log(createStatementError);
} else {
statement.executeUpdate(sql, function (executeQueryError, rowCount) {
if (executeQueryError) {
self.emit('execute', executeQueryError, null);
console.log(executeQueryError);
} else {
self.emit('executeUpdate', null, rowCount);
}
});
}
});
}
});
return self
};
Database.prototype.executeStoredProc = function(procedure,outputParams) {
var self = this;
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, function(getConnectionError, conn) {
if (getConnectionError) {
self.emit('executeStoredProc', getConnectionError, null);
} else {
conn.prepareCall(procedure,function(prepareCallError, callStatement) {
if (prepareCallError) {
self.emit('executeStoredProc', prepareCallError, null);
}
else {
var error = false;
for (i = 0; i < outputParams.length; i++)
{
if("Value" in outputParams[i])
{
callStatement.setString(outputParams[i].Index,outputParams[i].Value,function(setStringError, setString) {
if (setStringError) {
self.emit('executeStoredProc', setStringError, null);
error = true;
}
});
}
callStatement.registerOutParameter(outputParams[i].Index, outputParams[i].DataType,function(registerOutParameterError) {
if (registerOutParameterError) {
self.emit('executeStoredProc',registerParameterError, null);
}
});
}
if(error == false)
{
callStatement.execute(function(executeError, resultString) {
if (executeError) {
self.emit('executeStoredProc', executeError, null);
}
else {
var result = {};
for (i = 0; i < outputParams.length; i++) {
if(i <= outputParams.length - 1 )
{
result[outputParams[i].Index] = callStatement.getStringSync(outputParams[i].Index).trim();
}
}
self.emit('executeStoredProc', null, result);
}
});
}
}
});
}
});
}
exports.javaPackageExample = function(req,res) {
var java = require('java');
java.classpath.push(__dirname+'/../jars/example_2.jar');
java.callStaticMethod("com.ser.as400.webservice.Lubricantes", "name", "amos rivera", function(err, results) {
if(err) { console.error(err); return; }
console.log( results);
});
}
Database.prototype.execute = function (sql) {
const self = this;
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, function (getConnectionError, conn) {
if (getConnectionError) {
self.emit('execute', getConnectionError, null);
} else {
conn.createStatement(function (createStatementError, statement) {
if (createStatementError) {
self.emit('execute', createStatementError, null);
console.log(createStatementError);
} else {
statement.executeQuery(sql, function (executeQueryError, resultset) {
if (executeQueryError) {
self.emit('execute', executeQueryError, null);
console.log(executeQueryError);
} else {
resultset.getMetaData(function (getMetaDataError, rsmd) {
if (getMetaDataError) {
self.emit('execute', getMetaDataError, null);
console.log(getMetaDataError);
} else {
var cc = rsmd.getColumnCountSync();
var results = [];
var next = resultset.nextSync();
while (next) {
var row = {};
for (var i = 1; i <= cc; i = i+1) {
var colname = rsmd.getColumnNameSync(i);
var item = resultset.getStringSync(i);
if (!S(item).isEmpty()) {
row[colname] = S(item).trim().s
} else {
row[colname] = '';
}
}
results.push(row);
next = resultset.nextSync();
}
self.emit('execute', null, results);
}
});
}
});
}
});
}
});
return self
};
_teardown : function (api, next) {
try {
// Explicit exit JVM (needed because the JVM was started with the -Xrs option)
java.callStaticMethod('java.lang.System', 'exit', 0);
} catch (e) {
api.log('Error : ' + e, 'error');
}
next();
},
JDBCConn.prototype.open = function() {
var self = this;
java.callStaticMethod('java.sql.DriverManager','getConnection', self._config.url, function(err, conn) {
if (err) {
throw new Error(err);
} else {
self._conn = conn;
self.emit('open', conn);
}
});
};
JDBCConn.prototype.open = function(callback) {
var self = this;
java.callStaticMethod('java.sql.DriverManager','getConnection', self._config.url, function(err, conn) {
if (err) {
return callback(err);
} else {
self._conn = conn;
return callback(null, conn);
}
});
};
Database.prototype.open = function() {
var self = this;
java.callStaticMethod('java.sql.DriverManager', 'getConnection', self._config.url, function(getConnectionError, conn) {
if (getConnectionError) {
self.emit('open', getConnectionError, null);
} else {
self._conn = conn;
self.emit('open', null, conn);
}
});
};
java.newInstance(self._config.drivername, function (err, driver) {
if (err) {
return callback(err);
} else {
java.callStaticMethod('java.sql.DriverManager', 'registerDriver', driver, function (err, result) {
if (err) {
return callback(err);
} else {
return callback(null, self._config.drivername);
}
});
}
});
java.newInstance(self._config.drivername, function (err, driver) {
if (err) {
throw new Error(err);
} else {
java.callStaticMethod('java.sql.DriverManager', 'registerDriver', driver, function (registerDriverError/*, result */) {
if (registerDriverError) {
self.emit('init', registerDriverError, null);
} else {
self.emit('init', null, self._config.drivername);
}
});
}
});
java.callStaticMethod('java.sql.DriverManager','registerDriver', driver, function(err, result) {
if (err) {
self.emit('init', err);
} else {
java.callStaticMethod('java.sql.DriverManager','getConnection', self._config.url, function(err, conn) {
if (err) {
console.log(err);
self.emit('init', err);
} else {
self._conn = conn;
self.emit('init',null);
}
});
}
});