Hi Ivy teams,

I have followed this link https://discourse.axonivy.io/t/change-the-system-database-of-axon-ivy-designer/137 and success with PostgreSQL, when I tried for using Oracle DB, It seems that the code didn't work. Although there are no error logs on the designer it can not create any table in the DB.

here is my code

import ch.ivyteam.ivy.server.configuration.system.db.SystemDatabaseCreator;
import ch.ivyteam.ivy.persistence.db.DatabasePersistencyServiceFactory;
import ch.ivyteam.ivy.server.configuration.Configuration;
import ch.ivyteam.db.jdbc.DatabaseConnectionConfiguration;


String databaseName = "xe";
String driverName = "oracle.jdbc.OracleDriver";
String connectionUrl = "jdbc:oracle:thin:@localhost:1521:xe";


String username = "fintech";
String password = "fintech";

Configuration configuration = Configuration.loadOrCreateConfiguration();
DatabaseConnectionConfiguration dbConfig = configuration.getSystemDatabaseConnectionConfiguration();

dbConfig.setDriverName(driverName);
dbConfig.setConnectionUrl(connectionUrl);
dbConfig.setUserName(username);
dbConfig.setPassword(password);

configuration.setSystemDatabaseConnectionConfiguration(dbConfig);
configuration.saveConfiguration();

DatabasePersistencyServiceFactory.createDatabaseCreator(dbConfig);
SystemDatabaseCreator creator = SystemDatabaseCreator.createSystemDatabaseCreator(dbConfig, [databaseName]);

creator.start();
if(creator.getError()!=null){
ivy.log.error(
creator.getError());}
while (creator.isRunning()) {
}

Am I missing something? please let me know if you need further information.

Thank you in advance,

asked 12.09 at 04:26

nvnhung's gravatar image

nvnhung
111
accept rate: 0%

Which exact version of designer do you use? With oracle it is more difficult because, we also create a new user (in oracle you can not just create a database, you have to create an user!) So that is why you then need the new user to connect after creation. In my opinion it is easier if you use the EngineConfigCli (https://developer.axonivy.com/doc/latest/engine-guide/tool-reference/engine-config-cli.html) to create the databse. See EngineConfigCli config-db help and EngineConfigCli create-db help.

(16.09 at 10:14) SupportIvyTeam ♦♦ SupportIvyTeam's gravatar image

Any news here? Otherwise I will delete this question...

(9 hours ago) SupportIvyTeam ♦♦ SupportIvyTeam's gravatar image

Yes, I have created the user like the same way as I create for configuration with Ivy Engine. it's success with Ivy Engine but not with Ivy Designer. The version of the designer is 7.0.11

(6 hours ago) nvnhung nvnhung's gravatar image

for the comment using the EngineConfigCLi, you mean I need to download the IvyEngine and using that tool to create the database, then connect the Designer to that database?

(6 hours ago) nvnhung nvnhung's gravatar image
Be the first one to answer this question!
toggle preview

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:

×75
×15
×6

Asked: 12.09 at 04:26

Seen: 44 times

Last updated: 6 hours ago