SQLQueryPlugin v1.0.6 released

Hi,
I was able to connect to the oracle db..I am able to see the tables and columns but I am not able to run the query. The play button seems to be disabled. I have Idea Build #660.

Please advice as to what I am doing wrong.

Thanks.

-- Naveen

I was able to connect to the oracle db..I am able to see the tables and

columns but I am not able to run the query. The play button seems to be
disabled. I have Idea Build #660.
>

Please advice as to what I am doing wrong.

I was going to say works for me, when contagion seemed to come in here and
it didn't work any more. Are you sure your message didn't contain a virus?

After trying several times, restarting idea, closing all editors (x button),
creating a new one (+ button) and writing text in the editor, the play
button enabled itself.

Works for me.

Exception after connection is killed externally:

This exception always happens when hiding the sql query tool window after
the connection is killed in the oracle dba studio.


java.sql.SQLException: ORA-01012: not logged on

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oclose.receive(Oclose.java:126)
at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.java:539)
at
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:692)
at
oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:1
875)
at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1104)
at com.kiwisoft.db.Database.closeConnection(Database.java:70)
at
com.kiwisoft.db.DatabaseManager.closeAllConnections(DatabaseManager.java:38)
at com.kiwisoft.idea.MainPanel.removeNotify(MainPanel.java:144)
at java.awt.Container.removeNotify(Unknown Source)
at javax.swing.JComponent.removeNotify(Unknown Source)
at java.awt.Container.removeNotify(Unknown Source)
at javax.swing.JComponent.removeNotify(Unknown Source)
at java.awt.Container.removeNotify(Unknown Source)
at javax.swing.JComponent.removeNotify(Unknown Source)
at java.awt.Container.removeNotify(Unknown Source)
at javax.swing.JComponent.removeNotify(Unknown Source)
at java.awt.Container.removeNotify(Unknown Source)
at javax.swing.JComponent.removeNotify(Unknown Source)
at javax.swing.JRootPane.removeNotify(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at javax.swing.JDialog.remove(Unknown Source)
at com.intellij.openapi.wm.impl.p.run(p.java:3)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.intellij.ide.p.a(p.java:88)
at com.intellij.ide.p.dispatchEvent(p.java:40)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

I know of this problem. Because of some reasons the listener for the first query is killed. A simple workaround is to
close the first query panel and open a new one.

This exception is catched internally and is printed
for information only. It should not effect the working
of the plugin.

Bye, Stefan.

Hi,
Very fine work! I'll be use it in my work :)
Thanks!

PS. The three of database if a standard SQL mechanizm? Or you use specified
ORACLE requests for it?

--
Alexey Efimov, Software Engineer
Sputnik Labs,
http://www.spklabs.com
"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:7148396.1035297214566.JavaMail.jrun@is.intellij.net...

I've just release the first version of
my SQL query plugin for IDEA 3.

>

The features and the plugin itself can be found under

>

http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

>

Bye,
Stefan.

>
>
>
>
>
>
>

The tree of the database structure is created through a standard mechanism of JDBC. There seem to be some minor differences between the drivers and databases.

Bye, Stefan.

Sweet.....That did fix it..:))Thanks.

When I try to execute a sql command, the plugin says "No suitable driver"?

I have "mm.mysql-2.0.4-bin.jar" in C:\IntelliJ-IDEA-3.0\lib.

I use Idea 666

Any ideas?

nb. Under "connection propertiese" the mySql and Oracle icon are always red. Is this correct?

Regards Thomas

Hi, You have to use Connector/J 3.0.* You can pick it up from www.mysql.com as well

I've tested the plugin with mysql driver 2.0.14.
The problem is that they changed the class hierarchy between
version 2.0.4 and 2.0.14.
I currently look only for com.mysql.jdbc.Driver.

Bye, Stefan.