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

[Squirrel-sql-users] CSV Export

[Chris L. <ga...@gm...>]

Hi,

While trying to do a CSV export I get the following error message:

java.lang.NoClassDefFoundError: jxl/write/WritableCell

Any ideas?  I'm running this under Linux.

My best guess is that it's a library path issue; should SQuirreL's
lib directory be in my java library path?
-- 
Chris Long, San Diego Padres, 100 Park Boulevard, San Diego CA

Score: 0, Diff: 1, clong killed by a Harvard Math Team on  1

Re: [Squirrel-sql-users] Bug in metadata retrieval

[Robert M. <rob...@gm...>]

On 1/19/07, Ben Burch <Ben...@me...> wrote:
> All,
>  there seems to be an issue when using squirrel-sql on windows with SQL
> Server 2000.
>
> Steps to reproduce error as follows:
> - Connect to a SQL Server 2000 instance
> - Click a table in the database explorer
> - Click the 'info' pane to view metadata
> - The 'remarks' property has a corresponding null value
>
> Having run SQL Profiler, it seems as though the information for this
> pane is fed by a call to a stored procedure called
>
> 'sp_tables'
>
> This procedure is a Microsoft one and will never return a value as
> defined online at:
>
> http://msdn2.microsoft.com/en-us/library/ms186250.aspx
>
> We would like to use Squirrel in our organisation and this error is
> causing us problems as there seems to be no other way to view the
> metadata for a table.
>
> Any ideas how to quickly correct this?
Ben,

SQuirreL uses JDBC metadata (DatabaseMetaData.getTables(...)) to
retrieve this information.  We have no control over how the driver
implements this interface internally.  I suppose this is where the
call to sp_tables is being made.  That said, maybe the driver has some
property that will "turn on" the remarks for table objects.  I know
that Oracle has this same default behavior (not populating the remarks
field of the ResultSet returned from getTables(...))  and there is
property (remarksReporting) that when set to true will cause this
field to be populated.  Oracle does this for performance reasons as
the system catalog join required is expensive for instances with many
objects.  If you come across something that tells you how to get the
remarks using code (not a driver property) please let us know.  That
may be useful information in the future for the plugin.

Rob

[Squirrel-sql-users] Bug in metadata retrieval

[Ben B. <Ben...@me...>]

All,
 there seems to be an issue when using squirrel-sql on windows with SQL
Server 2000.

Steps to reproduce error as follows:
- Connect to a SQL Server 2000 instance
- Click a table in the database explorer
- Click the 'info' pane to view metadata
- The 'remarks' property has a corresponding null value

Having run SQL Profiler, it seems as though the information for this
pane is fed by a call to a stored procedure called

'sp_tables'

This procedure is a Microsoft one and will never return a value as
defined online at:

http://msdn2.microsoft.com/en-us/library/ms186250.aspx

We would like to use Squirrel in our organisation and this error is
causing us problems as there seems to be no other way to view the
metadata for a table.

Any ideas how to quickly correct this?

Thanks
Ben

[Squirrel-sql-users] Auto Complete when using multiple tables

[<ric...@id...>]

Hi,

On a select using more than one table, the auto complete function will only list the columns of the last table defined in the select script.

Is it any way to list the columns of all defined (in the select script) tables?

Thanks,
RD

Re: [Squirrel-sql-users] Strange conversions when doing calculations with Oracle

[Robert M. <rob...@gm...>]

On 1/16/07, CptBlaubaer <cpt...@gm...> wrote:
> Hi Rob,
>
> thanks for the fast reply. It really changes the behaviour. What makes me
> think a bit is, that the other databases (mysql, MS SQL) did provide the
> default format although I had setup the locale-dependent format. Do those
> JDBC drivers return other datatypes?

I don't know. When using the locale-dependent format the code is roughly:

      _numberFormat = java.text.NumberFormat.getInstance();
      _numberFormat.setMaximumFractionDigits(5);
      _numberFormat.setMinimumFractionDigits(0);
      return _numberFormat.format(value)

