Customers
User information
 Loading ...
Show article in Knowledge Base

 How can I manually change the database settings for the system? Export knowledge base Export     SubscribeSubscribe      Show article info

This is done in a file called visionproject_database.properties file that you can find in the <YOUR_WEB_APP_PATH>/WEB-INF/classes/ directory on your server

 

databaseType  - should be MSSQLServer or MySQL, example "databaseType=MSSQLServer"

 

user - should be the username that you log into the system with, such as sa or root, example "user=sa"

 

password - should be the database user's password, example password=mypassword

 

numberOfInitialConnections - the number of database connecitons the server should start with

 

driver - depends on the database you have installed. Use one of the following:

  • driver=com.mysql.jdbc.Driver for MySQL
  • driver=com.microsoft.sqlserver.jdbc.SQLServerDriver  for MSSQLServer

 

url - depends on the database you have installed and needs to be changed according to the formats below:

  • url=jdbc:sqlserver://localhost;databaseName=visionproject;portNumber=1433
  • url=jdbc:mysql://localhost/visionproject
  • or with the IP as follows
  • url=jdbc:sqlserver://127.0.0.1;databaseName=visionproject;portNumber=1433
  • url=jdbc:mysql://127.0.0.1/visionproject

MS SQL Server with named instance "vflow"

  • url=jdbc:sqlserver://localhost\\vflow;databaseName=visionflow

 

 

Please note that all values above are case sensitive.

 

If you have problems connecting to the server please try the following:

 

 

  • Ping server to make sure it is reachable from other server
  • Try to connect to server via telnet
    • For MS SQL Server use: telnet <YOUR_IP> 1433
    • For MS SQL Server use: telnet <YOUR_IP> 3306
  • If you use MS SQL Server make sure the server is configured with "Mixed mode Authentiction"
  • If you use MS SQL Server the password should not contain any windows domain, just username and password

User comments
 Loading ...