I'm trying to import a solution into my production server using the web interface.
The import result page says:
Importing NZIJServoy.servoy...
[info] Import contains XML version 7 and repository version 24.
[warning] Reserved words used as table or column names: tables: role; columns: type action number password level type date time type;
[info] Imported style 'nzij'.
The import options are:
Overwrite repository styles with import version [y]
Overwrite repository media with import version [y]
Overwrite repository group security settings with import version [y]
Allow reserved SQL keywords as table or column names [y]
Import solution sample data [n]
Import internationalization (i18n) data [n]
Insert new internationalization (i18n) keys only [n]
Merging options...
Merge solution if revision information is available, and when a merge conflict arises use: [n]
repository version
import version
Do not merge solution, and: [y]
overwrite repository forms with import version [y]
delete repository forms which do not exist in import version [y]
I get this error spurt out on the console of the server:
Oct 12, 2004 12:20:42 PM net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.PostgreSQLDialect
java.sql.SQLException: connection already closed or transaction in progress
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.persistence.datasource.TransactionConnection.close(Unknown Source)
at com.servoy.j2db.util.Utils.closeConnection(Unknown Source)
at com.servoy.j2db.persistence.e.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFile(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.try(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:518)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
java.lang.Exception: SOLUTION TRANSACTION NOT CLOSED ON FLUSH: NZIJServoy
java.lang.Exception: SOLUTION TRANSACTION NOT CLOSED ON FLUSH: NZIJServoy
at com.servoy.j2db.persistence.ao.do(Unknown Source)
at com.servoy.j2db.persistence.l.a(Unknown Source)
at com.servoy.j2db.persistence.l.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.flushAllCachedData(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFile(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.try(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
.........
And a whole lot more of the tomcat stack.
After this, the solution has not been imported.