tag:blogger.com,1999:blog-36973717.post69765481374145650..comments2023-09-01T12:34:45.870+02:00Comments on Gioppo Luca's Blog: TEIID and nodejs with node-postgresAnonymoushttp://www.blogger.com/profile/07783421934032055676noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-36973717.post-992755633248755152017-08-03T10:01:28.975+02:002017-08-03T10:01:28.975+02:00Hi Brian,
I've not experienced that problem.
H...Hi Brian,<br />I've not experienced that problem.<br />Have you checked the logs on the TEIID side?<br />There you should find hints of the problem.<br />Also ... did the connection abruptly terminated or did you get some error code back?<br />I've not used parametric queries, which versions are you using?<br />LucaAnonymoushttps://www.blogger.com/profile/07783421934032055676noreply@blogger.comtag:blogger.com,1999:blog-36973717.post-30477262768938275562017-07-31T18:15:31.310+02:002017-07-31T18:15:31.310+02:00Hi Luca!
Thank you so much for your post!
I was ...Hi Luca!<br /><br />Thank you so much for your post!<br /><br />I was able to connect to the database and send a query such as client.query("SELECT * FROM Reports WHERE ReportId = 10", function(err, result) {}). Everything works well!<br /><br />However, when I attempt to send a parameterized query such as client.query("SELECT * FROM Reports WHERE ReportId = $1", [10], function(err, result) {}), then the connection is terminated unexpectedly. I can confirm that it is able to find the correct rows, but the connection ends.<br /><br />Have you ever experienced this? Have you used parameterized queries with node pg and TEIID?<br /><br />Thank you so much, Luca!Anonymoushttps://www.blogger.com/profile/08543468909141311437noreply@blogger.comtag:blogger.com,1999:blog-36973717.post-20400025390295115112017-07-31T18:14:14.130+02:002017-07-31T18:14:14.130+02:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/08543468909141311437noreply@blogger.com