Thread:
 Middlegen and DB2 !!! 
 ChrisR   11 Mar 2004, 16:15 
 Re: Middlegen and DB2 !!! 
 cpalit   18 Mar 2004, 01:01 

Comment
Prev. thread 
 Next thread
 
Prev. posting 
 Next posting
From: ChrisR (11 Mar 2004, 16:15) Replies: 1, Views: 41275
Subject: Middlegen and DB2 !!!
ernani,

   Your \config\database\db2.xml file should look something like the 
following. I have DB2 installed to c:\sqllib.


   <!-- 
=================================================================== -->
   <!-- ant properties/targets for IBM 
DB2                                   -->
   <!-- note: this is not a proper xml file (there is no root 
element)      -->
   <!--       it is intended to be imported from a *real* xml 
file          -->
   <!-- 
=================================================================== -->

   <property name="sqllib.home"                    value="C:/sqllib"/>
   <property name="database.script.file"           
value="${src.dir}/sql/${name}-db2.sql"/>
   <property name="database.driver.file"           
value="${sqllib.home}/java/db2java.zip"/>
   <property name="database.driver.classpath"      
value="${database.driver.file}"/>
   <property name="database.driver"                
value="COM.ibm.db2.jdbc.app.DB2Driver"/>
   <property name="database.url"                   
value="jdbc:db2:SAMPLE"/>
   <property name="database.userid"                value="userid"/>
   <property name="database.password"              value="password"/>
   <property name="database.schema"                value="CLEX"/>
   <property name="database.catalog"               value=""/>


Your build.xml should contain the following...

<!DOCTYPE project [
    <!ENTITY database SYSTEM "file:./config/database/db2.xml">
]>

See if those work for you

Cheers
Chris
Prev. thread 
 Next thread
 
Prev. posting 
 Next posting
© Copyright 2006, Red Hat Middleware, LLC. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc. [Privacy Policy]