databaseToDdl from db2 problems with schema

["Ihrig, Jens (Key-Work)" <je...@key-work.de>]

Hi,

i have a problem exporting the database structure of ONE schema (called ags) from a db2 database (v8) via ant.
The database contains different schemata. If I set the schemapattern parameter to "ags" the result is an empty .xml oder *.sql file.
if i don´t set the parameter, the task tries to receive data form all tables of all schemas, but
appends the username "extranet" instead of the right schema prefix. which leads to an error as this schema doesnt exist and the tables 
are realy in other schemas.

C:\sources\ags_extranet\build.xml:299: Could not read the schema from the specified database: COM.ibm.db2.jdbc.DB2Exception: 
[IBM][CLI Driver][DB2/NT] SQL0204N  "EXTRANET.ACT_DYN_DATE_CURVE" ist ein nicht definierter Name.  SQLSTATE=42704

("ist ein nicht definierter Name" german for non-defined name)

if anybody has an idea, i would be very thankfull!

wbr
jens ihrig

<target name="dump-database" description="Dumps the database structure">  
		
		<echo message="Dump the database structure"/>
		
		<tstamp>
			<format property="fileNamePrefix" pattern="yyyy-MM-dd_HH-mm-ss_" />
		</tstamp>	
		
		<echo message="using java libraries from: ${java.lib.path}"/>

		<path id="runtime-classpath">
		  <fileset dir="${java.lib.path}">
		    <include name="**/*.jar"/>
		    <include name="**/*.zip"/>
		  </fileset>
		</path>	

		<taskdef classname="org.apache.ddlutils.task.DatabaseToDdlTask"
		           name="databaseToDdl"
		           classpathref="runtime-classpath" 
		 />
	
		<databaseToDdl 
			verbosity="DEBUG"  
			modelname="ags"
			tabletypes="TABLE"
			schemapattern="ags"	
		>
			    <database	url="jdbc:db2:ags_ex"
			              	driverClassName="COM.ibm.db2.jdbc.app.DB2Driver"
			              	username="extranet"
			              	password="********"
			    />

			    <writeSchemaToFile outputFile="${database-dump.path}${fileNamePrefix}db_schema.xml"/>
			<writeSchemaSqlToFile outputFile="${database-dump.path}${fileNamePrefix}db_schema.sql"/>
	  </databaseToDdl>
	

	</target>

Jens Ihrig 
Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany | www.key-work.de
Fon: +49-721-78203-15 | E-Mail: jens.ihrig@key-work.de | Fax: +49-721-78203-10

Key-Work Consulting GmbH Karlsruhe, HRB 108695, HRG Mannheim
Geschäftsführer: Andreas Stappert, Tobin Wotring