Hi all,
I am trying to set up a new Generator in hibernate so I can use Oracle like sequences in mySQL. (I personal feel identity columns are bad).

So I think I can set up a SequenceStlyeGenerator, point it at my sequence table and its column, and off we go.

The only thing is, how do i do this in a Spring applicationContext.xml, as I am using Spring.

Is it something liks:
<bean id="sessionFactory" blah>
<property name="Generator" class ="org.hibernate.id.enhanced.SequenceStyleGenerator">
<props>
<property key="hibernate.sequence_param">value</property>
<property key="hibernate.initial_param">value</property>
<property key="hibernate.increment_param">value</property>
<property key="hibernate.value_column_param">value</property>
</props>
</property>
</bean>

then in the mapping file:
<id name="OID" column="OID">
<generator class="org.hibernate.id.enhanced.SequenceStyleGenerator"/>
</id>

Thanks

G

Have decided that it should be the following in the mapping file:
<id name="OID" column="OID">
<generator class="org.hibernate.id.enhanced.SequenceStyleGenerator">
<param name="sequence_name">ev_sequence</param>
<param name="initial_value">-9223372036854775808</param>
<param name="increment_size">1</param>
<param name="value_column">CurrentValue</param>
</generator>
</id>

However, it seems that the SequenceStyle generator wont accept a long as its initial value???

org.hibernate.MappingException: could not instantiate id generator
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:98)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:192)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1143)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:431)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:254)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:144)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:163)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:281)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:241)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1307)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1571)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1580)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1560)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NumberFormatException: For input string: "-9223372036854775808"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:459)

You want to use something like this:

<generator class="org.hibernate.id.enhanced.SequenceStyleGenerator">
<param name="table">table</param>
<param name="sequence">sequence name</param>
<param name="initial">-9223372036854775808</param>
<param name="increment">1</param>
<param name="column">Column name</param>
</generator>

Can not believe I will have to put this in each mapping file.

it works so far as it loads, now to get it to work on inserts.

G

deleted