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

Re: [Squirrel-sql-users] Updating default_drivers.xml to include Apache Derby drivers

[Susan C. <hom...@ya...>]

Thanks Gerd!
 
Most appreciated.
 
Susan

Gerd Wagner <bir...@t-...> wrote:
Hi Susan,

is in CVS. Thanks for your contribution.

Gerd


Susan Cline schrieb:
> Hi,
> 
> I've modified the file
> 
> net\sourceforge\squirrel_sql\client\resources\defaults\default_drivers.xml
> 
> with these additional entries:
> 
> 
> org.apache.derby.jdbc.ClientDriver
> 
> -31
> 
> 
> Apache Derby Client
> 
> jdbc:derby://<server>[:<port>]/<databaseName>[;<URL 
> attribute>=<value>]
> 
> 
> 
> 
> org.apache.derby.jdbc.EmbeddedDriver
> 
> -30
> 
> 
> Apache Derby Embedded
> jdbc:derby:<database>[;create=true]
> 
> 
> to make the Apache Derby drivers appear in the Default Driver Definition 
> List.
> 
> I'd like to request that this file be updated in CVS so all SQuirreL 
> users can see the Derby drivers on this list. Both the Derby Client and 
> Embedded Drivers work with SQuirreL.
> 
> If I need to request this another way, please let me know.
> 
> (Sorry if this is a double post ... the first time I posted I used an 
> incorrect email address
> and the duplicate message may be stuck in a moderation queue.)
> 
> Thanks,
> 
> Susan



-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Updating default_drivers.xml to include Apache Derby drivers

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

Hi Susan,

is in CVS. Thanks for your contribution.

Gerd


Susan Cline schrieb:
> Hi,
>  
> I've modified the file
> 
> net\sourceforge\squirrel_sql\client\resources\defaults\default_drivers.xml
>  
> with these additional entries:
>  
>    <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
>        <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName>
>        <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
>            <string>-31</string>
>        </identifier>
>        <jarFileNames Indexed="true"/>
>        <name>Apache Derby Client</name>
>        
> <url>jdbc:derby://&lt;server&gt;[:&lt;port&gt;]/&lt;databaseName&gt;[;&lt;URL 
> attribute&gt;=&lt;value&gt;]</url>
>    </Bean>
>  
>    <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
>        
> <driverClassName>org.apache.derby.jdbc.EmbeddedDriver</driverClassName>
>        <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
>            <string>-30</string>
>        </identifier>
>        <jarFileNames Indexed="true"/>
>        <name>Apache Derby Embedded</name>
>        <url>jdbc:derby:&lt;database&gt;[;create=true]</url>
>    </Bean>
>  
> to make the Apache Derby drivers appear in the Default Driver Definition 
> List.
>  
> I'd like to request that this file be updated in CVS so all SQuirreL 
> users can see the Derby drivers on this list.  Both the Derby Client and 
> Embedded Drivers work with SQuirreL.
>  
> If I need to request this another way, please let me know.
>  
> (Sorry if this is a double post ... the first time I posted I used an 
> incorrect email address
> and the duplicate message may be stuck in a moderation queue.)
>  
> Thanks,
>  
> Susan

[Squirrel-sql-users] Updating default_drivers.xml to include Apache Derby drivers

[Susan C. <hom...@ya...>]

Hi,
 
I've modified the file 

net\sourceforge\squirrel_sql\client\resources\defaults\default_drivers.xml 
 
with these additional entries:
 
   <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
       <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName>
       <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
           <string>-31</string>
       </identifier>
       <jarFileNames Indexed="true"/>
       <name>Apache Derby Client</name>
       <url>jdbc:derby://&lt;server&gt;[:&lt;port&gt;]/&lt;databaseName&gt;[;&lt;URL attribute&gt;=&lt;value&gt;]</url>
   </Bean>
 
   <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
       <driverClassName>org.apache.derby.jdbc.EmbeddedDriver</driverClassName>
       <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
           <string>-30</string>
       </identifier>
       <jarFileNames Indexed="true"/>
       <name>Apache Derby Embedded</name>
       <url>jdbc:derby:&lt;database&gt;[;create=true]</url>
   </Bean>
 
to make the Apache Derby drivers appear in the Default Driver Definition List.
 
I'd like to request that this file be updated in CVS so all SQuirreL users can see the Derby drivers on this list.  Both the Derby Client and Embedded Drivers work with SQuirreL.
 
If I need to request this another way, please let me know.
 
(Sorry if this is a double post ... the first time I posted I used an incorrect email address
and the duplicate message may be stuck in a moderation queue.)

 
Thanks,
 
