Access a new type of database with openJPA

["Qiu, Damon" <da...@sap.com>]

Dear OpenJPA colleagues,

This is Damon from SAP Business One team. Currently I want use OpenJPA as OR Mapping framework in our project to support a new type of database(SAP HANA). In document section 4, I see user can plug a dictionary in OpenJPA to support a new database.

I have tried several times, but always failed. Could you please give me more detail configuration steps or guidelines? Thanks in advance.

Best Regards,
Damon Qiu

Remote Support Platform & Lifecycle Management & HANA | SAP Business One | damon.qiu@sap.com<ma...@sap.com> | +86 21 6030 6031

Re: Access a new type of database with openJPA

[Kevin Sutter <kw...@gmail.com>]

Hi,
I would assume that SAP HANA is pretty close to some other existing
database as far as JDBC and SQL support is concerned -- maybe Derby, DB2,
or Oracle?  I would start with one of those and extend your own
"HanaDictionary" class.  Or, you could always start by extending the base
DBDictionary class and then modify it as necessary for the proper Hana
support [1].

After you have created this dictionary, then you can plug this into the
architecture via the openjpa.jdbc.DBDictionary property like this [2][3]:

<property name="openjpa.jdbc.DBDictionary" value="my.project.HanaDictionary"/>

If you want to go a step further, you could also consider contributing this
back to the Apache OpenJPA project and then modify the OpenJPA code to
define an alias for this dictionary.  This way, other future users could
take advantage of your efforts and they could configure it as such:

<property name="openjpa.jdbc.DBDictionary" value="hana"/>

Hope this helps,
Kevin

[1]
http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_dbsetup_dbsupport
[2]
http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#openjpa.jdbc.DBDictionary
[3]
http://openjpa.apache.org/builds/latest/docs/docbook/manual.html#ref_guide_conf_plugins


On Mon, Apr 9, 2012 at 9:56 PM, Qiu, Damon <da...@sap.com> wrote:

> Dear OpenJPA colleagues,
>
> This is Damon from SAP Business One team. Currently I want use OpenJPA as
> OR Mapping framework in our project to support a new type of database(SAP
> HANA). In document section 4, I see user can plug a dictionary in OpenJPA
> to support a new database.
>
> I have tried several times, but always failed. Could you please give me
> more detail configuration steps or guidelines? Thanks in advance.
>
> Best Regards,
> Damon Qiu
>
> Remote Support Platform & Lifecycle Management & HANA | SAP Business One |
> damon.qiu@sap.com<ma...@sap.com> | +86 21 6030 6031
>
>