Re: Database configuration - DB2/400

Maurizio,

> Hi all,
> I'm new to the Keel framework, I just discovered it and find it very 
> interesting.
> I'm attempting to get Keel to work on an IBM iseries. I've seen 
> hibernate supports also this DB2 version, so I'd like to setup a 
> configuration for it. In the wiki it says to ask the mailing list 
> for help, and actually I do need help, as I can't find out how many 
> and which configuration files are involved. Can anyone address me to 
> the right information? Or better lead me through the personalized 
> configuration process? Thanks very much in advance Ciao Maurizio 

Primarily, you have to create a config file following the pattern in
svc-persist-base/sample-conf. The <jdbc>...</jdbc> config needs to be done
specific to the driver you will use (The @... parameters are replaced with
properties in the ant.properties file).  Next is the <default-persistent>
configuration in the same file, which Aleks will probably have to help with.
The actual SQL-dialect mapping is done in Java, see in
svc-persist-base/src/java in package org.keel.services.persist.base.  I'd
start with one of the existing dialects, or even with JDBCDatabaseType.java
and extend as needed.  The last piece is adding type-map entries to map
between Keel data types and the SQL data-types supported by the JDBC driver.

HTH,
Shash