timeout config and store procedures?

[erwinlobos]

How i can setup timeouts? it is possible to call store procedures?

[bergur]

Hi @erwinlobos

The node-jt400 does not support stored procedures, although it can be implemented. You can read more about it in this issue #9

I will take a look at timeouts and let you know.

[erwinlobos]

hi @bergur did you check the timeouts config?

[bergur]

@erwinlobos no sorry, busy day yesterday. Will try to find some time today.

[bergur]

Hi @erwinlobos

All I could find is the "query timeout mechanism" property. See: https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzahh/javadoc/com/ibm/as400/access/doc-files/JDBCProperties.html

You can set this property in the configure object when you connect since node-jt400 accepts all JDBC properties

But...I have never used it and don't really know how to use the QQRYTIMLMT feature of the database engine.

I guess its a push in the right direction but I am sorry I have no defenitive answer for you. If you take it any further please let us know :)

[erwinlobos]

thanks @bergur i see that in jt400 there is a setTimeOut method https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzahh/javadoc/com/ibm/as400/access/AS400JDBCConnection.html?view=kc#setNetworkTimeout(int)

is there any way to use this method with node-jt400?

[bergur]

Nice find. I'm sorry to say though that this function is not implemented in current version. We would have to expose that function to the node code. It's well doable....but.

This module was written by Tryggingamidstodin (an icelandic insurance company), to help us deal with legacy stuff. But we are working on all kind of things. Right now other stuff is getting higher priority than maintenance of this module, so I don't see this change beeing implemented by us in the near future, but feel free to fork and/or make a pull requests and we will try to take a look at it.