Reverse engineer information_schema from mysql

dtkaczyk · **Joined:** Mon May 11, 2009 9:12 am **Posts:** 3

Hi,

I'm trying to use hibernate ant tools to reverse engineer the mysql information_schema database. I've done a lot of searching on this and hope that I haven't overlooked anything simple. The problem is that it will not generate any java for me. I think I have figured out why based on sql in log file and a test jdbc program that I have written, but I'm unsure if there is a way through Hibernate to solve the problem.

Here's the details:
mysql-connector-java-5.1.7-bin.jar
mysql 5.0.22-standard-log
Linux dtkaczyk.corporate.camiant.local 2.6.18-92.1.10.el5 #1 SMP Wed Jul 23 03:55:54 EDT 2008 i686 i686 i386 GNU/Linux
jdk1.5.0_05

According to the "CHANGES" file in the driver documentation:
"- Implemented support of INFORMATION_SCHEMA for DatabaseMetadata.getTables() (views there are available as "SYSTEM TABLE"), and thus also made INFORMATION_SCHEMA tables available via DatabaseMetadata.getColumns()."

From the log file (posted as a whole below):
[hibernatetool] 09:35:45,826 DEBUG MySQLMetaDataDialect:26 - getTables(information_schema.null.null)

In order to get a list of tables in my test JDBC program I had to use this:
rs = con.getMetaData().getTables("information_schema", null, "%", new String[] {"SYSTEM TABLE"});

So, my question is: is there a configuration property in hibernate that will allow me to specify a table type of "SYSTEM TABLE"?

I've tried a ton of permutations (upper/lower casing, catalog, schema, on and on) and this is the only one that works. My hack work around is to copy the DDL of the tables from information_schema into another database and reverse them from there.

Any suggestions would be greatly appreciated.

Thanks,
Dave

Ant
=========
<?xml version="1.0" encoding="UTF-8"?>

<project name="SchemaCompare" basedir=".">
<description>SchemaCompare</description>

<path id="toolslib">
<path location="../buildlib/hibernate-tools.jar" />
<path location="../buildlib/hibernate3.jar" />
<path location="../buildlib/commons-logging-1.0.4.jar" />
<path location="../buildlib/dom4j-1.6.1.jar" />
<path location="../buildlib/slf4j-api-1.5.2.jar" />
<path location="../buildlib/slf4j-log4j12.jar" />
<path location="../buildlib/log4j.jar" />
<path location="../buildlib/cglib-2.1.3.jar" />
<path location="../buildlib/asm.jar" />
<path location="../buildlib/commons-collections-3.1.jar" />
<path location="../buildlib/mysql-connector-java-5.1.7-bin.jar" />
<path location="../buildlib/freemarker.jar" />
<path location="../buildlib/jtidy-r8-20060801.jar" />
</path>

<taskdef name="hibernatetool"
classname="org.hibernate.tool.ant.HibernateToolTask"
classpathref="toolslib"
classpath="${basedir}" />

<target name="generate">
<hibernatetool>
<jdbcconfiguration propertyfile="${basedir}/hibernate.properties" packagename="camiant.utils.schemacompare.gen" />

<hbm2hbmxml destdir="${basedir}"/>
<hbm2java destdir="${basedir}" />
<hbm2dao destdir="${basedir}" />
</hibernatetool>
</target>
</project>

hibernate.properties
================
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.password=root
hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema
hibernate.connection.username=root
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.default_catalog=information_schema
hibernate.show_sql=true

