Node.js SQL Adapter (firebird blob issue)

Stimulsoft Reports.JS discussion
Post Reply
Barnaby
Posts: 27
Joined: Tue Dec 20, 2016 1:57 am

Node.js SQL Adapter (firebird blob issue)

Post by Barnaby »

Hey,

When selecting a blob through the firebird SQL Adapter, a function (a data stream) gets passed back rather than a string, causing you to see the function in the report.
Blob.png
Blob.png (10.44 KiB) Viewed 1371 times
I've altered the adapter and got it working for the designer/viewer, but now I'm trying to generate a PDF via node.js.
stimulsoft-reports-js appears to use built in SQL Adapters, is it possible to alter them, or make it use external ones (as per the designer/viewer)?

I've tried to set Stimulsoft.StiOptions.WebServer.url, but requests timeout after 30 seconds at the start of report.renderAsync, it then does the SQL statements through the correct url, but when the report finishes no pages have been created.

Edit: I've found that I can use the following

Code: Select all

Stimulsoft.System.NodeJs.processFirebird = FirebirdAdapter.process;

Thanks,
Barnaby.
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Node.js SQL Adapter (firebird blob issue)

Post by HighAley »

Hello, Barnaby.

Did you solve the issue?
If not, write here and we will try to help you.

​Thank you.
Barnaby
Posts: 27
Joined: Tue Dec 20, 2016 1:57 am

Re: Node.js SQL Adapter (firebird blob issue)

Post by Barnaby »

Yeah I solved the using by using an altered SQL Adapter.

There is still an issue with the blob fields in firebird using the default SQL Adapters, which you guys might want to fix in a future version.
But nothing is needed urgently for me.

Thanks.
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: Node.js SQL Adapter (firebird blob issue)

Post by Lech Kulikowski »

Hello

Ok.
Please let us know if you need any additional help.

Thank you.
Post Reply