Hi Dmitry
What is your "jdbc/PostgreSQL" jdbc resource pointing too ?
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
>>
>>
>