Susan

Re: [Squirrel-sql-users] No connection to mysql

[Benedick M. <ben...@ya...>]

On Sun, 2005-09-18 at 15:27 -0400, Rob Manning wrote:
> Benedick Miller wrote:
> 
> > Hello
> >
> > I have just installed Squirrel 2.0 final
> > and Java (j2re1.5-sun)
> > and Jdbc Drivers: mysql-connector-java-3.1.10-bin.jar (from MySQL AB)
> > on a machine running Ubuntu Linux "Hoary"
> >
> > After all this work (!) i cannot connect to the mysql server.
> >
> > My Alias (using either MySQL or MMMySQL driver, I have tried both) 
> > looks like this:
> >
> > jdbc:mysql://localhost:3306/contact_list
> >
> > Is there something wrong there?
> >
> > Should I be using MySQL or MMMySQL driver?
> > What is the difference?
> 
>  From the README I appear to be using
> 
> MySQL Connector/J 3.1.8 (formerly MM.MySQL)
> MySQL AB's JDBC Driver for MySQL
> 
> to connect to MySQL 4.1.11.  Not sure about the difference between the 
> drivers.
> I do know that MySQL requires you to grant privilege to the user
> before connecting to the database.  Does the user you are attempting to 
> login as
> have privilege to access your "contact_list" database in the MySQL server?
> What error message are you seeing?
> 
> Rob Manning
> 

I am logging in as the MySQL administrator which works fine from a
terminal. So I don't think user-name / password is the problem.

Here is the error message:

Last packet sent to the server was 20 ms ago.

Here is the "stack Trace" output:

com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
	at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
	at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
	at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:193)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:367)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 20 ms ago.
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2607)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
	at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
	at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:193)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:367)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Unknown Source)


Does this mean anything to anyone? ;-) Sorry I know nothing about how
java programs work. Please excuse if I am making a simple error.

Re: [Squirrel-sql-users] Firebird

[Wolfgang K. <wk...@kb...>]

Thanks for the message.

Now it becomes clear that we are talking about different drivers.
The Jaybird-2.0.0RC1 driver does not contain firebirdsql.jar.
So I went back to the driver FirebirdSQL-1.0.0.zip and there is no 
problem with this driver.

Regards

Wolfgang Kluge



Rob Manning wrote:

> Wolfgang Kluge wrote:
>
>> Thanks for the reply.
>>
>> I tried your suggestion  - and I still get the error message "Check 
>> your URL".
>> I then tried all the possible variations of / and \  with the same 
>> result.
>> Then I tried all the suggestions given by the driver example in the 
>> JayBird driver with the same result.
>>
>> I simply have no clue where I messed up the system and the fact, that 
>> I am new to java programming also is of not much help.
>>
>> Do you have any suggestions where I should look for the wrong 
>> setting/parameter.....?
>
>
> Look very closely at this part of the URL:
>
> jdbc:firebirdsql
>
> Additionally, for your driver definition you chose 
> "org.firebirdsql.jdbc.FBDriver" as the class name, right?
>
> And included the jars firebirdsql.jar and mini-j2ee.jar in the 
> classpath, yes ? (In the "Extra Class Path"
> tab)
>
> Rob
>
>
>
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
>
>
>
>
>



-- 
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/

Re: [Squirrel-sql-users] No connection to mysql

[Rob M. <Rob...@co...>]

Benedick Miller wrote:

> Hello
>
> I have just installed Squirrel 2.0 final
> and Java (j2re1.5-sun)
> and Jdbc Drivers: mysql-connector-java-3.1.10-bin.jar (from MySQL AB)
> on a machine running Ubuntu Linux "Hoary"
>
> After all this work (!) i cannot connect to the mysql server.
>
> My Alias (using either MySQL or MMMySQL driver, I have tried both) 
> looks like this:
>
> jdbc:mysql://localhost:3306/contact_list
>
> Is there something wrong there?
>
> Should I be using MySQL or MMMySQL driver?
> What is the difference?

 From the README I appear to be using

MySQL Connector/J 3.1.8 (formerly MM.MySQL)
MySQL AB's JDBC Driver for MySQL

to connect to MySQL 4.1.11.  Not sure about the difference between the 
drivers.
I do know that MySQL requires you to grant privilege to the user
before connecting to the database.  Does the user you are attempting to 
login as
have privilege to access your "contact_list" database in the MySQL server?
What error message are you seeing?

Rob Manning


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

[Squirrel-sql-users] No connection to mysql

