persistence@glassfish.java.net

Re: [Code Review]Updating GlassFish to use PFD version of persistence spi

From: Lance J. Andersen <Lance.Andersen_at_Sun.COM>
Date: Tue, 31 Jan 2006 16:10:36 -0500

It looks like you are trying to insert a timestamp into a date column.

If you use the Date escape sequence

{d "yyyy-mm-dd'} you will have better success.

Timestamp and date are different datatypes

scott hutinger wrote:

> I don't know all the specifics (version of derby, schema etc...), but
> the following says a bit.
> http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
> which might? help?
> scott
>
> Sanjeeb Kumar Sahoo wrote:
>
>> Hi Tom,
>>
>> I am running tests against Derby. I got the following result:
>> [junit] Running
>> oracle.toplink.essentials.testing.tests.FullRegressionTestSuite
>> [junit] Tests run: 82, Failures: 0, Errors: 8, Time elapsed:
>> 60.336 sec
>> [junit] Test
>> oracle.toplink.essentials.testing.tests.FullRegressionTestSuite FAILED
>>
>> Tests fail for following reasons:
>> Internal Exception: org.apache.derby.client.am.SqlException: Columns
>> of type 'DATE' cannot hold values of type 'TIMESTAMP'. Error Code: -1
>> Call:INSERT INTO CMP3_EMPLOYEE (EMP_ID, F_NAME, L_NAME, VERSION,
>> START_DATE, END_DATE, ADDR_ID, manager_EMP_ID) VALUES (102, 'Jill',
>> 'May', 1,
>> {ts '1895-01-01 00:00:00.0'}, NULL, 10, NULL)
>>
>> *OR*
>>
>> Internal Exception: org.apache.derby.client.am.SqlException: 'TRIM'
>> is not recognized as a function or procedure.Error Code: -1
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE
>> (TRIM(NAME) = 'tem')
>>
>> My build.properties look as follows:
>> jdbc.driver.jar=/home/ss141213/ROOT/WS/gf/publish/glassfish/derby/lib/derbyclient.jar
>>
>> db.driver=org.apache.derby.jdbc.ClientDriver
>> db.url=jdbc:derby://localhost:1527/sun-appserv-samples
>> db.user=APP
>> db.pwd=APP
>> tl.platform=oracle.toplink.essentials.platform.database.DerbyPlatform
>>
>> db.type=true
>> result.file=testresults
>> junit.location=/home/ss141213/ROOT/WS/20051028/glassfish/appserv-tests/lib/junit.jar
>>
>>
>> ## component defined properties.
>> src.dir=src/java
>> component.classes.dir=build
>> maven.netbeans.exec.build=build
>>
>> Am I doing anything wrong here?
>>
>> Thanks,
>> Sahoo
>>
>> Tom Ware wrote:
>>
>>> Hi Sahoo,
>>>
>>> That changes look good.
>>>
>>> Please ensure the entity-persistence tests pass before checking in.
>>>
>>> Thanks,
>>> Tom
>>>
>>> Sanjeeb Kumar Sahoo wrote:
>>>
>>>> Hi Tom,
>>>>
>>>> Attached here with are the changes. I have done a clean build.
>>>> Please review the following changes include:
>>>>
>>>> persistence-api/src/java/javax/persistence/spi/PersistenceUnitInfo.java:
>>>>
>>>> It now uses ClassTransformer.
>>>> getTempClassLoader is renamed as getNewTempClassLoader.
>>>> related javadoc updates. It has ripple effect on entity-persistence
>>>> module. So I changed them as well.
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/ejb/cmp3/EntityManagerFactoryProvider.java
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/ejb/cmp3/persistence/PersistenceUnitInfo.java
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/EntityManagerSetupImpl.java
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/internal/ejb/cmp3/JavaSECMPInitializer.java
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/internal/weaving/TopLinkWeaver.java
>>>>
>>>> entity-persistence/src/java/oracle/toplink/essentials/internal/weaving/TransformerFactory.java
>>>>
>>>>
>>>> Mitesh,
>>>>
>>>> would you mind reviewing the following changes:
>>>>
>>>> appserv-core/src/java/com/sun/enterprise/loader/EJBClassLoader.java
>>>> appserv-core/src/java/com/sun/enterprise/loader/InstrumentableClassLoader.java
>>>>
>>>> appserv-core/src/java/com/sun/enterprise/server/PersistenceUnitInfoImpl.java
>>>>
>>>> appserv-core/src/java/com/sun/enterprise/web/WebModuleListener.java
>>>>
>>>> To avoid conflicts, I would like to check them in ASAP, preferrably
>>>> tonight (my time). So I will appreciate a faster turn around.
>>>>
>>>> Thanks,
>>>> Sahoo
>>>>
>>>>
>>>
>>