[jboss-user] [JBoss Seam] - Bug using Jboss seam and mySql

Hi there, I was working to re-create the default example using MySql instead of Hypersonic database. I use netbeans 5.5.1, JDK 5, MySQL 5 and the Seam plugin. After compile and successfully pluming everything, the sql execution throw me and error. 12:35:05,546 INFO [MyfacesConfig] Tomahawk jar not available. Autoscrolling, DetectJavascript, AddResourceClass and CheckExtensionsFilter are disabled now. 12:35:05,562 INFO [STDOUT] Hibernate: select jmstransac0_.TXID as TXID36_ from .jms_transactions jmstransac0_ limit ? 12:35:08,546 INFO [STDOUT] Hibernate: select orderdetai0_.ORDERDETAILNUMBER as ORDERDET1_39_, orderdetai0_.ORDERNUMBER as ORDERNUM6_39_, orderdetai0_.PRODUCTCODE as PRODUCTC5_39_, orderdetai0_.QUANTITYORDERED as QUANTITY2_39_, orderdetai0_.PRICEEACH as PRICEEACH39_, orderdetai0_.ORDERLINENUMBER as ORDERLIN4_39_ from .orderdetails orderdetai0_ limit ? 12:35:09,406 INFO [STDOUT] Hibernate: select count(*) as col_0_0_ from .orderdetails orderdetai0_ 12:50:34,812 INFO [STDOUT] Hibernate: select productlin0_.PRODUCTLINE as PRODUCTL1_42_, productlin0_.TEXTDESCRIPTION as TEXTDESC2_42_, productlin0_.HTMLDESCRIPTION as HTMLDESC3_42_ from jbossdb..productlines productlin0_ limit ? 12:50:34,812 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000 12:50:34,812 ERROR [JDBCExceptionReporter] 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 '.productlines productlin0_ limit 25' at line 1" 12:50:35,234 ERROR [STDERR] Jun 20, 2007 12:50:35 PM com.sun.facelets.FaceletViewHandler handleRenderException SEVERE: Error Rendering View[/ProductlinesList.xhtml] javax.faces.el.EvaluationException: /ProductlinesList.xhtml @49,65 rendered="#{empty productlinesList.resultList}": Exception getting value of property resultList of base of type : NewSeam.model.ProductlinesList_$$_javassist_51 the error happens because the double dot after the jboss name (jbossdb..productlines). When I generated entities the system add catlaog @Table(name = "productlines", catalog = "jbossdb") If I define catalog = "" everything is working " from .productlines" I don't know if it is an error, bug or something else but I hope this information helps someone. Damian. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056140#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...