apologies re Sybase/Oracle, I meant I got it working with that TIMESTAMP to
DATE change using Oracle. I first attempted on Sybase but I got a "boolean
type not found" error reported from Sybase, as they dont have a boolean
type. I ditched Sybase and I see we also using Oracle in house, so I
switched, but then got the TIMESTAMP error. After the DATE change, it
works. I have set the Oracle10g dialect in both cas.properties and the JPA
serviceRegistryDao in deployerConfigContext. Its very confusing to me as I
thought Hibernate would have some sort of type mapping stuff?
Here's my config:
<bean id="serviceRegistryDao"
class="org.jasig.cas.services.JpaServiceRegistryDaoImpl"
p:entityManagerFactory-ref="entityManagerFactory" />
<!-- This is the EntityManagerFactory configuration for Hibernate -->
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="jpaVendorAdapter">
<bean
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="generateDdl" value="true"/>
<property name="showSql" value="true" />
</bean>
</property>
<property name="jpaProperties">
<props>
<prop
key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
On 20 September 2012 01:34, Marvin Addison <[email protected]> wrote:
> > got it working, changed line 237 in JpaLockingStrategy from
> > @Temporal(TemporalType.TIMESTAMP) to @Temporal(TemporalType.DATE)
>
> I would expect the proper Hibernate dialect to handle timestamps
> correctly under the hood. I see lots of Sybase dialects listed at
>
> http://docs.jboss.org/hibernate/orm/4.1/javadocs/org/hibernate/dialect/package-summary.html
> .
> Have you tried them all?
>
> > Has this all been tested on Sybase by any chance?
>
> Not by any committer, but we're happy to accept volunteers that are
> willing to QA additional platforms.
>
> M
>
> --
> You are currently subscribed to [email protected] as:
> [email protected]
> To unsubscribe, change settings or access archives, see
> http://www.ja-sig.org/wiki/display/JSG/cas-user
>
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
