Hello,
I am a new in MonetDB.
I'm testing MonetDB + unixODBC with an application which inserts long BLOB values, and I'm having some problems.
Can you please help me?
1. When I use
rc= SQLBindParameter(hstmt, position, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_LONGVARBINARY, 0, 0, (char*) data, data_size, &BindBuf[position].size);
I get error "Optional feature is not implemented".
If I change SQL_LONGVARBINARY to SQL_VARCHAR, it works, however it wants the data in HEX notation, instead of raw binary buffer. That means I need 2*data_size extra memory to encode my binary data in hex, and then send the result send to SQLBindParameter.
Is there a way to bind raw binary data, to avoid hex encoding?
2. When I insert blob data using rc= SQLExecDirect(hstms, "INSERT INTO t1 (blob_column)" "VALUES " "('<long hex-string>')", SQL_NTS);
It works fine for short data, but it returns this error when hex-string is long enough:
[SQLSTATE:S1000][unixODBC][MonetDB][ODBC Driver 1.0]current transaction is aborted (please ROLLBACK)
I guess I hit some maximum possible query length limit, or maybe maximum possible transaction size.
Is there a way to configure MonetDB to allow longer values?
3. Does the native MonetDB API have the same limitations with the bind types and maximum query(or transaction) size?
Thank you very much!