[jboss-user] [JBoss Seam] - problems with ms sql

[max522over]

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