squirrel-sql-users — A subscriber only discussion list for SQuirreL

[Squirrel-sql-users] SQuirreL 1.2beta1 released along with MySQL plugin 0.20 and Syntax plugin 0.10

[Colin b. <col...@bi...>]

The first beta of 1.2 is now available. A new version of the MySQL 
plugin has been released and the jEdit plugin has been replaced by the 
Syntax Highlighting plugin. The main changes in 1.2beta1 include:

You can now maintain data in the Contents Tab for a table, check the 
help file under "Editing Data in the Contents Tab" for more information.

You can filter data in the contents tab in order to "drill down" to the 
data you want to see.

JDBC driver properties can now be specified for a connection.

SQL history is now persistent and shareable between aliases.

Results will now be displayed for all the result sets returned by an
executed SQL statement, not just the first one.

The homepage can be found at http://squirrel-sql.sf.net and downloads are at
http://sourceforge.net/project/showfiles.php?group_id=28383&release_id=170667

The full list of changes is at
http://sourceforge.net/project/shownotes.php?release_id=170667

-- 
Colin Bell
http://squirrel-sql.sf.net

RE: [Squirrel-sql-users] SQrL & Oracle 7.3

[Colin B. <Col...@as...>]

Hi Ruffin,

I havent used SQuirreL with Oracle 7.3, FWIW its fine with Oracle 8.1.6 and
Oracle 9.

I would expect problems with 7.3. In a previous job we tried using JDBC to
Oracle 7.3 and never got it working properly mainly because the JDBC driver
supplied by Oracle were pretty bad. If you want to post the error messages
that you are getting, they may spark a memory about the problems we were
having.

Col

-----Original Message-----
From: Ruffin Bailey [mailto:Ruf...@Bl...]
Sent: Thursday, 26 June 2003 1:36
To: squ...@li...
Subject: [Squirrel-sql-users] SQrL & Oracle 7.3


Anybody using SQrL and Oracle, specifically version 7.3?  I noticed on
Google that the JDBC-ODBC bridge isn't always going to work (using Windows
2k, fwiw) b/c of some "fancy metadata" that Oracle uses.

I tried downloading the JDBC drivers from Oracle's site, but got a host of
errors when I was trying to log in.  Not sure if I need the dll's on the
site to get the JDBC drivers working (that just seems wrong; it's a *JDBC*
driver, for heaven's sake) or not.  Also tried the "thin drivers", but for
whatever reason they weren't connecting with id & pwd's that worked through
simple ODBC.

Unf. I'm not an Oracle guy (SQL Server and Sybase), and am just trying to
use the ANSI-SQL approach once I do get it working, so I know less than
nothing about Oracle-specific stuff.  We've got an Oracle box on the network
where we test for Oracle-using clients, and that's that.

If anybody's gone through the setup and wouldn't mind giving me a
play-by-play, I'd sure appreciate it.

Thanks!

Ruffin Bailey


-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] SQrL & Oracle 7.3

[Ruffin B. <Ruf...@Bl...>]

Anybody using SQrL and Oracle, specifically version 7.3?  I noticed on =
Google that the JDBC-ODBC bridge isn't always going to work (using =
Windows 2k, fwiw) b/c of some "fancy metadata" that Oracle uses.

