Issue Details (XML | Word | Printable)

Key: NUCSPATIAL-35
Type: New Unit Test New Unit Test
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Baris ERGUN
Reporter: Baris ERGUN
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Types : Geospatial

Oracle Unit Tests

Created: 07/Jan/14 10:06 AM   Updated: 01/Mar/14 07:40 PM  Due: 17/Jan/14   Resolved: 04/Feb/14 09:17 PM
Component/s: None
Affects Version/s: 3.2.5
Fix Version/s: 3.2.7

Datastore: Oracle
Severity: Test/Acceptance


 Description  « Hide
Existing unit tests are only for Postgresql and Mysql(+Mariadb). In this scope I will run existing test cases against Oracle Spatial db. Of course taking into account spatial methods supported by Oracle Spatial.

Sort Order: Ascending order - Click to sort in descending order
Baris ERGUN added a comment - 18/Jan/14 03:25 PM
I will run the Oracle tests against 11G and will update the oracle jdbc driver , sdoapi etc regarding that version.

Baris ERGUN added a comment - 22/Jan/14 09:21 PM
Instead of using Connection from prepared statement

- Object obj = JGeometry.store((JGeometry)value, ((PreparedStatement)ps).getConnection());

we need to get underlying connnection which is OracleConnection in our case.

+ Object obj = JGeometry.store((JGeometry) value, ((PreparedStatement) ps).getConnection().unwrap(OracleConnection.class));

Otherwise we get ClassCastException

java.lang.ClassCastException: org.datanucleus.store.rdbms.datasource.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection

will apply the change on /src/java/org/datanucleus/store/rdbms/mapping/jgeom2oracle/JGeometryRDBMSMapping.java

Baris ERGUN added a comment - 04/Feb/14 09:17 PM
All tests pass against 11.2.0.4 version of Oracle Enterprise 11G server.