On Thu, Apr 28, 2011 at 6:44 PM, Andrea Aime <[email protected]> wrote: > On Thu, Apr 28, 2011 at 6:35 PM, Justin Deoliveira <[email protected]> > wrote: >> Hi all, >> I wanted to get some feedback on a problem i am trying to solve and a >> possible solution. First the problem. >> It comes out of working on the teradata datastore. The td database has a >> feature called "query banding". It is very simple in nature. It is basically >> just a statement that sets some key value pairs before another statement is >> executed, or set some key value pairs for the life of a connection. A common >> example is to set the name of the application. So one might do: >> SET QUERY_BAND = 'Application = geotools`; >> SELECT * FROM ...;
And oh, another thing. That SET will conceivably set the param for the connection's entire life. Connections are pooled so... how do you plan to remove those settings once you're done using them? If you are using query banding on some data access and none in others, the others will inherit that set you executed before Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
