Re: Are occi statement objects persistent?

From: <lovecreatesbea..._at_gmail.com>
Date: 8 Dec 2006 06:51:08 -0800
Message-ID: <1165589467.981282.198360@f1g2000cwa.googlegroups.com>

KM wrote:
> lovecreatesbea..._at_gmail.com wrote:
> > Can creating, using and terminating a member statement objects span
> > multiple C++ functions in a class?
> >
> > Can I write code like the following?
> >
> > class COgFileSize{
> >
> > private:
> > Connection *m_pConn;
> > Statement *m_pStm;
> >
> > public:
> > COgFileSize(){
> > m_pStm = m_pConn->createStatement();
> > }
> >
> > ~COgFileSize(){
> > m_pStm = m_pConn->terminateStatement(m_pStm);
> > }
> >
> > void Process(){
> > m_pStm->setSQL("SELECT count(*) FROM dual;");
> > ResultSet *rs = m_pStm->executeQuery();
> > /* ... */
> > }
> > };
> >

> yes, you can. The memory is managed by OCCI and the control objects
> (Connection, Statement, Resultset) are deleted only by calling explicit
> terminate/close methods. You need to make sure the parent objects are
> around though. For example, the Env should not be terminated till all
> the connections from that Env are terminated. A Connection should not be
> terminated till all its Statement objects are terminated. A Statement
> should not be terminated till its ResultSet object is closed.

Thank you. When I tried to code like above, I got memory fault (coredump). Maybe I didn't code it correctly. Received on Fri Dec 08 2006 - 08:51:08 CST