[postgis-users] Persistente of Jdbc Connection

[Nicolas Ribot]

Hi Noredine,

I assume you are using GeoTools to access Postgis.
Did you try to explicitely close your JDBC connection, by asking the
connectionPoolManager to do so in a finally block, somethinh like:
...
ConnectionPoolManager.getInstance().closeAll();
...
Nicolas

On 4/13/06, Noredine Berrached <nberrached at yahoo.com> wrote:
> Hi everyone,
> I've got a problem with my application (on Fedora core
> 4, postgresql serveur 8.0.7, postgis 1.1.1), I launch
> a periodic task with the Java Object TimerTask every
> two seconds, to change the style of the visible
> objects of the visible layer. The color change to
> green to red, and the next time red to green.
> The problem is that at each change of style, my
> application open one or more a connection to the
> server and never close it, then after a while a java
> exception appears "too many clients connected".
> How can I manage the connections?
> this the code that I use to connect to the server, I
> store the layer in a Vector:
> //the connection parameters->
> String database;
> String namespace =(String)params.get("namespace");
> String host = (String)params.get("host");
> int port = ((Integer)params.get("port")).intValue();
> String dbname = (String)params.get("database");
> String schema = (String)params.get("schema");
> String user = (String)params.get("user");
> String password =(String)params.get("password");
> factory = new PostgisConnectionFactory(host, port,
> dbname);
> JDBCDataStoreConfig config =
> JDBCDataStoreConfig.createWithNameSpaceAndSchemaName(
> namespace, schema );
>
> //new connectionPool->
> pool = factory.getConnectionPool(user, password);
> //new DataStore->
> pgDatastore = new PostgisDataStore(pool, config,
> PostgisDataStore.OPTIMIZE_SAFE);
> m_vect_feature_source = new Vector();
> FeatureSource fsRoads =
> pgDatastore.getFeatureSource("roads");
> FeatureSource fsStreams =
> pgDatastore.getFeatureSource("streams");
> FeatureSource fsBugs =
> pgDatastore.getFeatureSource("bugsites");
> FeatureSource fsArch =
> pgDatastore.getFeatureSource("archsites");
> FeatureSource fsRestricted =
> pgDatastore.getFeatureSource("rstrct");
>
> m_vect_feature_source.add(fsRoads);
> m_vect_feature_source.add(fsStreams);
> m_vect_feature_source.add(fsBugs);
> m_vect_feature_source.add(fsArch);
> m_vect_feature_source.add(fsRestricted);
>
> Here is the code that the periodic task uses :
> //first I store the visible object in a FeatureResults
> with a Filter
> ...(too long)
> //storage of the identifier in a Vector, and swap of
> the color ->
> FeatureResults fr = fsRestricted.getFeatures(filt);
> if (fr.getCount() == 0)
> {
> System.out.println("No feature selected.");
> }else{
> FeatureReader reader = fr.reader();
> Feature f = null;
> Vector vec_ident_feature = new Vector();
> while (reader.hasNext())
> {
> f = (Feature) reader.next();
> vec_ident_feature.add(f.getAttribute(0));
> }
> FeatureType ft_typ = f.getFeatureType() ;
> if(state==1)
> setColorOnDeterminedFeature(ft_typ,
>  ft_typ.getAttributeType(0).getName(),
> defaultStyle,vec_ident_feature,colorTrue,colorFalse);
> else
> setColorOnDeterminedFeature(ft_typ,
> ft_typ.getAttributeType(0).getName(),
> defaultStyle,vec_ident_feature,colorFalse,colorTrue);
> state = 1 - state;
> }
>
> Finally the function that applicates a style on the
> selected objects :
> GeometryAttributeType l_geom_attrib_type =
> ft_type_source.getDefaultGeometry();
> StyleBuilder sb = new StyleBuilder();
> Style mapStyle = null;
> Style mapStyle_2 = null;
> Long l_val;
> long val_orig, val_calc;
> try
> {
> StyleFactory styleFactory =
> StyleFactory.createStyleFactory();
> mapStyle = styleFactory.createStyle();
> //the "true Style" depends of true Color
> Mark markTrue =
> sb.createMark(StyleBuilder.MARK_CIRCLE, colorTrue,
> colorFalse, 1);
> Graphic graphicsTrue = sb.createGraphic(null,
> markTrue, null);
> PointSymbolizer pointTrue=
> sb.createPointSymbolizer(graphicsTrue);
> //the "false Style" depends of False Color
> Mark markFalse =
> sb.createMark(StyleBuilder.MARK_CIRCLE, colorFalse,
> colorTrue, 1);
> Graphic graphicFalse = sb.createGraphic(null,
> markFalse, null);
> PointSymbolizer pointFalse=
> sb.createPointSymbolizer(graphicFalse);
>
> FilterFactory filterFactory =
> FilterFactory.createFilterFactory();
> CompareFilter filter = null;
> FeatureTypeStyle fts = null;
> Rule rule_other;
> for(int i=0;i<vec_ident_feature.size();i++)
> {
> try
>                     {
>                         filter =
> filterFactory.createCompareFilter(CompareFilter.COMPARE_EQUALS);
>
> filter.addLeftValue(filterFactory.createAttributeExpression(ft_type_source,ft_ident));
>
>                         l_val =
> (Long)vec_ident_feature.get(i);
>                         val_orig = l_val.longValue();
>                         val_calc= (val_orig/2)*2;
>
>
> filter.addRightValue(filterFactory.createLiteralExpression(val_orig));
>                         //System.out.println("val_orig
> :"+val_orig+" val_calc :"+val_calc + "ft_ident
> :"+ft_ident+ (Long)vec_ident_feature.get(i));
>                         if(val_orig==val_calc)
>                         {
>
>                             rule_other =
> sb.createRule(pointTrue);
>                         }else{
>                             rule_other =
> sb.createRule(pointFalse);
>                         }
>                         rule_other.setFilter(filter);
>                         if(fts==null)
>                             fts =
> sb.createFeatureTypeStyle(null, rule_other);
>                         else
>                             fts.addRule(rule_other);
>                     }
>                     catch (IllegalFilterException e)
>                     {
>                         e.printStackTrace();
>                     }
>                 }
>
>                 //valeur indeterminé, style par defaut
>                 /*{
>                     Mark markFalse =
> sb.createMark(StyleBuilder.MARK_CIRCLE, colorFalse,
> colorTrue, 1);
>                     Graphic graphicFalse =
> sb.createGraphic(null, markFalse, null);
>                     PointSymbolizer pointFalse=
> sb.createPointSymbolizer(graphicFalse);
>
>                     Rule ruleFalse =
> sb.createRule(pointFalse);
>                     //StyleVisitor
>                     ruleFalse.setIsElseFilter(true);
>                     ruleFalse.setName("Color False");
>                     fts.addRule(ruleFalse);
>                 }*/
>
>                 Style sty =
> styleFactory.createStyle();
>                 sty.addFeatureTypeStyle(fts);
>
> //m_styled_map_pane.getMapContext().getLayer(2).setStyle(sty);
>                 m_map_layer.setStyle(sty);
>                 //m_styled_map_pane.updateUI();
>                 //mapStyle.addFeatureTypeStyle(fts);
>             }
>             catch( Exception e )
>             {
>               e.printStackTrace();
>             }
>
>
>
>
>
>
> ___________________________________________________________________________
> Faites de Yahoo! votre page d'accueil sur le web pour retrouver directement vos services préférés : vérifiez vos nouveaux mails, lancez vos recherches et suivez l'actualité en temps réel.
> Rendez-vous sur http://fr.yahoo.com/set
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>