[JBoss-user] [Datasource Configuration] - Re: JBoss 4.0 and MySQL Configuration

2004-02-06 Thread osganian
View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3820455#3820455

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3820455

Ok, I've gotten a little farther.  I'm trying to get the JBoss JDO example to work 
with JBoss 4.0 against MySQL.  I got the example to work against the Hypersonic 
database.  Below is the error I'm getting now:



2004-02-06 09:49:10,076 ERROR [org.jboss.web.localhost.Engine] 
StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception

org.apache.jasper.JasperException: Failed to execute statement: SELECT COMMENT.OID 
FROM COMMENT COMMENT ORDER BY COMMENT.PUBLISHDATE ASC

at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)



...



2004-02-06 09:49:10,106 ERROR [org.jboss.web.localhost.Engine] - Root Cause -

javax.jdo.JDOFatalDataStoreException: Failed to execute statement: SELECT COMMENT.OID 
FROM COMMENT COMMENT ORDER BY COMMENT.PUBLISHDATE ASC

at 
org.jboss.persistence.jbossdo.command.JDOAbstractCommand.executeQuery(JDOAbstractCommand.java:178)

at org.jboss.persistence.jbossdo.JBossQuery.execute(JBossQuery.java:134)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:191)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)



Any ideas out there???



The query cut and pasted in mysql works fine.



Thanks,

Mike


---
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Datasource Configuration] - Re: JBoss 4.0 and MySQL Configuration

2004-02-06 Thread osganian
View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3820459#3820459

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3820459

From looking at the JBoss source code (for 4.0 DR2), the actual SQLException that is 
raised in the JDOAbstractCommand class is lost and with it the actual cause.  Does 
anybody have any idea on what is going on here?



Thanks,

Mike


---
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user