Child pages
  • Managing Database Connections
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Almost all Servoy applications utilize a database to store user data and application metadata.  Servoy can connect to any database that has a JDBC driver available. Servoy provides a database, Sybase SQL Anywhere, for you if you do not already have a database management system (DBMS).

Creating a New Database in Sybase SQL Anywhere

In Servoy Developer, you may create a new SQL Anywhere database from the Solution Explorer tree.

  1. In the Servoy Developer Solution Explorer tab, expand the Database Servers node (under Resources) and right click on a SQL Anywhere database (all the example databases provided by Servoy are SQL Anywhere) to show the popup menu.
  2. Select Create Sybase Database.
  3. Enter a name for the database in the dialog window.
  4. A dialog will appear indicating a Sybase database restart is required.
  5. A dialog will recommend to restart Servoy Developer.  Click OK. and close Servoy Developer.
  6. Close Sybase SQLAnywhere.
    1. On Windows - Look for the orange lighting bolt in the system tray, right click, and select Shut down "servoy_repository"
    2. On Mac and Linux - find the dbsrv11 process and shut it down.
  7. Restart Servoy Developer.
  8. Your database will appear in the Database Servers node.

Connecting to an Existing Database

You may also connect to an existing database in Servoy Developer.

  1. Determine the JDBC driver required for making connections to your database.  You can find the proper driver normally from the DBMS manufacturer/documentation; another source that may help is the Servoy Forum as other developers have possibly used your database with Servoy.
  2. Install the driver by placing the .jar file in the application_server/drivers folder in your Servoy installation folder.
  3. Restart Servoy Developer.
  4. Create a new Database Server connection by right clicking on Database Servers node (under Resources) and selecting New Server.  A submenu will provide choices of different popular database choices that will fill in some of the connection information to make setup easier, or you may choose empty.

    NOTE

    Even though a database is listed here, you must still install a driver in the drivers folder in order to connect to the database.

  5.  Fill in the Server Name, User Name, Password, URL, and Driver for your database.  You can find the correct values for the URL and Driver from your database documentation, or suggested values will be already entered if you selected your database in the New Server menu.

    NOTE

    The user account should be of administrator level so you have full access to database objects in Servoy.

  6. Save the tab by clicking the save button in the toolbar or using Ctrl-S to save the tab.
  7. Your database should now appear in the Database Servers list.

Creating Tables and Fields

It is best practice to create your data model (tables, primary keys, foreign keys, and fields) before you create your solution.  You can create objects in the database with database tools built to administer the database, or you may create objects within Servoy Developer.

Creating Tables

To create a table in Servoy Developer.

  1.  
  • No labels