squirrel-sql-users Mailing List for SQuirreL SQL Client (Page 132)
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: umair m. <uma...@gm...> - 2006-01-19 05:56:46
|
Hello, I was going throughSQuirrel, no doubt an excellent tool, well written in JAVA. My requirements are however different. Does this tool give us the option to generate SQL code based on some selection through GUI ? If SQuirrel does not allow us to do so, is there anyother tool written in Java which performs the said operation ? Can anyone help me in this regard? Regards Umair |
From: Rob M. <Rob...@co...> - 2006-01-18 20:53:09
|
Gerd Wagner wrote: > yes, JGoodies Plastic 3D with Sky Bluer theme is the default. > > Good that the Look and Feel switch removed the lag. Since I never > heard of your problem before I wouldn't like to switch the default > right now. But if more people experience the same problem as you do > I'll turn the default to a Metal theme. > I'm quite fond of the kunstoff L&F myself. It just looks very professional IMHO. Rob |
From: Gerd W. <bir...@t-...> - 2006-01-18 20:47:29
|
Hi Mark, Mark Neher wrote: > > Interesting -- I switched to Metal L&F as you suggested and the lag went > away. Switching back (to JGoodies Plastic 3D -- is that the default ?? > I have never changed it) re-introduced the lag. I'll have to check at > home and see what L&F I have selected there, as I have no lag there on > an XP box; just on my Linux box at work. yes, JGoodies Plastic 3D with Sky Bluer theme is the default. Good that the Look and Feel switch removed the lag. Since I never heard of your problem before I wouldn't like to switch the default right now. But if more people experience the same problem as you do I'll turn the default to a Metal theme. Gerd > > Thanks for the advice, > > Mark > > >> From: Gerd Wagner <bir...@t-...> >> To: Mark Neher <mar...@ho...> >> CC: squ...@li... >> Subject: Re: [Squirrel-sql-users] performance issues when switching >> panels >> Date: Sun, 15 Jan 2006 13:08:44 +0100 >> >> Hi Mark, >> >> sorry that my tests didn't show any effect. All I can say at the >> moment is that your problem is not a common problem. At work more than >> 20 colleagues of mine are using SQuirreL on different Windows and >> Linux versions and no one ever complained about 3-4 seconds for >> switching between sessions. >> >> I have seen that with some look and feels switching session windows is >> faster than with others but by far not in the range of seconds. You >> might though try a Metal look and feel. >> >> The last thing I can offer is that you try out the little test class >> below. It opens a Desktop window with four child windows >> (JInternalFrames) with editor panes on each. If you can reproduce the >> lag on this example I'm pretty sure it is a problem with your system. >> >> Gerd >> >> ///////////////////////////////////////////////////////// >> // >> package pack; >> >> import javax.swing.*; >> >> public class InternalFrameTest >> { >> >> public static void main(String[] args) >> { >> JFrame f = new JFrame(); >> >> JDesktopPane desk = new JDesktopPane(); >> f.getContentPane().add(desk); >> >> JInternalFrame jif; >> >> jif = new JInternalFrame(); >> jif.getContentPane().add(new JEditorPane()); >> jif.setBounds(0,0,200,200); >> jif.setVisible(true); >> desk.add(jif); >> >> jif = new JInternalFrame(); >> jif.getContentPane().add(new JEditorPane()); >> jif.setBounds(0,210,200,200); >> jif.setVisible(true); >> desk.add(jif); >> >> jif = new JInternalFrame(); >> jif.getContentPane().add(new JEditorPane()); >> jif.setBounds(210,0,200,200); >> jif.setVisible(true); >> desk.add(jif); >> >> jif = new JInternalFrame(); >> jif.getContentPane().add(new JEditorPane()); >> jif.setBounds(210,210,200,200); >> jif.setVisible(true); >> desk.add(jif); >> >> >> f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); >> f.setSize(500,500); >> f.setVisible(true); >> } >> } >> // >> ///////////////////////////////////// >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Mark Neher wrote: >>> >>> Thanks for the quick response !! Regarding your suggestions: >>> >>> 1. I was and am using the NetBeans editor >>> >>> 2. I removed codecompletion.jar, restarted, and saw no change >>> >>> 3. I removed syntax.jar, restarted, and saw no change >>> >>> Thanks, >>> >>> Mark >>> >>> >>>> From: Gerd Wagner <bir...@t-...> >>>> To: Mark Neher <mar...@ho...> >>>> CC: squ...@li... >>>> Subject: Re: [Squirrel-sql-users] performance issues when switching >>>> panels >>>> Date: Fri, 13 Jan 2006 19:50:59 +0100 >>>> >>>> Hi Mark, >>>> >>>> could you try out the following an tell me if one or more changes >>>> the lag? >>>> >>>> 1. Check the New Session Properties if your are using the Netbeans >>>> editor. If not please switch to it and try again. >>>> >>>> 2. Remove the codecompletion.jar from your plugin dir, restart >>>> SQuirreL, and try again. >>>> >>>> 3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and >>>> try again. >>>> >>>> Thanks >>>> >>>> Gerd >>>> >>>> Mark Neher wrote: >>>> >>>>> Hi, >>>>> >>>>> I normally have 3-5 concurrent SQuirreL sessions open to various >>>>> schemas. When I upgraded from 1.2beta5 to version 2.0 a couple >>>>> months back, I started to have a lag when switching from one >>>>> session to another. In 1.2beta5, clicking in a different panel >>>>> would switch to that session instantly, like clicking into a >>>>> different window to switch applications at the system level. After >>>>> upgrading, there was a 3-4 second lag before the new panel became >>>>> active -- not a crippling problem, but annoying. This occurs when >>>>> directly clicking a panel or using the "Active Session" drop-down. >>>>> I've switched to version 2.1 today; my perception is that it is a >>>>> little faster in this regard (although I didn't put a stopwatch on >>>>> either version), but still a couple seconds to activate a panel. >>>>> >>>>> Does anyone else see this, or have an explanation ?? I've wondered >>>>> if there is some behind the scenes monitoring going on, to keep >>>>> code completion and other options up to date. BTW, I had switched >>>>> to 1.2beta6 quite a while back, but saw similar (or the same) >>>>> issues; I eventually was interested enough in code completion that >>>>> I was willing to take the delay. >>>>> >>>>> Thanks for the advice, >>>>> >>>>> Mark >>>>> > > > |
From: Rob M. <Rob...@co...> - 2006-01-17 18:49:52
|
Richard Vanhook wrote: > Hi, I've been using Squirrel for about 3 months now and I think its a > terrific sql editor. In fact, its something I wish I'd have found > quite some time ago. However, I've been unable to figure out if there > is a sql history capability to it. > > So, my question is - is sql history built into squirrel? If not, are > there plans to add sql history anytime soon? > > -Richard Vanhook Hi Richard, Just above the text area in the SQL tab, you should see a drop-down combo-box with the last SQL you executed displayed. If you click on it, you should see a scrollable list of each of your SQL statements. This list can be share acrossed sessions, or each session can have it's own list. Rob Manning |
From: Richard V. <ric...@gm...> - 2006-01-17 18:34:38
|
Hi, I've been using Squirrel for about 3 months now and I think its a terrific sql editor. In fact, its something I wish I'd have found quite some time ago. However, I've been unable to figure out if there is a sql history capability to it. So, my question is - is sql history built into squirrel? If not, are there plans to add sql history anytime soon? -Richard Vanhook |
From: Mark N. <mar...@ho...> - 2006-01-16 18:29:14
|
Interesting -- I switched to Metal L&F as you suggested and the lag went away. Switching back (to JGoodies Plastic 3D -- is that the default ?? I have never changed it) re-introduced the lag. I'll have to check at home and see what L&F I have selected there, as I have no lag there on an XP box; just on my Linux box at work. Thanks for the advice, Mark >From: Gerd Wagner <bir...@t-...> >To: Mark Neher <mar...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] performance issues when switching panels >Date: Sun, 15 Jan 2006 13:08:44 +0100 > >Hi Mark, > >sorry that my tests didn't show any effect. All I can say at the moment is >that your problem is not a common problem. At work more than 20 colleagues >of mine are using SQuirreL on different Windows and Linux versions and no >one ever complained about 3-4 seconds for switching between sessions. > >I have seen that with some look and feels switching session windows is >faster than with others but by far not in the range of seconds. You might >though try a Metal look and feel. > >The last thing I can offer is that you try out the little test class below. >It opens a Desktop window with four child windows (JInternalFrames) with >editor panes on each. If you can reproduce the lag on this example I'm >pretty sure it is a problem with your system. > >Gerd > >///////////////////////////////////////////////////////// >// >package pack; > >import javax.swing.*; > >public class InternalFrameTest >{ > > public static void main(String[] args) > { > JFrame f = new JFrame(); > > JDesktopPane desk = new JDesktopPane(); > f.getContentPane().add(desk); > > JInternalFrame jif; > > jif = new JInternalFrame(); > jif.getContentPane().add(new JEditorPane()); > jif.setBounds(0,0,200,200); > jif.setVisible(true); > desk.add(jif); > > jif = new JInternalFrame(); > jif.getContentPane().add(new JEditorPane()); > jif.setBounds(0,210,200,200); > jif.setVisible(true); > desk.add(jif); > > jif = new JInternalFrame(); > jif.getContentPane().add(new JEditorPane()); > jif.setBounds(210,0,200,200); > jif.setVisible(true); > desk.add(jif); > > jif = new JInternalFrame(); > jif.getContentPane().add(new JEditorPane()); > jif.setBounds(210,210,200,200); > jif.setVisible(true); > desk.add(jif); > > > f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); > f.setSize(500,500); > f.setVisible(true); > } >} >// >///////////////////////////////////// > > > > > > > > > > > > > > > >Mark Neher wrote: >> >>Thanks for the quick response !! Regarding your suggestions: >> >>1. I was and am using the NetBeans editor >> >>2. I removed codecompletion.jar, restarted, and saw no change >> >>3. I removed syntax.jar, restarted, and saw no change >> >>Thanks, >> >>Mark >> >> >>>From: Gerd Wagner <bir...@t-...> >>>To: Mark Neher <mar...@ho...> >>>CC: squ...@li... >>>Subject: Re: [Squirrel-sql-users] performance issues when switching >>>panels >>>Date: Fri, 13 Jan 2006 19:50:59 +0100 >>> >>>Hi Mark, >>> >>>could you try out the following an tell me if one or more changes the >>>lag? >>> >>>1. Check the New Session Properties if your are using the Netbeans >>>editor. If not please switch to it and try again. >>> >>>2. Remove the codecompletion.jar from your plugin dir, restart SQuirreL, >>>and try again. >>> >>>3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and try >>>again. >>> >>>Thanks >>> >>>Gerd >>> >>>Mark Neher wrote: >>> >>>>Hi, >>>> >>>>I normally have 3-5 concurrent SQuirreL sessions open to various >>>>schemas. When I upgraded from 1.2beta5 to version 2.0 a couple months >>>>back, I started to have a lag when switching from one session to >>>>another. In 1.2beta5, clicking in a different panel would switch to >>>>that session instantly, like clicking into a different window to switch >>>>applications at the system level. After upgrading, there was a 3-4 >>>>second lag before the new panel became active -- not a crippling >>>>problem, but annoying. This occurs when directly clicking a panel or >>>>using the "Active Session" drop-down. I've switched to version 2.1 >>>>today; my perception is that it is a little faster in this regard >>>>(although I didn't put a stopwatch on either version), but still a >>>>couple seconds to activate a panel. >>>> >>>>Does anyone else see this, or have an explanation ?? I've wondered if >>>>there is some behind the scenes monitoring going on, to keep code >>>>completion and other options up to date. BTW, I had switched to >>>>1.2beta6 quite a while back, but saw similar (or the same) issues; I >>>>eventually was interested enough in code completion that I was willing >>>>to take the delay. >>>> >>>>Thanks for the advice, >>>> >>>>Mark >>>> |
From: Simon G. <SGR...@fl...> - 2006-01-16 16:48:59
|
I've noticed over the years that, for some unknown reason, java is notoriously slow on some machines when doing large screen refreshes. I have been unable to get to the bottom of this, but believe it relates to some synch problem between javalibs delayed refresh and windows delayed refresh. Another suggestion is to make sure you have the HotSpot compiler installed. Simon ------ Simon Grantham Fleming College Sys. Admin, H&OD Ext. 1976 >>> Gerd Wagner <bir...@t-...> 1/15/2006 7:08 AM >>> Hi Mark, sorry that my tests didn't show any effect. All I can say at the moment is that your problem is not a common problem. At work more than 20 colleagues of mine are using SQuirreL on different Windows and Linux versions and no one ever complained about 3-4 seconds for switching between sessions. I have seen that with some look and feels switching session windows is faster than with others but by far not in the range of seconds. You might though try a Metal look and feel. The last thing I can offer is that you try out the little test class below. It opens a Desktop window with four child windows (JInternalFrames) with editor panes on each. If you can reproduce the lag on this example I'm pretty sure it is a problem with your system. Gerd ///////////////////////////////////////////////////////// // package pack; import javax.swing.*; public class InternalFrameTest { public static void main(String[] args) { JFrame f = new JFrame(); JDesktopPane desk = new JDesktopPane(); f.getContentPane().add(desk); JInternalFrame jif; jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(0,0,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(0,210,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(210,0,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(210,210,200,200); jif.setVisible(true); desk.add(jif); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setSize(500,500); f.setVisible(true); } } // ///////////////////////////////////// Mark Neher wrote: > > Thanks for the quick response !! Regarding your suggestions: > > 1. I was and am using the NetBeans editor > > 2. I removed codecompletion.jar, restarted, and saw no change > > 3. I removed syntax.jar, restarted, and saw no change > > Thanks, > > Mark > > >> From: Gerd Wagner <bir...@t-...> >> To: Mark Neher <mar...@ho...> >> CC: squ...@li... >> Subject: Re: [Squirrel-sql-users] performance issues when switching >> panels >> Date: Fri, 13 Jan 2006 19:50:59 +0100 >> >> Hi Mark, >> >> could you try out the following an tell me if one or more changes the >> lag? >> >> 1. Check the New Session Properties if your are using the Netbeans >> editor. If not please switch to it and try again. >> >> 2. Remove the codecompletion.jar from your plugin dir, restart >> SQuirreL, and try again. >> >> 3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and >> try again. >> >> Thanks >> >> Gerd >> >> Mark Neher wrote: >> >>> Hi, >>> >>> I normally have 3-5 concurrent SQuirreL sessions open to various >>> schemas. When I upgraded from 1.2beta5 to version 2.0 a couple >>> months back, I started to have a lag when switching from one session >>> to another. In 1.2beta5, clicking in a different panel would switch >>> to that session instantly, like clicking into a different window to >>> switch applications at the system level. After upgrading, there was >>> a 3-4 second lag before the new panel became active -- not a >>> crippling problem, but annoying. This occurs when directly clicking >>> a panel or using the "Active Session" drop-down. I've switched to >>> version 2.1 today; my perception is that it is a little faster in >>> this regard (although I didn't put a stopwatch on either version), >>> but still a couple seconds to activate a panel. >>> >>> Does anyone else see this, or have an explanation ?? I've wondered >>> if there is some behind the scenes monitoring going on, to keep code >>> completion and other options up to date. BTW, I had switched to >>> 1.2beta6 quite a while back, but saw similar (or the same) issues; I >>> eventually was interested enough in code completion that I was >>> willing to take the delay. >>> >>> Thanks for the advice, >>> >>> Mark >>> ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Rob M. <Rob...@co...> - 2006-01-16 11:11:23
|
Mark Neher wrote: > Hi, > > I normally have 3-5 concurrent SQuirreL sessions open to various > schemas. When I upgraded from 1.2beta5 to version 2.0 a couple months > back, I started to have a lag when switching from one session to > another. In 1.2beta5, clicking in a different panel would switch to > that session instantly, like clicking into a different window to > switch applications at the system level. After upgrading, there was a > 3-4 second lag before the new panel became active -- not a crippling > problem, but annoying. This occurs when directly clicking a panel or > using the "Active Session" drop-down. I've switched to version 2.1 > today; my perception is that it is a little faster in this regard > (although I didn't put a stopwatch on either version), but still a > couple seconds to activate a panel. > > Does anyone else see this, or have an explanation ?? I've wondered if > there is some behind the scenes monitoring going on, to keep code > completion and other options up to date. BTW, I had switched to > 1.2beta6 quite a while back, but saw similar (or the same) issues; I > eventually was interested enough in code completion that I was willing > to take the delay. Hi Mark, By any chance, are you viewing binary data in the contents tab of the object tree panel for a table in the session you are switching to or from? I recently noticed similar behavior for this type of data. Rob Manning |
From: Gerd W. <bir...@t-...> - 2006-01-15 12:08:48
|
Hi Mark, sorry that my tests didn't show any effect. All I can say at the moment is that your problem is not a common problem. At work more than 20 colleagues of mine are using SQuirreL on different Windows and Linux versions and no one ever complained about 3-4 seconds for switching between sessions. I have seen that with some look and feels switching session windows is faster than with others but by far not in the range of seconds. You might though try a Metal look and feel. The last thing I can offer is that you try out the little test class below. It opens a Desktop window with four child windows (JInternalFrames) with editor panes on each. If you can reproduce the lag on this example I'm pretty sure it is a problem with your system. Gerd ///////////////////////////////////////////////////////// // package pack; import javax.swing.*; public class InternalFrameTest { public static void main(String[] args) { JFrame f = new JFrame(); JDesktopPane desk = new JDesktopPane(); f.getContentPane().add(desk); JInternalFrame jif; jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(0,0,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(0,210,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(210,0,200,200); jif.setVisible(true); desk.add(jif); jif = new JInternalFrame(); jif.getContentPane().add(new JEditorPane()); jif.setBounds(210,210,200,200); jif.setVisible(true); desk.add(jif); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setSize(500,500); f.setVisible(true); } } // ///////////////////////////////////// Mark Neher wrote: > > Thanks for the quick response !! Regarding your suggestions: > > 1. I was and am using the NetBeans editor > > 2. I removed codecompletion.jar, restarted, and saw no change > > 3. I removed syntax.jar, restarted, and saw no change > > Thanks, > > Mark > > >> From: Gerd Wagner <bir...@t-...> >> To: Mark Neher <mar...@ho...> >> CC: squ...@li... >> Subject: Re: [Squirrel-sql-users] performance issues when switching >> panels >> Date: Fri, 13 Jan 2006 19:50:59 +0100 >> >> Hi Mark, >> >> could you try out the following an tell me if one or more changes the >> lag? >> >> 1. Check the New Session Properties if your are using the Netbeans >> editor. If not please switch to it and try again. >> >> 2. Remove the codecompletion.jar from your plugin dir, restart >> SQuirreL, and try again. >> >> 3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and >> try again. >> >> Thanks >> >> Gerd >> >> Mark Neher wrote: >> >>> Hi, >>> >>> I normally have 3-5 concurrent SQuirreL sessions open to various >>> schemas. When I upgraded from 1.2beta5 to version 2.0 a couple >>> months back, I started to have a lag when switching from one session >>> to another. In 1.2beta5, clicking in a different panel would switch >>> to that session instantly, like clicking into a different window to >>> switch applications at the system level. After upgrading, there was >>> a 3-4 second lag before the new panel became active -- not a >>> crippling problem, but annoying. This occurs when directly clicking >>> a panel or using the "Active Session" drop-down. I've switched to >>> version 2.1 today; my perception is that it is a little faster in >>> this regard (although I didn't put a stopwatch on either version), >>> but still a couple seconds to activate a panel. >>> >>> Does anyone else see this, or have an explanation ?? I've wondered >>> if there is some behind the scenes monitoring going on, to keep code >>> completion and other options up to date. BTW, I had switched to >>> 1.2beta6 quite a while back, but saw similar (or the same) issues; I >>> eventually was interested enough in code completion that I was >>> willing to take the delay. >>> >>> Thanks for the advice, >>> >>> Mark >>> |
From: Mark N. <mar...@ho...> - 2006-01-13 19:49:10
|
Thanks for the quick response !! Regarding your suggestions: 1. I was and am using the NetBeans editor 2. I removed codecompletion.jar, restarted, and saw no change 3. I removed syntax.jar, restarted, and saw no change Thanks, Mark >From: Gerd Wagner <bir...@t-...> >To: Mark Neher <mar...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] performance issues when switching panels >Date: Fri, 13 Jan 2006 19:50:59 +0100 > >Hi Mark, > >could you try out the following an tell me if one or more changes the lag? > >1. Check the New Session Properties if your are using the Netbeans editor. >If not please switch to it and try again. > >2. Remove the codecompletion.jar from your plugin dir, restart SQuirreL, >and try again. > >3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and try >again. > >Thanks > >Gerd > >Mark Neher wrote: >>Hi, >> >>I normally have 3-5 concurrent SQuirreL sessions open to various schemas. >>When I upgraded from 1.2beta5 to version 2.0 a couple months back, I >>started to have a lag when switching from one session to another. In >>1.2beta5, clicking in a different panel would switch to that session >>instantly, like clicking into a different window to switch applications at >>the system level. After upgrading, there was a 3-4 second lag before the >>new panel became active -- not a crippling problem, but annoying. This >>occurs when directly clicking a panel or using the "Active Session" >>drop-down. I've switched to version 2.1 today; my perception is that it >>is a little faster in this regard (although I didn't put a stopwatch on >>either version), but still a couple seconds to activate a panel. >> >>Does anyone else see this, or have an explanation ?? I've wondered if >>there is some behind the scenes monitoring going on, to keep code >>completion and other options up to date. BTW, I had switched to 1.2beta6 >>quite a while back, but saw similar (or the same) issues; I eventually was >>interested enough in code completion that I was willing to take the delay. >> >>Thanks for the advice, >> >>Mark >> >> >> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: Splunk Inc. Do you grep through log >>files >>for problems? Stop! Download the new AJAX search engine that makes >>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click >>_______________________________________________ >>Squirrel-sql-users mailing list >>Squ...@li... >>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > |
From: Gerd W. <bir...@t-...> - 2006-01-13 18:51:16
|
Hi Mark, could you try out the following an tell me if one or more changes the lag? 1. Check the New Session Properties if your are using the Netbeans editor. If not please switch to it and try again. 2. Remove the codecompletion.jar from your plugin dir, restart SQuirreL, and try again. 3. Remove the syntax.jar from your plugin dir, restart SQuirreL, and try again. Thanks Gerd Mark Neher wrote: > Hi, > > I normally have 3-5 concurrent SQuirreL sessions open to various > schemas. When I upgraded from 1.2beta5 to version 2.0 a couple months > back, I started to have a lag when switching from one session to > another. In 1.2beta5, clicking in a different panel would switch to > that session instantly, like clicking into a different window to switch > applications at the system level. After upgrading, there was a 3-4 > second lag before the new panel became active -- not a crippling > problem, but annoying. This occurs when directly clicking a panel or > using the "Active Session" drop-down. I've switched to version 2.1 > today; my perception is that it is a little faster in this regard > (although I didn't put a stopwatch on either version), but still a > couple seconds to activate a panel. > > Does anyone else see this, or have an explanation ?? I've wondered if > there is some behind the scenes monitoring going on, to keep code > completion and other options up to date. BTW, I had switched to > 1.2beta6 quite a while back, but saw similar (or the same) issues; I > eventually was interested enough in code completion that I was willing > to take the delay. > > Thanks for the advice, > > Mark > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: Mark N. <mar...@ho...> - 2006-01-13 18:32:22
|
Hi, I normally have 3-5 concurrent SQuirreL sessions open to various schemas. When I upgraded from 1.2beta5 to version 2.0 a couple months back, I started to have a lag when switching from one session to another. In 1.2beta5, clicking in a different panel would switch to that session instantly, like clicking into a different window to switch applications at the system level. After upgrading, there was a 3-4 second lag before the new panel became active -- not a crippling problem, but annoying. This occurs when directly clicking a panel or using the "Active Session" drop-down. I've switched to version 2.1 today; my perception is that it is a little faster in this regard (although I didn't put a stopwatch on either version), but still a couple seconds to activate a panel. Does anyone else see this, or have an explanation ?? I've wondered if there is some behind the scenes monitoring going on, to keep code completion and other options up to date. BTW, I had switched to 1.2beta6 quite a while back, but saw similar (or the same) issues; I eventually was interested enough in code completion that I was willing to take the delay. Thanks for the advice, Mark |
From: Gerd W. <bir...@t-...> - 2006-01-11 20:46:54
|
Hi Abhishek, your code is OK and I committed it to CVS. I just didn't see this solution last night. Thanks for not trusting me ;-) and for your code. Gerd Gupta, Abhishek schrieb: > This is the code which I had changed to get this working. > > -----Original Message----- > From: Gerd Wagner [mailto:bir...@t-...] > Sent: Tuesday, January 10, 2006 4:53 PM > To: Gupta, Abhishek > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Code Completion Plugin > > Hi Abhishek, > > thanks for this one. It made me play around with code completion for > some time. > > Unfortunately I don't think I'll find a good solution at the moment. > Here are some details: > > Of course the problem is that you use the same alias for two different > tables. The decision that has to be made is whether you are in the first > or the second statement when you use completion on 'a.' > I could not think of a good way to decide this for now. > > If you have got any suggestions let me know. For every day work I'd > suggest not to use duplicate aliases. > > Gerd > > Gupta, Abhishek wrote: > >>I am facing a problem with the code completion plugin which happens when >>I have multiple queries in the sql panel. >> >> >> >>For example: >> >> >> >>1^st query: select * from table1 a inner join table2 b on table1.id = >>table2.table1id where a.x = 2 // Auto complete works correctly here I >>get table1 columns in "a." where clause. >> >> >> >>2^nd query: select * from table3 a where a.y = 5 // Autocomplete shows >>the columns for table1 instead of table3. >> >> >> >>Has any body else seen this problem? >> >> >> >>Thanks >> >>Abhishek >> > > > > ------------------------------------------------------------------------ > > 75a76 > >> int stringToParsePosition = getStringToParsePosition ( textTillCarret ); > > 138c139 > < ret.addAll(Arrays.asList(getColumnsForName(catalog, schema, tableNamePat2, colNamePat2))); > --- > >> ret.addAll(Arrays.asList(getColumnsForName(catalog, schema, tableNamePat2, colNamePat2, stringToParsePosition ))); > > 148c149 > < ret.addAll(Arrays.asList(getColumnsForName(null, null, tableNamePat1, colNamePat1))); > --- > >> ret.addAll(Arrays.asList(getColumnsForName(null, null, tableNamePat1, colNamePat1, stringToParsePosition ))); > > 206a208,234 > >> private int getStringToParsePosition(String textTillCaret) >> { >> >> int lastIndexOfLineFeed = textTillCaret.lastIndexOf('\n'); >> String lineTillCaret; >> >> if(-1 == lastIndexOfLineFeed) >> { >> lineTillCaret = textTillCaret; >> } >> else >> { >> lineTillCaret = textTillCaret.substring(lastIndexOfLineFeed); >> } >> >> int pos = lastIndexOfLineFeed + 1; >> if (0 != lineTillCaret.length() && !Character.isWhitespace(lineTillCaret.charAt(lineTillCaret.length() - 1))) >> { >> int lastSeparatorIndex = getLastSeparatorIndex(lineTillCaret); >> if (-1 != lastSeparatorIndex) >> { >> pos += lastSeparatorIndex; >> } >> } >> >> return pos; >> } > > 211c239 > < private CodeCompletionInfo[] getColumnsForName(String catalog, String schema, String name, String colNamePat) > --- > >> private CodeCompletionInfo[] getColumnsForName ( String catalog, String schema, String name, String colNamePat, int colPos ) > > 214a243,265 > >> CodeCompletionInfo toReturn = null; >> if ( colPos != -1 ) >> { >> // First check aliases >> for ( int j = 0; j < infos.length ; j++ ) >> { >> CodeCompletionInfo info = infos[ j ]; >> if ( info instanceof CodeCompletionTableAliasInfo ) >> { >> if ( info.upperCaseCompletionStringEquals ( upperCaseTableNamePat ) ) >> { >> // See if this is the same statement >> CodeCompletionTableAliasInfo a = ( CodeCompletionTableAliasInfo ) info; >> if ( colPos >= a.getStatBegin () ) >> { >> toReturn = a; >> } >> } >> } >> } >> } >> if ( toReturn == null ) >> { > > 218a270,276 > >> toReturn = infos[ i ]; >> break; >> } >> } >> } >> if (toReturn != null) >> { > > 221c279 > < return infos[i].getColumns(_session.getSchemaInfo(), colNamePat); > --- > >> return toReturn.getColumns(_session.getSchemaInfo(), colNamePat); > > 228d285 > < } > 238c295 > < return getColumnsForName(null, null, _lastSelectedCompletionName, colNamePat); > --- > >> return getColumnsForName(null, null, _lastSelectedCompletionName, colNamePat, -1 ); >> >> >>------------------------------------------------------------------------ >> >>41a42,45 >> >>> public int getStatBegin() >>> { >>> return _aliasInfo.statBegin; >>> } |
From: Gupta, A. <abh...@gs...> - 2006-01-11 14:47:29
|
This is the code which I had changed to get this working. -----Original Message----- From: Gerd Wagner [mailto:bir...@t-...] Sent: Tuesday, January 10, 2006 4:53 PM To: Gupta, Abhishek Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Code Completion Plugin Hi Abhishek, thanks for this one. It made me play around with code completion for some time. Unfortunately I don't think I'll find a good solution at the moment. Here are some details: Of course the problem is that you use the same alias for two different tables. The decision that has to be made is whether you are in the first or the second statement when you use completion on 'a.' I could not think of a good way to decide this for now. If you have got any suggestions let me know. For every day work I'd suggest not to use duplicate aliases. Gerd Gupta, Abhishek wrote: > I am facing a problem with the code completion plugin which happens when > I have multiple queries in the sql panel. > > > > For example: > > > > 1^st query: select * from table1 a inner join table2 b on table1.id = > table2.table1id where a.x = 2 // Auto complete works correctly here I > get table1 columns in "a." where clause. > > > > 2^nd query: select * from table3 a where a.y = 5 // Autocomplete shows > the columns for table1 instead of table3. > > > > Has any body else seen this problem? > > > > Thanks > > Abhishek > |
From: Gupta, A. <abh...@gs...> - 2006-01-10 23:14:35
|
I have tried to fix this. Have got it working but do not know whether it is a good solution or not. -----Original Message----- From: Gerd Wagner [mailto:bir...@t-...] Sent: Tuesday, January 10, 2006 4:53 PM To: Gupta, Abhishek Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Code Completion Plugin Hi Abhishek, thanks for this one. It made me play around with code completion for some time. Unfortunately I don't think I'll find a good solution at the moment. Here are some details: Of course the problem is that you use the same alias for two different tables. The decision that has to be made is whether you are in the first or the second statement when you use completion on 'a.' I could not think of a good way to decide this for now. If you have got any suggestions let me know. For every day work I'd suggest not to use duplicate aliases. Gerd Gupta, Abhishek wrote: > I am facing a problem with the code completion plugin which happens when > I have multiple queries in the sql panel. > > > > For example: > > > > 1^st query: select * from table1 a inner join table2 b on table1.id = > table2.table1id where a.x = 2 // Auto complete works correctly here I > get table1 columns in "a." where clause. > > > > 2^nd query: select * from table3 a where a.y = 5 // Autocomplete shows > the columns for table1 instead of table3. > > > > Has any body else seen this problem? > > > > Thanks > > Abhishek > |
From: Gerd W. <bir...@t-...> - 2006-01-10 21:53:33
|
Hi Abhishek, thanks for this one. It made me play around with code completion for some time. Unfortunately I don't think I'll find a good solution at the moment. Here are some details: Of course the problem is that you use the same alias for two different tables. The decision that has to be made is whether you are in the first or the second statement when you use completion on 'a.' I could not think of a good way to decide this for now. If you have got any suggestions let me know. For every day work I'd suggest not to use duplicate aliases. Gerd Gupta, Abhishek wrote: > I am facing a problem with the code completion plugin which happens when > I have multiple queries in the sql panel. > > > > For example: > > > > 1^st query: select * from table1 a inner join table2 b on table1.id = > table2.table1id where a.x = 2 // Auto complete works correctly here I > get table1 columns in “a.” where clause. > > > > 2^nd query: select * from table3 a where a.y = 5 // Autocomplete shows > the columns for table1 instead of table3. > > > > Has any body else seen this problem? > > > > Thanks > > Abhishek > |
From: Gupta, A. <abh...@gs...> - 2006-01-10 19:56:35
|
I am facing a problem with the code completion plugin which happens when I have multiple queries in the sql panel. For example: 1st query: select * from table1 a inner join table2 b on table1.id = table2.table1id where a.x = 2 // Auto complete works correctly here I get table1 columns in "a." where clause. 2nd query: select * from table3 a where a.y = 5 // Autocomplete shows the columns for table1 instead of table3. Has any body else seen this problem? Thanks Abhishek |
From: Simon G. <SGR...@fl...> - 2006-01-10 17:35:56
|
Well now I am truly embarrassed. I sent an email to our DBA to ask if he had a current schema and he said he did generate one at one time but gave up on it as there were no primary or foreign keys defined in the system!??! What kind of database is that?? I suppose the next question is what is MS Accesses doing when it decides that they're are primary keys. Nope, don't really care enough to investigate that. Still, I some point I'll download the source. I have a couple of ideas I'ld like to experiment with before proposing. Thanks for your time, Simon ------ Simon Grantham Fleming College Sys. Admin, H&OD Ext. 1976 >>> Rob Manning <Rob...@co...> 1/10/2006 10:32 AM >>> Simon Grantham wrote: >I was using the OCI version of JDBC in order to use tnsnames without >specifying host name (e.g. URL=jdbc:oracle:oci:@<sid>). >However, I tried the pure java driver >(URL=jdbc:oracle:thin:@<host>:<port>:<sid>) with the same results. That >is, the "Primary Key" tab of the Objects display, only shows that there >are no primary keys and generates no errors to indicate what my be a >cause. I guess I'll have to download the Squirrel source and try and >debug. > > Always good to have more eyes looking at the code ;) Sounds like the driver is failing to give the primary key info for the table you are inspecting.(Either that or some exception is occuring) Are you using the latest 10g type4 driver (ojdbc14.jar) to access your Oracle 9i server? Rob |
From: Rob M. <Rob...@co...> - 2006-01-10 15:33:11
|
Simon Grantham wrote: >I was using the OCI version of JDBC in order to use tnsnames without >specifying host name (e.g. URL=jdbc:oracle:oci:@<sid>). >However, I tried the pure java driver >(URL=jdbc:oracle:thin:@<host>:<port>:<sid>) with the same results. That >is, the "Primary Key" tab of the Objects display, only shows that there >are no primary keys and generates no errors to indicate what my be a >cause. I guess I'll have to download the Squirrel source and try and >debug. > > Always good to have more eyes looking at the code ;) Sounds like the driver is failing to give the primary key info for the table you are inspecting.(Either that or some exception is occuring) Are you using the latest 10g type4 driver (ojdbc14.jar) to access your Oracle 9i server? Rob |
From: Simon G. <SGR...@fl...> - 2006-01-10 15:08:54
|
I was using the OCI version of JDBC in order to use tnsnames without specifying host name (e.g. URL=jdbc:oracle:oci:@<sid>). However, I tried the pure java driver (URL=jdbc:oracle:thin:@<host>:<port>:<sid>) with the same results. That is, the "Primary Key" tab of the Objects display, only shows that there are no primary keys and generates no errors to indicate what my be a cause. I guess I'll have to download the Squirrel source and try and debug. Thanks Simon ------ Simon Grantham Fleming College Sys. Admin, H&OD Ext. 1976 >>> Rob Manning <Rob...@co...> 1/9/2006 5:53 PM >>> Simon Grantham wrote: >I just installed 2.1 and it looks to be a great tool. However, after >connecting to an Oracle 9i database using the OCI driver, I can look at >things with the exception of Primary/Imported/Exported keys. I don't >get privilege violations and in fact, if I link the various tables to an >MS Access database through ODBC, MS Access shows the primary keys. > > Simon, I would hazard to guess that not many use an Oracle OCI driver with SQuirreL.(I've never tried the OCI driver - does it use SQL*Net and tnsnames.ora?) Perhaps you can give the Type-4 JDBC driver a try? If memory serves me correctly, I believe Oracle recommends the pure-Java driver anyway. I use it, and can access the information you are looking for. Rob Manning |
From: Rob M. <Rob...@co...> - 2006-01-09 22:53:55
|
Simon Grantham wrote: >I just installed 2.1 and it looks to be a great tool. However, after >connecting to an Oracle 9i database using the OCI driver, I can look at >things with the exception of Primary/Imported/Exported keys. I don't >get privilege violations and in fact, if I link the various tables to an >MS Access database through ODBC, MS Access shows the primary keys. > > Simon, I would hazard to guess that not many use an Oracle OCI driver with SQuirreL.(I've never tried the OCI driver - does it use SQL*Net and tnsnames.ora?) Perhaps you can give the Type-4 JDBC driver a try? If memory serves me correctly, I believe Oracle recommends the pure-Java driver anyway. I use it, and can access the information you are looking for. Rob Manning |
From: Simon G. <SGR...@fl...> - 2006-01-09 19:24:52
|
I just installed 2.1 and it looks to be a great tool. However, after connecting to an Oracle 9i database using the OCI driver, I can look at things with the exception of Primary/Imported/Exported keys. I don't get privilege violations and in fact, if I link the various tables to an MS Access database through ODBC, MS Access shows the primary keys. I've been through all the doc's (well, I believe so anyways), and all the configuration settings. Have I missed something obvious? Thanks Simon |
From: Sylvain R. <Rou...@ya...> - 2006-01-06 07:14:24
|
Le Vendredi 30 D=E9cembre 2005 22:10, Rob Manning a =E9crit=A0: > Sylvain Rouillard wrote: > >Hi list, > > > >I am trying to install squirrel-sql on my FC4 x86_64 machine with no > > success. First of all, I have many minor problems with the installer > > window. > > > >Problem #4 - the terminator: > >After clicking on Next, here is what the consol says: > >Caused by: java.lang.ClassNotFoundException: > >com.izforge.izpack.event.InstallerListener not found in > >gnu.gcj.runtime.SystemClassLoader{urls=3D[file:squirrel-sql-2.1final-ins= tall > >.jar], parent=3Dgnu.gcj.runtime.ExtensionClassLoader{urls=3D[], parent= =3Dnull}} > > at java.net.URLClassLoader.findClass(java.lang.String) > >(/usr/lib64/libgcj.so.6.0.0) > > at java.lang.ClassLoader.loadClass(java.lang.String, boolean) > >(/usr/lib64/libgcj.so.6.0.0) > > at java.lang.ClassLoader.loadClass(java.lang.String) > >(/usr/lib64/libgcj.so.6.0.0) > > at java.lang.Class.forName(java.lang.String, boolean, > >java.lang.ClassLoader) (/usr/lib64/libgcj.so.6.0.0) > > ...28 more > > Hi Sylvain, > > I'm not sure what all of your jdk options are for FC4 on x86 / 64-bit, > but I know one thing for sure - > the gnu java that comes with FC4 out-of-the-box is not what I'd call a > good replacement for Sun's > JDK. I had lots of GUI-related problems when I was running eclipse on > it. I would suggest trying > downloading 1.4.2 from Sun, or if you need it, try out 1.5 from > Blackdown (I believe I heard they > are the only ones offering 1.5 for 64-bit platform right now - from Java > Posse) > > Rob Manning Hi Rob, Thank you for your insight. I'm not sure I am willing to go through the pai= n=20 of installing another java implementation on top or instead of the default = =46C=20 one, but at least if I get desperate of getting squirrel, I'll know what to= =20 do. As for java on 64bits plateform, Sun's version is perfectly ok, they=20 provide 1.5 for 64b. What you need Blackdown for on 64b machines is to get= =20 the browser java plugin, because Sun doesn't provide one (yet). And afaik,= =20 Blackdown only has 1.4.2 (and down). Anyways, thank you for your answer and happy new year to the list :-) ___________________________________________________________________________ Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international. Téléchargez sur http://fr.messenger.yahoo.com |
From: Rob M. <Rob...@co...> - 2006-01-05 21:41:46
|
Matt Kirk wrote: > Hi Squirrel SQL users, > > I've noticed that auto commit is on by default - is there any way to > make of off by default? Sure, just go to: File -> New Session Properties -> SQL Tab Uncheck the checkbox labelled "Auto Commit SQL" and click "OK". Now each time you open a new database session, Auto-Commit should be disabled, unless you change it in that session. Rob Manning |
From: Matt K. <mck...@ya...> - 2006-01-05 11:20:49
|
Hi Squirrel SQL users, I've noticed that auto commit is on by default - is there any way to make of off by default? Thanks. --------------------------------- Play Santa's Celebrity Xmas Party, an exclusive game from Yahoo! |