Comments (9)
Are you using db2?
from node-odbc.
Yes, on this old 32bit box, db2 9.7fp4.
from node-odbc.
It's an old box but it's completely up to date with Ubuntu Server 12.04.2.
from node-odbc.
from node-odbc.
I'm pretty sure the issue has to do with the Unicode support that I enabled by default in this release. Probably shouldn't have done that. If you want to try disabling it, you can remove the UNICODE
flag from binding.gyp
. (https://github.com/wankdanker/node-odbc/blob/master/binding.gyp#L13).
My best guess is that in certain circumstances where ODBC writes to a buffer like in SQLDriverConnect if it is writing out a UCS2 encoding string into a buffer that is smaller than required it overflows the buffer causing errors such as you see.
I found a way to reproduce it on my end, so I should be able to nail it down.
from node-odbc.
Just pushed v0.5.19. If you get a chance to try it out, let me know if it fixes this issue or if you find any other regressions.
Thanks,
Dan
from node-odbc.
yep, all good...
u da man
from node-odbc.
Awesome. Glad to hear it. Curious to hear if your numbers increase or decrease at this version. We are avoiding some string copying now. But, also we have the added overhead of Unicode processing (as the default is set). If your numbers seem to decrease at all, try removing UNICODE
from binding.gyp
and recompiling.
Thanks for the feedback!
from node-odbc.
I put 5.19 into "production" today on x64 db2 10.5. Millions of calls... no issues that I can see.
But if you want me to compare one of your benchmarks at 5.14 to 5.19, let me know which one. You have a lot. :-)
from node-odbc.
Related Issues (20)
- Error '[node-odbc] Error in ODBCResult::MoreResultsSync', HOT 1
- support for SQL_SUCCESS_WITH_INFO return HOT 1
- endless loop HOT 1
- node-odbc incompatible with Electron? HOT 3
- Error while installing package [Failed at the [email protected] install script 'node-gyp configure build'.]
- npm install error OSX HOT 2
- code fails with latest version of node-odbc as well as ibm_db
- node-odbc SSL encryption support? HOT 1
- Unsupported platform for [email protected] HOT 1
- Support more ODBC Features
- Statically linked Library
- npm WARN lifecycle [email protected]~preinstall: cannot run in wd %s %s (wd=%s) [email protected] node-gyp configure build /usr/src/pal/node_modules/odbc HOT 3
- Row count when doing UPDATE, INSERT, or DELETE via querySync()
- iso-8859-15 dont show character
- Build error when the UNICODE define is removed from binding.gyp HOT 2
- Windows odbc.open crashes on 2nd invocation with Microsoft Access Driver
- Only returning first character on macOS. HOT 2
- How to prevent conversion of datetime string to JS Date object? HOT 2
- How does odbc handle sql injection HOT 2
- odbc.Database is not a constructor HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-odbc.