Thanks. Your persistence.xml settings are a great help. I'm using
Postgres 8.2.13 because other applications have not yet moved to 8.3.
However, I decided to use the most current Postgres JDBC driver that is
supposed to be compatible with Postgres versions 7.2 and later -
postgresql-8.3-604.jdbc3.jar -
More info here - http://jdbc.postgresql.org/download.html
On 3/20/2009 5:57 AM, Judes Tumuhairwe wrote:
I'm using the jdbc driver in the jdbc folder of my postgres 8.2 install
[C:\EnterpriseDB\Postgres\8.2\jdbc]. There are 5 but I picked
postgresql-8.2-506.jdbc2ee. Yes, I'm using version 1.2.
About the DBDictonary, this is my configuration in my <properties> tag in
persistence.xml in my dev environment
<!-- BEGING PROPERTIES FOR OpenJPA -->
<property name="openjpa.Log" value="SQL=TRACE, JDBC=TRACE,
DefaultLevel=TRACE, Tool=INFO"/>
<property name="openjpa.ConnectionFactoryProperties"
value="PrettyPrint=true, PrettyPrintLineLength=72"/>
<property name="openjpa.TransactionMode" value="managed" />
<property name="openjpa.RetryClassRegistration" value="true" />
*<property name="openjpa.jdbc.DBDictionary"
value="org.apache.openjpa.jdbc.sql.PostgresDictionary(SupportsDeferredConstraints=false)"/>
*
<!--
<property name="openjpa.ConnectionDriverName"
value="org.apache.commons.dbcp.BasicDataSource"/>
-->
* <property name="openjpa.ConnectionDriverName"
value="org.postgresql.Driver"/>*
<property name="openjpa.ConnectionURL"
value="jdbc:postgresql://localhost:5432/myDBname"/>
<property name="openjpa.ConnectionUserName" value="xxxxx"/>
<property name="openjpa.ConnectionPassword" value="xxxxxx"/>
<!-- END PROPERTIES FOR OpenJPA -->
Judes
On Tue, Mar 17, 2009 at 9:27 AM, Paul Copeland <t...@jotobjects.com> wrote:
Thanks. Are you using OpenJPA 1.2? What postgres JDBC driver are you
using?
From the manual it looks like by default the property
|openjpa.jdbc.DBDictionary will be set from the value of property
||openjpa.ConnectionDriverName. I'm just wondering if these default settings
are correct for Postgres 8.2x and 8.3x since the openJPA manual only
mentions support for Postgres 8.1.5. Is there a sure way to answer that
question?
- Paul
|
On 3/16/2009 7:07 PM, Judes Tumuhairwe wrote:
I'm using Postgres 8.2 with no problems.
Judes
On Mon, Mar 16, 2009 at 5:16 PM, Paul Copeland <t...@jotobjects.com>
wrote:
I should add that I am using openJPA 1.2 (as it appears to be the stable
version and this project is intended for production use).
My question is how to tell if openJPA 1.2 supports Postgres 8.2.13.
On 3/16/2009 4:11 PM, Paul Copeland wrote:
I would like to use Postgres 8.2 (latest 8.2 minor version is 8.2.13).
The openJPA manual lists Postgres 8.1.5 as a supported database in
Appendix 2.
The openJPA reference guide section 4 Database Support says "OpenJPA can
take advantage of any JDBC 2.x compliant driver" and then points to the
table that list Postgres 8.1.5 as an "offically supported database".
How do I determine if Postgres 8.2.13 is going to work "out of the box"
with openJPA?
TIA - Paul
