Bug in Squirrel version 3.7.1 when we look after the source of view

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug in Squirrel version 3.7.1 when we look after the source of view

Cheick DIENG
Hi,
How to get source SQL queries for the views in squirrel client in version 3.7.1
We encoured a bug when we select the source tab in the object tab like  << ExampleExceptionFormatter: exception message was: Pas de valeur spécifiée pour le paramètre 2.>>
Thanks for your help.


Cheikh DIENG - Externe
GIRC Agirc-Arrco
Direction Technique /Architecture Technique, Industrialisation et Performance

Socle Middleware & SGBD - Ormes

Tél: 02 38 42 80 79
[hidden email]

______________________________________________________________________________________
L'intégrité de ce message et de toutes ses pièces jointes n'étant pas entièrement assurée sur internet,
le GIRC Agirc-Arrco ne peut pas être tenu responsable de son contenu.
Toute utilisation de ce message non conforme à sa destination est interdite sauf autorisation expresse.
Si vous n'êtes pas destinataire de ce message, merci de le détruire et d'en avertir l'expéditeur.
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯



------------------------------------------------------------------------------
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
|

Re: Bug in Squirrel version 3.7.1 when we look after the source of view

Gerd Wagner-3
Could you please post the complete stacktrace of your error message. The
stacktrace can be found at
main menu -> Windows -> View SQuirreL Logs

Thanks
Gerd

Am 13.12.2016 um 11:07 schrieb Cheick DIENG:

> Hi,
> How to get source SQL queries for the views in squirrel client in
> version 3.7.1
> <http://stackoverflow.com/questions/17530117/how-to-get-source-sql-queries-for-the-views-in-squirrel-client-3-4-0>
>
> We encoured a bug when we select the source tab in the object tab like
>  << ExampleExceptionFormatter: exception message was: Pas de valeur
> spécifiée pour le paramètre 2.>>
> Thanks for your help.
>
>
> *Cheikh DIENG - Externe*
> GIRC Agirc-Arrco
> Direction Technique /Architecture Technique, Industrialisation et
> Performance
> Socle Middleware & SGBD - *Ormes*
>
> Tél: 02 38 42 80 79
> [hidden email]
>
> ______________________________________________________________________________________
>
> L'intégrité de ce message et de toutes ses pièces jointes n'étant pas
> entièrement assurée sur internet,
> le GIRC Agirc-Arrco ne peut pas être tenu responsable de son contenu.
> Toute utilisation de ce message non conforme à sa destination est
> interdite sauf autorisation expresse.
> Si vous n'êtes pas destinataire de ce message, merci de le détruire et
> d'en avertir l'expéditeur.
> ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
|

Re: Bug in Squirrel version 3.7.1 when we look after the source of view

Gerd Wagner-3
This bug should be fixed but it is not yet released in a version. Please
try out the latest snapshot here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161223_2019/
and let me know if it works.

Thanks
Gerd

Am 27.12.2016 um 12:10 schrieb Cheick DIENG:

> 2016-12-27 12:03:17,516 [AWT-EventQueue-1] ERROR
> net.sourceforge.squirrel_sql.client.session.MessagePanel  -
> privateShowMessage: Exception was Pas de valeur spécifiée pour le
> paramètre 2.
> org.postgresql.util.PSQLException: Pas de valeur spécifiée pour le
> paramètre 2.
>         at
> org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:249)
>
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:270)
>
>         at
> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
>         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
>         at
> org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
>
>         at
> org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.FormattedSourceTab$FormattedSourcePanel.load(FormattedSourceTab.java:150)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab.refreshComponent(BaseSourceTab.java:144)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseObjectTab.select(BaseObjectTab.java:113)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeTabbedPane.selectCurrentTab(ObjectTreeTabbedPane.java:151)
>
>         at
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel$TabbedPaneListener.stateChanged(ObjectTreePanel.java:1062)
>
>         at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)
>         at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown
> Source)
>         at
> javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)
>         at
> javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)
>         at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)
>         at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)
>         at
> javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(Unknown
> Source)
>         at java.awt.AWTEventMulticaster.mousePressed(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.dispatchEventImpl(Unknown Source)
>         at java.awt.EventQueue.access$200(Unknown Source)
>         at java.awt.EventQueue$3.run(Unknown Source)
>         at java.awt.EventQueue$3.run(Unknown Source)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
>         at
> java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
>         at java.awt.EventQueue$4.run(Unknown Source)
>         at java.awt.EventQueue$4.run(Unknown Source)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> java.security.ProtectionDomain$1.doIntersectionPrivilege(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)

------------------------------------------------------------------------------
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