Stack Overflow
Stack Overflow

Questions tagged [otl]

OTL is a C++ database access interface (ODBC,Oracle,DB2...)

OTL is an advanced database access library that applies C++ well founded concepts to a difficult, practical task, in an efficient way. It's designed as a combination of a C++ template framework and OTL-adapters. The framework is a generic implementation of the concept of OTL streams. The OTL-adapters are thin wrappers around the database APIs and are used as class type parameters to be passed into the template framework.

35 questions
16
votes
1 answer

Differences between OTL and SOCI

What are the advantages and disadvantages of the C++ database libraries OTL and SOCI? In particular, what differences are relevant for my project, whose database uses SQL Server 2008? I haven't used either before, and during my project I don't want…
ikhtiyor
  • 504
  • 5
  • 15
6
votes
2 answers

Preventing SQL injection in C++ OTL, DTL, or SOCI libraries

I've been looking at all three of these database libraries, and I'm wondering if they do anything to prevent SQL injection. I'm most likely going to be building a lib on top of one of them, and injection is a top concern I have in picking one. …
Brett Rossier
  • 3,420
  • 3
  • 27
  • 36
5
votes
0 answers

Trouble getting OTL connecting to MySQL

I am trying to use OTL to avoid the GPL on MyODBC (and because it is very nice). It compiles fine but I get a "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" error on the console. This code isn't…
Confident
  • 321
  • 4
  • 17
4
votes
2 answers

Is C++ OTL SQL database library using parameterized queries under the hood, or string concat?

I've been looking at the OTL (Oracle, Odbc and DB2-CLI Template Library) for C++ database access. I'm unsure of whether the query I pass in is converted to a parameterized query for the underlying database, or if it's basically just concatenating…
Brett Rossier
  • 3,420
  • 3
  • 27
  • 36
4
votes
6 answers

How to detect Oracle broken/stalled connection?

In our server/client-setup we're experiencing some weird behaviour. The client is a C/C++-application which uses OCI to connect to an Oracle server (using the OTL library). Every now and then the DB server dies in a way (yes this is the core issue,…
Kosi2801
  • 22,222
  • 13
  • 38
  • 45
3
votes
1 answer

How to SELECT whole table with OTL, and save it to file?

Here is the problem, I dont know how many attributes or which type are the attributes in table and I need simple select statment like: SELECT * FROM TABLE1; to write down to file. And this need to be done with otlv4 wrapper. Please help. otl_stream…
Gile
  • 31
  • 3
3
votes
2 answers

Delphi - OTL - Communicating between ThreadPool and Worker thread

I'm using XE8 and I'm trying to built an example of my real world application. I need to communicate between the main "service thread" and the OTL thread pool. The examples are all set with forms and Monitors. I don't need those, but I can't figure…
Clément
  • 91
  • 6
2
votes
2 answers

Unable to compile C++ code using OTLv4 library

Could you help me figure out what's missing here? I'm trying to compile a c++ program using the OTL 4 library but I'm getting an error. Environment Details: I've installed Oracle DB XE 10G on an Ubuntu 11.04 VM. SQL*Plus and the server itself…
cr8ivecodesmith
  • 2,021
  • 5
  • 21
  • 30
2
votes
2 answers

How to determine cause of main thread not responding with Omni Thread Library?

Platform: Delphi with VirtualTreeView SVN 5.1.0 & OmniThreadLibrary 3 SVN & Delphi XE2 Originally I thought that the problem was VirtualTreeView. I need to add node to VST every 1s or less.But It seems soon or later the CPU rate will hit 50% or more…
XARA
  • 23
  • 3
2
votes
1 answer

Trying to use OTL to connect to my PostgreSQL server

I am trying to connect my c++ client to an PostgreSQL DB. I keep getting otlv4.h|12406|undefined reference to `SQLFreeHandle@8' and many other undefined reference errors. To get the header file go to…
Roland Sams
  • 173
  • 1
  • 2
  • 12
1
vote
0 answers

Is there any methods to use "try,catch,throw in C++" in the Chromium Project Code

Recently, I'm working on changing some code of Chromium. When I try to use OTL+ODBC to connect mysql, I meet some problems. The OTL used lots of "try,catch,throw" phrases which cannot be used in Chromium Project according to the Google C++ style…
Xx Yu
  • 11
  • 2
1
vote
0 answers

Execute a oracle stored procedure using otl in c++

I have a very simple stored procedure which is below: CREATE OR REPLACE PROCEDURE rc_name (id IN NUMBER, name OUT VARCHAR) IS BEGIN SELECT receivable_class_name INTO name FROM receivableclass WHERE receivable_class_id = id; END; / I execute…
user1939168
  • 547
  • 5
  • 20
1
vote
0 answers

updating database blobs with otl crashes

I'm writing a simple application to correct a certain byte in a binary blob that's stored in a database. I use OTL to connect my C++ program to the database. Reading the data and manipulation works fine, but when I want to write it back to the…
Thomas H
  • 21
  • 1
1
vote
1 answer

C++ OTL doesn't see external database changes

I have a C++ program that is using OTLv4 to connecto to a database. Everything is working fine. I can both insert data into the database and read data out of the database. However, if I change data in the database from another program, then this…
DaedalusAlpha
  • 1,610
  • 4
  • 20
  • 33
1
vote
0 answers

How to warn user on Timecard Review page, OTL?

User enters time on timecard page and clicks on ‘Continue’ button. On the review page he does not ‘Submit’ or goes ‘Back’ or ‘Cancel’. But clicks on other links such as ‘Home’ or ‘Preferences’, etc. Requirement is to provide a warning message to the…
Roopana T
  • 21
  • 3
1
2 3