PostgreSQL JDBC - UPDATE with alias

Author

UPDATE with alias - P6Spy on JDeveloper

andres@sayago.info

2005-09-20, 1:24 pm

Thanks Vadim, but I have another problem.

I can't install P6Spy on JDeveloper. I tried using the instructions, but
in the P6Spy READ file don't exist about JDeveloper.

I tried replacing, in the JDeveloper connections, the PostgreSQL driver
"org.postgresql.Driver" by "com.p6spy.engine.spy.P6SpyDriver", and then
configuring the "spy.properties" file with the correct realdriver, but I
get the following message:

-----
oracle.jdeveloper.cm.CMException: Unable to instantiate driver:
com.p6spy.engine.spy.P6SpyDriver
at
oracle.jdeveloper.cm. JdbcConnectionWrappe
r. createConnection(Jdb
cConnectionWrapper.java:130)
at
oracle.jdeveloper.cm. JdbcConnectionWrappe
r. getJdbcConnection(Jd
bcConnectionWrapper.java:181)
at
oracle.jdeveloper.cm. JdbcConnectionWrappe
r. getPresentation(Jdbc
ConnectionWrapper.java:168)
at
oracle.jdevimpl.cm.dt.browser.jdbc.JdbcBrowser. openConnectionBrowse
r(JdbcBrowser.java:208)
at
oracle.jdeveloper.cm.dt. ConnectionNode$NodeO
pen. doWork(ConnectionNod
e.java:210)
at oracle.jdeveloper.cm.dt.ProgressRunnable. run(ProgressRunnable
.java:165)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:540)
at java.lang.Thread.run(Thread.java:534)
-----

Anyone know this? :(

Andrés

> On Monday 19 September 2005 18:46, Kris Jurka wrote:
>
> In practical terms, you're right.
>
> In theory, this may also be addressed by using a wrapper JDBC driver
> like P6Spy (but not as buggy) that would sit between the application
> and the real PostgreSQL JDBC driver. The wrapper driver would have
> the opportunity to rewrite UPDATE statements in a spec-compliant
> manner before passing them on to the real driver.
>
> http://sourceforge.net/projects/p6spy/
> http://www.google.com/search? q=ant...+grammar

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Vadim Nasardinov

2005-09-20, 1:24 pm

On Tuesday 20 September 2005 10:48, andres@sayago.info wrote:
> I can't install P6Spy on JDeveloper. I tried using the instructions, but
> in the P6Spy READ file don't exist about JDeveloper.

P6Spy is a waste of time. I only mentioned it as an example of an existing
wrapper that kinda sorta does something similar to what you'd have to do
if you chose to fix up Oracle's broken UPDATE statements without changing
the backend SQL grammar on the PostgreSQL server side.

If you are seriously considering going down this path, you might be better
off starting from scratch. In any case, this is not the right list to ask
about P6Spy. Try
http://sourceforge.net/forum/?group_id=49288

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links