UPDATE with alias - P6Spy on JDeveloper

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.JdbcConnectionWrapper.createConnection(JdbcConnectionWrapper.java:130)
    at
oracle.jdeveloper.cm.JdbcConnectionWrapper.getJdbcConnection(JdbcConnectionWrapper.java:181)
    at
oracle.jdeveloper.cm.JdbcConnectionWrapper.getPresentation(JdbcConnectionWrapper.java:168)
    at
oracle.jdevimpl.cm.dt.browser.jdbc.JdbcBrowser.openConnectionBrowser(JdbcBrowser.java:208)
    at
oracle.jdeveloper.cm.dt.ConnectionNode$NodeOpen.doWork(ConnectionNode.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:
>> > JDeveloper use alias to UPDATE, an dthen, what can I do?
>> >
>>
>> Your only option would be to ajdust the postgresql backend grammar
>> to allow an alias.
>
> 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=antlr+SQL+grammar
>  http://www.google.com/search?q=JavaCC+SQL+grammar
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>