Cannot import solution into 2.2RC5 repository on Oracle 9

Classic Servoy
1

Hi,

Just upgraded our Application Server to 2.2RC5 and now try to import a solution, but we are getting an com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException error:

[info] Import contains XML version 9 and repository version 25.
[warning] Reserved words used as table or column names: columns: timestamp segment;
[info] Imported new media ‘delete.png’.
[info] Imported new media ‘documents_new.png’.
[info] Imported new media ‘media_play_green.png’.
[info] Imported new media ‘media_stop_red.png’.
[info] Imported new media ‘media_step_forward.png’.
[info] Imported new media ‘find.png’.
[info] Imported new media ‘gear_stop.png’.
[info] Imported new media ‘user1_add.png’.
[info] Imported new media ‘house.png’.
[info] Imported new media ‘keys.png’.
[error] com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: connection already closed or transaction in progress

We import the solution with the following options turned on on the admin page where you specify the solution file to import:

  • Allow reserved SQL keywords as table or column names
  • Do not import users contained in import
  • Do not merge solution, and:
    overwrite repository forms with import version
    delete repository forms which do not exist in import version

Paul

Server Information
Servoy version R2 2.2rc5-build 323, repository version 25

JDK Information
java.vm.name=Java HotSpot™ Client VM
java.vm.version=1.5.0_02-b09
java.vm.info=mixed mode, sharing
java.vm.vendor=Sun Microsystems Inc.

Operating System Information
os.name=Linux
os.version=2.4.20-8smp
os.arch=i386

2

Got the same on a windows environment with Oracle only DB’s, running Java 1.4.1…

Paul

3

And here’s the stacktrace:

Solution xxxxxxxxx’ connection closed by thread TaskExecuter[3]
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.Rep
ositoryException: java.sql.SQLException: connection already closed or transactio
n in progress
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.Rep
ositoryException: java.sql.SQLException: connection already closed or transactio
n in progress
at com.servoy.j2db.persistence.an.a(Unknown Source)
at com.servoy.j2db.persistence.i.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unkn
own Source)
at com.servoy.j2db.develop.j$6.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: connecti
on already closed or transaction in progress
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: connecti
on already closed or transaction in progress
at com.servoy.j2db.persistence.an.a(Unknown Source)
at com.servoy.j2db.persistence.an.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.createNewMedia(Unknown Source)

at com.servoy.j2db.persistence.Solution.createNewMedia(Unknown Source)
at com.servoy.j2db.persistence.i.if(Unknown Source)
at com.servoy.j2db.persistence.i.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unkn
own Source)
at com.servoy.j2db.develop.j$6.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.persistence.datasource.TransactionConnection.close(Un
known Source)
at com.servoy.j2db.persistence.an.a(Unknown Source)
at com.servoy.j2db.persistence.an.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.createNewMedia(Unknown Source)

at com.servoy.j2db.persistence.Solution.createNewMedia(Unknown Source)
at com.servoy.j2db.persistence.i.if(Unknown Source)
at com.servoy.j2db.persistence.i.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unkn
own Source)
at com.servoy.j2db.develop.j$6.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)
repository_server: Closed connection, thread=TaskExecuter[3]
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.Rep
ositoryException: java.sql.SQLException: connection already closed or transactio
n in progress
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.Rep
ositoryException: java.sql.SQLException: connection already closed or transactio
n in progress
at com.servoy.j2db.persistence.i.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unkn
own Source)
at com.servoy.j2db.develop.j$6.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.Rep
ositoryException: java.sql.SQLException: connection already closed or transactio
n in progress
Reserved words used as table or column names: columns: timestamp segment;

4

I think there is a problem with repository import/export not only with Oracle. I sent a solution to Servoy already, so I guess there will be a fix in RC6.

5

Missed that post, Patrick, but tnx for pointing it out :) Now at least I know it’s not just us here.. and hope it’ll be fixed in rc6…

Some more info: the solution we’re trying to import was created in a Sybase repository.

And, to try to get it working, we tried copying the additional Oracle Driver JAR with the CLOB fix to a 2.2b2 installation. Then we get the same errors there when trying to import a solution.

Paul