Step By Step Installation ?

Classic Servoy
1

Dowloaded the demo for Windows and installed fine.

Then. went to run Servoy Developer and got Repository errors and following connect errors.

java.sql.SQLException: JDBC Driver ‘com.microsoft.jdbc.sqlserver.SQLServerDriver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver com.microsoft.jdbc.sqlserver.SQLServerDriver

Am I missing something? From reading on the forum, there looks to be many issues with installing and you need a degree to install this?

Can someone describe the install process somwhere easily for laymans like myself for the different OS.

e.g. for Windows, do this
eg. etc. etc.

Correct me if i’m wrong and this is described somewhere

Thanks

2

I think you installed the new version, on top, of an old one?
maybe the old properties file is refering to MS-SQl server, and you don’t have the JDBC driver installed.

maybe, try to completly remove the folder, and install again.

Hope this helps

3

Hi,

This is my first time installing the Servoy Product.

After installation starts, the program states that it cannot connect to the Repository specified in the application preferences.

What do i do next?

Thanks

4

Hi,

It looks like you are trying to use the MSSQL JDBC driver. That however doesn’t come installed with Servoy (most likely a licensing issue).
You need to install the driver or use the already bundled (OpenSource) jtds driver.
See the combobox at the bottom of the DB Servers tab in the application prefs window.

Hope this helps.

5

Hi,

Thanks, Correct. I’m trying to connect to a MSSQL database.

I downloaded the bundle jdts-1.2.2-dist.zip and there a lot of files. Within this zip package, there is a file jdts-1.2.2.jar

Is this the file? Do i need to copy only this file from the package to the Servoy drivers directory?

Thanks

6

yes, that should work,

in my case, I have a file called: jtds.jar

(but I don’t know which version I use! ;-) )

7

Hi,

Servoy already comes bundled with the jtds driver. See the drivers directory.
But yes, that jar file is the jdbc driver.

Hope this helps

8

Thanks guys.

Now, what do i do next. I have copied the file to the drivers directory.

Now i have restarted Servoy Develeoper and i get cannot connect to repository.

What must i do in Edit, Preferences.

Thanks

9

Hi,

First if all make sure there is only 1 jtds driver in the drivers directory.
After this you need to change your DB server settings with the following syntax.

Database Server URL : jdbc:jtds:sqlserver://<server_host>/
Replace the <> fields accordingly.

Driver : net.sourceforge.jtds.jdbc.Driver

Hope this helps.

10

Many thanks

I have inputted my SQL Server info now.

When i restart Servoy Developer, it is still saying “Cannot connect to the Repository Server etc.”

What settings must i use for the Repository Server

Thanks

11

Do you use the bundled Sybase as repository database or do you (want to) use MSSQL for this?
If it’s the latter then make sure you have created an empty database in MSSQL and have put the correct login info in the database connection.
After launching Developer it will ask if it can create the repository for you (create the tables).

Hope this helps.

12

Is is the bundled sybase included in the install?

If so, how do i do this?

I am using SQL2005 on a local machine.

13

Hi,

If you didn’t uncheck that option in the installer then yes it should be there.
Make sure your repository_server connection settings uses the following syntax:

username: dba
password: sql
database server URL: jdbc:sybase:Tds:localhost:2638?ServiceName=<database_name>&CHARSET=utf8
Driver: com.sybase.jdbc3.jdbc.SybDriver

Developer should launch Sybase when you launch it the first time. If it’s now running then check the sybase log in the servoy/sybase directory.

Hope this helps.

14

If you want to use MSSQL as repository

You must first create in your MSSQL Server the different Databases you’ll need :
servoy_repository
servoy_example_data
servoy_udm
servoy_user_data
servoy_ log_data
etc…
the same than in sybase
Then you can use mixed authentication , the goto to the secutity of your server and create an account for your servoy connection
Granted him access to all these dbs with db owner rights (permit modify structure from servoy).

Then you can modify you servoy properties files like the sample below (with microsoft jdbc driver):

