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 <[email protected]> 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 <[email protected]>
>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>
>
