25 comments
Comment actions Permalink

I've updated the Plugin Manager's registry file with the info for your new
version.

(If you'd like to do this yourself in the future, docs on how to update are
available at http://www.intellij.org/twiki/bin/view/Main/PluginManager)

"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>


0
Comment actions Permalink

Hi!

I'd LOVE to use your plugin but the fact is that I'm a n00b at JDBC drivers
and databases. So I dont know what you mean when you say "Copy JDBC driver
into IDEA_HOME\lib " :( could you please tell me what this means and how to
use your plugin ? :)

thx

Anders


"Stefan Stiller" <stefan@sstiller.de> skrev i en meddelelse
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>


0
Comment actions Permalink

Could you automatically resize the column so that it is possible to see the
whole column name?
Thanks
/kesh

"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>


0
Comment actions Permalink

The JDBC driver is what allows a Java program to 'connect' to a database or
any tabular data. It may be supplied by the database, the application
server, or some other 3rd party vendor(or yourself for that matter). Anyway,
we use the driver supplied by Oracle. The driver is packaged in a jar file.
Just copy this jar to IDEA_HOME\lib. If you happen to be using Oracle's
driver you can find it at ORACLE_HOME\jdbc\lib. The file is: classes12.zip
for Java2.
After you do that you will need to specify the URL for the database you want
to connect to. Since I'm not using this particular plugin, hopefully Stefen
can give you instructions on how to do this within the plugin. For general
JDBC info, including how to specify a URL you should check the Sun site:
http://java.sun.com/products/jdbc/

"Anders Madsen" <nzc@it.dk> wrote in message
news:aqopj8$adr$1@is.intellij.net...

Hi!

>

I'd LOVE to use your plugin but the fact is that I'm a n00b at JDBC

drivers

and databases. So I dont know what you mean when you say "Copy JDBC driver
into IDEA_HOME\lib " :( could you please tell me what this means and how

to

use your plugin ? :)

>

thx

>

Anders

>
>

"Stefan Stiller" <stefan@sstiller.de> skrev i en meddelelse
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>

>
>


0
Comment actions Permalink

For information and Q/A regarding JDBC, I suggest you check out Sun's excellent online forums on the subject:
http://forum.java.sun.com/forum.jsp?forum=48

Also, check out the (excellent) online documentation on the subject:
http://java.sun.com/docs/books/tutorial/jdbc/

http://www-105.ibm.com/developerworks/education.nsf/java-onlinecourse-bytitle/56A6275393F0BE5786256AFD004DBBB4?OpenDocument

http://www.javaworld.com/jw-05-1996/jw-05-shah.html

Also, JDBC drivers are (usually) packaged as .jar files -- and the 'lib' directory you mentioned will (I'm guessing) be included as part of the classpath -- so you're effectively putting a JDBC driver into the classpath for an application, that's all.

Dan

0
Comment actions Permalink

I think it is possible as long as the column name isn't to long because of expressions like to_char(...) and so on.
Thanks for the suggestion.

Bye, Stefan

0
Comment actions Permalink

Hi Stefan

thank you for the great Plugin!
One Enhancement Request:
what about copying the sql statement to the code (or clipboard) with
corresponding java formatting (" and +) and vice versa from the java code to
your SQL window?

regards, Claude

"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>


0
Comment actions Permalink

This is a good suggestion. I will try and implement it in the next release.

Bye, Stefan.

0
Comment actions Permalink

What does the new feature "Viewer for CLOB and BLOB values" mean? Just that the word BLOB is displayed in the result table or do I miss anything?

Another question: is there any way to copy something from the result table to the clipboard? I didn't manager to do so. In case this is not implemented yet I'd like to submit this as a feature request.

Can you rename the queries in the tabs? If not, another feature requst. :)

I noticed that the new version takes much longer to open the database structure view. Is there any reason for this, maybe more work is done, or is it a bug?

And last but not least: a great plugin! I really like it.

Michael

0
Comment actions Permalink

What does the new feature "Viewer for CLOB and BLOB
values" mean? Just that the word BLOB is displayed in
the result table or do I miss anything?


If a BLOB value represents an Java Object you can open an Object Explorer (like in the debugger).

Another question: is there any way to copy something
from the result table to the clipboard? I didn't
manager to do so. In case this is not implemented yet
I'd like to submit this as a feature request.


I've already thought about it and will certainly implement in a future version.

Can you rename the queries in the tabs? If not,
another feature requst. :)


Currently the tabs are only renamed if you load a query.

I noticed that the new version takes much longer to
open the database structure view. Is there any reason
for this, maybe more work is done, or is it a bug?


I try loading some more data (like primary keys), so it is possible that this is the reason.

And last but not least: a great plugin! I really like
it.


Thank You.

Bye, Stefan.

0
Comment actions Permalink

Feature request: Make the 'database structure' window non-modal and always
on top(or at least an option for this) so I can look at it while typing in
my query.

BTW - Nice plugin.