[Benedick M. <ben...@ya...>]

Hello

I have just installed Squirrel 2.0 final
and Java (j2re1.5-sun)
and Jdbc Drivers: mysql-connector-java-3.1.10-bin.jar (from MySQL AB)
on a machine running Ubuntu Linux "Hoary"

After all this work (!) i cannot connect to the mysql server.

My Alias (using either MySQL or MMMySQL driver, I have tried both) looks 
like this:

jdbc:mysql://localhost:3306/contact_list

Is there something wrong there?

Should I be using MySQL or MMMySQL driver?
What is the difference?

I can connect to mysql on port 3306 fine from the command line.
I have no idea what the problem is. Any help much appreciated.

Ben
--
...Shall we their fond pageant see?
Lord what fools these mortals be!

Re: [Squirrel-sql-users] Firebird

[Rob M. <Rob...@co...>]

Wolfgang Kluge wrote:

> Thanks for the reply.
>
> I tried your suggestion  - and I still get the error message "Check 
> your URL".
> I then tried all the possible variations of / and \  with the same 
> result.
> Then I tried all the suggestions given by the driver example in the 
> JayBird driver with the same result.
>
> I simply have no clue where I messed up the system and the fact, that 
> I am new to java programming also is of not much help.
>
> Do you have any suggestions where I should look for the wrong 
> setting/parameter.....?

Look very closely at this part of the URL:

jdbc:firebirdsql

Additionally, for your driver definition you chose 
"org.firebirdsql.jdbc.FBDriver" as the class name, right?

And included the jars firebirdsql.jar and mini-j2ee.jar in the 
classpath, yes ? (In the "Extra Class Path"
tab)

Rob



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

Re: [Squirrel-sql-users] Firebird

[Wolfgang K. <wk...@kb...>]

Thanks for the reply.

I tried your suggestion  - and I still get the error message "Check your 
URL".
I then tried all the possible variations of / and \  with the same result.
Then I tried all the suggestions given by the driver example in the 
JayBird driver with the same result.

I simply have no clue where I messed up the system and the fact, that I 
am new to java programming also is of not much help.

Do you have any suggestions where I should look for the wrong 
setting/parameter.....?

Regards

Wolfgang Kluge



Rob Manning wrote:

> Wolfgang Kluge wrote:
>
>> Good evening.
>> I will appreciate any help in using Squirrel-SQL on a Win2000 machine 
>> to access a local Firebird 1.5.2 database.
>>
>> I have installed Jaybird-2.0.0RC1
>> The driver is loaded in Squirrel but I always get the error message 
>> "Check your URL".
>>
>> What is the correct syntax for the URL?
>> The database is located at d:\fbdata\frontdesk.fdb
>> and the firebird alias.conf lists the alias Frontdesk for this database
>
>
> My connect url looks like this:
>
> jdbc:firebirdsql://localhost/c:\tools\FIREBIRD_1_5\data\dbcopy.fdb
>
> So, I'm going to guess that yours would be
>
> jdbc:firebirdsql://localhost/d:\fbdata\frontdesk.fdb
>
> Rob
>
>
> CollabraSpace - Revolutionary Collaboration
> Visit us at http://www.collabraspace.com
> This message has been scanned for viruses by
> ClamAV v0.83
>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. 
> Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>



-- 
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/

Re: [Squirrel-sql-users] Firebird

[Rob M. <Rob...@co...>]

Wolfgang Kluge wrote:

> Good evening.
> I will appreciate any help in using Squirrel-SQL on a Win2000 machine 
> to access a local Firebird 1.5.2 database.
>
> I have installed Jaybird-2.0.0RC1
> The driver is loaded in Squirrel but I always get the error message 
> "Check your URL".
>
> What is the correct syntax for the URL?
> The database is located at d:\fbdata\frontdesk.fdb
> and the firebird alias.conf lists the alias Frontdesk for this database

My connect url looks like this:

jdbc:firebirdsql://localhost/c:\tools\FIREBIRD_1_5\data\dbcopy.fdb

So, I'm going to guess that yours would be

jdbc:firebirdsql://localhost/d:\fbdata\frontdesk.fdb

Rob


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

[Squirrel-sql-users] Firebird

[Wolfgang K. <wk...@kb...>]

Good evening.
I will appreciate any help in using Squirrel-SQL on a Win2000 machine to 
access a local Firebird 1.5.2 database.

I have installed Jaybird-2.0.0RC1
The driver is loaded in Squirrel but I always get the error message 
"Check your URL".

