[ANN] SQLQueryPlugin 1.0.8

I've just released the newest version of my SQL plugin.

The major changes are:
- Editable result table
- Executing statements in separate thread

Bye, Stefan.

8 comments
Comment actions Permalink

Stefan,

Just wanted to say thanks for the plug-in. Well written and the
functionality is great ... exactly what I was looking for.

If you're looking for more ideas, it would be nice if ...

- You could drag and drop the table and field names in the schema window
into the sql editor and code editor pane.
- You could edit the data directly in the grid

Without these features, it's still a great plug-in!

- joe


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

I've just released the newest version of my SQL plugin.

>

The major changes are:
- Editable result table
- Executing statements in separate thread

>

Bye, Stefan.



0
Comment actions Permalink

Stefan Stiller wrote:

I've just released the newest version of my SQL plugin.

The major changes are:
- Editable result table
- Executing statements in separate thread

Bye, Stefan.


I can't get it to work with v 5.5 of the Sybase jConnect JDBC driver.
I can run "use ..." statements, but when I try a basic select I get
"The method com.sybase.jdbc2.tds.RowFormatToken.getCatalogName has not
been completed and should not be called."

Also, if I don't hit "Refresh all connections" after running a
statement, it asks for my password again - when I put it in I get a
dialog box with "SET CHAINED command not allowed within multi-statement
transaction".

Any ideas? (No pun intended...)
Robbie

0
Comment actions Permalink

Sorry I can't test it with a Sybase database. You can try to disable the option 'Highlight primary key columns'. The option is used to automatically detect primary keys and executes a second statement on the same connection. There seem to be some problems for some drivers/databases.

I can't really help you with the second bug because I can't do anything with the error message. The password request happens only because after the first exception the plugin assumes a password error.

Bye, Stefan.

0
Comment actions Permalink

Stefan Stiller wrote:

Sorry I can't test it with a Sybase database. You can try to disable the option 'Highlight primary key columns'. The option is used to automatically detect primary keys and executes a second statement on the same connection. There seem to be some problems for some drivers/databases.


Where is this option? In the Connection Properties I just have:
Driver (Other Driver)
Class (com.sybase.jdbc2.jdbc.SybDriver)
URL (jdbc:sybase:Tds:dbname:4100/)
User (guest)
and an always-disabled checkbox (Save encrypted password)

Am I using the wrong version of the plugin?
Robbie

0
Comment actions Permalink

Am I using the wrong version of the plugin?


Yes. In the latest version (1.0.8) there is a second tab in the 'Connection Properties' dialog.

Bye, Stefan.

0
Comment actions Permalink

- You could edit the data directly in the grid

It is possible to edit the result table as long as the query isn't complicated (ex. 'select * from mytable') and the table contains a primary key column (yellow). The plugin tries to automatically define primary key columns, but it is also possible to define a column manually by right mouse click on the table header.

Bye, Stefan.

0
Comment actions Permalink

The Sybase jConnect drivers are really stupid. Here's a comment from code I've written. I'm not sure if the links still work, but I bet this is what you are running into.

Jason Boehle
jboehle@actuate.com


// If using the Sybase jConnect for JDBC driver, and the 'FAKE_METADATA'
// property is NOT set to 'true', calling ResultSetMetaData.getTableName() will throw
// an exception, instead of returning an empty string (""), as the JDBC specification
// mandates.
//
// For more info, see section 6.1 of:
// http://manuals.sybase.com/onlinebooks/group-jc/jcg0520e/jcon52rb/@Generic__BookView;pt=182;hf=0
// Also, see Table 2-2 in:
// http://manuals.sybase.com/onlinebooks/group-jc/jcg0550e/prjdbc/@Generic__BookView;hf=0

0
Comment actions Permalink

Is there any way to select a specific location in the filesystem where the database files are kept? I keep multiple copies of my database(one for each project) and it would be nice to have a way to point the plugin at a specific directory/DB to use. Running my project, I can declare the database.path when I call it. Is there any way to declare a specific database.path from your plugin?

Thanks for your plug-in. It looks like it will be a big help if I can get it working with my database(FirstSQL).

Chris

0

Please sign in to leave a comment.