I tried downloading the JDBC drivers from Oracle's site, but got a host =
of errors when I was trying to log in.  Not sure if I need the dll's on =
the site to get the JDBC drivers working (that just seems wrong; it's a =
*JDBC* driver, for heaven's sake) or not.  Also tried the "thin =
drivers", but for whatever reason they weren't connecting with id & =
pwd's that worked through simple ODBC.

Unf. I'm not an Oracle guy (SQL Server and Sybase), and am just trying =
to use the ANSI-SQL approach once I do get it working, so I know less =
than nothing about Oracle-specific stuff.  We've got an Oracle box on =
the network where we test for Oracle-using clients, and that's that.

If anybody's gone through the setup and wouldn't mind giving me a =
play-by-play, I'd sure appreciate it.

Thanks!

Ruffin Bailey

[Squirrel-sql-users] JDK Versions

[Colin B. <Col...@as...>]

Just a quick note to let everybody know. SQuirreL 1.2 will require JDK
1.3.1, not JDK 1.4.x because of problems with JDK 1.4 on OS X.

Col

[Squirrel-sql-users] RE: newbie question about stored procedures

[Colin B. <Col...@as...>]

Hi Peter,

Your email didn't go through to the list because of the size of the
attachments. Next time just zip up any attachments and it should go through
automatically.

If the stored procedure returns its data through a result set then SQuirreL
should display it. I don't currently have access to Sybase but with
Microsoft SQL Server "exec sp_tables" for example returns results. Could you
test one of the standard system stored procedures to see if they return a
result set in SQuirreL?

One problem in SQuirreL 1.1 that has been fixed in CVS and will be available
in the soon to be released 1.2 beta concerns multiple result sets. If your
stored procedure returns multiple result sets only the first will be
displayed, subsuquent ones will be ignored.

> Also BTW,  I installed squirrel (and java) on a windows network drive (I
> know this sounds bad) so that my co-workers could use it.  Is there a way
> for us to share a "group" alias file,
> while each keeping a copy of our own alias file?

Not currently. If you'd like it just add an entry to the wish list at
SourceForge.

Col

-----Original Message-----
From: Kleinmann, Peter G [mailto:pk...@le...]
Sent: Friday, 20 June 2003 12:36
To: Colin Bell
Subject: newbie question about stored procedures




I just installed squirrel-sql and I think its really cool, but, I can't seem
to get output from stored procedures.
On a sybase enterprise server,  I can run the following:

exec GetData
@AliasOwner='gmdpublic',@AliasName='CLOSINGVOL',@StartDate='20020621',@ThruD
ate='20020621'

via isql, I get
----------------------------------------------------------------------------
---------------------------------------------------
 ConceptID   QuoteDate                  DataPoint            DataPointFlag
         AliasTag
 ----------- -------------------------- -------------------- -------------
        ----------------------------------------------------------------
      273322        Jun 21 2002 12:00AM             2.449991 V
         CVUSDV01_M

      //rows deleted

      292913        Jun 21 2002 12:00AM             5.817167 V
         CVUSDV30_M

(307 rows affected, return status = 0) 


but via squirrel, I get
----------------------------------------------------------------------------
---------------------------------------------------
1 Rows Updated
Query 1 elapsed time (seconds) - Total: 0.062, SQL query: 0.062, Building
output: 0


I can execute standard sql commands without compilcations.


In case this helps, I've attached an application dump and a session dump.
I would have attached the log as well, but only recent messages where about 
drives for db's we don't have.

Your help would be very much appreciated.

 <<squirrel-session>>  <<squirrel>> 


thanks in advance,

Peter


BTW, pardon me if this is too sybase specific, but I found a great applet
for converting 
sybase interface file data into hosts and ports, which can then be used to
construct the 
url's for sybase connection strings.  Its at:
http://www.outlands.demon.co.uk/utilities/tli2ip.html
<http://www.outlands.demon.co.uk/utilities/tli2ip.html> 


Also BTW,  I installed squirrel (and java) on a windows network drive (I
know this sounds bad)
so that my co-workers could use it.  Is there a way for us to share a
"group" alias file,
while each keeping a copy of our own alias file?

This is a nice piece of work.







----------------------------------------------------------------------------
--
This message is intended only for the personal and confidential use of the
designated recipient(s) named above.  If you are not the intended recipient
of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited.  This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers.  Email transmission cannot be guaranteed to be
secure or error-free.  Therefore, we do not represent that this information
is
complete or accurate and it should not be relied upon as such.  All
information is subject to change without notice.

[Squirrel-sql-users] remove feature?

[gwg <gw...@co...>]

Folks,
One of the existing features in SQuirreL is going to make some of my 
development harder, and before I put in that effort I would like to ask 
if anyone is using that feature.  The alternatives I am considering 
could include eliminating the feature or making a significant 
modification to it.

The feature is setting various fields to show a standard description of 
the data rather than the data itself.  For example, instead of showing 
"011010010", it would say "Binary".  The feature is enabled/disabled on 
a per-data-type basis under "Session Parameters"-> "SQL", and is labeled 
"Show String Data for Columns of these Data Types".

My questions are:

1. Do you use this feature?

2. What benefit does it give you (e.g. performance, reduced clutter in 
display, etc.)?

3. What types of data do you use it for?

4. If the reason you use it is performance, can you give us an example 
or two of the difference between turning the feature on (i.e. showing 
only the description of the data) and turning it off (i.e. showing the 
actual data)?


Thank you for sharing your insight.

Glenn Griffin

[Squirrel-sql-users] Kymerix

[Colin B. <col...@te...>]

Kymerix http://kymerix.com/ is an organization created to promote open 
source Java desktop applications. Each month they will be doing a 
feature on a Java application. This month they have done one on 
SQuirreL which you can read at http://kymerix.com/reviews/squirrel.html

--
Colin Bell
http://squirrel-sql.sf.net

RE: [Squirrel-sql-users] location of "blob" window

[Colin B. <Col...@as...>]

This ones definitely a bug. Its been fixed in CVS and will be available in
the next release. To get an idea of what has been done for 1.2 you can take
a look at the change log
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/squirrel-sql/sql12/doc/change
s.txt?rev=HEAD

Col

-----Original Message-----
From: Surowiec, William [mailto:Wil...@th...]
Sent: Thursday, 12 June 2003 2:03
To: 'squ...@li...'
Subject: [Squirrel-sql-users] location of "blob" window


I've just started using squirrel (neat) and noticed either a gottcha 
or further evidence of the need to rtfm (read the fine manual). 
My firebird database has text blob fields. Double clicking on one cell 
brings up a dialog box with the content. The top of the dialog box seems 
to lie "under" the main panel and it is not possible, with the mouse, 
to click and reposition that dialog box (or to close just it, etc). 

[Squirrel-sql-users] location of "blob" window

[Surowiec, W. <Wil...@th...>]

I've just started using squirrel (neat) and noticed either a gottcha
or further evidence of the need to rtfm (read the fine manual). 

My firebird database has text blob fields. Double clicking on one cell
brings up a dialog box with the content. The top of the dialog box seems 
to lie "under" the main panel and it is not possible, with the mouse,
to click and reposition that dialog box (or to close just it, etc).

RE: [Squirrel-sql-users] adding new drivers

[Colin B. <col...@te...>]

Hi Bill,

In future please reply to the list, not just to me.

It looks like you're a victim of bad error handling in SQuirreL. I
installed Firebird 1.5rc3 and JayBird JDBC 1.0 and got a stack trace
(see below) in the command window when I tried to add a new driver using
the supplied firebirdsql.jar. It worked with the supplied
firebirdsql-full.jar. I don't know the JayBird build process but it
looks like you need one or more thirdparty jars. In the jaybird/lib
directory there are 3 jars - jaas.jar, log4j-core.jar,
mini-concurrent.jar and mini-j2ee.jar

In the next version of SQuirreL this error will display in a dialog, not
in the command window.

java.lang.NoClassDefFoundError: javax/resource/ResourceException
        at java.lang.Class.getDeclaredConstructors0(Native Method)
        at java.lang.Class.privateGetDeclaredConstructors(Class.java:1590)
        at java.lang.Class.getConstructor0(Class.java:1762)
        at java.lang.Class.newInstance0(Class.java:276)
        at java.lang.Class.newInstance(Class.java:259)
        at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.registerSQLDriver(SQLDriverManager.java:61)
        at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager$MyDriverListener.propertyChange(SQLDriverManager.java:163
        at
java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:252)
        at
net.sourceforge.squirrel_sql.fw.util.PropertyChangeReporter.firePropertyChange(PropertyChangeReporter.java:52)
        at
net.sourceforge.squirrel_sql.fw.sql.SQLDriver.setJarFileNames(SQLDriver.java:267)
        at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.applyFromDialog(DriverMaintSheet.java:257)
        at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.performOk(DriverMaintSheet.java:238)
        at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet.access$100(DriverMaintSheet.java:68)
        at
net.sourceforge.squirrel_sql.client.db.DriverMaintSheet$2.actionPerformed(DriverMaintSheet.java:364)
        at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
        at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)
        at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419)
        at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
        at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
        at java.awt.Component.processMouseEvent(Component.java:5134)
        at java.awt.Component.processEvent(Component.java:4931)
        at java.awt.Container.processEvent(Container.java:1566)
        at java.awt.Component.dispatchEventImpl(Component.java:3639)
        at java.awt.Container.dispatchEventImpl(Container.java:1623)
        at java.awt.Component.dispatchEvent(Component.java:3480)
        at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
        at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
        at java.awt.Container.dispatchEventImpl(Container.java:1609)
        at java.awt.Window.dispatchEventImpl(Window.java:1590)
        at java.awt.Component.dispatchEvent(Component.java:3480)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
        at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: "Surowiec, William" <Wil...@th...>
