[ jEdit-devel ] SQL Plugin suggestion + bug

[Philip M. <ph...@dy...>]

Hi Serghey,


I have a suggestion.
Can you please add an option somehow so that when I double click a table in
the tree it doesn't also open a buffer ?
I find it pretty annoying since : a) the buffer is readonly b) it always
print the same info (select * from that_table_you_clicked_on). Maybe you can
either add an option to the configuration panel or a button in the SQL
Result Set something like "Show underlying query".


Also this little script throws an error:

SCRIPT:

DROP TABLE IF EXISTS customer;

CREATE TABLE customer
(
CUSTOMERID        NUMERIC (9,0) NOT NULL,
CUSTOMERNAME           VARCHAR (50),
PHONE                  VARCHAR (20),
FAX                    VARCHAR (20),
EMAIL                  VARCHAR (50),
ADDRESS                VARCHAR (100),
CITY                   VARCHAR (30),
STATE                  VARCHAR (30),
ZIP                    VARCHAR (10),
CONTACTNAME            VARCHAR (30),
ACTIVE                 NUMERIC (1)
);


Error:
[error] java.sql.SQLException: Syntax error or access violation: You have an
err
or in your SQL syntax near ';
[error] CREATE TABLE customer
[error] (
[error] CUSTOMERID             NUMERIC (9,0) NOT NULL,
[error] CUSTOMERNA' at line 2
[error]         at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:498)
[error]         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:551)
[error]         at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:636)
[error]         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:924)
[error]         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:857)
[error]         at org.gjt.mm.mysql.Statement.execute(Statement.java:595)
[error]         at
org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
[error]         at sql.SqlUtils.doPublishText(SqlUtils.java:369)
[error]         at sql.SqlUtils$3.run(SqlUtils.java:292)
[error]         at sql.SqlThreadGroup$1.run(SqlThreadGroup.java:108)
[error]         at java.lang.Thread.run(Thread.java:484)


The script runs fine agains MySQL.

I run jEdit 3.2 final, SQL 0.6, JDK 1.3.1, W2K, mm's mysql driver.

thanx,
philip