Erik,
Sorry, you teach me something, but I try both and cannot see a valuable difference.
Alex,
I apologize if you don't like my comments byt I can proove what I say. The only error
I make is that (you are right) the SQL generated for testing the entity existence is
the same for the databases). I make this mistake because I anticipate with the error
in this topic.
But here is it:
I have an entity bean:
| <entity >
| <description><![CDATA[PharmaML Client]]></description>
| <display-name>PhML_ClientBean</display-name>
|
| <ejb-name>PhML_Client</ejb-name>
|
| <home>PharmaML_EJB.interfaces.PhML_ClientHome</home>
| <remote>PharmaML_EJB.interfaces.PhML_Client</remote>
| <local-home>PharmaML_EJB.interfaces.PhML_ClientLocalHome</local-home>
| <local>PharmaML_EJB.interfaces.PhML_ClientLocal</local>
|
| <ejb-class>PharmaML_EJB.pkg.PhML_ClientBean</ejb-class>
| <persistence-type>Container</persistence-type>
| <prim-key-class>PharmaML_EJB.pkg.ClientPK</prim-key-class>
| <reentrant>False</reentrant>
| <cmp-version>2.x</cmp-version>
| <abstract-schema-name>PhML_Client</abstract-schema-name>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliId</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliAddr</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliCode</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliCp</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliFax</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliFlagsup</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliMail</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliRsnscl</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliSiret</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliTel</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>cliVille</field-name>
| </cmp-field>
| <cmp-field >
| <description><![CDATA[]]></description>
| <field-name>etabCode</field-name>
| </cmp-field>
|
| <query>
| <query-method>
| <method-name>findByClientCode</method-name>
| <method-params>
| <method-param>java.lang.String</method-param>
| </method-params>
| </query-method>
| <ejb-ql><![CDATA[SELECT OBJECT(a) FROM PhML_Client AS a WHERE
a.cliCode = ?1]]></ejb-ql>
| </query>
| <!-- Write a file named ejb-finders-PhML_ClientBean.xml if you want to
define extra finders. -->
| </entity>
|
My primary key class is
| public class ClientPK implements java.io.Serializable {
|
| public Long cliID;
|
| public ClientPK() {
| }
|
| public ClientPK(Long id) {
| cliID = id;
| //cliCode = code;
| }
|
| public int hashCode()
| {
| return String.valueOf(cliID).hashCode();
| }
|
|
|
| public boolean equals(Object prod)
| {
| return ((ClientPK)prod).cliID.equals(cliID);
| }
| /**
| * @return
| */
| public Long getCliID() {
| return cliID;
| }
|
| /**
| * @param long1
| */
| public void setCliID(Long long1) {
| cliID = long1;
| }
|
| }
|
As you see, only one field in the primary key class.
here is the log with MSSQL2000 (trying to create a new entity, table is already
created) : the WHERE clause is empty
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start
method=create
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current
transaction in MI is null
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED
for create
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came
in with tx null
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Starting
new tx TransactionImpl:XidImpl [FormatId=257, GlobalId=bureau//27, BranchQual=]
| 2004-05-30 11:16:58,821 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get
instance [EMAIL PROTECTED] PharmaML_EJB.pkg.PhML_ClientBean
| 2004-05-30 11:16:58,831 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PhML_Client] Executing SQL:
SELECT COUNT(*) FROM dbo.TD_CLIENT WHERE
| 2004-05-30 11:16:58,981 ERROR
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PhML_Client] Error checking if
entity exists
| java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Ligne
1 : syntaxe incorrecte vers 'WHERE'.
| at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
| at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
| at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
| at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
| at
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
| at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
| at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
| at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
| at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
| at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
| at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
| at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
| at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
| at com.microsoft.jdbcx.base.BasePreparedStatementWrapper.executeQuery(Unknown
Source)
| at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:83)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
| at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
| at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
| at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
| at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
| at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
| at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
| at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
| at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
| at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
| at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
| at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
| at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
| at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
| at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
| at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
| at org.jboss.ejb.Container.invoke(Container.java:720)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
| at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
| at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
| at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
| at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
| at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
| at $Proxy63.create(Unknown Source)
| at tutorial.web.ComputeServlet.doPost(ComputeServlet.java:99)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
| at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
| at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
| at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
| at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
| at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
| at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
| at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
| at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
| at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
| at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
| at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
| at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
| at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
| at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
| at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
| at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
| at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
| at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
| at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
| at java.lang.Thread.run(Thread.java:536)
| 2004-05-30 11:16:59,111 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT]
TxInterceptorCMT: In finally
| 2004-05-30 11:16:59,181 TRACE [org.jboss.ejb.plugins.LogInterceptor] End
method=create
|
and the trace at deployment with mySQL (create table is true) : both the WHERE clause
is empty and the table creation has a SQL string with a PRIMARY KEY instruction empty.
| 2004-05-30 11:25:02,176 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PhML_Client] Insert Entity
SQL: INSERT INTO TD_CLIENT (CLI_ID, CLI_ADDR, CLI_CODE, CLI_CP, CLI_FAX, CLI_FLAGSUP,
CLI_MAIL, CLI_RSNSCL, CLI_SIRET, CLI_TEL, CLI_VILLE, ETAB_CODE) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
| 2004-05-30 11:25:02,176 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.PhML_Client] Entity Exists
SQL: SELECT COUNT(*) FROM TD_CLIENT WHERE
| 2004-05-30 11:25:02,176 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.PhML_Client] entity-command:
[commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2004-05-30 11:25:02,226 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.PhML_Client] Remove SQL:
DELETE FROM TD_CLIENT WHERE
| 2004-05-30 11:25:02,296 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PhML_Client] Executing SQL: CREATE
TABLE TD_CLIENT (CLI_ID BIGINT, CLI_ADDR VARCHAR(250) BINARY, CLI_CODE VARCHAR(250)
BINARY, CLI_CP VARCHAR(250) BINARY, CLI_FAX VARCHAR(250) BINARY, CLI_FLAGSUP TINYINT
NOT NULL, CLI_MAIL VARCHAR(250) BINARY, CLI_RSNSCL VARCHAR(250) BINARY, CLI_SIRET
VARCHAR(250) BINARY, CLI_TEL VARCHAR(250) BINARY, CLI_VILLE VARCHAR(250) BINARY,
ETAB_CODE VARCHAR(250) BINARY, CONSTRAINT pk_TD_CLIENT PRIMARY KEY ())
| 2004-05-30 11:25:02,336 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.PhML_Client] Could not create table
TD_CLIENT
| 2004-05-30 11:25:02,346 ERROR [org.jboss.ejb.EntityContainer] Starting failed
| org.jboss.deployment.DeploymentException: Error while creating table TD_CLIENT; -
nested throwable: (java.sql.SQLException: Syntax error or access violation, message
from server: "You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near '))' at line 1")
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
| at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
| at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
| at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
| at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
| at $Proxy14.start(Unknown Source)
| at org.jboss.system.ServiceController.start(ServiceController.java:394)
| at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy31.start(Unknown Source)
| at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
| at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
| at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
| at $Proxy14.start(Unknown Source)
| at org.jboss.system.ServiceController.start(ServiceController.java:394)
| at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy12.start(Unknown Source)
| at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
| at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
| at org.jboss.deployment.MainDeployer.start(MainDeployer.java:824)
| at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
| at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
| at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy6.deploy(Unknown Source)
| at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
| at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
| Caused by: java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near '))' at line 1"
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
| at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2048)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2005)
| at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)
| at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)
| at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
| ... 55 more
| 2004-05-30 11:25:02,356 WARN [org.jboss.system.ServiceController] Problem
starting service jboss.j2ee:jndiName=PhML_Individu,service=EJB
| org.jboss.deployment.DeploymentException: Error while creating table TD_CLIENT; -
nested throwable: (java.sql.SQLException: Syntax error or access violation, message
from server: "You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near '))' at line 1")
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
| at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
| at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
| at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
| at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
| at $Proxy14.start(Unknown Source)
| at org.jboss.system.ServiceController.start(ServiceController.java:394)
| at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy31.start(Unknown Source)
| at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
| at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
| at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
| at $Proxy14.start(Unknown Source)
| at org.jboss.system.ServiceController.start(ServiceController.java:394)
| at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy12.start(Unknown Source)
| at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
| at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
| at org.jboss.deployment.MainDeployer.start(MainDeployer.java:824)
| at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
| at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
| at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:324)
| at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
| at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
| at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
| at $Proxy6.deploy(Unknown Source)
| at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
| at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212)
| at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
| Caused by: java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near '))' at line 1"
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
| at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1153)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2048)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:2005)
| at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)
| at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)
| at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219)
| ... 55 more
| 2004-05-30 11:25:02,376 DEBUG [org.jboss.ejb.plugins.local.BaseLocalProxyFactory]
Fibo cannot be Bound, doesn't have local and local home interfaces
| 2004-05-30 11:25:02,446 DEBUG [org.jboss.ejb.plugins.StatelessSessionInstancePool]
Starting
| 2004-05-30 11:25:02,446 INFO [org.jboss.ejb.plugins.StatelessSessionInstancePool]
Started jboss.j2ee:jndiName=ejb/tutorial/Fibo,plugin=pool,service=EJB
| 2004-05-30 11:25:02,446 INFO [org.jboss.ejb.StatelessSessionContainer] Started
jboss.j2ee:jndiName=ejb/tutorial/Fibo,service=EJB
| 2004-05-30 11:25:02,446 INFO [org.jboss.ejb.EjbModule] Started
jboss.j2ee:module=FiboEJB.jar,service=EjbModule
| 2004-05-30 11:25:02,446 INFO [org.jboss.ejb.EJBDeployer] Deployed:
file:/D:/JBoss/jboss-3.2.3/server/default/tmp/deploy/tmp10701FiboApp.ear-contents/FiboEJB.jar
| 2004-05-30 11:25:02,857 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService]
deploy, ctxPath=/fibo,
warUrl=file:/D:/JBoss/jboss-3.2.3/server/default/tmp/deploy/tmp10701FiboApp.ear-contents/FiboWeb.war/
| 2004-05-30 11:25:02,907 INFO [org.jboss.web.tomcat.tc4.EmbeddedTomcatService]
ClusteredHTTPSessionService not found
| 2004-05-30 11:25:02,917 ERROR [org.jboss.web.tomcat.tc4.EmbeddedTomcatService]
Failed to setup clustering, clustering disabled
| 2004-05-30 11:25:03,348 INFO [org.jboss.web.localhost.Engine]
SingleSignOnContextConfig[/fibo]: Ajout de certificats -> requête Attribut de Valve
(attribute Valve)
| 2004-05-30 11:25:03,928 WARN [org.jboss.web.tomcat.tc4.EmbeddedTomcatService]
Unable to invoke setDelegate on class loader:[EMAIL PROTECTED]
| 2004-05-30 11:25:03,928 INFO [org.jboss.web.localhost.Engine]
StandardManager[/fibo]: Alimentation de la classe du générateur de nombre aléatoire
java.security.SecureRandom
| 2004-05-30 11:25:04,059 INFO [org.jboss.web.localhost.Engine]
StandardManager[/fibo]: L'alimentation du générateur de nombre aléatoire est terminé
| 2004-05-30 11:25:04,129 INFO [org.jboss.web.localhost.Engine]
StandardWrapper[/fibo:default]: Chargement du conteneur (container) de servlet default
| 2004-05-30 11:25:04,139 INFO [org.jboss.web.localhost.Engine]
StandardWrapper[/fibo:invoker]: Chargement du conteneur (container) de servlet invoker
| 2004-05-30 11:25:05,471 INFO [org.jboss.deployment.EARDeployer] Started J2EE
application: file:/D:/JBoss/jboss-3.2.3/server/default/deploy/FiboApp.ear
| 2004-05-30 11:25:05,481 INFO [org.jboss.deployment.MainDeployer] Deployed
package: file:/D:/JBoss/jboss-3.2.3/server/default/deploy/FiboApp.ear
| 2004-05-30 11:25:33,681 TRACE
[org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] Resized cache for bean
PhML_Client: old capacity = 1000000, new capacity = 50
|
When I modify the primary key class with 2 fields, it works fine with both databases.
You can remove my comment, but i have already seen a topic in this forum where
somebody talks about hte same error and had never had a response.
So, I apologize for the debug level of cmp plugin.
BUT WHAT ABOUT THE PRIMARY KEY ERROR !
Thanks
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836875#3836875
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836875
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id?66&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
