[OpenMap Users] accessing mysql using dblocationhandler, adding it on the layer menu, and rendering pts.

From: <theodore.wong_at_comcast.net>
Date: Fri, 18 Jan 2008 20:28:50 +0000

Hi,

I'm trying to connect to mysql using dblocationhandler. I place the in the openmap.properties
but it gives me a "cannot create" reply at run time.

  # In the section for the LocationLayer:
  locationLayer.locationHandlers=dblocationhandler
  
  dblocationhandler.class=com.bbn.openmap.layer.location.db.DBLocationHandler
  dblocationhandler.locationColor=FF0000
  dblocationhandler.nameColor=008C54
  dblocationhandler.showNames=false
  dblocationhandler.showLocations=true
  dblocationhandler.jdbcDriver=oracle.jdbc.driver.OracleDriver
  dblocationhandler.jdbcString=jdbc login string
  dblocationhandler.userName=username
  dblocationhandler.userPassword=password
  dblocationhandler.locationQueryString="select * from table"

Does anyone know if this is all that's required to access the data?
And, how do I add this to the layers menu like the "cities" layer?

Thanks,

Ted

--
[To unsubscribe to this list send an email to "majdart_at_bbn.com"
with the following text in the BODY of the message "unsubscribe openmap-users"]

Received on Fri Jan 18 2008 - 15:37:11 EST