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

[ddiaz]

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#4056140

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056140