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