Build responsibility feature does not work properly on Oracle database
After upgrading Bamboo instance from older versions prior to 4.1, a error appears in the Bamboo logs whenever a build fails:
Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor2313.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.activeobjects.spi.ConnectionHandler.delegate(ConnectionHandler.java:42) at com.atlassian.activeobjects.spi.ConnectionHandler.invoke(ConnectionHandler.java:37) ... 159 more Caused by: java.sql.SQLException: Unsupported feature at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:537) at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3091) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:15
The following screenshots elaborate the issue:
The Broken Build Responsibility Tracker, uses the active object framework for persisting data which is having some problems to work properly on Oracle. We have raised a bug report -
We have tracked this issue and noticed that the problem is caused by incompatible JDBC driver and/or the ORACLE version. Bamboo 4.1 and above should be compatible with ORACLE 11G on JDBC driver 188.8.131.52. We have observed that the same version of the driver works on ORACLE 10G. Please note that 10G however is not supported in BAMBOO 4.1 and later versions; upgrade the database.