Hi, This was a known problem in xpetstore 2.1. The description field in the CategoryEJB is set to be 256 and not 255. MySQL will only take 255 characters maximum. Edit the EJB and recompile. All should then be fine.
I sent the information for MySQL with xpetstore and there are no further requirements needed other than those documented in the j2ee.properties file for JBOSS. Do ensure though that the mysql-service.xml file is in the deploy directory of the JBOSS server i.e. %JBOSS_HOME%\server\xpetstore\deploy Hope this helps Anthony Miller -----Original Message----- From: [EMAIL PROTECTED]%INTERNET [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 01:59 To: Herve Tchepannou Cc: xdoclet Subject: Re: [Xdoclet-user] New release of xPetStore v2.2 Importance: Low *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. Herve, very nice work! Thanks! Quick problem. I'm having the exceptions below while deploying, in regards to MySQL column sizes. Which version of MySQL and JDBC driver are you using? Any special jboss configuration you had to do to make it work? Thanks again, Zorzella ******************************************* 17:51:31,316 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=local/xpetstore.domain.order.OrderItem,service=EJB org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Invalid argument value: Too big column length for column 'description' (max = 255). Use BLOB instead) 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) [...] Herve Tchepannou <[EMAIL PROTECTED]> says: > New release of xPetStore > > xPetStore is a WODRA (Write Once, Deploy and Run Anywhere) > implementation of Sun PetStore application based on the following > opensource tools/framework: > - xDoclet > - Stuts > - SiteMesh > > xPetStore has been successfully deployed to the following application > servers: > - JBoss > - WebLogic > > Changes: > - Move the sourcecode to sourceforge CVS > - Add a ant-task to initialize the database > - Move configuration files from XPETSTORE/src/conf to > XPETSTORE/src/petstore/etc/conf > - Remove '.' from all EJB names to be conform to EJB specs > - Don't run docbook task for non unix system > > -- > > Herve Tchepannou > mailto:[EMAIL PROTECTED] > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: FREE SSL Guide from Thawte > are you planning your Web Server Security? Click here to get a FREE > Thawte SSL guide and find the answers to all your SSL security issues. > http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en > _______________________________________________ > Xdoclet-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/xdoclet-user > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ ------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ Xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** ------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ Xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
