xadrv/postgres/ecpg.c

0001 /**
0002  * @brief Postgres ECPG Connection
0003  *
0004  * @file ecpg.c
0005  */
0006 /* -----------------------------------------------------------------------------
0007  * Enduro/X Middleware Platform for Distributed Transaction Processing
0008  * Copyright (C) 2009-2016, ATR Baltic, Ltd. All Rights Reserved.
0009  * Copyright (C) 2017-2023, Mavimax, Ltd. All Rights Reserved.
0010  * This software is released under one of the following licenses:
0011  * AGPL (with Java and Go exceptions) or Mavimax's license for commercial use.
0012  * See LICENSE file for full text.
0013  * -----------------------------------------------------------------------------
0014  * AGPL license:
0015  *
0016  * This program is free software; you can redistribute it and/or modify it under
0017  * the terms of the GNU Affero General Public License, version 3 as published
0018  * by the Free Software Foundation;
0019  *
0020  * This program is distributed in the hope that it will be useful, but WITHOUT ANY
0021  * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
0022  * PARTICULAR PURPOSE. See the GNU Affero General Public License, version 3
0023  * for more details.
0024  *
0025  * You should have received a copy of the GNU Affero General Public License along
0026  * with this program; if not, write to the Free Software Foundation, Inc.,
0027  * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
0028  *
0029  * -----------------------------------------------------------------------------
0030  * A commercial use license is available from Mavimax, Ltd
0031  * contact@mavimax.com
0032  * -----------------------------------------------------------------------------
0033  */
0034 #include <string.h>
0035 #include <stdio.h>
0036 #include <stdlib.h>
0037
0038 #include <ndrstandard.h>
0039 #include <ndebug.h>
0040 #include <atmi.h>
0041
0042 #include "atmi_shm.h"
0043 #include "utlist.h"
0044
0045 #include <xa.h>
0046 #include <ecpglib.h>
0047 #include <pgxa.h>
0048 #include <thlock.h>
0049 /*---------------------------Externs------------------------------------*/
0050 /*---------------------------Macros-------------------------------------*/
0051 /*---------------------------Enums--------------------------------------*/
0052 /*---------------------------Typedefs-----------------------------------*/
0053 /*---------------------------Globals------------------------------------*/
0054 /*---------------------------Statics------------------------------------*/
0055 /*---------------------------Prototypes---------------------------------*/
0056
0057 /**
0058  * Perform connect
0059  * @param conndata parsed connection data
0060  * @param connname connection name
0061  * @return NULL (connection failed) or connection object
0062  */
0063 expublic PGconn * ndrx_pg_connect(ndrx_pgconnect_t *conndata, char *connname)
0064 {
0065     PGconn *ret = NULL;
0066
0067     NDRX_LOG(log_debug, "Establishing ECPG connection: [%s]", connname);
0068
0069     /* OK, try to open, with out autocommit please!
0070      */
0071     if (!ECPGconnect (__LINE__, conndata->c, conndata->url, conndata->user,
0072             conndata->password, connname, EXFALSE))
0073     {
0074         NDRX_LOG(log_error, "ECPGconnect failed, code %ld state: [%s]: %s",
0075                 (long)sqlca.sqlcode, sqlca.sqlstate, sqlca.sqlerrm.sqlerrmc);
0076         ret = NULL;
0077         goto out;
0078     }
0079
0080     ret = ECPGget_PGconn(connname);
0081     if (NULL==ret)
0082     {
0083         NDRX_LOG(log_error, "Postgres error: failed to get PQ connection!");
0084         ret = NULL;
0085         goto out;
0086     }
0087
0088 out:
0089     return ret;
0090 }
0091
0092 /**
0093  * disconnect from postgres
0094  * @param conn current connection object
0095  * @param connname connection name
0096  * @return EXSUCCEED/EXFAIL
0097  */
0098 expublic int ndrx_pg_disconnect(PGconn *conn, char *connname)
0099 {
0100     int ret = EXSUCCEED;
0101
0102     NDRX_LOG(log_debug, "Closing ECPG connection: [%s]", connname);
0103
0104     if (!ECPGdisconnect(__LINE__, connname))
0105     {
0106         NDRX_LOG(log_error, "ECPGdisconnect failed: %s",
0107                 PQerrorMessage(conn));
0108         EXFAIL_OUT(ret);
0109     }
0110 out:
0111     return ret;
0112 }
0113
0114 /* vim: set ts=4 sw=4 et smartindent: */