SQLViewer Plugin
I have an initial implementation of the SQLViewer plugin ready for preview.
Find it below.
http://orinoco.flamefew.net/moatas/archives/000019.html#000019
Jim
jim@bnainc.net
请先登录再写评论。
I have an initial implementation of the SQLViewer plugin ready for preview.
Find it below.
http://orinoco.flamefew.net/moatas/archives/000019.html#000019
Jim
jim@bnainc.net
请先登录再写评论。
Could u upload the plugin and descriptions (and sources) to the Wiki on
www.intellij.org?
Thanks,
Johannes Schneider
I have entered info into the Wiki, but probably not correctly.
Jim
"Johannes Schneider" wrote in message
news:Xns926F57E9EE3B0shakeatwebde@213.182.181.98...
>
>
>
>
I have updated the plugin to fix several bugs, and add a few more
features...
http://orinoco.flamefew.net/moatas/archives/000019.html#000019
Jim
"James Birchfield" wrote in message
news:ajpnp2$vpd$1@is.intellij.net...
preview.
>
>
>
>
>
Once again, a new update. Find it here...
http://weblogs.flamefew.net/moatas/
Jim
"James Birchfield" wrote in message
news:ajpnp2$vpd$1@is.intellij.net...
preview.
>
>
>
>
>
>
Really nice plugin. I love it ;)
Johannes Schneider
Hi,
I am having trouble creating the datasource. I am trying to connect to an
Oracle database using the following:
Driver: oracle.jdbc.driver.OracleDriver
I have placed the classes12.zip that contains this driver in the classpath
of Idea (%IDEA_HOME%/lib - it is also in my project classpath) and changed
the startup script to point to this zip file (SET
CLASS_PATH=%CLASS_PATH%;%JAVA_HOME%\lib\classes12.zip). When I try to add
the datasource the plugin can't find the driver class?
Has anyone else managed to connect to an Oracle instance and if so, am I
doing anything wrong?
Thanks
- scott
If I close a project and open another one, the old sqlviewer tab is left
behind and a new one is added. This continues as each new project is opened
until there are severaly sqlviewer tabs on the edge of the ide.
- scott
I had no Problems connecting to an Oracle DB.
From what you wrote, I got the impression that you placed the ZIP in
IDEA_HOME/lib, but pointed the classpath to JAVA_HOME/lib.
-- Jens
"Scott Curtis" <scurtis@smart421.com> wrote in message
news:ajssjt$fk7$1@is.intellij.net...
>
>
>
>
>
>
>
Feeling a bit sheepish now... :) It would seem that I did indeed point the
classpath to JAVA_HOME/lib... that'll teach me not to trust cut and paste so
much!
Thanks, it works fine now.
- scott
PS. What a great plugin!
"Jens G?ring" <jens.goering@healy-hudson.com> wrote in message
news:ajt3o3$p1r$1@is.intellij.net...
>
>
>
I made the same fault yesterday :)
Johannes Schneider
Yes, I need to do one of two things.
The Plugin is project based and should probably not be. It is better suited
to be application based. The first thing I should do is that.
But I will probably do the second thing. Which is unregister the window
when you close the project. This does not however adress the problem when
two projects are opened.
The only reason it is project based is I couldn't figure out how to do it as
an application level plugin. Mainly due to lask of examples. I couldn't
figure out where to start the process of creating the GUI componenets.
BTW, I did the same thing the first time I tried to load the drivers. Took
me about an hour to figure it out...;-)
I am glad the plugin is working out. I have several more ideas I would like
t oimplement.
Jim
"Scott Curtis" <scurtis@smart421.com> wrote in message
news:ajst66$ghs$1@is.intellij.net...
opened
>
>
>
Very nice. I like it a lot.
1 issue:
I'm using PostgreSQL, and my JDBC URL is something like
jdbc:postgresql:/// from my jdbc url, hoping it would find the
schemas (schemae?) and let me pick one, but I got the following stacktrace,
which someone else already ran into. It makes sense that this doesn't work,
but it might be nice to get a better error message.
mike
1669187 ERROR - com.intellij.ide.q - Error during dispatching
of
java.awt.event.MouseEvent[MOUSE_CLICKED,(81,894),button=1,modifiers=Button1,
clic
kCount=2] on frame0
1669187 ERROR - com.intellij.ide.q - IntelliJ IDEA (Ariadna)
3.0
Build #639
1669187 ERROR - com.intellij.ide.q - JDK: 1.4.0_01
1669187 ERROR - com.intellij.ide.q - VM: Java HotSpot(TM)
Client
VM
1669187 ERROR - com.intellij.ide.q - Vendor: Sun Microsystems
Inc
.
1669187 ERROR - com.intellij.ide.q - OS: Windows 2000
1669187 ERROR - com.intellij.ide.q -
java.lang.NullPointerException
at net.plugin.sql.gui.SQLDataPanel.buildSchemaList(Unknown Source)
at net.plugin.sql.gui.SQLDataPanel.
wrote in message
news:ajs2vb$mfe$1@is.intellij.net...
>
>
>
>
>
Doh! I can fix that up no problem. I will try to get a new release out
tonight!
Thanks for the feedback!
Jim
"schmoe" <schmoe@messageone.com> wrote in message
news:ajti9n$ege$1@is.intellij.net...
>
stacktrace,
work,
>
>
dispatching
>
java.awt.event.MouseEvent[MOUSE_CLICKED,(81,894),button=1,modifiers=Button1,
(Ariadna)
Microsystems
Source)
Source)
>
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3004)
>
>
>
>
>
Nice job man! Can you make the internal window thing use the currently
selected look & feel? As in use IDEA l&f instead of the ugly metal l&f???
Keep up the good work
"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajpnp2$vpd$1@is.intellij.net...
preview.
>
>
>
>
>
Sure I can. Do you have an example for using the L&F for me to follow?
Jim
"P. Ansari" <spam@patrick-ansari.com> wrote in message
news:ajtphp$q1d$1@is.intellij.net...
>
>
>
>
>
Nice plugin!
Here's a suggestion for a feature:
Allow creation of a SQL query string from SQLViewer and put it in the clip
board.
There are many ways to do this, here's one suggestion:
Add the columns to the table nodes and allow multiple selection of columns.
Have a button named "Create SELECT Query" that would create a string like
"SELECT selectedColumn1, selectedColumn2 FROM tableName;" and put it
in the clip board.
Another possibility would be:
Highlight the table node and click the button "Create SELECT Query".
A dialog comes up that displays all column names with check boxes.
Checking the desired columns and pressing Ok would put the query
string in the clip board.
This could be expanded in a lot of directions that would allow creation of
different kinds of query strings or even Java code from the SQLViewer.
Keep up the good work!
-Thomas
"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajs2vb$mfe$1@is.intellij.net...
>
For me plugin does not work :(
I use oracle.jdbc.driver.OracleDriver
Datasource is conected, but on any SQL command i have IllegalNumberFormat.
--
Alexey Efimov, Software Engineer
Sputnik Labs,
http://www.spklabs.com
"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajpnp2$vpd$1@is.intellij.net...
preview.
>
>
>
>
>
Can you give me an example of a query your are running? I ansd many othes
have connected to an Oracle instance with no problems.
Jim
"Alexey Efimov" <aefimov@spklabs.com> wrote in message
news:ajtvob$24q$1@is.intellij.net...
>
>
>
>
I have classes12_01.zip and rowset.jar in classpath in idea.bat.
I create new datasource:
name: myname
driver: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@localhost:ORCL:1521
username: system
password: manager
This datasource connected as i can see.
After connecting i type:
select * from dual;
select * from dual
select column from existing_scheme.existing_table;
select column from existing_scheme.existing_table
On all queries pluging say about error in number format (???)
--
Alexey Efimov, Software Engineer
Sputnik Labs,
http://www.spklabs.com
"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:aju1r6$5b7$1@is.intellij.net...
>
>
>
IllegalNumberFormat.
>
>
Hi,
Thanks for this wonderful plugin. The query part works fine with me, but if
I double click the table window I get a NullPointerException, so I can't get
a list of my tables.
Thanks
Willem
java.lang.NullPointerException
at net.plugin.sql.gui.SQLDataPanel.mouseClicked(Unknown Source)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:208)
at java.awt.Component.processMouseEvent(Component.java:5024)
at java.awt.Component.processEvent(Component.java:4818)
at java.awt.Container.processEvent(Container.java:1525)
at java.awt.Component.dispatchEventImpl(Component.java:3526)
at java.awt.Container.dispatchEventImpl(Container.java:1582)
at java.awt.Component.dispatchEvent(Component.java:3367)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3359)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3083)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3004)
at java.awt.Container.dispatchEventImpl(Container.java:1568)
at java.awt.Window.dispatchEventImpl(Window.java:1581)
at java.awt.Component.dispatchEvent(Component.java:3367)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:445)
at com.intellij.ide.q.a(q.java:13)
at com.intellij.ide.q.dispatchEvent(q.java:1)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:191)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)
Which database are you running against?
Did yuo grab the latest version? Posted last night around 11:00 EST?
Jim
"Willem Salembier" wrote in message
news:ajvje3$si6$1@is.intellij.net...
>
if
get
>
>
>
java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:208)
>
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
>
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
>
>
When our DBA comes in, I will connect as system and perform those queries
and see what I get.
Wjich version of Oracle? Classes12_01.zip is an older jar and was replaced
by classes12.zip.
Jim
"Alexey Efimov" <aefimov@spklabs.com> wrote in message
news:ajvc3e$lb8$1@is.intellij.net...
>
>
>
othes
>
>
replaced
>
Oracle 8.1.7
- Yeah, sorry, old mind :) Really i use classes12.zip
--
Alexey Efimov, Software Engineer
Sputnik Labs,
http://www.spklabs.com
"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajvv6d$dat$1@is.intellij.net...
>
replaced
>
>
>
>
>
Hmmm...I would only be able to test against a 9I database.
Run this code and tell me what you get...
public class test {
public void performQuery(DataSource dataSource, String query) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
CachedRowSet crs = null;
try {
JDBCConnectionManager manager = new
JDBCConnectionManager(dataSource);
con = manager.getConnection();
stmt = con.createStatement();
stmt.execute(query);
if (stmt.getResultSet() != null) {
rs = stmt.getResultSet();
while(rs.next()) {
//do something here
}
} else {
int uc = stmt.getUpdateCount();
JOptionPane.showMessageDialog(null, uc + " rows were
updated.", "Results", JOptionPane.INFORMATION_MESSAGE);
}
} catch (DataSourceException e1) {
JOptionPane.showMessageDialog(null, e1.getMessage(), "Error",
JOptionPane.ERROR_MESSAGE);
} catch (SQLException e1) {
JOptionPane.showMessageDialog(null, e1.getMessage(), "Error",
JOptionPane.ERROR_MESSAGE);
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (con != null) {
con.close();
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}
public static void main(String[] args) {
DataSource ds = new DataSource();
ds.setName("Test");
ds.setDriver("oracle.jdbc.driver.OracleDriver");
ds.setUrl("jdbc:oracle:thin:@hades.genscape.com:1581:test");
ds.setUser("");
ds.setPassword("");
test t = new test();
t.performQuery(da, "select * from dual);
}
}
This may or may not compile. I hacked the code in this news reader. Change
accordingly and let me know what it does. This is the code that actually
runs in the qury window. In the plugin, the CachedRowSet gets populated
with the ResultSet, but that is the only thing different. If the above code
runs, it looks like the problem might lie in the rowset.jar classes.
Jim
P.S. Make sure you have the sqlviewer.jar in your classpath. Change your
user name and password accordingly and put appropriate debugging in the loop
for the resultset.
"Alexey Efimov" <aefimov@spklabs.com> wrote in message
news:ak0041$fv9$1@is.intellij.net...
>
queries
for
>
>