Date: Tuesday, June 10, 2003 11:39 pm
Subject: RE: [Squirrel-sql-users] adding new drivers

> Thanks for the reply Colin. Here is what I know and what I'm doing 
> (with the
> distinct possibility of a disjoint set):
> 
> Windows 2000 Pro, I keep it up to date with all Microsoft 
> recommend updates.
> Java j2sdk1.4.1_02
> Firebird type 4 Interbase jdbc, jar dated about 3/15/03 (I d/l cvs 
> tree,rebuild, test, use). I wish to move to the newer firebird 
> versions, so these
> newer jdbc connections become important to me.
> SQuirreL SQL Client Version 1.1final1 (copy from help about)
> 
> I know English, at least my version of it, is as precise as a 
> sprinkling can
> distributing water. I define the driver:
> 
> 1) click the plus at the top of the driver panel
> 2) select the extra tab on the pop up panel
> 3) press add button
> 4) navigate to my firebirdsql.jar
> 5) press the open button
> 6) the jar appears on the extra tab
> 7) press the list drivers button
> 8) org.firebirdsql.jdbc.FBDriver appears in the class name
> 9) I select and fill in name: (firebird)
> 10) I select and fill in sample url (localhost:c:/gscc2.gdb)
> 11) press the ok button (it highlights and stays highlighted as 
> long as my
> mouse is over it).
> 
> 
> It seems as if nothing has happened. The dialog box stays up. The 
> driverspanel has not been updated. Pressing the + on the alias 
> panel, I get an add
> alias popup. Firebird is not an option in the combo box.
> 
> Not sure what to do next short of read code or ask if I am doing 
> somethingdumb or have missed something.
> 
> I do thank you for enduring the obvious pain supporting anything 
> offered to
> the public must cause. I hope not to be a pest.
> 
> I will play on my end. Possibly the firebird jar needs more 
> supporting jars.
> While I try _not_ to add stuff to my classpath or jre lib 
> directory (I find
> installing my stuff on client machines to be far harder) I will 
> try that
> approach to see what I see. Unfortunately, jury duty starts 
> tomorrow and I
> am already under water.
> 
> Thank you again,
> 
> Bill
> 
> 
 

