Index: driver/transact.c =================================================================== --- driver/transact.c (revision 244) +++ driver/transact.c (working copy) @@ -20,33 +20,22 @@ Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ -/*************************************************************************** - * TRANSACT.C * - * * - * @description: For processing transactions * - * * - * @author : MySQL AB(monty@mysql.com, venu@mysql.com) * - * @date : 2001-Aug-15 * - * @product : myodbc3 * - * * - ****************************************************************************/ +/** + @file transact.c + @brief Transaction processing functions. +*/ -/*************************************************************************** - * The following ODBC APIs are implemented in this file: * - * * - * SQLEndTran (ISO 92) * - * SQLTransact (ODBC, Deprecated) * - * * - ****************************************************************************/ - #include "myodbc3.h" -/* - @type : internal - @purpose : to do the transaction at the connection level +/** + Commit or roll back the transactions associated with a particular + database connection. + + @param[in] hdbc Handle of database connection + @param[in] CompletionType How to complete the transactions, + @c SQL_COMMIT or @c SQL_ROLLBACK */ - -SQLRETURN my_transact(SQLHDBC hdbc,SQLSMALLINT CompletionType) +static SQLRETURN my_transact(SQLHDBC hdbc, SQLSMALLINT CompletionType) { SQLRETURN result= SQL_SUCCESS; DBC FAR *dbc= (DBC FAR *)hdbc; @@ -97,6 +86,19 @@ operations on all statements associated with a connection */ +/** + Commit or roll back the transactions associated with a particular + database connection, or all connections in an environment. + + @param[in] HandleType Type of @a Handle, @c SQL_HANDLE_ENV or + @c SQL_HANDLE_DBC + @param[in] Handle Handle to database connection or environment + @param[in] CompletionType How to complete the transactions, + @c SQL_COMMIT or @c SQL_ROLLBACK + + @since ODBC 3.0 + @since ISO SQL 92 +*/ SQLRETURN SQL_API SQLEndTran(SQLSMALLINT HandleType, SQLHANDLE Handle, @@ -108,18 +110,17 @@ MYODBCDbgEnter; - MYODBCDbgInfo( "type: %s", MYODBCDbgHandleTypeString( HandleType ) ); - MYODBCDbgInfo( "handle: 0x%x", Handle ); - MYODBCDbgInfo( "option: %s", MYODBCDbgTransactionTypeString( CompletionType ) ); + MYODBCDbgInfo("type: %s", MYODBCDbgHandleTypeString(HandleType)); + MYODBCDbgInfo("handle: 0x%lx", (long)Handle); + MYODBCDbgInfo("option: %s", MYODBCDbgTransactionTypeString(CompletionType)); switch (HandleType) { case SQL_HANDLE_ENV: - henv = (ENV*)Handle; - current= henv->connections; - do + henv= (ENV *)Handle; + for (current= henv->connections; current; current= current->next) { - my_transact( (DBC*)current->data, CompletionType ); - }while( current = current->next ); + my_transact((DBC *)current->data, CompletionType); + } break; case SQL_HANDLE_DBC: @@ -135,27 +136,28 @@ } -/* - @type : ODBC 1.0 - @purpose : Requests a commit or rollback operation for all active - operations on all statement handles (hstmts) associated - with a connection or for all connections associated - with the environment handle, henv +/** + Commit or roll back the transactions associated with a particular + database connection, or all connections in an environment. + + @deprecated This function is deprecated, SQLEndTran() should be used instead. + + @param[in] henv Handle to database environment + @param[in] hdbc Handle to database connection + @param[in] fType How to complete the transactions, + @c SQL_COMMIT or @c SQL_ROLLBACK + + @since ODBC 1.0 */ - -SQLRETURN SQL_API SQLTransact(SQLHENV henv __attribute__((unused)), +SQLRETURN SQL_API SQLTransact(SQLHENV henv, SQLHDBC hdbc, SQLUSMALLINT fType) { - SQLRETURN result= SQL_SUCCESS; - MYODBCDbgEnter; - MYODBCDbgInfo( "henv: 0x%x", henv ); - MYODBCDbgInfo( "hdbc: 0x%x", hdbc ); - MYODBCDbgInfo( "option: %d", fType ); + MYODBCDbgInfo("henv: 0x%lx", (long)henv ); + MYODBCDbgInfo("hdbc: 0x%lx", (long)hdbc ); + MYODBCDbgInfo("option: %s", MYODBCDbgTransactionTypeString(fType)); - if (hdbc) - result= my_transact(hdbc,fType); - - MYODBCDbgReturnReturn(result); + MYODBCDbgReturnReturn(SQLEndTran(hdbc ? SQL_HANDLE_DBC : SQL_HANDLE_ENV, + hdbc ? hdbc : henv, fType)); } Index: test/include/odbctap.h =================================================================== --- test/include/odbctap.h (revision 0) +++ test/include/odbctap.h (revision 0) @@ -0,0 +1,229 @@ +/* + Copyright (C) 2007 MySQL AB + + This program is free software; you can redistribute it and/or modify + it under the terms of version 2 of the GNU General Public License as + published by the Free Software Foundation. + + There are special exceptions to the terms and conditions of the GPL + as it is applied to this software. View the full text of the exception + in file LICENSE.exceptions in the top-level directory of this software + distribution. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +*/ + +/** + @file odbctap.h + + A basic interface for writing tests that produces TAP-compliant output. +*/ + +/** @todo Remove dependency on this crufty old header. */ +#include "mytest3.h" + +#ifndef OK +# define OK 0 +#endif +#ifndef FAIL +# define FAIL 1 +#endif + +typedef int (*test_func)(SQLHDBC, SQLHSTMT, SQLHENV); + +#define DECLARE_TEST(name) \ + int (name)(SQLHDBC hdbc, SQLHSTMT hstmt, SQLHENV henv) + +typedef struct { + char *name; + test_func func; +} my_test; + +#define BEGIN_TESTS my_test tests[]= { +#define ADD_TEST(name) { #name, name }, +#define END_TESTS }; + +#define RUN_TESTS \ +int main(int argc, char **argv) \ +{ \ + SQLHENV henv; \ + SQLHDBC hdbc; \ + SQLHSTMT hstmt; \ + int i, num_tests; \ +\ + if (argc > 1) \ + mydsn= (SQLCHAR *)argv[1]; \ + if (argc > 2) \ + myuid= (SQLCHAR *)argv[2]; \ + if (argc > 3) \ + mypwd= (SQLCHAR *)argv[3]; \ +\ + num_tests= sizeof(tests) / sizeof(tests[0]); \ + printf("1..%d\n", num_tests); \ +\ + alloc_basic_handles(&henv,&hdbc,&hstmt); \ +\ + for (i= 0; i < num_tests; i++ ) \ + { \ + int rc= tests[i].func(hdbc, hstmt, henv); \ + printf("%d %s - %s\n", i + 1, rc == OK ? "ok" : "not ok", tests[i].name); \ + } \ +\ + free_basic_handles(&henv,&hdbc,&hstmt); \ +\ + exit(0); \ +} + +/** + Execute an SQL statement and bail out if the execution does not return + SQL_SUCCESS or SQL_SUCCESS_WITH_INFO. + + @param hstmt Handle for statement object + @param query The query to execute +*/ +#define ok_sql(hstmt, query) \ +do { \ + SQLRETURN rc= SQLExecDirect(hstmt, (SQLCHAR *)query, SQL_NTS); \ + print_diag(rc, SQL_HANDLE_STMT, hstmt, \ + "SQLExecDirect(hstmt, \"" query "\", SQL_NTS)",\ + __FILE__, __LINE__); \ + if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) \ + return FAIL; \ +} while (0) + +/** + Verify that the results of an ODBC function call on a statement handle was + SQL_SUCCESS or SQL_SUCCESS_WITH_INFO. + + @param hstmt Handle for statement object + @param call The function call +*/ +#define ok_stmt(hstmt, call) \ +do { \ + SQLRETURN rc= call; \ + print_diag(rc, SQL_HANDLE_STMT, hstmt, #call, __FILE__, __LINE__); \ + if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) \ + return FAIL; \ +} while (0) + + +/** + Verify that the result of an ODBC function call matches an expected + result, such as SQL_NO_DATA_FOUND. + + @param hstmt Handle for statement object + @param call The function call + @param expect The expected result +*/ +#define expect_stmt(hstmt, call, expect) \ +do { \ + SQLRETURN rc= call; \ + if (rc != expect) \ + { \ + print_diag(rc, SQL_HANDLE_STMT, hstmt, #call, __FILE__, __LINE__); \ + printf("# Expected %d, but got %d in %s on line %d\n", expect, rc, \ + __FILE__, __LINE__); \ + return FAIL; \ + } \ +} while (0) + + +/** + Verify that the results of an ODBC function call on a connection handle + was SQL_SUCCESS or SQL_SUCCESS_WITH_INFO. + + @param hstmt Handle for statement object + @param call The function call +*/ +#define ok_con(hdbc, call) \ +do { \ + SQLRETURN rc= call; \ + print_diag(rc, SQL_HANDLE_DBC, hdbc, #call, __FILE__, __LINE__); \ + if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) \ + return FAIL; \ +} while (0) + + +/** +*/ +void print_diag(SQLRETURN rc, SQLSMALLINT htype, SQLHANDLE handle, + const char *text, const char *file, int line) +{ + if (!SQL_SUCCEEDED(rc)) + { + SQLCHAR sqlstate[6], message[SQL_MAX_MESSAGE_LENGTH]; + SQLINTEGER native_error; + SQLSMALLINT length; + + /** @todo map rc to SQL_SUCCESS_WITH_INFO, etc */ + printf("# %s = %d\n", text, rc); + + /** @todo Handle multiple diagnostic records. */ + SQLRETURN drc= SQLGetDiagRec(htype, handle, 1, sqlstate, &native_error, + message, SQL_MAX_MESSAGE_LENGTH - 1, &length); + + if (SQL_SUCCEEDED(drc)) + printf("# [%6s] %*s in %s on line %d\n", + sqlstate, length, message, file, line); + else + printf("# Did not get expected diagnostics from SQLGetDiagRec()" + " in file %s on line %d\n", file, line); + } +} + + +void alloc_basic_handles(SQLHENV *henv,SQLHDBC *hdbc, SQLHSTMT *hstmt) +{ + SQLRETURN rc; + + rc = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,henv); + myenv(*henv,rc); + + rc = SQLSetEnvAttr(*henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER)SQL_OV_ODBC3,0); + myenv(*henv,rc); + + rc = SQLAllocHandle(SQL_HANDLE_DBC,*henv, hdbc); + myenv(*henv,rc); + + rc = SQLConnect(*hdbc, mydsn, SQL_NTS, myuid, SQL_NTS, mypwd, SQL_NTS); + mycon(*hdbc,rc); + + rc = SQLSetConnectAttr(*hdbc,SQL_ATTR_AUTOCOMMIT, + (SQLPOINTER)SQL_AUTOCOMMIT_ON,0); + mycon(*hdbc,rc); + + rc = SQLAllocHandle(SQL_HANDLE_STMT,*hdbc,hstmt); + mycon(*hdbc,rc); + + SQLSetStmtAttr(*hstmt,SQL_ATTR_CURSOR_TYPE,(SQLPOINTER)SQL_CURSOR_STATIC,0); + SQLSetStmtOption(*hstmt,SQL_SIMULATE_CURSOR,SQL_SC_NON_UNIQUE); + SQLSetStmtOption(*hstmt, SQL_CURSOR_TYPE, SQL_CURSOR_KEYSET_DRIVEN); +} + + +void free_basic_handles(SQLHENV *henv,SQLHDBC *hdbc, SQLHSTMT *hstmt) +{ + SQLRETURN rc; + + rc= SQLEndTran(SQL_HANDLE_DBC, *hdbc, SQL_COMMIT); + mycon(*hdbc, rc); + + rc= SQLFreeStmt(*hstmt, SQL_DROP); + mystmt(*hstmt,rc); + + rc= SQLDisconnect(*hdbc); + mycon(*hdbc,rc); + + rc= SQLFreeConnect(*hdbc); + mycon(*hdbc,rc); + + rc= SQLFreeEnv(*henv); + myenv(*henv,rc); +} Index: test/tran/my_tran.c =================================================================== --- test/tran/my_tran.c (revision 244) +++ test/tran/my_tran.c (working copy) @@ -1,200 +1,120 @@ -/*************************************************************************** - my_tran.c - description - ------------------- - begin : Wed Aug 8 2001 - copyright : (C) MySQL AB 1995-2002, www.mysql.com - author : venu ( venu@mysql.com ) - ***************************************************************************/ +/* + Copyright (C) 1995-2007 MySQL AB -/*************************************************************************** - * * - * This program is free software; you can redistribute it and/or modify * - * it under the terms of the GNU General Public License as published by * - * the Free Software Foundation; either version 2 of the License, or * - * (at your option) any later version. * - * * - ***************************************************************************/ + This program is free software; you can redistribute it and/or modify + it under the terms of version 2 of the GNU General Public License as + published by the Free Software Foundation. -/*************************************************************************** - * * - * This is a basic sample to demonstrate the transaction support in * - * MySQL using MySQL ODBC 3.51 driver * - * * - ***************************************************************************/ + There are special exceptions to the terms and conditions of the GPL + as it is applied to this software. View the full text of the exception + in file LICENSE.exceptions in the top-level directory of this software + distribution. -#include "../include/mytest3.h" /* MyODBC 3.51 sample utility header */ + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +*/ -/******************************************************** -* Transactional behaviour using BDB/InnoDB table type * -*********************************************************/ -void my_transaction(SQLHDBC hdbc, SQLHSTMT hstmt, SQLHENV henv, SQLHDBC hdbc2, SQLHSTMT hstmt2, SQLHENV henv2) +#include "odbctap.h" + +/** + Test transaction behavior using InnoDB tables +*/ +DECLARE_TEST(my_transaction) { - SQLRETURN rc, rc2; + SQLHDBC hdbc2; + SQLHSTMT hstmt2; + SQLHENV henv2; - if (!server_supports_trans(hdbc)) - return; + /** @todo need a mechanism for outputting skip results */ + if (!server_supports_trans(hdbc)) + return FAIL; - /* set AUTOCOMMIT to OFF */ - rc = SQLSetConnectAttr(hdbc,SQL_ATTR_AUTOCOMMIT,(SQLPOINTER)SQL_AUTOCOMMIT_OFF,0); - mycon(hdbc,rc); + alloc_basic_handles(&henv2, &hdbc2, &hstmt2); - rc = SQLExecDirect(hstmt,"DROP TABLE IF EXISTS my_demo_transaction",SQL_NTS); - mystmt(hstmt,rc); + /* set AUTOCOMMIT to OFF */ + ok_con(hdbc, SQLSetConnectAttr(hdbc,SQL_ATTR_AUTOCOMMIT, + (SQLPOINTER)SQL_AUTOCOMMIT_OFF,0)); - rc = SQLTransact(NULL,hdbc,SQL_COMMIT); - mycon(hdbc,rc); + ok_sql(hstmt, "DROP TABLE IF EXISTS t1"); - /* create the table 'mytran_demo' of type BDB' or 'InnoDB' */ - rc = SQLExecDirect(hstmt,"CREATE TABLE my_demo_transaction(col1 int ,col2 varchar(30)) TYPE = InnoDB",SQL_NTS); - mystmt(hstmt,rc); + ok_con(hdbc, SQLTransact(NULL,hdbc,SQL_COMMIT)); - rc = SQLTransact(NULL,hdbc,SQL_COMMIT); - mycon(hdbc,rc); + /* create the table 't1' using InnoDB */ + ok_sql(hstmt, "CREATE TABLE t1 (col1 INT, col2 VARCHAR(30))" + " ENGINE = InnoDB"); - /* insert a row and commit the transaction */ - rc = SQLExecDirect(hstmt,"INSERT INTO my_demo_transaction VALUES(10,'venu')",SQL_NTS); - mystmt(hstmt,rc); + /* insert a row and commit the transaction */ + ok_sql(hstmt, "INSERT INTO t1 VALUES(10,'venu')"); + ok_con(hdbc, SQLTransact(NULL,hdbc,SQL_COMMIT)); - rc = SQLTransact(NULL,hdbc,SQL_COMMIT); - mycon(hdbc,rc); + /* now insert the second row, but roll back that transaction */ + ok_sql(hstmt,"INSERT INTO t1 VALUES(20,'mysql')"); + ok_con(hdbc, SQLTransact(NULL,hdbc,SQL_ROLLBACK)); - /* now insert the second row, and rollback the transaction */ - rc = SQLExecDirect(hstmt,"INSERT INTO my_demo_transaction VALUES(20,'mysql')",SQL_NTS); - mystmt(hstmt,rc); + /* delete first row, but roll it back */ + ok_sql(hstmt,"DELETE FROM t1 WHERE col1 = 10"); + ok_con(hdbc, SQLTransact(NULL,hdbc,SQL_ROLLBACK)); - rc = SQLTransact(NULL,hdbc,SQL_ROLLBACK); - mycon(hdbc,rc); + /* Bug #21588: Incomplete ODBC API implementaion */ + /* insert a row, but roll it back using SQLTransact on the environment */ + ok_sql(hstmt,"INSERT INTO t1 VALUES(30,'mysql')"); + ok_con(hdbc, SQLTransact(henv,NULL,SQL_ROLLBACK)); - /* delete first row, and rollback it */ - rc = SQLExecDirect(hstmt,"DELETE FROM my_demo_transaction WHERE col1 = 10",SQL_NTS); - mystmt(hstmt,rc); + ok_stmt(hstmt, SQLFreeStmt(hstmt,SQL_CLOSE)); - rc = SQLTransact(NULL,hdbc,SQL_ROLLBACK); - mycon(hdbc,rc); + /* test the results now, only one row should exist */ + ok_sql(hstmt,"SELECT * FROM t1"); - rc = SQLFreeStmt(hstmt,SQL_CLOSE); - mystmt(hstmt,rc); + ok_stmt(hstmt, SQLFetch(hstmt)); + expect_stmt(hstmt, SQLFetch(hstmt), SQL_NO_DATA_FOUND); - /* test the results now, only one row should exists */ - rc = SQLExecDirect(hstmt,"SELECT * FROM my_demo_transaction",SQL_NTS); - mystmt(hstmt,rc); + ok_stmt(hstmt, SQLFreeStmt(hstmt,SQL_CLOSE)); - rc = SQLFetch(hstmt); - mystmt(hstmt,rc); + /* now insert some more records to check SQLEndTran */ + ok_sql(hstmt,"INSERT INTO t1 " + "VALUES (30,'test'),(40,'transaction')"); + ok_con(hdbc, SQLTransact(NULL,hdbc,SQL_COMMIT)); - rc = SQLFetch(hstmt); - mystmt_err(hstmt,rc == SQL_NO_DATA_FOUND,rc); + /* Commit the transaction using DBC handler */ + ok_sql(hstmt,"DELETE FROM t1 WHERE col1 = 30"); + ok_con(hdbc, SQLEndTran(SQL_HANDLE_DBC, hdbc, SQL_COMMIT)); - rc = SQLFreeStmt(hstmt,SQL_CLOSE); - mystmt(hstmt,rc); + /* test the results now, select should not find any data */ + ok_sql(hstmt2,"SELECT * FROM t1 WHERE col1 = 30"); + expect_stmt(hstmt2, SQLFetch(hstmt2), SQL_NO_DATA_FOUND); + ok_stmt(hstmt2, SQLFreeStmt(hstmt2,SQL_CLOSE)); - /* now insert some more records to check SQLEndTran */ - rc = SQLExecDirect(hstmt,"INSERT INTO my_demo_transaction VALUES(30,'test'),(40,'transaction')",SQL_NTS); - mystmt(hstmt,rc); + /* Delete a row to check, and commit the transaction using ENV handler */ + ok_sql(hstmt,"DELETE FROM t1 WHERE col1 = 40"); + ok_con(hdbc, SQLEndTran(SQL_HANDLE_ENV, henv, SQL_COMMIT)); - rc = SQLTransact(NULL,hdbc,SQL_COMMIT); - mycon(hdbc,rc); + /* test the results now, select should not find any data */ + ok_sql(hstmt2,"SELECT * FROM t1 WHERE col1 = 40"); + expect_stmt(hstmt2, SQLFetch(hstmt2), SQL_NO_DATA_FOUND); - rc = SQLExecDirect(hstmt,"DELETE FROM my_demo_transaction WHERE col1 = 30",SQL_NTS); - mystmt(hstmt,rc); + ok_stmt(hstmt2, SQLFreeStmt(hstmt2,SQL_CLOSE)); - /* Commit the transaction using DBC handler */ - rc = SQLEndTran(SQL_HANDLE_DBC, hdbc, SQL_COMMIT); - mycon(hdbc,rc); + /* drop the table */ + ok_sql(hstmt,"DROP TABLE t1"); - /* test the results now, select should not find any data */ - rc2 = SQLExecDirect(hstmt2,"SELECT * FROM my_demo_transaction WHERE col1 = 30",SQL_NTS); - mystmt(hstmt2,rc2); + ok_stmt(hstmt, SQLFreeStmt(hstmt,SQL_CLOSE)); - rc2 = SQLFetch(hstmt2); - mystmt_err(hstmt2,rc2 == SQL_NO_DATA_FOUND,rc2); + free_basic_handles(&henv2,&hdbc2,&hstmt2); - rc2 = SQLFreeStmt(hstmt2,SQL_CLOSE); - mystmt(hstmt2,rc2); - - /* Delete a row to check */ - rc = SQLExecDirect(hstmt,"DELETE FROM my_demo_transaction WHERE col1 = 40",SQL_NTS); - mystmt(hstmt,rc); - - /* Commit the transaction using DBC handler */ - rc = SQLEndTran(SQL_HANDLE_ENV, henv, SQL_COMMIT); - mycon(hdbc,rc); - - /* test the results now, select should not find any data */ - rc2 = SQLExecDirect(hstmt2,"SELECT * FROM my_demo_transaction WHERE col1 = 40",SQL_NTS); - mystmt(hstmt2,rc2); - - rc2 = SQLFetch(hstmt2); - mystmt_err(hstmt2,rc2 == SQL_NO_DATA_FOUND,rc2); - - rc2 = SQLFreeStmt(hstmt2,SQL_CLOSE); - mystmt(hstmt2,rc2); - - /* drop the table */ - rc = SQLExecDirect(hstmt,"DROP TABLE my_demo_transaction",SQL_NTS); - mystmt(hstmt,rc); - - rc = SQLTransact(NULL,hdbc,SQL_ROLLBACK); - mycon(hdbc,rc); - - rc = SQLFreeStmt(hstmt,SQL_CLOSE); - mystmt(hstmt,rc); - + return OK; } -/******************************************************** -* main routine * -*********************************************************/ -int main(int argc, char *argv[]) -{ - SQLHENV henv, henv2; - SQLHDBC hdbc, hdbc2; - SQLHSTMT hstmt, hstmt2; - SQLINTEGER narg; - printMessageHeader(); +BEGIN_TESTS + ADD_TEST(my_transaction) +END_TESTS - /* - * if connection string supplied through arguments, overrite - * the default one.. - */ - for (narg = 1; narg < argc; narg++) - { - if ( narg == 1 ) - mydsn = argv[1]; - else if ( narg == 2 ) - myuid = argv[2]; - else if ( narg == 3 ) - mypwd = argv[3]; - } - - /* - * connect to MySQL server - */ - myconnect(&henv,&hdbc,&hstmt); - - /* - create another connection to check whether transactions were committed/rolled back - */ - myconnect(&henv2,&hdbc2,&hstmt2); - - /* - * simple transaction test - */ - my_transaction(hdbc, hstmt, henv, hdbc2, hstmt2, henv2); - - /* - * disconnect from the server, by freeing all resources - */ - mydisconnect(&henv,&hdbc,&hstmt); - - printMessageFooter( 1 ); - - return(0); -} - - - +RUN_TESTS