Can you tell me what documentation page you went looking in - and I can add it
:-)
--
Jody Garnett
On Monday, 25 March 2013 at 7:14 PM, Ron Lindhoudt wrote:
> Jody,
>
> Thanks for your answer.
>
> I finally got it working with:
> org.geotools.jdbc.level=FINE
> org.geotools.jdbc.SQLDialect.level=FINE
>
> This does not work: org.geotools.jdbc.logging.level=FINE
>
> It is not clear from any documentation.
>
> Ron
> From: Jody Garnett <[email protected] (mailto:[email protected])>
> To: Ron Lindhoudt <[email protected] (mailto:[email protected])>
> Cc: "[email protected]
> (mailto:[email protected])"
> <[email protected]
> (mailto:[email protected])>
> Sent: Monday, March 25, 2013 7:40 AM
> Subject: Re: [Geotools-gt2-users] How do I turn on FINE Logging for package
> org.geotools.data.oracle?
>
> In reviewing the code I do not see a log of logging at that level.
>
> 1. SQL generation is often handled by SQLDialect which provides:
>
> protected static final Logger LOGGER = Logging.getLogger(SQLDialect.class);
>
> So either of the OracleDialect implementations should use this. So your
> logging.properties should reference "org.geotools.jdbc.SQLDialect"
>
> 2. JDBCDataStore makes use of a logger created by its superclass:
>
> this.LOGGER = org.geotools.util.logging.Logging.getLogger(
> getClass().getPackage().getName());
>
> This should result in "org.geotools.jdbc"
>
> 3. For actually running the SQL .. it happens where it is needed. The most
> useful is JDBCFeatureReader (however it is not logging the SQL used).
>
> public JDBCFeatureReader( String sql, Connection cx, JDBCFeatureSource
> featureSource, SimpleFeatureType featureType, Hints hints )
> throws SQLException {
> init( featureSource, featureType, hints );
>
> //create the result set
> this.cx (http://this.cx) = cx;
> st = cx.createStatement(ResultSet.TYPE_FORWARD_ONLY,
> ResultSet.CONCUR_READ_ONLY);
> st.setFetchSize(featureSource.getDataStore().getFetchSize());
>
>
> ((BasicSQLDialect)featureSource.getDataStore().getSQLDialect()).onSelect(st,
> cx, featureType);
> rs = st.executeQuery(sql);
> }
>
>
> This class is called from a number of locations such as
> JDBCFeatureSource.getReaderInternalQuery() -
>
> //build up a statement for the content
> String sql = getDataStore().selectSQL(querySchema,
> preQuery);
> getDataStore().getLogger().fine(sql);
>
> reader = new JDBCFeatureReader( sql, cx, this,
> querySchema, query.getHints() );
>
> So this is your best bet, "org.geotools.jdbc" set to FINE
> --
> Jody Garnett
>
> On Sunday, 24 March 2013 at 6:05 PM, Ron Lindhoudt wrote:
> >
> > Hey,
> >
> > How can I turn on FINE logging to display the sql statements in package
> > org.geotools.data.oracle?
> > I tried several thing in logging.properties but nothing helps.
> > I also want to show sql statements that are executed in FeatureLayer during
> > StreamingRenderer.paint.
> >
> > Thanks.
> >
> > Ron
> >
> >
> >
> > ------------------------------------------------------------------------------
> > Everyone hates slow websites. So do we.
> > Make your web apps faster with AppDynamics
> > Download AppDynamics Lite for free today:
> > http://p.sf.net/sfu/appdyn_d2d_mar
> >
> > _______________________________________________
> > GeoTools-GT2-Users mailing list
> > [email protected]
> > (mailto:[email protected])
> > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
> >
> >
> >
>
>
>
>
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
