I am connecting it with postgresql and trying to run query $view after
connecting but got error. i am trying to import OpenStreetMap data from the
database.
> *java.lang.Error: Error : ST_GeomFromText('POLYGON ((0 0, 0 348, 460 348,
> 460 0, 0 0))',0)*
> *ERROR: syntax error at or near "ST_GeomFromText"*
> * Position: 1 *
> * at
> com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:95)*
> * at
> com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.executeAdhocQuery(PostgisDSConnection.java:80)
> *
> * at
> com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.execute(PostgisDSConnection.java:49)*
> * at
> com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayer(RunDatastoreQueryPlugIn.java:78)
> *
> * at
> com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayerable(RunDatastoreQueryPlugIn.java:47)*
> * at
> com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:33)
> *
> * at
> com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152)**
> at java.lang.Thread.run(Thread.java:724)*
Please help me out. i
On Fri, Nov 22, 2013 at 1:10 PM, Michaël Michaud <michael.mich...@free.fr>wrote:
> Hi sukhjit
>
> - What is your operating system?
> tried on linux unbutu 13.04
>
>> - Your java version?
>>
> openjdk
>
>> - What have you installed - OpenJUMP version, what plugin version,
>> from where did you get it?
>>
> from sourceforge website
>
>> - What is the problem? Making connection to PostGIS, finding the
>> tables, reading the data, what?
>>
> i have installed the postgis plugin but unable to find postgis linkage or
> it may be possible i may not be fully educated to use the plugin.
>
> Which plugin did you install? Most PostGIS capabilities are included
> in CORE and PLUS version of OpenJUMP without need to add external plugins.
> To read a PostGIS table from OpenJUMP, you need to choose
> - File > Open... (choose "Data Store Layer")
> or
> - File > Run DataStore Query...
> please see also documentation. You have a short tutorial here :
>
> https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=Working_with_Databases
> and here is a video (a bit old, some menu items have moved)
> http://www.pgcon.org/2009/schedule/events/174.en.html
>
> Michaël
>
> - Did you try with version 1.6 or later? If not, why?
>>
> >OpenJUMP-1.6.3-rev.3576-CORE-1380520973142
>
>>
>>
>
> still i will re install everything and do it again.
>
> Thanks
>
>> Regards,
>>
>>
>>
>> -Jukka Rahkonen-
>>
>>
>>
>> sukhjit
>>
>> wrote:
>>
>> Any body could help me in resolving the issues with OSM and Postgis
>> plugin in Openjump
>>
>>
>>
>> thanks
>>
>>
>>
>> --
>> Er. Sukhjit Singh Sehra
>>
>>
>> ------------------------------------------------------------------------------
>> Shape the Mobile Experience: Free Subscription
>> Software experts and developers: Be at the forefront of tech innovation.
>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>> conversations that shape the rapidly evolving mobile landscape. Sign up
>> now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Jump-pilot-devel mailing list
>> Jump-pilot-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>
>>
>
>
> --
> Er. Sukhjit Singh Sehra
> Assistant Professor
> Dept of Computer Science Engg.
> Guru Nanak Dev Engineering College, Ludhiana, Punjab
> Mobile No:- 09855959200
> *In your free time kindly visit Sikh-relics.com - A Gallery of Blessed
> Relics of Sikh Guru Sahib
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Jump-pilot-devel mailing
> listJump-pilot-devel@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up
> now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
--
Er. Sukhjit Singh Sehra
Assistant Professor
Dept of Computer Science Engg.
Guru Nanak Dev Engineering College, Ludhiana, Punjab
Mobile No:- 09855959200
*In your free time kindly visit Sikh-relics.com - A Gallery of Blessed
Relics of Sikh Guru Sahib
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel