I’m a new Servoy user and I’m trying to use SQLite for the repository database. After reading through the documentation and forums I am not able to succesfully create the repository. These are the steps I’m following:
Install Servoy (without database)
Put sqlitejdbc-v506.jar in c:program files\servoy\application_server\drivers
Create repository servor in SQLite
Start Servoy
Create new empty repository server
Untick enabled
Select sqlite jdbc driver and enter URL
Save and restart Servoy
Enable repository server
Right click repository server to bring up message “Old or no repository version found in repository_server connection do you want to upgrade”.
Click OK
Results in a message “Cannot create \ upgrade repository”
can anybody offer any suggestions as to where I’m going wrong?
2009-08-27 20:35:58,484 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Could not find repository server: ‘repository_server’
at com.servoy.j2db.persistence.ServerManager.getRepositoryServer(ServerManager.java:261)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:131)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
2009-08-27 20:35:59,812 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Could not find repository server: ‘repository_server’
at com.servoy.j2db.persistence.ServerManager.getRepositoryServer(ServerManager.java:261)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:371)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
2009-08-27 20:43:48,859 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: No repository found in the database.
at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:39)
at com.servoy.j2db.persistence.Repository.(Repository.java:178)
at com.servoy.j2db.persistence.Repository.(Repository.java:1641)
at com.servoy.j2db.persistence.Server.getRepository(Server.java:730)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
2009-08-27 20:44:14,640 ERROR [main] com.servoy.j2db.util.Debug - Throwable
java.sql.SQLException: SQL logic error or missing database
at org.sqlite.DB.throwex(DB.java:288)
at org.sqlite.DB.exec(DB.java:68)
at org.sqlite.Conn.rollback(Conn.java:179)
at com.servoy.j2db.persistence.datasource.Zs.rollback(Zs.java:21)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:236)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:236)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:236)
at com.servoy.j2db.persistence.datasource.TransactionConnection.rollback(TransactionConnection.java:14)
at com.servoy.j2db.util.Utils.rollback(Utils.java:455)
at com.servoy.j2db.persistence.Repository.loadSequence(Repository.java:374)
at com.servoy.j2db.persistence.Repository.getSequence(Repository.java:1221)
at com.servoy.j2db.persistence.Repository.setUserProperties(Repository.java:1263)
at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:54)
at com.servoy.j2db.persistence.Server.createActualRepositoryTables(Server.java:530)
at com.servoy.j2db.persistence.Server.createRepositoryTables(Server.java:622)
at com.servoy.eclipse.team.ServoyTeamProvider$6.run(ServoyTeamProvider.java:4)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:129)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3659)
at org.eclipse.swt.widgets.Display.msgFilterProc(Display.java:3041)
at org.eclipse.swt.internal.win32.OS.TrackPopupMenu(Native Method)
at org.eclipse.swt.widgets.Menu._setVisible(Menu.java:228)
at org.eclipse.swt.widgets.Display.runPopups(Display.java:3708)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
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.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
2009-08-27 20:44:14,640 ERROR [main] com.servoy.j2db.util.Debug - Throwable
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.persistence.datasource.TransactionConnection.close(TransactionConnection.java:7)
at com.servoy.j2db.util.Utils.closeConnection(Utils.java:166)
at com.servoy.j2db.persistence.Repository.setUserProperties(Repository.java:381)
at com.servoy.j2db.persistence.RepositoryUpdater.createRepositoryTables(RepositoryUpdater.java:54)
at com.servoy.j2db.persistence.Server.createActualRepositoryTables(Server.java:530)
at com.servoy.j2db.persistence.Server.createRepositoryTables(Server.java:622)
at com.servoy.eclipse.team.ServoyTeamProvider$6.run(ServoyTeamProvider.java:4)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:129)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3659)
at org.eclipse.swt.widgets.Display.msgFilterProc(Display.java:3041)
at org.eclipse.swt.internal.win32.OS.TrackPopupMenu(Native Method)
at org.eclipse.swt.widgets.Menu._setVisible(Menu.java:228)
at org.eclipse.swt.widgets.Display.runPopups(Display.java:3708)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3287)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
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.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
2009-08-27 20:45:57,296 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 0, software version: 35. Upgrade the repository first.
at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:1625)
at com.servoy.j2db.persistence.Repository.(Repository.java:178)
at com.servoy.j2db.persistence.Repository.(Repository.java:1641)
at com.servoy.j2db.persistence.Server.getRepository(Server.java:730)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
2009-08-27 21:06:17,734 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 0, software version: 35. Upgrade the repository first.
at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:1625)
at com.servoy.j2db.persistence.Repository.(Repository.java:178)
at com.servoy.j2db.persistence.Repository.(Repository.java:1641)
at com.servoy.j2db.persistence.Server.getRepository(Server.java:730)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
2009-08-27 21:12:41,218 ERROR [Thread-3] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 0, software version: 35. Upgrade the repository first.
at com.servoy.j2db.persistence.Repository.testIfValid(Repository.java:1625)
at com.servoy.j2db.persistence.Repository.(Repository.java:178)
at com.servoy.j2db.persistence.Repository.(Repository.java:1641)
at com.servoy.j2db.persistence.Server.getRepository(Server.java:730)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(ApplicationServer.java:353)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:182)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:2)
at java.lang.Thread.run(Unknown Source)
I have some customers that have relatively simple desktop database applications that use SQLite. I just wanted to see how easy it was to develop these using Servoy and did not want to install another database which I will not use in the future. If all else fails I’ll try SQL server or MySQL which I already use or install SQL Anywhere. It was just that once I started I just wanted to figure out why I could not get Servoy to work with SQLite!