[jbossseam-issues] Bug using Jboss seam and mySql

[damian diaz]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/seam-issues/attachments/20070620/a8505d3e/attachment.html