What is the correct syntax for the URL?
The database is located at d:\fbdata\frontdesk.fdb
and the firebird alias.conf lists the alias Frontdesk for this database

Regards
Wolfgang Kluge



-- 
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/

[Squirrel-sql-users] Firebird

[<wk...@tm...>]

Good evening.
I will appreciate any help in using Squirrel-SQL on a Win2000 machine to access a local Firebird 1.5.2 database.

I have installed Jaybird-2.0.0RC1 
The driver is loaded in Squirrel but I always get the error message "Check your URL".

What is the correct syntax for the URL?
The database is located at d:\fbdata\frontdesk.fdb
and the firebird alias.conf lists the alias Frontdesk for this database

Regards
Wolfgang Kluge

Re: [Squirrel-sql-users] SQLBookmark 1.0 - How to activate the default bookmarks

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

Hi Karim,

Karim D. Saloojee wrote:
 > Hi Gerd
 >
 > Thanks, I found the registry key, removed it and now the bookmarks are
 > displaying correctly.
 >
 > I just have a question on development of Java GUI's on multiple
 > platforms. Why did you use the home folder on *NIX and the registry on
 > Windows? Considering that you do already make use of the home folder on
 > Windows for other things like plugins etc. Is there a problem with how
 > Windows treats the home folder vs *NIX? Or did you try and make the
 > application use all of the features that were provided by the host OS?
For more complex configuration data we use Java Beans together with an 
XML-Serialization framework. For those SQuirreL itself determines the 
place to write the data to which is always the users home directory. For 
little things we sometimes spare us the Java Beans and use the standard 
Java Preference API and this is the one that uses the home directory on 
*NIX and the registry on Windows. A Java programmer only sees the 
Preference-API he doesn't need to know anything about where the data is 
actually stored.

Gerd

Re: [Squirrel-sql-users] SQLBookmark 1.0 - How to activate the default bookmarks

[Karim D. S. <ka...@ab...>]

Hi Gerd

Thanks, I found the registry key, removed it and now the bookmarks are 
displaying correctly.

I just have a question on development of Java GUI's on multiple 
platforms. Why did you use the home folder on *NIX and the registry on 
Windows? Considering that you do already make use of the home folder on 
Windows for other things like plugins etc. Is there a problem with how 
Windows treats the home folder vs *NIX? Or did you try and make the 
application use all of the features that were provided by the host OS?

Regards,
Karim


Gerd Wagner wrote:

> Hi Karim,
>
> Karim D. Saloojee wrote:
> > Hi
> >
> > I cannot get the SQL Bookmarks pop-up to open. If I create 2 or more
> > bookmarks I can get the pop-up to display (ctrl-j) but the default
> > bookmarks like:
> > crtab,
> > addcol,
> > crix
> >
> > are missing. Do I have to activate some option somewhere? I could not
> > find anything in the documentation.
> Normally the default bookmarks are created when version 1.0 of the 
> Bookmark plugin is used for the first time. When the bookmarks are 
> created a message is displayed in the message panel. SQuirreL looks 
> for a preferences key to decide whether the bookmarks should be created.
>
> On Linux the preferences are usually stored in:
> <user home>.java/.userPrefs/prefs.xml.
> The entry key is:
> <entry key="Squirrel.sqlbookmark.defaultbookmarksloaded" value="true" />
>
> On Windows there will be an according Registry key.
>
> You may just remove the key to make SQuirreL create the bookmarks again.
>
> I admit that buttons to add and remove the default bookmarks would be 
> helpful. Maybe they'll be introduced in  2.1
>
> Gerd
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing 
> & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

___________________________________________________________

Important Notice:
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to dis...@ab... and we will send you a copy of the 
Disclaimer.