Re: [Squirrel-sql-users] adding new drivers

[Colin B. <col...@te...>]

Hi Bill,

> I am attempting to add a "firebird", nee "Interbase", driver on 
> the extra
> class path tab. All seems to go well. Unfortunately, the driver 
> never shows
> up as one that may be selected.

I haven't used Interbase/Firebird for a while but I've previously had
SQuirreL successfully connected to it with both the old Interclient
driver and the new Firebird JDBC driver. What exactly do you mean when
you say "the driver never shows up as one that may be selected"? Are you
creating a new driver definition, adding the driver jar(s) to the extra
class path, saving it but the new driver doesn't show in the Driver
dropdown in the Alias maintenance dialog?

A couple of things to look at:

- I've had a reported problem where changing the jars that a driver
definition refers to doesn't change the icon from unavailable to
available in the drivers list dialog but the driver still works. If this
is your problem then the Interbase driver should be useable. The icon
fixes itself when SQuirreL restarts. I haven't been able to duplicate
this problem.

- Try placing the driver jars in your CLASSPATH or in your jre/lib/ext
directory. I've had some reports of older drivers (I can't remember
which drivers/DBMS's now) where the driver wouldn't work when specified
in the "Extra Classpath" tab. Updating to the latest drivers fixed this
problem.

