Skip site navigation (1) Skip section navigation (2)

UPDATE with alias - P6Spy on JDeveloper

From: andres(at)sayago(dot)info
To: pgsql-jdbc(at)postgresql(dot)org
Cc: "Vadim Nasardinov" <vadimn(at)redhat(dot)com>
Subject: UPDATE with alias - P6Spy on JDeveloper
Date: 2005-09-20 14:48:18
Message-ID: 1944.69.79.131.31.1127227698.squirrel@www.sayago.info (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>


In response to

Responses

pgsql-jdbc by date

Next:From: Vadim NasardinovDate: 2005-09-20 16:47:48
Subject: Re: UPDATE with alias - P6Spy on JDeveloper
Previous:From: Vadim NasardinovDate: 2005-09-20 12:57:50
Subject: Re: UPDATE with database name alias

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group