JPA with postgres database

[Former Member]

Hello guys.

I am trying to write an EJB project with JPA facet. Database is postgres 8.2. SAP JPA implementatiom uses incorrect SQL syntax with that DB. Can I add some vendor-specific properties to my persistence.xml? Are there any other ways to solve that peoblem?

Thanks in advance.

[adrian_goerler · Accepted solution]

Hi Andrey,

Postgres in not known to SAP JPA. In case of a unknown database vendor, SAP JPA generates generic ISO/IEC compliant SQL, which works in many cases but not always.

Moreover, an application cannot define a vendor-specific SQL dialect.

Which kind of issues are you facing? If only some JPQL queries are failing, you might have a chance to replace them with native queries. If the issues are more fundamental, it will be difficult, though.

I hope this helps.

-Adrian

[Former Member · Accepted solution]

Thanks. Do you know what databases are supported by SAP JPA? I have installed postgres on my developer machine only for test - I can use any db on production.

[adrian_goerler · Accepted solution]

Hi,

fully supported are

MaxDb (aka SAPDB),

Microsoft SQL Server,

Oracle,

DB2 for z/OS,

DB2 for i5/OS and

DB2 for Linux, Unix, Windows.

-Adrian

[Former Member · Accepted solution]

Thanks.

What about versions of Oracle and Ms sql server? Which are recommended by SAP?

[Vlado · Accepted solution]

Oracle 10.2

SQL Server 2005

For more detailed information please refer to the [PAM|http://service.sap.com/~form/handler?_EVENT=DISP_NEW&_APP=00200682500000001303&00200682500000002804=01200615320900001418].

HTH!

\-- Vladimir