|
From: patricios1 <pat...@gm...> - 2012-03-30 13:38:53
|
Thanks to all for the replies. I extended the Java memory to 1280, which I believe is the maximum for Java 32, and now it works fine. Since my OS is windows 7, I modified the .bat file, as suggested by Stefan. On Fri, Mar 30, 2012 at 8:58 AM, < squ...@li...> wrote: > Send Squirrel-sql-users mailing list submissions to > squ...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > or, via email, send a message with subject or body 'help' to > squ...@li... > > You can reach the person managing the list at > squ...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Squirrel-sql-users digest..." > > > Today's Topics: > > 1. Re: exceeded maximum memory (erw...@gm...) > 2. Squirrel SQL Update feature (Tindall, Mark (M.)) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 27 Mar 2012 08:27:55 +0200 (GMT+02:00) > From: erw...@gm... > Subject: Re: [Squirrel-sql-users] exceeded maximum memory > To: Stefan Willinger <ste...@ao...>, > squ...@li... > Message-ID: <4086b3f2-8385-4dce-bcb8-6c354d20794d.maildroid@localhost> > Content-Type: text/plain; charset="utf-8" > > If your table is very large, raising the memory size won't be enough. > You should also limit the number of rows fetched by squirrel. 1000 rows is > a good start. > This can be set in the upper right corner of the sql window and in the > general settings. > Sorry not to be more specific, i'm not on my pc. > Erwan > > > Envoy? depuis mon Archos. > > > > -----Original Message----- > From: Stefan Willinger <ste...@ao...> > To: squ...@li... > Sent: lun., 26 mars 2012 19:24 > Subject: Re: [Squirrel-sql-users] exceeded maximum memory > > You can increase the max available memory by editing your run script. > > Depending on your operating system, you have to edit squirrel-sql.sh or > squirrel-sql.bat. > > Look for the line containing -Xmx256m (usually one of the last lines) > and change this value to -Xmx512m or -Xmx756m or any other valid value > (the valid value depends on your OS and Java Version). > > Stefan > > Am 2012-03-26 16:24, schrieb patricios1: > > Hi, > > > > I keep running out of memory when running queries. I get the following > > message: > > > > "The query results have exceeded the maximum amount of memory > > allocated to this application. All result tabs have been closed to > > allow you to save your work and restart the application." > > > > Can I allocate more memory to the program? If so, can someone advice > > how to do that? > > > > Thank you very much, > > Patricio > > > > > > > ------------------------------------------------------------------------------ > > This SF email is sponsosred by: > > Try Windows Azure free for 90 days Click Here > > http://p.sf.net/sfu/sfd2d-msazure > > > > > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Fri, 30 Mar 2012 12:31:23 +0000 > From: "Tindall, Mark (M.)" <mti...@fo...> > Subject: [Squirrel-sql-users] Squirrel SQL Update feature > To: "squ...@li..." > <squ...@li...> > Message-ID: > < > E51...@na...> > Content-Type: text/plain; charset="us-ascii" > > Hi, > > I have been trying (without much luck) to try and make use of the Software > Update feature of SquirrelSQL. When I try and use it I get the following > error: > > Release file couldn't be downloaded. Please check your settings. > > Looking at the logs the following appears: > > 2012-03-30 13:09:59,090 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.Application - Unable to download > release.xml from the specified location > java.net.UnknownHostException: sourceforge.net > at java.net.PlainSocketImpl.connect(Unknown Source) > at java.net.SocksSocketImpl.connect(Unknown Source) > at java.net.Socket.connect(Unknown Source) > at java.net.Socket.connect(Unknown Source) > at java.net.Socket.<init>(Unknown Source) > at java.net.Socket.<init>(Unknown Source) > at > org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80) > at > org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122) > at > org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707) > at > org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387) > at > org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) > at > org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) > at > org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323) > at > net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:321) > at > net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:875) > at > net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1055) > at > net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:204) > at > net.sourceforge.squirrel_sql.client.preferences.UpdatePreferencesPanel$TestConnectionButtonListener.actionPerformed(UpdatePreferencesPanel.java:655) > at javax.swing.AbstractButton.fireActionPerformed(Unknown > Source) > at javax.swing.AbstractButton$Handler.actionPerformed(Unknown > Source) > at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown > Source) > at javax.swing.DefaultButtonModel.setPressed(Unknown Source) > at > javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) > at java.awt.Component.processMouseEvent(Unknown Source) > at javax.swing.JComponent.processMouseEvent(Unknown Source) > at java.awt.Component.processEvent(Unknown Source) > at java.awt.Container.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown > Source) > at java.awt.LightweightDispatcher.processMouseEvent(Unknown > Source) > at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Window.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.EventQueue.dispatchEvent(Unknown Source) > at > net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) > at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown > Source) > at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown > Source) > at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown > Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.run(Unknown Source) > > I have tried typing the server name and path ( > sourceforge.net/projects/squirrel-sql/files/udates into IE and it brings > up the location without any problems. Could this be caused by being behind > a company firewall? > > On a separate note Squirrel SQL does seem to hang a lot when looking at > databases even though I have tried to alter the alias properties so that > only the minimum of information is being downloaded. This though I think > maybe more to do with using it with Windows 7 which has caused a lot of > problems with numerous other applications I use. > > Thanks, > > Mark Tindall > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > > ------------------------------ > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > End of Squirrel-sql-users Digest, Vol 69, Issue 7 > ************************************************* > |
