[Users] javax.xml.ws.soap.SOAPFaultException: could not execute native bulk manipulation query
Leo Bayer
lbayer at alterpoint.com
Thu May 22 11:51:00 CDT 2008
if you check out from the branch you should be using the module alias
for the branch. 'ziptie' is always the module list for the HEAD.
cvs checkout -r b2008_04 ziptie_2008_04
- Leo
On May 22, 2008, at 11:47 AM, Brett Wooldridge wrote:
> Yep, you are correct. I just found the issue. There was an error
> in our table create statement for the tag table. It is fixed in the
> 2008.04 branch (soon to be released as 2008.04b).
>
> You probably want to checkout the branch rather than from the
> timestamp:
>
> cvs checkout -r b2008_04 ziptie
>
> -Brett
>
> On 5/23/08 1:22 AM, "Steve Eastham" <steve.eastham at gmail.com> wrote:
>
> I changed the value and bounced the server ... still happening;
>
> Looking down in in the stack trace there a DB exception occurring <
> Caused by: org.postgresql.util.PSQLException: ERROR: null value in
> column "tag_id" violates not-null constraint
> >
>
> javax.xml.ws.soap.SOAPFaultException: could not execute native bulk
> manipulation query
> at
> com
> .sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:
> 173)
> at
> com
> .sun
> .xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:
> 102)
> at
> com
> .sun
> .xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:
> 240)
> at
> com
> .sun
> .xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:
> 210)
> at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:103)
> at $Proxy39.addTag(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org
> .ziptie
> .client
> .ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:80)
> at $Proxy40.addTag(Unknown Source)
> at
> org
> .ziptie
> .ui.devices.tags.TagPreferencePage.performOk(TagPreferencePage.java:
> 405)
> at org.eclipse.jface.preference.PreferenceDialog
> $11.run(PreferenceDialog.java:889)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
> at org.eclipse.core.runtime.Platform.run(Platform.java:843)
> at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
> at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:149)
> at
> org
> .eclipse
> .jface.preference.PreferenceDialog.okPressed(PreferenceDialog.java:
> 869)
> at
> org
> .eclipse
> .ui
> .internal
> .dialogs
> .FilteredPreferenceDialog.okPressed(FilteredPreferenceDialog.java:376)
> at
> org
> .eclipse
> .ui
> .internal
> .dialogs
> .WorkbenchPreferenceDialog.okPressed(WorkbenchPreferenceDialog.java:
> 164)
> at
> org
> .eclipse
> .jface
> .preference.PreferenceDialog.buttonPressed(PreferenceDialog.java:230)
> at org.eclipse.jface.dialogs.Dialog$3.widgetSelected(Dialog.java:660)
> at
> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:
> 227)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:
> 3682)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
> at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
> at org.eclipse.jface.window.Window.open(Window.java:796)
> at
> org
> .ziptie
> .ui
> .common
> .OpenPreferencePageActionDelegate
> .run(OpenPreferencePageActionDelegate.java:61)
> at
> org
> .ziptie
> .navigation
> .ActionSideBarContribution
> .executeActionDelegate(ActionSideBarContribution.java:90)
> at org.ziptie.navigation.ActionSideBarContribution.access
> $100(ActionSideBarContribution.java:37)
> at org.ziptie.navigation.ActionSideBarContribution
> $1.linkActivated(ActionSideBarContribution.java:70)
> at
> org
> .eclipse
> .ui
> .forms
> .widgets.AbstractHyperlink.handleActivate(AbstractHyperlink.java:208)
> at
> org
> .eclipse
> .ui
> .forms
> .widgets.AbstractHyperlink.handleMouseUp(AbstractHyperlink.java:289)
> at org.eclipse.ui.forms.widgets.AbstractHyperlink.access
> $1(AbstractHyperlink.java:273)
> at org.eclipse.ui.forms.widgets.AbstractHyperlink
> $4.handleEvent(AbstractHyperlink.java:110)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:
> 3682)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894)
> at
> org
> .eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:
> 422)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:
> 149)
> at org.ziptie.rcp.ZiptieApplication.run(ZiptieApplication.java:115)
> at org.eclipse.core.internal.runtime.PlatformActivator
> $1.run(PlatformActivator.java:78)
> at
> org
> .eclipse
> .core
> .runtime
> .internal
> .adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
> at
> org
> .eclipse
> .core
> .runtime
> .internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
> at
> org
> .eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
> 400)
> at
> org
> .eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:
> 177)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336)
> at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
> at org.eclipse.core.launcher.Main.run(Main.java:977)
> at org.eclipse.core.launcher.Main.main(Main.java:952)
> Caused by: org.hibernate.exception.ConstraintViolationException:
> could not execute native bulk manipulation query
> at
> org
> .hibernate
> .exception.SQLStateConverter.convert(SQLStateConverter.java:71)
> at
> org
> .hibernate
> .exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at
> org
> .hibernate
> .engine
> .query
> .NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:174)
> at
> org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:
> 1163)
> at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:
> 334)
> at
> org
> .ziptie
> .provider.devices.DeviceTagProvider.addTag(DeviceTagProvider.java:54)
> at
> org
> .ziptie
> .provider
> .devices
> .DeviceTagProviderDelegate.addTag(DeviceTagProviderDelegate.java:21)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun
> .reflect
> .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun
> .reflect
> .DelegatingMethodAccessorImpl
> .invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at com.sun.xml.ws.api.server.InstanceResolver
> $1.invoke(InstanceResolver.java:246)
> at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
> at
> com
> .sun
> .xml
> .ws
> .server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:
> 257)
> at
> com
> .sun
> .xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:
> 93)
> at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
> at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
> at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
> at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
> at com.sun.xml.ws.server.WSEndpointImpl
> $2.process(WSEndpointImpl.java:243)
> at com.sun.xml.ws.transport.http.HttpAdapter
> $HttpToolkit.handle(HttpAdapter.java:444)
> at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:
> 244)
> at
> com
> .sun
> .xml
> .ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:
> 135)
> at
> com
> .sun
> .xml
> .ws
> .transport
> .http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
> at
> com
> .sun
> .xml
> .ws
> .transport
> .http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
> at org.ziptie.zap.metro.ZwsServlet.doPost(ZwsServlet.java:227)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
> 487)
> at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1093)
> at org.ziptie.zap.security.ZHttpContext.doFilter(ZHttpContext.java:80)
> at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1084)
> at
> org
> .ziptie
> .zap.metro.ZThreadContextFilter.doFilter(ZThreadContextFilter.java:34)
> at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
> 360)
> at
> org
> .ops4j
> .pax
> .web
> .service
> .internal
> .HttpServiceServletHandler.handle(HttpServiceServletHandler.java:56)
> at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
> 181)
> at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
> 722)
> at
> org
> .ops4j
> .pax
> .web
> .service.internal.HttpServiceContext.handle(HttpServiceContext.java:
> 107)
> at org.ops4j.pax.web.service.internal.JettyServerHandlerCollection.handle
> (JettyServerHandlerCollection.java:64)
> at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
> 139)
> at org.mortbay.jetty.Server.handle(Server.java:324)
> at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
> 505)
> at org.mortbay.jetty.HttpConnection
> $RequestHandler.content(HttpConnection.java:842)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
> at org.mortbay.jetty.bio.SocketConnector
> $Connection.run(SocketConnector.java:228)
> at org.mortbay.jetty.security.SslSocketConnector
> $SslConnection.run(SslSocketConnector.java:620)
> at org.mortbay.thread.BoundedThreadPool
> $PoolThread.run(BoundedThreadPool.java:450)
> Caused by: org.postgresql.util.PSQLException: ERROR: null value in
> column "tag_id" violates not-null constraint
> at
> org
> .postgresql
> .core
> .v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
> 1592)
> at
> org
> .postgresql
> .core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> at
> org
> .postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
> 192)
> at
> org
> .postgresql
> .jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at
> org
> .postgresql
> .jdbc2
> .AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
> 350)
> at
> org
> .postgresql
> .jdbc2
> .AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun
> .reflect
> .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun
> .reflect
> .DelegatingMethodAccessorImpl
> .invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection
> $StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
> at $Proxy50.executeUpdate(Unknown Source)
> at
> bitronix
> .tm
> .resource
> .jdbc
> .JdbcPreparedStatementHandle
> .executeUpdate(JdbcPreparedStatementHandle.java:51)
> at
> org
> .hibernate
> .engine
> .query
> .NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:165)
> ... 47 more
>
> <ATT00001.txt>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ziptie.org/pipermail/users/attachments/20080522/64b52713/attachment.html
More information about the Users
mailing list