Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 362592

Summary:	DCNTestSuite failed with OCI driver and thin drivers prior to version 11.2
Product:	z_Archived	Reporter:	Edwin Tang <edwin.tang>
Component:	Eclipselink	Assignee:	Project Inbox <eclipselink.foundation-inbox>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	P3	CC:	jamesssss, martin.grebac
Version:	unspecified	Keywords:	test
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Whiteboard:
Bug Depends on:
Bug Blocks:	454799

Description Edwin Tang

2011-11-01 15:16:11 EDT

The DCNTestSuite(for Database Change Notification) failed with OCI driver and thin drivers prior to version 11.2.

Error Message:
==============
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20111027-r10284): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Unsupported feature Error Code: 17023

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20111027-r10284): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Unsupported feature
Error Code: 17023
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:518)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.getDatabaseSession(JUnitTestCase.java:434)
at org.eclipse.persistence.testing.tests.jpa.dcn.DCNTestSuite.testSetup(DCNTestSuite.java:76)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:584)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20111027-r10284): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Unsupported feature
Error Code: 17023
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:147)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:723)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:653)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:208)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:489)
Caused by: java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.PhysicalConnection.doRegisterDatabaseChangeNotification(PhysicalConnection.java:10535)
at oracle.jdbc.driver.PhysicalConnection.registerDatabaseChangeNotification(PhysicalConnection.java:10417)
at oracle.jdbc.driver.T2CConnection.registerDatabaseChangeNotification(T2CConnection.java:47)
at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:104)

Comment 1 Edwin Tang

2011-11-01 15:20:55 EDT

OCI driver and thin driver prior to version 11.2 don't support this feature. The  DCNTestSuite needs to detect driver type and version, and skip the tests if necessary.

Comment 2 Eclipse Webmaster

2022-06-09 10:04:14 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink