Hi, I would like to know how to add connection to the system database of the designer next to other connections. This would allow me to browse systemdb via database elements.

Thanks a lot.

asked 10.10.2014 at 09:34

matej_smetana's gravatar image

matej_smetana
(suspended)
accept rate: 0%


You can access the system database of the Designer as follows:

  1. Create a new Database Configuration. Choose an appropriate name like 'SystemDb'
  2. Choose 'Hpyersonic SQL Db' as Database
  3. Choose 'HSQL Db Memory' as Driver
  4. Choose 'AxonIvySystemDatabase' (Axon.ivy 5.1 and later) or 'XpertIvySystemDatabase' (Xpert.ivy 5.0 and older) as Database Name
  5. Use the new database configuration in the Database process element to access the system database.
link

answered 13.10.2014 at 14:11

Reto%20Weiss's gravatar image

Reto Weiss ♦♦
4.9k202857
accept rate: 74%

edited 13.10.2014 at 14:13

This is exactly what I was looking for. Thank you!

(13.10.2014 at 14:26) matej_smetana matej_smetana's gravatar image

Is it still correct? I tried to use 'AxonIvySystemDatabase' and 'IvySystemDatabase'. But I can't connect to HSQL db, will we still use 9001 as default port ?

(22.07.2018 at 22:33) Tuyen Tuyen's gravatar image

You cannot specify a port for the HSQL Db Memory. So why would you use 9001?

(23.07.2018 at 02:38) Reto Weiss ♦♦ Reto%20Weiss's gravatar image

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×78
×14

Asked: 10.10.2014 at 09:34

Seen: 3,545 times

Last updated: 23.07.2018 at 02:38