[JBoss-user] [Installation, Configuration Deployment] - Every derived table must have its own alias
Windows XP JBoss 4.0.3RC2 installed via the installer program with all instead of minimal or ejb3. MySQL 4.1.14-nt-max via TCP/IP MySQL-Connector 3.1.10-bin I'm trying to get MySQL setup as my default database. I keep getting the same error when I use MySQL as the database for JMS. I do not get this error when it's configured for HSQLDB or using the null-persistence-service.xml file instead of mysql-jdbc2-service.xml. The error that I am getting is this: --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.mq:service=PersistenceManager State: FAILED Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias) I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS Depends On Me: jboss.mq:service=DestinationManager I think the part that I can not figure out is the Every derived table must have its own alias. At this point I'm stuck and have been trying to figure this out for a couple days. Feel free to ask for more information as I have no idea how much information on what is needed to fix this. Thank you for ANY possible help, even for a place to start looking. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3896752#3896752 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3896752 --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Installation, Configuration Deployment] - PersistenceManager FAILED
I am getting errors during the startup of JBoss 4.0.3RC2. ... --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.mq:service=PersistenceManager State: FAILED Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias) ... The Persistence Manager is described in the file jms/mysql-jdbc2-service.xml. I copied it from the examples, and removed three lines that were identical defining (UPDATE_MESSAGE, UPDATE_MARKED_MESSAGES, and UPDATE_MARKED_MESSAGES_WITH_TX). Thanks for any help. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3895919#3895919 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3895919 --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: EQL not generating correct SQL
fbiaggi wrote : Could you try with MySQL 4.1.13 ? | I have sse some stranges with 4.1.14... I can try and post the results. However, I don't expect it to change. I say that because I recently upgraded MySQL on Windows from 4.1.10, as well as upgrading MySQL's J driver to try to fix the same problem. On Linux I'm still running MySQL 4.1.10 and I get the same errors. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3891865#3891865 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3891865 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - EQL not generating correct SQL
Windows and SUSE Linux Java 5 JBoss 4.0.3RC1 MySQL 4.1.14 MySQL Connector/J 3.1.10 When I create a CMP EJB the finder queries seem to not be generating the correct SQL. On the wiki I found how to make JBoss log the SQL that was generated by the CMP's, after looking in the logs it makes me more believe that it's not generating the correct SQL. For example, in one of my finder queries: EQL SELECT OBJECT(c) FROM mySchema AS c Generated SQL (from log) SELECT FROM t_0c Any ideas on how to fix this? If you need more information feel free to ask for it because I would really like to figure out how to fix this and I'm at the end of my knowledge. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3891663#3891663 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3891663 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - EQL not generating correct SQL
Windows and SUSE Linux Java 5 JBoss 4.0.3RC1 MySQL 4.1.14 MySQL Connector/J 3.1.10 When I create a CMP EJB the finder queries seem to not be generating the correct SQL. On the wiki I found how to make JBoss log the SQL that was generated by the CMP's, after looking in the logs it makes me more believe that it's not generating the correct SQL. For example, in one of my finder queries: EQL SELECT OBJECT(c) FROM mySchema AS c Generated SQL (from log) SELECT FROM t_0c Any ideas on how to fix this? If you need more information feel free to ask for it because I would really like to figure out how to fix this and I'm at the end of my knowledge. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3891724#3891724 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3891724 --- SF.Net email is Sponsored by the Better Software Conference EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile Plan-Driven Development * Managing Projects Teams * Testing QA Security * Process Improvement Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Installation Configuration] - Configuration of JBoss 4.0.1
I've installed and used 3.2.x versions on Linux and Windows before without any problems. I've also installed and configured 4.0.1 on Windows XP with MySQL 4.1.0 database without any issues. I've been trying to get 4.0.1 to work with MySQL 4.0.21 on SUSE 9.2 and I get an error. JBoss starts up and runs, but the PersistenceManager fails. MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM: ObjectName: jboss.mq:service=PersistenceManager state: FAILED I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding Depends On Me: jboss.mq:service=DestinationManager org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Youhave an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TXID FROM JMS_TRANSACTIONS)' at line 1) However, if i connect to MySQL and the jboss DB from the command line, running the query SELECT TXID FROM JMS_TRANSACTIONS; runs fine. Any ideas would be helpful. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3873130#3873130 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3873130 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Installation Configuration] - trouble setting up jboss and mysql
I am new to jboss and for some reason I am having troubles getting jboss setup with mysql. Can someone either help me get it setup or tell me where basically a step-by-step howto would be. I appreciate any help. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3854195#3854195 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3854195 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588alloc_id=12065op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user