Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Object Types and Java (migrating from mod_plsql)

Re: Oracle Object Types and Java (migrating from mod_plsql)

From: Thomas Kyte <>
Date: 18 Feb 2005 06:56:10 -0800
Message-ID: <>

In article <>, Thanatos says...
>Here's a concept, let me know if you like or hate the idea.
>Current Application (Single Tier)
>PL/SQL stored procedures generating 50 million pages a month via
>mod_plsql (htp.p etc)
>Main problem: scalability

ahh, but what isn't scaling out?

is it "we cannot run anymore sql", well, moving to java isn't going to make the sql run any faster (in fact, my experience is the opposite is true, the java programmers tend not to write the best sql, the database needs become larger then when we had database programmers in there).

have you identified what isn't "scaling" about your situation? before you propose a fix, you need to identify exactly what is "broken"

You are already 3 tier, you have a client (browser), a web server (apache), and a database spitting out data.

>Proposed Architecture (2 tier)
>Re-write stored procedures as Oracle Object Types.

that doesn't make sense -- what do you mean by "rewrite stored procedures as object types"?

>Create Java access classes to these objects (via Jpublisher for
>Create .jsp application to use the Oracle Objects via the access
>not rewiting everything in Java
>application tier is scalable
>Why not 3 tier? Well this stlye of article has largly convinced me:

but you are 3 tier - in both cases above, you are decidely 3 tier.

>Whilst the above idea seems to be a stab in the dark, it does try to
>address the following problem:
>How do I scale a large scale pl/sql mod_plsql application without
>having to rewrite the entire application (without purchasing additional
>oracle licencees - or indeed without purchasing OracleAS)
>Tricky question nay?

Thomas Kyte
Oracle Public Sector
opinions are my own and may not reflect those of Oracle Corporation
Received on Fri Feb 18 2005 - 08:56:10 CST

Original text of this message