Package Exports

jt400

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (jt400) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

jt400

Download jt400.jar and copy in your path.

More info: http://jt400.sourceforge.net/

Install

npm install jt400

Custom config connection

Host: 127.0.0.1
Database: myDatabase
User: myUser
Password: myPassword

app.js

var Database = require('jt400');
var database = new Database();

var config = {
  libpath: __dirname + '/jt400.jar',
  drivername: 'com.ibm.as400.access.AS400JDBCDriver',
  url: 'jdbc:as400://127.0.0.1/myDatabase;user=myUser;password=myPassword'
};

database.initialize(config);

// SELECT statements must be run with execute()
database.execute('SELECT * FROM foo');

database.on('execute', function(error, results) {
  if (error) {
    console.log(error);
  }
  else {
    console.log(results);
  }
});

//INSERT and UPDATE statements must be run with executeUpdate()
database.executeUpdate('INSERT INTO foo (bar) VALUES ("bar")');

database.on('executeUpdate', function(error, rowCount) {
  if (error) {
    console.log(error);
  }
  else {
    console.log(rowCount);
  }
});

//CALL stored procedure must use executeStoredProc()
var outputParameters = [{
  Index: 1,
  DataType: 1
}];

database.executeStoredProc("CALL FOO('BAR',?)", outputParameters);

database.on('executeStoredProc', function(error, results) {
  if (error) {
    console.log(error);
  }
  else {
    console.log(results);
  }
});

Run

node app.js

Based on https://npmjs.org/package/jdbc