multiple database in database.xml

Posted by shilpi.agarwal3373 on 23-Dec-2015 01:27

Hello all,

Can we define multiple database(openedge, mysql) in the database.xml file of rollbase\config dir while we installing private cloud? 

<Database name="RB" isDefault="false" isExternal="true" MinConnections="3" MaxConnections="10" MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1" MaxConnLifetimeMins="60" TxIsolation="2" >
<Driver>com.mysql.jdbc.Driver</Driver>
<Url>jdbc:mysql://localhost:3306/RB_DBO</Url>
<DbUser>root</DbUser>
<Password>mysql</Password>
</Database>

<Database name="RB" isDefault="yes" isExternal="no"
MinConnections="3" MaxConnections="10"
MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"
MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="yes">
<Driver>com.ddtek.jdbc.openedge.OpenEdgeDriver</Driver>
<Url>jdbc:datadirect:openedge://localhost:8911;databaseName=rbdb</Url>

<DbUser>dbadmin</DbUser>
<Password>dbadmin</Password>
</Database>

Rollbase - Forum

All Replies

Posted by Siddeshwar on 23-Dec-2015 01:38

Hi,

While installing it is not possible, but later we can add multiple databases.

Please refer the following documentation:

documentation.progress.com/.../index.html

documentation.progress.com/.../

Thanks,

Siddeshwar.

Posted by shilpi.agarwal3373 on 23-Dec-2015 01:51

it is true.

When I am adding manually mysql database configuration with isExternal="true" in the database.xml file and again i restart the web server then I am only seeing Openedge database running in private rollbase. I have no option to see mysql database anywhere.

Posted by Manooj Murali on 23-Dec-2015 01:58

You should see the database by switching to System Console app and checking the databases section. If you don't see it there, can you please post your database.xml and a screenshot of the first page that comes up when you click on System Console app? (Also, please make sure there are no parse errors in the app server console log)

Regards,

Manooj

Posted by Rajkumar Mateti on 23-Dec-2015 02:20

Hi Shilpi,

My two cents

Still if you are unable to see the database in Database section of System tab in System Console application. Try renaming the mysql database name in databse.xml  from RB to something else and try.

Thanks,

Rajkumar

Posted by shilpi.agarwal3373 on 23-Dec-2015 03:17

After renaming mysql database name  in databse.xml, It works fine. Now i can see 2 databases on system console app

Thanks to all. But I am getting

License Expired or Invalid - Too many databases: 2 instead of free evaluation. When i am creating another customer tenant for mysql database, a system error appears. "License expired".

What does it mean?

Posted by Siddeshwar on 23-Dec-2015 03:32

The evaluation edition does not support multiple databases.

Thanks,

Siddeshwar.

Posted by shilpi.agarwal3373 on 23-Dec-2015 03:36

Ok Thanks.

This thread is closed