I agree, it's counter-intuitive that it would be different across
database vendors.

> Anyway, thank you for the fast solution of this problem.
Your welcome.

Rob

Re: [Squirrel-sql-users] Select statement only possible using double quotes?

[Bjoern S. <bi...@fr...>]

It seems that this isn't a direct issue for the Squirrel SQL Client but
merely has to do with the Derby DB and tables generated by hibernate. In my
case the database is generated by Eclipse Teneo in runtime. Testing with a
database directly created in Squirrel SQL Client (as proposed by Robert
Manning) doesn't reproduce the problem.

I found following link on the java.sun forum describing a similar problem: 
http://forum.java.sun.com/thread.jspa?threadID=5116373&tstart=105
http://forum.java.sun.com/thread.jspa?threadID=5116373&tstart=105 

[quote]
Derby needs column and table names to be quoted. There appears to be no
developer control over the EntityManager's production of native SQL, but
developers can use the EJB's @Table and @Column annotations to specify table
and column names. When Netbeans produces an EJB from a database schema
Netbeans writes these in the format:

@Table(name = "myTable")
@Column(name = "Forename")


When the database is Derby, and therefore requires quoted table and column
names, the developer must rewrite the annotations as:

@Table(name = "\"myTable\"")
@Column(name = "\"Forename\"")
[unquote]

It doesn't really solve anything for me, but it might anyway shed some light
into this problem.

Bjoern


Bjoern Sundin wrote:
> 
> When executing SQL statements in Squirrel 2.4 I get an error if the user,
> table and/or field isn't surrounded by double quotes.
> 
> Example (lsa is a table):
> 
> SELECT "lsa"."name" FROM "lsa" --> works 
> 
> SELECT lsa.name FROM lsa --> returns following error: Error:
> java.sql.SQLException: Schema 'lsa' does not exist, SQL State: 42Y07,
> Error Code: 30000
> 
> also SELECT * FROM lsa returns this error
> 
> I'm using Java 1.6 with the Derby database embedded driver.
> 
> In the tutorials and help no double quotes are used and I find it very
> inconvenient to have to add quotes to the autocompleted names composing a
> query.
> 
> Is there any setting that I can use or any other solution to handle this?
> 
> Thanks in advance!
> Bjoern
> 
> 

-- 
View this message in context: http://www.nabble.com/Select-statement-only-possible-using-double-quotes--tf3013596.html#a8374311
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Strange conversions when doing calculations with Oracle

[Robert M. <rob...@gm...>]

On 1/15/07, CptBlaubaer <cpt...@gm...> wrote:
> Hi there,
>
> select 1.5/1.2 from dual
>
> delivers "1" as a result. This behaviour shows up only when doing this query
> against an oracle server. We're using a "Oracle Database 10g Release
> 10.2.0.2.0 " server and the 10.2.0.2.0 JDBC driver.
>
> When I do the same query against a MS SQL or mysql I get the correct value
> "1,25".
>
> If I change the query to
>
> select to_char(1.5/1.2) from dual I get "1,25" as well on an Oracle.
>
> Similar problem arises when displaying "bigger" ints.
>
> For example:
>
> select 123*456*789 from dual;
>
> delivers "44.253.432"
>
> Since I'm running SQuirreL on a localized German windows version, I had the
> idea that it may have something to do with localisation problems.
>
> Has anyone noticed something like that before? This behaviour doesn't show
> up on 2.1.
>

This is an effect which I would attribute to using 'Use
local-dependent format" as opposed to "Use default format" in Global
Preferences -> Data Type Controls -> "Float, Real, Double..."
section.  Try changing this  setting to "Use default format" and see
if that fixes it.

Rob

[Squirrel-sql-users] Strange conversions when doing calculations with Oracle

[CptBlaubaer <cpt...@gm...>]

Hi there,

select 1.5/1.2 from dual

delivers "1" as a result. This behaviour shows up only when doing this query
against an oracle server. We're using a "Oracle Database 10g Release
10.2.0.2.0" server and the 10.2.0.2.0 JDBC driver.

