You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Paul Copeland <te...@jotobjects.com> on 2009/03/17 00:11:41 UTC
Postgres supported versions
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
Re: Postgres supported versions
Posted by Paul Copeland <te...@jotobjects.com>.
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 <te...@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 <te...@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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>
>
>
Re: Postgres supported versions
Posted by Judes Tumuhairwe <ju...@gmail.com>.
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 <te...@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 <te...@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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>
>
Re: Postgres supported versions
Posted by Paul Copeland <te...@jotobjects.com>.
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 <te...@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
>>>
>>>
>>>
>>>
>
>
Re: Postgres supported versions
Posted by Judes Tumuhairwe <ju...@gmail.com>.
I'm using Postgres 8.2 with no problems.
Judes
On Mon, Mar 16, 2009 at 5:16 PM, Paul Copeland <te...@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
>>
>>
>>
>
Re: Postgres supported versions
Posted by Paul Copeland <te...@jotobjects.com>.
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
>
>