Hi,
Thanks for the reply. I'm using OCI, Could you please advice what other libraries I will need to add? I couldn't find a place to attach Server.xml file, So I had to copy it here.
Thanks.
S.J
<?xml version='1.0' encoding='utf-8'?>

<Server port='8005' shutdown='SHUTDOWN'>
<Listener className='org.apache.catalina.core.AprLifecycleListener' SSLEngine='on' />
<Listener className='org.apache.catalina.core.JasperListener' />
<Listener className='org.apache.catalina.core.JreMemoryLeakPreventionListener' />
<Listener className='org.apache.catalina.mbeans.GlobalResourcesLifecycleListener' />
<Listener className='org.apache.catalina.core.ThreadLocalLeakPreventionListener' />
<GlobalNamingResources>
<Resource auth='Container' driverClassName='com.mysql.jdbc.Driver'
maxActive='20' maxIdle='10' maxWait='-1' name='jdbc/spagobi'
password='xxx' type='javax.sql.DataSource'
url='jdbc:mysql://localhost:3306/spagobi' username='xx'/>
<Resource name='UserDatabase' auth='Container'
type='org.apache.catalina.UserDatabase'
description='User database that can be updated and saved'
factory='org.apache.catalina.users.MemoryUserDatabaseFactory'
pathname='conf/tomcat-users.xml' />
<Environment name='spagobi_resource_path' type='java.lang.String' value='${catalina.base}/resources'/>
<Environment name='spagobi_sso_class' type='java.lang.String' value='it.eng.spagobi.services.common.FakeSsoService'/>
<Environment name='spagobi_service_url' type='java.lang.String' value='http://localhost:8080/SpagoBI'/>
<Environment name='spagobi_host_url' type='java.lang.String' value='http://localhost:8080'/>
<Resource name='jdbc/bidb' auth='Container'
type='javax.sql.DataSource' driverClassName='com.mysql.jdbc.Driver'
url='jdbc:mysql://localhost:3306/bidb'
username='xx' password='xx' maxActive='20' maxIdle='10'
maxWait='-1'/>
<Resource name='jdbc/piers' auth='Container'
type='javax.sql.DataSource' driverClassName='oracle.jdbc.driver.OracleDriver'
url='jdbc:oracle:oci8:@pdeai'
username='xxxx' password='xxx' maxActive='20' maxIdle='10'
maxWait='-1'/>
<Resource name='jdbc/foodmart' auth='Container'
type='javax.sql.DataSource' driverClassName='com.mysql.jdbc.Driver'
url='jdbc:mysql://vmx9116.cofc.gov.calgary.ab.ca:3306/sifoodmart'
username='xxxx' password='xxxx' maxActive='20' maxIdle='10'
maxWait='-1'/>
<Resource name='jdbc/bam' auth='Container'
type='javax.sql.DataSource' driverClassName='com.mysql.jdbc.Driver'
url='jdbc:mysql://localhost/bam'
username='xxxx' password='xxx' maxActive='20' maxIdle='10'
maxWait='-1'/>
<Resource auth='Container' factory='de.myfoo.commonj.work.FooWorkManagerFactory'
maxThreads='5' name='wm/SpagoWorkManager'
type='commonj.work.WorkManager'/>
</GlobalNamingResources>
<Service name='Catalina'>
<Connector port='8080' protocol='HTTP/1.1'
connectionTimeout='20000'
redirectPort='8443'
URIEncoding='UTF-8'
/>

<Connector port='8009' URIEncoding='UTF-8' protocol='AJP/1.3' redirectPort='8443' />
<Engine name='Catalina' defaultHost='localhost'>

<Realm className='org.apache.catalina.realm.LockOutRealm'>

<Realm className='org.apache.catalina.realm.UserDatabaseRealm'
resourceName='UserDatabase'/>
</Realm>
<Host name='localhost' appBase='webapps'
unpackWARs='true' autoDeploy='true'>
<Valve className='org.apache.catalina.valves.AccessLogValve' directory='logs'
prefix='localhost_access_log.' suffix='.txt'
pattern='%h %l %u %t '%r' %s %b' />
</Host>
</Engine>
</Service>
</Server>

This message was edited 1 time. Last update was at 22/06/2015 16:03:40

No Ocijdbc18 In Java Library Path Mac Os

No ocijdbc18 in java library path macbook

No Ocijdbc18 In Java Library Path Machine

OCI applications, by default, look for the OCI Data Shared Library, libociei.so (or Oraociei119.dll on Windows) in the runtime library search path (for example LDLIBRARYPATH on Linux, or PATH on Windows) to determine if the application should operate in the Instant Client mode. 3 cp your libxxx.so into the java.library.path. Java 一般使用两个path：classpath 和 java.library.path. Java.library.path是非java类包的位置如（dll,so）解决办法：第一种方法，在代码里设置环境变量. 第二种方法：执行时在vm arguments里添加-Djava.library.path.