Skip to content

Instantly share code, notes, and snippets.

View amcintyre99's full-sized avatar

amcintyre99

View GitHub Profile
@amcintyre99
amcintyre99 / gist:8cd26d53274a1d27159c
Created April 25, 2015 04:13
$ npm rebuild odbc
> odbc@1.1.0 install /home/andrew/dma/prd/node_modules/odbc
> node-gyp rebuild
make: Entering directory `/home/andrew/dma/prd/node_modules/odbc/build'
CXX(target) Release/obj.target/odbc_bindings/src/odbc.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_connection.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_statement.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_result.o
@amcintyre99
amcintyre99 / gist:7837f232e1e9b2e18773
Created April 25, 2015 13:13
$ npm install bzuillsmith/node-odbc#dynofix
\
> odbc@1.1.0 install /home/andrew/dma/prd/node_modules/odbc
> node-gyp rebuild
make: Entering directory `/home/andrew/dma/prd/node_modules/odbc/build'
CXX(target) Release/obj.target/odbc_bindings/src/odbc.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_connection.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_statement.o
CXX(target) Release/obj.target/odbc_bindings/src/odbc_result.o
@amcintyre99
amcintyre99 / gist:c890737380dbc80b4bda
Created April 25, 2015 13:17
$ npm rebuild odbc
> odbc@1.1.0 install /home/andrew/dma/prd/node_modules/odbc
> node-gyp rebuild
make: Entering directory `/home/andrew/dma/prd/node_modules/odbc/build'
CXX(target) Release/obj.target/odbc_bindings/src/odbc.o
In file included from ../src/odbc.h:28:0,
from ../src/odbc.cpp:25:
../src/dynodbc.h:352:0: warning: "SQLSetConnectOption" redefined [enabled by default]
@amcintyre99
amcintyre99 / gist:56c941a47291d5fef293
Last active August 29, 2015 14:20
ubuntu desktop 14.04.2 i7-4770
node 10.38 odbc 6.13 dynodbc 11672 13497
100000 queries issued in 7.46 seconds, 13404/sec : Prepare - ExecuteNonQuery
100000 queries issued in 8.476 seconds, 11798/sec : Prepare - ExecuteNonQuery
100000 queries issued in 7.409 seconds, 13497/sec : Prepare - ExecuteNonQuery
100000 queries issued in 8.12 seconds, 12315/sec : Prepare - ExecuteNonQuery
100000 queries issued in 8.258 seconds, 12109/sec : Prepare - ExecuteNonQuery
100000 queries issued in 8.465 seconds, 11813/sec : Prepare - ExecuteNonQuery
100000 queries issued in 8.217 seconds, 12169/sec : Prepare - ExecuteNonQuery
@amcintyre99
amcintyre99 / gist:5478705
Created April 28, 2013 22:38
var db = new odbc.Database()
var recursive = function (stmt) {
request/response
stmt.bindSync
stmt.execute {
........
@amcintyre99
amcintyre99 / gist:5485701
Created April 29, 2013 23:48
ODBC::New
ODBC::CreateConnection
ODBC::UV_CreateConnection
ODBC::UV_AfterCreateConnection
ODBCConnection::New
ODBCConnection::Open
ODBCConnection::UV_Open
ODBCConnection::UV_AfterOpen
ODBCConnection::CreateStatementSync
ODBCStatement::PrepareSync
@amcintyre99
amcintyre99 / gist:5486102
Created April 30, 2013 01:33
with the library from my odbcinst.ini file:
odbc.library = '/fast/db2inst1/sqllib/lib/libdb2.so'
i get this:
=======================
node-odbc: error loading ODBC library: /fast/db2inst1/sqllib/lib/libdb2.so.so: cannot open shared object file: No such file or directory
/home/andrew/dma/prd/node_modules/odbc/lib/odbc.js:48
throw new Error("Could not load library. You may need to specify full "
^
@amcintyre99
amcintyre99 / gist:5489307
Created April 30, 2013 15:03
works
db.query(sqlc,["<qt>"+str+"</qt>",resp_ts.toString()],function(err) {
fails sometimes - at least, I think this is what's failing - the SQL error comes from the execute
stmt.bind(["<qt>"+str+"</qt>",resp_ts.toString()],function() {
@amcintyre99
amcintyre99 / gist:5489891
Created April 30, 2013 16:31
17 { state: '22005',
error: '[node-odbc] Error in some module',
message: '[unixODBC][IBM][CLI Driver][DB2/LINUXX8664] SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018\n' }
17 1 240 <qt><trade><cvol>29922533</cvol><datetime>2013-04-30T12:27:19-04:00</datetime><exch>The Trade Reporting Facility LLC</exch><last>32.82</last><symbol>MSFT</symbol><timestamp>1367339239</timestamp><vl>100</vl><vwap>32.5603</vwap></trade></qt>
17 00000000: 3c71 743e 3c74 7261 6465 3e3c 6376 6f6c <qt><trade><cvol
00000010: 3e32 3939 3232 3533 333c 2f63 766f 6c3e >29922533</cvol>
00000020: 3c64 6174 6574 696d 653e 3230 3133 2d30 <datetime>2013-0
00000030: 342d 3330 5431 323a 3237 3a31 392d 3034 4-30T12:27:19-04
00000040: 3a30 303c 2f64 6174 6574 696d 653e 3c65 :00</datetime><e
00000050: 7863 683e 5468 6520 5472 6164 6520 5265 xch>The.Trade.Re
@amcintyre99
amcintyre99 / gist:5490123
Created April 30, 2013 17:02
ODBC::New
ODBC::CreateConnection
ODBC::UV_CreateConnection
ODBC::UV_AfterCreateConnection
ODBCConnection::New
ODBCConnection::Open
ODBCConnection::UV_Open
ODBCConnection::UV_AfterOpen
ODBCConnection::CreateStatementSync
ODBCStatement::PrepareSync