Oracle Maps HTML5 Javascript API Reference

 
Class: ServerJDBCTheme

OM.server. ServerJDBCTheme

new ServerJDBCTheme(name)

Constructs a new dynamic sql theme (JDBC theme). For example:


    var jdbcTCounties= new OM.server.ServerJDBCTheme('theme_jdbc_counties');

After a ServerJDBCTheme is instantiated, other attributes can then be added. For example:


    jdbcTCounties.setDataSourceName('mvdemo');
    jdbcTCounties.setSRID('8307');
    jdbcTCounties.setGeometryColumnName('geom');
    var sql='select totpop,poppsqmi, county, state_abrv, geom from counties';
    jdbcTCounties.setQuery(sql);
    jdbcTCounties.addInfoColumn({column: 'state_abrv', name:'State'});
    jdbcTCounties.addInfoColumn({column: 'county', name:'County'});

Such a theme may be added into a server map request instance.
For example:


  • var req = new OM.server.ServerMapRequest(baseURL);

  • req.addTheme(jdbcTCounties);


Warning: Since ServerJDBCTheme will send a large number of non-reusable SQL queries to the database,
it is recommended to use ServerPredefinedTheme instead.

Parameters:
Name Type Description
name String

The name of the JDBC theme; the theme
will be built dynamically using the attrbites in this class.

Extends

Methods

addInfoColumn(ic)

Adds an info-column to the theme.

Parameters:
Name Type Description
ic Object

The JSON object representing a new info column in the
format of 

 {columnName: 'totpop', displayName: 'Population'}
.

getDataSourceName()

Get the current MapViewer data source name.

Inherited From:
Returns:

returns the name of the data source.

Type
String

setDataSourceName(dsrcName)

Set the name of the MapViewer data source where this theme is
defined.

Parameters:
Name Type Description
dsrcName String

The name of the MapViewer data source.
Inherited From:

setExecuteAsis(flag)

Sets whether the query should be executed as-is on the server side. Default is false.
By default (i.e., false), a subsequent spatial filter is applied to only fetch the needed features to optimize the performance.

Parameters:
Name Type Description
flag Boolean

A true or false value. Default is false

setGeometryColumnName(name)

Sets the geometry column name in the query result set.

Parameters:
Name Type Description
name String

The name of the geometry column name in the query result set.

setLabelColumnName(name)

Set the label column name

Parameters:
Name Type Description
name String

The lable column name
Returns:
Type
undefined

setLabelStyleName(name)

Set the label style name

Parameters:
Name Type Description
name String

The lable style name
Returns:
Type
undefined

setName(nm)

Set the theme name

Parameters:
Name Type Description
nm String

The theme name to set
Inherited From:

setQuery(sql)

Sets the dynamic SQL to be executed for this theme on the server.

Parameters:
Name Type Description
sql String

The SQL string. Such as:
SELECT s.geom.sdo_point.x long_loc,s.geom.sdo_point.y lat_loc,state,fatalities,injuries,loss
FROM wind_3857 s

setRenderingStyleName(name)

Sets the rendering style name.

Parameters:
Name Type Description
name String

The rendering style name.

setRenderingStyleValueColumns(columns)

Sets the rendering style value columns

Parameters:
Name Type Description
columns String

The comma separated value columns to be used for rendering.

setSRID(srid)

Sets the jdbc theme srid

Parameters:
Name Type Description
srid String

The jdbc theme srid.

setXColumnName(name)

Sets the x column name in the query result set.

Parameters:
Name Type Description
name String

The name of the x column in the query result set.

setYColumnName(name)

Sets the y column name in the query result set.

Parameters:
Name Type Description
name String

The name of the y column in the query result set.