have you tried to use the layer\add Datastore laye function?
It uses the Framework developed lately by Vividsolutions

As far as i know there is on the projet sigle website also an SQL Query 
plugin

as i am not familar with Databases, maybe someone else can help

stefan

Eric Lemesre wrote:

> Hi,
>
> I build Postgis layers with BeanShell Script.
>
> What is the better way to build layer with java code?
>
> I try :
>  - build pgSD with common properties (Host, database, user, password)
>  - pgQuery = new  PostGISDataSourceQuery(new 
> PostGISDataSource(),query,layerName);
>  - Update pgSD properties (table, where condition, ...)
>  - pgQuery.getDataSource().setProperties(pgDS.getProperties());
>  - Build layer with wc.layerManager.addLayer("Fond de carte", 
> layerName,pgQuery.getDataSource ().getConnection().executeQuery(query));
>  - get Layer reference and put DataSourceQuery !! ( 
> curentLayer.setDataSourceQuery(pgQuery); )
>
> It work but it is a little complicate.
>
> Thank
> Eric
>
>------------------------------------------------------------------------
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by: Splunk Inc.
>Still grepping through log files to find problems?  Stop.
>Now Search log events and configuration files using AJAX and a browser.
>Download your FREE copy of Splunk now >> http://get.splunk.com/
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Jump-pilot-devel mailing list
>Jump-pilot-devel@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>  
>


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to