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. ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