- Which version of Firebird server and JDBC driver are you using? Which
operating system and Java version? If you're using java 1.3.0 I'd
recommend upgrading to at least 1.3.1, preferably 1.4. 1.3.0 has a
number of serious problems.

--
Colin Bell
http://squirrel-sql.sf.net


 

[Squirrel-sql-users] adding new drivers

[Surowiec, W. <Wil...@th...>]

I'm a new user and am having trouble adding a driver.

I have reviewed about 150 of the most recent emails to this list and seem to
be unique (an "honor" unwanted).

I am attempting to add a "firebird", nee "Interbase", driver on the extra
class path tab. All seems to go well. Unfortunately, the driver never shows
up as one that may be selected.

As I am clueless, (no, more honestly, since I am asking) I will accept any
reasonable advice (accustomed as I am to a bountiful harvest generously,
unbidden, freely offered by my wife).

thank you in advance

Bill

[Squirrel-sql-users] [ANN] SQuirreL included in Out-of-the-Box Open Source distribution

[Rod C. <rod...@ej...>]

SQuirreL is included in Out-of-the-Box 2.0, an intelligent distribution =
of
over 100 Open Source projects for Java developers on both Linux and =
Windows.

Its graphical installer provides selective and incremental installation =
and
uninstallation, automatic project dependency management, easy project
configuration, and a highly-organized built-in project knowledge base.  =
When
installation completes, the selected projects are installed, configured,
integrated, tested (with live JUnit/HttpUnit test reports to prove it =
all
worked), running, and ready to use.

You get 10 custom sample applications, including ones for JBoss that =
take
advantage of XDoclet, Middlegen, Hibernate, AspectJ, and more.
Out-of-the-Box comes with a 350 page user guide that contains tips, =
gotchas,
and workarounds for the major projects, along with a substantial section =
on
JBoss.

The free Community Edition is fully functional, does not expire, and =
does
not require registration.  It installs just over 25 of the 100+ =
projects,
including JBoss, MySQL, and Castor, and comes with the Castor sample =
project
and nearly all of the Enterprise Edition documentation.

Please visit http://www.ejbsolutions.com for details or to download the =
free
Community Edition.

Rod

Re: [Squirrel-sql-users] non-ASCII characters not being displayed - bug?

[Colin B. <col...@te...>]

Hi Denis=2C

I don=27t have any databases with non-ASCII character sets but I=27m told=

that SQuirreL does work with them (at least in Oracle)=2E However you wil=
l
need to configure your JDBC connection=2E Check the doco for your JDBC
driver as you=27ll probably need to add a parameter to the URL to tell it=

what character set to use=2E With Oracle you also need to add another JAR=

to the classpath - see the oracle site for details/downloads=2E

--
Colin Bell
http=3A//squirrel-sql=2Esf=2Enet

----- Original Message -----
From=3A Denis Grannell =3Cdgrannell=40web=2Ede=3E
Date=3A Saturday=2C May 31=2C 2003 7=3A11 pm
Subject=3A =5BSquirrel-sql-users=5D non-ASCII characters not being displa=
yed -
bug=3F

=3E Hi Folks=2C
=3E =

=3E I=27ve just noticed that accented characters are not
=3E being displayed correctly in squirrel 1=2E1-final=2E
=3E The effect is similar to that of displaying user-defined
=3E data types that I reported at the start of the month=2E
=3E Over here in Old Europe we are fond of accented
=3E characters like the French accent aigu (e=2Eg=2E Ren=E9)
=3E or the German Umlaut (e=2Eg=2E gr=FCn) - I hope these
=3E characters display correctly on a US locale=2E
=3E Anyway=2C if a column contains a word that has the
=3E accent aigu=2C then squirrel shows that word as an error
=3E as follows=3A
=3E =

=3E John
=3E Tom
=3E Dave
=3E =3Cerror=3E
=3E =

