SQLViewer 1.0.4 is available

Hi,

I like your plugin very much.. (better than the SQLQuery plugin :))

I have a small problem with it..

The databases I wish to connect to are not always available (at home or
at work)
The plugin erases their configuration from my project when it can't
connect.. leaving me typing in the details every day / everywhere.
It would be nice if the Connection information would be decoupled from
whether the connection can be made or not.. (a "dis-/connect" option in
the popup menu maybe)

keep up the good work..

Aiko


James Birchfield wrote:

SQLViewer 1.0.4 is available at http://sqlviewer.sf.net . This release
fixes the 'schemaless database' issues, and allows for the double clicking
of any cell to view the contents in a small read only window...great for
those long entries in the DB.

Jim

After a new install, double clicking in the "Data Sources" (before
configuring any data source) line in the left panel throws this exception:

ERROR - com.intellij.ide.p - Error during dispatching
of java.awt.event.MouseEvent[MOUSE_CLICKED,
(65,58),button=1,modifiers=Button1,clickCount=2] on dialog2
ERROR - com.intellij.ide.p - IntelliJ IDEA 3.0 Build
#664
ERROR - com.intellij.ide.p - JDK: 1.4.1_01
ERROR - com.intellij.ide.p - VM: Java HotSpot(TM)
Client VM
ERROR - com.intellij.ide.p - Vendor: Sun Microsystems
Inc.
ERROR - com.intellij.ide.p - OS: Windows 2000
ERROR - com.intellij.ide.p - Last Action:
SQLConnectionCreatorAction.CreateWindow
ERROR - com.intellij.ide.p -
java.lang.ClassCastException
at
net.plugin.sql.gui.SQLConnectionTree.mouseClicked(SQLConnectionTree.java:69)
at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.intellij.ide.p.a(p.java:31)
at com.intellij.ide.p.dispatchEvent(p.java:5)
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)

Some suggestions:

1. The north panel with "Enter SQL Command" and the run button uses to much
real estate.It should be moved to a new Run menu.

2. After opening a database connection for the first time, the table list is
for the first user in the user list -> the table list should be for the
connected user.

3. Are you really serious on fetching all rows when opening a table :)
This database has many tables with 100s K rows and several tables with
millions of rows. I jus't had to kill idea after opening a table with 200K
rows.

A limit on the fetched rows, with a dialog asking the user if he want's to
fetch more rows, is necessary. Both on the table view and on the sql view.

4. Queries should run in the background, not locking idea.

5. The popup menu opened by right clicking a connection should also have an
entry for "Open table list" - on first place and bold if possible.

6. How about auto-sizing the data columns. If needed, I can post a table
auto-sizing code.

Carlos

5. The popup menu opened by right clicking a connection should also have

an

entry for "Open table list" - on first place and bold if possible.

There's no way of knowing the connection properties.
There should be also another entry in the popup "Properties" that opened the
dialog with the connection properties.

Your instructions state: You will need to adjust your $IDEA_HOME/idea.bat or $IDEA_HOME/idea.sh script to add your JDBC driver. My question is: Does my not knowing where the JDBC driver for the project is, mean that I probably shouldn't be trying to use the plugin? :-}

We have an oracle db, but I wouldn't have a clue where the JDBC driver is. Is there a default location someone can point me to?

classes12.jar

Hi,

I've added my jdbc driver jar to the lax.class.path in idea.lax but the plugin still can't find the driver. Any ideas ? I'm using SQLViewer 1.0.4 with Idea 3.0 Build 666

I've added my jdbc driver jar to the lax.class.path in idea.lax but the

plugin still can't find the driver. Any ideas ? I'm using SQLViewer 1.0.4
with Idea 3.0 Build 666

No need for that. Just put the jdbc drivers in the idea lib directory and
they'll be picked automatically.

Hello.

I have one datasource and when I execute a statement like "select * from log" the data/Colums field are always gray!!

I can't see any data

Any idea?

Maybe you should specify which plugin you're talking about?

"Thomas" <java2@mail.dk> wrote in message
news:4670466.1036069267062.JavaMail.javamailuser@localhost...

Hello.

>

I have one datasource and when I execute a statement like "select * from

log" the data/Colums field are always gray!!
>

I can't see any data

>

Any idea?

Brad:

I am usig the SQLViewer 1.0.4 plugin, but can't see any data?

Try updating to 1.0.6

"Thomas" <java2@mail.dk> wrote in message
news:5169649.1036136852761.JavaMail.jrun@is.intellij.net...

Brad:

>

I am usig the SQLViewer 1.0.4 plugin, but can't see any data?

Brad:

Is there a SQLViewer 1.0.6 ?
Link?


I can only find SQLQueryPlugin v1.0.6, but I thing that this a a different plugin?

Oops. You're correct.

Do you get any errors in the console? What DB and driver are you using?

"Thomas" <java2@mail.dk> wrote in message
news:6349431.1036167893436.JavaMail.jrun@is.intellij.net...

Brad:

>

Is there a SQLViewer 1.0.6 ?
Link?

>
>

I can only find SQLQueryPlugin v1.0.6, but I thing that this a a different

plugin?

I use a Pervasive 2000 sql database, and a JDBC driver.
(pvjdbc2.jar)

I can create a Datasource with no problems.

But when a try the "adhoc query" and type "select * from log", and click "run" I get nothing! And the console give no errors!

But when a type something wrong like: "select * from bla..." I get a error in the console:
Error: [Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object.


I have the same problem with mySQL database and the mysql-driver.

I use IntelliJ build 666

Any idea?

Now it works :)))


I included the rowset.jar in my classpath.