Jira doesn't run on SUN ONE

jira won't work on sun one. i'm describing my attempt to install and configure.

jira sunone installation
========================
this describes installing jira 2.4.1 on sun one application server 7 using Oracle 9i.

0) follow atlassian install guide to configure jira for oracle.

1) configure the sun one instance's "server.policy" file as follows:
1.1) add the following to domains/[domain]/[server]/config/server.policy":
---------------------------------------------------------------------
grant

{ permission java.security.AllPermission; }

;
----------------------------------------------------------------------

This basically just turns on all security permissions (e.g. write to filesystem, set system property) to avoid trouble with the server.

2) add the jdbc driver to the server classpath
2.1) hit the admin console at http://host:4848 and log in
2.2) click on your server instance under "app server instances" in the
2.3) click on "JVM settings"
2.4) click on "path settings"
2.5) add the location of your tier 4 jdbc driver jar (e.g. ojdbc14.jar) under "classpath suffix".

3) create oracle connection pool "jdbc/JiraOraclePool" on the admin console using these parameters:
3.1) DataSource classname: "oracle.jdbc.pool.OracleDataSource"
3.2) Transaction isolation: "serializable"
3.2) Properties:
3.2.1) "URL" "jdbc:oracle:thin:@host:port:sid"
3.2.2) "user" "username"
3.2.3) "password" "password"

4) create datasource "jdbc/JiraDS" using "jdbc/JiraOraclePool" on the admin console
4.1) hit "jdbc/jdbc resources" and click new
4.2) enter "jdbc/JiraDS" as jndi name
4.3) select "jdbc/JiraOraclePool" from pool name combo box.

5) deploy as war file on the admin console
5.1) click on "server instance"/applications/web apps/
5.2) hit "deploy" and browse for war file.
5.3) specify "context-root"

This happened
=============

When trying to access Jira it produces the following stracktrace on the server console.

From what I read:
1) Jira uses SiteMesh's com.opensymphony.module.sitemesh.util.Container class to do servlet container detection and thinks Sun ONE is Tomcat.

2) Looking into SiteMesh, this seems to be caused by trying to classload org.apache.jasper.runtime.JspFactoryImpl".

3) Sun ONE's servlet engine is indeed based on Tomcat (or is in fact? I don't know). The appserver runtime jar is full of tomcat classes anyway.

4) Based on this detection, JIRA then turns of transactions and the jdbc driver starts complaining.

StackTrace
==========
--------------------------------------------------------------------------
INFO: CORE3282: stdout: 2003-10-20 14:16:45,070 WARN [atlassian.jira.upgrade.ConsistencyCheckImpl] Detected that you are using Tomcat - turned off all transactions.
INFO: CORE3282: stdout: 2003-10-20 14:17:13,902 ERROR [core.entity.jdbc.DatabaseUtil] Unable to esablish a connection wi th the database... Error was:java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

INFO: CORE3282: stdout: 2003-10-20 14:17:13,902 ERROR [core.entity.jdbc.DatabaseUtil] Could not get table name informati on from the database, aborting.
WARNING: CORE3283: stderr: Could not connect to database. Check your entityengine.xml settings: org.ofbiz.core.entity.Ge
nericDataSourceException: Unable to esablish a connection with the database. (ORA-01453: SET TRANSACTION must be first s tatement of transaction
WARNING: CORE3283: stderr: )
WARNING: CORE3283: stderr: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the da tabase. (ORA-01453: SET TRANSACTION must be first statement of transaction
WARNING: CORE3283: stderr: )
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:213)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:283)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
WARNING: CORE3283: stderr: at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:696)
WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConnection(ConsistencyCheckImpl.
java:144)
WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl
.java:90)
WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:
81)
WARNING: CORE3283: stderr: at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher
.java:18)
WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3255)
WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardContext.start(StandardContext.java:3575)
WARNING: CORE3283: stderr: at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
WARNING: CORE3283: stderr: at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
WARNING: CORE3283: stderr: at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:345)
WARNING: CORE3283: stderr: at org.apache.catalina.startup.Embedded.start(Embedded.java:957)
WARNING: CORE3283: stderr: at com.iplanet.ias.web.WebContainer.start(WebContainer.java:426)
WARNING: CORE3283: stderr: at com.iplanet.ias.web.WebContainer.startInstance(WebContainer.java:514)
WARNING: CORE3283: stderr: at com.iplanet.ias.server.J2EERunner.confPostInit(J2EERunner.java:170)
-------------------------------------------------------------------------