Buildfile: build_oc.xml microsoftdd: [echo] So you are using microsoft datadirect driver..! setdefaultmode: [echo] So you are using Platform Edition print-props: [echo] admin.user=admin [echo] admin.port=4848 [echo] admin.domain=domain1 [echo] appserver.instance.name=server setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: [echo] Workaround for early v3: create directories... setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: setup: [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/descriptor build: [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes [javac] Compiling 5 source files to /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes [javac] Compiling 1 source file to /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes/META-INF [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes/META-INF run: [java] [EL Config]: 2009-09-21 23:33:24.699--ServerSession(19356985)--Thread(Thread[main,5,main])--The access type for the persistent class [class Person] is set to [PROPERTY]. [java] [EL Config]: 2009-09-21 23:33:24.752--ServerSession(19356985)--Thread(Thread[main,5,main])--The alias name for the entity class [class Person] is being defaulted to: Person. [java] [EL Config]: 2009-09-21 23:33:24.915--ServerSession(19356985)--Thread(Thread[main,5,main])--The access type for the persistent class [class NaturalPerson] is set to [PROPERTY]. [java] [EL Config]: 2009-09-21 23:33:24.916--ServerSession(19356985)--Thread(Thread[main,5,main])--The alias name for the entity class [class NaturalPerson] is being defaulted to: NaturalPerson. [java] [EL Config]: 2009-09-21 23:33:24.992--ServerSession(19356985)--Thread(Thread[main,5,main])--The target entity (reference) class for the many to many mapping element [method getChildren] is being defaulted to: class NaturalPerson. [java] [EL Config]: 2009-09-21 23:33:25.005--ServerSession(19356985)--Thread(Thread[main,5,main])--The access type for the persistent class [class PersonPK] is set to [PROPERTY]. [java] [EL Config]: 2009-09-21 23:33:25.013--ServerSession(19356985)--Thread(Thread[main,5,main])--The table name for entity [class Person] is being defaulted to: PERSON. [java] [EL Config]: 2009-09-21 23:33:25.048--ServerSession(19356985)--Thread(Thread[main,5,main])--The discriminator column name for the root inheritance class [class Person] is being defaulted to: DTYPE. [java] [EL Config]: 2009-09-21 23:33:25.143--ServerSession(19356985)--Thread(Thread[main,5,main])--The column name for element [method getPk1] is being defaulted to: PK1. [java] [EL Config]: 2009-09-21 23:33:25.186--ServerSession(19356985)--Thread(Thread[main,5,main])--The column name for element [method getName] is being defaulted to: NAME. [java] [EL Config]: 2009-09-21 23:33:25.192--ServerSession(19356985)--Thread(Thread[main,5,main])--The table name for entity [class NaturalPerson] is being defaulted to: NATURALPERSON. [java] [EL Config]: 2009-09-21 23:33:25.206--ServerSession(19356985)--Thread(Thread[main,5,main])--The primary key column name for the inheritance class [class NaturalPerson] is being defaulted to: PK1. [java] [EL Config]: 2009-09-21 23:33:25.208--ServerSession(19356985)--Thread(Thread[main,5,main])--The foreign key column name for the inheritance class [class NaturalPerson] is being defaulted to: PK1. [java] [EL Config]: 2009-09-21 23:33:25.209--ServerSession(19356985)--Thread(Thread[main,5,main])--The column name for element [method getExt1] is being defaulted to: EXT1. [java] [EL Config]: 2009-09-21 23:33:25.407--ServerSession(19356985)--Thread(Thread[main,5,main])--Class NaturalPerson could not be weaved for change tracking as it is not supported by its mappings. [java] WS HOME appserver-sqe [java] [EL Info]: 2009-09-21 23:33:27.866--ServerSession(19356985)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.0.0.v20090821-r4934 [java] [EL Fine]: 2009-09-21 23:33:29.551--Thread(Thread[main,5,main])--Detected Vendor platform: org.eclipse.persistence.platform.database.SQLServerPlatform [java] [EL Config]: 2009-09-21 23:33:29.631--ServerSession(19356985)--Connection(20263497)--Thread(Thread[main,5,main])--connecting(DatabaseLogin( [java] platform=>SQLServerPlatform [java] user name=> "coretest1" [java] datasource URL=> "jdbc:sun:sqlserver://jsepc02.east.sun.com:1433;SID=coretest1" [java] )) [java] [EL Config]: 2009-09-21 23:33:30.315--ServerSession(19356985)--Connection(9199266)--Thread(Thread[main,5,main])--Connected: jdbc:sun:sqlserver://jsepc02.east.sun.com:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1000;DATABASENAME=;MAXPOOLEDSTATEMENTS=0;PROGRAMID=;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVERRIDE=;DESCRIBEPARAMETERS=noDescribe;CONNECTIONRETRYCOUNT=5;ENABLEBULKLOAD=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;FAILOVERPRECONNECT=false;USESERVERSIDEUPDATABLECURSORS=false;ALWAYSREPORTTRIGGERRESULTS=false;RESULTSETMETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;FAILOVERGRANULARITY=nonAtomic;HOSTNAMEINCERTIFICATE=;CATALOGINCLUDESSYNONYMS=true;SNAPSHOTSERIALIZABLE=false;APPLICATIONNAME=;JAVADOUBLETOSTRING=false;SENDSTRINGPARAMETERSASUNICODE=true;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;PROGRAMNAME=;NETADDRESS=000000000000;ALTERNATESERVERS=;WSID=;TRUNCATEFRACTIONALSECONDS=true;ENCRYPTIONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTORE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHENTICATIONMETHOD=auto;LOGINTIMEOUT=0;FETCHTWFSASTIME=false;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;SID=coretest1;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;RECEIVESTRINGPARAMETERTYPE=nvarchar;PACKETSIZE=-1;CLIENTHOSTNAME=;DEFAULTSCALE=4;XMLDESCRIBETYPE=;FETCHTSWTZASTIMESTAMP=false;SELECTMETHOD=direct [java] User: dbo [java] Database: Microsoft SQL Server Version: Microsoft SQL Server Yukon - 10.0.1600 [java] Driver: SQLServer Version: 4.0.023606 (040313.014801) [java] [EL Config]: 2009-09-21 23:33:30.316--ServerSession(19356985)--Connection(26795772)--Thread(Thread[main,5,main])--connecting(DatabaseLogin( [java] platform=>SQLServerPlatform [java] user name=> "coretest1" [java] datasource URL=> "jdbc:sun:sqlserver://jsepc02.east.sun.com:1433;SID=coretest1" [java] )) [java] [EL Config]: 2009-09-21 23:33:31.017--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--Connected: jdbc:sun:sqlserver://jsepc02.east.sun.com:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1000;DATABASENAME=;MAXPOOLEDSTATEMENTS=0;PROGRAMID=;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVERRIDE=;DESCRIBEPARAMETERS=noDescribe;CONNECTIONRETRYCOUNT=5;ENABLEBULKLOAD=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;FAILOVERPRECONNECT=false;USESERVERSIDEUPDATABLECURSORS=false;ALWAYSREPORTTRIGGERRESULTS=false;RESULTSETMETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;FAILOVERGRANULARITY=nonAtomic;HOSTNAMEINCERTIFICATE=;CATALOGINCLUDESSYNONYMS=true;SNAPSHOTSERIALIZABLE=false;APPLICATIONNAME=;JAVADOUBLETOSTRING=false;SENDSTRINGPARAMETERSASUNICODE=true;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;PROGRAMNAME=;NETADDRESS=000000000000;ALTERNATESERVERS=;WSID=;TRUNCATEFRACTIONALSECONDS=true;ENCRYPTIONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTORE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHENTICATIONMETHOD=auto;LOGINTIMEOUT=0;FETCHTWFSASTIME=false;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;SID=coretest1;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;RECEIVESTRINGPARAMETERTYPE=nvarchar;PACKETSIZE=-1;CLIENTHOSTNAME=;DEFAULTSCALE=4;XMLDESCRIBETYPE=;FETCHTSWTZASTIMESTAMP=false;SELECTMETHOD=direct [java] User: dbo [java] Database: Microsoft SQL Server Version: Microsoft SQL Server Yukon - 10.0.1600 [java] Driver: SQLServer Version: 4.0.023606 (040313.014801) [java] [EL Info]: 2009-09-21 23:33:31.208--ServerSession(19356985)--Thread(Thread[main,5,main])--file:/space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes/-manager login successful [java] [EL Fine]: 2009-09-21 23:33:31.28--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--ALTER TABLE NATURALPERSON DROP CONSTRAINT FK_NATURALPERSON_PK1 [java] [EL Fine]: 2009-09-21 23:33:31.604--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:31.833--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]'FK_NATURALPERSON_PK1' is not a constraint. [java] Error Code: 3728 [java] Call: ALTER TABLE NATURALPERSON DROP CONSTRAINT FK_NATURALPERSON_PK1 [java] Query: DataModifyQuery(sql="ALTER TABLE NATURALPERSON DROP CONSTRAINT FK_NATURALPERSON_PK1") [java] [EL Fine]: 2009-09-21 23:33:31.847--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_C_ID1 [java] [EL Fine]: 2009-09-21 23:33:31.943--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:32.13--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]'PARENT_CHILDREN_C_ID1' is not a constraint. [java] Error Code: 3728 [java] Call: ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_C_ID1 [java] Query: DataModifyQuery(sql="ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_C_ID1") [java] [EL Fine]: 2009-09-21 23:33:32.131--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_P_ID1 [java] [EL Fine]: 2009-09-21 23:33:32.226--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:32.412--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]'PARENT_CHILDREN_P_ID1' is not a constraint. [java] Error Code: 3728 [java] Call: ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_P_ID1 [java] Query: DataModifyQuery(sql="ALTER TABLE PARENT_CHILDREN DROP CONSTRAINT PARENT_CHILDREN_P_ID1") [java] [EL Fine]: 2009-09-21 23:33:32.414--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--DROP TABLE NATURALPERSON [java] [EL Fine]: 2009-09-21 23:33:32.612--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--CREATE TABLE NATURALPERSON (PK1 VARCHAR(255) NOT NULL, EXT1 VARCHAR(255) NULL, PRIMARY KEY (PK1)) [java] [EL Fine]: 2009-09-21 23:33:32.803--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--DROP TABLE PERSON [java] [EL Fine]: 2009-09-21 23:33:32.897--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:33.175--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]Could not drop object 'PERSON' because it is referenced by a FOREIGN KEY constraint. [java] Error Code: 3726 [java] Call: DROP TABLE PERSON [java] Query: DataModifyQuery(sql="DROP TABLE PERSON") [java] [EL Fine]: 2009-09-21 23:33:33.176--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--CREATE TABLE PERSON (DTYPE VARCHAR(31) NULL, NAME VARCHAR(255) NULL, PK1 VARCHAR(255) NOT NULL, PRIMARY KEY (PK1)) [java] [EL Fine]: 2009-09-21 23:33:33.273--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:33.458--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]There is already an object named 'PERSON' in the database. [java] Error Code: 2714 [java] Call: CREATE TABLE PERSON (DTYPE VARCHAR(31) NULL, NAME VARCHAR(255) NULL, PK1 VARCHAR(255) NOT NULL, PRIMARY KEY (PK1)) [java] Query: DataModifyQuery(sql="CREATE TABLE PERSON (DTYPE VARCHAR(31) NULL, NAME VARCHAR(255) NULL, PK1 VARCHAR(255) NOT NULL, PRIMARY KEY (PK1))") [java] [EL Fine]: 2009-09-21 23:33:33.459--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--DROP TABLE PARENT_CHILDREN [java] [EL Fine]: 2009-09-21 23:33:33.654--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--CREATE TABLE PARENT_CHILDREN (P_ID1 VARCHAR(255) NOT NULL, C_ID1 VARCHAR(255) NOT NULL, PRIMARY KEY (P_ID1, C_ID1)) [java] [EL Fine]: 2009-09-21 23:33:33.866--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--ALTER TABLE NATURALPERSON ADD CONSTRAINT FK_NATURALPERSON_PK1 FOREIGN KEY (PK1) REFERENCES PERSON (PK1) [java] [EL Fine]: 2009-09-21 23:33:33.963--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:34.152--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]Foreign key 'FK_NATURALPERSON_PK1' references invalid column 'PK1' in referenced table 'PERSON'. [java] Error Code: 1770 [java] Call: ALTER TABLE NATURALPERSON ADD CONSTRAINT FK_NATURALPERSON_PK1 FOREIGN KEY (PK1) REFERENCES PERSON (PK1) [java] Query: DataModifyQuery(sql="ALTER TABLE NATURALPERSON ADD CONSTRAINT FK_NATURALPERSON_PK1 FOREIGN KEY (PK1) REFERENCES PERSON (PK1)") [java] [EL Fine]: 2009-09-21 23:33:34.153--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--ALTER TABLE PARENT_CHILDREN ADD CONSTRAINT PARENT_CHILDREN_C_ID1 FOREIGN KEY (C_ID1) REFERENCES PERSON (PK1) [java] [EL Fine]: 2009-09-21 23:33:34.249--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:34.434--ServerSession(19356985)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]Foreign key 'PARENT_CHILDREN_C_ID1' references invalid column 'PK1' in referenced table 'PERSON'. [java] Error Code: 1770 [java] Call: ALTER TABLE PARENT_CHILDREN ADD CONSTRAINT PARENT_CHILDREN_C_ID1 FOREIGN KEY (C_ID1) REFERENCES PERSON (PK1) [java] Query: DataModifyQuery(sql="ALTER TABLE PARENT_CHILDREN ADD CONSTRAINT PARENT_CHILDREN_C_ID1 FOREIGN KEY (C_ID1) REFERENCES PERSON (PK1)") [java] [EL Fine]: 2009-09-21 23:33:34.577--ClientSession(610720)--Connection(19682353)--Thread(Thread[main,5,main])--INSERT INTO PERSON (NAME, PK1, DTYPE) VALUES (?, ?, ?) [java] bind => [person2, pk_p2, NaturalPerson] [java] [EL Fine]: 2009-09-21 23:33:34.773--ClientSession(610720)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:34.959--UnitOfWork(9097155)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'NAME'. [java] Error Code: 207 [java] Call: INSERT INTO PERSON (NAME, PK1, DTYPE) VALUES (?, ?, ?) [java] bind => [person2, pk_p2, NaturalPerson] [java] Query: InsertObjectQuery(NaturalPerson(name=person2, ext1=ext_p2)) [java] javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'NAME'. [java] Error Code: 207 [java] Call: INSERT INTO PERSON (NAME, PK1, DTYPE) VALUES (?, ?, ?) [java] bind => [person2, pk_p2, NaturalPerson] [java] Query: InsertObjectQuery(NaturalPerson(name=person2, ext1=ext_p2)) [java] at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102) [java] at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63) [java] at TestClient.create1(TestClient.java:50) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at TestClient.executeTest(TestClient.java:130) [java] at TestClient.main(TestClient.java:181) [java] Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'NAME'. [java] Error Code: 207 [java] Call: INSERT INTO PERSON (NAME, PK1, DTYPE) VALUES (?, ?, ?) [java] bind => [person2, pk_p2, NaturalPerson] [java] Query: InsertObjectQuery(NaturalPerson(name=person2, ext1=ext_p2)) [java] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:323) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:785) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:851) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:574) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:517) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:897) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:321) [java] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162) [java] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177) [java] at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:461) [java] at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) [java] at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) [java] at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:286) [java] at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) [java] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:670) [java] at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:589) [java] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:109) [java] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:86) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2864) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1208) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1150) [java] at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:197) [java] at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:103) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3229) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1400) [java] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:521) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505) [java] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:200) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1126) [java] at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84) [java] ... 8 more [java] Caused by: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'NAME'. [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.executeUpdateInternal(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.executeUpdate(Unknown Source) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:776) [java] ... 38 more [java] [EL Fine]: 2009-09-21 23:33:35.126--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] bind => [pk_p1] [java] [EL Fine]: 2009-09-21 23:33:35.315--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:35.502--UnitOfWork(33108879)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] Error Code: 207 [java] Call: SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] bind => [pk_p1] [java] Query: ReadObjectQuery(referenceClass=Person sql="SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?)") [java] Local Exception Stack: [java] Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] Error Code: 207 [java] Call: SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] bind => [pk_p1] [java] Query: ReadObjectQuery(referenceClass=Person sql="SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?)") [java] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:674) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:517) [java] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2564) [java] at org.eclipse.persistence.descriptors.InheritancePolicy.selectOneRowUsingDefaultMultipleTableSubclassRead(InheritancePolicy.java:1361) [java] at org.eclipse.persistence.descriptors.InheritancePolicy.selectOneRowUsingMultipleTableSubclassRead(InheritancePolicy.java:1391) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2532) [java] at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:431) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:997) [java] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:670) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:958) [java] at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:399) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1021) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2864) [java] [EL Fine]: 2009-09-21 23:33:35.506--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1208) [java] bind => [pk_p2] [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1150) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:646) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:590) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:494) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:373) [java] at TestClient.findPerson(TestClient.java:92) [java] at TestClient.find1(TestClient.java:66) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at TestClient.executeTest(TestClient.java:130) [java] at TestClient.main(TestClient.java:181) [java] Caused by: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.executeQueryInternal(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.executeQuery(Unknown Source) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:876) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:589) [java] ... 31 more [java] [EL Fine]: 2009-09-21 23:33:35.604--ServerSession(19356985)--Thread(Thread[main,5,main])--SELECT 1 [java] [EL Warning]: 2009-09-21 23:33:35.816--UnitOfWork(33108879)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] Error Code: 207 [java] Call: SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] bind => [pk_p2] [java] Query: ReadObjectQuery(referenceClass=Person sql="SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?)") [java] Local Exception Stack: [java] Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20090821-r4934): org.eclipse.persistence.exceptions.DatabaseException [java] Internal Exception: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] Error Code: 207 [java] Call: SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?) [java] bind => [pk_p2] [java] Query: ReadObjectQuery(referenceClass=Person sql="SELECT DISTINCT DTYPE FROM PERSON WHERE (PK1 = ?)") [java] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:674) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:517) [java] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191) [java] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2564) [java] at org.eclipse.persistence.descriptors.InheritancePolicy.selectOneRowUsingDefaultMultipleTableSubclassRead(InheritancePolicy.java:1361) [java] at org.eclipse.persistence.descriptors.InheritancePolicy.selectOneRowUsingMultipleTableSubclassRead(InheritancePolicy.java:1391) [java] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2532) [java] at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:431) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:997) [java] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:670) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:958) [java] at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:399) [java] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1021) [java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2864) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1208) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190) [java] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1150) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:646) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:590) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:494) [java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:373) [java] at TestClient.findPerson(TestClient.java:92) [java] at TestClient.find2(TestClient.java:80) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at TestClient.executeTest(TestClient.java:130) [java] at TestClient.main(TestClient.java:181) [java] Caused by: java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Invalid column name 'PK1'. [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) [java] at com.sun.sql.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BaseStatement.executeQueryInternal(Unknown Source) [java] at com.sun.sql.jdbc.sqlserverbase.BasePreparedStatement.executeQuery(Unknown Source) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:876) [java] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:589) [java] ... 31 more [java] Generating report at /space/test1/SRC/c10/appserver-sqe/test_results.xml [java] ----------------------------------------- [java] - JPA1-SE-J2DB-Issue1153-Basic:find1: FAIL - [java] - JPA1-SE-J2DB-Issue1153-Basic:create1: FAIL - [java] - JPA1-SE-J2DB-Issue1153-Basic:find2: FAIL - [java] ----------------------------------------- [java] Total PASS: 0 [java] Total FAIL: 3 [java] Total DNR: 0 [java] ----------------------------------------- [java] [EL Config]: 2009-09-21 23:33:36.11--ServerSession(19356985)--Connection(9199266)--Thread(Thread[main,5,main])--disconnect [java] [EL Info]: 2009-09-21 23:33:36.111--ServerSession(19356985)--Thread(Thread[main,5,main])--file:/space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes/-manager logout successful [java] [EL Config]: 2009-09-21 23:33:36.112--ServerSession(19356985)--Connection(20263497)--Thread(Thread[main,5,main])--disconnect [java] [EL Config]: 2009-09-21 23:33:36.112--ServerSession(19356985)--Connection(19682353)--Thread(Thread[main,5,main])--disconnect unsetup: [move] Moving 1 file to /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/descriptor clean: [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/classes [delete] Deleting: /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/createDDL.jdbc [delete] Deleting: /space/test1/SRC/c10/appserver-sqe/pe/ejb/ejb30/issue/1153/basic/dropDDL.jdbc all: BUILD SUCCESSFUL Total time: 30 seconds