Versions Compared

Version Old Version 17 New Version 18
Changes made by

Axel PHILIPPON-LEBREC (Unlicensed)

Axel PHILIPPON-LEBREC (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1/ Open the file context.xml in C:\Program Files\Optilogistic\Axiodis6\...\tomcat\conf\bi

and copy in C:\Program Files\Optilogistic\Axiodis6\...\tomcat\conf\ all missing lines and only them.


Code Block
languagexml
titleExample of code to add to the target context.xml file
linenumberstrue
collapsetrue
<!-- BI main datasource -->
    <Environment name="bi_resource_path" type="java.lang.String" value="${catalina.home}/../bi"/>
    <Environment name="bi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"/>
    <!--<Environment name="bi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.cas.CasSsoService3"/>-->
    <Environment name="bi_service_url" type="java.lang.String" value="http://GCREC02.optilogistic.dom:8080/bi"/>
    <Environment name="bi_host_url" type="java.lang.String" value="http://GCREC02.optilogistic.dom:8080"/>
    <!--# Define the global hibernate dialect to be used for the main JNDI Datasource -->
    <Environment name="jdbc/bi_dialect" type="java.lang.String" value="org.hibernate.dialect.HSQLDialect"/>
    <Environment name="jdbc/bi_cache_dialect" type="java.lang.String" value="org.hibernate.dialect.SQLServerDialect"/>
    <!--TODO: Currently the JBPM, cache and quartz are REQUIRED to be on SqlServer Database!-->

    <!--This is the main schema portable database-->
    <Resource name="jdbc/axio-bi" auth="Container"
			  type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver"
			  url="jdbc:hsqldb:file:${catalina.base}/database/axiodisbi"
			  username="sa" password="" maxTotal="64" maxIdle="8"
			  maxWaitMillis="-1" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"/>
    <!--This is where the BI extract, trasform, load and store the big data-->
    <Resource name="jdbc/axio-bi-cache" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_BI1"
              username="REC_V6_MINOR_BI1" password="REC_V6_MINOR_BI1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>
    <!--This is where the BI reads the real time data coming unaggregaged from the axiodis database-->
    <Resource name="jdbc/axio-bi-operational" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_AX1"
              username="REC_V6_MINOR_AX1" password="REC_V6_MINOR_AX1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>
    <!--This is where the BI reads the MIA flux aggregaged data from the Infocenter database-->
    <Resource name="jdbc/axio-bi-reporting" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_IC1"
              username="REC_V6_MINOR_IC1" password="REC_V6_MINOR_IC1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>

    <Resource name="wm/BiWorkManager" auth="Container"
              type="commonj.work.WorkManager" factory="de.myfoo.commonj.work.FooWorkManagerFactory" maxThreads="8"/>


2/ Paste them just after the tag  <Context containerSciFilter="">


Code Block
languagexml
linenumberstrue
collapsetrue
<?xml version="1.0" encoding="utf-8" standalone="no"?>
<Context containerSciFilter="">

    <!-- BI main datasource -->
    <Environment name="bi_resource_path" type="java.lang.String" value="${catalina.home}/../bi"/>
    <Environment name="bi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"/>
    <!--<Environment name="bi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.cas.CasSsoService3"/>-->
    <Environment name="bi_service_url" type="java.lang.String" value="http://GCREC02.optilogistic.dom:8080/bi"/>
    <Environment name="bi_host_url" type="java.lang.String" value="http://GCREC02.optilogistic.dom:8080"/>
    
    <Environment name="jdbc/bi_dialect" type="java.lang.String" value="org.hibernate.dialect.HSQLDialect"/>
    <Environment name="jdbc/bi_cache_dialect" type="java.lang.String" value="org.hibernate.dialect.SQLServerDialect"/>

    <Resource name="jdbc/axio-bi" auth="Container"
			  type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver"
			  url="jdbc:hsqldb:file:${catalina.base}/database/axiodisbi"
			  username="sa" password="" maxTotal="64" maxIdle="8"
			  maxWaitMillis="-1" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"/>
    
    <Resource name="jdbc/axio-bi-cache" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_BI1"
              username="REC_V6_MINOR_BI1" password="REC_V6_MINOR_BI1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>
    <!--This is where the BI reads the real time data coming unaggregaged from the axiodis database-->
    <Resource name="jdbc/axio-bi-operational" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_AX1"
              username="REC_V6_MINOR_AX1" password="REC_V6_MINOR_AX1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>
    <!--This is where the BI reads the MIA flux aggregaged data from the Infocenter database-->
    <Resource name="jdbc/axio-bi-reporting" auth="Container"
              type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://GCSQL01:1533;databaseName=REC_V6_MINOR_IC1"
              username="REC_V6_MINOR_IC1" password="REC_V6_MINOR_IC1" maxTotal="64" maxIdle="8" maxWaitMillis="-1"/>

    <Resource name="wm/BiWorkManager" auth="Container"
              type="commonj.work.WorkManager" factory="de.myfoo.commonj.work.FooWorkManagerFactory" maxThreads="8"/>


	<Resources cacheMaxSize="100000" cachingAllowed="true"/>

    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>

    <Manager pathname=""/>
	
	<Environment name="axio/messages" type="java.lang.String" value="file:C:/Program Files/Optilogistic/Axiodis6/REC_V6_MINOR_AX1/messages"/>

	<Environment name="axio/config" type="java.lang.String" value="file:C:/Program Files/Optilogistic/Axiodis6/REC_V6_MINOR_AX1/conf"/>

<Resource auth="Container" mail.smtp.auth="true" mail.smtp.host="smtp.gmail.com" mail.smtp.port="587" mail.smtp.starttls.enable="true" mail.smtp.user="optilogistic@gmail.com" name="mail/axio" password="axiodis2011" type="javax.mail.Session"/>
			
	<Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" maxIdle="30" maxTotal="100" name="jdbc/axio" password="REC_V6_MINOR_AX1" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://GCSQL01:1533/REC_V6_MINOR_AX1" username="REC_V6_MINOR_AX1" validationQuery="select 1"/>
	
	<Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" maxIdle="30" maxTotal="100" name="jdbc/axio-tasks" password="REC_V6_MINOR_AX1" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://GCSQL01:1533/REC_V6_MINOR_AX1" username="REC_V6_MINOR_AX1" validationQuery="select 1"/>
	
	<Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" maxIdle="30" maxTotal="100" name="jdbc/axio-mobil" password="REC_V6_MINOR_AX1" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://GCSQL01:1533/REC_V6_MINOR_AX1" username="REC_V6_MINOR_AX1" validationQuery="select 1"/>

</Context>