Ok, I've downloaded the latest Jboss and I'm learning how to move from Hypersonic to Mysql, but I have an SQL syntax error relating to interval bigint etc when I deploy using Mysql. It relates to the fact that interval is a reserved word for Mysql. After searching the forums I saw that some of you had overcome this by changing interval to intervals in the ejb-deployer.xml file (standardjbosscmp-jdbc.xml(?)), but that was on previous versions of Jboss. The current versions of these files don't contain these words, yet they must be somewhere because I am getting the same error message that other guys have got previously. So my question is where are these words?!? (There is a list of reserved words and I thought by adding interval to this list it would suffice, but it has no effect. Or do I have to reboot?)
Mike. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3864041#3864041 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3864041 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
