Unable to reconnect to Vertica

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Unable to reconnect to Vertica

Nester Neworchard
Hi,

I've been using some 2-years old version for quite a time, but since I updated my Java recently it stopped to work. I've update it with the newest build, but now I'm no longer to reconnect to session with a Vertica DB. I get following error when selecting Session->Reconnect:

Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:

 Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1] on frame0
java.lang.ClassCastException: net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder cannot be cast to java.lang.String
at net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
at net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
at net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
...

When using Ctrl+Alt+T instead:

Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM: Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54] on net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]

java.lang.ClassCastException: net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder cannot be cast to java.lang.String at net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184) at net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513) at net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561) at net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
...

Could that be caused by my configuration being imported from an old install? The connection otherwise works, I'm able to run queries and get results, so far only the Reconnect function makes troubles.

Thanks,
Michael

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to reconnect to Vertica

Gerd Wagner-3
Hi Michael,

I just uploaded a new snapshot containing a fix. Since I wasn't able to
reproduce the problem it would be nice if you could try it out and let
me know if it worked.

See:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161011_2203/

Thanks
Gerd

Am 11.10.2016 um 14:49 schrieb Nester Neworchard:

> Hi,
>
> I've been using some 2-years old version for quite a time, but since I
> updated my Java recently it stopped to work. I've update it with the
> newest build, but now I'm no longer to reconnect to session with a
> Vertica DB. I get following error when selecting Session->Reconnect:
>
> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
>
>  Exception occurred dispatching Event
> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
> on frame0
> java.lang.ClassCastException:
> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
> cannot be cast to java.lang.String
> at
> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
> at
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> at
> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
> at
> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> ...
>
> When using Ctrl+Alt+T instead:
>
> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
> Exception occurred dispatching Event
> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
> on
> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
>
> java.lang.ClassCastException:
> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
> cannot be cast to java.lang.String at
> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
> at
> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
> at
> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
> at
> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> ...
>
> Could that be caused by my configuration being imported from an old
> install? The connection otherwise works, I'm able to run queries and get
> results, so far only the Reconnect function makes troubles.
>
> Thanks,
> Michael
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to reconnect to Vertica

Matt Ferreira
I got the same problem as well(hadn't noticed as I rarely use vertica). I can test tomorrow if Michael hasn't by then

> On Oct 11, 2016, at 4:11 PM, Gerd Wagner <[hidden email]> wrote:
>
> Hi Michael,
>
> I just uploaded a new snapshot containing a fix. Since I wasn't able to
> reproduce the problem it would be nice if you could try it out and let
> me know if it worked.
>
> See:
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161011_2203/
>
> Thanks
> Gerd
>
>> Am 11.10.2016 um 14:49 schrieb Nester Neworchard:
>> Hi,
>>
>> I've been using some 2-years old version for quite a time, but since I
>> updated my Java recently it stopped to work. I've update it with the
>> newest build, but now I'm no longer to reconnect to session with a
>> Vertica DB. I get following error when selecting Session->Reconnect:
>>
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
>>
>> Exception occurred dispatching Event
>> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
>> on frame0
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>>
>> When using Ctrl+Alt+T instead:
>>
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
>> Exception occurred dispatching Event
>> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
>> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
>> on
>> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
>>
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>>
>> Could that be caused by my configuration being imported from an old
>> install? The connection otherwise works, I'm able to run queries and get
>> results, so far only the Reconnect function makes troubles.
>>
>> Thanks,
>> Michael
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Unable to reconnect to Vertica

Nester Neworchard
Hi Gerd,

Thanks for the update. I've installed the new snapshot and the reconnect functionality is working again.

Thanks!
Michael.

On Tue, Oct 11, 2016 at 10:45 PM, Matt Ferreira <[hidden email]> wrote:
I got the same problem as well(hadn't noticed as I rarely use vertica). I can test tomorrow if Michael hasn't by then

> On Oct 11, 2016, at 4:11 PM, Gerd Wagner <[hidden email]> wrote:
>
> Hi Michael,
>
> I just uploaded a new snapshot containing a fix. Since I wasn't able to
> reproduce the problem it would be nice if you could try it out and let
> me know if it worked.
>
> See:
> https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161011_2203/
>
> Thanks
> Gerd
>
>> Am 11.10.2016 um 14:49 schrieb Nester Neworchard:
>> Hi,
>>
>> I've been using some 2-years old version for quite a time, but since I
>> updated my Java recently it stopped to work. I've update it with the
>> newest build, but now I'm no longer to reconnect to session with a
>> Vertica DB. I get following error when selecting Session->Reconnect:
>>
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:29 PM:
>>
>> Exception occurred dispatching Event
>> java.awt.event.MouseEvent[MOUSE_RELEASED,(370,399),absolute(-838,-517),button=1,modifiers=Button1,clickCount=1]
>> on frame0
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>>
>> When using Ctrl+Alt+T instead:
>>
>> Logged by net.sourceforge.squirrel_sql.client.Main at 10/11/16 2:47 PM:
>> Exception occurred dispatching Event
>> java.awt.event.KeyEvent[KEY_PRESSED,keyCode=84,keyText=T,keyChar=Undefined
>> keyChar,modifiers=Ctrl+Alt,extModifiers=Ctrl+Alt,keyLocation=KEY_LOCATION_STANDARD,rawCode=84,primaryLevelUnicode=116,scancode=20,extendedKeyCode=0x54]
>> on
>> net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1138x347,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@1b3404c,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=167,g=166,b=170],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=255,g=255,b=255],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=16,word=true,wrap=false]
>>
>> java.lang.ClassCastException:
>> net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox$NoCatalogPlaceHolder
>> cannot be cast to java.lang.String at
>> net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel.getSelectedCatalog(CatalogsPanel.java:184)
>> at
>> net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.getSelectedCatalogFromCatalogsComboBox(SessionPanel.java:513)
>> at
>> net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:561)
>> at
>> net.sourceforge.squirrel_sql.client.session.action.ReconnectAction.actionPerformed(ReconnectAction.java:67)
>> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>> ...
>>
>> Could that be caused by my configuration being imported from an old
>> install? The connection otherwise works, I'm able to run queries and get
>> results, so far only the Reconnect function makes troubles.
>>
>> Thanks,
>> Michael
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>>
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...