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#3973428
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3973428
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
