Hi Dmitry
All the platforms that are part of glassfish are present under
oracle/toplink/essentials/platform/database directory. If you do not
find PostgreSQLPlatform there then the build that you are using is
pretty old. You should consider upgrading to the latest build. The
support for postgresql database was added to glassfish in the first week
of February 2006.
Thanks
Pramod
Dmitry Mozheyko wrote:
> I find good errors:
>
> [#|2006-04-03T13:38:34.435+0400|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=httpWorkerThread-4848-3;|[TopLink Info]: 2006.04.03 01:38:34.435--Not able to detect platform for vendor name [PostgreSQL]. Defaulting to [oracle.toplink.essentials.platform.database.DatabasePlatform]. The database dialect used may not match with the database you are using. Please explicitly provide a platform using property toplink.platform.class.name.
> |#]
>
> I found defined platforms in ${appserver}/lib/toplink-essentials.jar, but no postgresql platform defined in this file.
>
> How to create this definition for PostgreSQL?
>
>
> -----Original Message-----
> From: Pramod Gopinath <Pramod.Gopinath_at_Sun.COM>
> To: persistence_at_glassfish.dev.java.net
> Date: Tue, 21 Mar 2006 13:30:57 -0800
> Subject: Re: How to change SQL-statements for Persistence Unit
>
>
>> Hi Dmitry
>> The entries for PostgreSQLPool that you have provided do not seem to
>> be correct. Can you send out these pool entries as they appear in your
>> domain.xml associated with your server.
>>
>> The entries should be pointing to a valid postgresql database. Again my
>> suspicion is that the jdbc/PostgreSQL jdbc resource is not configured
>> correctly.
>>
>> Let me explain w.r.t the postgres connection that I have set up here :
>>
>>
>> <resources>
>> <jdbc-resource enabled="true" jndi-name="jdbc/PostgreSQL"
>> object-type="user" pool-name="PostgresPool"/>
>> ....
>> <jdbc-connection-pool allow-non-component-callers="false"
>> connection-validation-method="auto-commit"
>> datasource-classname="org.postgresql.ds.PGSimpleDataSource"
>> fail-all-connections="false" idle-timeout-in-seconds="300"
>> is-connection-validation-required="false"
>> is-isolation-level-guaranteed="false" max-pool-size="32"
>> max-wait-time-in-millis="60000" name="PostgresPool"
>> non-transactional-connections="false" pool-resize-quantity="2"
>> res-type="javax.sql.DataSource" steady-pool-size="8">
>> <property name="PortNumber" value="5432"/>
>> <property name="Password" value="postgres"/>
>> <property name="User" value="postgres"/>
>> <property name="serverName" value="postgres-machine-name"/>
>> <property name="DatabaseName" value="test"/>
>> </jdbc-connection-pool>
>> ....
>> </resources>
>>
>> I have copied the postgres client jar -
>> "postgresql-8.2dev-500.jdbc3.jar" into the application server lib
>> directory and restarted the machine.
>>
>> The server works correctly i.e it connects to the database and also
>> creates the tables with the correct database field types.
>>
>> Thanks
>> Pramod
>>
>>
>>
>> Dmitry Mozheyko wrote:
>>
>>> -----Original Message-----
>>> From: Pramod Gopinath <Pramod.Gopinath_at_Sun.COM>
>>> To: persistence_at_glassfish.dev.java.net
>>> Date: Mon, 20 Mar 2006 10:33:46 -0800
>>> Subject: Re: How to change SQL-statements for Persistence Unit
>>>
>>>
>>>
>>>> Hi Dmitry
>>>> What is your "jdbc/PostgreSQL" jdbc resource pointing too ?
>>>>
>>>>
>>> PostgreSQLPool - no special information about Postgres.
>>> Filled properties:
>>> ServerName
>>> PortNumber
>>> DatabaseName
>>> user
>>> password
>>> defaultAutoCommit
>>>
>>>
>>>
>>>> I am interested to know the jdbc connection pool that is referenced by
>>>> this jdbc/PostgreSQL resource. We use the jdbc connection information to
>>>> to autodetect the database platform. Based on the error messages that
>>>> you have reported it seems that the jdbc resource is not currently
>>>> pointing to postgresql. Hence the datatypes that are created are wrong
>>>> and that eventually leads to the error that is being reported from the
>>>> database.
>>>>
>>>> The jdbc connection pool + jdbc resource should be configured to
>>>> correctly point to the database and then everything should properly. At
>>>> this point of time there are no known issues in this area.
>>>>
>>>> Thanks
>>>> Pramod
>>>>
>>>>
>>>> Sanjeeb Kumar Sahoo wrote:
>>>>
>>>>
>>>>> Hi Dmitry,
>>>>>
>>>>> Your persistence.xml looks perfect.
>>>>>
>>>>> Pramod,
>>>>> Is Dmitry's issue a known issue?
>>>>>
>>>>> Thanks,
>>>>> Sahoo
>>>>> Dmitry Mozheyko wrote:
>>>>>
>>>>>
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Sanjeeb Kumar Sahoo <Sanjeeb.Sahoo_at_Sun.COM>
>>>>>> To: persistence_at_glassfish.dev.java.net
>>>>>> Date: Fri, 17 Mar 2006 17:49:48 +0530
>>>>>> Subject: Re: How to change SQL-statements for Persistence Unit
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Dmitry Mozheyko wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>> Did you specify any platform in you persistence.xml? The code
>>>>>>>>> tries to autodetect the database type, but if you specify it
>>>>>>>>> explicitly, your
>>>>>>>>> value will be used instead.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> Where i can find docs, examples about this file?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>> https://glassfish.dev.java.net/javaee5/persistence/entity-persistence-support.html#persistence.xml
>>>>>>>
>>>>>>>
>>>>>>> Can you send contents of your persistence.xml? Ideally, you don't
>>>>>>> have to use any special property to inform the runtime that you are
>>>>>>> using Postgress. It should be automatically detected for you.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Sahoo
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> Content of my persistence.xml:
>>>>>>
>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>> <persistence xmlns="http://java.sun.com/xml/ns/persistence">
>>>>>> <persistence-unit name="em" transaction-type="JTA">
>>>>>> <jta-data-source>jdbc/PostgreSQL</jta-data-source>
>>>>>> <properties>
>>>>>> <property name="ddl-generation" value="createtables"/>
>>>>>> </properties>
>>>>>> </persistence-unit>
>>>>>> </persistence>
>>>>>>
>>>>>> "jdbc/PostgreSQL" - jndi name of my jdbc-resource.
>>>>>>
>>>>>> Thanks, Dmitry
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>
>>