Buildfile: build.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: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: create-jdbc-connpool-common: [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false create-jdbc-connection-pool --datasourceclassname com.sun.sql.jdbcx.sqlserver.SQLServerDataSource --restype javax.sql.DataSource --isisolationguaranteed=true --isconnectvalidatereq=false --failconnection=false --allownoncomponentcallers=false --nontransactionalconnections=false --leakreclaim=false --lazyconnectionenlistment=false --lazyconnectionassociation=false --associatewiththread=false --matchconnections=false --ping=false --pooling=true --statementcachesize 0 --wrapjdbcobjects=true --property User=dbuser:Password=dbpassword:serverName=129.145.133.124:portNumber=1433:serverType=dedicated --target server --help=false poolDelimited [exec] Command create-jdbc-connection-pool executed successfully. setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: create-jdbc-resource-common: [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false create-jdbc-resource --connectionpoolid poolDelimited --enabled=true --target server --help=false jdbc/delimited [exec] Command create-jdbc-resource executed successfully. [echo] cmd executed for server clean: [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive compile: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common-as: [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes [echo] sqe-common.xml: Compiling test source files [javac] Compiling 6 source files to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common-as80: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common-as: [echo] sqe-common.xml: Compiling test source files [javac] Compiling 1 source file to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: compile-common-as80: build: setOSConditions: fixFiles: convUnix: [echo] fixed files for Unix convWin: setdefaultmode: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: package-par3-common: [echo] sqe-common.xml: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes, /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/lib [echo] sqe-common.xml: Generating PAR inside build directory [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${mapping.xml} to copy. [jar] Building jar: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/lib/entity.jar [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF ejb-jar-common: package-ejbjar-common: [echo] sqe-common.xml: Generating ejb-jar inside build directory [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF/wsdl [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${ejb-jar.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-ejb-jar.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-cmp-mappings.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${dbschema} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${webservices.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${webservices.wsdl} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${mapping.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-resources-ejb.xml} to copy. [jar] Building jar: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/jpa20-delimited-ejb.jar [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF appclient-jar-common: package-appclientjar-common: [echo] sqe-common.xml: Generating appclient-jar in build dir [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${application-client.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-application-client.xml} to copy. [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-resources-appclient.xml} to copy. [jar] Building jar: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/jpa20-delimited-client.jar [delete] Deleting directory /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF webclient-war2-common: build-ear3-common: [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/lib [mkdir] Created dir: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [copy] Warning: Could not find file /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited/${sun-application.xml} to copy. [copy] Copying 1 file to /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/classes/META-INF [jar] Building jar: /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/jpa20-delimitedApp.ear deploy: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: deploy-common: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: deploy-common-pe: [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false deploy --name jpa20-delimitedApp --force=false --precompilejsp=false --verify=false --retrieve /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive --enabled=true --generatermistubs=false --availabilityenabled=false --keepreposdir=false --keepfailedstubs=false --logReportedErrors=true --help=false /space/test1/SRC/c10/appserver-sqe/build/pe/sparc_win60_SunOS/jpa20/archive/jpa20-delimitedApp.ear [exec] Application deployed successfully with name jpa20-delimitedApp. [exec] Deployment encountered SQL Exceptions: [exec] Got SQLException executing statement "CREATE TABLE "Jpa_Emp_Del" ("ID" INTEGER NOT NULL, "LNAME" VARCHAR(15) NULL, "Jpa_Ext_Del" VARCHAR(30) NULL, "FNAME" VARCHAR(15) NULL, "DEPT_ID" INTEGER NULL, PRIMARY KEY ("ID"))": java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]There is already an object named 'Jpa_Emp_Del' in the database. [exec] Got SQLException executing statement "ALTER TABLE "Jpa_Emp_Del" ADD CONSTRAINT "Jpa_Emp_Del_DEPT_ID" FOREIGN KEY (DEPT_ID) REFERENCES "JPA_DEPT" (ID)": java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]There is already an object named 'Jpa_Emp_Del_DEPT_ID' in the database. [exec] Command deploy executed successfully. run: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: runclient-common: [echo] Executing appclient at /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited [echo] Nov 11, 2009 4:11:28 PM org.glassfish.appclient.client.acc.FacadeLaunchable selectFacadeFromGroup [echo] WARNING: appclient.singleNestedClientNoMatch [echo] Nov 11, 2009 4:11:29 PM com.sun.enterprise.transaction.JavaEETransactionManagerSimplified initDelegates [echo] INFO: Using com.sun.enterprise.transaction.jts.JavaEETransactionManagerJTSDelegate as the delegate [echo] WS HOME appserver-sqe [echo] testSuiteID is : JPA2-EAR-J2DB-Delimited: [echo] The Database type is : microsoft [echo] ...started test 1: testCreate [echo] ...finished testCreate, passed = true [echo] ...started test 2: testNativeQuery [echo] ...finished testNativeQuery, passed = false [echo] ...started test 3: testRead [echo] ...finished testRead, passed = false [echo] ...started test 4: testUpdate [echo] ...finished testUpdate, passed = true [echo] ...started test 5: testDelete [echo] ...finished testDelete, passed = true [echo] Generating report at /space/test1/SRC/c10/appserver-sqe/test_results.xml [echo] [echo] [echo] ----------------------------------------- [echo] - JPA2-EAR-J2DB-Delimited:testRead: FAIL - [echo] - JPA2-EAR-J2DB-Delimited:testNativeQuery: FAIL - [echo] - JPA2-EAR-J2DB-Delimited:testDelete: PASS - [echo] - JPA2-EAR-J2DB-Delimited:testUpdate: PASS - [echo] - JPA2-EAR-J2DB-Delimited:testCreate: PASS - [echo] ----------------------------------------- [echo] Total PASS: 3 [echo] Total FAIL: 2 [echo] Total DNR: 0 [echo] ----------------------------------------- setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: check-runclient-output: checkReporting-common: confirmReportPresent-common: [echo] Test seems to be reported fine [delete] Deleting 1 files from /space/test1/SRC/c10/appserver-sqe/pe/ejb/jpa20/ear/delimited confirmMissingReport-common: undeploy: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: undeploy-common: [echo] Undeploying jpa20-delimitedApp on server server ... [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false undeploy --target server --keepreposdir=false --cascade=false --ignoreCascade=false --help=false jpa20-delimitedApp [exec] Deployment encountered SQL Exceptions: [exec] Got SQLException executing statement "ALTER TABLE "Jpa_Emp_Del" DROP CONSTRAINT "Jpa_Emp_Del_DEPT_ID"": java.sql.SQLException: [sunm][SQLServer JDBC Driver][SQLServer]'Jpa_Emp_Del_DEPT_ID' is not a constraint. [exec] Got SQLException executing statement "DROP TABLE "Jpa_Emp_Del"": java.sql.SQLSyntaxErrorException: [sunm][SQLServer JDBC Driver][SQLServer]Cannot drop the table 'Jpa_Emp_Del', because it does not exist or you do not have permission. [exec] Command undeploy executed successfully. [echo] cmd executed for server unsetup: setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: delete-jdbc-resource-common: [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false delete-jdbc-resource --target server --help=false jdbc/delimited [exec] Command delete-jdbc-resource executed successfully. [echo] cmd executed for server setdefaultmode: setOSConditions: setToolWin: setToolUnix: setToolProperty: setS1ASclassPath: setS1AS80classPath: setS1WSclassPath: setJWSDPclassPath: setTimeStamp: init-password-file: init-common: init-password-file: create-password-file: create-report-dir: delete-jdbc-connpool-common: [exec] asadmin --host localhost --port 4848 --user admin --passwordfile /space/test1/SRC/c10/appserver-sqe/build-config/adminpassword.txt --interactive=false --echo=true --terse=false delete-jdbc-connection-pool --cascade=true --help=false poolDelimited [exec] Command delete-jdbc-connection-pool executed successfully. [echo] cmd executed for server all: BUILD SUCCESSFUL Total time: 1 minute 4 seconds