transaction 2 « Transaction « Java Database Q&A





1. Transaction Exception using JDBC Job Store    forums.terracotta.org

I 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 ...

3. Ehcache Transaction Search Error: "count", "sum" errors when the cache is "Local" transaction cache    forums.terracotta.org

Hi, 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.com

Hi 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.com

Hi 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.com

Hi, 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 ...





10. Detailed Transactions per Second and Response Time Vs time graphs    jmeter.512774.n5.nabble.com

Hi 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.com

Hello, 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.com

Hi 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.com

This 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.com

Hi 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.com

Hi, 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.com

Hi 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.com

Hi 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.com

Hi , 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.com

My 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.com

Hi, 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.com

Hi, 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.com

Hi 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.com

Hi, 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.com

Hello, 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.com

Hi 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.com

I 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.com

Hi 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.com

Hi 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.com

The 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.com

I 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.com

Simple 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.com

Hi., 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.com

According 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.com

Depends 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.com

Hi, 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.com

Dear 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.com

Hi 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 ...

48. About JXTA's support for transaction processing    coderanch.com

I 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.com

hi 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.com

Hello 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.com

The 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 ...

56. maintaining transaction while updating two different databases    coderanch.com

posted 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.com

hi, 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.com

Hello, 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.com

Hi 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.com

Hi, 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.com

Hi... 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.com

I 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 ...

66. Question about TRANSACTION SERIALIZABLE...    coderanch.com

I 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.com

Hi 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.com

Before 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.com

I 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.com

For 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.com

I 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.com

In 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.com

Hi, 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.com

hi 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.com

Let'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.com

Ok, 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.com

I 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.com

Craig 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.com

Hi 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.com

Hi, 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.com

Hi 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.com

Can 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.com

Howdy 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.com

Hai 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.com

Hi 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.com

Julian, 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.com

hello 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.com

may 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.com

Originally 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.com

I 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 ...

98. DAO And Transaction Management Books    coderanch.com

99. question about transaction    coderanch.com

100. Transactions ACID Advice    coderanch.com

I 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. ...