Redshift data access from node jdbc

[Naga Sai A]

Hi ,

I am getting below error when i try to data from redshift with the below mentioned code

Code:

var jdbc = new ( require('jdbc') );

var config = {

libpath: 'C:/Users/ABCD/Desktop/jar/RedshiftJDBC41-1.1.6.1006.jar',

//libs: [__dirname + 'path/to/other/jars.jar'],

drivername: 'com.amazon.redshift.jdbc41.Driver',

url: 'jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev',

user: 'xxxx',

password: 'xxxxx'

};

jdbc.initialize(config, function(err, res) {

if (err) {

console.log(err);

}

});

var genericQueryHandler = function(err, results) {

if (err) {

console.log(err);

} else if (results) {

console.log(results);

}

jdbc.close(function(err) {

if(err) {

  console.log(err);

} else {

  console.log("Connection closed successfully!");

}

});

};

jdbc.open(function(err, conn) {

if (conn) {

                // SELECT statements are called with executeQuery 

                jdbc.executeQuery("select * from information_schema.tables", genericQueryHandler);

}

});

____________________________________________________________________

                Error message 

___________________________________________________________________

Error:

C:\Users\ABCD> node redshift.js
C:\Users\ABCD\node_modules\jdbc\lib\jdbc.js:62

if(this._props.getPropertySync('user') === undefined){

               ^

TypeError: undefined is not a function

at JDBCConn.initialize (C:\Users\ABCD\node_modules\jdbc\lib\jdbc.js:62:20)




at Object.<anonymous> (C:\Users\ABCD\Desktop\AngularJS\redshift.js:15:6)

at Module._compile (module.js:460:26)

at Object.Module._extensions..js (module.js:478:10)

at Module.load (module.js:355:32)

at Function.Module._load (module.js:310:12)

at Function.Module.runMain (module.js:501:10)

at startup (node.js:129:16)

at node.js:814:3

Could you please let me know whether there is nay issue with the above mentioned node jdbc usage for redshift?

Thanks

[Naga Sai A]

Error: