Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
I will look into both suggestions, conflicting property files and the debug
version.

I am connecting to MS SQL Server 2008 R2 (SP1), using the sqljdbc41.jar
file.  The access to SQL Server works great, insert, updates, queries,
stored procedures...no issues. I am just trying to activate the logging for
the connection pool.


On Thu, Feb 16, 2017 at 3:16 PM, Aurélien Terrestris <aterrest...@gmail.com>
wrote:

> What database are you connecting to ? Oracle ? MySQL ? If Oracle, then
> you're probably using its specific driver, and there is a debug version
> (the "_g" version) that logs.
>
> According to you, what kind of log the Tomcat driver should write ?
>
> 2017-02-16 19:08 GMT+01:00 Chris Keilitz <keil...@gmail.com>:
>
> > I'm assuming, once configured properly, the Tomcat JDBC connection pool
> > would output log messages. Unfortunately, I currently get no console or
> > file output...even after trying numerous logging.properties changes.
> >
> > I'm hoping for a little help to understand the proper way to configure a
> > stand alone usage of Tomcat JDBC.
> >
> > On Thu, Feb 16, 2017 at 12:58 PM, Christopher Schultz <
> > ch...@christopherschultz.net> wrote:
> >
> > > -BEGIN PGP SIGNED MESSAGE-
> > > Hash: SHA256
> > >
> > > Chris,
> > >
> > > On 2/16/17 12:26 PM, Chris Keilitz wrote:
> > > > I've implemented Tomcat JDBC connection pool stand-alone, outside
> > > > of Tomcat or any app server or container and cannot get the Juli
> > > > logging working - console or file.   The connection pool works
> > > > great, but I cannot get the logging going.  I've added
> > > > CATALINA_HOME to the local directory and have added
> > > > logging.properties file to the local lib and .conf directories,
> > > > but still cannot get it to work.
> > > >
> > > > I know I'm missing somethinghoping one of you can me understand
> > > > what I'm doing wrong, could try.
> > >
> > > When you say that the logging doesn't work, what exactly do you mean?
> > >
> > > "Adding CATALINA_HOME to the local directory" doesn't clarify anything.
> > >
> > > - -chris
> > > -BEGIN PGP SIGNATURE-
> > > Comment: GPGTools - http://gpgtools.org
> > > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
> > >
> > > iQIcBAEBCAAGBQJYpehVAAoJEBzwKT+lPKRYRIIQAL252B1PA+RdmD0kvxi4XGQw
> > > 1nkfbUpLy3qnZlejj4AMxNZCmNsgxzSVKsuseZXSltiCvsidbuS1VJb+aZ6qI/mC
> > > FaDdrORqA5MJ5JQxCBKF0KHNvm4/P8+7XLW7S0m+CCSUsJ6S4yUfq8soV+giM6vD
> > > I3tEMfQscMnkj3wTzWqKKwY4rs6YJ+ILerwclGmMB1rtpO9lwGFBTj2p2M0NwPav
> > > 9P7LESiUtZGaJMxlS+QFJW+u8xPqQTkQV2xf5ZVbeMZfKqtD14FWrgMzrlRyo27P
> > > 0IhK1qs2I1EdWzPT7O2xEWpcKC9b6P2+su5YIjS4xwDOF9dsSBZfBLgKXhrm8gDf
> > > JI+d0xgC80PzDZfQwv/Spo0J9U4sGPUp9+tTRjI4Ub8M8z4xG/gssNw7eG8RCOfU
> > > NYIK/POB9QPTukUKyEPMXr/DYC7W3b0RP0yjH/yk+hcp3H3Iok/4GVoey8ydhYlT
> > > fI5P7oq1FNXFVoupMEv77eqlzCc6V7CU0idMhjnSjM5Zoio9r+kbONg5oHDBlSDA
> > > yXbPcDPORr+qux6hf73HK8kNH5ae059aF9T8lGC+uW5EyY4YAgQfrhle/3xk+Jub
> > > sGeM8gpVt9eozlNFyZ4LqTXXNtBHzpw5LCTQa1TWS8UQm703+/0DxZmf0EgZwEn5
> > > pN0ov1UkJ4tcT7DA7E0w
> > > =Xqes
> > > -END PGP SIGNATURE-
> > >
> > > -
> > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> > > For additional commands, e-mail: users-h...@tomcat.apache.org
> > >
> > >
> >
>


Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
I'm assuming, once configured properly, the Tomcat JDBC connection pool
would output log messages. Unfortunately, I currently get no console or
file output...even after trying numerous logging.properties changes.

