squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 31)

I was reading through plugins.html and noticed the following:

"To reserve an internal name just email a request to the SQuirreL 
developers mailing list
specifying the internal name that you'd like and a quick description of 
your plugin."

If that is still the case, I'd like to reserve the internal name of 
"dbcopy".  My plugin
development is well under way and can be located at the following URL:

http://sourceforge.net/projects/dbcopyplugin

Description: DB Copy Plugin is a plugin for the SQuirreL SQL Client (2.0 
RC1+) that allows
copying  database objects (schema def and data) from one session window 
to another. The
sessions can be disparate database vendors (Oracle -> MySQL, for instance).

Currently (as of the trunk) this plugin provides:

- Copy and Paste tables from one session to another (Can be different 
database
  types (MySQL -> Oracle, SyBase->MySQL, etc...)

- Includes Primary Key and Foreign Key constraints for tables copied.

- Uses Hibernate 3.0 internally to perform database object type mappings.

The "Copy Table" and "Paste Table" functions are accessible through
the context-sensitive (right-click) menu of the Object Tree.

That's all for now,

Rob Manning



CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Gerd Wagner wrote:

> Hi Rob,
>
> once and again in the past such a plugin would have been useful to me. 
> So I'd really like it. I hope you don't mind some suggestions:
>
> 1. Let the user select the Objects to copy from the Object tree.

So, a user could select one or multiple tables in the source schema 
right-click to copy them (Copy Object Def/Contents)
and then select a target schema tables object(in the same DB session or 
in another perhaps different session with different database type)
and right-click to paste them (Paste Object Def/Contents).  That sounds 
very powerful.  I like it. 

> 2. I believe good progress information is needed because copying can 
> take quite a bit of time.

Agreed.  No long-running operation such as this should take place 
without a JProgressBar or some such indication of progress.

> 3. This may be a hard one: If something breaks it would be good if the 
> process could be chosen either to continue or to start from the 
> beginning.

I hadn't thought about that one.  I may need to keep track of what state 
the plugin was in when the operation failed.  Then see if it
matches the next requested operation and prompt the user for further 
direction.  Good thoughts, keep 'em coming.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Hi Rob,

once and again in the past such a plugin would have been useful to me. 
So I'd really like it. I hope you don't mind some suggestions:

1. Let the user select the Objects to copy from the Object tree.

2. I believe good progress information is needed because copying can 
take quite a bit of time.

3. This may be a hard one: If something breaks it would be good if the 
process could be chosen either to continue or to start from the beginning.

Gerd


robert wrote:
> Hey,
> 
> Keith Mashinter posted a link to opendbcopy which according to the 
> description
> seems to solve the problem I've described in my previous email.
> (http://sourceforge.net/mailarchive/forum.php?thread_id=7487032&forum_id=3124) 
> 
> I'll take a look at it and see how suitable it is for my use.  If it's 
> generic enough and a
> suitable framework, I'll see if I can't wrap it in a plugin for 
> inclusion in Squirrel.  Thanks
> for the link Keith!
> 
> Rob
> 

Hi Keith,

the Graph plugin does this.

Compared to SQL Servers tool it lacks the functions to change tables and 
relations from within the chart. But perhaps some day...

Gerd


Keith Mashinter wrote:
> I'm not sure that there is a plugin for squirrel-sql, but the opendbcopy project may help there: http://sourceforge.net/projects/opendbcopy/.
> 
> 
> -----Original Message-----
> From:	squ...@li... on behalf of naveen kumar
> Sent:	Sat 6/11/2005 6:29 AM
> To:	squ...@li...
> Cc:	
> Subject:	[Squirrel-sql-develop] Need help
> Hi,
>       
>       I am working with Squirrel SQL client. 
> Like in MicrosoftSQL-Server is there any tool in
> Squirrel-SQL for displays the graphical relations
> between tables (or) a tools that gives the
> documenation of about tables such as relations between
> tables,primary-key in tables,name of the coloumns in
> the table, etc..
> 
> I will be very thankfull on advice.....   
>  
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
> a projector? How fast can you ride your desk chair down the office luge track?
> If you want to score the big prize, get to know the little guy.  
> Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
> a projector? How fast can you ride your desk chair down the office luge track?
> If you want to score the big prize, get to know the little guy.  
> Play to win an NEC 61" plasma display: http://www.necitguy.com/?r 
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

Hey,

Keith Mashinter posted a link to opendbcopy which according to the 
description
seems to solve the problem I've described in my previous email.
(http://sourceforge.net/mailarchive/forum.php?thread_id=7487032&forum_id=3124) 

I'll take a look at it and see how suitable it is for my use.  If it's 
generic enough and a
suitable framework, I'll see if I can't wrap it in a plugin for 
inclusion in Squirrel.  Thanks
for the link Keith!

Rob

robert wrote:

> Hi,
>
> I have an idea for a plugin that I've been mulling over on and off for 
> the last year.  But
> before I started working on it I wanted to follow the guidelines set 
> forth in the project FAQ:
>
> "If you have got an idea for a plugin just send a message to the 
> SQuirreL Developers
> list giving a brief description. This helps to ensure that two people 
> don't develop the same plugin."
>
> Here's the problem I think I can solve by writing a plugin for SQuirreL:
>
> We have a commercial J2EE app that - in theory - can run on several 
> different app servers
> using several different databases (embedded as well as stand-alone).  
> The thorny problem
> comes when it's time to test a release, we need to be able to run the 
> same tests against the
> same data, in different app servers and different databases.  Because 
> the application has a
> rich client interface (via applet) much testing needs to be performed 
> by hand.  Even some
> of the test setup has to occur using the GUI as we don't yet have a 
> way to automate it. I need
> to be able to setup a test database in Oracle, for instance, setup/run 
> some tests, then at some
> point switch over to MySQL using the same data that was in Oracle,  
> then again re-run some
> tests, then at some point switch over to HyperSonic (SyBase, 
> PointBase, DB2, MS-SQL etc.)
> So my plugin would - I think - build on work done in SQL Scripts 
> plugin by being able to
> use two connections to databases of differing types (Oracle , MySQL), 
> asking the user for
> input schema on Oracle and output database in MySQL.  The challenge in 
> doing this is
> mapping the types - perhaps a configuration dialog would allow the 
> user to choose to use
> default mappings (Oracle:NUMBER -> MySQL:MEDIUM INT) or customize them.
> The plugin could then create tables/views in MySQL using the 
> definitions in Oracle.  Then it would
> read records in each table in Oracle, and write them into the 
> corresponding table in MySQL.
>
> So, is anyone currently working on such a plugin and if so, could I 
> help?  If not, do you all
> think this would be a useful plugin to include with SQuirreL, or 
> perhaps just distribute it on
> my own (it would still be open source licensed)?
>
> Rob Manning




CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

I'm not sure that there is a plugin for squirrel-sql, but the opendbcopy =
project may help there: http://sourceforge.net/projects/opendbcopy/.


-----Original Message-----
From:	squ...@li... on behalf of =
naveen kumar
Sent:	Sat 6/11/2005 6:29 AM
To:	squ...@li...
Cc:=09
Subject:	[Squirrel-sql-develop] Need help
Hi,
     =20
      I am working with Squirrel SQL client.=20
Like in MicrosoftSQL-Server is there any tool in
Squirrel-SQL for displays the graphical relations
between tables (or) a tools that gives the
documenation of about tables such as relations between
tables,primary-key in tables,name of the coloumns in
the table, etc..

I will be very thankfull on advice.....  =20
=20

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you =
shotput
a projector? How fast can you ride your desk chair down the office luge =
track?
If you want to score the big prize, get to know the little guy. =20
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=3D20
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

Hi,
      
      I am working with Squirrel SQL client. 
Like in MicrosoftSQL-Server is there any tool in
Squirrel-SQL for displays the graphical relations
between tables (or) a tools that gives the
documenation of about tables such as relations between
tables,primary-key in tables,name of the coloumns in
the table, etc..

I will be very thankfull on advice.....   
 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Hi,

I have an idea for a plugin that I've been mulling over on and off for 
the last year.  But
before I started working on it I wanted to follow the guidelines set 
forth in the project FAQ:

"If you have got an idea for a plugin just send a message to the 
SQuirreL Developers
list giving a brief description. This helps to ensure that two people 
don't develop the same plugin."

Here's the problem I think I can solve by writing a plugin for SQuirreL:

We have a commercial J2EE app that - in theory - can run on several 
different app servers
using several different databases (embedded as well as stand-alone).  
The thorny problem
comes when it's time to test a release, we need to be able to run the 
same tests against the
same data, in different app servers and different databases.  Because 
the application has a
rich client interface (via applet) much testing needs to be performed by 
hand.  Even some
of the test setup has to occur using the GUI as we don't yet have a way 
to automate it. I need
to be able to setup a test database in Oracle, for instance, setup/run 
some tests, then at some
point switch over to MySQL using the same data that was in Oracle,  then 
again re-run some
tests, then at some point switch over to HyperSonic (SyBase, PointBase, 
DB2, MS-SQL etc.) 

So my plugin would - I think - build on work done in SQL Scripts plugin 
by being able to
use two connections to databases of differing types (Oracle , MySQL), 
asking the user for
input schema on Oracle and output database in MySQL.  The challenge in 
doing this is
mapping the types - perhaps a configuration dialog would allow the user 
to choose to use
default mappings (Oracle:NUMBER -> MySQL:MEDIUM INT) or customize them.
The plugin could then create tables/views in MySQL using the definitions 
in Oracle.  Then it would
read records in each table in Oracle, and write them into the 
corresponding table in MySQL.

So, is anyone currently working on such a plugin and if so, could I 
help?  If not, do you all
think this would be a useful plugin to include with SQuirreL, or perhaps 
just distribute it on
my own (it would still be open source licensed)?

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83

Hi all,

Glenn Griffin and me, Gerd Wagner, are trying to fix the problems that 
SQuirreL had since the introduction of the multiple session window 
framework.

I just extended the Plugin API such that Session Plugins can support the 
new framework.

A Session Plugin might decide to not support the framework. Then it's 
functions are only available in the main session windows not in other 
session windows.

I was able to make most of the plugins that don't belong to me compile.
At the moment these plugins don't support the new framework. If you are 
interested in making those plugins support the new framework you may 
have a look at the editextras or the codecompletion plugin or ask me.

The following plugins had compile problems that are not connected to the 
new framework. I didn't fix these plugins:

laf, favs, sessionscript, mysql


Gerd

Hi Paul,


Paul Galbraith-TM wrote:
> Is there an easy way to execute/debug a plugin without putting the class 
> files into a jar file?

The plugin loader needs the jar file, but it doesn't have to be up to
date. All you need to do is to put the compile output path in your
classpath. I usually set it up as the first classpath entry. SQuirreL's
class loader first searches the classpath then the plugin jars.

For savety you may even try to put only an empty copy of the plugin
class (the implementation of ISessionPlugin) in your jar. By empty I
mean you can make all methods just throw exceptions. So you will easily
notice if once a method of this class would be called.

I hope this helps

Gerd

Stan:

 > I have Oracle 8.1.7.4.0, JDBC 8.1.6.0.0 and SQuirreL 1.2beta6.

Unfortunately, I don't have a v8 database around, so I can't try to 
reproduce your configuration.  What I would try first is to go to:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

and download Oracle's latest (10.1.0.2.0) jdbc driver.  Also, if you're 
running java JDK 1.3 (I forgot to ask), I would download and install 
java JDK 1.4 or 1.5.


Maury...


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 10/01/2005

Stan:

> We here, at my office, use SQuirreL a lot as well.  BUT for Oracle it 
> doesn't work.  It generates this ugly "not in the streaming mode" error 
> and stops.  I have files a bug report and at some point  got a response 
> to it, but the bug hasn't been fixed.  So, I'm switching to another 
> client, even if it's not that good (jEdit has an SQL plugin: simple but 
> OK).

Uhm.  I use SQuirreL almost exclusively for Oracle, and it works relatively 
well.  Just out of curiosity, what are the versions of the Oracle database 
and the JDBC driver you are using?



Maury...

We here, at my office, use SQuirreL a lot as well.  BUT for Oracle it 
doesn't work.  It generates this ugly "not in the streaming mode" error 
and stops.  I have files a bug report and at some point  got a response 
to it, but the bug hasn't been fixed.  So, I'm switching to another 
client, even if it's not that good (jEdit has an SQL plugin: simple but OK).

Stan Berka

Maury Hammel wrote:

> Gerd:
>
> > SQuirreL is not dead especially not for me. Me and all of my colleagues
> > at work use it and like it a lot. We are using a snapshot of the 
> sources
> > that I took just before the work at the Multible session window
> > framework started. This version is pretty well tested und quite
> > functional. If you want me to I can mail you this version. Without the
> > libs that are available in CVS and including all the plugins we use it
> > is a tar.gz of 1.5 mb.
>
> Would you send me a copy of your snapshot?
>
>
> Thanks... Maury.
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>

Is there an easy way to execute/debug a plugin without putting the class =
files into a jar file?

Gerd:

 > SQuirreL is not dead especially not for me. Me and all of my colleagues
 > at work use it and like it a lot. We are using a snapshot of the sources
 > that I took just before the work at the Multible session window
 > framework started. This version is pretty well tested und quite
 > functional. If you want me to I can mail you this version. Without the
 > libs that are available in CVS and including all the plugins we use it
 > is a tar.gz of 1.5 mb.

Would you send me a copy of your snapshot?


Thanks... Maury.

Hi Alex,

all you need to do is delete
sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/SQLExecuterTask.java
and compile will work.

Unfortunately SQuirreL is in the middle of the introduction of a
"Multible session window framework". Nonetheless it works. The people
who where working on the new framework got stuck at the moment but I'm
confident they will be back in the near future.

SQuirreL is not dead especially not for me. Me and all of my colleagues
at work use it and like it a lot. We are using a snapshot of the sources
that I took just before the work at the Multible session window
framework started. This version is pretty well tested und quite
functional. If you want me to I can mail you this version. Without the
libs that are available in CVS and including all the plugins we use it
is a tar.gz of 1.5 mb.

Here's just a quick overview of the things I have done that have not yet
been released:

- The graph plugin allows you to print tables and their foregin key
relations.

- Scripting is more complete and available from within the graph plugin.

- The code completion plugin provides shortcuts for writing joins. Those
shortcuts use foreign key relations to generate the join syntax.

- The syntax plugin uses the editor of Sun's Netbeans IDE. This editor's
syntax highlightning is more exact, it is less memory consuming and
feels more like a real code editor than the old editor.


I hope this gives you a little faith that SQuirreL is alive.

Gerd

Hello, All !

Is the SQuirreL SQL project in active development ? I see commits in cvs only from Gerd Wagner.
I tried to compile project from cvs, but I see some errors. Can anybody help me with this beast ?

$ ant compile_app
Buildfile: build.xml

init:
     [echo] ANT HOME: ${env.ANT_HOME}
     [echo] JAVA HOME: /opt/j2sdk1.4.2_05/

setup:
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/work/obj
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/jws
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/lib
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/doc
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/src
    [mkdir] Created dir: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/plugins

compile_fw:
     [echo] ---------------- Framework ----------------
    [javac] Compiling 234 source files to /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/work/obj
    [javac] /home/alex/projects/sq-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/sql/DataCache.java:418: warning: getJarFileName() in net.sourceforge.squirrel_sql.fw.sql.ISQLDriver has been deprecated
    [javac]                             String fileName = driver.getJarFileName();
    [javac]                                                         ^
    [javac] 1 warning
     [copy] Copying 15 files to /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/work/obj
     [copy] Copying 3 files to /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/lib
      [jar] Building jar: /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/dist/lib/fw.jar

compile_app:
     [echo] ---------------- squirrel-sql 1.2beta7 ----------------
    [javac] Compiling 352 source files to /home/alex/projects/sq-sql/squirrel-sql-dist/squirrel-sql-1.2beta7/core/work/obj
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/SQLExecuterTask.java:477: cannot resolve symbol
    [javac] symbol  : class SQLExecutionInfo
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask
    [javac]                                                                             final SQLExecutionInfo exInfo)
    [javac]                                                                                       ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/Application.java:911: warning: setLogStream(java.io.PrintStream) in java.sql.DriverManager has been deprecated
    [javac]                     DriverManager.setLogStream(null);
    [javac]                                      ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/Application.java:930: warning: setLogStream(java.io.PrintStream) in java.sql.DriverManager has been deprecated
    [javac]                                     DriverManager.setLogStream(_jdbcDebugOutputStream);
    [javac]                                                      ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/Application.java:938: warning: setLogStream(java.io.PrintStream) in java.sql.DriverManager has been deprecated
    [javac]                                     DriverManager.setLogStream(System.out);
    [javac]                                                      ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/properties/SessionProperties.java:731: warning: splitString(java.lang.String,char,boolean) in net.sourceforge.squirrel_sql.fw.util.Utilities has been deprecated
    [javac]             return Utilities.splitString(_schemaPrefixList, ',', true);
    [javac]                                 ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/properties/SessionProperties.java:761: warning: splitString(java.lang.String,char,boolean) in net.sourceforge.squirrel_sql.fw.util.Utilities has been deprecated
    [javac]             return Utilities.splitString(_catalogPrefixList, ',', true);
    [javac]                                 ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/gui/session/SessionPanel.java:167: warning: updateState() in net.sourceforge.squirrel_sql.client.gui.session.MainPanel has been deprecated
    [javac]             _mainTabPane.updateState();
    [javac]                             ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/action/DumpSessionCommand.java:280: warning: getTypeInfo() in net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData has been deprecated
    [javac]                             dest.show(new DatabaseTypesDataSet(conn.getSQLMetaData().getTypeInfo()));
    [javac]                                                                                       ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/SQLExecuterTask.java:324: cannot resolve symbol
    [javac] symbol  : class SQLExecutionInfo
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask
    [javac]             final SQLExecutionInfo exInfo = new SQLExecutionInfo(_currentQueryIndex,
    [javac]                       ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/SQLExecuterTask.java:324: cannot resolve symbol
    [javac] symbol  : class SQLExecutionInfo
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask
    [javac]             final SQLExecutionInfo exInfo = new SQLExecutionInfo(_currentQueryIndex,
    [javac]                                                     ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/SQLExecuterTask.java:470: cannot resolve symbol
    [javac] symbol  : method getSQLPanelAPI (net.sourceforge.squirrel_sql.client.plugin.IPlugin)
    [javac] location: interface net.sourceforge.squirrel_sql.client.session.ISession
    [javac]                             ISQLPanelAPI sqlPnlApi = _session.getSQLPanelAPI(dummyPlugin);
    [javac]                                                                  ^
    [javac] /home/alex/projects/sq-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/database/DataTypesTab.java:76: warning: getTypeInfo() in net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData has been deprecated
    [javac]                     ResultSet rs = session.getSQLConnection().getSQLMetaData().getTypeInfo();
    [javac]                                                                ^
    [javac] 4 errors
    [javac] 8 warnings

BUILD FAILED
/home/alex/projects/sq-sql/sql12/build/build.xml:155: Compile failed; see the compiler error output for details.



WBR, Alex.

Hello.
I'm brand new to this excelent Tool (4 days yet).
I'm currently using Version 1.1Final1.

As in our Company we are currently using QMF for SQL - Querys, we have=20
many QMF Scripts already.
So I've developed a simple Plugin to load and convert this Queries.
This plugin also converts variable parameters to SQLBookmark style.

Now I want (as a first step) to extend the SQLBookmark plugin to Hook=20
into SQL execution and to online exchange
parameters whith user entries and then execute the modified SQL.

I've used ISession.getSQLPanelAPI().addExecutionListener(...) for this=20
reason, but though it seams that my Listener will be registered, it is=20
never called.
The listener is registered in sessionStarted() and will be removed in=20
sessionEnded();
Because the might be more than 1 session, I manage the associated=20
listeners via a hashtable.
This seems to work (as I can see from the generated Messages).
But my Listener isn't ever called.

So my Questions are,

is it ok to register an SQLExecutionListener that way ?
In plugin.html there is an Example just using=20
ISession.addExecutionListener(...), but I think this is an outdated=20
example, because this funktion isn't available in the current library.

If it's the wrong way, you will I achive the requested result ?

Any help will be appreciated.

J=FCrgen Stauvermann

On Sat, Dec 04, 2004 at 08:38:42PM +0100, Jan Brinkmann wrote:
> (to Gentoo Linux). I've resolved nearly every
> dependency, except tt-bytecode.jar. I can't figure
> out to which project this jarfile belong.=20

Hi,

I found the project to which tt-bytecode.jar belong
on my own. Now I've got another problem. If i try to
build the app via 'ant compile_app' i get the following
errors:

    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:53: cannot find symbol
    [javac] symbol  : class CopyQualifiedObjectNameAction
    [javac] location: package net.sourceforge.squirrel_sql.client.session.a=
ction
    [javac] import net.sourceforge.squirrel_sql.client.session.action.CopyQ=
ualifiedObjectNameAction;
    [javac]                                                           ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:54: cannot find symbol
    [javac] symbol  : class CopySimpleObjectNameAction
    [javac] location: package net.sourceforge.squirrel_sql.client.session.a=
ction
    [javac] import net.sourceforge.squirrel_sql.client.session.action.CopyS=
impleObjectNameAction;
    [javac]                                                           ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:289: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]     public void addObjectTreeListener(IObjectTreeListener lis)
    [javac]                                           ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:300: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]     void removeObjectTreeListener(IObjectTreeListener lis)
    [javac]                                       ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:155: cannot find symbol
    [javac] symbol  : class CopySimpleObjectNameAction
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             addToPopup(actions.get(CopySimpleObjectNameAction.c=
lass));
    [javac]                                        ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:156: cannot find symbol
    [javac] symbol  : class CopyQualifiedObjectNameAction
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             addToPopup(actions.get(CopyQualifiedObjectNameActio=
n.class));
    [javac]                                        ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:239: cannot find symbol
    [javac] symbol  : method clearCache()
    [javac] location: class net.sourceforge.squirrel_sql.fw.sql.SQLDatabase=
MetaData
    [javac]             _session.getSQLConnection().getSQLMetaData().clearC=
ache();
    [javac]                                          ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:266: cannot find symbol
    [javac] symbol  : method clearCache()
    [javac] location: class net.sourceforge.squirrel_sql.fw.sql.SQLDatabase=
MetaData
    [javac]             _session.getSQLConnection().getSQLMetaData().clearC=
ache();
    [javac]                                          ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:291: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             _listenerList.add(IObjectTreeListener.class, lis);
    [javac]                                   ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:302: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             _listenerList.remove(IObjectTreeListener.class, lis=
);
    [javac]                                      ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:623: cannot find symbol
    [javac] symbol  : class ObjectTreeListenerEvent
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             ObjectTreeListenerEvent evt =3D null;
    [javac]                 ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:626: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                     if (listeners[i] =3D=3D IObjectTreeListener=
=2Eclass)
    [javac]                                             ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:631: cannot find symbol
    [javac] symbol  : class ObjectTreeListenerEvent
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                                     evt =3D new ObjectTreeListe=
nerEvent(ObjectTree.this);
    [javac]                                                   ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:633: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                             ((IObjectTreeListener)listeners[i +=
 1]).objectTreeCleared(evt);
    [javac]                                   ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:647: cannot find symbol
    [javac] symbol  : class ObjectTreeListenerEvent
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]             ObjectTreeListenerEvent evt =3D null;
    [javac]                 ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:650: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                     if (listeners[i] =3D=3D IObjectTreeListener=
=2Eclass)
    [javac]                                             ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:655: cannot find symbol
    [javac] symbol  : class ObjectTreeListenerEvent
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                                     evt =3D new ObjectTreeListe=
nerEvent(ObjectTree.this);
    [javac]                                                   ^
    [javac] /var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-200412=