Re: [Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

[Karim D. S. <ka...@ab...>]

Hi Gerd

> But you should still see query results when you use the latest 
> SQuirreL snapshot, don't you? 

Yes, the weekly snapshot does display the query results.

Regards,
Karim


Gerd Wagner wrote:

> Hi Karim,
>
> unfortunately what you see here is a follow up error that occurred 
> while writing the log. This bug is fixed in CVS and will be available 
> with the next snapshot. Nonetheless from the second part of the 
> stacktrace I could see where the original error was raised. It is the 
> place where SQuirreL tries to close the result set.
>
> Though I haven't got the driver's error message itself it is very 
> probable that your driver closes a result set when it fully is 
> iterated through. That is, as I assumed, the same problem we had with 
> the Derby DB. We can't do anything about it. It's a problem of the 
> driver. But you should still see query results when you use the latest 
> SQuirreL snapshot, don't you?
>
> Gerd
>
> Karim D. Saloojee wrote:
>
>> Hi Gerd
>>
>> Unfortuneately I cannot use the NET driver in our environment. Its 
>> just that out environment is very peculiar and that is not really an 
>> option. I will get a hold of the latest weekly build. Here is the 
>> stack trace you asked for:
>>
>> 109570 [Thread-3] ERROR 
>> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet  - Error 
>> positioning caret in log text component
>> javax.swing.text.BadLocationException: Can't translate offset to line
>>    at javax.swing.JTextArea.getLineOfOffset(JTextArea.java:353)
>>    at 
>> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.refreshLog(ViewLogsSheet.java:281) 
>>
>>    at 
>> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.access$700(ViewLogsSheet.java:58) 
>>
>>    at 
>> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet$Refresher.run(ViewLogsSheet.java:421) 
>>
>>    at 
>> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) 
>>
>>    at java.lang.Thread.run(Thread.java:536)
>> 116304 [Thread-2] ERROR 
>> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask  
>> - Error occured executing SQL
>> java.lang.StringIndexOutOfBoundsException: String index out of range: 
>> -35
>>    at java.lang.String.substring(String.java:1480)
>>    at 
>> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.processQuery(SQLExecuterTask.java:429) 
>>
>>    at 
>> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.run(SQLExecuterTask.java:238) 
>>
>>    at 
>> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) 
>>
>>    at java.lang.Thread.run(Thread.java:536)
>>
>> TIA
>>
>> Regards,
>> Karim
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing 
> & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

___________________________________________________________

Important Notice:
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to dis...@ab... and we will send you a copy of the 
Disclaimer.