"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:4023434.1037017541319.JavaMail.jrun@is.intellij.net...

I've uploaded a new version of the plugin.

>

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

>

Changes:

  • Load and save for queries

  • Viewer for CLOB and BLOB values

  • Support for custom JDBC driver

  • Bugfixes

>

Bye, Stefan.

>


0
Comment actions Permalink

Is there a way to make the plugin close any open database connections?

0
Comment actions Permalink

The plugin closes all connections if you hide the tool window or if you press the 'Refresh' button at the right end of the plugin toolbar.

Bye, Stefan.

0
Comment actions Permalink

Hi, great plugin, probably the best one i ever seen so far.
Now two things:
A bug (or probably i didnt understand how does it works): If there is a TIMESTAMP field in the results view, it is shown as "oracle.sql.TIMESTAMP@xxxx" instead of the timestamp value.
A feature request: it would be nice if you can add support for showing stored procedures and packages in the database structure dialog.


Thanks again for great plug in.

0
Comment actions Permalink

A bug (or probably i didnt understand how does it
works): If there is a TIMESTAMP field in the results
view, it is shown as "oracle.sql.TIMESTAMP@xxxx"
instead of the timestamp value.


This is a bug in the table cell renderer. I will fix it
in the next version.

A feature request: it would be nice if you can add
support for showing stored procedures and packages in
the database structure dialog.


I don't know if it is possible to get information about
stored procedures through JDBC. If it should be possible
I will implement it in a future version.

Bye, Stefan.

0
Comment actions Permalink

Timestamp is showing as Date!


0
Comment actions Permalink

oracle.sql.TIMESTAMP is not a sub class of java.sql.Timestamp therefore the table can't use the toString() method to render the value.

0
Comment actions Permalink

I'm using Firebird 1.0 (InterBase) and JBird (FirebirdSQL) jdbc-driver.
Database in SQL DIALECT 3.

"Stefan Stiller" <stefan.stiller@net-linx.com> wrote in message
news:2147462.1037275142833.JavaMail.jrun@is.intellij.net...

oracle.sql.TIMESTAMP is not a sub class of java.sql.Timestamp therefore

the table can't use the toString() method to render the value.


0
Comment actions Permalink

feature request:
don't grab all the rows in the query right away. If I have a table with millions of rows, it will probably crash things due to lack of memory. At the very least, it will freeze idea until the query comes back. Also, could we have a "working" cursor while the queries are executing?

Is the source available? I'd love to help make it better!
John

0
Comment actions Permalink

feature request:
don't grab all the rows in the query right away.
. If I have a table with millions of rows, it will
probably crash things due to lack of memory. At the
very least, it will freeze idea until the query comes
back.


I can make the max. number of rows loaded into the result table configurable. But I think it mostly depends on the user to restrict the number of returned rows by adding where conditions to the query.

Also, could we have a "working" cursor while
the queries are executing?


In the future I will execute the query in a separate thread so this is still in work.

Is the source available? I'd love to help make it
better!


Currently it is not available but I will think about making it available.

Bye, Stefan.

0
Comment actions Permalink

I can make the max. number of rows loaded into the result table

configurable. But I think it mostly depends on the user to restrict the
number of returned rows by adding where conditions to the query.

No user is perfect, but conditions fail sometimes. And then killing idea is
the only way of resolving the problem.

Also, could we have a "working" cursor while
the queries are executing?

>

In the future I will execute the query in a separate thread so this is

still in work.

A progress bar and a cancel button are very useful - that's the way I
implemented returning sql in my app. The background thread can look for flag
set by the button and stop if it's set.

Carlos


0
Comment actions Permalink

Hi,

can you please tell me how I can configure a jdbc driver
for embedded (no client-server) environments. I want to use your plugin
with the cloudscape emnedded driver "COM.cloudscape.core.JDBCDriver"
In JBuilder for example you can use a URL like:
"jdbc:cloudscape:e:\test\MyDatabase" and the
use the driver class" to connect to a local database.
You don't need to define username or password.

Is this possible with your plugin ?

The only possibility I see is to modify the
jdbc entries in project.iws, but I don't
know which parameters(tags) are supported.

Thanks in advance,

H.Aras

0
Comment actions Permalink

It should be possible by selecting 'Other Driver' in the configuration dialog. Entering the driver class and url into the fields below and leave the 'User' empty.
The driver class must be found by the IDEA runtime environment so best solution is to place the driver JAR file into IDEA_HOME\lib.

If this doesn't work please let me know.

Bye, Stefan.

0
Comment actions Permalink

Hi Stefan,

it works very fine the way you described. I think I
was using an older version somehow.

Thanks and Bye,
Hidir

0
Comment actions Permalink

well, I still don't get how to add this sqlqueryplugin. I am not able give it the right url...what is that that I am supposed to put in the value parameter of the database parameter?

Could you please help. I am using JSQLConnect as the JDBC driver

0

Please sign in to leave a comment.