[Gvsig_english] gvSIG 1.9 error message: Can`t initialize writer: POSTGIS Writer

[BERNO84]

Benjamin thank you, that solved the problem. Fields also have to be lover
case.

On Mon, May 17, 2010 at 10:33 AM, Benjamin Ducke [via OSGeo.org] <
ml-node+5064137-481168084-541499 at n2.nabble.com<ml-node%2B5064137-481168084-541499 at n2.nabble.com>
> wrote:

> It could be a problem with captial letters in table names.
> Towards the bottom of your error message it reads:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "public.TstPostGIS" does not exist
>
> Try storing that table as "public.tstpostgis" (all small caps) instead.
> Handling capitalization in SQL is an absolute pain in the a**
> because every SQL server has its own ideas about how that should
> be done.
>
> Hope that helps.
>
> Ben
>
> ----- Original Message -----
> From: "BERNO84" <[hidden email]<http://user/SendEmail.jtp?type=node&node=5064137&i=0>>
>
> To: "gvsig internacional" <[hidden email]<http://user/SendEmail.jtp?type=node&node=5064137&i=1>>
>
> Sent: Monday, May 17, 2010 10:10:31 AM GMT +01:00 Amsterdam / Berlin / Bern
> / Rome / Stockholm / Vienna
> Subject: Re: [Gvsig_english] gvSIG 1.9 error message: Can`t initialize
> writer: POSTGIS Writer
>
>
> Hi, I have the same problem. Character table is set ok. This is what I
> recive
> in error log:
>
> Can´t initialize writer: PostGIS Writer
>         at
> com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:104)
>
>         at
> com.iver.cit.gvsig.gui.cad.MyFinishAction.performAction(MyFinishAction.java:204)
>
>         at
> jwizardcomponent.DefaultJWizardComponents.finishButton_actionPerformed(Unknown
>
> Source)
>         at
> jwizardcomponent.DefaultJWizardComponents$4.actionPerformed(Unknown
> Source)
>         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
> com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
>
>         at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
> Source)
>         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
>
>         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
>
>         at java.awt.Dialog$1.run(Unknown Source)
>         at java.awt.Dialog$3.run(Unknown Source)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at java.awt.Dialog.show(Unknown Source)
>         at java.awt.Component.show(Unknown Source)
>         at java.awt.Component.setVisible(Unknown Source)
>         at java.awt.Window.setVisible(Unknown Source)
>         at java.awt.Dialog.setVisible(Unknown Source)
>         at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)
>         at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)
>         at
> com.iver.cit.gvsig.CreateNewLayer.execute(CreateNewLayer.java:137)
>         at
> com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)
>
>         at
> com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:678)
>         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.AbstractButton.doClick(Unknown Source)
>         at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
>         at
> javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
> Source)
>         at java.awt.AWTEventMulticaster.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.Component.dispatchEvent(Unknown Source)
>         at java.awt.EventQueue.dispatchEvent(Unknown Source)
>         at
> com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
>
>         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)
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "public.TstPostGIS" does not exist
>
>         at
> org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
>         at
> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
>         at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
>         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
>
>         at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
>
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
>
>         at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298)
>
>         at
> com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:84)
>
>         ... 67 more
>
> I'm using gvSig 1.9 OADE 2010 beta on ubuntu 9.10. Is this bug or I'm not
> setting something right? Importing from postGIS works fine.
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064088.html
> Sent from the gvSIG international mailing list archive at Nabble.com.
> _______________________________________________
> Gvsig_internacional mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5064137&i=2>
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
> ------
> Files attached to this email may be in ISO 26300 format (OASIS Open
> Document Format). If you have difficulty opening them, please visit
> http://iso26300.info for more information.
>
> _______________________________________________
> Gvsig_internacional mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5064137&i=3>
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
> ------------------------------
>  View message @
> http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064137.html
> To unsubscribe from Re: gvSIG 1.9 error message: Can`t initialize writer:
> POSTGIS Writer, click here<http://osgeo-org.1803224.n2.nabble.com/subscriptions/Unsubscribe.jtp?code=YmVybm84NEBnbWFpbC5jb218NTA2NDA4OHw0NzA2MzkwNjc=>.
>
>
>

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064155.html
Sent from the gvSIG international mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100517/b2890e9f/attachment.htm