It worked at last, for those interested it was my fault, in the mysql_local_cmp_database.xml file i had written  DBClinica (the JNDI name) instead of Clinica (the real DB name).

The Pk class works fine.



José Manuel Molina wrote:
I'm testing the primary key classes, I have advanced but I'm stuck again.

I  reach the create method and I get this exception

Its very strange as that user have accese to that DB (I have test it after, and i works with taht user fine for the rest of the Connections to the DB, and if I use the atrribute as it is (int-Integer) as the Pk it works fine)





INFO : 
********************************************************************************
OpenEJB http://openejb.sf.net
Startup: 17/09/03 0:34
Copyright 2000,2001,2002 (C) OpenEJB Project, All Rights Reserved.
Version: 0.9.2
Build date: 20030605
Build time: 0409
********************************************************************************


DEBUG:  Instantiating assembler class org.openejb.alt.assembler.classic.Assembler
DEBUG:  Containers        : 4
DEBUG:  Type        Container ID
DEBUG:     ENTITY      Default BMP Container
DEBUG:     ENTITY      Default CMP Container
DEBUG:     STATEFUL    Default Stateful Container
DEBUG:     STATELESS   Default Stateless Container
DEBUG:  Deployments       : 6
DEBUG:  Type        Deployment ID
DEBUG:     CMP_ENTITY  Tablas
DEBUG:     STATELESS   EPersonal
DEBUG:     STATELESS   EHistoria
DEBUG:     STATELESS   ECita
DEBUG:     STATELESS   EPaciente
DEBUG:     STATELESS   EIntervencion
DEBUG:  SecurityService   : org.openejb.ri.sp.PseudoSecurityService
DEBUG:  TransactionManager: org.openejb.core.TransactionManagerWrapper
INFO :  OpenEJB ready.
ERROR:  The bean instances business method encountered a system exception:Nested error: java.sql.SQLException: General error: Access denied for user: '[EMAIL PROTECTED]' to database 'DBClinica'
java.sql.SQLException: General error: Access denied for user: '[EMAIL PROTECTED]' to database 'DBClinica'
    at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
    at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:264)
    at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
    at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:140)
    at org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(DatabaseRegistry.java:401)
    at org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(TransactionContextImpl.java:203)
    at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:891)
    at org.exolab.castor.persist.LockEngine.create(LockEngine.java:492)
    at org.exolab.castor.persist.TransactionContext.create(TransactionContext.java:827)
    at org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:345)
    at org.openejb.alt.containers.castor_cmp11.CastorCMP11_EntityContainer.createEJBObject(CastorCMP11_EntityContainer.java:821)
    at org.openejb.alt.containers.castor_cmp11.CastorCMP11_EntityContainer.invoke(CastorCMP11_EntityContainer.java:521)
    at org.openejb.server.EjbDaemon.doEjbHome_CREATE(EjbDaemon.java:728)
    at org.openejb.server.EjbDaemon.processEjbRequest(EjbDaemon.java:539)
    at org.openejb.server.EjbDaemon.run(EjbDaemon.java:374)
    at java.lang.Thread.run(Thread.java:536)

<?xml version="1.0"?> <mapping> <class name="gcc.lpd.TablasBean" identity="PKTabla" key-generator="IDENTITY"> <map-to table="tablas"/> <field name="PKTabla" type="integer" direct="true"> <sql name="PKTabla" type="integer"/> </field> <field name="Nombre" type="string" direct="true"> <sql name="Nombre" type="varchar" dirty="check"/> </field> </class> </mapping>



Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to