Benjamin thank you, that solved the problem. Fields also have to be lover case. <br><br><div class="gmail_quote">On Mon, May 17, 2010 at 10:33 AM, Benjamin Ducke [via OSGeo.org] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5064155&i=0" target="_top" rel="nofollow">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
It could be a problem with captial letters in table names.
<br>Towards the bottom of your error message it reads:
<br><br></div><div class="im">Caused by: org.postgresql.util.PSQLException: ERROR: relation
<br>"public.TstPostGIS" does not exist
<br><br></div><div class="im">Try storing that table as "public.tstpostgis" (all small caps) instead.
<br>Handling capitalization in SQL is an absolute pain in the a**
<br>because every SQL server has its own ideas about how that should
<br>be done.
<br><br>Hope that helps.
<br><br>Ben
<br><br>----- Original Message -----
<br></div><div class="im">From: "BERNO84" <<a href="http://user/SendEmail.jtp?type=node&node=5064137&i=0" rel="nofollow" target="_blank" link="external">[hidden email]</a>>
<br>To: "gvsig internacional" <<a href="http://user/SendEmail.jtp?type=node&node=5064137&i=1" rel="nofollow" target="_blank" link="external">[hidden email]</a>>
<br>Sent: Monday, May 17, 2010 10:10:31 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna
<br></div><div><div></div><div class="h5">Subject: Re: [Gvsig_english] gvSIG 1.9 error message: Can`t initialize writer: POSTGIS Writer
<br><br><br>Hi, I have the same problem. Character table is set ok. This is what I recive
<br>in error log:
<br><br>Can´t initialize writer: PostGIS Writer
<br> at
<br>com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:104)
<br> at
<br>com.iver.cit.gvsig.gui.cad.MyFinishAction.performAction(MyFinishAction.java:204)
<br> at
<br>jwizardcomponent.DefaultJWizardComponents.finishButton_actionPerformed(Unknown
<br>Source)
<br> at jwizardcomponent.DefaultJWizardComponents$4.actionPerformed(Unknown
<br>Source)
<br> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
<br> at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
<br> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
<br> at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
<br> at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
<br> at java.awt.Component.processMouseEvent(Unknown Source)
<br> at javax.swing.JComponent.processMouseEvent(Unknown Source)
<br> at java.awt.Component.processEvent(Unknown Source)
<br> at java.awt.Container.processEvent(Unknown Source)
<br> at java.awt.Component.dispatchEventImpl(Unknown Source)
<br> at java.awt.Container.dispatchEventImpl(Unknown Source)
<br> at java.awt.Component.dispatchEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
<br> at java.awt.Container.dispatchEventImpl(Unknown Source)
<br> at java.awt.Window.dispatchEventImpl(Unknown Source)
<br> at java.awt.Component.dispatchEvent(Unknown Source)
<br> at java.awt.EventQueue.dispatchEvent(Unknown Source)
<br> at
<br>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
<br> at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
<br> at java.awt.Dialog$1.run(Unknown Source)
<br> at java.awt.Dialog$3.run(Unknown Source)
<br> at java.security.AccessController.doPrivileged(Native Method)
<br> at java.awt.Dialog.show(Unknown Source)
<br> at java.awt.Component.show(Unknown Source)
<br> at java.awt.Component.setVisible(Unknown Source)
<br> at java.awt.Window.setVisible(Unknown Source)
<br> at java.awt.Dialog.setVisible(Unknown Source)
<br> at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)
<br> at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)
<br> at com.iver.cit.gvsig.CreateNewLayer.execute(CreateNewLayer.java:137)
<br> at
<br>com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)
<br> at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:678)
<br> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
<br> at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
<br> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
<br> at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
<br> at javax.swing.AbstractButton.doClick(Unknown Source)
<br> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
<br> at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
<br>Source)
<br> at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
<br> at java.awt.Component.processMouseEvent(Unknown Source)
<br> at javax.swing.JComponent.processMouseEvent(Unknown Source)
<br> at java.awt.Component.processEvent(Unknown Source)
<br> at java.awt.Container.processEvent(Unknown Source)
<br> at java.awt.Component.dispatchEventImpl(Unknown Source)
<br> at java.awt.Container.dispatchEventImpl(Unknown Source)
<br> at java.awt.Component.dispatchEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
<br> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
<br> at java.awt.Container.dispatchEventImpl(Unknown Source)
<br> at java.awt.Component.dispatchEvent(Unknown Source)
<br> at java.awt.EventQueue.dispatchEvent(Unknown Source)
<br> at
<br>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
<br> at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
<br> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
<br> at java.awt.EventDispatchThread.run(Unknown Source)
<br>Caused by: org.postgresql.util.PSQLException: ERROR: relation
<br>"public.TstPostGIS" does not exist
<br><br> at
<br>org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
<br> at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
<br> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
<br> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
<br> at
<br>org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
<br> at
<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
<br> at
<br>org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298)
<br> at
<br>com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:84)
<br> ... 67 more
<br><br>I'm using gvSig 1.9 OADE 2010 beta on ubuntu 9.10. Is this bug or I'm not
<br>setting something right? Importing from postGIS works fine.
<br>--
<br>View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064088.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064088.html</a><br>
Sent from the gvSIG international mailing list archive at Nabble.com.
<br>_______________________________________________
<br>Gvsig_internacional mailing list
<br></div></div><a href="http://user/SendEmail.jtp?type=node&node=5064137&i=2" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br><div class="im"><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" rel="nofollow" link="external" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
<br><br></div>------
<br><div class="im">Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit <a href="http://iso26300.info" rel="nofollow" link="external" target="_blank">http://iso26300.info</a> for more information.
<br><br>_______________________________________________
<br>Gvsig_internacional mailing list
<br></div><a href="http://user/SendEmail.jtp?type=node&node=5064137&i=3" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br><div class="im"><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" rel="nofollow" link="external" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
<br><br>
</div><hr noshade size="1" color="#cccccc">
<div style="color: rgb(102, 102, 102); font-family: tahoma,geneva,helvetica,arial,sans-serif; font-style: normal; font-variant: normal; font-weight: normal; font-size: 11px; line-height: normal; font-size-adjust: none; font-stretch: normal;">
View message @ <a href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064137.html" target="_blank" rel="nofollow" link="external">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064137.html</a>
<br>To unsubscribe from Re: gvSIG 1.9 error message: Can`t initialize writer: POSTGIS Writer, <a target="_blank" rel="nofollow" link="external">click here</a>.
</div>
<br>
</blockquote></div><br>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064155.html">Re: gvSIG 1.9 error message: Can`t initialize writer: POSTGIS Writer</a><br>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-international-f2009903.html">gvSIG international mailing list archive</a> at Nabble.com.<br>