meta user
network profile
| bio | website | sqlfiddle.com |
|---|---|---|
| location | Vancouver, WA | |
| age | 31 | |
| visits | member for | 1 year, 5 months |
| seen | Apr 15 at 13:09 | |
| stats | profile views | 46 |
Web Developer (strengths in ColdFusion, SQL, jQuery)
twitter - @sqlfiddle
Developer of http://sqlfiddle.com
|
Jun 10 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state @NickChammas I had thought about that approach, but due to memory concerns I'd prefer not to go that route. |
|
Jun 8 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state @NickChammas I need to disable commits so that I can keep the schema (as defined by the left side panel) in a fixed state. There could be any number of people writing queries against the same schema trying to solve the same problem. To prevent them from interfering with each other, I need to be sure to keep the structure and data from changing. This is accomplished via rolled-back transactions, but that doesn't happen if the right-side code is committed. |
|
Jun 8 |
revised |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state Updates |
|
Jun 7 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state @Phil ah! Sorry, I was being a bit slow there. Yeah, that is a cool idea. Might be able to use that. |
|
Jun 7 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state @Phil the only problem there is that I don't have (and don't really want) control over the definition of each of the tables (those are defined on the left panel). So that DEFERRABLE INITIALLY DEFERRED clause wouldn't be there (unless there is some way to do that automatically for all tables - say via a system trigger that responds to create table statements? Ugh) |
|
Jun 7 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state Worth mentioning - I also did a lot of research looking into "pre-commit" triggers. It appears those do not exist, so unfortunately that's not an option either. |
|
Jun 7 |
asked | Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state |
|
May 22 |
comment |
Complex MySQL Query returning almost all the correct rows I don't think it's a bug in SQL Fiddle (btw - sql fiddle is my site). The site is structured in such a way that would make such a bug very unlikely. |
|
May 22 |
comment |
Complex MySQL Query returning almost all the correct rows I see that your tblorderitems table only has references to invoiceid=275, but your tblinvoices table (which you are attempting to join) has no reference to that id. This is why you are getting (null) values for your grossprice subselect. I haven't looked at the other subselects too closely, but I suspect a similar issue. |
|
May 22 |
comment |
Complex MySQL Query returning almost all the correct rows What exactly about the calculated columns isn't working in the SQL Fiddle link? The fact that they are showing "(null)"? |
|
May 20 |
comment |
Group by minute and two minute intervals Thanks for the heads up regarding GO <int> - I didn't even know that was an option for GO. I'll add it to the list of enhancements for SQL Fiddle (my site). |
|
Mar 22 |
comment |
Oracle build_plan_xml visualizer Thanks for your answer, phil. Text would suffice if there were no convenient graphical alternatives, but as you can see now I've got the Oracle flash-based execution plan viewer working. I think this format is preferable for my specific case. Your tips would certainly be useful for people looking to solve similar problems, however. |
|
Mar 22 |
comment |
Oracle build_plan_xml visualizer Sigh, gotta love Oracle. It works when you go to bed and breaks by the time you wake up.... Anyhow, it's working now. Hopefully it will continue to do so. |
|
Mar 22 |
comment |
Oracle build_plan_xml visualizer Thanks for your tip! I've updated the site to use the flash viewer behind the "ACTIVE" option (Check out this link to see it in action: sqlfiddle.com/#!4/ee7da/596). Had to do some serious mucking around with Oracle's HTML and JS to get it to work, but finally managed to do so. Thanks! |
|
Mar 21 |
awarded | Benefactor |
|
Mar 21 |
accepted | Oracle build_plan_xml visualizer |
|
Mar 20 |
revised |
Oracle build_plan_xml visualizer added 294 characters in body |
|
Mar 15 |
awarded | Promoter |
|
Mar 13 |
comment |
Oracle build_plan_xml visualizer @a_horse_with_no_name thanks I'll definitely look at that. |
|
Mar 12 |
asked | Oracle build_plan_xml visualizer |
