db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin van den Bemt <mll...@mvdb.net>
Subject Re: DDLUtils and Informix (how to write it)
Date Sat, 18 Mar 2006 10:30:46 GMT
Added to the wiki :)

Mvgr,
Martin

Thomas Dudziak wrote:
> On 3/16/06, Valicek Arnost <arnost.valicek@turboconsult.cz> wrote:
> 
> 
>>I found this interesting tool DDLUtils, but it isn't supporting Inforxmix database,
so I'd like to create support for Informix.
> 
> 
> Yes, because we don't currently have access to an Informix server.
> However I just saw that it is possible to download a trial version of
> Informix Dynamic Server Express Edition, so I might give it a go.
> 
> 
>>After looking to souce code, it seems, that I shoud implement some classes in org.apache.ddlutils.platform.[informix]
package.
>>
>>Is there any documentation which describes what is need to support new database? Or
should I learn it from implementation for other databases :)
> 
> 
> The steps that I take to implement a new platform are as follows:
> 
> * Create a package, e.g. org.apache.ddlutils.platform.informix, and
> create a platform class (InformixPlatform) in it that inherits from
> PlatformImplBase
> 
> * Add the jdbc driver classname and jdbc subprotocol as constants to
> the platform class
> 
> * Register the platform class in PlatformFactory (including against
> the driver classname and the subprotocol)
> 
> * Create in src/test a jdbc.properties.informix file with the
> appropriate JDBC settings
> 
> * Get the datatype tests to run with the these tests, i.e. that they
> really access the database (though they'll most likely fail)
> 
> * Add a model reader and if necessary, a sql builder implementation to
> the package
> 
> * Register the native type mappings in the platform, and override
> methods in the model reader/sql builder as needed so that the datatype
> tests run successfully
> 
> * Override methods in the model reader and sql builder as needed so
> that the constraint and alteration tests run successfully
> 
> Tom
> 
> 

Mime
View raw message