otl c tutorial

There are also a lot of articles about OTL on the Internet, but it seems that it is only official documents. OTL is very easy to use. Combined with some official examples, you can try more to understand it. After about a month of project development, I have some knowledge about OTL. Here I will summarize it and hope it will help new users who have just started

Use OTL to access the database-take the wife to the street-C ++ blog Use OTL to access the database Source: http://read.newbooks.com.cn/info/157869.html OTL introduction: OTL Yes Oracle, ODBC and DB2-CLI template library abbreviation, is a C ++ template library for controlling relatio

The code is as follows:#define Otl_bigint Long long#define otl_str_to_bigint (str,n) {n=atoll (STR);} #define OTL_BIGINT_TO_STR (N,STR) {sprintf (STR, "%lld", n);} #include "otlv4.h"//include the OTL 4.0 header fileAs can be seen from the above, OTL does not actually do what work, it is just a macro way to reserve the interface, the specific you own according to the operating system corresponding function

A constant SQL statement an SQL statement that has no bound variables, a SQL statement block, or a stored procedure is called a constant SQL statement. OTL executes such SQL statements through a static function. For example://static otl_cursor::d irect_exec ()otl_cursor::d irect_exec (DB,//Connect Object "CREATE TABLE Test_tab (f1 int, f2 varchar ())" ); //CREATE TABLEotl_cursor::d irect_exec (DB,//Connect Object "drop table Test_tab",//state

Connect OTL to the Oracle database in Linux # Include Using namespace std; # Define OTL_ORA10G // indispensable# Include "otlv4.h" // pay attention to the OTL header file location Otl_connect db; Int main (){Otl_connect: otl_initialize ();Try{Db. rlogon ("user/passwd"); // connect to the local databaseIf (db. connected)Cout }Catch (otl_exception p){Cerr Cerr Cerr Cerr } Db. logoff ();Return 0;} The above i

:14This word has been changed twice ....Bright red Sen 22:27:32Change nouns and tense voicesBright red Sen 22:27:43The electronic dictionary may be dizzy. Positive Solution:Now you can write sentences that fully conform to the original text:Elegant princessClosed(Great)RoundedEyesCompletely. Where Round eyes big circle eyes RoundedRounded adj. roundedThe above software translation uses completely to modify rounded I personally think it is inferior:(I like zookeeper ....) It is better to join

1.OTL_SQL_HANDLE.GET_RPC ():Meaning: The parameters have been removed or inserted several times. Note: When you delete, it is always 0.2. Set the field to the same size.such as: user_id Varchar2[5], the operation, User_idOTL exceptions are typically ORACLE errors:Special: When the card is dead, it is generally not enough to set the cache size.OTL Library Execution exception [32000]:WORKAROUND: The Out parameter type does not match. such as OTL Library

Label:1, the code is as follows: voidTestcache (otl_connectotlconn) { Try { Charsql[1024x768] = {0}; sprintf (SQL,"Call test1 (1)"); Otl_stream Stream ( -, SQL, otlconn,otl_implicit_select); intID; while(!stream.eof ()) {Stream>>ID; Charsql2[1024x768] = {0}; sprintf (SQL2,"Call test2 (:id"); Otl_stream stream2 ( -, SQL2, Otlconn,otl_implicit_select); Stream2ID; while(!stream2.eof ()) { intFF =0; } } } Catch(otl_exceptionex) {printf ("ExecuteSQL E

The entire process structure of otl calling MySQL database in Linux Otl uses the header file otlv4.h to declare the interface. the specific implementation is implemented by unixODBC in linux. the FreeTDS driver is used to call the DBMS of MySQL (my opinion)Software installation steps Therefore, unixODBC and FreeTDS must be installed. Specific installation reference: http://wenku.baidu.com/view/89e9e711a2

FolderFirst: Add the header file of the code you wrote in the Optimizer folder: Optimizer.h file #include Second place: Add code to the Switch.h file, and format it to mimic the contents of the file #define Export_reference_nsga_iiThe third place: Because our general code is encoded in real form, so modify the contents of the file Optimizer.h file under Optimizer.real, the format mimics the contents of the file typedef otl::optimizer::reference_nsga_

OTL has a set of databases for Oracle and ODBC, including their respective otl_connect and otl_stream. The two are differentiated by namespaces. However, suppose we have a class, which may use Oracle or ODBC, so we have to write n template parameters for it. We can use the C ++ traits method to solve this problem.Template Struct cotltraits ...{ Typedef C otl_connect; Typedef s otl_stream; Typedef R otl_refcur_stream; Typedef I otl_stream_read_iterator

1. Add the otl4.h header file; 2. Generate the OCI. Lib file. Because Oracle9i only provides visual C ++ OCI. Li, you must regenerate the BCB lib file and find the following methods on the OTL Forum: I got it working now. I found out, that I needed Re-import the OCI. DLL for use with C ++ Builder as follows: In a separate directory that I created: Implib-a oci. lib ... And then include the newly created. Lib file My project. 3. Add the OCI.