=3E Denis Grannell=2C Kapuzinerstr=2E 45=2C D-80469 Muenchen
=3E Tel=3A +49 89 201 3672          Fax=3A +49 89 202 2875
=3E =5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F/=5F=
/=5F/=5F/=5F/=5F/=5F/=5F/=5F/
=3E =

=3E =

=3E =

=3E -------------------------------------------------------
=3E This SF=2Enet email is sponsored by=3A eBay
=3E Get office equipment for less on eBay!
=3E http=3A//adfarm=2Emediaplex=2Ecom/ad/ck/711-11697-6916-5
=3E =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
=3E Squirrel-sql-users mailing list
=3E Squirrel-sql-users=40lists=2Esourceforge=2Enet
=3E https=3A//lists=2Esourceforge=2Enet/lists/listinfo/squirrel-sql-users=

=3E =

=3E =

 

[Squirrel-sql-users] non-ASCII characters not being displayed - bug?

[Denis G. <dgr...@we...>]

Hi Folks,

I've just noticed that accented characters are not
being displayed correctly in squirrel 1.1-final.
The effect is similar to that of displaying user-defined
data types that I reported at the start of the month.
Over here in Old Europe we are fond of accented
characters like the French accent aigu (e.g. René)
or the German Umlaut (e.g. grün) - I hope these
characters display correctly on a US locale.
Anyway, if a column contains a word that has the
accent aigu, then squirrel shows that word as an error
as follows:

John
Tom
Dave
<error>

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

Re: [Squirrel-sql-users] Exception trying to connect to database

[Colin B. <col...@te...>]

You may need to set the CHARSET or the CHARSET_CONVERTER_CLASS
properties in the URL. There is some information here
http://www.sybase.com/detail?id=1009812

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Uy Hoang <Uy....@HE...>
Date: Thursday, May 29, 2003 11:45 pm
Subject: [Squirrel-sql-users] Exception trying to connect to database

> I was able to get SQuirrel to connect fine to a Sybase ASE 
> database but
> lately it's been giving me this exception:
> 
> 
> 
> Error: hlpddu ASE: java.sql.SQLException: JZ006: Caught IOException:
> java.io.IOException: JZ0I6: An error occured converting UNICODE to the
> charset used by the server.  Error message: 
> java.io.CharConversionException:java.io.UnsupportedEncodingException:
Cp850
> 
> 
> 
> Any ideas what's going on?
> 
> 
> 
> Uy Hoang
> 
> Lockheed Martin
> 
> 
 

[Squirrel-sql-users] Exception trying to connect to database

[Uy H. <Uy....@HE...>]

I was able to get SQuirrel to connect fine to a Sybase ASE database but
lately it's been giving me this exception:

 

Error: hlpddu ASE: java.sql.SQLException: JZ006: Caught IOException:
java.io.IOException: JZ0I6: An error occured converting UNICODE to the
charset used by the server.  Error message: java.io.CharConversionException:
java.io.UnsupportedEncodingException: Cp850

 

Any ideas what's going on?

 

Uy Hoang

Lockheed Martin

RE: [Squirrel-sql-users] SQL Script plugin question

[Colin B. <Col...@as...>]

You can click on the first table in the object tree, <shift>click on the
last table, right click and select "Create Table Script" which will generate
the "CREATE TABLE" scripts for all the selected tables. This works
reasonably well for a single schema/catalog but if you have multiple
schemas/catalogs it can be a bit of a pain.

Col

-----Original Message-----
From: John Zoetebier [mailto:joh...@tr...]
Sent: Monday, 26 May 2003 12:52
To: Colin Bell
Subject: Re: [Squirrel-sql-users] SQL Script plugin question


Colin Bell wrote:

>There is a hierarchical menu "Scripts" on the "Session" menu. This has the
>options "Load Script" and "Save Script". These options will load an SQL
>script from a text file into the SQL entry area and save the contents of
the
>SQL entry area to a text file.
>
Thanks Colin,
I found it.
Is this function on table level only ?
Or is there a function that generates the data SQL for the whole datase ?
Something similar to what phpMyAdmin does for MySQL databases.
That function would be realy helpfull as it allows me to instantly 
backup and restore a database in test environment.

-- 
John Zoetebier
Web site: http://www.transparent.co.nz