04/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree=
/ObjectTree.java:657: cannot find symbol
    [javac] symbol  : class IObjectTreeListener
    [javac] location: class net.sourceforge.squirrel_sql.client.session.mai=
npanel.objecttree.ObjectTree
    [javac]                             ((IObjectTreeListener)listeners[i +=
 1]).objectTreeRefreshed(evt);
    [javac]                                   ^
    [javac] Note: * uses or overrides a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
    [javac] 18 errors
    [javac] 3 warnings

BUILD FAILED
/var/tmp/portage/squirrel-sql-20041204/work/squirrel-sql-20041204/build/bui=
ld.xml:153: Compile failed; see the compiler error output for details.

Total time: 14 seconds


the missing classes are not in the cvs tree. can anybody point me to a
solution of this problem?


-- Jan

Hi,

I'm currently trying to integrate Squirrel SQL via
a source based build into Gentoo Linux (www.gentoo.org)=20
what means that I'm writing an ebuild for it. We
don't want that packages rely on packed jars which
come with the distfile to avoid that a user has multiple
copies of a library on his system. This implies that=20
we also have to add dependencies to the portage tree=20
(to Gentoo Linux). I've resolved nearly every
dependency, except tt-bytecode.jar. I can't figure
out to which project this jarfile belong. If you
could tell me where I can find it, you would be=20
a great help. Thank you.