Re: [Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

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

Hi Karim,

unfortunately what you see here is a follow up error that occurred while 
writing the log. This bug is fixed in CVS and will be available with the 
next snapshot. Nonetheless from the second part of the stacktrace I 
could see where the original error was raised. It is the place where 
SQuirreL tries to close the result set.

Though I haven't got the driver's error message itself it is very 
probable that your driver closes a result set when it fully is iterated 
through. That is, as I assumed, the same problem we had with the Derby 
DB. We can't do anything about it. It's a problem of the driver. But you 
should still see query results when you use the latest SQuirreL 
snapshot, don't you?

Gerd

Karim D. Saloojee wrote:
> Hi Gerd
> 
> Unfortuneately I cannot use the NET driver in our environment. Its just 
> that out environment is very peculiar and that is not really an option. 
> I will get a hold of the latest weekly build. Here is the stack trace 
> you asked for:
> 
> 109570 [Thread-3] ERROR 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet  - Error 
> positioning caret in log text component
> javax.swing.text.BadLocationException: Can't translate offset to line
>    at javax.swing.JTextArea.getLineOfOffset(JTextArea.java:353)
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.refreshLog(ViewLogsSheet.java:281) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.access$700(ViewLogsSheet.java:58) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet$Refresher.run(ViewLogsSheet.java:421) 
> 
>    at 
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>    at java.lang.Thread.run(Thread.java:536)
> 116304 [Thread-2] ERROR 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask  - 
> Error occured executing SQL
> java.lang.StringIndexOutOfBoundsException: String index out of range: -35
>    at java.lang.String.substring(String.java:1480)
>    at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.processQuery(SQLExecuterTask.java:429) 
> 
>    at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.run(SQLExecuterTask.java:238) 
> 
>    at 
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>    at java.lang.Thread.run(Thread.java:536)
> 
> TIA
> 
> Regards,
> Karim

Re: [Squirrel-sql-users] SQLBookmark 1.0 - How to activate the default bookmarks

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

Hi Karim,

Karim D. Saloojee wrote:
 > Hi
 >
 > I cannot get the SQL Bookmarks pop-up to open. If I create 2 or more
 > bookmarks I can get the pop-up to display (ctrl-j) but the default
 > bookmarks like:
 > crtab,
 > addcol,
 > crix
 >
 > are missing. Do I have to activate some option somewhere? I could not
 > find anything in the documentation.
Normally the default bookmarks are created when version 1.0 of the 
Bookmark plugin is used for the first time. When the bookmarks are 
created a message is displayed in the message panel. SQuirreL looks for 
a preferences key to decide whether the bookmarks should be created.

On Linux the preferences are usually stored in:
<user home>.java/.userPrefs/prefs.xml.
The entry key is:
<entry key="Squirrel.sqlbookmark.defaultbookmarksloaded" value="true" />

On Windows there will be an according Registry key.

You may just remove the key to make SQuirreL create the bookmarks again.

I admit that buttons to add and remove the default bookmarks would be 
helpful. Maybe they'll be introduced in  2.1

Gerd

[Squirrel-sql-users] SQLBookmark 1.0 - How to activate the default bookmarks

[Karim D. S. <ka...@ab...>]

Hi

I cannot get the SQL Bookmarks pop-up to open. If I create 2 or more 
bookmarks I can get the pop-up to display (ctrl-j) but the default 
bookmarks like:
crtab,
addcol,
crix

are missing. Do I have to activate some option somewhere? I could not 
find anything in the documentation.

Regards,
Karim

___________________________________________________________

Important Notice:
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to dis...@ab... and we will send you a copy of the 
Disclaimer.

Re: [Squirrel-sql-users] Re: oracle plugin with 2.0rc1

[Fabrice G. <Fab...@hc...>]

Thank's a lot Rob !
Your issue works perfectly with SQuirreL 2.0RC1 !!
You confirm the splendid way to work with open-source.
Thank's again for the light you give us.

Fabrice.



Fabrice Gonnon

Responsable Groupe Qualit=E9-Outils-M=E9thodes

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

H=F4pitaux Universitaires de Gen=E8ve
Direction d' informatique de gestion (DIG)
24, rue Micheli-du-Crest
CH 1211 GENEVE 14

Tel: +41.22.372.61.74
Bal: fab...@hc...

>>> Rob Manning <Rob...@co...> 12.08.05 19:57:04 >>>
Rob Manning wrote:

>
> Which makes me wonder - are you using SQuirreL 2.0RC1 ?  If so then=20
> you should make sure
> you get oracle-0.13-for-2.0.zip from here:
>
> http://sourceforge.net/project/showfiles.php?group_id=3D28383&package_id=
=3D64864&release_id=3D246228=20
>
>
> I just installed it and it seems to work without exception for me.

Just a follow up to this discussion.  I discovered that using the=20
oracle-0.13-for-2.0.zip (which was published in
June 2005) with 2.0RC1 produces the issue that others have noted in this=20
list (Oracle Session window - object tree /
SQL worksheet doesn't appear when attempting to connect to Oracle - when=20
the plugin is installed).  I built the
Oracle Plugin using the latest code on the trunk and the problem appears=20
to have been resolved by some change
made since June.  So, I plan to update the snapshots section of the=20
downloads page with updated versions of these
plugins.=20

Rob Manning


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




-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf=
 _______________________________________________
Squirrel-sql-users mailing list
Squ...@li...=20
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

**********************************************************************

[Squirrel-sql-users] Re: =?ISO-8859-1?Q?R=E9p=2E_=3A_Re=3A_=5BSquirrel-sql-user?= =?ISO-8859-1?Q?s=5D_Re=3A_oracle_plugin_with_2=2E0rc1?=

[Rob M. <Rob...@co...>]

Hari Krishna Dara wrote:

>Thanks a lot. The attached plugin seems to work perfectly. I can now
>see the stored procedure text too.
>  
>
All,

I've updated all of the "for-2.0" files in the "develop" plugins module 
on SourceForge with a fresh
build from the trunk.  Most notably, the Oracle plugin (v0.13) should 
fix the issue seen when using
2.0RC1 or the snapshots with regard to not being able to see the SQL 
worksheet.  You *may*
find changes in the other plugins in their respective "changes.txt" 
document - although, I don't believe
any major enhancements have been added in the last couple of months.  
That being the case, I've
kept the version number the same for all plugins. However, I've tagged 
each of the vendor-specific
plugins with a CVS tag that reflects their individual version, so it 
should be simple in the future to
determine exactly which files have changed since the last release.

Rob Manning



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

Re: [Squirrel-sql-users] SQuirreL-SQL and Oracle versions

[Rob M. <Rob...@co...>]

Rob Manning wrote:

> Stefan Stonjek wrote:
>
>> Hello Rob,
>>
>> network can't be the issue here.
>> If I am using the Oracle 9.2... JDBC drivers everything works well. 
>> But if
>> I switch to Oracle 10.1... JDBC drivers I get the error. This 
>> behavior is
>> reproducible by switching between the different versions of
>> "classes12.jar". This is true for an Oracle 9.2... database.
>>
>> I just found that everything works well with the 10.1... JDBC drivers 
>> if one connects to a 10.1... database.....
>>
>> This should not happen. According to Oracle client and database can 
>> interact if the difference in the major release number is not bigger 
>> than one.
>>  
>>
> Yes, I've heard that too somewhere before.  I don't have access to a 
> 10g database, or else I'd test
> it myself.  Very interesting result you are seeing (10g driver can't 
> talk to a 9i server).

Actually, I just recently upgraded my JDBC driver to 10g. (There was a 
bug that I was tripping over in the
9i driver when talking to a 9i database server.)  Believe it or not, the 
10g driver works well with the 9i database.
In fact, it solved the problem I was having with the 9i driver as well.

Rob


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

Re: [Squirrel-sql-users] Re: oracle plugin with 2.0rc1

[Rob M. <Rob...@co...>]

Rob Manning wrote:

>
> Which makes me wonder - are you using SQuirreL 2.0RC1 ?  If so then 
> you should make sure
> you get oracle-0.13-for-2.0.zip from here:
>
> http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=64864&release_id=246228 
>
>
> I just installed it and it seems to work without exception for me.

Just a follow up to this discussion.  I discovered that using the 
oracle-0.13-for-2.0.zip (which was published in
June 2005) with 2.0RC1 produces the issue that others have noted in this 
list (Oracle Session window - object tree /
SQL worksheet doesn't appear when attempting to connect to Oracle - when 
the plugin is installed).  I built the
Oracle Plugin using the latest code on the trunk and the problem appears 
to have been resolved by some change
made since June.  So, I plan to update the snapshots section of the 
downloads page with updated versions of these
plugins. 

Rob Manning


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

Re: [Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

[Karim D. S. <ka...@ab...>]

Hi Gerd

Unfortuneately I cannot use the NET driver in our environment. Its just 
that out environment is very peculiar and that is not really an option. 
I will get a hold of the latest weekly build. Here is the stack trace 
you asked for:

109570 [Thread-3] ERROR 
net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet  - Error 
positioning caret in log text component
javax.swing.text.BadLocationException: Can't translate offset to line
    at javax.swing.JTextArea.getLineOfOffset(JTextArea.java:353)
    at 
net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.refreshLog(ViewLogsSheet.java:281)
    at 
net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet.access$700(ViewLogsSheet.java:58)
    at 
net.sourceforge.squirrel_sql.client.gui.ViewLogsSheet$Refresher.run(ViewLogsSheet.java:421)
    at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:536)
116304 [Thread-2] ERROR 
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask  - 
Error occured executing SQL
java.lang.StringIndexOutOfBoundsException: String index out of range: -35
    at java.lang.String.substring(String.java:1480)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.processQuery(SQLExecuterTask.java:429)
    at 
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecuterTask.run(SQLExecuterTask.java:238)
    at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:536)

