mapping one object in different RDBMS - source

[Stas Ostapenko]

I have a problem with inserting all table data of one table to another
table in other RDBMS. Following code works, but it stores not all the
data, but only first object.
Where I`m wrong ?
Please help.

import org.apache.ojb.broker.PersistenceBroker;
import org.apache.ojb.broker.PersistenceBrokerException;
import org.apache.ojb.broker.PersistenceBrokerFactory;
import org.apache.ojb.broker.query.QueryByCriteria;
import org.apache.ojb.broker.query.Criteria;
import org.apache.ojb.broker.metadata.DescriptorRepository;
import org.apache.ojb.broker.metadata.FieldDescriptor;
import org.apache.ojb.broker.metadata.MetadataManager;
import org.apache.ojb.broker.metadata.ClassDescriptor;

import java.util.Iterator;

public class From_MySQL_2_HSQL_DB_testing
{
        public static void main(String args[])
        {
        PersistenceBroker hsql_db_broker = null;

        PersistenceBroker mysql_db_broker = null;

        Object result = null;

        ClassDescriptor hsql_db_Domain_classDescriptor  = null;
        ClassDescriptor mysql_db_Domain_classDescriptor = null;
    try
    {
        hsql_db_broker =
PersistenceBrokerFactory.createPersistenceBroker("HSQL_OJB_Files",
"root", "");

        mysql_db_broker =
PersistenceBrokerFactory.createPersistenceBroker("MySQL_Main_Database",
"root", "");

        hsql_db_Domain_classDescriptor =
hsql_db_broker.getClassDescriptor(Domain.class);
        hsql_db_Domain_classDescriptor.setTableName("hsqldb_domain");

        mysql_db_Domain_classDescriptor =
mysql_db_broker.getClassDescriptor(Domain.class);
        mysql_db_Domain_classDescriptor.setTableName("domain");

        Criteria criteria = new Criteria();

        criteria.addLike("Domain", "%");
        QueryByCriteria query = new QueryByCriteria(Domain.class, criteria);

        Iterator bdIterator = mysql_db_broker.getIteratorByQuery(query);

        while(bdIterator.hasNext())
        {
        mysql_db_Domain_classDescriptor.setTableName("domain");
        result = bdIterator.next();

        hsql_db_Domain_classDescriptor.setTableName("hsqldb_domain");
                hsql_db_broker.beginTransaction();
                        hsql_db_broker.store(result);
                hsql_db_broker.commitTransaction();
        System.out.println(((Domain)result).Name);
        }
    }
            catch(Exception e)
                {
                e.printStackTrace();
                }
            finally
            {
                //close HSQLDB connection
                hsql_db_broker.close();

                //close MySQL connection
                mysql_db_broker.close();
            }
        }
}

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