How to integrate KNOWAGE with oracle database [closed]

Question

I am trying to install KNOWAGE (Knowage-7_4_10-CE-Installer-Unix-20210922) with connection to Oracle database. I am stuck. In the installation manual it dictate on mysql installation but not with oracle. Is there anyone can provide step-by-step guidelines for KNWOAGE installation with Oracle database directly.

Answer 1

Hello,

when using Oracle the procedure is the same as MySQL, but in the $TOMCAT/lib folder you will need the Oracle JDBC connector, and in the server.xml file you will provide the Oracle connection string:

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" logAbandoned="true" maxIdle="4" maxTotal="20" maxWait="-1" minEvictableIdleTimeMillis="60000" name="jdbc/knowage" password="..." removeAbandoned="true" removeAbandonedTimeout="3600" testOnReturn="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" type="javax.sql.DataSource" url="..." username="...." validationQuery="select 1 from dual"/>

Hope this helps.

Bye,
Marco

Comments

Hi Marco,

Thanks for your quick response. The problem is when i ran the installer (Knowage-7_4_10-CE-Installer-Unix) it asked for database with two options (MarioDB and MySQL) , no option to choose Oracle as a database. But I still ran the installation and i found that it didn't generate knowage*/META-INF folder. That's why i suck, and don't know how to proceed? So my question is, to install KNOWAGE in LINUX, do i need to install mysql database first before run the installer if i already have Oracle installed? Please see the screen shot below

Thanks

Abu Muyeen