Stack Overflow
Stack Overflow

Questions tagged [node-firebird]

node-firebird is one of several Node.js libraries for the Firebird database. Use this tag when your question concerns using node-firebird to query a Firebird database.

node-firebird is a pure JavaScript and asynchronous Firebird client for Node.js

For more information, see https://github.com/hgourvest/node-firebird

See also:

28 questions
6
votes
2 answers

Node-firebird sequentially select

I am trying to get the data from Firebird DB with sequentially select option. I would like to get the first 500 rows, as you see on my code. And for testing, I am increasing 'k' for each 'row' and logging 'k' and 'md5' to the console. When I am…
Tural Gulmammadov
  • 95
  • 1
  • 9
4
votes
1 answer

Node-Firebird Invalid transaction handle

I got an error when trying to commit in sequence with the same transaction. I am using Node-firebird lib. The first time is committed, but the second time I got the following message: Error: > invalid transaction handle (expecting explicit…
William Ferreira da Silva
  • 41
  • 3
3
votes
3 answers

Why does node-firebird output a byte buffer instead of a string value?

I'm new to node.js and javascript studies and I'm trying to build a backend to fetch information from a Firebird database. I am using some dependencies that are in a course that I am following. My project as 'express', 'nodemon',…
Alexandre Felix
  • 31
  • 3
3
votes
1 answer

Firebird blob to Base64 - Node.js

I'm migrating one website with java/jsf for Node/Angular but i have the problem for convert blob from firebird database to base64 using node-firebird. connection.query(query,function(err,rows){ if(err) { res.json({"Error" : true, "Message" :…
Douglas
  • 71
  • 5
2
votes
1 answer

How to extract data in [Function (anonymous)]

I'm trying data extraction in Node.js with Firebird. First code: var sql1 = 'select id,id_asset_element,duration,start_datetime,show_name from MAIN_EVENT where start_datetime > DATEDIFF(millisecond, TIMESTAMP\'0001-01-01 00:00\', CURRENT_TIMESTAMP)…
Mert
  • 39
  • 4
2
votes
1 answer

How to execute multiples procedures from nodejs and node-firebird?

I'm using Firebird 2.5 and node-firebird 0.8.6. I have to run SQL files with multiple stored procedures but I always got errors like the ones below Error: Dynamic SQL Error, SQL error code = -104, Token unknown - line 1, column 5, term at…
Felipe Paz
  • 347
  • 1
  • 6
  • 19
2
votes
0 answers

Error when connecting to Firebird database with NodeJS

I'm trying to connect to a Firebird database with NodeJS, and I'm using the node-firebird package link here, and am having the following error when trying to connect. Error node index.js Error: Connection is closed. at…
Jefter Rocha
  • 387
  • 2
  • 14
2
votes
2 answers

firebird - getaddrinfo ENOTFOUND

I am new to firebird database. I have created a database "a" and a table "STUDENT". I am trying to connect to the database using this npm package https://www.npmjs.com/package/node-firebird Following is my code to connect to db and get data. var…
MARKAND Bhatt
  • 2,428
  • 10
  • 47
  • 80
2
votes
1 answer

Connection Error to Firebird DB

I have attached my code and error message on the below. Can you please help me, I could not find the reason to get the error. Thanks, // My Code // Node-Firebird var Firebird = require('node-firebird'); // Options var options = {}; //options.host =…
Tural Gulmammadov
  • 95
  • 1
  • 9
1
vote
1 answer

How to create an image file from Firebird blob data?

I have a Firebird DB table, which contains fields with image data (as blob sybtype -5). I need to get this data and convert it to an image file. Code example below creates a file (but size is very large, and while trying to open it - it is said,…
Yurii
  • 171
  • 2
  • 17
1
vote
0 answers

Node-firebird doesn't give results if more than 3 fields in the query

I'm testing "node-firebird" with Firebird 2.5 and it runs if I query for 1, 2 or 3 fields, but if I ask for a fourth field, it doesn't give any response. It is not a problem with any exact field because it queries well if I ask for it with less…
wakeup
  • 67
  • 7
1
vote
1 answer

Unknown table error accessing Firebird database with NodeJS

I need to write a script to migrate data from Firebird 2.5 to mySQL. I'm trying: const Firebird = require('node-firebird') const options = { host: '127.0.0.1', port: 3050, database: 'database.gdb', user: 'SYSDBA', password: 'masterkey', …
isacvale
  • 627
  • 8
  • 13
1
vote
0 answers

Result of query has a [Function] as value

I'm running a SQL statement and it has a sub select. But after running, the result field has a [Function] value. Do I doing something wrong? My SQL is something like it: SELECT product.CODE , (SELECT LIST(item.size, '/') FROM ITEMS item…
Marcel Zanluca
  • 11
  • 1
1
vote
1 answer

Node-firebird sequentially select doesn't work

I'm using simple code to test sequentially in Firebird lib "node-firebird". It always gives me back 1 row, but should be a lot of them. exports.sequentially = (select, db_con_options) => { Firebird.attach(db_con_options, (err, db) => { if…
Sebastian Zalewski
  • 89
  • 8
1
vote
1 answer

Select Blob return a function

exports.carregaContrato = function(id, cb){ Firebird.attach(firebirdConfig, function (err, db) { if (err) throw err; db.query("select contrato_escaniado as IMAGE from cad_prospectos_contratos where codigo = ?", [id], function(err,…
Erick Zanetti
  • 459
  • 1
  • 4
  • 11
1
2