[Announcement] SQLQueryPlugin 1.0.7 released
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.
Please sign in to leave a comment.
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...
>
>
>
>
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...
>
>
>
>
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...
>
>
>
>
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...
>
drivers
to
>
>
>
>
>
>
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
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
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...
>
>
>
>
This is a good suggestion. I will try and implement it in the next release.
Bye, Stefan.
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
If a BLOB value represents an Java Object you can open an Object Explorer (like in the debugger).
I've already thought about it and will certainly implement in a future version.
Currently the tabs are only renamed if you load a query.
I try loading some more data (like primary keys), so it is possible that this is the reason.
Thank You.
Bye, Stefan.
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...
>
>
>
>
Is there a way to make the plugin close any open database connections?
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.
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.
This is a bug in the table cell renderer. I will fix it
in the next version.
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.
Timestamp is showing as Date!
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.
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...
the table can't use the toString() method to render the value.
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
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.
In the future I will execute the query in a separate thread so this is still in work.
Currently it is not available but I will think about making it available.
Bye, Stefan.
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.
>
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
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
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.
Hi Stefan,
it works very fine the way you described. I think I
was using an older version somehow.
Thanks and Bye,
Hidir
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