24 comments
Comment actions Permalink

Could u upload the plugin and descriptions (and sources) to the Wiki on
www.intellij.org?


Thanks,


Johannes Schneider

0
Comment actions Permalink

I have entered info into the Wiki, but probably not correctly.

Jim

"Johannes Schneider" wrote in message
news:Xns926F57E9EE3B0shakeatwebde@213.182.181.98...

Could u upload the plugin and descriptions (and sources) to the Wiki on
www.intellij.org?

>
>

Thanks,

>
>

Johannes Schneider

0
Comment actions Permalink

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...

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

>
>

0
Comment actions Permalink

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...

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

>
>

0
Comment actions Permalink

Once again, a new update. Find it here...
http://weblogs.flamefew.net/moatas/

>

Really nice plugin. I love it ;)


Johannes Schneider

0
Comment actions Permalink

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


0
Comment actions Permalink

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


0
Comment actions Permalink

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...

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

>
>


0
Comment actions Permalink

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 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

>



0
Comment actions Permalink

I made the same fault yesterday :)


Johannes Schneider

0
Comment actions Permalink

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...

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

>
>


0
Comment actions Permalink

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.

<init>(Unknown Source)
        at net.plugin.sql.gui.SQLFrame.<init>(Unknown Source)
        at net.plugin.sql.gui.SQLWindowManager.createFrame(Unknown Source)
        at net.plugin.sql.gui.MainSQLView.dataSourceSelected(Unknown Source)
        at
net.plugin.sql.gui.SQLConnectionTree.notifyDatasourceListeners(Unknow
n Source)
        at net.plugin.sql.gui.SQLConnectionTree.mouseClicked(Unknown Source)
        at
java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:20
8)
        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:23)
        at com.intellij.ide.q.dispatchEvent(q.java:22)
        at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:191)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.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)

"James Birchfield" <jim.birchfield@genscape.com>

wrote in message

news:ajs2vb$mfe$1@is.intellij.net...

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...

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

>
>

>
>

0
Comment actions Permalink

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...

Very nice. I like it a lot.

>

1 issue:
I'm using PostgreSQL, and my JDBC URL is something like
jdbc:postgresql:///, according to the jdbc driver. > This means the Schema dropdown is empty, and if I double-click a tablename, > it runs the query "select * from .", which produces an error. > You probably want to change it so if the current schema is empty, it doesn't > add the '.' to the query. The adhoc queries work beautifully, so this > doesn't really interfere with the usefulness of the plugin (at least for > me). > > I tried to remove the 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

>

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
ERROR - com.intellij.ide.q - IntelliJ IDEA

(Ariadna)

3.0
Build #639
ERROR - com.intellij.ide.q - JDK: 1.4.0_01
ERROR - com.intellij.ide.q - VM: Java HotSpot(TM)
Client
VM
ERROR - com.intellij.ide.q - Vendor: Sun

Microsystems

Inc
.
ERROR - com.intellij.ide.q - OS: Windows 2000
ERROR - com.intellij.ide.q -
java.lang.NullPointerException
at net.plugin.sql.gui.SQLDataPanel.buildSchemaList(Unknown Source)
at net.plugin.sql.gui.SQLDataPanel.<init>(Unknown Source)
at net.plugin.sql.gui.SQLFrame.<init>(Unknown Source)
at net.plugin.sql.gui.SQLWindowManager.createFrame(Unknown Source)
at net.plugin.sql.gui.MainSQLView.dataSourceSelected(Unknown

Source)

at
net.plugin.sql.gui.SQLConnectionTree.notifyDatasourceListeners(Unknow
n Source)
at net.plugin.sql.gui.SQLConnectionTree.mouseClicked(Unknown

Source)

at
java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:20
8)
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:23)
at com.intellij.ide.q.dispatchEvent(q.java:22)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:191)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.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)

>

"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajs2vb$mfe$1@is.intellij.net...

Once again, a new update. Find it here...
http://weblogs.flamefew.net/moatas/

>

Jim

>
>

"James Birchfield" <jim.birchfield@genscape.com> wrote in message
news:ajpnp2$vpd$1@is.intellij.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

>
>

>
>

>
>


0
Comment actions Permalink

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...

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

>
>


0
Comment actions Permalink

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 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...

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

>
>

>
>


0
Comment actions Permalink

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...

Once again, a new update. Find it here...
http://weblogs.flamefew.net/moatas/

>

Jim




0
Comment actions Permalink

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...

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

>
>


0
Comment actions Permalink

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...

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...

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

>
>

>
>


0
Comment actions Permalink

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...

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...

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...

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

>
>

>
>

>
>


0
Comment actions Permalink

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)


0
Comment actions Permalink

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...

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)

>
>

0
Comment actions Permalink

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...

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...

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...

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...

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

>
>

>
>

>
>

>
>


0
Comment actions Permalink

Wjich version of Oracle? Classes12_01.zip is an older jar and was

replaced

by classes12.zip.

>
Oracle 8.1.7

by classes12.zip.

- 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...

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...

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...

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...

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...

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

>
>

>
>

>
>

>
>

>
>


0
Comment actions Permalink

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...

Wjich version of Oracle? Classes12_01.zip is an older jar and was

replaced

by classes12.zip.

>
Oracle 8.1.7

>

by classes12.zip.

- 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...

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...

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...

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...

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...

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

>
>

>
>

>
>

>
>

>
>

>
>


0

Please sign in to leave a comment.