When I do the same query against a MS SQL or mysql I get the correct value
"1,25".

If I change the query to

select to_char(1.5/1.2) from dual I get "1,25" as well on an Oracle.

Similar problem arises when displaying "bigger" ints.

For example:

select 123*456*789 from dual;

delivers "44.253.432"

Since I'm running SQuirreL on a localized German windows version, I had the
idea that it may have something to do with localisation problems.

Has anyone noticed something like that before? This behaviour doesn't show
up on 2.1.

Take care

Andreas

[Squirrel-sql-users] Select statement only possible using double quotes?

[Bjoern S. <bi...@fr...>]

When executing SQL statements in Squirrel 2.4 I get an error if the user,
table and/or field isn't surrounded by double quotes.

Example (lsa is a table):

SELECT "lsa"."name" FROM "lsa" --> works 

SELECT lsa.name FROM lsa --> returns following error: Error:
java.sql.SQLException: Schema 'lsa' does not exist, SQL State: 42Y07, Error
Code: 30000

also SELECT * FROM lsa returns this error

I'm using Java 1.6 with the Derby database embedded driver.

In the tutorials and help no double quotes are used and I find it very
inconvenient to have to add quotes to the autocompleted names composing a
query.

Is there any setting that I can use or any other solution to handle this?

Thanks in advance!
Bjoern

-- 
View this message in context: http://www.nabble.com/Select-statement-only-possible-using-double-quotes--tf3013596.html#a8368875
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Karr, D. <dav...@wa...>]

Yes, it looks like that will help.  In the case of Oracle, it just seems
like the connection times out after a while.  I have to deal with that
in WebLogic by having it renew the connection every few minutes.

I did notice that the menu mnemonic for "Reconnect" conflicts with
"Transaction".  I filed a bug on that.=20

> -----Original Message-----
> From: Robert Manning [mailto:rob...@gm...]=20
> Sent: Sunday, January 14, 2007 10:57 AM
> To: Gerd Wagner
> Cc: Karr, David; squ...@li...
> Subject: Re: [Squirrel-sql-users] Anything to do about=20
> timed-out sessions with oracle?
>=20
> On 1/14/07, Gerd Wagner <bir...@t-...> wrote:
> > Karr, David wrote:
> > > One minor nit I have with SQuirreL is that if I let a=20
> connection sit=20
> > > for too long, the connection sort of times out, but the=20
> only way I=20
> > > can fix is to close the session with the db and open it=20
> again.  I've=20
> > > just gotten used to doing this, but I guess I should ask=20
> if there's=20
> > > a way to make this work better.  I've tried the "Refresh Object=20
> > > Tree" button, but that doesn't help in this case.
> > In the Session menu there is an item "Reconnect".
> >
> Yes, reconnect keeps you from having to save your script,=20
> close and re-open session.  It's very handy and I use from=20
> time to time.  Mostly with older (that is, buggy) MySQL=20
> server/driver which seems to drop the connection if the SQL=20
> syntax isn't perfect.
>=20
> Rob
>=20

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Robert M. <rob...@gm...>]

On 1/14/07, Gerd Wagner <bir...@t-...> wrote:
> Karr, David wrote:
> > One minor nit I have with SQuirreL is that if I let a connection sit for
> > too long, the connection sort of times out, but the only way I can fix
> > is to close the session with the db and open it again.  I've just gotten
> > used to doing this, but I guess I should ask if there's a way to make
> > this work better.  I've tried the "Refresh Object Tree" button, but that
> > doesn't help in this case.
> In the Session menu there is an item "Reconnect".
>
Yes, reconnect keeps you from having to save your script, close and
re-open session.  It's very handy and I use from time to time.  Mostly
with older (that is, buggy) MySQL server/driver which seems to drop
the connection if the SQL syntax isn't perfect.

Rob

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Gerd W. <bir...@t-...>]

