Schemacrawler and DB2

Hi !
>
I'm currently trying to read out ddl-structures from a db2-database
with schemacrawler (http://schemacrawler.sourceforge.net/)
but without success. Some people in this newsgroup recommended this
tool for analyzing and diff-ing ddl-structures of databases.
>
My configuration looks like this:
---
....
vk1xap04.host=127.0.0.1
vk1xap04.port=60020
vk1xap04.database=vk1xap04
vk1xap04.schemapattern=%
vk1xap04.user=vk1xap04
vk1xap04.password=<removed>
vk1xap04.driver=com.ibm.db2.jcc.DB2Driver
vk1xap04.url=jdbc:db2://${host}:${port}
...
---
>
I got the following error-message:
--
$ java -cp $CLASSPATH -jar `ls -1 schemacrawler-*.jar` \
-command=maximum_schema \
-outputformat=text \
-g /application/shared/install/schemacrawler/current/schemacrawler.config.properties \
-connection=vk1xap04
>
exception in thread "main" dbconnector.datasource.PropertiesDataSourceExcepti on: Driver class not found - com.ibm.db2.jcc.DB2Driver
at dbconnector.datasource.PropertiesDataSource.constr uctPropertiesDataSource(PropertiesDataSource.java: 202)
at dbconnector.datasource.PropertiesDataSource.<init> (PropertiesDataSource.java:153)
at dbconnector.Main.createDataSource(Main.java:215)
at schemacrawler.Main.doMain(Main.java:117)
at schemacrawler.Main.main(Main.java:82)
Caused by: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 06)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 51)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at dbconnector.datasource.PropertiesDataSource.constr uctPropertiesDataSource(PropertiesDataSource.java: 197)
... 4 more
--
>
This looks like a simple classpath problem - but the class is resolvable:
---
# positive test
java com.ibm.db2.jcc.DB2Driver
Exception in thread "main" java.lang.NoSuchMethodError: main
# negative test
java com.ibm.db2.jcc.DB2DriverXXXXXXXXXXX
Exception in thread "main" java.lang.NoClassDefFoundError: com/ibm/db2/jcc/DB2DriverXXXXXXXXXXX
---
>
Any ideas ?
>
Is there a another free tool which eases comparison of databases ?
>
Best regards
>
Marc Schoechlin

Your problem is shown in the first line of the error message - the type
4 jcc driver wasn't found.
>
Make sure that the *.jcc.jar file appears in your CLASSPATH. On my
system it's located at:
/home/db2inst1/sqllib/java/db2jcc.jar

Phil Sherman <psherman@ameritech.netschrieb:>
This file was already in my classpath (you see this in the test
beyond) - but it was not enough to
set the classpath varaible or to add the classpath with
"java -cp jar1.jar:jar2.jar" ...
>>
I tried an alternate way:
----
-------
CLASSPATH=/opt/IBM/db2/V8.1/java/db2java.zip:/opt/IBM/db2/V8.1/java/Common.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2fs.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2jcc.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2qgjava.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2policy.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2jcc_license_cisuz.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2jcc_javax.jar
CLASSPATH=$CLASSPATH:/opt/IBM/db2/V8.1/java/db2jcc_license_cu.jar
export CLASSPATH
>
java -cp `ls -1 schemacrawler-*.jar`:$CLASSPATH schemacrawler.Main \
-command=maximum_schema \
-outputformat=text \
-g /application/shared/install/schemacrawler/schemacrawler.config.properties \
-connection=$1
-------
>
Now i ran into another problem :-)
>
--- my config --------------------------------------------
vk1xap04.host=127.0.0.1
vk1xap04.port=60020
vk1xap04.database=vk1xap04
vk1xap04.schemapattern=vk1xap04
vk1xap04.user=vk1xap04
vk1xap04.password=<removed>
vk1xap04.driver=com.ibm.db2.jcc.DB2Driver
vk1xap04.url=jdbc:db2://${host}:${port}/${database}
---------------------------------------------------------
>
- error output ----------------------------------------------
>
-- database product: DB2/SUN SQL08024
-- driver: com.ibm.db2.jcc.DB2Driver - IBM DB2 JDBC Universal Driver
Architecture 2.8.46
-- connection: jdbc:db2://127.0.0.1:60020/vk1xap04
-- schema pattern: vk1xap04
------------------------------------------------------------------------
>
>
AllProceduresAreCallable false
AllTablesAreSelectable false
CatalogSeparator .
Exception in thread "main" java.lang.NullPointerException
at
schemacrawler.tools.schematext.BaseSchemaTextForma tter.handle(BaseSchemaTextFormatter.java:160)
at
schemacrawler.crawl.SchemaCrawler.crawlDatabaseInf o(SchemaCrawler.java:186)
at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCraw ler.java:131)
at
schemacrawler.tools.ToolsExecutor.execute(ToolsExe cutor.java:126)
at schemacrawler.Main.doMain(Main.java:124)
at schemacrawler.Main.main(Main.java:82)
--------------------------------------------------------------------------
>
I´m have no idea how to solve this ....
>
Best regards
>
Marc Schoechlin
>
----
>