a select OQLQuery doing an insert on commit? [newbie]

[katarn]

Hello,

I am having the following situation and I don't know where is my error:

This is the code:
           tx = impl.newTransaction();
           tx.begin();          
           final OQLQuery query = impl.newOQLQuery();
           query.create("select TABLE from "  + 
classtype.class.getName()  + " where KEY= $1");
           query.bind( new Long( KEYID ) );
           final DList results = (DList) query.execute();
           final Iterator iterator = results.iterator();
           while ( iterator.hasNext() )
           {
               dataList.add( iterator.next() );
            }
           tx.commit();

After each commit the first row is inserted again in the table,

Any suggestion about where to look?

Thanks in advance!

K.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]