Re: Are occi statement objects persistent?

"lovecreatesbea..._at_gmail.com" <lovecreatesbeauty_at_gmail.com> schreef in bericht news:1165589467.981282.198360_at_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.
>

You need to create an environment first
Environment* env = Environment::createEnvironment(Environment::DEFAULT); Connection* con = env->createConection();

johan Received on Fri Dec 08 2006 - 10:48:25 CST