[udig-devel] How can I add Layers from PostGIS?

[오명운]

 Hi...

I installed PostgreSQL 8.1.4, PostGIS 1.1.3, u-Dig 1.0.6 on my WindowsXP
computer.

In u-Dig,
I tried to add layers from PostGIS using 'File>New>New Layer>PostGIS'.
I typed the PostGIS Server Information(Host, Username, Password, Database,
Schema) and clicked 'Next' button in 'Add layers to Map' pop-up window.

Then u-Dig shows Error messages like below.
------
org.geotools.data.DataSourceException: ERROR: function postgis_version()
does not exist

 at org.geotools.data.postgis.PostgisDataStore.guessDataStoreOptions (
PostgisDataStore.java:345)

 at org.geotools.data.postgis.PostgisDataStore.<init>(PostgisDataStore.java
:259)

 at org.geotools.data.postgis.PostgisDataStore.<init>(PostgisDataStore.java
:233)

 at
org.geotools.data.postgis.PostgisDataStoreFactory.createDataStoreInternal(
PostgisDataStoreFactory.java:219)

 at org.geotools.data.postgis.PostgisDataStoreFactory.createDataStore(
PostgisDataStoreFactory.java:195)

 at net.refractions.udig.catalog.internal.postgis.PostGISServiceImpl.getDS(
PostGISServiceImpl.java:153)

 at net.refractions.udig.catalog.internal.postgis.PostGISServiceImpl.getInfo
(PostGISServiceImpl.java:122)

 at
net.refractions.udig.catalog.internal.postgis.ui.PostGisWizardPage.getResources
(PostGisWizardPage.java:541)

 at net.refractions.udig.catalog.internal.ui.ConnectionPage.getResources(
ConnectionPage.java:72)

 at net.refractions.udig.catalog.internal.ui.ConnectionPage$1.run(
ConnectionPage.java:127)

 at org.eclipse.jface.operation.ModalContext.runInCurrentThread(
ModalContext.java:346)

 at org.eclipse.jface.operation.ModalContext.run (ModalContext.java:291)

 at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:830)

 at net.refractions.udig.catalog.internal.ui.ConnectionPage.getNextPage(
ConnectionPage.java:147)

 at org.eclipse.jface.wizard.WizardDialog.nextPressed (WizardDialog.java
:747)

 at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java
:345)

 at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:556)

 at org.eclipse.swt.widgets.TypedListener.handleEvent (TypedListener.java
:90)

 at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

 at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)

 at org.eclipse.swt.widgets.Display.runDeferredEvents (Display.java:3125)

 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)

 at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)

 at org.eclipse.ui.internal.Workbench.runUI (Workbench.java:1663)

 at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java
:367)

 at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)

 at net.refractions.udig.internal.ui.UDIGApplication.run (
UDIGApplication.java:28)

 at org.eclipse.core.internal.runtime.PlatformActivator$1.run(
PlatformActivator.java:226)

 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java
:376)

 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java
:163)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

 at java.lang.reflect.Method.invoke(Unknown Source)

 at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)

 at org.eclipse.core.launcher.Main.basicRun (Main.java:278)

 at org.eclipse.core.launcher.Main.run(Main.java:973)

 at org.eclipse.core.launcher.Main.main(Main.java:948)

Caused by: org.postgresql.util.PSQLException: ERROR: function
postgis_version() 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.executeQuery(
AbstractJdbc1Statement.java:233)

 at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(
AbstractJdbc1Statement.java :221)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

 at java.lang.reflect.Method.invoke(Unknown Source)

 at
org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(
PooledConnectionImpl.java:392)

 at $Proxy1.executeQuery(Unknown Source)

 at org.geotools.data.postgis.PostgisDataStore.guessDataStoreOptions(
PostgisDataStore.java:292)

 ... 37 more
----------------
I guessed this was just about configuration problem.

So I copied 'postgis_1.1.3.jar' and 'postgresql-8.1-405.jdbc3.jar' to the
directory 'C:\Program Files\uDig\1.0.6\eclipse\jre\lib\ext', but it was in
vain.

How can I add layers from PostGIS?

Thank you for reading my poor English e-mail. ;)

Have a nice day~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.refractions.net/pipermail/udig-devel/attachments/20060907/e5d2ac5c/attachment.html