tarasko / edba Goto Github PK

From backends_smoke_test.cpp

// Oracle require explicit specification which type we going to bind: BLOB or CLOB, 
// istreams in oracle backend are always bound as BLOBs, that is why you can`t bind to anything except blob columns 
// in database. Actually the same problem we have with odbc drivers that don`t support SQLDescribeParam. 
// Fortunally MSSQL driver support it.

edba try to guess database type specifically in each backend and in most time it is done very well, but that`s not enought. Frontend should allow user to specify which database type has parameter during binding. Possible syntax:

st << use("name", value, dbt_blob);
st.bind("name", value, dbt_clob);

It would be great to have an ability to see the DB activity time spent on the multiple DB statements execution. It could be the DB connection scope.

Thanks.

Currently session monitor only has hooks that are called after the statement or query is executed. Sometimes it is handy to have hooks that are executed before. For example such hook will make it possible to see exactly what query hanged without waiting a timeout or attaching a debugger..

E1114 16:44:30.628938 7360 pnl_context.cpp:238] Scenarios for BAM(22182) failed to evaluate Dynamic exception type: class edba::edba_error
std::exception::what: edba::backend::odbc SQLExecute failed with error [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (0)

Driver: ODBC
Database: MSSQL 2008

Dynamic exception type: class boost::exception_detail::clone_impl<struct boost::
exception_detail::error_info_injector >
std::exception::what: edba::odbc_backend::Failed with error `[Microsoft][SQL Ser
ver Native Client 10.0][SQL Server]The data types varchar and text are incompati
ble in the equal to operator.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be
prepared.'
[struct sbt::datav2::error_infos::tag_country *] = RU
[struct sbt::datav2::error_infos::tag_stored_proc_name *] = ftapi_GetCountrySect
orIndex

SELECT INSTRUMENT_ID FROM [INDEX] WHERE NAME = :index_name

INSTRUMENT_ID – NUMERIC(18,0)
NAME – VARCHAR(150)

index_name – std::string

ODBC specific problem.
MSSQL 2008 native client destroy all access plans for cached prepared statements, during SQLEndTran call.

http://msdn.microsoft.com/en-us/library/ms711769(v=vs.85).aspx

To reproduce prepare and run query in transaction, commit transaction and run query again