Ok,
That are my tags:
/**
* Entity bean que representa Item
*
* @author Cleber Miranda Barboza
* @version $Revision: 1.0 $
*
* @ejb.bean
* name="ItemTransfer"
* display-name="Item Relacionado aos Contratos"
* type="CMP"
* local-jndi-name="ItemTransferLocalHome"
* view-type="local"
* primkey-field="id"
*
* @ejb.pk class="java.lang.String"
*
* @ejb.transaction type="Required"
*
* @ejb.finder
* signature="java.util.Collection findAll()"
*
* @ejb.finder
* signature="tci.interfaces.ItemTransferLocal
* findByItem(java.lang.String codEmpresa, java.lang.String codItem)"
* unchecked="true"
* query="SELECT OBJECT(p) FROM ItemTransfer AS p WHERE p.codEmpresa=?1 AND
p.codItem=?2"
* view-type="local"
*
* @jboss.persistence
* datasource="MySqlDS"
* datasource-mapping="mySQL"
* create-table="true"
*
* @jboss:table-name
* "fat_ctr_rems_446"
*
**/
and, that are the logs:
/tmp/cleber/J2EE/jboss-3.0.6_tomcat-4.1.18/server/default/deploy/samples-ejb.jar
2003-03-11 14:13:24,182 INFO [org.jboss.ejb.EjbModule] Creating
2003-03-11 14:13:24,297 INFO [org.jboss.ejb.EjbModule] Deploying Item
2003-03-11 14:13:24,352 INFO [org.jboss.ejb.EjbModule] Deploying ItemTransfer
2003-03-11 14:13:24,507 INFO [org.jboss.ejb.EjbModule] Created
2003-03-11 14:13:24,508 INFO [org.jboss.ejb.EjbModule] Starting
2003-03-11 14:13:25,459 WARN [org.jboss.system.ServiceController] Problem starting
service jboss.j2ee:jndiName=ItemLocalHome,service=EJB
org.jboss.deployment.DeploymentException: Error while creating table; - nested
throwable: (java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax near 'NOT NULL, empresa CHAR(2), secao
CHAR(10), ordem_producao INTEGER(4), item CHAR(' at line 1")
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:457)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:369)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
at org.jboss.ejb.Container.invoke(Container.java:756)
at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
at $Proxy4.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:413)
at sun.reflect.GeneratedMethodAccessor3.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:517)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy44.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
at sun.reflect.GeneratedMethodAccessor4.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:517)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
at $Proxy4.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:413)
at sun.reflect.GeneratedMethodAccessor3.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:517)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy9.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:395)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
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:517)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy3.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:435)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:656)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:261)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
at sun.reflect.GeneratedMethodAccessor4.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:517)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:413)
at sun.reflect.GeneratedMethodAccessor3.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:517)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy2.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:230)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:575)
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:517)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:325)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:222)
at org.jboss.Main.boot(Main.java:148)
at org.jboss.Main$1.run(Main.java:381)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax near 'NOT NULL, empresa CHAR(2), secao
CHAR(10), ordem_producao INTEGER(4), item CHAR(' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1628)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:917)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1806)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1740)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1309)
at
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalStatement.java:231)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:166)
... 82 more
2003-03-11 14:13:25,499 INFO [org.jboss.ejb.EjbModule] Started
2003-03-11 14:13:25,499 INFO [org.jboss.deployment.MainDeployer] Deployed package:
file:/tmp/cleber/J2EE/jboss-3.0.6_tomcat-4.1.18/server/default/deploy/samples-ejb.jar
Aleksandr Shneyderman writes:
>
> there is not enough information here to help you:
>
> 1. What is the database you use
> 2. Show the tagging you use to create your descriptors that generate the SQL
> 3. Show the complete SQL that is being generated (you can do it
> by turning the jboss logging to the higer level; DEBUG will do)
>
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Cleber
> > Miranda Barboza
> > Sent: Tuesday, March 11, 2003 12:32 PM
> > To: [EMAIL PROTECTED]
> > Subject: [Xdoclet-user] Error while creating table
> >
> >
> >
> > When I deploy my application I get the follow messages:
> >
> >
> > 14:13:25,459 WARN [ServiceController] Problem starting service
> > jboss.j2ee:jndiName=ItemLocalHome,service=EJB
> > org.jboss.deployment.DeploymentException: Error while creating table; -
> > nested throwable: (java.sql.SQLException: Syntax error or access
> > violation, message from server: "You have an error in your SQL syntax
> > near 'NOT NULL, empresa CHAR(2), secao CHAR(10), ordem_producao
> > INTEGER(4), item CHAR(' at line 1")
> > at
> > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCSt
> > artCommand.java:175)
> > at
> > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartC
> > ommand.java:84)
> > at
> > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(
> > JDBCStoreManager.java:457)
> > at
> > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreMan
> > ager.java:369)
> > at
> > org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceMa
> > nager.java:198)
> > ...
> >
> >
> >
> > Anyone knows some thing about that ?
> >
> > []'s
> >
> >
> > --
> > Cleber Miranda Barboza.
> > I'm a Computer Science student at University of S�o Paulo (USP).
> >
> > email: [EMAIL PROTECTED]
> > home page: http://www.linux.ime.usp.br/~cleberc
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:Crypto Challenge is now open!
> > Get cracking and register here for some mind boggling fun and
> > the chance of winning an Apple iPod:
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > _______________________________________________
> > xdoclet-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/xdoclet-user
> >
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> xdoclet-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/xdoclet-user
--
Cleber Miranda Barboza.
I'm a Computer Science student at University of S�o Paulo (USP).
email: [EMAIL PROTECTED]
home page: http://www.linux.ime.usp.br/~cleberc
-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open!
Get cracking and register here for some mind boggling fun and
the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
xdoclet-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/xdoclet-user
