JIRA with Oracle 11g

[Radu Popescu]

RE this thread, I am standing up a JIRA 3.13 in dev to prepare for upgrade, and using Oracle 11g on the backend. The thread just mentioned describes two files to edit: entityengine.xml and jira-ds.xml.

I do not have a jira-ds.xml; rather, I have a server.xml (in the conf dir) that also contains the JDBC and db login info. do I need a jira-ds.xml file? If yes, where do I put it?

Also, the db URL seems to be in two places: entityengine.xml and server.xml; is this ok, or should it be just in one?

Thanks.

[tier-0 grump]

Whoops - didn't look at your version properly - try oracle10g, and if that's still not found plain oracle

[Radu Popescu]

10g works, but there is another issue:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'

.

.

.

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

[Radu Popescu]

It is that it cannor find the driver? It's in:

<jira_home>./common/lib/.

This is the correct location, right?

[tier-0 grump]

The reason that thread taks about jir-ds is that they were using JBoss - so you should edit it in server.xml.

All that is needed in the entity engine.xml is a reference to the jndi url that you define in server.xml. So you should have

entityengine.xml

<datasource name="defaultDS"
field-type-name="oracle11g"
schema-name="JIRA_GTC"
helper-class="org.ofbiz.core.entity.GenericHelperDAO"

check-on-start="true"
use-foreign-keys="false"
use-foreign-key-indices="false"
check-fks-on-start="false"
check-fk-indices-on-start="false"
add-missing-on-start="true"
check-indices-on-start="true">

<jndi-jdbc jndi-server-name="default" jndi-name="java:comp/env/jdbc/JiraDS"/>

server.xml

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
username="<username>"
password="<password>"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@<hostname>:<port number>:<SID>"
connectionProperties="SetBigStringTryClob=true"
maxActive="20"/>

Cheers

[Radu Popescu]

Thanks, James. I get the error below in the catalina.out file.

Where could I add a valid 'oracle11g' field-type name?

java.lang.IllegalStateException: Could not find a field-type definition with name "oracle11g"