Connect with jt400 and implement memcached in your projects.
Download jt400.jar and copy in your path.
More info: http://jt400.sourceforge.net/
npm install jt400-memcached
var sql = require('jt400-memcached');
var connection = {
libpath: __dirname + '/jt400.jar',
drivername: 'com.ibm.as400.access.AS400JDBCDriver',
url: 'jdbc:as400://127.0.0.1/myDatabase;user=myUser;password=myPassword'
};
sql.setMemcachedServers( '127.0.0.1:11211' );
sql.debug( true );
var test = new sql.prepare({
query: 'SELECT foo FROM bar',
connection: connection,
cache: true,
lifetime: 100
});
test.execute();
test.success = function(data){
console.log(data);
};
test.error = function(error){
console.log(error);
};
node app.js