Hi Scott,
Thanks for the quick turnaround.
I think I have the correct MySQL Dialect,
org.hibernate.dialect.MySQLDialect. Hacking at the problem I altered
the schema, such that all BIT fields are converted to TINYINT.
Bellow is a part of the deployerConfigContext.xml:
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="service_registry_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.MySQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
On Fri, Feb 22, 2008 at 1:55 AM, Scott Battaglia
<[EMAIL PROTECTED]> wrote:
> Are you using the correct MySQL Dialect for Hibernate?
>
>
>
> On Thu, Feb 21, 2008 at 3:19 PM, Sudirikku Mohanjith <[EMAIL PROTECTED]>
> wrote:
> > Hi Mike,
> > Thanks for the quick reply,
> >
> > In my case hibernate.hbm2ddl.auto is set to update,
> >
> > <prop key="hibernate.hbm2ddl.auto">update</prop>
> >
> > Also if it was set to create-drop, none of the records will persist,
> > but it's only the statuses that doesn't persist.
> >
> > My gut feeling is it is something to do with BIT datatype that is used
> > for boolean fields.
> >
> > Cheers,
> > Mohanjith
> >
> >
> >
> >
> > On Fri, Feb 22, 2008 at 1:27 AM, Mike Kennedy <[EMAIL PROTECTED]> wrote:
> > > Mohanjith,
> > >
> > > I think its because you probably have this property set in the
> > > entityManagerFactory bean:
> > >
> > > <prop key="hibernate.hbm2ddl.auto">create-drop</prop>
> > >
> > > I think if you remove this line once the database is created you should
> be
> > > ok.
> > >
> > > Mike
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On
> > > Behalf Of Sudirikku Mohanjith
> > > Sent: Thursday, February 21, 2008 11:35 AM
> > > To: Yale CAS mailing list
> > > Subject: CAS services registry status
> > >
> > > Hi,
> > > In my CAS deployment I'm using ServiceRegistry DAO based on MySQL and
> > > Hibernate, as explained in
> > > http://www.ja-sig.org/wiki/display/CASUM/Configuring. However the
> > > status of the services in the registry is always reset everytime I
> > > restart the application server.
> > >
> > > Any help will be appreciated.
> > >
> > > Cheers,
> > > Mohanjith
> > > _______________________________________________
> > > Yale CAS mailing list
> > > [email protected]
> > > http://tp.its.yale.edu/mailman/listinfo/cas
> > >
> > > _______________________________________________
> > > Yale CAS mailing list
> > > [email protected]
> > > http://tp.its.yale.edu/mailman/listinfo/cas
> > >
> > _______________________________________________
> > Yale CAS mailing list
> > [email protected]
> > http://tp.its.yale.edu/mailman/listinfo/cas
> >
>
>
>
> --
> -Scott Battaglia
> PGP Public Key Id: 0x383733AA
> LinkedIn: http://www.linkedin.com/in/scottbattaglia
> _______________________________________________
> Yale CAS mailing list
> [email protected]
> http://tp.its.yale.edu/mailman/listinfo/cas
>
>
_______________________________________________
Yale CAS mailing list
[email protected]
http://tp.its.yale.edu/mailman/listinfo/cas
