org.geotools.data.DataSourceException: Transaction rollback
-----------------------------------------------------------
Key: GEOS-419
URL: http://jira.codehaus.org/browse/GEOS-419
Project: GeoServer
Type: Bug
Components: WFS
Versions: 1.3-rc2
Environment: MySQL Adapter (Linux OS)
Reporter: Pat Cappelaere
Assigned to: dblasby
Attachments: geoserver exception.rtf
Trying to do an insert, getting 956664 [WARNING] org.vfny.geoserver.ServiceException - encountered error: org.geotools.data.DataSourceException: Transaction rollback
The odd part is that the insert does work and the database is updated.
This problem seems to come and go. I tried the wfs insert from the demo gui.
Full stacktrace in attached document.
Partial here:
956654 [FINE] org.geotools.data.jdbc.JDBCTextFeatureWriter - INSERT INTO user_upload(uuid,date,url,userid,caption,latitude,longitude,location,icon) VALUES ('72f751ae:106e61e3145:-7fd1','2005-09-12T14:37:00','http://tacsatdev.pxi.com/tacsat1/data/upload/products/original/2005/09/12/A4A8F654-EEF7-482A-84E8-4DA8C88859B7.jpg’,‘FCBFBCDB-5265-CCFFBCDB-160127184186’,'UCIM tent','24.2','123.2',PointFromText('POINT (123.2 24.2)', -1),null)
956657 [FINE] org.geotools.validation.ValidationProcessor - No tests defined by integrityLookup - validation not needed
956658 [FINE] org.vfny.geoserver.servlets.AbstractService - mime type is: text/xml; charset=UTF-8
956662 [INFO] org.vfny.geoserver.servlets.AbstractService - Had an undefined error: Transaction rollback
956663 [FINE] org.vfny.geoserver.ServiceException - org.geotools.data.DataSourceException: Transaction rollback
956664 [WARNING] org.vfny.geoserver.ServiceException - encountered error: org.geotools.data.DataSourceException: Transaction rollback
StackTrace: org.geotools.data.DataSourceException: Transaction rollback
at org.geotools.data.jdbc.JDBCTransactionState.rollback(JDBCTransactionState.java:159)
at org.geotools.data.DefaultTransaction.rollback(DefaultTransaction.java:216)
at org.vfny.geoserver.wfs.responses.TransactionResponse.writeTo(TransactionResponse.java:774)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:465)
at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.java:342)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira