I am not using Oracle XE.
Regards
Senthil
On Fri, Jul 16, 2010 at 9:31 PM, Andrea Aime <[email protected]> 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.
>
------------------------------------------------------------------------------
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
