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

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@bbn.com"
with the following text in the BODY of the message "unsubscribe openmap-users"]