>
>Col
>
>-----Original Message-----
>From: John Zoetebier [mailto:joh...@tr...]
>Sent: Sunday, 25 May 2003 12:49
>To: squ...@li...
>Subject: [Squirrel-sql-users] SQL Script plugin question
>
>
>I have installed the SQL script plugin.
>When I create a script the output is sent to the SQL window.
>I would expect a dialog to enter filename.
>Do I have to copy and paste the output into a file manually ?
>
>  
>

RE: [Squirrel-sql-users] SQL Script plugin question

[Colin B. <Col...@as...>]

There is a hierarchical menu "Scripts" on the "Session" menu. This has the
options "Load Script" and "Save Script". These options will load an SQL
script from a text file into the SQL entry area and save the contents of the
SQL entry area to a text file.

Col

-----Original Message-----
From: John Zoetebier [mailto:joh...@tr...]
Sent: Sunday, 25 May 2003 12:49
To: squ...@li...
Subject: [Squirrel-sql-users] SQL Script plugin question


I have installed the SQL script plugin.
When I create a script the output is sent to the SQL window.
I would expect a dialog to enter filename.
Do I have to copy and paste the output into a file manually ?

-- 
John Zoetebier
Web site: http://www.transparent.co.nz




-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] SQL Script plugin question

[John Z. <joh...@tr...>]

I have installed the SQL script plugin.
When I create a script the output is sent to the SQL window.
I would expect a dialog to enter filename.
Do I have to copy and paste the output into a file manually ?

-- 
John Zoetebier
Web site: http://www.transparent.co.nz

RE: [Squirrel-sql-users] Bug when displaying user defined data types?

[Stathis.Rege <st...@re...>]

Hi Collin and Denis

I possibly have an immediate solution for this problem.

1. Try to install the sqsc-isqlj plugin located in www.rege.org/isqlj/.
2. Start a session. and write  the following statement


jdbc.getDatabase().dropTable( "foo_%");
#sql[session]
{
    create table foo_1
    (
        .......
    );
    create table foo_2
    (
        .......
    );
}


3. Select all of the code and press Control J. Propably you will have the
feature you wanted.


This will happen because i allready implemented a small parser able to run
mixed Java and SQL. I made also a plugin for SquirrelSql client.
Inside this parser exists a Database class which has the dropTable method.


I know that i did not documented, i have no excuse. I will do my best when i
will have some time.


Best regards


Stathis Alexopoulos


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of Colin
Bell
Sent: Tuesday, May 20, 2003 8:52 AM
To: 'Denis Grannell'
Cc: squ...@li...
Subject: RE: [Squirrel-sql-users] Bug when displaying user defined data
types?


Hi Denis,

I've just installed PostgreSQL under Cygwin and installed the sample ISBN
data types. The current CVS version of SQuirreL will display columns of
these data types if you have "SQL Other" checked in the "Format" tab in
Session Properties. So it should work for you in the 1.2 beta when it is
released.

Col

-----Original Message-----
From: Denis Grannell [mailto:dgr...@we...]
Sent: Monday, 12 May 2003 6:33
To: squ...@li...
Subject: [Squirrel-sql-users] Bug when displaying user defined data
types?


Hi Folks,

I've just noticed a problem displaying a Postgres
user-defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

psql output			squirrel output
=============		===============

isbn_table			isbn_table

1-56592-286-7		<Other>
0-14-043789-4		<other
0-88687-800-4		<Other>
0-575-05054-3		<Other>
   .				   .
   .				   .

cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com

_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

RE: [Squirrel-sql-users] Bug when displaying user defined data ty pes?

[Colin B. <Col...@as...>]

Hi Denis,

I've just installed PostgreSQL under Cygwin and installed the sample ISBN
data types. The current CVS version of SQuirreL will display columns of
these data types if you have "SQL Other" checked in the "Format" tab in
Session Properties. So it should work for you in the 1.2 beta when it is
released.

Col

-----Original Message-----
From: Denis Grannell [mailto:dgr...@we...]
Sent: Monday, 12 May 2003 6:33
To: squ...@li...
Subject: [Squirrel-sql-users] Bug when displaying user defined data
types?


