Tagged Questions
0
votes
0answers
36 views
MySQL second connection does not see committed change from first connection
I have a problem with a Grails based application that is connected to MySQL where there is a process that updates a record as part of a larger transaction. This process also kicks off a 2nd thread via ...
0
votes
0answers
53 views
I get last insert value but I don't see such a record in the table
I am having an issue with an insert statement. Once I process a query using PDO I display on my screen the last inserted id. it displays this number 4344484. But when I search for 4344484 in my table ...
1
vote
4answers
82 views
PHP: my page takes a very long time to load but does not time out. Are there too many queries at once or can my code be optimized?
This is the function I use to access the DB, theoretically maybe up 10-20 times in a do while loop, though right now I removed the loop so it only can do one db query at a time. Can this be optimized ...
1
vote
1answer
79 views
Does mysql_query commit everything
I am using mysql extension in php, I know it is deprecated as of PHP 5.5.0, but I have a lot of code allready written with the use of this extension.
It seems to me like mysql_query commits the query, ...
0
votes
0answers
95 views
Java MySQL calling commit() on a large EntityTransaction object failed
I have a large javax.persistence.EntityTransaction object, say ent, when I called the method commit() on this object (to insert a new record into my (MySQL) table:
ent.commit();
I got the quere ...
0
votes
1answer
106 views
Can MySQL commit fail if individual queries works? [duplicate]
Possible Duplicate:
Can a COMMIT statement (in SQL) ever fail? How?
Can a commit query fail if all queries within the transaction returned a working result?
I have a $ok = ...
0
votes
0answers
69 views
Software to backup mysql and commit to Bitbucket? [closed]
I am struggling to find a solution to enable automatic backup of a MySQL database and commit(and push) it to a bitbucket account?
Is there a piece of software which can do this, or will I need to ...
3
votes
1answer
111 views
Problems with “commit” after SQL INSERT with Python and SQL
I made a loop in Python that calls itself to repeatedly check for new entries in a database. On first execution, all affected rows are shown fine. Meanwhile, I add more rows into the database. On the ...
0
votes
2answers
100 views
how to use commit to save all query and if any one query failed no data should be save
I have an employee form.In that i have used tabbed pane to get four different tabs.But problem is that if i save data on first tab only it get saved in database. and before saving data on other tabs i ...
0
votes
1answer
56 views
Too many selects in a second - Mysql
I have a system that sends emails for me and my clients every day in the morning. This process is triggered automatically through access to my website, via an iframe.
Often, I receive the same email ...
0
votes
1answer
71 views
How to tell if error occured in MySQL client script
I can't discover how to tell if an error occurred in a MySQL client script (after a couple of hours googling and reading the MySQL docs. I would expect there would be something like an error flag or ...
0
votes
1answer
90 views
Max value from auto commit false table
My problem is i have set a table auto commit false. I need to get the max id from that table(the currently inserted value of auto increment id). But i am getting the id of the previous committed ...
-2
votes
1answer
110 views
Commit/rollback using java from jsp Page
I call various java class file for inserting data to tables from jsp page. sometime the datas are not inserted in all tables. So, it create integrity how to avoid this problem using commit/roll back ...
0
votes
0answers
9 views
how to tweak application for any particular (stated) feature of MySQL or any DB
MySQL documentation says
Blockquote
If your applications are written in a way that is dependent on being able to call ROLLBACK rather than COMMIT in critical situations, transactions are more ...
0
votes
1answer
574 views
MySQL rollback on duplicate key
I'm looking forward use transaction and rollback in case of error (like duplicate keys or else).
When I disable the autocommit and when the error came, transactions has been commited even if they ...
