Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <13830532.post@talk.nabble.com>
Date: Mon, 19 Nov 2007 01:41:24 -0800 (PST)
From: ivanrc <iriano@indra.es>
To: user@geronimo.apache.org
Subject: Booleans in CMP EJB2.1 with Geronimo 2.0.2 and Sql Server
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


Hello,

I=C2=B4m using Apache Geronimo 2.0.2 and DataBase pool with SQL Server 2005=
. I=C2=B4ve
got this remote interface defined in my EJB2.1 CMP...

/* Generated by Together */

package test;

import javax.ejb.EJBObject;
import java.rmi.RemoteException;
import javax.ejb.EJBException;

public interface TestEntity extends EJBObject {
=09Long getId() throws RemoteException, EJBException;

    void setId(Long param) throws RemoteException, EJBException;

    void setActive(Boolean active) throws RemoteException, EJBException;

    Boolean getActive() throws RemoteException, EJBException;
   =20
}


Boolean named "Active" is mapped with a BIT column type named "ACTIVE" into
SQL server data base, and then, the first time I invoke create() method of
my home interface, I obtain this exception...

10:23:16,453 ERROR [OpenEJB] The bean instances business method encountered
a system exception: Syntax error: Encountered "BIT" at line 1, column 56.
{stmnt 4757738 CREATE TABLE BOOLEAN_TABLE (ID BIGINT NOT NULL, ACTIVE BIT,
PRIMARY KEY (ID))} [code=3D30000, state=3D42X01]
<openjpa-1.0.0-r420667:568756 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Syntax error:
Encountered "BIT" at line 1, column 56. {stmnt 4757738 CREATE TABLE
BOOLEAN_TABLE (ID BIGINT NOT NULL, ACTIVE BIT, PRIMARY KEY (ID))}
[code=3D30000, state=3D42X01]
=09at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:549)
=09at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:449)
=09at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBr=
okerFactory.java:170)
=09at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFa=
ctory.java:130)
=09at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFac=
tory.java:186)
=09at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBroke=
rFactory.java:142)
=09at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager=
(EntityManagerFactoryImpl.java:192)
=09at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager=
(EntityManagerFactoryImpl.java:56)
=09at
org.apache.geronimo.persistence.CMPEntityManagerTxScoped.createEntityManage=
r(CMPEntityManagerTxScoped.java:74)
=09at
org.apache.geronimo.persistence.CMPEntityManagerTxScoped.getEntityManager(C=
MPEntityManagerTxScoped.java:55)
=09at
org.apache.geronimo.persistence.CMPEntityManagerTxScoped.getDelegate(CMPEnt=
ityManagerTxScoped.java:315)
=09at
org.apache.openejb.core.cmp.jpa.JpaCmpEngine.registerListener(JpaCmpEngine.=
java:128)
=09at
org.apache.openejb.core.cmp.jpa.JpaCmpEngine.getEntityManager(JpaCmpEngine.=
java:109)
=09at
org.apache.openejb.core.cmp.jpa.JpaCmpEngine.createBean(JpaCmpEngine.java:1=
40)
=09at
org.apache.openejb.core.cmp.CmpContainer.createEJBObject(CmpContainer.java:=
638)
=09at org.apache.openejb.core.cmp.CmpContainer.invoke(CmpContainer.java:290=
)
=09at
org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbHome_CREATE(EjbReques=
tHandler.java:240)
=09at
org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestH=
andler.java:125)
=09at
org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:1=
64)
=09at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
=09at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
=09at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
=09at org.apache.openejb.server.ServiceLogger.service(ServiceLogger.java:73=
)
=09at
org.apache.openejb.server.ServiceAccessController.service(ServiceAccessCont=
roller.java:55)
=09at org.apache.openejb.server.ServiceDaemon$1.run(ServiceDaemon.java:117)
=09at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax error:
Encountered "BIT" at line 1, column 56. {stmnt 4757738 CREATE TABLE
BOOLEAN_TABLE (ID BIGINT NOT NULL, ACTIVE BIT, PRIMARY KEY (ID))}
[code=3D30000, state=3D42X01]
=09at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnecti=
onDecorator.java:192)
=09at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingCo=
nnectionDecorator.java:57)
=09at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$Lo=
ggingStatement.executeUpdate(LoggingConnectionDecorator.java:754)
=09at
org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingSta=
tement.java:114)
=09at
org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1185)
=09at
org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:949)
=09at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:526)
=09at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
=09at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
=09at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:497)
=09... 25 more

As exception tell me, table named BOOLEAN_TABLE exist (with the same format=
)
before I invoked create method the fist time. The second time that I invoke
create method of home works well. I using SQL Server 2005 JDBC Driver 1.0
downloaded from Microsoft web page.

Do Anybody know how to I can solve this poblem?. How can I disable this
previous check of Table format?

Thanks.
--=20
View this message in context: http://www.nabble.com/Booleans-in-CMP-EJB2.1-=
with-Geronimo-2.0.2-and-Sql-Server-tf4834404s134.html#a13830532
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.