CAS services registry status

[Sudirikku Mohanjith]

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
<scott.battaglia at gmail.com> wrote:
> Are you using the correct MySQL Dialect for Hibernate?
>
>
>
> On Thu, Feb 21, 2008 at 3:19 PM, Sudirikku Mohanjith <moha at mohanjith.net>
> 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 <mikek at ucr.edu> 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: cas-bounces at tp.its.yale.edu [mailto:cas-bounces at tp.its.yale.edu]
> 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
> > >  cas at tp.its.yale.edu
> > >  http://tp.its.yale.edu/mailman/listinfo/cas
> > >
> > >  _______________________________________________
> > >  Yale CAS mailing list
> > >  cas at tp.its.yale.edu
> > >  http://tp.its.yale.edu/mailman/listinfo/cas
> > >
> > _______________________________________________
> > Yale CAS mailing list
> > cas at tp.its.yale.edu
> > 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
>  cas at tp.its.yale.edu
>  http://tp.its.yale.edu/mailman/listinfo/cas
>
>