Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. ... [java] INFO: EclipseLink, version: Eclipse Persistence Services - 2.6.0.v20130710-0f21df0 ... [java] WARNING: [java] java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:12 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:12 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:12 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:12 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:13 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29973: Unsupported query or operation during change notification registration [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:13 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29973: Unsupported query or operation during change notification registration [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:13 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:14 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:14 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:14 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:15 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:15 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:15 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:15 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:15 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin.sql [java] WARNING: [java] java.sql.SQLException: ORA-29983: Unsupported query for Continuous Query Notification [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [java] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) [java] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) [java] at org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener.register(OracleChangeNotificationListener.java:136) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:843) [java] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:752) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:241) [java] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337) [java] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303) [java] at ca.mcgill.ncs.starfinder.StarFinder.connectDatabase(StarFinder.java:4264) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:340) [java] Jul 11, 2013 5:18:16 PM org.eclipse.persistence.session.file:/C:/temp/starfinder/dist/StarFinder_V1_00.jar_DMAIN.MCGILL.CA_user=dev_admin [java] WARNING: [java] Local Exception Stack: [java] Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20130710-0f21df0): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] Error Code: 1446 [java] Call: SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?)) [java] bind => [6 parameters bound] [java] Query: ReadAllQuery(name="UserRolePrivilege.fetchAllRoles" referenceClass=UserRolePrivilege sql="SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?))") [java] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1989) [java] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) [java] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:250) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2737) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2690) [java] at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:502) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1171) [java] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1130) [java] at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3201) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1791) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1773) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1738) [java] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) [java] at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:469) [java] at ca.mcgill.ncs.security.PrivilegeManager.loadUserRoles(PrivilegeManager.java:49) [java] at ca.mcgill.ncs.security.PrivilegeManager.(PrivilegeManager.java:36) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:356) [java] Caused by: java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) [java] ... 24 more [java] java.lang.ExceptionInInitializerError [java] Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20130710-0f21df0): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] Error Code: 1446 [java] Call: SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?)) [java] bind => [6 parameters bound] [java] Query: ReadAllQuery(name="UserRolePrivilege.fetchAllRoles" referenceClass=UserRolePrivilege sql="SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?))") [java] at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:378) [java] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260) [java] at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:469) [java] at ca.mcgill.ncs.security.PrivilegeManager.loadUserRoles(PrivilegeManager.java:49) [java] at ca.mcgill.ncs.security.PrivilegeManager.(PrivilegeManager.java:36) [java] at ca.mcgill.ncs.starfinder.StarFinder.(StarFinder.java:356) [java] Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20130710-0f21df0): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] Error Code: 1446 [java] Call: SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?)) [java] bind => [6 parameters bound] [java] Query: ReadAllQuery(name="UserRolePrivilege.fetchAllRoles" referenceClass=UserRolePrivilege sql="SELECT ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED, USERNAME, GRANTED_ROLE, ROWID, ROWID FROM SYS.USER_ROLE_PRIVS WHERE (GRANTED_ROLE IN (?, ?, ?, ?, ?, ?))") [java] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1989) [java] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) [java] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:250) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2737) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2690) [java] at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:502) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1171) [java] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1130) [java] at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3201) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1791) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1773) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1738) [java] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) [java] ... 4 more [java] Caused by: java.sql.SQLException: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) [java] ... 24 more