Karr, David wrote:
> One minor nit I have with SQuirreL is that if I let a connection sit for
> too long, the connection sort of times out, but the only way I can fix
> is to close the session with the db and open it again.  I've just gotten
> used to doing this, but I guess I should ask if there's a way to make
> this work better.  I've tried the "Refresh Object Tree" button, but that
> doesn't help in this case.
In the Session menu there is an item "Reconnect".

Hope this helps.

Gerd

[Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Karr, D. <dav...@wa...>]

One minor nit I have with SQuirreL is that if I let a connection sit for
too long, the connection sort of times out, but the only way I can fix
is to close the session with the db and open it again.  I've just gotten
used to doing this, but I guess I should ask if there's a way to make
this work better.  I've tried the "Refresh Object Tree" button, but that
doesn't help in this case.

Re: [Squirrel-sql-users] First use of v2.4 after 2.3.2 gets exceptionin Oracle driver called from SQLDatabaseMetaData.getColumns()

[Karr, D. <dav...@wa...>]

Well, never mind.  I was a little sloppy and installed 2.4 on top of
2.3.2.  After I did it more carefully and installed it in a separate
location, 2.4 worked fine.=20

> -----Original Message-----
> From: squ...@li...=20
> [mailto:squ...@li...] On=20
> Behalf Of Karr, David
> Sent: Saturday, January 13, 2007 1:49 PM
> To: squ...@li...
> Subject: [Squirrel-sql-users] First use of v2.4 after 2.3.2=20
> gets exceptionin Oracle driver called from=20
> SQLDatabaseMetaData.getColumns()
>=20
> I installed v2.4, and then changed the bat file to point to=20
> my Java 5 distro.  When I brought it up, I connected to an=20
> alias I already had defined.  It brought up the window=20
> showing the tables, but when I tried to view a table, nothing=20
> displayed in the pane.  I noticed there was an error in the=20
> log file, which might be relevant. I didn't have this problem=20
> with v2.3.2.  I assume v2.4 is using the same aliases and=20
> driver settings that I had set in v2.3.2.  I can't view any=20
> table information with this version.  I don't see a bug like=20
> this in the bug list.
>=20
> java.sql.SQLException: Io exception: invalid arguments in call
> 	at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> 	at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
> 	at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
> 	at
> oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502)
> 	at
> oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.
> java:2416)
> 	at
> oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574)
> 	at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.
> java:2803)
> 	at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedS
> tatement.java:608)
> 	at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle
> PreparedSt
> atement.java:536)
> 	at
> oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDat
> abaseMetaD
> ata.java:242)
> 	at
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCol
> umns(SQLDa
> tabaseMetaData.java:1834)
> 	at
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCol
> umns(SQLDa
> tabaseMetaData.java:1855)
> 	at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttr
> ee.tabs.ta
> ble.ColumnsTab.createDataSet(ColumnsTab.java:69)
> 	at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttr
> ee.tabs.Ba
> seDataSetTab$1.run(BaseDataSetTab.java:123)
> 	at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExec
> uter.java:
> 82)
> 	at java.lang.Thread.run(Thread.java:595)
>=20
> --------------------------------------------------------------
> -----------
> Take Surveys. Earn Cash. Influence the Future of IT Join=20
> SourceForge.net's Techsay panel and you'll get the chance to=20
> share your opinions on IT & business topics through brief=20
> surveys - and earn cash=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
&CID=3DDEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>=20

Re: [Squirrel-sql-users] First use of v2.4 after 2.3.2 gets exception in Oracle driver called from SQLDatabaseMetaData.getColumns()

[Robert M. <rob...@gm...>]

That is a very peculiar exception.  First, it's happening when we
attempt to get the columns of a table using DatabaseMetaData which is
a perfectly valid and necessary thing to do in this case.  Second, it
looks like OracleStatement.freeLine made a mistake by calling a
procedure/method with the wrong arguments.  Do you have the latest
JDBC driver?  Does it happen consistently or only some of the time.
What if you refresh the tree? Do you have the Oracle plugin and have
you set any Alias properties (like only load certain objects from some
schemas, etc.) ?  I haven't seen this behavior before and I use the
10g driver to connect to 9i and 10g much of the time.

