https://issues.apache.org/bugzilla/show_bug.cgi?id=50326

           Summary: Problem with DBCP 1.3 /jdk 6 and oracle spatial
           Product: Tomcat 5
           Version: 5.5.30
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Catalina
        AssignedTo: dev@tomcat.apache.org
        ReportedBy: nils.hildebr...@bamf.bund.de


Hi,

we have a GIS-application running on Tomcat 5.5. As webserver we are using
Apache httpd 2.2 connected to tomcat via ajp (mod_proxy_ajp).

OS is Linux (CentOS 5.5 x86_64).

As database we use a oracle-db release 10.2. Connection works fine with
ojdbc5/6.jar - even the old ojdbc14.jar works.

The application worked fine with Tomcat 5.5.28, sun jdk 1.5_22 and oracle jdk
6u22 until we tried to upgrade to tomcat 5.5.31.

After the upgrade we get - in certain situations a:
java.io.IOException: org.hibernatespatial.helper.FinderException: Couldn't get
at the OracleSpatial Connection object from the PreparedStatement.

After looking through the Tomcat 5.5 changelogs we stumbled across a change
made in 5.5.30: Upgrade to DBCP 1.3.

We tried to narrow down the problem by downgrading to Tomcat 5.5.29 - the error
was gone. Then Upgrade to 5.5.30: The error is back.

We took a closer look at the db-connector: oracle.jdbc.driver.OracleDriver was
in use, so we changed this to oracle.jdbc.OracleDriver - nevertheless - the
error remains.

When looking at DBCP we found on http://commons.apache.org/dbcp/: 

DBCP 1.4 binaries should be used by applications running under JDK 1.6.
DBCP 1.3 should be used when running under JDK 1.4 or 1.5."

Now Tomcat should run with jdk 1.5 and jdk 1.6 (and worked fine with the dbcp
1.2.x as it seems). This seems to be a bug here.

Since jdk 1.5 has reached EoL I think a proper solution would be to update dbcp
to 1.4 in Tomcat 5.5 - or fix dbcp 1.3 so it is compatible with jdk 1.6. Else
the statement that 5.5 runs with jdk 1.5 or higher is no longer true.

I could not test our current application with Tomcat 5.5.31 and jdk 1.5 since
it is compiled now against jdk 1.6 and won't work with jdk 1.5 any longer. 


Kind regards

Nils

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org

Reply via email to