Hi Michael,
I've included the errors in server.log and the ejb-jar.xml as attachments for easier debugging.
I'm pasting the errors here for a quick view:
|#]
[#|2008-07-22T16:20:01.713-0500|INFO|sun-appserver9.1|javax.enterprise.system.core|_ThreadID=18;_ThreadName=Thread-34;awardslinqII;|CORE5022: All ejb(s) of [awardslinqII] were unloaded successfully!|#]
[#|2008-07-22T16:21:32.759-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Catalog' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Catalog
Method: java.util.Collection ejbSelectNonCrossSellProductGroups(java.lang.String)
EJBQL: SELECT OBJECT(pg) FROM ProductGroup AS pg
WHERE pg.catalogs.catalogId = ?1
AND NOT EXISTS (SELECT OBJECT(cg) FROM CrossSellGroup cg
WHERE cg.productGroups.productGroupId = pg.productGroupId)
Error: line(3) column(41): JDO75202: Syntax error unexpected token '('.
|#]
[#|2008-07-22T16:21:32.759-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Catalog' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Catalog
Method: java.util.Collection ejbSelectNonCrossSellProductGroups(java.lang.String)
EJBQL: SELECT OBJECT(pg) FROM ProductGroup AS pg
WHERE pg.catalogs.catalogId = ?1
AND NOT EXISTS (SELECT OBJECT(cg) FROM CrossSellGroup cg
WHERE cg.productGroups.productGroupId = pg.productGroupId)
Error: line(3) column(41): JDO75202: Syntax error unexpected token '('.
|#]
[#|2008-07-22T16:21:33.103-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'TravelPlan' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: TravelPlan
Method: java.util.Collection findByCreatedDate(long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM TravelPlan o WHERE o.createdDate = ?1
Error: column(65): JDO75311: Invalid argument(s) for '='.
|#]
[#|2008-07-22T16:21:33.103-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'TravelPlan' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: TravelPlan
Method: java.util.Collection findByCreatedDate(long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM TravelPlan o WHERE o.createdDate = ?1
Error: column(65): JDO75311: Invalid argument(s) for '='.
|#]
[#|2008-07-22T16:21:33.634-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'ProductGroup' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: ProductGroup
Method: java.util.Collection findUnassignedProductGroups(java.lang.String,int)
EJBQL: SELECT OBJECT(productGroup) FROM Catalog catalog,
IN (catalog.productGroups) productGroup
WHERE catalog.catalogId = ?1
AND productGroup.productGroupId NOT IN
(SELECT subProductGroup.productGroupId FROM Category category,
IN (category.productGroups) subProductGroup
WHERE category.categoryRoot.categoryRootId = ?2
)
Error: line(4) column(61): JDO75202: Syntax error unexpected token 'NOT'.
|#]
[#|2008-07-22T16:21:33.634-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'ProductGroup' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: ProductGroup
Method: java.util.Collection findUnassignedProductGroups(java.lang.String,int)
EJBQL: SELECT OBJECT(productGroup) FROM Catalog catalog,
IN (catalog.productGroups) productGroup
WHERE catalog.catalogId = ?1
AND productGroup.productGroupId NOT IN
(SELECT subProductGroup.productGroupId FROM Category category,
IN (category.productGroups) subProductGroup
WHERE category.categoryRoot.categoryRootId = ?2
)
Error: line(4) column(61): JDO75202: Syntax error unexpected token 'NOT'.
|#]
[#|2008-07-22T16:21:34.072-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'GiftWrappers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: GiftWrappers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM GiftWrappers o WHERE o.active = ?1 AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.wrapperId ASC
Error: column(74): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:34.072-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'GiftWrappers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: GiftWrappers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM GiftWrappers o WHERE o.active = ?1 AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.wrapperId ASC
Error: column(74): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:34.166-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Flowers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Flowers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM Flowers o
WHERE o.active = ?1
AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.displayOrder ASC
Error: line(3) column(45): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:34.166-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Flowers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Flowers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM Flowers o
WHERE o.active = ?1
AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.displayOrder ASC
Error: line(3) column(45): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:35.025-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Participant' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Participant
Method: java.util.Collection findByLastAccessDateRange(long,long)
EJBQL: SELECT OBJECT(o) FROM Participant o WHERE o.lastLoginDate BETWEEN ?1 AND ?2
Error: column(44): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:35.025-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Participant' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Participant
Method: java.util.Collection findByLastAccessDateRange(long,long)
EJBQL: SELECT OBJECT(o) FROM Participant o WHERE o.lastLoginDate BETWEEN ?1 AND ?2
Error: column(44): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:35.088-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'CategoryRoot' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: CategoryRoot
Method: java.util.Collection findByUnassignedCatalogId(java.lang.String)
EJBQL: SELECT OBJECT(cr) FROM CategoryRoot cr
WHERE cr.categoryRootId
NOT IN (SELECT cr_sub.categoryRootId FROM Catalog ca,
IN (ca.categoryRoots) cr_sub
WHERE ca.catalogId = ?1 )
Error: line(3) column(29): JDO75202: Syntax error unexpected token 'NOT'.
|#]
[#|2008-07-22T16:21:35.088-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'CategoryRoot' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: CategoryRoot
Method: java.util.Collection findByUnassignedCatalogId(java.lang.String)
EJBQL: SELECT OBJECT(cr) FROM CategoryRoot cr
WHERE cr.categoryRootId
NOT IN (SELECT cr_sub.categoryRootId FROM Catalog ca,
IN (ca.categoryRoots) cr_sub
WHERE ca.catalogId = ?1 )
Error: line(3) column(29): JDO75202: Syntax error unexpected token 'NOT'.
|#]
[#|2008-07-22T16:21:35.181-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Category' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCatalogIdAndProductGroupId(java.lang.String,int)
EJBQL: SELECT OBJECT(category) FROM Category As category
WHERE category.categoryRoot.catalogs.catalogId = ?1
AND category.categoryId IN (SELECT productCategory.categoryId FROM ProductGroup productGroup,
IN (productGroup.categories) productCategory
WHERE productGroup.productGroupId = ?2
)
Error: line(3) column(49): JDO75202: Syntax error unexpected token 'IN'.
JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCategoryIdAllSiblings(int,java.lang.String)
EJBQL: SELECT OBJECT(o) FROM Category o
WHERE o.parentCategoryId
= (SELECT category.parentCategoryId FROM Category category
WHERE category.categoryId = ?1 )
AND o.categoryRootId = ?2
ORDER BY o.displayOrder
Error: line(3) column(34): JDO75202: Syntax error unexpected token 'SELECT'.
|#]
[#|2008-07-22T16:21:35.181-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Category' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCatalogIdAndProductGroupId(java.lang.String,int)
EJBQL: SELECT OBJECT(category) FROM Category As category
WHERE category.categoryRoot.catalogs.catalogId = ?1
AND category.categoryId IN (SELECT productCategory.categoryId FROM ProductGroup productGroup,
IN (productGroup.categories) productCategory
WHERE productGroup.productGroupId = ?2
)
Error: line(3) column(49): JDO75202: Syntax error unexpected token 'IN'.
JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCategoryIdAllSiblings(int,java.lang.String)
EJBQL: SELECT OBJECT(o) FROM Category o
WHERE o.parentCategoryId
= (SELECT category.parentCategoryId FROM Category category
WHERE category.categoryId = ?1 )
AND o.categoryRootId = ?2
ORDER BY o.displayOrder
Error: line(3) column(34): JDO75202: Syntax error unexpected token 'SELECT'.
|#]
[#|2008-07-22T16:21:35.338-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Announcement' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Announcement
Method: java.util.Collection findAllActive(java.lang.String,boolean,long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM Announcement o WHERE o.programId = ?1 AND o.active = ?2 AND ?3 BETWEEN o.startDate AND o.endDate
Error: column(104): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:35.338-0500|WARNING|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Announcement' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Announcement
Method: java.util.Collection findAllActive(java.lang.String,boolean,long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM Announcement o WHERE o.programId = ?1 AND o.active = ?2 AND ?3 BETWEEN o.startDate AND o.endDate
Error: column(104): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
|#]
[#|2008-07-22T16:21:42.056-0500|SEVERE|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|Exception occured in J2EEC Phase
com.sun.enterprise.deployment.backend.IASDeploymentException: Fatal Error from EJB Compiler -- JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Catalog' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Catalog
Method: java.util.Collection ejbSelectNonCrossSellProductGroups(java.lang.String)
EJBQL: SELECT OBJECT(pg) FROM ProductGroup AS pg
WHERE pg.catalogs.catalogId = ?1
AND NOT EXISTS (SELECT OBJECT(cg) FROM CrossSellGroup cg
WHERE cg.productGroups.productGroupId = pg.productGroupId)
Error: line(3) column(41): JDO75202: Syntax error unexpected token '('.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'TravelPlan' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: TravelPlan
Method: java.util.Collection findByCreatedDate(long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM TravelPlan o WHERE o.createdDate = ?1
Error: column(65): JDO75311: Invalid argument(s) for '='.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'ProductGroup' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: ProductGroup
Method: java.util.Collection findUnassignedProductGroups(java.lang.String,int)
EJBQL: SELECT OBJECT(productGroup) FROM Catalog catalog,
IN (catalog.productGroups) productGroup
WHERE catalog.catalogId = ?1
AND productGroup.productGroupId NOT IN
(SELECT subProductGroup.productGroupId FROM Category category,
IN (category.productGroups) subProductGroup
WHERE category.categoryRoot.categoryRootId = ?2
)
Error: line(4) column(61): JDO75202: Syntax error unexpected token 'NOT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'GiftWrappers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: GiftWrappers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM GiftWrappers o WHERE o.active = ?1 AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.wrapperId ASC
Error: column(74): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Flowers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Flowers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM Flowers o
WHERE o.active = ?1
AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.displayOrder ASC
Error: line(3) column(45): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Participant' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Participant
Method: java.util.Collection findByLastAccessDateRange(long,long)
EJBQL: SELECT OBJECT(o) FROM Participant o WHERE o.lastLoginDate BETWEEN ?1 AND ?2
Error: column(44): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'CategoryRoot' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: CategoryRoot
Method: java.util.Collection findByUnassignedCatalogId(java.lang.String)
EJBQL: SELECT OBJECT(cr) FROM CategoryRoot cr
WHERE cr.categoryRootId
NOT IN (SELECT cr_sub.categoryRootId FROM Catalog ca,
IN (ca.categoryRoots) cr_sub
WHERE ca.catalogId = ?1 )
Error: line(3) column(29): JDO75202: Syntax error unexpected token 'NOT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Category' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCatalogIdAndProductGroupId(java.lang.String,int)
EJBQL: SELECT OBJECT(category) FROM Category As category
WHERE category.categoryRoot.catalogs.catalogId = ?1
AND category.categoryId IN (SELECT productCategory.categoryId FROM ProductGroup productGroup,
IN (productGroup.categories) productCategory
WHERE productGroup.productGroupId = ?2
)
Error: line(3) column(49): JDO75202: Syntax error unexpected token 'IN'.
JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCategoryIdAllSiblings(int,java.lang.String)
EJBQL: SELECT OBJECT(o) FROM Category o
WHERE o.parentCategoryId
= (SELECT category.parentCategoryId FROM Category category
WHERE category.categoryId = ?1 )
AND o.categoryRootId = ?2
ORDER BY o.displayOrder
Error: line(3) column(34): JDO75202: Syntax error unexpected token 'SELECT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Announcement' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Announcement
Method: java.util.Collection findAllActive(java.lang.String,boolean,long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM Announcement o WHERE o.programId = ?1 AND o.active = ?2 AND ?3 BETWEEN o.startDate AND o.endDate
Error: column(104): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
at com.sun.ejb.codegen.CmpCompiler.compile(CmpCompiler.java:320)
at com.sun.ejb.codegen.IASEJBC.doCompile(IASEJBC.java:648)
at com.sun.ejb.codegen.IASEJBC.ejbc(IASEJBC.java:593)
at com.sun.enterprise.deployment.backend.EJBCompiler.preDeployApp(EJBCompiler.java:290)
at com.sun.enterprise.deployment.backend.EJBCompiler.compile(EJBCompiler.java:226)
at com.sun.enterprise.deployment.backend.AppDeployer.runEJBC(AppDeployer.java:319)
at com.sun.enterprise.deployment.backend.AppDeployer.deploy(AppDeployer.java:240)
at com.sun.enterprise.deployment.backend.AppDeployer.doRequestFinish(AppDeployer.java:148)
at com.sun.enterprise.deployment.phasing.J2EECPhase.runPhase(J2EECPhase.java:191)
at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:279)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:788)
at com.sun.enterprise.management.deploy.DeployThread.deploy(DeployThread.java:187)
at com.sun.enterprise.management.deploy.DeployThread.run(DeployThread.java:223)
|#]
[#|2008-07-22T16:21:42.056-0500|SEVERE|sun-appserver9.1|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-70;_RequestID=8c3d1838-2e51-41b4-8e7b-b1582355b5df;|Exception occured in J2EEC Phase
com.sun.enterprise.deployment.backend.IASDeploymentException: Fatal Error from EJB Compiler -- JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Catalog' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Catalog
Method: java.util.Collection ejbSelectNonCrossSellProductGroups(java.lang.String)
EJBQL: SELECT OBJECT(pg) FROM ProductGroup AS pg
WHERE pg.catalogs.catalogId = ?1
AND NOT EXISTS (SELECT OBJECT(cg) FROM CrossSellGroup cg
WHERE cg.productGroups.productGroupId = pg.productGroupId)
Error: line(3) column(41): JDO75202: Syntax error unexpected token '('.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'TravelPlan' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: TravelPlan
Method: java.util.Collection findByCreatedDate(long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM TravelPlan o WHERE o.createdDate = ?1
Error: column(65): JDO75311: Invalid argument(s) for '='.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'ProductGroup' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: ProductGroup
Method: java.util.Collection findUnassignedProductGroups(java.lang.String,int)
EJBQL: SELECT OBJECT(productGroup) FROM Catalog catalog,
IN (catalog.productGroups) productGroup
WHERE catalog.catalogId = ?1
AND productGroup.productGroupId NOT IN
(SELECT subProductGroup.productGroupId FROM Category category,
IN (category.productGroups) subProductGroup
WHERE category.categoryRoot.categoryRootId = ?2
)
Error: line(4) column(61): JDO75202: Syntax error unexpected token 'NOT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'GiftWrappers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: GiftWrappers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM GiftWrappers o WHERE o.active = ?1 AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.wrapperId ASC
Error: column(74): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Flowers' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Flowers
Method: java.util.Collection findAllActive(boolean,long)
EJBQL: SELECT OBJECT(o) FROM Flowers o
WHERE o.active = ?1
AND ?2 BETWEEN o.effStartDate AND o.effEndDate ORDER BY o.displayOrder ASC
Error: line(3) column(45): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Participant' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Participant
Method: java.util.Collection findByLastAccessDateRange(long,long)
EJBQL: SELECT OBJECT(o) FROM Participant o WHERE o.lastLoginDate BETWEEN ?1 AND ?2
Error: column(44): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'CategoryRoot' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: CategoryRoot
Method: java.util.Collection findByUnassignedCatalogId(java.lang.String)
EJBQL: SELECT OBJECT(cr) FROM CategoryRoot cr
WHERE cr.categoryRootId
NOT IN (SELECT cr_sub.categoryRootId FROM Catalog ca,
IN (ca.categoryRoots) cr_sub
WHERE ca.catalogId = ?1 )
Error: line(3) column(29): JDO75202: Syntax error unexpected token 'NOT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Category' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCatalogIdAndProductGroupId(java.lang.String,int)
EJBQL: SELECT OBJECT(category) FROM Category As category
WHERE category.categoryRoot.catalogs.catalogId = ?1
AND category.categoryId IN (SELECT productCategory.categoryId FROM ProductGroup productGroup,
IN (productGroup.categories) productCategory
WHERE productGroup.productGroupId = ?2
)
Error: line(3) column(49): JDO75202: Syntax error unexpected token 'IN'.
JDO75006: Invalid EJBQL query
Bean: Category
Method: java.util.Collection findByCategoryIdAllSiblings(int,java.lang.String)
EJBQL: SELECT OBJECT(o) FROM Category o
WHERE o.parentCategoryId
= (SELECT category.parentCategoryId FROM Category category
WHERE category.categoryId = ?1 )
AND o.categoryRootId = ?2
ORDER BY o.displayOrder
Error: line(3) column(34): JDO75202: Syntax error unexpected token 'SELECT'.
JDO74025: JDOCodeGenerator: Caught an Exception validating CMP bean 'Announcement' in application 'awardslinqII' module 'awardslinqservicesEJB': JDO75006: Invalid EJBQL query
Bean: Announcement
Method: java.util.Collection findAllActive(java.lang.String,boolean,long)
EJBQL: SELECT DISTINCT OBJECT(o) FROM Announcement o WHERE o.programId = ?1 AND o.active = ?2 AND ?3 BETWEEN o.startDate AND o.endDate
Error: column(104): JDO75305: Number expression expected, expression has type 'java.sql.Timestamp'.
at com.sun.ejb.codegen.CmpCompiler.compile(CmpCompiler.java:320)
at com.sun.ejb.codegen.IASEJBC.doCompile(IASEJBC.java:648)
at com.sun.ejb.codegen.IASEJBC.ejbc(IASEJBC.java:593)
at com.sun.enterprise.deployment.backend.EJBCompiler.preDeployApp(EJBCompiler.java:290)
at com.sun.enterprise.deployment.backend.EJBCompiler.compile(EJBCompiler.java:226)
at com.sun.enterprise.deployment.backend.AppDeployer.runEJBC(AppDeployer.java:319)
at com.sun.enterprise.deployment.backend.AppDeployer.deploy(AppDeployer.java:240)
at com.sun.enterprise.deployment.backend.AppDeployer.doRequestFinish(AppDeployer.java:148)
at com.sun.enterprise.deployment.phasing.J2EECPhase.runPhase(J2EECPhase.java:191)
at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:279)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.deploy(PEDeploymentService.java:788)
at com.sun.enterprise.management.deploy.DeployThread.deploy(DeployThread.java:187)
at com.sun.enterprise.management.deploy.DeployThread.run(DeployThread.java:223)
|#]
Thanks
Suneel
[Message sent by forum member 'suneelgv' (suneelgv)]
http://forums.java.net/jive/thread.jspa?messageID=288532