TIA

Regards,
Karim

Gerd Wagner wrote:

> Hi Karim,
>
> during the last months all the work I did on SQuirreL was mostly 
> tested against DB2 Version 8.2 running on Linux. The driver I use is
> COM.ibm.db2.jdbc.net.DB2Driver, URL: jdbc:db2://<host>/<db>
> with db2java.zip and db2jcc.jar in the driver definition's extra 
> classpath. I Never saw such trouble.
>
>
> Karim D. Saloojee wrote:
>
>> Hi
>>
>> We have just migrated to DB2 Version 8 and are now using the JDBC 
>> Type 4 driver. This is when the problems started.
>>
>> The first problem is when running a simple query (SELECT * from 
>> CUSTOMER) the following exception is printed out in the output window:
>> com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed
>> Query 1 elapsed time (seconds) - Total: 0.078, SQL query: 0.047, 
>> Building output: 0.031
>>
>> In 1.2b6, the results of the query are still printed out in the 
>> results window. In 2.0rc1 the results of the query do not even 
>> display. Using the "Objects" view and drilling down, Squirrel 
>> displays the table data in both versions without any issue.
>
> This sounds like a problem that occurred on the Derby DB some time 
> ago. I'm not sure if it is fixed in 2.0 rc1. You may try out the 
> latest weekly build to be sure you have got the fix.
>
>
>
>>
>> I have written a simple class that creates a JDBC connection in the 
>> same way. When I run the query, no errors/exceptions occur. Although 
>> I only retrieve the first column from the result set but I do not 
>> believe this is related to the issue.
>>
>> The second problem is as follows. When running an update as follows: 
>> UPDATE CUSTOMER SET SEGMENT = 777 WHERE ID IN (SELECT CUSTOMERID from 
>> CASEBASIC)
>> the following is displayed in the output window:
>> 13 Rows Updated
>> Query 1 elapsed time (seconds) - Total: 0, SQL query: 0, Building 
>> output: 0
>> Error: java.lang.StringIndexOutOfBoundsException: String index out of 
>> range: -35
>
> Could you please have look at the Windows menu --> 'View SQuirreL 
> logs' and check you find a stacktrace for the exception. If so please 
> send it to me.
>
> Thanks
>
> Gerd
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing 
> & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