I'm hoping for a little help to understand the proper way to configure a
stand alone usage of Tomcat JDBC.

On Thu, Feb 16, 2017 at 12:58 PM, Christopher Schultz <
ch...@christopherschultz.net> wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Chris,
>
> On 2/16/17 12:26 PM, Chris Keilitz wrote:
> > I've implemented Tomcat JDBC connection pool stand-alone, outside
> > of Tomcat or any app server or container and cannot get the Juli
> > logging working - console or file.   The connection pool works
> > great, but I cannot get the logging going.  I've added
> > CATALINA_HOME to the local directory and have added
> > logging.properties file to the local lib and .conf directories,
> > but still cannot get it to work.
> >
> > I know I'm missing somethinghoping one of you can me understand
> > what I'm doing wrong, could try.
>
> When you say that the logging doesn't work, what exactly do you mean?
>
> "Adding CATALINA_HOME to the local directory" doesn't clarify anything.
>
> - -chris
> -BEGIN PGP SIGNATURE-
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIcBAEBCAAGBQJYpehVAAoJEBzwKT+lPKRYRIIQAL252B1PA+RdmD0kvxi4XGQw
> 1nkfbUpLy3qnZlejj4AMxNZCmNsgxzSVKsuseZXSltiCvsidbuS1VJb+aZ6qI/mC
> FaDdrORqA5MJ5JQxCBKF0KHNvm4/P8+7XLW7S0m+CCSUsJ6S4yUfq8soV+giM6vD
> I3tEMfQscMnkj3wTzWqKKwY4rs6YJ+ILerwclGmMB1rtpO9lwGFBTj2p2M0NwPav
> 9P7LESiUtZGaJMxlS+QFJW+u8xPqQTkQV2xf5ZVbeMZfKqtD14FWrgMzrlRyo27P
> 0IhK1qs2I1EdWzPT7O2xEWpcKC9b6P2+su5YIjS4xwDOF9dsSBZfBLgKXhrm8gDf
> JI+d0xgC80PzDZfQwv/Spo0J9U4sGPUp9+tTRjI4Ub8M8z4xG/gssNw7eG8RCOfU
> NYIK/POB9QPTukUKyEPMXr/DYC7W3b0RP0yjH/yk+hcp3H3Iok/4GVoey8ydhYlT
> fI5P7oq1FNXFVoupMEv77eqlzCc6V7CU0idMhjnSjM5Zoio9r+kbONg5oHDBlSDA
> yXbPcDPORr+qux6hf73HK8kNH5ae059aF9T8lGC+uW5EyY4YAgQfrhle/3xk+Jub
> sGeM8gpVt9eozlNFyZ4LqTXXNtBHzpw5LCTQa1TWS8UQm703+/0DxZmf0EgZwEn5
> pN0ov1UkJ4tcT7DA7E0w
> =Xqes
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>


Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
I've implemented Tomcat JDBC connection pool stand-alone, outside of Tomcat
or any app server or container and cannot get the Juli logging working -
console or file.   The connection pool works great, but I cannot get the
logging going.  I've added CATALINA_HOME to the local directory and have
added logging.properties file to the local lib and .conf directories, but
still cannot get it to work.

I know I'm missing somethinghoping one of you can me understand what
I'm doing wrong, could try.