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
