problems with ms sql
max522over Sep 21, 2006 6:06 PMcan some one tell me how to do this. I'm trying to bulk load into Ms Sql 2000 and I need to execute this sql statement
Query setIdentity = entityManager.createNativeQuery("SET IDENTITY_INSERT AssignmentType ON"); setIdentity.executeUpdate();
16:59:31,500 WARN [TxConnectionManager] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure.
16:59:35,718 ERROR [STDERR] regionBuilder is created.
16:59:35,718 ERROR [STDERR] Processing an RegionBuilder conversion now...about to execite QUERY Please wait.
16:59:35,734 ERROR [STDERR] java.lang.UnsupportedOperationException: Update queries only supported through HQL
16:59:35,734 ERROR [STDERR] at org.hibernate.impl.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:760)
16:59:35,734 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:43)
16:59:35,734 ERROR [STDERR] at com.mfa.healthtrack.dbconv.controller.RegionBuilderImpl.convertRegion(RegionBuilderImpl.java:95)
16:59:35,734 ERROR [STDERR] at com.mfa.healthtrack.dbconv.controller.RegionBuilderImpl$$EnhancerByCGLIB$$73eeecb2.CGLIB$convertRegion$5()
16:59:35,734 ERROR [STDERR] at com.mfa.healthtrack.dbconv.controller.RegionBuilderImpl$$EnhancerByCGLIB$$73eeecb2$$FastClassByCGLIB$$83b49971.invoke()
16:59:35,734 ERROR [STDERR] at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
16:59:35,734 ERROR [STDERR] at org.jboss.seam.interceptors.JavaBeanInterceptor$1.proceed(JavaBeanInterceptor.java:80)
16:59:35,734 ERROR [STDERR] at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
16:59:35,734 ERROR [STDERR] at org.jboss.seam.interceptors.ValidationInterceptor.validateTargetComponent(ValidationInterceptor.java:64)
16:59:35,734 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source)
16:59:35,734 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)