Hi all,
Today another issue found with Oracle in GeoServer as below logs:
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:2471)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:813)
When i searched in Oracle forum that this issue has been fixed already in latest jdbc driver. Currently Geo-Server Oracle plugin released ojdbc14.jar which is 10.2.0.2.0 version:
Specification-Title: Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Implementation-Title: ojdbc14.jar
Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - “10.2.0.2.0”
Implementation-Version: Oracle JDBC Driver version - “10.2.0.2.0”
Implementation-Vendor: Oracle Corporation
Implementation-Time: Tue Jan 24 08:55:21 2006
As long as Geo-Server requires Java 1.5 or latter version, it could released with latest version of Oracle JDBC driver…ojdbc5.jar from Oracle 11g release 2.
I have updated geoserver with latest oracle jdbc jar and monitoring for any issues.
Regards
Senthil
Senthil ha scritto:
Hi all,
Today another issue found with Oracle in GeoServer as below logs:
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:2471)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:813)
When i searched in Oracle forum that this issue has been fixed already in latest jdbc driver. Currently Geo-Server Oracle plugin released ojdbc14.jar which is 10.2.0.2.0 version:
Specification-Title: Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Implementation-Title: ojdbc14.jar
Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - "*10.2.0.2.0*"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.2.0"
Implementation-Vendor: Oracle Corporation
Implementation-Time: Tue Jan 24 08:55:21 2006
As long as Geo-Server requires Java 1.5 or latter version, it could released with latest version of Oracle JDBC driver...ojdbc5.jar from Oracle 11g release 2.
I have updated geoserver with latest oracle jdbc jar and monitoring for any issues.
Interesting. Wondering if that latest driver works fine with Oracle XE
as well
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
I am not using Oracle XE.
Regards
Senthil
On Fri, Jul 16, 2010 at 9:31 PM, Andrea Aime <aaime@anonymised.com> wrote:
Senthil ha scritto:
Hi all,
Today another issue found with Oracle in GeoServer as below logs:
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:2471)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:813)
When i searched in Oracle forum that this issue has been fixed already in latest jdbc driver. Currently Geo-Server Oracle plugin released ojdbc14.jar which is 10.2.0.2.0 version:
Specification-Title: Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Implementation-Title: ojdbc14.jar
Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - “10.2.0.2.0”
Implementation-Version: Oracle JDBC Driver version - “10.2.0.2.0”
Implementation-Vendor: Oracle Corporation
Implementation-Time: Tue Jan 24 08:55:21 2006
As long as Geo-Server requires Java 1.5 or latter version, it could released with latest version of Oracle JDBC driver…ojdbc5.jar from Oracle 11g release 2.
I have updated geoserver with latest oracle jdbc jar and monitoring for any issues.
Interesting. Wondering if that latest driver works fine with Oracle XE
as well
Cheers
Andrea
–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Senthil ha scritto:
I am not using Oracle XE.
But I am, and I'm the Oracle data store maintainer. If it does not work
for me I cannot include it in the distribution 
I don't have time to look into this now, and I'll be away for the next
two weeks, please remind me to double check when I come back in August.
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi Andrea
This email for remind on oracle driver update and found similar issue with JNDI datasource conflict with plugin jdbc driver with tomcat jdbc driver, which may need to noted. http://jira.codehaus.org/browse/GEOS-3986
regards
Senthil
On Fri, Jul 16, 2010 at 9:40 PM, Andrea Aime <aaime@anonymised.com> wrote:
Senthil ha scritto:
I am not using Oracle XE.
But I am, and I’m the Oracle data store maintainer. If it does not work
for me I cannot include it in the distribution
I don’t have time to look into this now, and I’ll be away for the next
two weeks, please remind me to double check when I come back in August.
Cheers
Andrea
–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.