{"action":"created","issue":{"url":"https://api.github.com/repos/nukedzn/node-informix/issues/33","repository_url":"https://api.github.com/repos/nukedzn/node-informix","labels_url":"https://api.github.com/repos/nukedzn/node-informix/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/nukedzn/node-informix/issues/33/comments","events_url":"https://api.github.com/repos/nukedzn/node-informix/issues/33/events","html_url":"https://github.com/nukedzn/node-informix/issues/33","id":186075681,"number":33,"title":"Error: [-200] Identifier is too long.","user":{"login":"rshep44","id":23136937,"avatar_url":"https://avatars.githubusercontent.com/u/23136937?v=3","gravatar_id":"","url":"https://api.github.com/users/rshep44","html_url":"https://github.com/rshep44","followers_url":"https://api.github.com/users/rshep44/followers","following_url":"https://api.github.com/users/rshep44/following{/other_user}","gists_url":"https://api.github.com/users/rshep44/gists{/gist_id}","starred_url":"https://api.github.com/users/rshep44/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rshep44/subscriptions","organizations_url":"https://api.github.com/users/rshep44/orgs","repos_url":"https://api.github.com/users/rshep44/repos","events_url":"https://api.github.com/users/rshep44/events{/privacy}","received_events_url":"https://api.github.com/users/rshep44/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"uditha-atukorala","id":2161935,"avatar_url":"https://avatars.githubusercontent.com/u/2161935?v=3","gravatar_id":"","url":"https://api.github.com/users/uditha-atukorala","html_url":"https://github.com/uditha-atukorala","followers_url":"https://api.github.com/users/uditha-atukorala/followers","following_url":"https://api.github.com/users/uditha-atukorala/following{/other_user}","gists_url":"https://api.github.com/users/uditha-atukorala/gists{/gist_id}","starred_url":"https://api.github.com/users/uditha-atukorala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uditha-atukorala/subscriptions","organizations_url":"https://api.github.com/users/uditha-atukorala/orgs","repos_url":"https://api.github.com/users/uditha-atukorala/repos","events_url":"https://api.github.com/users/uditha-atukorala/events{/privacy}","received_events_url":"https://api.github.com/users/uditha-atukorala/received_events","type":"User","site_admin":false},"assignees":[{"login":"uditha-atukorala","id":2161935,"avatar_url":"https://avatars.githubusercontent.com/u/2161935?v=3","gravatar_id":"","url":"https://api.github.com/users/uditha-atukorala","html_url":"https://github.com/uditha-atukorala","followers_url":"https://api.github.com/users/uditha-atukorala/followers","following_url":"https://api.github.com/users/uditha-atukorala/following{/other_user}","gists_url":"https://api.github.com/users/uditha-atukorala/gists{/gist_id}","starred_url":"https://api.github.com/users/uditha-atukorala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uditha-atukorala/subscriptions","organizations_url":"https://api.github.com/users/uditha-atukorala/orgs","repos_url":"https://api.github.com/users/uditha-atukorala/repos","events_url":"https://api.github.com/users/uditha-atukorala/events{/privacy}","received_events_url":"https://api.github.com/users/uditha-atukorala/received_events","type":"User","site_admin":false}],"milestone":null,"comments":19,"created_at":"2016-10-29T12:20:35Z","updated_at":"2016-11-01T13:58:28Z","closed_at":null,"body":"always get\nError: [-200] Identifier is too long.\n\nI'm new to this, and first time using node, so I may have missed something in the setup....\n\n server rhel 7.2\ninformixserver \nINFORMIX-SQL Version 7.25.UC6R1     Thu Mar 4 19:58:41 CST 2004\n\n[root@mon37 tx]# esql -V\nIBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC2W1\nSoftware Serial Number RDS#N000000\n\n[root@mon37 tx]# node --version\nv4.6.1\n\nset infromix env\n[root@mon37 ~]# . /u/catcom/catcom_vars\nexport DBDATE='DMY4'\nexport IFX_LIBS='/usr/informix_sqldev_4gldev_75_x64/lib'\nexport INFORMIXDIR='/usr/informix_sqldev_4gldev_75_x64'\nexport IFMX_ESQLC='/usr/informix_sqldev_4gldev_75_x64/bin/esql'\n\nnode-informix install log.....\n[root@mon37 ~]# npm install --save informix\n/\n\n> informix@0.5.2 install /root/node_modules/informix\n> node-gyp rebuild\n\nmake: Entering directory `/root/node_modules/informix/build'\n  ACTION binding_gyp_esqlc_target_esql_preprocess Release/obj/gen/src/esqlc.cpp\nesqlc: \"esqlc.ecpp\", line 19: Warning -33011: Current declaration of 'esql_user' hides previous declaration.\nesqlc: \"esqlc.ecpp\", line 20: Warning -33011: Current declaration of 'esql_pass' hides previous declaration.\n2 warning(s)\n  TOUCH Release/obj.target/esqlc.stamp\n  CXX(target) Release/obj.target/ifx/src/module.o\n  CXX(target) Release/obj.target/ifx/src/ifx/ifx.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/connect.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/disconnect.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/stmtprepare.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/stmtexec.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/stmtfree.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/fetch.o\n  CXX(target) Release/obj.target/ifx/src/ifx/workers/cursorclose.o\n  CXX(target) Release/obj.target/ifx/gen/src/esqlc.o\n  SOLINK_MODULE(target) Release/obj.target/ifx.node\n  COPY Release/ifx.node\nmake: Leaving directory`/root/node_modules/informix/build'\ninformix@0.5.2 node_modules/informix\nâââ bindings@1.2.1\nâââ uuid@2.0.3\nâââ debug@2.2.0 (ms@0.7.1)\nâââ nan@2.4.0\n\n--- test script ---------------------\n\n[root@mon37 tx]# cat nodetest1.js\n\nvar Informix = require( 'informix' ).Informix;\nvar informix = new Informix( { database : 'catcom' } );\n\ninformix\n  .query( \"select siteid from site\" )\n  .then( function ( cursor ) {\n    return cursor.fetchAll( { close : true } );\n  } )\n  .then( function ( cursor ) {\n    return cursor.fetchAll( { close : true } );\n  } )\n  .then( function ( results ) {\n    console.log( 'results:', results );\n  } )\n  .catch( function ( err ) {\n    console.log( err );\n  } );\n---\n\nsetp debug thru test script...\n\n-bash-4.2$ node debug nodetest1.js\n< Debugger listening on port 5858\nconnecting to 127.0.0.1:5858 ... ok\nbreak in nodetest1.js:2\n  1\n\n> 2 var Informix = require( 'informix' ).Informix;\n>   3 var informix = new Informix( { database : 'catcom' } );\n>   4\n> 3\n> debug> 3\n\ndebug> setp\nrepl:1\nsetp\n^\nReferenceError: setp is not defined\n    at repl:1:1\n    at Object.exports.runInContext (vm.js:44:17)\n    at Interface.protocol.onResponse.Interface.controlEval (_debugger.js:953:21)\n    at REPLServer.Interface.opts.eval (_debugger.js:737:41)\n    at bound (domain.js:287:14)\n    at REPLServer.runBound [as eval](domain.js:300:12)\n    at REPLServer.<anonymous> (repl.js:431:12)\n    at emitOne (events.js:77:13)\n    at REPLServer.emit (events.js:169:7)\n    at REPLServer.Interface._onLine (readline.js:212:10)\ndebug> help\nCommands: run (r), cont (c), next (n), step (s), out (o), backtrace (bt), setBreakpoint (sb), clearBreakpoint (cb),\nwatch, unwatch, watchers, repl, exec, restart, kill, list, scripts, breakOnException, breakpoints, version\nstep\nbreak in internal/module.js:12\n 10\n 11   function require(path) {\n\n> 12     return self.require(path);\n>  13   }\n>  14\n> step\n> break in module.js:351\n>  349 // `exports` property.\n>  350 Module.prototype.require = function(path) {\n> 351   assert(path, 'missing path');\n>  352   assert(typeof path === 'string', 'path must be a string');\n>  353   return Module._load(path, this);\n> debug> step\n> break in assert.js:109\n>  107\n>  108 function ok(value, message) {\n> 109   if (!value) fail(value, true, message, '==', assert.ok);\n>  110 }\n>  111 assert.ok = ok;\n> run\n> App is already running... Try `restart` instead\n> debug> step\n> break in assert.js:110\n>  108 function ok(value, message) {\n>  109   if (!value) fail(value, true, message, '==', assert.ok);\n> 110 }\n>  111 assert.ok = ok;\n>  112\n> debug> step\n> break in module.js:352\n>  350 Module.prototype.require = function(path) {\n>  351   assert(path, 'missing path');\n> 352   assert(typeof path === 'string', 'path must be a string');\n>  353   return Module._load(path, this);\n>  354 };\n> debug> help\n> Commands: run (r), cont (c), next (n), step (s), out (o), backtrace (bt), setBreakpoint (sb), clearBreakpoint (cb),\n> watch, unwatch, watchers, repl, exec, restart, kill, list, scripts, breakOnException, breakpoints, version\n> debug> next\n> break in module.js:353\n>  351   assert(path, 'missing path');\n>  352   assert(typeof path === 'string', 'path must be a string');\n> 353   return Module._load(path, this);\n>  354 };\n>  355\n> debug> next\n> break in module.js:354\n>  352   assert(typeof path === 'string', 'path must be a string');\n>  353   return Module._load(path, this);\n> 354 };\n>  355\n>  356\n> debug> next\n> break in internal/module.js:13\n>  11   function require(path) {\n>  12     return self.require(path);\n> 13   }\n>  14\n>  15   require.resolve = function(request) {\n> debug> next\n> break in nodetest1.js:3\n>   1\n>   2 var Informix = require( 'informix' ).Informix;\n> 3 var informix = new Informix( { database : 'catcom' } );\n>   4\n>   5 informix\n> debug> next\n> break in nodetest1.js:5\n>   3 var informix = new Informix( { database : 'catcom' } );\n>   4\n> 5 informix\n>   6   .query( \"select siteid from site\" )\n>   7   .then( function ( cursor ) {\n> debug> next\n> break in nodetest1.js:7\n>   5 informix\n>   6   .query( \"select siteid from site\" )\n> 7   .then( function ( cursor ) {\n>   8     return cursor.fetchAll( { close : true } );\n>   9   } )\n> debug> next\n> break in nodetest1.js:40\n>  38\n>  39\n> 40 });\n> debug> next\n> break in module.js:410\n>  408   const args = [this.exports, require, this, filename, dirname];\n>  409   return compiledWrapper.apply(this.exports, args);\n> 410 };\n>  411\n>  412\n> debug> next\n> break in module.js:417\n>  415   var content = fs.readFileSync(filename, 'utf8');\n>  416   module._compile(internalModule.stripBOM(content), filename);\n> 417 };\n>  418\n>  419\n> debug> next\n> break in module.js:344\n>  342   if (!Module._extensions[extension]) extension = '.js';\n>  343   Module._extensions[extension](this, filename);\n> 344   this.loaded = true;\n>  345 };\n>  346\n> debug> next\n> break in module.js:345\n>  343   Module._extensions[extension](this, filename);\n>  344   this.loaded = true;\n> 345 };\n>  346\n>  347\n> debug> next\n> break in module.js:301\n>  299   try {\n>  300     module.load(filename);\n> 301     hadException = false;\n>  302   } finally {\n>  303     if (hadException) {\n> debug> next\n> break in module.js:303\n>  301     hadException = false;\n>  302   } finally {\n> 303     if (hadException) {\n>  304       delete Module._cache[filename];\n>  305     }\n> debug> next\n> break in module.js:308\n>  306   }\n>  307\n> 308   return module.exports;\n>  309 };\n>  310\n> debug> next\n> break in module.js:309\n>  307\n>  308   return module.exports;\n> 309 };\n>  310\n>  311 Module._resolveFilename = function(request, parent) {\n> debug> next\n> break in module.js:443\n>  441   Module._load(process.argv[1], null, true);\n>  442   // Handle any nextTicks added in the first tick of the program\n> 443   process._tickCallback();\n>  444 };\n>  445\n> debug> next\n> break in module.js:444\n>  442   // Handle any nextTicks added in the first tick of the program\n>  443   process._tickCallback();\n> 444 };\n>  445\n>  446 Module._initPaths = function() {\n> debug> next\n> break in timers.js:93\n>  91         first._called = true;\n>  92         first._onTimeout();\n> 93         if (domain)\n>  94           domain.exit();\n>  95         threw = false;\n> debug> next\n> break in timers.js:95\n>  93         if (domain)\n>  94           domain.exit();\n> 95         threw = false;\n>  96       } finally {\n>  97         if (threw) {\n> debug> next\n> break in timers.js:97\n>  95         threw = false;\n>  96       } finally {\n> 97         if (threw) {\n>  98           // We need to continue processing after domain error handling\n>  99           // is complete, but not by using whatever domain was left over\n> debug> next\n> break in timers.js:66\n>  64\n>  65   var diff, first, threw;\n> 66   while (first = L.peek(list)) {\n>  67     diff = now - first._idleStart;\n>  68     if (diff < msecs) {\n> debug> next\n> break in timers.js:110\n>  108   }\n>  109\n> 110   debug('%d list empty', msecs);\n>  111   assert(L.isEmpty(list));\n>  112   list.close();\n> debug>\n> debug> next\n> break in timers.js:111\n>  109\n>  110   debug('%d list empty', msecs);\n> 111   assert(L.isEmpty(list));\n>  112   list.close();\n>  113   delete lists[msecs];\n> debug> next\n> break in timers.js:112\n>  110   debug('%d list empty', msecs);\n>  111   assert(L.isEmpty(list));\n> 112   list.close();\n>  113   delete lists[msecs];\n>  114 }\n> debug> next\n> break in timers.js:113\n>  111   assert(L.isEmpty(list));\n>  112   list.close();\n> 113   delete lists[msecs];\n>  114 }\n>  115\n> debug> next\n> break in timers.js:114\n>  112   list.close();\n>  113   delete lists[msecs];\n> 114 }\n>  115\n>  116\n> debug> next\n> < [Error: [-200] Identifier is too long.]\n> debug> next\n"},"comment":{"url":"https://api.github.com/repos/nukedzn/node-informix/issues/comments/257572912","html_url":"https://github.com/nukedzn/node-informix/issues/33#issuecomment-257572912","issue_url":"https://api.github.com/repos/nukedzn/node-informix/issues/33","id":257572912,"user":{"login":"uditha-atukorala","id":2161935,"avatar_url":"https://avatars.githubusercontent.com/u/2161935?v=3","gravatar_id":"","url":"https://api.github.com/users/uditha-atukorala","html_url":"https://github.com/uditha-atukorala","followers_url":"https://api.github.com/users/uditha-atukorala/followers","following_url":"https://api.github.com/users/uditha-atukorala/following{/other_user}","gists_url":"https://api.github.com/users/uditha-atukorala/gists{/gist_id}","starred_url":"https://api.github.com/users/uditha-atukorala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uditha-atukorala/subscriptions","organizations_url":"https://api.github.com/users/uditha-atukorala/orgs","repos_url":"https://api.github.com/users/uditha-atukorala/repos","events_url":"https://api.github.com/users/uditha-atukorala/events{/privacy}","received_events_url":"https://api.github.com/users/uditha-atukorala/received_events","type":"User","site_admin":false},"created_at":"2016-11-01T13:58:28Z","updated_at":"2016-11-01T13:58:28Z","body":"It cannot be changed at the moment (unless you change the source directly). I'll push an update later today so you can use named cursors (similar to named statements). "}}
{"actor":{"display_login":"uditha-atukorala"}}