Dodgy SQL and Dodgy Products

16 thoughts on “Dodgy SQL and Dodgy Products”

1. Hi Tim,

   Recently I gave a list of links for blogs on Oracle to be published in my company newsletter. The editors after reading your blog (specially the part on Oracle Application Server) decided not to include it and I got a frown for my comment :).

   Cheers
   Amar

2. Sorry mate!

   I never promised my views would nice 🙂

   Cheers

   Tim…

3. Call as you see it.

   Thanks for the warnings.

4. adewri said…Recently I gave a list of links for blogs on Oracle to be published in my company newsletter. The editors after reading your blog (specially the part on Oracle Application Server) decided not to include it and I got a frown for my comment :).

   Give them DKB’s blog instead and how quickly they will take Tim’s blog over that one!!! 😀 😀

5. OK, there’s a fair bit of venom today, but I find it really frustrating when products that cost loads of cash just don’t do what they say on the box.

   OCS is not fit for an enterprise environment.

   The App servers are a joke. Apache is a great product, and very stable when used with other kit like PHP or Tomcat, but when Oracle added all that other rubbish they made it memory and CPU hungry and killed any hope of reliability.

   Let’s hope the whole fusion thing is more than lip service. perhaps they might get all the middleware and application sorted at last…

   And I’m not the first to say that the database is getting very buggy these days. I tend to agree that Oracle seem too distracted by adding more features, rather than making the basics work.

   Hopefully tomorrow will go a little better.

6. Craptastic
   did you copyright that, or can I use it?

   Oracle applications are a total mess as well.
   You must need patch #….

7. Can’t agree with you more, Tim. I got stuck into the local user’s group management because of precisely this. Too much wind on all the “craptastic” stuff (I love that term!) and no one talking about the real issues we all have to put up with every day.

   It takes 30 seconds of OEM and resource manager “wizard” to make a 9i database utterly and completely go bonkers with 600 errors! For Pete’s sake: the darn thing has been out for how many years now and NO ONE has fixed the bug???? Unbreakable, eh?

   (Yeah, it’s “fixed in 10gr2”: WTH cares? I’m running 9i NOW, I want it fixed THERE!)

   You can’t even setup a MV environment for read-only snapshot replication between two databases without having to go into Metalink: one of the required dblinks is not documented anywhere else and OEM and repcat_admin STILL don’t know about it.

   Let’s not even go into how hard and confusing it is to setup aio for file systems with 9i and RHAS3. And this is their “preferred” OS platform!!!

   It’s beyond ridiculous. And yet, all the feedback that is going to Oracle via UGs is the same old same old PC “slap in the back” crappola. No wonder they’re spending their time with the ridiculous “fusion”: they’re not getting half the story from the field!

   I wanna see the “fusion” do a J2EE container startup with 26000 tables in EJBs: that will be fun, given that the most I’ve ever seen at any time was 300 tables and that was on a Godzilla-box! Hasn’t anyone in Oracle yet woken up to the fact J2EE is the WRONG technology for fusion?

   Cripes, talk about shooting themselves on the foot…

   It’s gotten so bad I’m seriously thinking of recommending to management they look at alternatives when they do the next round of “future gazing”!

8. I wonder if J2EE actually works with Oracle AS without any performance or maintainance issues… Isn’t HTMLDB a better and stable option.

   The way they are marketing OracleAS they should do the same with HTMLDB. Most people have never heard of HTMLDB.

9. Theory:
   HTML DB is not as scalable because you are doing both the procedural and data work on the database. The idea of J2EE is that the procedural work is taken on by the App Server, leaving the DB to do the data stuff. Also, J2EE has fantastic scaling, you can cluster onto many boxes.

   Practice:
   AskTom is written in HTML DB, and just the plain PL/SQL Web Toolkit before that. I doubt many companies get the hitrates Tom does. With that in mind, can you really question the scalability of HTML DB?

   Also, J2EE sucks!

   🙂

   Tim…

10. By the way, I’m not sure I can claim craptastic for myself. A comedian called Harry Enfield used to do a sketch called “Smashy and Nicey” with Paul Whitehouse (from the Fast Show) about two aging radio DJs. Paul Whitehouse’s character used to put “tastic” onto the end of loads of words, hence craptastic.

    I remember Bart Simpson saying Craptacular, which is also very special 🙂

    Cheers

    Tim…

11. “Also, J2EE has fantastic scaling, you can cluster onto many boxes.”

    Small clarification: the J2EE boffins CLAIM that it has fantastic scaling. Meanwhile, anyone who needs such with anything slightly more complex than a shopping cart is NOT using J2EE!

    I wonder why…

12. Nuno: it was under my “Theory” section. I didn’t say it was true 🙂

    Cheers

    Tim…

13. Woohoo – great stuff …

    Isn’t OCS some serious shite … we couldn’t even get it running … got an Oracle consultant on-site – he gave up on it after 4 days installing, reinstalling, patching, installing …

14. Let’s just say OCS isn’t very good 🙂

15. oracle employees call it internally the Collaps Suite. Eat your own dogfood, you know.

    I guess the last one who criticized j2ee within oracle is already long gone.

16. J22E is a joke

Comments are closed.