#13 MS SQL Server 2000 Weblogic Issue

[Anonymous]

When trying to deploy xpetstore on weblogic 7 using a
MS SQL Server 2000 database, i can never get xpet
deployed as there is a problem with the type mapping
from Date to Datetime.

I've tried adding 'sql-type="datetime"' to the entity bean
but still no joy.

I've given the weblogic error below,

Any ideas?

Thanks, Paul

Unable to deploy EJB: Order from xpetstore-ejb.jar:

weblogic.ejb20.WLDeploymentException: Errors
encountered ''The Container-Managed
Persistence Entity EJB failed while creating its SQL
Type Map. The error was:
Invalid object name 'T_ORDER'. Severity 16, State 1,
Procedure 'NOL-DEV-DB null'
, Line 1',
'Error encountered while attempting to create Default
DBMS Table: 'T_ORDER'. Err
or Text: 'Column or parameter #8: Cannot find data type
DATE. Severity 16, State
7, Procedure 'NOL-DEV-DB null', Line 1'.''
at
weblogic.ejb20.utils.TableVerifier.verifyTableExistsAndCr
eateMaybe(Ta
bleVerifier.java:472)
at
weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.
verifyTablesExist(RD
BMSPersistenceManager.java:1058)
at
weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.
setup(RDBMSPersisten
ceManager.java:150)
at
weblogic.ejb20.manager.BaseEntityManager.setupPM
(BaseEntityManager.ja
va:211)
at
weblogic.ejb20.manager.BaseEntityManager.setup
(BaseEntityManager.java
:181)
at weblogic.ejb20.manager.DBManager.setup
(DBManager.java:162)
at
weblogic.ejb20.deployer.ClientDrivenBeanInfoImpl.activat
e(ClientDrive
nBeanInfoImpl.java:945)
at weblogic.ejb20.deployer.EJBDeployer.activate
(EJBDeployer.java:1296)
at weblogic.ejb20.deployer.EJBModule.activate
(EJBModule.java:349)
at
weblogic.j2ee.J2EEApplicationContainer.activateModule
(J2EEApplication
Container.java:1592)
at weblogic.j2ee.J2EEApplicationContainer.activate
(J2EEApplicationContai
ner.java:1029)
at weblogic.j2ee.J2EEApplicationContainer.activate
(J2EEApplicationContai
ner.java:1016)
at
weblogic.management.deploy.slave.SlaveDeployer.proce
ssPrepareTask(Sla
veDeployer.java:1112)
at
weblogic.management.deploy.slave.SlaveDeployer.prepar
eUpdate(SlaveDep
loyer.java:732)
at
weblogic.drs.internal.SlaveCallbackHandler$1.execute
(SlaveCallbackHan
dler.java:24)
at weblogic.kernel.ExecuteThread.execute
(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run
(ExecuteThread.java:134)