Connection to Postgres Database using libpqxx

Question

I am using libpqxx to connect to a postgres database by creating a class.

class databaseConnection
{
public:
    pqxx::connection* conn;
    void SetConnection(){
        conn=new pqxx::connection(
            "username=temp "
            "host=db.corral.tacc.utexas.edu "
            "password=timelione "
            "dbname=temp");

    }

    void Disconnect(){
        conn->disconnect();
    }

    pqxx::result query(std::string strSQL){
        //SetConnection();
        pqxx::work trans(*conn,"trans");

        pqxx::result res=trans.exec(strSQL);

        trans.commit();
        return res;
    }
};

int main()
{
    databaseConnection* pdatabase;
    pdatabase->SetConnection();
    return 0;
}

I am getting error that says

terminate called after throwing an instance of 'pqxx::broken_connection' 
what(): invalid connection option "database"

Can anyone help me out?

Thanks

@Gaurav has Daniel's answer helped you? If so please accept it. I'm faced with similar problems and if you don't accept it, most of us new users won't know if this is a solution or not. After all, he's taken the time to help you and you ought to say thanks in the least. — itsols
– itsols, Commented Jun 30, 2013 at 2:23

Daniel Trebbien · Accepted Answer · 2012-08-09 12:09:09Z

14

pgxx::connection(const PGSTD::string&) is basically a wrapper around libpq's PQconnectdb() function, so the supported connection parameter keywords are the same as for libpq.

The parameter key word for the PostgreSQL user name to connect as is user, not username. Perhaps correcting that will fix the problem.

Also, in your sample code, pdatabase is an uninitialized pointer. You could either allocate a databaseConnection object on the stack with:

databaseConnection database;
database.SetConnection();

or use new to heap-allocate a databaseConnection object:

databaseConnection* pdatabase = new databaseConnection();
pdatabase->SetConnection();

But you need to pick one.

edited Aug 9, 2012 at 12:09

answered Oct 14, 2011 at 14:44

Daniel Trebbien

39.5k18 gold badges131 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

yet · Accepted Answer · 2014-04-11 19:20:17Z

7

if you try like this

try
{
    conn = new pqxx::connection(
    "username=temp "
    "host=db.corral.tacc.utexas.edu "
    "password=timelione "
    "dbname=temp");
}
catch (const std::exception &e)
{
    std::cerr << e.what() << std::endl;
}

it catches the exception about connection string:

invalid connection option "username"

answered Apr 11, 2014 at 19:20

yet

80412 silver badges19 bronze badges

Comments

Jesus Noland · Accepted Answer · 2013-09-11 23:17:49Z

0

You might also need to add port=5432 to your connection string.

answered Sep 11, 2013 at 23:17

Jesus Noland

1972 silver badges12 bronze badges

Collectives™ on Stack Overflow

Connection to Postgres Database using libpqxx

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related