Having just gotten a repository running in MSSQL I figured it would be easy o import a sample solution. Seems not so. Using Admin on the server I get the error:
Importing C:\Program Files\Servoy\application_server\solutions\examples\svyDocMmt_2_2_x_example.servoy… [info] Import contains XML version 11 and repository version 29.
[error] Server ‘udm’ does not exist. Import failed.
[error] com.servoy.j2db.persistence.RepositoryException: Operation cancelled
Is there a particular set of servers (obviously ‘udm’ being one of them) I need to have configured and where would I find a list of the Db’s I’d need, if so?
I am under the impression that the tables will be created in the relevant Db’s from the repository / solution once imported???
Harry Catharell:
I have not invested time into reviewing 4.x yet but I make the assumption that the same servers would be required as for earlier 3.x versions:
Once the db’s and connections are there then table structures would be created automatically
Cheers
Harry
I guess I’ll need to create the relevant Db’s there too of course?
Harry Catharell:
Have you an earlier version installed somewhere that you can use for reference ?
Cheers
Harry
Now that’s an excellent thought Harry - I’ll investigate. EDIT: Looks like 3.x was installed on a different PC (not easily accessible now) for the last review!
Dont suppose you’d have a screen grab of the Dbs with names would you Harry?
Cheers Harry - a lone voice in the Forum Wilderness LOL. Guess there’s not many Servoy’ians not in Vegas tonight!!!
Got em installed thanks Harry - unfortunately there is no data attached to any of them!!! Seems since I didnt choose to install the iAnywhere Db’s I cant now get the samples to run!
Kahuna:
Got em installed thanks Harry - unfortunately there is no data attached to any of them!!! Seems since I didnt choose to install the iAnywhere Db’s I cant now get the samples to run!
If you had installed the databases you also would have had the connections already setup in Servoy.
So you know
Have you also configured / created the databases? The Servoy installation will contain pre-configured databases for Sybase. If you want to use MSSQL then you’ll have to create / edit your db servers so that the driver is set to com.microsoft.jdbc.sqlserver.SQLServerDriver, URL to jdbc:microsoft:sqlserver://<sql_host>:1433;DatabaseName=<database_name>;SelectMethod=cursor and username to the configured mssql user (‘sa’ by default). Did you do that?
Have you also configured / created the databases? The Servoy installation will contain pre-configured databases for Sybase. If you want to use MSSQL then you’ll have to create / edit your db servers so that the driver is set to com.microsoft.jdbc.sqlserver.SQLServerDriver, URL to jdbc:microsoft:sqlserver://<sql_host>:1433;DatabaseName=<database_name>;SelectMethod=cursor and username to the configured mssql user (‘sa’ by default). Did you do that?
Regards
Paul - I created the Db’s in my SQL server, and created servers in Servoy for them. I’m usint the Freebird driver BTW (jdbc:jtds:sqlserver://localhost:1443/example).
All connected correctly. But importing the solutions I still get no data? I assumed that the solutions would come with sample data that would be installed in the correct Db’s - but since I’m still getting my head around the Servoy concepts I could be totally wrong there?
Note that when importing solutions via the admin web page by default, the “import sample data” check box is unchecked. This is meant to make it harder to toast a production servers’ data by accident.
You can simply import the solution(s) again with the “import sample data” check box checked.
svroemisse:
Note that when importing solutions via the admin web page by default, the “import sample data” check box is unchecked. This is meant to make it harder to toast a production servers’ data by accident.
Hi Sandor,
in previous Servoy versions (up to 3.5) sample data is never imported if the table already contains some data, I hope this is still true with 4.0, isn’t it? It would be very dangerous otherwise…
svroemisse:
Note that when importing solutions via the admin web page by default, the “import sample data” check box is unchecked. This is meant to make it harder to toast a production servers’ data by accident.
Hi Sandor,
in previous Servoy versions (up to 3.5) sample data is never imported if the table already contains some data, I hope this is still true with 4.0, isn’t it? It would be very dangerous otherwise…
