1. Transaction Exception using JDBC Job Store forums.terracotta.orgI have a job that is executed by Quartz 1.8.5 scheduler My quartz properties is: # Default Properties file for use by StdSchedulerFactory # to create a Quartz Scheduler Instance #::::::::::::::::::::::::::::::::::::::::::::::::::: # Configure the Job Initialization Plugin #::::::::::::::::::::::::::::::::::::::::::::::::::: org.quartz.plugin.jobInitializer.class : org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin org.quartz.plugin.jobInitializer.fileNames : jobconfig/jobs.xml org.quartz.plugin.jobInitializer.failOnFileNotFound : true org.quartz.plugin.jobInitializer.scanInterval : 0 #org.quartz.plugin.jobInitializer.wrapInUserTransaction : true #::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: # Configure Main Scheduler Properties #::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: org.quartz.scheduler.instanceName ... |
2. how to code for ehcache transactions, locking, and race conditions forums.terracotta.org |
3. Ehcache Transaction Search Error: "count", "sum" errors when the cache is "Local" transaction cache forums.terracotta.orgHi, I am using EHcache 2.4.6 and test the sample code in user guide search section. If the cache is none transaction, it works fine. If the cache is "Local" transaction cache, most of the test works fine, only the "count" will return me twice the value. I also tested "sum". Same issue. I debug and found: in Ehcache source class ... |
4. Assertion problem when used with Transaction Controllers jmeter.512774.n5.nabble.com> Hi Guys, > > I'm putting a response assertion at testplan level to > check if any of the sample responses contained the > word error. > My http request samplers are grouped under transaction > controllers that generate a parent sample. > The samplers pass the assertion but the transaction > controller fails with the message below. > > ... |
5. Bug when Module Controllers are named the same in the same transaction controller jmeter.512774.n5.nabble.comHi I have the following structure Disabled Thread Group Simple Controller HTTP Request Thread Group Transaction Controller Module Controller named Test --> Using Simple Controller Defined above Module Controller named Test --> ... |
6. Calculating average response time for each transactions when it contains many images jmeter.512774.n5.nabble.comHi All, I have started using Jmeter recently. I am having a query on how to find out the average respone time of the transaction when it includes images and java scripts as part of its transaction. Because I could see the response time given by Jmeter is less than response time given by Load Runner for the same transaction ... |
7. Capturing transaction ID? jmeter.512774.n5.nabble.comHi, The website I need to test contains off several web transactions you have to execute to get the required result (for example, the steps you need to perform to buy something from an online shope). Some of the pages/transactions contain a variable that is generated by the webserver. This variable is used to check that the user is not cutting ... |
8. constant trhougput on Transaction Controllers. jmeter.512774.n5.nabble.com> Hi! > > I've made a script in witch all requests sent are grouped by Transaction Controllers. > Each Transaction Controller represents an user "click". > > Now I need to controll the amount of Througput an user generates in terms of clicks( instead of sent requests). > > Is there any way to achieve this? > > I've been ... |
9. Controller to keep transaction level as percentage of user load jmeter.512774.n5.nabble.com |
10. Detailed Transactions per Second and Response Time Vs time graphs jmeter.512774.n5.nabble.comHi All, Here is list of some detailed performance analysis graphs that can be generated using JMeter and MeterPlus: * Transactions per Second: This line graph can be used to determine whether the system performance is within acceptable minimum and maximum transaction performance time ranges. Only transaction with status of passed are included to be plotted vs. time. Transaction per second ... |
11. Excluding timer duration from transaction controller runtime jmeter.512774.n5.nabble.com |
12. Fwd: Multi transactional request with data from CSV jmeter.512774.n5.nabble.comHello, I've got a task to prepare multi transactional and multi thread performance test.Data should be get from CSV file. Each request is the same, but the names should increase. For next loop and thread data should change. I'll try to explain it on the sample. I would like to get results like below: Thread 1-1 Request:Name 1, Surname1 ... |
13. Getting error(10%)in listner when no of threads are increased gradually for some transactions jmeter.512774.n5.nabble.comHi I am getting the following error:- jmeter.protocol.http.sampler.HTTPSampler: readResponse: java.io.IOException". Hope this will help in understanding what the issue is. Thanks, Jitendra -----Original Message----- From: sebb [mailto:[hidden email]] Sent: Thursday, June 12, 2008 3:40 PM To: JMeter Users List Subject: Re: Getting error(10%)in listner when no of threads are increased gradually for some transactions On 12/06/2008, Jitendra Kumar Mohanty <[hidden email]> ... |
14. How to control 2 transactions in 2 different web? jmeter.512774.n5.nabble.comThis post has NOT been accepted by the mailing list yet. Hi, I have a load scenario to automate where there are 2 transactions 1st : initiate from 1st website : here users will log into the application with there own user id and password and initiating the transaction. 2nd : confirm the above transaction from another website : here there ... |
15. How to get transaction time into a user defined variable? jmeter.512774.n5.nabble.comHi guys, I want to use a BeanShell Timer to get dynamical think time in transactions. Now I'm trying to use BeanShell PreProcessor and BeanShell PostProcessor in a transaction to get the start and end timestamp like the following: long time2; ${__time(,time2)}; ${__log(${time2},OUT)}; long response = Long.parseLong(${time2})-Long.parseLong(${time1}); long response1 = ${time2}-${time1}; ${__log(${response},OUT)}; ${__log(${response1},OUT)}; But it always logs an error like this: ... |
16. How to use Transaction Controller jmeter.512774.n5.nabble.com |
17. Load time and latency in transaction controller jmeter.512774.n5.nabble.comHi, When using the transaction controller containing 2 HTTP Requests I see that the load time differs from the combined load times of the 2 HTTP Requests and that the latency is not summed up at all. I'm using 2.4 r961953 and both generate parent sample and include timer are enabled, though i'm not using a timer in the controller. Is ... |
18. Managing Transactions with JDBC Sampler jmeter.512774.n5.nabble.comHi All, Has anybody had any luck defining tests that support a number of JDBC SQL statements that constitute a transaction. I'm still very new to JMeter, but I don't see a way within any Controller to define multiple JDBC Requests that constitute a transaction (ie. an all or nothing approach). For a transaction, you would need to ensure ... |
19. Managing Transactions with JDBC Sampler jmeter.512774.n5.nabble.comHi All, Has anybody had any luck defining tests that support a number of JDBC SQL statements that constitute a transaction. I'm still very new to JMeter, but I don't see a way within any Controller to define multiple JDBC Requests that constitute a transaction (ie. an all or nothing approach). For a transaction, you would need to ensure ... |
20. Multi transactional request with data from CSV jmeter.512774.n5.nabble.com> > Re: Multi transactional request with data from CSV > 22616 by: shigella Gazeta.pl > 22624 by: sebb > ---------- Forwarded message ---------- > From: sebb <[hidden email]> > To: "JMeter Users List" <[hidden email]> > Date: Sat, 11 Oct 2008 02:17:47 +0100 > Subject: Re: ... |
21. NTLM failure in between a transaction jmeter.512774.n5.nabble.comHi , I am currently running a test plan which calls four samplers in a loop. To do this I added a HTTP Authorization Manager at the start of the plan and it working fine for the home page. When it enters the loop, it passes for few no. of samples and then fails after a while giving 401 ... |
22. RegEx Config for Transaction Token jmeter.512774.n5.nabble.com |
23. response assertion under transaction controller jmeter.512774.n5.nabble.comMy test setup has a transaction controller set to generate a parent sample, with several http samplers as children, there is also a Duration Assertion. These elements all work, including having the Duration assertion applying to each of the http samplers. Transaction Controler | - http sampler | - http sampler | - http sampler | ... |
24. Samplers vs Transactions jmeter.512774.n5.nabble.com |
25. Save Only Transaction Response Times jmeter.512774.n5.nabble.comHi, I would like to trap all transaction controller response times to their 1 csv. Currently I trap all http samplers and transaction responses times to Aggregate Report as a csv and run a ruby script to extract the Transaction response times. My tests are larger and the csv's are becoming huge. Outside of creating a separate Aggregate report listener ... |
26. Soft coding transaction names jmeter.512774.n5.nabble.comHi, this may be a bit weird requirement, but would appreciate if some one can help me. I am trying to do multiple searches that trigger different queries. I would like to have each thread pick up a different query randomly and execute using a sampler. I would also like to track these queries separately. That is ... |
27. Thread group parameters based on # of transactions on peak hour jmeter.512774.n5.nabble.comHi I have the following transactions on a web application I'm trying to configure the Thread group for: Peak Month approximately 60,000 Txns Peak Day in that month 7,000 Txns and Peak Hour in that day around 600 transactions. My plan, pls advise/recommend any paramter change: application presents an online payment where credit card is entered and submitted... I'm distributing the ... |
28. throughput: transactions vs samplers jmeter.512774.n5.nabble.comHi, Recently I have been using the Throughput Controller together with the Constant Throughput Timer (native) and Throughput Shaping Timer (from JMeter Plugin). I became to understand that the throughput values specified in the timers do not reflect transactions per second, but rather samplers per second. This led me to a rather crucial problem for my test plan, but maybe I ... |
29. Transaction controller and assertion jmeter.512774.n5.nabble.comHello, I am fighting with Jmeter since too many time. Can you help me: I have the following script: Transaction controller -->Http request A -->Http request B -->Http request C -->Http request D When I run this script, the result is response time: tA+tB+tC+tD success= true ==> Until there all is fine Now I want to have something like: Transaction controller ... |
30. Transaction Controller Bug jmeter.512774.n5.nabble.comHi Im using JMeter 2.3.2. I have the following structure Thread Group Transaction Controller HTTP Request BeanShell preprocessor The Pre processor does a sampler.addArgument("test","value"); If the Generate Parent Sample on the Transaction Controller ... |
31. Transaction Controller dosen't work jmeter.512774.n5.nabble.comI am revisiting the problem I have with the Transaction Controller not working on this site. I recorded a very simple Test Plan where the user hits a guest page, goes to page 1, then page 2, and then back to the guest page. I added page 1 and page 2 as children to TC 1 and added the last guest ... |
32. Transaction Controller issue jmeter.512774.n5.nabble.comHi All I am using jmeter 2.4 r961953. Transaction Controller has two options 1. Generate Parent Sample 2. Include Timer duration in the generated sample. I have put timer in the transaction controller with one of the HTTP Sampler. lets say 5 sec If both the options are unchecked, timer duration doesnt gets added to generated ... |
33. transaction controller overall time jmeter.512774.n5.nabble.com |
34. Transaction controller response time differences jmeter.512774.n5.nabble.comHi All, I am new to JMeter, Please help me for below question. 1) When can i use transaction controllers. what is the differences of response time between Generate parent sample checked / unchecked I have executed a sample test plan for simple login and logout scenario: 2) I have executed my test plan ... |
35. transaction controller jmeter.512774.n5.nabble.comThe Transaction Controller is used to combine a group of samples into one combined result. Suppose you have three actions that you are more concerned about how long all three take that than the results for each of the three. You would set it up like this: - Transaction Controller -- Action 1 -- Action ... |
36. Transaction Controller jmeter.512774.n5.nabble.comI have inserted Transaction Controller in my script, which contains HTTP Request HTTPClient and Response Assertions. When I run the Test plan from local machine, the response time from the child process (HTTP Request HTTPClient and Response Assertions)are suming up to the Response time of it's Parent Transaction Controller. But when I run the same script from Remote machine, there is ... |
37. Transaction Controller jmeter.512774.n5.nabble.comSimple Controller seems to mostly be used to group your tests into logical components. This makes it easier to only show the parts of your test that you're interested in, and to move or copy functional units around. The transaction controller seems to fail if any of the statements in it fail. I don't know if it does much other than ... |
38. Transaction Controller jmeter.512774.n5.nabble.com |
39. Transaction Controller jmeter.512774.n5.nabble.comHi., I am having a Transaction Controller with ONLY one HTTP Request in it. In Aggregate report, I am getting the Avg response times different for both the Transaction Controller and the HTTP request. see sample output below. Expand Node to Corporate Account is the transaction Contoller and Expand Node to Corporate Account - HTTP is the HTTP request in that ... |
40. Transaction Controller jmeter.512774.n5.nabble.comAccording to the user manual: "The Transaction Controller times how long it takes for all its children to run." When a user logs into an application I am testing there are two HTTP Request samplers, one that sets the JSESSIONID and another that sends the login request with its parameters. In order to time the login process I created a Transaction ... |
41. Transaction Error. Page has expired jmeter.512774.n5.nabble.comDepends on whether you are trying to emulate what a browser does or give the server indigestion by serving up stale tokens ;-) Seriously. If you want to test how the server responds to normal (i.e. browser) requests, then process the token as a browser would, which presumably means it will only keep it as long as it is in the ... |
42. Transaction time for successfull responses jmeter.512774.n5.nabble.comHi, could anyone help with this request?: I have a jmeter test plan which triggers an email, then 'waits' (in a loop) for 5 minutes max for the email to arrive. If the email does NOT arrive after 5 minutes, the loop is exited and the test starts again (a new email is triggered) I am using the Transaction controller to ... |
43. Transactions per second calculation jmeter.512774.n5.nabble.com |
44. Using Transaction Controller for creating use cases jmeter.512774.n5.nabble.comDear JMeter-Users, I've got the following problem: I am using a transaction controller with the choosen parameter "Generate parent sample" to group Request into UseCases. For example, looks similiar to this: Login (Transaction Controller) |_ Request 1 (HTTP Request) |_ Request 2 (HTTP Request) |_ Request 3 (HTTP Request) Logout (Transaction Controller) |_Request 4 (HTTP Request) |_Request 5 (HTTP Request) |_Request ... |
45. Using transaction controller to count all iterations of each thread jmeter.512774.n5.nabble.com> The Transaction Controller does not calculate throughput, it merely > aggregates samples. > > What Listener are you using? Aggregate report and View Results Tree for specifics on each call. > The ones that do aggregation generally ignore the thread name, and > just aggregate based on the sampler name, so throughput should be > for all threads. So is ... |
46. Wishlist feature for discussion: should Transaction Controllers fail when a child fails? jmeter.512774.n5.nabble.comHi list! One thing I've been doing a lot of lately with JMeter is wrapping a bunch of samplers up behind a Transaction Controller then post-processing the Transaction Controller to produce some pretty graphs (e.g. http://gallery.eggwan.com/v/users/richg/forums/jmeter-output.PNG.html). However, I've hit a snag. If, say, the second page in a three-page HTTP test returns an error, graphs of the Transaction Controller cannot see ... |
47. How to calculate Response time for a web transaction coderanch.com |
48. About JXTA's support for transaction processing coderanch.comI have two words for applying P2P computing to transaction processing: big mistake. Transaction services are widely regarded as the prototype that drives the thin client/fat server model. The things that transaction processors typically rely on -- two-phase commit support, client connection handling, persistence, archive/redo logging, SQL parsing, and so on -- all contribute to a heavyweight construct on the backend: ... |
49. JINI: transactions coderanch.comhi all i need to send some data (serialized objects...) from service A to service B. upon succesful transfer of an ser. object, A must delete files related to this object, B must create files related to this object. i thought about using jini transactions for this. can somebody give me a hint on how to do this ? what part ... |
50. Transaction Management coderanch.com |
51. Need help with Transactions coderanch.com |
52. Corba.TRANSACTION_ROLLEDBACK after 3 method invokations coderanch.comHello all, I am using a PowerBuilder object on an EAServer. I am using a Java stub to instantiate and call methods on this object. It works perfectly fine the first 2 times. On the third run, I get a CORBA.TRANSACTION_ROLLEDBACK exception. I have tried many different configurations dealing with the transaction timeout property, and nothing seems to even change the ... |
53. RMI and Transactions coderanch.com |
54. javax.transaction.Transaction Rolledback Exception: CORBA coderanch.comThe transaction rolled back because an error was thrown during the transaction. This error was - java.lang.OutOfMemoryError. Something is causing your JVM to run out of memory. This could be due to a problem with implementation - Java's version of "memory leaks" - objects not getting de-referenced properly so they are never garbage collected. Or it could be that the program ... |
55. what is the meaning of transaction management coderanch.com |
56. maintaining transaction while updating two different databases coderanch.composted Yesterday 16:48 GMT+0100 (GMT Standard Time) I am listing down my requirement. Please advise me on how to achieve the desired functionality. I have two database systems. One is of a ERP package hosted on JBOSS and other is a standalone database with UIs to change data using ejb hosted on Oracle application server. Now the requirement is that whenever ... |
57. pls help,bank transaction problem coderanch.comhi, i am doing project of ank transaction system.i want the situation like,if more than one user try to make operations on the same account,like depositing amount in same account and transferring amount from same account to some other account,there must be some of the procedures to stop simultaneous resource allocation.that is there should not be deadlock. what can i do ... |
58. Multiple Transactions coderanch.comHello, I am trying to allow my program to accept multiple transaction records. I have created a file creator (CreateData) to populate two text files (oldmast.txt, trans.txt). CreateData will need to be run to create these two files. I have also created a file matching class (FileMatch) to process and write the processed information to newmast.txt and log the unnecessary transactions ... |
59. Transaction please help coderanch.comHi all!! 1.while inserting U got the exception .what does it mean. The values are not inserted.ok 2.what do u mean by rollback.just Undo the part which done lastly after commit.ok. 3.U R getting the exception while inserting means not inserted then how U rollback that one. Hope this is going there. chandran.. |
60. Recent Transaction Records coderanch.comHi, Is there a way to pull the recent 20 records from Oracle Database table without using any field in particular. My table contains fields like , session_id - looks like random number generator timestamp with only date not the time. The table is logged by some application in the background whenever a transaction is occurred. For example , in any ... |
61. doing transaction using jdbc coderanch.com-------------------------------------------------------------------------------- When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed. The last thing you can try is disable auto-commit mode and then commit the transaction. Later you can enable the auto commit mode. con.setAutoCommit(false); // your // SQL ... |
62. Transaction processing coderanch.com |
63. Transaction handling in JDBC coderanch.comHi... Actually You would need to change your architecture a bit...In case of Transaction don't return the connection back to pool, keep it in some hashtable [maintained by a singleton (i.e. single instance class) on server] keeping some ID (say ContextId) as key and connection as value. maintain this ContextId at client end...next time you need the connection to continue/commit/rollback the ... |
64. Cross JVM transactions - Architecture issues coderanch.comI have 3 JVMs (a,b,c) of which JVM-a is the server JVM (say), the server JVM has a transaction manager that keeps tracks of all the local transactions, local connection pools and the resources (connections) it doles out to the other JVMs (b & c) which I call agents. Agents need resources (connections to databases) which the server maintains. Agent b ... |
65. WHY I can't see transaction for jdbc api coderanch.com |
66. Question about TRANSACTION SERIALIZABLE... coderanch.comI know that it's possible to set the transaction isolation level on a Connection object using setTransactionIsolation(int), but I'm not clear as to what affect this has on concurrent updates to the database. Lets say that two clients are using two separate connection objects, both of which have previously called setTransactionIsolation( TRANSACTION_SERIALIZABLE). I know that setting TRANSACTION_SERIALIZABLE on a connection object ... |
67. Transaction or Table Locking? coderanch.comHi List People, I'm starting an app which I would like to make database-independent, e.g. so that it can work on Oracle or mySQL. I would like to have one schema that works on both, no stored procedures and, well that's challenging enough. My first issue: primary keys I'll have an extra helper table (last_key_used) to store the last primary key ... |
68. SQLException: Invalid Transaction State coderanch.comBefore i switch over to my problem let megive u brief description of the way i am handling JDBC connection. I am using jdbc odbc bridge with MS SQL Server 7.0 and jdk1.4 ,a single Connection object and Statement object throughout the project is being used but i also create new Statement objects where it is necessary to get data from ... |
69. transaction problem involving multiple databases coderanch.comI was wondering what is the best strategy, if available, to put couple of database updates into one transaction. These update sqls involve several databases, so usual connection.setAutoCommit(false) does not work here. One basic and maybe stupid way is to establish all connections first, and setAutoCommit(false) to all these connections, and after everything is done and successful, setAutoCommit(true)to all these connections. ... |
70. manual transaction for all JDBC calls coderanch.comFor consistency, I usually have autocommit set to false for all my JDBC calls. I know when it's necessary to have for complex transactions, such as multiple batch queries, insert/update/delete calls and so forth. Is there any performance hit or other issues using manual transactions for single calls (see example below)? Simple example: /* assume dataSource has already been instantiated from ... |
71. Transaction blues coderanch.com |
72. Transaction error(Invalid cursor state) coderanch.comI am using jsp with Oracle.Whenever i use the code "con.setAutoCommit(false)" i get a runtime exception saying invalid transaction state.Without it everything works fine except ofcourse there is no transaction support.I am using multiple statements in the jsp.I have included the code fragment below.what could be the possible reasons.Please help.Thanks in advance. //Import driver and make a connection Class.forName(DRIVER); con=DriverManager.getConnection(URL,"reswebp","reswebp"); //con.setAutoCommit(false); ... |
73. Transaction question coderanch.com |
74. Urgent - Transaction coderanch.comIn sybase (TSQL),"BEGIN TRANSACTION" and "COMMIT TRANSACTION" is used for transaction control. Are these two statements valid for Oracle, Informix or any other DB also? Actually the problem is that for managing transcations I was using JDBC methods - setAutoCommit(),rollback() and commit(). But it caused some conflict with stored procedure setting. The DBA is asking me to use "BEGIN TRANSACTION" and ... |
75. Strange JDBC transaction problem coderanch.comHi, Two JDBC transcations are runned concurrently. They update the same table, but different records. Since they update different records, they should not affect each other. But the result shows that the 2nd transaction cannot continue until the 1st transaction finished. Isolation level is set to Read Commited. I'm using weblogic 6.1 + db2 7.1 Transaction 1 1)transcation begin 2)update record1 ... |
76. transaction question coderanch.comhi ranchers i hope you can help me, probably simple for experts... i need to change some values in the DB in a transaction. so i obtain my Connection from the DataSource, set the Connection to autoCommit = false and then obtain Statements/PreparedStatements from this Connection. after i changed my stuff in the DB i call commit() on the Connection and ... |
77. Transaction Locking Question coderanch.comLet's say that I start a new Transaction. I pull the Autoincremented ID that I need for the transaction from the future new record. And then I lock that record so another transaction can't write to it. So in the mean time, another user has created a new transaction therefor creating a new record. His ID is 100. The ID I ... |
78. A Transaction Question coderanch.comOk, I haven't recieved very many responses to a couple of other questions, so I thought I would post another one that is similar but still different and may make more sense. MySQL-MAX - innoDB table types Connector/J V3 If I begin a transaction with a serilaizable isolation level and then move my result set to a new record, will my ... |
79. Multi-threading issues while handling JDBC transactions coderanch.comI have 5 threads running, each thread tries to insert some records into the database. Each thread is unaware of what the other thread is processing. In this scenario when one of the thread out of 5 is facing some problem while inserting into database, it tries to rollback its own transaction. Is it possible to rollback the transactions of the ... |
80. JDO and transactions coderanch.comCraig implemented JDO within the Sun One CMP environment, so he can provide you with more complete details, but yes, JDO can work with either container managed transactions or bean managed transactions. The JDO implementation must provide some integration in order to interoperate with the application server's transaction manager. In the case of using JDO against a file, the JDO implementation ... |
81. Transaction coderanch.com |
82. Transactions and Threading coderanch.comHi all, I am new to web based programming.. This is my problem: I have a Jsp page (jsp1) which takes some input from the user (say his name) thru a text field. Now I call a Java class file which stores this name into a database(MySql). I have another jsp page (jsp2) which displays the names stored in the databse. ... |
83. JDBC , Transaction related question coderanch.comHi, please share ur answers/opinions regarding foll questions: Q. Which of the following will not get the data from the first column of ResultSet rs, returned from executing the following SQL statement: SELECT name, rank, serialNo FROM employee a. rs.getString(0); b. rs.getString("name"); c. rs.getString(1); Q. Which of the following statements about Transactions are true ? a. A database does not support ... |
84. JDBC and Transaction Management coderanch.com |
85. how to do transaction management? coderanch.comHi all, I have little knowledge about "how to transaction control" via JDBC. Here is what I know, - we can set Connection to not commit queries automatically - we can then group our logical operations together sharing that one connection - then once we are sure that all those individual operations got over successfully we can call commit() on the ... |
86. Transaction over multiple tables coderanch.comCan you maintain a Transaction over multiple Table inserts? I will be entering data into Table1 and retrieving the ID then entering that ID and other data into Table2 then possibly a 3rd Table. (Normalization, ha). If any one of those inserts fail for any reason, I don't want any of them to happen. And I just didn't know if you ... |
87. Savepoints and transactions coderanch.comHowdy all, Here's my question. Given the following code: Connection conn = null; SavePoint savepoint = null; try { conn = ConnectionPool.getConnection(); dao mydao = new mydao(); mydao.task(conn); savepoint = conn.setSavepoint("Beginning"); conn.commit(); mydao.anotherTask(conn); conn.commit(); mydao.finalTask(conn); conn.commit(); } catch(Exception e) { conn.rollback(savepoint); // try/catch removed for clarity } finally { conn.close(); // try/catch removed for clarity } If I were to rollback ... |
88. Save point in Java Transactions coderanch.com |
89. Problem in rolling back some transactions. coderanch.comHai All, I am finding diff in rolling back some transactions. Actually in my application (ie in Servlet) i have 5 callable statements to execute 5 stored procedures. cstmt1,cstmt2,cstmt3,cstmt4,cstmt5 I have one connection object. I have to execute these stored procedures in sequence. If any stored procedures returns non zero value i have to stop execution and roll back all the ... |
90. Transactions! coderanch.comHi Kriti, What you describe is the correct way to perform a mulit-statement transaction in JDBC. I don't know about Weblogic ... perhaps one for the Weblogic forum? I expect that the issue of how you go about committing would depend on whether your transaction is distributed, e.g. whether you're using full J2EE with container managed persistence and so on. I'm ... |
91. Trigger after transaction coderanch.comJulian, I am working for a product development team, so I can't assume that the user will use a particular database. I am not using just one table. I am inserting in two or more tables, and I want a trigger to be generated after the transaction is committed. I set connection's autocommit to false, and commit at the end of ... |
92. Commiting a transaction from J2EE coderanch.com |
93. JDBC Transaction Setting coderanch.comhello people.. I wrote a java code to know the transaction process. I clearly set the AutoCommit into false. Then I forcibly disable the commit just for checking purpose. But the database changes whenevewr the statement executes. I have given below the code. It should not update the database .But it does.I dont know where I am missing the technical things.. ... |
94. test JDBC transaction coderanch.commay be this is because of MySQL. i found MySQL and Access wiered sometimes. It doesn't support the transaction management. I have a good experience with Oracle, but not with MySQL. hope someones knows the actual cause. but again i think MySQL sucks. I have heard something bad like the same about MySQL from ranchers. |
95. Transaction coderanch.comOriginally posted by adeel ansari: Shailesh could you elaborate Dear Adeel, I am not very accomplished so I just wanted to learn from you the facts on basis of which we can say sugar in place of tea is a transaction . if yes then definitely it would a failed transaction. eg: I customer ask for tea and shopkeeper doesnt offer ... |
96. Transaction management coderanch.comI have a scenerio as below I have two data stores one is SQL Server and other LDAP. When I insert a record in SQL Server and should also insert into LDAP. Steps I am calling a stored procedure to insert into SQL Server database After that I call LDAP API to insert into LDAP I should roll back SQL server ... |
97. difference between transaction Isolation Level 1 & 2 coderanch.com |
98. DAO And Transaction Management Books coderanch.com |
99. question about transaction coderanch.com |
100. Transactions ACID Advice coderanch.comI am executing a transaction against a single database. AND HANDLE IT SO: Connection.setAutocommit(false); // for ATOMICITY of ACID Connection.setIsolationLevel(TRANSACTION_READ_COMMITTED); // for ISOLATION of ACID PROBLEM: I guess setAutocommit(false); is a Must FOR the 2nd stage... true? B'cos I have some special insert queries which must execute in autocommit(true) modus. But I am handling all the DB-Story in a central way. ... |