-- Jan

On Wed, Oct 20, 2004 at 08:59:09AM -0700, Brent Miller wrote:
> This is in regards to a bug I saw posted.....
> 
> On 2004-09-23, Apple released Java 1.4.2 Update 2. 
> After installing the update, I know longer have a
> problem viewing the IxPack interface.  Infact, pretty
> much all popular thrid party Look-and-feel packages
> are rendering much better on OS X.

Thanks Brent. I'll add it to the FAQ.

-- 
Colin Bell
http://www.squirrelsql.org

On Wed, Oct 20, 2004 at 08:51:06AM -0700, Brent Miller wrote:
> Quick question.  There are several classes that
> implement the JTable class.  However, I can't seem to
> find the class in 1.2 Beta 6 that is used to display
> the results from an SQL query as a table. 
> BeanPropertyTable?  DataSetViewerTablePanel?  Sorry
> for the lame question, just started to get my hands on
> the code....

Should be DataSetViewerTablePanel unless Glenns changed it. I haven't
been in that part of the code in a while. Its actually defined in one of
the properties in ~/.squirrelsql/prefs.xml

<sqlResultsOutputClassName>net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetViewerTablePanel</sqlResultsOutputClassName>

-- 
Colin Bell
http://www.squirrelsql.org

On Sun, Oct 10, 2004 at 08:43:48AM -0600, Maury Hammel wrote:
> Would whomever (Colin?) is working on 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionInfo.java 
> and net.sourceforge.squirrel_sql.client.session.ISession.java in sql12 
> please commit the latest versions to CVS, if they're ready?  The first 
> file doesn't exist, and the second doesn't contain the method 
> getSQLPanelAPI.

I've got some time to work on SQuirreL now so this will get fixed in the
next few days.

-- 
Colin Bell
http://www.squirrelsql.org

This is in regards to a bug I saw posted.....

On 2004-09-23, Apple released Java 1.4.2 Update 2. 
After installing the update, I know longer have a
problem viewing the IxPack interface.  Infact, pretty
much all popular thrid party Look-and-feel packages
are rendering much better on OS X.

--Brent


		
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail 

Hi,

Quick question.  There are several classes that
implement the JTable class.  However, I can't seem to
find the class in 1.2 Beta 6 that is used to display
the results from an SQL query as a table. 
BeanPropertyTable?  DataSetViewerTablePanel?  Sorry
for the lame question, just started to get my hands on
the code....

Thanks,

Brent


		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com