Rob

On 1/13/07, Karr, David <dav...@wa...> wrote:
> I installed v2.4, and then changed the bat file to point to my Java 5
> distro.  When I brought it up, I connected to an alias I already had
> defined.  It brought up the window showing the tables, but when I tried
> to view a table, nothing displayed in the pane.  I noticed there was an
> error in the log file, which might be relevant. I didn't have this
> problem with v2.3.2.  I assume v2.4 is using the same aliases and driver
> settings that I had set in v2.3.2.  I can't view any table information
> with this version.  I don't see a bug like this in the bug list.
>
> java.sql.SQLException: Io exception: invalid arguments in call
>         at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>         at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>         at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
>         at
> oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502)
>         at
> oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2416)
>         at
> oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574)
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:2803)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:608)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
> atement.java:536)
>         at
> oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaD
> ata.java:242)
>         at
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa
> tabaseMetaData.java:1834)
>         at
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa
> tabaseMetaData.java:1855)
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.ta
> ble.ColumnsTab.createDataSet(ColumnsTab.java:69)
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Ba
> seDataSetTab$1.run(BaseDataSetTab.java:123)
>         at
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:
> 82)
>         at java.lang.Thread.run(Thread.java:595)
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Can't even install Squirrel-2.4 if JAVA_HOME not set to Java 5

[Karr, D. <dav...@wa...>]

Thanks.  I should have realized this was easy to work around.=20

> -----Original Message-----
> From: Robert Manning [mailto:rob...@gm...]=20
> Sent: Saturday, January 13, 2007 12:21 PM
> To: Karr, David
> Cc: squ...@li...
> Subject: Re: [Squirrel-sql-users] Can't even install=20
> Squirrel-2.4 if JAVA_HOME not set to Java 5
>=20
> On 1/13/07, Karr, David <dav...@wa...> wrote:
> > Squirrel-2.4 requires Java 5.  That's fine.  However, it should be=20
> > understood that there will be a transition period where people are=20
> > using both JDK 1.4.2 and Java 5, and they require JDK 1.4.2=20
> for their=20
> > main work, but use Java 5 for some tools.  Eclipse works=20
> very well this way.
> > My JAVA_HOME is set for JDK 1.4.2, and I specify the Java 5=20
> runtime on=20
> > the Eclipse command line.  I can't even install Squirrel-2.4, much=20
> > less use it, even though I have Java 5 installed.
>=20
> The installer can be run from the command-line using any java=20
> 5 or 6 JRE.  It isn't necessary for the JAVA_HOME environment=20
> variable to be set to run the installer.  However, you are=20
> correct in that the script to Launch SQuirreL will use the=20
> version specified by JAVA_HOME.
> If you run some java apps that also use JAVA_HOME but require=20
> < 1.5, then you can simply put a line in squirrel-sql.bat=20
> near the top that sets JAVA_HOME to 1.5+ jvm.  Java 6 is now=20
> available and SQuirreL 2.4 works with BOTH Java 5 & 6.  Maybe=20
> we shouldn't be transitioning from
> 1.4 -> 1.5, but rather 1.5 -> 1.6 :)
>=20
> >
> > The installer should be changed to prompt the user for a Java 5=20
> > runtime directory path, if JAVA_HOME doesn't point to one. =20
> From that,=20
> > the run scripts should use that Java 5 runtime.
>=20
> That's an enhancement that's been discussed.  The original=20
> installer did ship with a panel to let you choose, but it=20
> required a JDK - a JRE wasn't sufficient.  So we removed it. =20
> We may have time to address it for 2.5
>=20
> Rob
>=20

[Squirrel-sql-users] First use of v2.4 after 2.3.2 gets exception in Oracle driver called from SQLDatabaseMetaData.getColumns()

[Karr, D. <dav...@wa...>]