Hi Folks,

I've just noticed a problem displaying a Postgres 
user-defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

psql output			squirrel output
=============		===============

isbn_table			isbn_table

1-56592-286-7		<Other>
0-14-043789-4		<other
0-88687-800-4		<Other>
0-575-05054-3		<Other>
   .				   .
   .				   .
 
cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 


-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com

_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: RE: [Squirrel-sql-users] Bug when displaying user defined data types?

[Colin B. <col...@te...>]

Hi Denis,

There have been some changes in the current CVS code which may fix your
problem. The first beta should be out very shortly (a week or 2). If the
beta doesn't work let me know and we'll track down the problem.

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: "Denis Grannell" <dgr...@we...>
Date: Monday, May 12, 2003 9:22 am
Subject: RE: [Squirrel-sql-users] Bug when displaying user defined data
types?

> Hi Colin,
> 
> Actually I do receive a digest every day, but I
> didn't see my posting on it, sorry.
> This happened to me once before as well.
> Anyway, I tried out your suggestion and it didn't
> seem to make any difference. Squirrel still throws
> up an 'unknown' type for the ISBN column.
> I also tried selecting 'SQL Other' but that causes
> an error straight away.
> 
> cheers,
> Denis
> 
> -----Original Message-----
> From: col...@bi... [mailto:col...@bi...]On 
> Behalf Of
> Colin Bell
> Sent: 12 May 2003 00:44
> To: Denis Grannell
> Subject: Re: [Squirrel-sql-users] Bug when displaying user defined 
> datatypes?
> 
> 
> Hi Denis,
> 
> Are you receiving messages from this list because I replied to 
> this msg
> a couple of days ago?
> 
> --
> Colin Bell
> http://squirrel-sql.sf.net
> 
> 
> -----Original Message-----
> From: Colin Bell [mailto:col...@te...]
> Sent: Friday, 9 May 2003 17:20
> To: Squ...@li...
> Subject: Re: [Squirrel-sql-users] Bug when displaying user defined 
> datatypes(?)
> 
> 
> Hi Denis,
> 
> In the SQL tab in the Session Properties dialog you can specify which
> data types are shown. Just make sure that the "All Other Data Types"
> checkbox is checked.
> 
> --
> Colin Bell
> http://squirrel-sql.sf.net
> 
> ----- Original Message -----
> From: "Denis Grannell" <dgr...@we...>
> Date: Friday, May 9, 2003 7:17 am
> Subject: [Squirrel-sql-users] Bug when displaying user defined 
> data types(?)
> 
> > Hi Folks,
> >
> > I've just noticed a problem displaying a Postgres
> > user defined data type in Squirrel 1.1 Final.
> > I have a data type of 'ISBN' which I can display
> > correctly with other clients (psql or a php script)
> > but Squirrel is displaying it as 'other'. The output
> > looks like this:
> >
> > isbn_table
> > <Other>
> > <Other>
> > <Other>
> > <Other>
> >   .
> >   .
> >
> > cheers,
> > Denis
> >
> >
> > Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
> > Tel: +49 89 201 3672          Fax: +49 89 202 2875
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> >
> 
> 
> 
> 
 

[Squirrel-sql-users] Bug when displaying user defined data types?

[Denis G. <dgr...@we...>]

Hi Folks,

I've just noticed a problem displaying a Postgres 
user-defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

psql output			squirrel output
=============		===============

isbn_table			isbn_table

1-56592-286-7		<Other>
0-14-043789-4		<other
0-88687-800-4		<Other>
0-575-05054-3		<Other>
   .				   .
   .				   .
 
cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 

[Squirrel-sql-users] Bug when displaying user defined data types?

[Denis G. <dgr...@we...>]

Hi Folks,

I've just noticed a problem displaying a Postgres 
user defined data type in Squirrel 1.1 Final.
I have a data type of 'ISBN' which I can display
correctly with other clients (psql or a php script)
but Squirrel is displaying it as 'other'. The output
looks like this:

isbn_table
<Other>
<Other>
<Other>
<Other>
   .
   .
 
cheers,
Denis

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/