server.0.URL=jdbc:sqlserver://localhost;databaseName=servoy_repository;user=SERVOY;password=SERVOY;
server.0.catalog=
server.0.connectionValidationType=0
server.0.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.0.enabled=true
server.0.maxConnectionsActive=10
server.0.maxConnectionsIdle=5
server.0.maxPreparedStatementsIdle=100
server.0.password=encrypted:esfqXLYYxNU=
server.0.schema=
server.0.serverName=repository_server
server.0.userName=SERVOY
server.1.URL=jdbc:sqlserver://localhost;databaseName=servoy_user_data;user=SERVOY;password=SERVOY;
server.1.catalog=
server.1.connectionValidationType=0
server.1.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.1.enabled=true
server.1.maxConnectionsActive=10
server.1.maxConnectionsIdle=5
server.1.maxPreparedStatementsIdle=100
server.1.password=encrypted:esfqXLYYxNU=
server.1.schema=
server.1.serverName=user_data
server.1.userName=SERVOY
server.2.URL=jdbc:sqlserver://localhost;databaseName=servoy_example_data;user=SERVOY;password=SERVOY;
server.2.catalog=
server.2.connectionValidationType=0
server.2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.2.enabled=true
server.2.maxConnectionsActive=10
server.2.maxConnectionsIdle=5
server.2.maxPreparedStatementsIdle=100
server.2.password=encrypted:esfqXLYYxNU=
server.2.schema=
server.2.serverName=example_data
server.2.userName=SERVOY
server.3.URL=jdbc:sqlserver://localhost;databaseName=servoy_log_data;user=SERVOY;password=SERVOY;
server.3.catalog=
server.3.connectionValidationType=0
server.3.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.3.enabled=true
server.3.maxConnectionsActive=10
server.3.maxConnectionsIdle=5
server.3.maxPreparedStatementsIdle=100
server.3.password=encrypted:esfqXLYYxNU=
server.3.schema=
server.3.serverName=log_server
server.3.userName=SERVOY
server.4.URL=jdbc:sqlserver://localhost;databaseName=servoy_udm;user=SERVOY;password=SERVOY;
server.4.catalog=
server.4.connectionValidationType=0
server.4.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.4.enabled=true
server.4.maxConnectionsActive=10
server.4.maxConnectionsIdle=5
server.4.maxPreparedStatementsIdle=100
server.4.password=encrypted:esfqXLYYxNU=
server.4.schema=
server.4.serverName=udm
server.4.userName=SERVOY
server.5.URL=jdbc:sqlserver://localhost;databaseName=servoy_pdf_forms;user=SERVOY;password=SERVOY;
server.5.catalog=
server.5.connectionValidationType=0
server.5.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.5.enabled=true
server.5.maxConnectionsActive=10
server.5.maxConnectionsIdle=5
server.5.maxPreparedStatementsIdle=100
server.5.password=encrypted:esfqXLYYxNU=
server.5.schema=
server.5.serverName=pdf_forms
server.5.userName=SERVOY

15

Thanks

Still having problems.

Do i need the following setup to get this application running?

  1. Repository Server
  2. My own SQL Server/Database Settings?

For the Repository Server, i am trying to point it at a blank database and still get the error

java.sql.SQLException: Driver did not return a connection (driver does not recognize the URL)

16

Ok, getting somewhere. I’m getting the following error now so it has to do with login

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Login failed for user ‘bos’.
java.sql.SQLException: Login failed for user ‘bos’.

17

bpmosullivan:
Do i need the following setup to get this application running?

  1. Repository Server
  2. My own SQL Server/Database Settings?
  1. is needed to develop your solutions in. It contains your solution source.
  2. is needed to work with any data for your solutions.

bpmosullivan:
java.sql.SQLException: Driver did not return a connection (driver does not recognize the URL)

Seems you are using a wrong syntax for this connection. Can you post here both your database server URL and your driver string ?

18

bpmosullivan:
Ok, getting somewhere. I’m getting the following error now so it has to do with login

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Login failed for user ‘bos’.
java.sql.SQLException: Login failed for user ‘bos’.

So what database server are you using for this? And is this the repository or another database ?

19

Here is what i have working so far

Under the DB Servers Tab,

I have configured my local machine and my database settings and this has been accepted.

When i go to restart the program, it gives me the repository error.

So i change the Repository Server listing to another MSSQL database on my local machine but it says this server already exists

com.servoy.j2db.persistence.RepositoryException: Server with name: ‘myserver’ already exists

20

Could you paste your servoy.properties file here please