I installed v2.4, and then changed the bat file to point to my Java 5
distro.  When I brought it up, I connected to an alias I already had
defined.  It brought up the window showing the tables, but when I tried
to view a table, nothing displayed in the pane.  I noticed there was an
error in the log file, which might be relevant. I didn't have this
problem with v2.3.2.  I assume v2.4 is using the same aliases and driver
settings that I had set in v2.3.2.  I can't view any table information
with this version.  I don't see a bug like this in the bug list.

java.sql.SQLException: Io exception: invalid arguments in call
	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
	at
oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502)
	at
oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2416)
	at
oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:2803)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:608)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
atement.java:536)
	at
oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaD
ata.java:242)
	at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa
tabaseMetaData.java:1834)
	at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa
tabaseMetaData.java:1855)
	at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.ta
ble.ColumnsTab.createDataSet(ColumnsTab.java:69)
	at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Ba
seDataSetTab$1.run(BaseDataSetTab.java:123)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:
82)
	at java.lang.Thread.run(Thread.java:595)

Re: [Squirrel-sql-users] Can't even install Squirrel-2.4 if JAVA_HOME not set to Java 5

[Robert M. <rob...@gm...>]

On 1/13/07, Karr, David <dav...@wa...> wrote:
> Squirrel-2.4 requires Java 5.  That's fine.  However, it should be
> understood that there will be a transition period where people are using
> both JDK 1.4.2 and Java 5, and they require JDK 1.4.2 for their main
> work, but use Java 5 for some tools.  Eclipse works very well this way.
> My JAVA_HOME is set for JDK 1.4.2, and I specify the Java 5 runtime on
> the Eclipse command line.  I can't even install Squirrel-2.4, much less
> use it, even though I have Java 5 installed.

The installer can be run from the command-line using any java 5 or 6
JRE.  It isn't necessary for the JAVA_HOME environment variable to be
set to run the installer.  However, you are correct in that the script
to Launch SQuirreL will use the version specified by JAVA_HOME.
If you run some java apps that also use JAVA_HOME but require < 1.5,
then you can simply put a line in squirrel-sql.bat near the top that
sets JAVA_HOME to 1.5+ jvm.  Java 6 is now available and SQuirreL 2.4
works with BOTH Java 5 & 6.  Maybe we shouldn't be transitioning from
1.4 -> 1.5, but rather 1.5 -> 1.6 :)

>
> The installer should be changed to prompt the user for a Java 5 runtime
> directory path, if JAVA_HOME doesn't point to one.  From that, the run
> scripts should use that Java 5 runtime.

That's an enhancement that's been discussed.  The original installer
did ship with a panel to let you choose, but it required a JDK - a JRE
wasn't sufficient.  So we removed it.  We may have time to address it
for 2.5

Rob

[Squirrel-sql-users] Can't even install Squirrel-2.4 if JAVA_HOME not set to Java 5

[Karr, D. <dav...@wa...>]

I filed a bug about this, but I figured I'd write a note about this here
also.

Squirrel-2.4 requires Java 5.  That's fine.  However, it should be
understood that there will be a transition period where people are using
both JDK 1.4.2 and Java 5, and they require JDK 1.4.2 for their main
work, but use Java 5 for some tools.  Eclipse works very well this way.
My JAVA_HOME is set for JDK 1.4.2, and I specify the Java 5 runtime on
the Eclipse command line.  I can't even install Squirrel-2.4, much less
use it, even though I have Java 5 installed.

The installer should be changed to prompt the user for a Java 5 runtime
directory path, if JAVA_HOME doesn't point to one.  From that, the run
scripts should use that Java 5 runtime.

[Squirrel-sql-users] Missing double quotes for field names

[Michael F. <mic...@be...>]

