Guest User

Untitled

a guest
Dec 4th, 2018
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. node index.js
  2. Error: Connection is closed.
  3. at exports.Connection.Connection._queueEvent (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:3117:22)
  4. at exports.Connection.Connection.connect (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:3152:10)
  5. at C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:1587:13
  6. at Socket.<anonymous> (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:2828:17)
  7. at emitOne (events.js:116:13)
  8. at Socket.emit (events.js:211:7)
  9. at TCP._handle.close [as _onclose] (net.js:561:12)
  10. C:UsersJEFTERDocumentsfirebird-node-devindex.js:19
  11. db.query('SELECT * FROM TEST', function(err, result) {
  12. ^
  13.  
  14. TypeError: Cannot read property 'query' of undefined
  15. at C:UsersJEFTERDocumentsfirebird-node-devindex.js:19:8
  16. at doError (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:1244:9)
  17. at C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:1589:17
  18. at exports.Connection.Connection._queueEvent (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:3117:13)
  19. at exports.Connection.Connection.connect (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:3152:10)
  20. at C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:1587:13
  21. at Socket.<anonymous> (C:UsersJEFTERDocumentsfirebird-node-devnode_modulesnode-firebirdlibindex.js:2828:17)
  22. at emitOne (events.js:116:13)
  23. at Socket.emit (events.js:211:7)
  24. at TCP._handle.close [as _onclose] (net.js:561:12)
  25.  
  26. ┌─data
  27. │ └─TEST.FDB
  28. ├─node_modules
  29. ├─index.js
  30. ├─package.json
  31. └─package-lock.json
  32.  
  33. const firebird = require('node-firebird-dev')
  34. const options = {
  35. host: '127.0.0.1',
  36. port: 3050,
  37. database: 'C:/Users/JEFTER/Documents/firebird-node-dev/data/TEST.FDB',
  38. user: 'SYSDBA',
  39. password: 'masterkey',
  40. lowercase_keys: false, // set to true to lowercase keys
  41. role: null, // default
  42. pageSize: 4096 // default when creating database
  43. }
  44.  
  45. firebird.attach(options, (err, db) => {
  46.  
  47. if (err)
  48. console.log(err)
  49.  
  50. // db = DATABASE
  51. db.query('SELECT * FROM TEST', (err, result) => {
  52. // IMPORTANT: close the connection
  53. db.detach()
  54. })
  55. })
Add Comment
Please, Sign In to add comment