___________________________________________________________

Important Notice: 
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to dis...@ab... and we will send you a copy of the 
Disclaimer.

Re: [Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

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

Hi Karim,

during the last months all the work I did on SQuirreL was mostly tested 
against DB2 Version 8.2 running on Linux. The driver I use is
COM.ibm.db2.jdbc.net.DB2Driver, URL: jdbc:db2://<host>/<db>
with db2java.zip and db2jcc.jar in the driver definition's extra 
classpath. I Never saw such trouble.


Karim D. Saloojee wrote:
> Hi
> 
> We have just migrated to DB2 Version 8 and are now using the JDBC Type 4 
> driver. This is when the problems started.
> 
> The first problem is when running a simple query (SELECT * from 
> CUSTOMER) the following exception is printed out in the output window:
> com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed
> Query 1 elapsed time (seconds) - Total: 0.078, SQL query: 0.047, 
> Building output: 0.031
> 
> In 1.2b6, the results of the query are still printed out in the results 
> window. In 2.0rc1 the results of the query do not even display. Using 
> the "Objects" view and drilling down, Squirrel displays the table data 
> in both versions without any issue.
This sounds like a problem that occurred on the Derby DB some time ago. 
I'm not sure if it is fixed in 2.0 rc1. You may try out the latest 
weekly build to be sure you have got the fix.



> 
> I have written a simple class that creates a JDBC connection in the same 
> way. When I run the query, no errors/exceptions occur. Although I only 
> retrieve the first column from the result set but I do not believe this 
> is related to the issue.
> 
> The second problem is as follows. When running an update as follows: 
> UPDATE CUSTOMER SET SEGMENT = 777 WHERE ID IN (SELECT CUSTOMERID from 
> CASEBASIC)
> the following is displayed in the output window:
> 13 Rows Updated
> Query 1 elapsed time (seconds) - Total: 0, SQL query: 0, Building output: 0
> Error: java.lang.StringIndexOutOfBoundsException: String index out of 
> range: -35
Could you please have look at the Windows menu --> 'View SQuirreL logs' 
and check you find a stacktrace for the exception. If so please send it 
to me.

Thanks

Gerd

[Squirrel-sql-users] DB2 Type 4 Driver: SqlException: Invalid operation: result set closed

[Karim D. S. <ka...@ab...>]

Hi

We have just migrated to DB2 Version 8 and are now using the JDBC Type 4 
driver. This is when the problems started.

The first problem is when running a simple query (SELECT * from 
CUSTOMER) the following exception is printed out in the output window:
com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed
Query 1 elapsed time (seconds) - Total: 0.078, SQL query: 0.047, 
Building output: 0.031

In 1.2b6, the results of the query are still printed out in the results 
window. In 2.0rc1 the results of the query do not even display. Using 
the "Objects" view and drilling down, Squirrel displays the table data 
in both versions without any issue.

I have written a simple class that creates a JDBC connection in the same 
way. When I run the query, no errors/exceptions occur. Although I only 
retrieve the first column from the result set but I do not believe this 
is related to the issue.

The second problem is as follows. When running an update as follows: 
UPDATE CUSTOMER SET SEGMENT = 777 WHERE ID IN (SELECT CUSTOMERID from 
CASEBASIC)
the following is displayed in the output window:
13 Rows Updated
Query 1 elapsed time (seconds) - Total: 0, SQL query: 0, Building output: 0
Error: java.lang.StringIndexOutOfBoundsException: String index out of 
range: -35

This seems to actually update the records in 1.2b6 but not in 2.0rc1.

Once again I wrote a simple class to run the update which displayed no 
errors or exceptions.

My class ran both of the above items as Statements and 
PreparedStatements with no issues. Could someone give me a pointer as to 
where I should start looking for the solutions to the problems I am 
encountering. Maybe even a quick explanation as to what Squirrel does 
once it executes a query in the SQL view.

Perhaps there is a bug in the JDBC driver metadata methods that Squirrel 
calls? Note that the issues above do not appear when running the queries 
using a JDBC Type 2 driver (which is a different class completely). 
However I cannot access all my databases using the Type 2 drivers for 
other non-technical reasons, so I would like to get this working.

TIA

Regards,
Karim


___________________________________________________________

Important Notice: 
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to dis...@ab... and we will send you a copy of the 
Disclaimer.