Newbie question - New to Benerator

[beneratorrocks]

Hi Volker,

I just started trying out Benerator - so this might be a basic question. I am trying to set up a Benerator.xml for a simple table schema/data copy from a DB2 table to MySQL table. My DB2 database has multiple schemas. So I specified database source like so

Code: Select all

 <database id="src"
        url="jdbc:db2://<Server>:<Port>/<Database>"
        driver="com.ibm.db2.jcc.DB2Driver"   
      schema="ab,cd,de"
      catalog="<Database>"
        user="<user name>"
      password="<password>"/>

The source DB2 table is ab.tbl where ab is the database schema and tbl is the database table name. How do I specify this in my iterate statement ?

I tried the below iterate statement but I get the error "generate failed: java.lang.RuntimeException: org.databene.commons.ObjectNotFoundException: Table null"

Code: Select all

<iterate type="state" source="src" encoding="utf-8" consumer="tgt" onError="debug" />

[Volker Bergmann]

Hi,

currently benerator is designed to access only one single schema with one <database> in order to avoid name collisions.

The simplest solution for your case would be to use three different <database> instances, one for each schema.

Regards,