The JTDS driver was added to the MS SQL GeoTools module some time ago (version 14.x) but if it is not present the slower MicroSoft driver will be used. See http://docs.geotools.org/latest/userguide/library/jdbc/sqlserver.html for more information.
Ian On Wed, 9 Jan 2019 at 18:22, Paul Wittle via Geoserver-users < geoserver-users@lists.sourceforge.net> wrote: > Hi, > > > > Quick update to my own post. Using developer logging I was getting > messages about JTDS not being present in the classpath. This confused me as > there is no reference to JTDS at all that I could find but I did add the > jar file to see what happened. With it present I find that the error in the > original email is often associated as follows (in terms of timing) but I > couldn’t say if there is an actual link. > > > > 2019-01-09 14:09:39,817 TRACE [geotools.factory] - RETURN > (GridCoverageFactory): found implementation Optional. > > 2019-01-09 14:09:39,817 TRACE [geotools.factory] - ENTRY > (GridCoverageFactory) > > 2019-01-09 14:09:39,817 TRACE [geotools.factory] - RETURN > (GridCoverageFactory): found implementation Optional. > > 2019-01-09 14:09:39,817 DEBUG [sqlserver.jtds] - Target not a string > > 2019-01-09 14:09:39,817 ERROR [geotools.map] - Call MapContent dispose() > to prevent memory leaks > > > > I notice that JTDS debug messages are starting to appear in other people’s > error log’s when searching for previous questions. Is JTDS support > something that has been added on purpose or have I just managed to > misconfigure something? > > > > I do have the Microsoft SQL Server and SQL Azure extension installed and > this is the only place that I can find JTDS listed. > > > > Searching the Geoserver code base this is the only reference to JTDS I’ve > found: > > > https://github.com/geoserver/geoserver/blob/445625cdad44e79c48682b0c9852e1e2586c018e/src/community/release/ext-wps-remote.xml > > > > That is not currently installed but I may have installed it on DEV > previously so perhaps that plugin has introduced something into my > configuration? > > > > Thanks, > > Paul > > > > *From:* Paul Wittle > *Sent:* 09 January 2019 13:53 > *To:* 'geoserver-users@lists.sourceforge.net' < > geoserver-users@lists.sourceforge.net> > *Subject:* Memory leak error messages > > > > Hi, > > > > I’ve recently updated us to the latest version of GeoServer (stable) and > I’ve started getting a lot of these errors: > > > > 2019-01-09 13:50:49,127 ERROR [geotools.map] - Call MapContent dispose() > to prevent memory leaks > > > > Does anyone know which logging profile I need to get a more informative > message about the cause of this error? > > > > Best Regards, > > > > Paul Wittle > > GIS Developer > > Insight, Intelligence & Performance > > > > County Hall > > Dorchester > > Dorset. DT1 1XJ > > Tel: 01305 228473 > > E mail: p.wit...@dorsetcc.gov.uk > > > "This e-mail is intended for the named addressee(s) only and may contain > information about individuals or other sensitive information and should be > handled accordingly. Unless you are the named addressee (or authorised to > receive it for the addressee) you may not copy or use it, or disclose it to > anyone else. If you have received this email in error, kindly disregard the > content of the message and notify the sender immediately. Please be aware > that all email may be subject to recording and/or monitoring in accordance > with relevant legislation." > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Ian Turton
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
