Datablade List Forum

Re: Visualization tools for Geodetic Datablade?

Posted By: Ken Tanaka
Date: Tuesday, 4 November 2003, at 4:47 p.m.

In Response To: Visualization tools for Geodetic Datablade? (Ken Tanaka)

Thanks for the feedback Jean.

I will look into the mapserver and see how easy it is to connect to the
database.

I did look at the openmap viewer that came with the Geodetic DataBlade,
however the contents for this file weren't documented as well as I'd
have liked for connecting to a database. I did modify a copy of the
configuration file "openmap.properties" in my home directory and
duplicated another layer that looked like a database connection,
substituting in parameters to our own database, but still didn't get a
connection to the geodetic table. An exception was thrown that I still
don't know how to deal with yet:

java.sql.SQLException: Cannot use database commands in an explicit
database connection.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:308)
at com.informix.jdbc.IfxSqli.errorDone(IfxSqli.java:3109)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:2982)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2066)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:1995)
at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:664)
at
com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:275)
at
com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:736)
at
com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:198)
at com.informix.geodetic.util.SQLWorker.connect(SQLWorker.java:284)
at com.informix.geodetic.util.SQLWorker.run(SQLWorker.java:236)

For now the most promising route may be writing desired output to a text
file, and using ArcTools to create viewable geometry from that.

-Ken

Jean Anderson wrote:

>Hi, Ken,
>
>I ran your email by the folks who are the most savvy
>about Geodetic and are summarizing various tips below.
>
>First, one clarification. The ESRI tools will display
>data that uses data types from the Spatial DataBlade,
>so the same ESRI tools that work for Oracle will also
>work for Informix. However, those ESRI tools do not display
>data that uses data types from the Geodetic DataBlade.
>
>An OpenMap application ships with the Geodetic DataBlade.
>See the $INFORMIXDIR/extend/geodetic.<rel>/java directory.
>
>Geodyssey LTD (http://www.geodyssey.com) produces a
>Georamix (Georama for Informix) application for Windows.
>If you're interested, contact John Russell at
>jmahlon@geodyssey.com .
>
>Ed Katibah mentioned an Open Source project called MapServer
>that is freely available from http://mapserver.gis.umn.edu.
>This is an ArcIMS-like spatial webserver. Ed thinks that
>with some help you could get MapServer working with the
>Geodetic DataBlade by using the projection functions
>in the Spatial DataBlade. If you're interested in this and
>need some help, contact Ed at ekatibah@us.ibm.com.
>
>regards,
>
> -jean
>
>Jean T. Anderson
>Extender & DataBlade Development, IBM Data Management
>email: jander@us.ibm.com
>web: http://www.ibm.com/software/data/informix/
>web: http://www.ibm.com/software/data/developer/informix
>
>
>
>

Messages In This Thread

• Visualization tools for Geodetic Datablade?
  Ken Tanaka -- Monday, 3 November 2003, at 7:03 p.m.
  • Re: Visualization tools for Geodetic Datablade?
    Jean Anderson -- Tuesday, 4 November 2003, at 2:29 p.m.
  • Re: Visualization tools for Geodetic Datablade?
    Ken Tanaka -- Tuesday, 4 November 2003, at 4:47 p.m.
    • Re: Visualization tools for Geodetic Datablade?
      Jean Anderson -- Tuesday, 4 November 2003, at 5:18 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.