HiRDB Support

Description

I would like to contribute with a dialect for HiRDB, Hitachi's RDBMS.
(For more information, please see http://www.hitachi.co.jp/Prod/comp/soft1/global/prod/hirdb/)

I added 4 classes and slightly modified 2 existing classes as shown below. Please look at the documentation at the top of the patch for explanations.
org.hibernate.dialect.HiRDBDialect (added)
org.hibernate.dialect.UserFuncDeclParser (added)
org.hibernate.dialect.DialectFactory (modified)
org.hibernate.dialect.function.AnsiTrimEmulationFunction (modified)
org.hibernate.dialect.function.AnsiTrimEmulationFunctionWithTrimstrs (added)
org.hibernate.dialect.function.TypeQualifiedSQLFunction (added)

You may think this code is relatively large as a dialect. It is because I also implemented user-defined function support. As HiRDB requires '?' parameters to be qualified by 'as <type>' in user-defined function invocations, I made a parser for the type declarations that the user specified in the properties file, and a renderer for the type qualifier. See javadoc comments of HiRDBDialect and UserFuncDeclParser for more details.

This patch is created on Hibernate 3.2.5.ga and tested on HiRDB V8 with Type4 JDBC Driver. The example configuration for HiRDB is shown below:
hibernate.dialect org.hibernate.dialect.HiRDBDialect
hibernate.connection.driver_class JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver
hibernate.connection.url jdbc:hitachi:hirdb://DBID=@HIRDBENVGRP=C:/hirdb.ini
hibernate.connection.username hitachi
hibernate.connection.password hitachi

Environment

3.2.5 + HiRDB V8 + Type4 JDBC Driver

Activity

Show:
Tomoto Shimizu Washio
September 4, 2008, 2:57 PM

Please let me know if there are any problems to incorporate this feature. I would be happy to fix them. Thanks.

Tomoto Shimizu Washio
September 5, 2008, 5:40 AM

The link to the HiRDB page I have written above may bring you to a wrong page because of the trailing ')'. Please click below instead.

http://www.hitachi.co.jp/Prod/comp/soft1/global/prod/hirdb/

Sorry for bothering you.

Tomoto Shimizu Washio
September 12, 2008, 6:02 AM

Congratulations on 3.3.1 GA release. I'll modify the patch for that version and post it along with the complete test report hoping it makes things a bit easier. Thanks for your hard work.

Assignee

Unassigned

Reporter

Tomoto Shimizu Washio

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major