Log File
=======
Buildfile: /home/dtkaczyk/ewks1/SchemaCompare/src/build.xml
generate:
[hibernatetool] Executing Hibernate Tool with a JDBC Configuration (for reverse engineering)
[hibernatetool] 1. task: hbm2hbmxml (Generates a set of hbm.xml files)
[hibernatetool] 09:35:44,960 INFO Environment:543 - Hibernate 3.3.1.GA
[hibernatetool] 09:35:44,968 INFO Environment:561 - loaded properties from resource hibernate.properties: {hibernate.connection.username=root, hibernate.connection.password=****, hibernate.dialect=org.hibernate.dialect.MySQL5Dialect, hibernate.show_sql=true, hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema, hibernate.bytecode.use_reflection_optimizer=false, hibernate.connection.driver_class=com.mysql.jdbc.Driver, hibernate.default_catalog=information_schema}
[hibernatetool] 09:35:44,972 INFO Environment:709 - Bytecode provider name : javassist
[hibernatetool] 09:35:44,979 INFO Environment:627 - using JDK 1.4 java.sql.Timestamp handling
[hibernatetool] 09:35:45,247 INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
[hibernatetool] 09:35:45,248 INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 20
[hibernatetool] 09:35:45,250 INFO DriverManagerConnectionProvider:68 - autocommit mode: false
[hibernatetool] 09:35:45,257 INFO DriverManagerConnectionProvider:103 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:45,258 INFO DriverManagerConnectionProvider:106 - connection properties: {user=root, password=root}
[hibernatetool] 09:35:45,260 DEBUG DriverManagerConnectionProvider:132 - opening new JDBC connection
[hibernatetool] 09:35:45,635 DEBUG DriverManagerConnectionProvider:138 - created connection to: jdbc:mysql://localhost:3306/information_schema, Isolation Level: 4
[hibernatetool] 09:35:45,637 INFO SettingsFactory:116 - RDBMS: MySQL, version: 5.0.22-standard-log
[hibernatetool] 09:35:45,638 INFO SettingsFactory:117 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.7 ( Revision: ${svn.Revision} )
[hibernatetool] 09:35:45,674 INFO Dialect:175 - Using dialect: org.hibernate.dialect.MySQL5Dialect
[hibernatetool] 09:35:45,746 INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
[hibernatetool] 09:35:45,753 INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[hibernatetool] 09:35:45,754 INFO SettingsFactory:170 - Automatic flush during beforeCompletion(): disabled
[hibernatetool] 09:35:45,755 INFO SettingsFactory:174 - Automatic session close at end of transaction: disabled
[hibernatetool] 09:35:45,756 INFO SettingsFactory:181 - JDBC batch size: 15
[hibernatetool] 09:35:45,758 INFO SettingsFactory:184 - JDBC batch updates for versioned data: disabled
[hibernatetool] 09:35:45,760 INFO SettingsFactory:189 - Scrollable result sets: enabled
[hibernatetool] 09:35:45,760 DEBUG SettingsFactory:193 - Wrap result sets: disabled
[hibernatetool] 09:35:45,764 INFO SettingsFactory:197 - JDBC3 getGeneratedKeys(): enabled
[hibernatetool] 09:35:45,765 INFO SettingsFactory:205 - Connection release mode: auto
[hibernatetool] 09:35:45,767 INFO SettingsFactory:224 - Default catalog: information_schema
[hibernatetool] 09:35:45,767 INFO SettingsFactory:229 - Maximum outer join fetch depth: 2
[hibernatetool] 09:35:45,768 INFO SettingsFactory:232 - Default batch fetch size: 1
[hibernatetool] 09:35:45,769 INFO SettingsFactory:236 - Generate SQL with comments: disabled
[hibernatetool] 09:35:45,769 INFO SettingsFactory:240 - Order SQL updates by primary key: disabled
[hibernatetool] 09:35:45,772 INFO SettingsFactory:244 - Order SQL inserts for batching: disabled
[hibernatetool] 09:35:45,773 INFO SettingsFactory:420 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[hibernatetool] 09:35:45,777 INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
[hibernatetool] 09:35:45,778 INFO SettingsFactory:252 - Query language substitutions: {}
[hibernatetool] 09:35:45,779 INFO SettingsFactory:257 - JPA-QL strict compliance: disabled
[hibernatetool] 09:35:45,780 INFO SettingsFactory:262 - Second-level cache: enabled
[hibernatetool] 09:35:45,781 INFO SettingsFactory:266 - Query cache: disabled
[hibernatetool] 09:35:45,782 INFO SettingsFactory:405 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
[hibernatetool] 09:35:45,783 INFO SettingsFactory:276 - Optimize cache for minimal puts: disabled
[hibernatetool] 09:35:45,783 INFO SettingsFactory:285 - Structured second-level cache entries: disabled
[hibernatetool] 09:35:45,790 INFO SettingsFactory:305 - Echoing all SQL to stdout
[hibernatetool] 09:35:45,792 INFO SettingsFactory:314 - Statistics: disabled
[hibernatetool] 09:35:45,793 INFO SettingsFactory:318 - Deleted entity synthetic identifier rollback: disabled
[hibernatetool] 09:35:45,795 INFO SettingsFactory:333 - Default entity-mode: pojo
[hibernatetool] 09:35:45,795 INFO SettingsFactory:337 - Named query checking : enabled
[hibernatetool] 09:35:45,826 DEBUG MySQLMetaDataDialect:26 - getTables(information_schema.null.null)
[hibernatetool] 09:35:45,833 INFO DriverManagerConnectionProvider:170 - cleaning up connection pool: jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:45,837 DEBUG Configuration:1153 - processing extends queue
[hibernatetool] 09:35:45,837 DEBUG Configuration:1157 - processing collection mappings
[hibernatetool] 09:35:45,838 DEBUG Configuration:1168 - processing native query and ResultSetMapping mappings
[hibernatetool] 09:35:45,839 DEBUG Configuration:1176 - processing association property references
[hibernatetool] 09:35:45,839 DEBUG Configuration:1198 - processing foreign key constraints
[hibernatetool] 09:35:45,867 DEBUG HibernateMappingExporter:138 - org.hibernate.tool.hbm2x.HibernateMappingExporter outputdir:/home/dtkaczyk/ewks1/SchemaCompare/src path: []
[hibernatetool] 09:35:46,224 INFO Version:15 - Hibernate Tools 3.2.4.GA
[hibernatetool] 09:35:46,231 DEBUG TemplateHelper:149 - putInContext exporter=org.hibernate.tool.hbm2x.HibernateMappingExporter@1963b3e
[hibernatetool] 09:35:46,232 DEBUG TemplateHelper:149 - putInContext c2h=org.hibernate.tool.hbm2x.Cfg2HbmTool@b6548
[hibernatetool] 09:35:46,233 DEBUG TemplateHelper:149 - putInContext c2j=org.hibernate.tool.hbm2x.Cfg2JavaTool@269997
[hibernatetool] 09:35:46,233 DEBUG TemplateHelper:149 - putInContext outputdir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,234 DEBUG TemplateHelper:149 - putInContext template_path=[Ljava.lang.String;@2db19d
[hibernatetool] 09:35:46,235 DEBUG TemplateHelper:149 - putInContext java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
[hibernatetool] 09:35:46,236 DEBUG TemplateHelper:149 - putInContext hibernate.connection.password=root
[hibernatetool] 09:35:46,253 DEBUG TemplateHelper:149 - putInContext sun.boot.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386
[hibernatetool] 09:35:46,255 DEBUG TemplateHelper:149 - putInContext java.vm.version=1.5.0_05-b05
[hibernatetool] 09:35:46,256 DEBUG TemplateHelper:149 - putInContext ant.library.dir=/chameleon/public/ant/apache-ant-1.6.0/lib
[hibernatetool] 09:35:46,257 DEBUG TemplateHelper:149 - putInContext hibernate.connection.username=root
[hibernatetool] 09:35:46,257 DEBUG TemplateHelper:149 - putInContext java.vm.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,258 DEBUG TemplateHelper:149 - putInContext java.vendor.url=http://java.sun.com/
[hibernatetool] 09:35:46,259 DEBUG TemplateHelper:149 - putInContext path.separator=:
[hibernatetool] 09:35:46,260 DEBUG TemplateHelper:149 - putInContext java.vm.name=Java HotSpot(TM) Server VM
[hibernatetool] 09:35:46,260 DEBUG TemplateHelper:149 - putInContext file.encoding.pkg=sun.io
[hibernatetool] 09:35:46,261 DEBUG TemplateHelper:149 - putInContext user.country=US
[hibernatetool] 09:35:46,262 DEBUG TemplateHelper:149 - putInContext sun.os.patch.level=unknown
[hibernatetool] 09:35:46,263 DEBUG TemplateHelper:149 - putInContext java.vm.specification.name=Java Virtual Machine Specification
[hibernatetool] 09:35:46,263 DEBUG TemplateHelper:149 - putInContext user.dir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,264 DEBUG TemplateHelper:149 - putInContext java.runtime.version=1.5.0_05-b05
[hibernatetool] 09:35:46,265 DEBUG TemplateHelper:149 - putInContext java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
[hibernatetool] 09:35:46,266 DEBUG TemplateHelper:149 - putInContext java.endorsed.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/endorsed
[hibernatetool] 09:35:46,266 DEBUG TemplateHelper:149 - putInContext os.arch=i386
[hibernatetool] 09:35:46,267 DEBUG TemplateHelper:149 - putInContext java.io.tmpdir=/tmp
[hibernatetool] 09:35:46,268 DEBUG TemplateHelper:149 - putInContext line.separator=
[hibernatetool] 09:35:46,269 DEBUG TemplateHelper:149 - putInContext java.vm.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,269 DEBUG TemplateHelper:149 - putInContext os.name=Linux
[hibernatetool] 09:35:46,270 DEBUG TemplateHelper:149 - putInContext ant.home=/chameleon/public/ant/apache-ant-1.6.0
[hibernatetool] 09:35:46,271 DEBUG TemplateHelper:149 - putInContext sun.jnu.encoding=UTF-8
[hibernatetool] 09:35:46,271 DEBUG TemplateHelper:149 - putInContext java.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386/server:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386:/mnt/chameleon/public/java/jdk1.5.0_05/jre/../lib/i386:/usr/lib/xulrunner-1.9:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/97/1/.cp
[hibernatetool] 09:35:46,272 DEBUG TemplateHelper:149 - putInContext java.specification.name=Java Platform API Specification
[hibernatetool] 09:35:46,273 DEBUG TemplateHelper:149 - putInContext java.class.version=49.0
[hibernatetool] 09:35:46,274 DEBUG TemplateHelper:149 - putInContext sun.management.compiler=HotSpot Server Compiler
[hibernatetool] 09:35:46,274 DEBUG TemplateHelper:149 - putInContext os.version=2.6.18-92.1.10.el5
[hibernatetool] 09:35:46,275 DEBUG TemplateHelper:149 - putInContext user.home=/home/dtkaczyk
[hibernatetool] 09:35:46,276 DEBUG TemplateHelper:149 - putInContext user.timezone=America/New_York
[hibernatetool] 09:35:46,277 DEBUG TemplateHelper:149 - putInContext java.awt.printerjob=sun.print.PSPrinterJob
[hibernatetool] 09:35:46,278 DEBUG TemplateHelper:149 - putInContext file.encoding=UTF-8
[hibernatetool] 09:35:46,278 DEBUG TemplateHelper:149 - putInContext java.specification.version=1.5
[hibernatetool] 09:35:46,279 DEBUG TemplateHelper:149 - putInContext hibernate.connection.driver_class=com.mysql.jdbc.Driver
[hibernatetool] 09:35:46,300 DEBUG TemplateHelper:149 - putInContext user.name=dtkaczyk
[hibernatetool] 09:35:46,301 DEBUG TemplateHelper:149 - putInContext java.class.path=/chameleon/public/ant/apache-ant-1.6.0/lib/ant-antlr.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-bsf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-resolver.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-logging.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-net.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-icontract.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jai.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-bcel.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-log4j.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-oro.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-regexp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-javamail.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jdepend.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jmf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jsch.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-junit.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-launcher.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-netrexx.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-nodeps.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-starteam.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-stylebook.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-swing.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-trax.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-vaj.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-weblogic.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan2.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xslp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/junit-3.8.1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xercesImpl.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xml-apis.jar:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/484/1/.cp/lib/remoteAnt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/lib/tools.jar:/home/dtkaczyk/softeng/lib/xalan.jar:/home/dtkaczyk/softeng/lib/serializer.jar:/home/dtkaczyk/softeng/lib/xercesImpl.jar:/home/dtkaczyk/softeng/lib/xml-apis.jar:/home/dtkaczyk/softeng/lib/xsltc.jar:/home/dtkaczyk/eclipse/e1/eclipse/plugins/org.eclipse.swt.gtk.linux.x86_3.4.0.v3448f.jar
[hibernatetool] 09:35:46,302 DEBUG TemplateHelper:149 - putInContext hibernate.default_catalog=information_schema
[hibernatetool] 09:35:46,303 DEBUG TemplateHelper:149 - putInContext hibernate.bytecode.use_reflection_optimizer=false
[hibernatetool] 09:35:46,304 DEBUG TemplateHelper:149 - putInContext hibernate.show_sql=true
[hibernatetool] 09:35:46,304 DEBUG TemplateHelper:149 - putInContext java.vm.specification.version=1.0
[hibernatetool] 09:35:46,305 DEBUG TemplateHelper:149 - putInContext sun.arch.data.model=32
[hibernatetool] 09:35:46,306 DEBUG TemplateHelper:149 - putInContext java.home=/mnt/chameleon/public/java/jdk1.5.0_05/jre
[hibernatetool] 09:35:46,306 DEBUG TemplateHelper:149 - putInContext hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:46,307 DEBUG TemplateHelper:149 - putInContext hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
[hibernatetool] 09:35:46,307 DEBUG TemplateHelper:149 - putInContext java.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,308 DEBUG TemplateHelper:149 - putInContext user.language=en
[hibernatetool] 09:35:46,309 DEBUG TemplateHelper:149 - putInContext java.vm.info=mixed mode
[hibernatetool] 09:35:46,310 DEBUG TemplateHelper:149 - putInContext java.version=1.5.0_05
[hibernatetool] 09:35:46,310 DEBUG TemplateHelper:149 - putInContext java.ext.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/ext
[hibernatetool] 09:35:46,311 DEBUG TemplateHelper:149 - putInContext sun.boot.class.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/rt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i18n.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/sunrsasign.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jsse.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jce.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/charsets.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/classes
[hibernatetool] 09:35:46,315 DEBUG TemplateHelper:149 - putInContext java.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,316 DEBUG TemplateHelper:149 - putInContext file.separator=/
[hibernatetool] 09:35:46,317 DEBUG TemplateHelper:149 - putInContext java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
[hibernatetool] 09:35:46,317 DEBUG TemplateHelper:149 - putInContext sun.cpu.endian=little
[hibernatetool] 09:35:46,318 DEBUG TemplateHelper:149 - putInContext sun.io.unicode.encoding=UnicodeLittle
[hibernatetool] 09:35:46,318 DEBUG TemplateHelper:149 - putInContext sun.desktop=gnome
[hibernatetool] 09:35:46,319 DEBUG TemplateHelper:149 - putInContext sun.cpu.isalist=
[hibernatetool] 09:35:46,320 DEBUG TemplateHelper:149 - putInContext artifacts=org.hibernate.tool.hbm2x.ArtifactCollector@e2291
[hibernatetool] 09:35:46,320 DEBUG TemplateHelper:149 - putInContext cfg=org.hibernate.cfg.JDBCMetaDataConfiguration@1ff92f5
[hibernatetool] 09:35:46,321 DEBUG TemplateHelper:149 - putInContext hmgs=org.hibernate.tool.hbm2x.HibernateMappingGlobalSettings@9505f
[hibernatetool] 09:35:46,322 DEBUG TemplateHelper:158 - removeFromContext java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
[hibernatetool] 09:35:46,330 DEBUG TemplateHelper:158 - removeFromContext hibernate.connection.password=root
[hibernatetool] 09:35:46,331 DEBUG TemplateHelper:158 - removeFromContext sun.boot.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386
[hibernatetool] 09:35:46,331 DEBUG TemplateHelper:158 - removeFromContext java.vm.version=1.5.0_05-b05
[hibernatetool] 09:35:46,332 DEBUG TemplateHelper:158 - removeFromContext ant.library.dir=/chameleon/public/ant/apache-ant-1.6.0/lib
[hibernatetool] 09:35:46,332 DEBUG TemplateHelper:158 - removeFromContext hibernate.connection.username=root
[hibernatetool] 09:35:46,333 DEBUG TemplateHelper:158 - removeFromContext java.vm.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,334 DEBUG TemplateHelper:158 - removeFromContext java.vendor.url=http://java.sun.com/
[hibernatetool] 09:35:46,334 DEBUG TemplateHelper:158 - removeFromContext path.separator=:
[hibernatetool] 09:35:46,335 DEBUG TemplateHelper:158 - removeFromContext java.vm.name=Java HotSpot(TM) Server VM
[hibernatetool] 09:35:46,336 DEBUG TemplateHelper:158 - removeFromContext file.encoding.pkg=sun.io
[hibernatetool] 09:35:46,336 DEBUG TemplateHelper:158 - removeFromContext user.country=US
[hibernatetool] 09:35:46,337 DEBUG TemplateHelper:158 - removeFromContext sun.os.patch.level=unknown
[hibernatetool] 09:35:46,338 DEBUG TemplateHelper:158 - removeFromContext java.vm.specification.name=Java Virtual Machine Specification
[hibernatetool] 09:35:46,338 DEBUG TemplateHelper:158 - removeFromContext user.dir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,339 DEBUG TemplateHelper:158 - removeFromContext java.runtime.version=1.5.0_05-b05
[hibernatetool] 09:35:46,339 DEBUG TemplateHelper:158 - removeFromContext java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
[hibernatetool] 09:35:46,340 DEBUG TemplateHelper:158 - removeFromContext java.endorsed.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/endorsed
[hibernatetool] 09:35:46,340 DEBUG TemplateHelper:158 - removeFromContext os.arch=i386
[hibernatetool] 09:35:46,353 DEBUG TemplateHelper:158 - removeFromContext java.io.tmpdir=/tmp
[hibernatetool] 09:35:46,354 DEBUG TemplateHelper:158 - removeFromContext line.separator=
[hibernatetool] 09:35:46,354 DEBUG TemplateHelper:158 - removeFromContext java.vm.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,355 DEBUG TemplateHelper:158 - removeFromContext os.name=Linux
[hibernatetool] 09:35:46,356 DEBUG TemplateHelper:158 - removeFromContext ant.home=/chameleon/public/ant/apache-ant-1.6.0
[hibernatetool] 09:35:46,356 DEBUG TemplateHelper:158 - removeFromContext sun.jnu.encoding=UTF-8
[hibernatetool] 09:35:46,357 DEBUG TemplateHelper:158 - removeFromContext java.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386/server:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386:/mnt/chameleon/public/java/jdk1.5.0_05/jre/../lib/i386:/usr/lib/xulrunner-1.9:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/97/1/.cp
[hibernatetool] 09:35:46,357 DEBUG TemplateHelper:158 - removeFromContext java.specification.name=Java Platform API Specification
[hibernatetool] 09:35:46,358 DEBUG TemplateHelper:158 - removeFromContext java.class.version=49.0
[hibernatetool] 09:35:46,359 DEBUG TemplateHelper:158 - removeFromContext sun.management.compiler=HotSpot Server Compiler
[hibernatetool] 09:35:46,359 DEBUG TemplateHelper:158 - removeFromContext os.version=2.6.18-92.1.10.el5
[hibernatetool] 09:35:46,360 DEBUG TemplateHelper:158 - removeFromContext user.home=/home/dtkaczyk
[hibernatetool] 09:35:46,360 DEBUG TemplateHelper:158 - removeFromContext user.timezone=America/New_York
[hibernatetool] 09:35:46,361 DEBUG TemplateHelper:158 - removeFromContext java.awt.printerjob=sun.print.PSPrinterJob
[hibernatetool] 09:35:46,361 DEBUG TemplateHelper:158 - removeFromContext file.encoding=UTF-8
[hibernatetool] 09:35:46,362 DEBUG TemplateHelper:158 - removeFromContext java.specification.version=1.5
[hibernatetool] 09:35:46,363 DEBUG TemplateHelper:158 - removeFromContext hibernate.connection.driver_class=com.mysql.jdbc.Driver
[hibernatetool] 09:35:46,363 DEBUG TemplateHelper:158 - removeFromContext user.name=dtkaczyk
[hibernatetool] 09:35:46,364 DEBUG TemplateHelper:158 - removeFromContext java.class.path=/chameleon/public/ant/apache-ant-1.6.0/lib/ant-antlr.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-bsf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-resolver.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-logging.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-net.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-icontract.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jai.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-bcel.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-log4j.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-oro.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-regexp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-javamail.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jdepend.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jmf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jsch.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-junit.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-launcher.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-netrexx.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-nodeps.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-starteam.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-stylebook.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-swing.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-trax.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-vaj.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-weblogic.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan2.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xslp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/junit-3.8.1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xercesImpl.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xml-apis.jar:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/484/1/.cp/lib/remoteAnt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/lib/tools.jar:/home/dtkaczyk/softeng/lib/xalan.jar:/home/dtkaczyk/softeng/lib/serializer.jar:/home/dtkaczyk/softeng/lib/xercesImpl.jar:/home/dtkaczyk/softeng/lib/xml-apis.jar:/home/dtkaczyk/softeng/lib/xsltc.jar:/home/dtkaczyk/eclipse/e1/eclipse/plugins/org.eclipse.swt.gtk.linux.x86_3.4.0.v3448f.jar
[hibernatetool] 09:35:46,365 DEBUG TemplateHelper:158 - removeFromContext hibernate.default_catalog=information_schema
[hibernatetool] 09:35:46,365 DEBUG TemplateHelper:158 - removeFromContext hibernate.bytecode.use_reflection_optimizer=false
[hibernatetool] 09:35:46,365 DEBUG TemplateHelper:158 - removeFromContext hibernate.show_sql=true
[hibernatetool] 09:35:46,366 DEBUG TemplateHelper:158 - removeFromContext java.vm.specification.version=1.0
[hibernatetool] 09:35:46,366 DEBUG TemplateHelper:158 - removeFromContext sun.arch.data.model=32
[hibernatetool] 09:35:46,366 DEBUG TemplateHelper:158 - removeFromContext java.home=/mnt/chameleon/public/java/jdk1.5.0_05/jre
[hibernatetool] 09:35:46,367 DEBUG TemplateHelper:158 - removeFromContext hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:46,367 DEBUG TemplateHelper:158 - removeFromContext hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
[hibernatetool] 09:35:46,367 DEBUG TemplateHelper:158 - removeFromContext java.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,368 DEBUG TemplateHelper:158 - removeFromContext user.language=en
[hibernatetool] 09:35:46,368 DEBUG TemplateHelper:158 - removeFromContext java.vm.info=mixed mode
[hibernatetool] 09:35:46,369 DEBUG TemplateHelper:158 - removeFromContext java.version=1.5.0_05
[hibernatetool] 09:35:46,369 DEBUG TemplateHelper:158 - removeFromContext java.ext.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/ext
[hibernatetool] 09:35:46,369 DEBUG TemplateHelper:158 - removeFromContext sun.boot.class.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/rt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i18n.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/sunrsasign.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jsse.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jce.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/charsets.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/classes
[hibernatetool] 09:35:46,370 DEBUG TemplateHelper:158 - removeFromContext java.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,370 DEBUG TemplateHelper:158 - removeFromContext file.separator=/
[hibernatetool] 09:35:46,370 DEBUG TemplateHelper:158 - removeFromContext java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
[hibernatetool] 09:35:46,371 DEBUG TemplateHelper:158 - removeFromContext sun.cpu.endian=little
[hibernatetool] 09:35:46,371 DEBUG TemplateHelper:158 - removeFromContext sun.io.unicode.encoding=UnicodeLittle
[hibernatetool] 09:35:46,371 DEBUG TemplateHelper:158 - removeFromContext sun.desktop=gnome
[hibernatetool] 09:35:46,372 DEBUG TemplateHelper:158 - removeFromContext sun.cpu.isalist=
[hibernatetool] 09:35:46,372 DEBUG TemplateHelper:158 - removeFromContext outputdir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,377 DEBUG TemplateHelper:158 - removeFromContext template_path=[Ljava.lang.String;@2db19d
[hibernatetool] 09:35:46,381 DEBUG TemplateHelper:158 - removeFromContext exporter=org.hibernate.tool.hbm2x.HibernateMappingExporter@1963b3e
[hibernatetool] 09:35:46,387 DEBUG TemplateHelper:158 - removeFromContext artifacts=org.hibernate.tool.hbm2x.ArtifactCollector@e2291
[hibernatetool] 09:35:46,389 DEBUG TemplateHelper:158 - removeFromContext cfg=org.hibernate.cfg.JDBCMetaDataConfiguration@1ff92f5
[hibernatetool] 09:35:46,429 DEBUG TemplateHelper:158 - removeFromContext c2h=org.hibernate.tool.hbm2x.Cfg2HbmTool@b6548
[hibernatetool] 09:35:46,438 DEBUG TemplateHelper:158 - removeFromContext c2j=org.hibernate.tool.hbm2x.Cfg2JavaTool@269997
[hibernatetool] 2. task: hbm2java (Generates a set of .java files)
[hibernatetool] 09:35:46,442 DEBUG POJOExporter:138 - org.hibernate.tool.hbm2x.POJOExporter outputdir:/home/dtkaczyk/ewks1/SchemaCompare/src path: []
[hibernatetool] 09:35:46,442 DEBUG TemplateHelper:149 - putInContext exporter=org.hibernate.tool.hbm2x.POJOExporter@8046f4
[hibernatetool] 09:35:46,443 DEBUG TemplateHelper:149 - putInContext c2h=org.hibernate.tool.hbm2x.Cfg2HbmTool@1b273cc
[hibernatetool] 09:35:46,443 DEBUG TemplateHelper:149 - putInContext c2j=org.hibernate.tool.hbm2x.Cfg2JavaTool@d05c13
[hibernatetool] 09:35:46,444 DEBUG TemplateHelper:149 - putInContext outputdir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,444 DEBUG TemplateHelper:149 - putInContext template_path=[Ljava.lang.String;@14d1d41
[hibernatetool] 09:35:46,444 DEBUG TemplateHelper:149 - putInContext java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
[hibernatetool] 09:35:46,445 DEBUG TemplateHelper:149 - putInContext hibernate.connection.password=root
[hibernatetool] 09:35:46,445 DEBUG TemplateHelper:149 - putInContext sun.boot.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386
[hibernatetool] 09:35:46,445 DEBUG TemplateHelper:149 - putInContext java.vm.version=1.5.0_05-b05
[hibernatetool] 09:35:46,446 DEBUG TemplateHelper:149 - putInContext ant.library.dir=/chameleon/public/ant/apache-ant-1.6.0/lib
[hibernatetool] 09:35:46,446 DEBUG TemplateHelper:149 - putInContext hibernate.connection.username=root
[hibernatetool] 09:35:46,446 DEBUG TemplateHelper:149 - putInContext java.vm.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,447 DEBUG TemplateHelper:149 - putInContext java.vendor.url=http://java.sun.com/
[hibernatetool] 09:35:46,447 DEBUG TemplateHelper:149 - putInContext path.separator=:
[hibernatetool] 09:35:46,447 DEBUG TemplateHelper:149 - putInContext java.vm.name=Java HotSpot(TM) Server VM
[hibernatetool] 09:35:46,447 DEBUG TemplateHelper:149 - putInContext file.encoding.pkg=sun.io
[hibernatetool] 09:35:46,448 DEBUG TemplateHelper:149 - putInContext user.country=US
[hibernatetool] 09:35:46,449 DEBUG TemplateHelper:149 - putInContext sun.os.patch.level=unknown
[hibernatetool] 09:35:46,449 DEBUG TemplateHelper:149 - putInContext java.vm.specification.name=Java Virtual Machine Specification
[hibernatetool] 09:35:46,450 DEBUG TemplateHelper:149 - putInContext user.dir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,450 DEBUG TemplateHelper:149 - putInContext java.runtime.version=1.5.0_05-b05
[hibernatetool] 09:35:46,450 DEBUG TemplateHelper:149 - putInContext java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
[hibernatetool] 09:35:46,450 DEBUG TemplateHelper:149 - putInContext java.endorsed.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/endorsed
[hibernatetool] 09:35:46,452 DEBUG TemplateHelper:149 - putInContext os.arch=i386
[hibernatetool] 09:35:46,453 DEBUG TemplateHelper:149 - putInContext java.io.tmpdir=/tmp
[hibernatetool] 09:35:46,453 DEBUG TemplateHelper:149 - putInContext line.separator=
[hibernatetool] 09:35:46,454 DEBUG TemplateHelper:149 - putInContext java.vm.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,454 DEBUG TemplateHelper:149 - putInContext os.name=Linux
[hibernatetool] 09:35:46,455 DEBUG TemplateHelper:149 - putInContext ant.home=/chameleon/public/ant/apache-ant-1.6.0
[hibernatetool] 09:35:46,455 DEBUG TemplateHelper:149 - putInContext sun.jnu.encoding=UTF-8
[hibernatetool] 09:35:46,456 DEBUG TemplateHelper:149 - putInContext java.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386/server:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386:/mnt/chameleon/public/java/jdk1.5.0_05/jre/../lib/i386:/usr/lib/xulrunner-1.9:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/97/1/.cp
[hibernatetool] 09:35:46,456 DEBUG TemplateHelper:149 - putInContext jdk5=false
[hibernatetool] 09:35:46,457 DEBUG TemplateHelper:149 - putInContext java.specification.name=Java Platform API Specification
[hibernatetool] 09:35:46,457 DEBUG TemplateHelper:149 - putInContext java.class.version=49.0
[hibernatetool] 09:35:46,458 DEBUG TemplateHelper:149 - putInContext sun.management.compiler=HotSpot Server Compiler
[hibernatetool] 09:35:46,458 DEBUG TemplateHelper:149 - putInContext os.version=2.6.18-92.1.10.el5
[hibernatetool] 09:35:46,459 DEBUG TemplateHelper:149 - putInContext user.home=/home/dtkaczyk
[hibernatetool] 09:35:46,464 DEBUG TemplateHelper:149 - putInContext user.timezone=America/New_York
[hibernatetool] 09:35:46,464 DEBUG TemplateHelper:149 - putInContext java.awt.printerjob=sun.print.PSPrinterJob
[hibernatetool] 09:35:46,465 DEBUG TemplateHelper:149 - putInContext file.encoding=UTF-8
[hibernatetool] 09:35:46,465 DEBUG TemplateHelper:149 - putInContext java.specification.version=1.5
[hibernatetool] 09:35:46,466 DEBUG TemplateHelper:149 - putInContext hibernate.connection.driver_class=com.mysql.jdbc.Driver
[hibernatetool] 09:35:46,466 DEBUG TemplateHelper:149 - putInContext user.name=dtkaczyk
[hibernatetool] 09:35:46,480 DEBUG TemplateHelper:149 - putInContext java.class.path=/chameleon/public/ant/apache-ant-1.6.0/lib/ant-antlr.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-bsf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-resolver.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-logging.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-net.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-icontract.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jai.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-bcel.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-log4j.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-oro.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-regexp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-javamail.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jdepend.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jmf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jsch.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-junit.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-launcher.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-netrexx.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-nodeps.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-starteam.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-stylebook.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-swing.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-trax.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-vaj.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-weblogic.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan2.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xslp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/junit-3.8.1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xercesImpl.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xml-apis.jar:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/484/1/.cp/lib/remoteAnt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/lib/tools.jar:/home/dtkaczyk/softeng/lib/xalan.jar:/home/dtkaczyk/softeng/lib/serializer.jar:/home/dtkaczyk/softeng/lib/xercesImpl.jar:/home/dtkaczyk/softeng/lib/xml-apis.jar:/home/dtkaczyk/softeng/lib/xsltc.jar:/home/dtkaczyk/eclipse/e1/eclipse/plugins/org.eclipse.swt.gtk.linux.x86_3.4.0.v3448f.jar
[hibernatetool] 09:35:46,481 DEBUG TemplateHelper:149 - putInContext hibernate.default_catalog=information_schema
[hibernatetool] 09:35:46,481 DEBUG TemplateHelper:149 - putInContext hibernate.bytecode.use_reflection_optimizer=false
[hibernatetool] 09:35:46,482 DEBUG TemplateHelper:149 - putInContext ejb3=false
[hibernatetool] 09:35:46,483 DEBUG TemplateHelper:149 - putInContext hibernate.show_sql=true
[hibernatetool] 09:35:46,483 DEBUG TemplateHelper:149 - putInContext java.vm.specification.version=1.0
[hibernatetool] 09:35:46,483 DEBUG TemplateHelper:149 - putInContext sun.arch.data.model=32
[hibernatetool] 09:35:46,484 DEBUG TemplateHelper:149 - putInContext java.home=/mnt/chameleon/public/java/jdk1.5.0_05/jre
[hibernatetool] 09:35:46,484 DEBUG TemplateHelper:149 - putInContext hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:46,485 DEBUG TemplateHelper:149 - putInContext hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
[hibernatetool] 09:35:46,485 DEBUG TemplateHelper:149 - putInContext java.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,486 DEBUG TemplateHelper:149 - putInContext user.language=en
[hibernatetool] 09:35:46,486 DEBUG TemplateHelper:149 - putInContext java.vm.info=mixed mode
[hibernatetool] 09:35:46,487 DEBUG TemplateHelper:149 - putInContext java.version=1.5.0_05
[hibernatetool] 09:35:46,487 DEBUG TemplateHelper:149 - putInContext java.ext.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/ext
[hibernatetool] 09:35:46,488 DEBUG TemplateHelper:149 - putInContext sun.boot.class.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/rt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i18n.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/sunrsasign.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jsse.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jce.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/charsets.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/classes
[hibernatetool] 09:35:46,488 DEBUG TemplateHelper:149 - putInContext java.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,489 DEBUG TemplateHelper:149 - putInContext file.separator=/
[hibernatetool] 09:35:46,489 DEBUG TemplateHelper:149 - putInContext java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
[hibernatetool] 09:35:46,490 DEBUG TemplateHelper:149 - putInContext sun.cpu.endian=little
[hibernatetool] 09:35:46,490 DEBUG TemplateHelper:149 - putInContext sun.io.unicode.encoding=UnicodeLittle
[hibernatetool] 09:35:46,491 DEBUG TemplateHelper:149 - putInContext sun.desktop=gnome
[hibernatetool] 09:35:46,491 DEBUG TemplateHelper:149 - putInContext sun.cpu.isalist=
[hibernatetool] 09:35:46,492 DEBUG TemplateHelper:149 - putInContext artifacts=org.hibernate.tool.hbm2x.ArtifactCollector@1bbd7b2
[hibernatetool] 09:35:46,492 DEBUG TemplateHelper:149 - putInContext cfg=org.hibernate.cfg.JDBCMetaDataConfiguration@1ff92f5
<removeFromContext removed for brevity!>
c2j=org.hibernate.tool.hbm2x.Cfg2JavaTool@d05c13
[hibernatetool] 3. task: hbm2dao (Generates a set of DAOs)
[hibernatetool] 09:35:46,540 DEBUG DAOExporter:138 - org.hibernate.tool.hbm2x.DAOExporter outputdir:/home/dtkaczyk/ewks1/SchemaCompare/src path: []
[hibernatetool] 09:35:46,541 DEBUG TemplateHelper:149 - putInContext exporter=org.hibernate.tool.hbm2x.DAOExporter@8de462
[hibernatetool] 09:35:46,542 DEBUG TemplateHelper:149 - putInContext c2h=org.hibernate.tool.hbm2x.Cfg2HbmTool@18ce14a
[hibernatetool] 09:35:46,543 DEBUG TemplateHelper:149 - putInContext c2j=org.hibernate.tool.hbm2x.Cfg2JavaTool@1ae90c
[hibernatetool] 09:35:46,557 DEBUG TemplateHelper:149 - putInContext outputdir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,557 DEBUG TemplateHelper:149 - putInContext template_path=[Ljava.lang.String;@47a0d4
[hibernatetool] 09:35:46,558 DEBUG TemplateHelper:149 - putInContext java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
[hibernatetool] 09:35:46,558 DEBUG TemplateHelper:149 - putInContext hibernate.connection.password=root
[hibernatetool] 09:35:46,559 DEBUG TemplateHelper:149 - putInContext sun.boot.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386
[hibernatetool] 09:35:46,560 DEBUG TemplateHelper:149 - putInContext java.vm.version=1.5.0_05-b05
[hibernatetool] 09:35:46,560 DEBUG TemplateHelper:149 - putInContext ant.library.dir=/chameleon/public/ant/apache-ant-1.6.0/lib
[hibernatetool] 09:35:46,561 DEBUG TemplateHelper:149 - putInContext hibernate.connection.username=root
[hibernatetool] 09:35:46,561 DEBUG TemplateHelper:149 - putInContext java.vm.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,562 DEBUG TemplateHelper:149 - putInContext java.vendor.url=http://java.sun.com/
[hibernatetool] 09:35:46,563 DEBUG TemplateHelper:149 - putInContext path.separator=:
[hibernatetool] 09:35:46,563 DEBUG TemplateHelper:149 - putInContext java.vm.name=Java HotSpot(TM) Server VM
[hibernatetool] 09:35:46,564 DEBUG TemplateHelper:149 - putInContext file.encoding.pkg=sun.io
[hibernatetool] 09:35:46,564 DEBUG TemplateHelper:149 - putInContext user.country=US
[hibernatetool] 09:35:46,565 DEBUG TemplateHelper:149 - putInContext sun.os.patch.level=unknown
[hibernatetool] 09:35:46,565 DEBUG TemplateHelper:149 - putInContext java.vm.specification.name=Java Virtual Machine Specification
[hibernatetool] 09:35:46,566 DEBUG TemplateHelper:149 - putInContext user.dir=/home/dtkaczyk/ewks1/SchemaCompare/src
[hibernatetool] 09:35:46,567 DEBUG TemplateHelper:149 - putInContext java.runtime.version=1.5.0_05-b05
[hibernatetool] 09:35:46,567 DEBUG TemplateHelper:149 - putInContext java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
[hibernatetool] 09:35:46,568 DEBUG TemplateHelper:149 - putInContext java.endorsed.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/endorsed
[hibernatetool] 09:35:46,568 DEBUG TemplateHelper:149 - putInContext os.arch=i386
[hibernatetool] 09:35:46,569 DEBUG TemplateHelper:149 - putInContext java.io.tmpdir=/tmp
[hibernatetool] 09:35:46,570 DEBUG TemplateHelper:149 - putInContext line.separator=
[hibernatetool] 09:35:46,570 DEBUG TemplateHelper:149 - putInContext java.vm.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,571 DEBUG TemplateHelper:149 - putInContext os.name=Linux
[hibernatetool] 09:35:46,572 DEBUG TemplateHelper:149 - putInContext ant.home=/chameleon/public/ant/apache-ant-1.6.0
[hibernatetool] 09:35:46,572 DEBUG TemplateHelper:149 - putInContext sun.jnu.encoding=UTF-8
[hibernatetool] 09:35:46,573 DEBUG TemplateHelper:149 - putInContext java.library.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386/server:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i386:/mnt/chameleon/public/java/jdk1.5.0_05/jre/../lib/i386:/usr/lib/xulrunner-1.9:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/97/1/.cp
[hibernatetool] 09:35:46,574 DEBUG TemplateHelper:149 - putInContext jdk5=false
[hibernatetool] 09:35:46,574 DEBUG TemplateHelper:149 - putInContext java.specification.name=Java Platform API Specification
[hibernatetool] 09:35:46,575 DEBUG TemplateHelper:149 - putInContext java.class.version=49.0
[hibernatetool] 09:35:46,576 DEBUG TemplateHelper:149 - putInContext sun.management.compiler=HotSpot Server Compiler
[hibernatetool] 09:35:46,576 DEBUG TemplateHelper:149 - putInContext os.version=2.6.18-92.1.10.el5
[hibernatetool] 09:35:46,577 DEBUG TemplateHelper:149 - putInContext user.home=/home/dtkaczyk
[hibernatetool] 09:35:46,578 DEBUG TemplateHelper:149 - putInContext user.timezone=America/New_York
[hibernatetool] 09:35:46,579 DEBUG TemplateHelper:149 - putInContext java.awt.printerjob=sun.print.PSPrinterJob
[hibernatetool] 09:35:46,579 DEBUG TemplateHelper:149 - putInContext file.encoding=UTF-8
[hibernatetool] 09:35:46,580 DEBUG TemplateHelper:149 - putInContext java.specification.version=1.5
[hibernatetool] 09:35:46,585 DEBUG TemplateHelper:149 - putInContext sessionFactoryName=SessionFactory
[hibernatetool] 09:35:46,585 DEBUG TemplateHelper:149 - putInContext hibernate.connection.driver_class=com.mysql.jdbc.Driver
[hibernatetool] 09:35:46,586 DEBUG TemplateHelper:149 - putInContext user.name=dtkaczyk
[hibernatetool] 09:35:46,586 DEBUG TemplateHelper:149 - putInContext java.class.path=/chameleon/public/ant/apache-ant-1.6.0/lib/ant-antlr.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-bsf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-apache-resolver.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-logging.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-commons-net.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-icontract.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jai.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-bcel.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-log4j.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-oro.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jakarta-regexp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-javamail.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jdepend.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jmf.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-jsch.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-junit.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-launcher.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-netrexx.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-nodeps.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-starteam.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-stylebook.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-swing.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-trax.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-vaj.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-weblogic.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xalan2.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant-xslp.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/ant.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/junit-3.8.1.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xercesImpl.jar:/chameleon/public/ant/apache-ant-1.6.0/lib/xml-apis.jar:/home/dtkaczyk/eclipse/e1/eclipse/configuration/org.eclipse.osgi/bundles/484/1/.cp/lib/remoteAnt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/lib/tools.jar:/home/dtkaczyk/softeng/lib/xalan.jar:/home/dtkaczyk/softeng/lib/serializer.jar:/home/dtkaczyk/softeng/lib/xercesImpl.jar:/home/dtkaczyk/softeng/lib/xml-apis.jar:/home/dtkaczyk/softeng/lib/xsltc.jar:/home/dtkaczyk/eclipse/e1/eclipse/plugins/org.eclipse.swt.gtk.linux.x86_3.4.0.v3448f.jar
[hibernatetool] 09:35:46,587 DEBUG TemplateHelper:149 - putInContext hibernate.default_catalog=information_schema
[hibernatetool] 09:35:46,595 DEBUG TemplateHelper:149 - putInContext hibernate.bytecode.use_reflection_optimizer=false
[hibernatetool] 09:35:46,596 DEBUG TemplateHelper:149 - putInContext ejb3=false
[hibernatetool] 09:35:46,597 DEBUG TemplateHelper:149 - putInContext hibernate.show_sql=true
[hibernatetool] 09:35:46,597 DEBUG TemplateHelper:149 - putInContext java.vm.specification.version=1.0
[hibernatetool] 09:35:46,598 DEBUG TemplateHelper:149 - putInContext sun.arch.data.model=32
[hibernatetool] 09:35:46,599 DEBUG TemplateHelper:149 - putInContext java.home=/mnt/chameleon/public/java/jdk1.5.0_05/jre
[hibernatetool] 09:35:46,599 DEBUG TemplateHelper:149 - putInContext hibernate.connection.url=jdbc:mysql://localhost:3306/information_schema
[hibernatetool] 09:35:46,600 DEBUG TemplateHelper:149 - putInContext hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
[hibernatetool] 09:35:46,600 DEBUG TemplateHelper:149 - putInContext java.specification.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,601 DEBUG TemplateHelper:149 - putInContext user.language=en
[hibernatetool] 09:35:46,602 DEBUG TemplateHelper:149 - putInContext java.vm.info=mixed mode
[hibernatetool] 09:35:46,602 DEBUG TemplateHelper:149 - putInContext java.version=1.5.0_05
[hibernatetool] 09:35:46,603 DEBUG TemplateHelper:149 - putInContext java.ext.dirs=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/ext
[hibernatetool] 09:35:46,604 DEBUG TemplateHelper:149 - putInContext sun.boot.class.path=/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/rt.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/i18n.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/sunrsasign.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jsse.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/jce.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/lib/charsets.jar:/mnt/chameleon/public/java/jdk1.5.0_05/jre/classes
[hibernatetool] 09:35:46,606 DEBUG TemplateHelper:149 - putInContext java.vendor=Sun Microsystems Inc.
[hibernatetool] 09:35:46,606 DEBUG TemplateHelper:149 - putInContext file.separator=/
[hibernatetool] 09:35:46,607 DEBUG TemplateHelper:149 - putInContext java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
[hibernatetool] 09:35:46,607 DEBUG TemplateHelper:149 - putInContext sun.cpu.endian=little
[hibernatetool] 09:35:46,608 DEBUG TemplateHelper:149 - putInContext sun.io.unicode.encoding=UnicodeLittle
[hibernatetool] 09:35:46,608 DEBUG TemplateHelper:149 - putInContext sun.desktop=gnome
[hibernatetool] 09:35:46,609 DEBUG TemplateHelper:149 - putInContext sun.cpu.isalist=
[hibernatetool] 09:35:46,610 DEBUG TemplateHelper:149 - putInContext artifacts=org.hibernate.tool.hbm2x.ArtifactCollector@18a8ce2
[hibernatetool] 09:35:46,610 DEBUG TemplateHelper:149 - putInContext cfg=org.hibernate.cfg.JDBCMetaDataConfiguration@1ff92f5
<removeFromContext deleted for brevity!>
BUILD SUCCESSFUL
Total time: 3 seconds

max · **Posted:** Wed May 13, 2009 3:48 pm

We only pickup TABLE and VIEWs since system tables are not relevant or simply broken when it come to metadata.

You would have to change JDBCBinder/JDBCReader to include system tables.

dtkaczyk · **Joined:** Mon May 11, 2009 9:12 am **Posts:** 3

Thanks for the response.

I'm writing a database schema comparison utility that compares two live databases, so from my perspective the data contained in the system tables are very relevant as they contain the schema metadata that I'm comparing. I have found in the meantime, however, that this particular database is as you say "broken" from a physical database perspective. This database uses MyISAM and MEMORY storage engines neither of which support foreign key constraints. The tables also do not have primary keys defined. So, it looks like my hack is the way to go with this one. I reversed engineered the DDL using the MySQL Query Browser, hand edited them to include PKs and FKs, then created a "fake_information_schema" database that I can reverse engineer using hibernate. Then point my tool at the real information_schema database and all seems to be working pretty well. More work than I had anticipated and it will be prone to incompatibilities if the information_schema changes with future releases of the database engine, but it works.