DQpJIGFtIHVzaW5nIERCMiBvbiB6L09TIHdpdGggZmllbGQgbmFtZXMgKGFsc28ga2V5cykgY29u
dGFpbmluZyBkYXNoZXMuDQpJLkUuOiDigJxBQkMtREVGLUdISeKAnQ0KDQpJZiBJIHVzZSBhIGZp
bHRlciBJIGFtIGFibGUgdG8gYWRkIHRoZSByZXF1aXJlZCBkb3VibGUgcXVvdGVzIGZvciBmaWVs
ZA0KbmFtZXMgbWFudWFsbHkgaW4gdGhlIGVkaXQgd2luZG93Lg0KSS5FLjogIkFCQy1ERUYtR0hJ
IiA9ICdYWVonDQoNCk9uIHVwZGF0ZXMgdG8gYSByb3cgdGhlIGRvdWJsZSBxdW90ZXMgYXJlIG1p
c3NpbmcgYW5kIEkgZ290IGEgU1FMIGVycm9yLg0KDQpIYXMgYW55IGJvZHkgYSB0aXAgaG93IHRv
IHNvbHZlIHRoaXMgd2l0aG91dCBjaGFuZ2luZyB0aGUgZmllbGQgbmFtZXM/DQoNClRoYW5rcw0K
DQoNCg0KW1RoaXMgbWVzc2FnZSBpcyBjb25maWRlbnRpYWwuIEl0IG1heSBhbHNvIGJlIHByaXZp
bGVnZWQgb3Igb3RoZXJ3aXNlDQpwcm90ZWN0ZWQgYnkgd29yayBwcm9kdWN0IGltbXVuaXR5IG9y
IG90aGVyIGxlZ2FsIHJ1bGVzLiBJZiB5b3UgaGF2ZQ0KcmVjZWl2ZWQgaXQgYnkgbWlzdGFrZSBw
bGVhc2UgbGV0IHVzIGtub3cgYnkgcmVwbHkgYW5kIHRoZW4gZGVsZXRlIGl0IGZyb20NCnlvdXIg
c3lzdGVtOyB5b3Ugc2hvdWxkIG5vdCBjb3B5IGl0IG9yIGRpc2Nsb3NlIGl0cyBjb250ZW50cyB0
byBhbnlvbmUuIEFsbA0KbWVzc2FnZXMgc2VudCB0byBhbmQgZnJvbSBCZXRhIFN5c3RlbXMgbWF5
IGJlIG1vbml0b3JlZCB0byBlbnN1cmUNCmNvbXBsaWFuY2Ugd2l0aCBpbnRlcm5hbCBwb2xpY2ll
cyBhbmQgdG8gcHJvdGVjdCBvdXIgYnVzaW5lc3MuIEVtYWlscyBhcmUNCm5vdCBzZWN1cmUgYW5k
IGNhbm5vdCBiZSBndWFyYW50ZWVkIHRvIGJlIGVycm9yIGZyZWUgYXMgdGhleSBjYW4gYmUNCmlu
dGVyY2VwdGVkLCBhbWVuZGVkLCBsb3N0IG9yIGRlc3Ryb3llZCwgb3IgY29udGFpbiB2aXJ1c2Vz
LiBBbnlvbmUgd2hvDQpjb21tdW5pY2F0ZXMgd2l0aCB1cyBieSBlbWFpbCBpcyB0YWtlbiB0byBh
Y2NlcHQgdGhlc2Ugcmlza3MuXQ==

Re: [Squirrel-sql-users] loading schemas on squirrel startup

[Colin B. <co...@ba...>]

On Thu, Jan 11, 2007 at 10:24:58AM -0700, Mark Neher wrote:
> When I started using Squirrel in 2004, a session would start up and 
> load/list all schemas for a DB instance into the leftmost panel of the 
> object tree screen.  Somewhere along the way, later versions began loading 
> (or displaying, anyway) only the schema corresponding to the username.  This 
> was better for me, as there are hundreds of schemas on our Oracle 
> development instance.  I installed Squirrel 2.4 today, and it is back to the 
> original behavior.
> 
> Is there any way to configure this, or a known reason why this has changed 
> ??  I have played with the load schemas and filter options in the new 
> session properties panel, but they don't do what I would have expected and I 
> haven't been able to get the previous behavior.

When you installed 2.4 did you install the Oracle plugin?

-- 
Colin Bell

Re: [Squirrel-sql-users] Linux Installation

[Colin B. <co...@ba...>]

