[JBoss-user] [Beginners Corner] - how to config to make the transaction work?
hi, i am using jboss 3.2.5, mysql 4.0, Eclipse 2.1, lomboz 2.1, xdoclet i dont know why the operation(insertUser) does not roll back even i call setRollbackOnly(). /** * @ejb.interface-method * @ejb.transaction type="Required" */ public void processPass (Hashtable order) throws Exception { insertUser(); //db connection is fine. succeed all the time try { processOrder(order); //i made this throw a fileNotFound exception } catch (Exception e) { e.printStackTrace(); sessionContext.setRollbackOnly(); //coz processOrder() fails, i expect insertUser() //rolls back...but it never happened } } i can not figure out what is wrong. here are my config files: {jboss_home}/server/default/config/jboss-service.xml never been changed {jboss_home}/server/default/deploy/transaction-service.xml never been changed {jboss_home}/server/default/deploy/mysql-ds.xml is like this: DefaultDS jdbc:mysql://localhost:3306/mytest com.mysql.jdbc.Driver root 1234 the code should have no problem, i guess i might missed something in one config file...any help plz. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3865754#3865754 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3865754 --- 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=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - INSERT never rolls back
hi, i am using jboss 3.2.5, mysql 4.0, Eclipse 2.1, lomboz 2.1 code snippet: /** * @ejb.interface-method * @ejb.transaction type="Required" */ public void processPass (Hashtable order) throws Exception { insertUser(); //db connection is fine. succeed all the time try { processOrder(order); //i made this throw a fileNotFound exception } catch (Exception e) { e.printStackTrace(); ctx.setRollbackOnly(); //coz processOrder() fails, i expect insertUser() //rolls back...but it never happened } } i can not figure out what is wrong. here are my config files: {jboss_home}/server/default/config/jboss-service.xml never been changed {jboss_home}/server/default/deploy/transaction-service.xml never been changed {jboss_home}/server/default/deploy/mysql-ds.xml is like this: DefaultDS jdbc:mysql://localhost:3306/mytest com.mysql.jdbc.Driver root 1234 did i miss anything in datasource config file? what extra step(s) do i need to set the transaction support in jboss? any difference about tx between 3.2.5 and 4.0 ? thanx View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3865629#3865629 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3865629 --- 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=6595&alloc_id=14396&op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - jboss error on persistencemanager after switching from hyper
Hi, friends: i am useing jboss3.2.1, mysql4.0. after i set up mysql datasource, connection is ok. but jboss gives me the following error messages. i also did a little search. some people has the same problem and solved it by modifying some config/setting files. but i don't know which ones. does this problem in FAQ or any links? thanx in advance. 12:26:39,828 INFO [PersistenceManager] Starting 12:26:39,843 ERROR [STDERR] Query "SET autocommit=0" execution time: 0 12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping 12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping 12:26:39,890 ERROR [STDERR] Query "rollback" execution time: 0 12:26:39,890 ERROR [STDERR] Query "SET autocommit=1" execution time: 0 12:26:39,890 ERROR [STDERR] Query "SHOW VARIABLES LIKE 'tx_isolation'" execution time: 0 result set fetch time: 0 12:26:39,890 ERROR [PersistenceManager] Starting failed org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: 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 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1") at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:276) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1299) . . . View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849356#3849356 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849356 --- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - mysql connection ok, but org.jboss.mq.SpyJMSException: Could
HI: i am useing jboss3.2.1, mysql4.0. after i set up mysql datasource, connection is ok. but jboss gives me the following error messages. i also did a little search. some people has the same problem and solved it by modifying some config/setting files. but i don't know which ones. does this problem in FAQ or any links? thanx in advance. 12:26:39,828 INFO [PersistenceManager] Starting 12:26:39,843 ERROR [STDERR] Query "SET autocommit=0" execution time: 0 12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping 12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping 12:26:39,890 ERROR [STDERR] Query "rollback" execution time: 0 12:26:39,890 ERROR [STDERR] Query "SET autocommit=1" execution time: 0 12:26:39,890 ERROR [STDERR] Query "SHOW VARIABLES LIKE 'tx_isolation'" execution time: 0 result set fetch time: 0 12:26:39,890 ERROR [PersistenceManager] Starting failed org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: 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 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1") at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:276) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1299) . . . View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849180#3849180 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849180 --- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - how to run default instead of all in jboss3.2.1 in tutorial?
i am following tusc tutorial with jboss3.2.1 eclipse2.1 lomboz2.1.2 jboss is running fine except a HAJNDI exception. after some research, i found HAJNDI is a mbean for cluster and i am running against "all" config. my questions are: 1. how to eliminate the HAJNDI problem? 2. if i run default config, will it get rid of HAJNDI service? then how can i start default config in lomboz? 3. whenever i compile the ejb, i need change the "ejb-ref" to "ejb-local-ref" in ejb-jar.xml and "COMP" to "JNDI" in *Util.java. is there a correct xdoclet to get rid of these problems once for all? thanx in advance View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3848099#3848099 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3848099 --- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - Re: dev w/ jboss3.2.1 on pc, move to production ....
thank you for your advice, darranl. you are right. i can change both to jboss3.2.3 then how about development on pc and production on solaris x86? will i have serious deploy problems? i guess there should have no problem coz i just drop jar/xml file. am i right? thanx View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847602#3847602 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847602 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - dev w/ jboss3.2.1 on pc, move to production ....
develop w/ jboss3.2.1 on pc, move to production running jboss3.2.3 on solaris x86. using jboss3.2.1 eclipse2.1 lomboz2.1.2 to develop. is there anything i need to pay paticular attention? such as path difference, version difference? any article or link to share? thanx View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847474#3847474 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847474 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - develop w/ jboss3.2.1 on pc, move to production running jbos
is there anything i need to pay paticular attention? such as doclet.xml or path change? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847473#3847473 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847473 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - problems on chapter 3 (StoreAccessDAOImpl)
Hi, i am new in ejb world. and i found this excellent tutorial. all my thanks and respect to the author(s). i really would like to finish to the end. but i bumped a small problem in chapt3. system: jboss 3.2.1 eclipse 2.1 lomboz 2.1.2(2.1_02 is no longer avail) after i inserted @dao.call name="loginUser" into StoreAccessBean, generateed EJB classes for MyStoreMgr, i found StoreAccessDAOImpl is not populated. i expect init() and loginUser() will show in StoreAccessDAOImpl. but it stays as public class StoreAccessDAOImpl { } i dont mink add all the lines, but if it should be populated and did not come up, i am worrying maybe something is wrong and might get stuck later on. lomboz 2.1.2 uses xdoclet.xml instead of ejbgenerate.xml. that might be the only reason. but i am not sure. any help plz? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847156#3847156 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847156 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - StoreAccessDAOImpl problem in tutorial chapter 3
Hi, i am new in ejb world. and i found this excellent tutorial. all my thanks and respect to the author(s). i really would like to finish to the end. but i bumped a small problem in chapt3. system: jboss 3.2.1 eclipse 2.1 lomboz 2.1.2(2.1_02 is no longer avail) after i inserted @dao.call name="loginUser" into StoreAccessBean, generateed EJB classes for MyStoreMgr, i found StoreAccessDAOImpl is not populated. i expect init() and loginUser() will show in StoreAccessDAOImpl. but it stays as public class StoreAccessDAOImpl { } i dont mink add all the lines, but if it should be populated and did not come up, i am worrying maybe something is wrong and might get stuck later on. lomboz 2.1.2 uses xdoclet.xml instead of ejbgenerate.xml. that might be the only reason. but i am not sure. any help plz? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847154#3847154 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847154 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Beginners Corner] - need help for j2ee1.3 for jboss3.2.3
hi, i am running jboss3.2.3, ant1.5, jsdk1.4.2, mysql4.0 on a x86 box with Solaris9 os. my questions are: 1. i guess i need either j2ee1.3 or 1.4 to compile my application to run in jboss, right? 2. Sun does not support solaris-x86 version j2ee1.3, and j2ee1.4 comes with Sun's AS, what is the way work around? 3. the final production machine is solaris-x86. if i use w2k as my development platform, when pushing to production, will i have problems? thanx View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846808#3846808 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846808 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user