can 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) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3973428#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...