I think it's 255, but there is a text type that supports up to 64K! Matt
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf > Of Herve Tchepannou > Sent: Tuesday, January 21, 2003 7:47 PM > To: xdoclet > Subject: Re: [Xdoclet-user] New release of xPetStore v2.2 > > > What's the max size for string on mySQL? > > > 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(JD > BCStartCommand.java:175) > > at > > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCSt > artCommand.java:84) > > at > > > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreMana > ger(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 > -- > > Herve Tchepannou > mailto:[EMAIL PROTECTED] > > > > ------------------------------------------------------- > 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 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