On Mon, Jan 08, 2007 at 11:34:39AM -0800, Andrew Melton wrote:
> Whenever I launch squirrel-sql.sh, I get a blank squirrel 2.4 window.  There
> is a title bar to the window with the acorn icon and "SQuirrel SQL Client
> Version 2.4" written in the title bar.  But, there is nothing else.
> The first time I run the program, a help window appears as well, but it is
> gone on subsequent instances.
> 
> I am running Squirrel 2.4 with FC6 and java version "1.5.0_10"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_10-b03)
> Java HotSpot(TM) Client VM (build 1.5.0_10-b03, mixed mode, sharing)
> 
> Even before trying to register/configure a driver, should I not see program
> options in the main window?  I read the archives, and saw a problem with
> Java 6 which sounded similar.  I had been using 6 as well, so I downgraded
> to 5.  That didn't seem to help, but I'm wondering whether that could still
> be contributing.

Could be your video drivers.

Could be this Java bug
<http://bugs.sun.com/bugdatabase/view_bug.do;jsessionid=dcb5b73ca8dc9ffffffffcd4efff679200cb:WuuT?bug_id=6429775>

What happens when you take menu options?

-- 
Colin Bell

Re: [Squirrel-sql-users] loading schemas on squirrel startup

[Robert M. <rob...@gm...>]

On 1/11/07, Mark Neher <mar...@ho...> wrote:
> Hi All,
>
> When I started using Squirrel in 2004, a session would start up and
> load/list all schemas for a DB instance into the leftmost panel of the
> object tree screen.  Somewhere along the way, later versions began loading
> (or displaying, anyway) only the schema corresponding to the username.  This
> was better for me, as there are hundreds of schemas on our Oracle
> development instance.  I installed Squirrel 2.4 today, and it is back to the
> original behavior.
>
> Is there any way to configure this, or a known reason why this has changed
> ??  I have played with the load schemas and filter options in the new
> session properties panel, but they don't do what I would have expected and I
> haven't been able to get the previous behavior.

I think you will be pleasantly surprised.  Although the original
behavior is there by default, you now have the ability to choose which
schemas get loaded on startup. See Alias Properties when you right
click on the alias.  Let me know if anything is unclear.

Rob

[Squirrel-sql-users] loading schemas on squirrel startup

[Mark N. <mar...@ho...>]

Hi All,

When I started using Squirrel in 2004, a session would start up and 
load/list all schemas for a DB instance into the leftmost panel of the 
object tree screen.  Somewhere along the way, later versions began loading 
(or displaying, anyway) only the schema corresponding to the username.  This 
was better for me, as there are hundreds of schemas on our Oracle 
development instance.  I installed Squirrel 2.4 today, and it is back to the 
original behavior.

Is there any way to configure this, or a known reason why this has changed 
??  I have played with the load schemas and filter options in the new 
session properties panel, but they don't do what I would have expected and I 
haven't been able to get the previous behavior.

Thanks,

Mark

_________________________________________________________________
>From photos to predictions, The MSN Entertainment Guide to Golden Globes has 
it all. http://tv.msn.com/tv/globes2007/?icid=nctagline1

[Squirrel-sql-users] Displaying Oracle TIMESTAMPTZ columns

[John B. <Joh...@is...>]

I'm using v2.4, running on Linux w/JDK 1.5 to access an Oracle 9i databas=
e
that has TIMESTAMPTZ columns (declared as "TIMESTAMP WITH TIME ZONE"). Th=
e
results page, however, shows any of these column values as
"<Unknown(-101)>".

When I look at the metadata for the query, the getColumnType is returning
-101 for these, and getColumnTypeName is returning "TIMESTAMPTZ".

I installed the Oracle plugin with SQuirrel SQL, and am using the Oracle
Thin driver for 10g (oracle-jdbc-thin-10.1.0.2-g.jar), the same driver we
are using in our application code to go against this database. I've tried
changing the Global Preferences settings for "Data Type Controls" for the
Timestamp fields, but none seem to have any effect.

Any tips or clues appreciated.
John