<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1066609201;
mso-list-type:hybrid;
mso-list-template-ids:-455166414 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Tahoma","sans-serif"'>Using Logback classic 1.0.6 (slf4j 1.6.5)<o:p></o:p></span></p><p class=MsoNormal>Running on a Weblogic server 10.3.5.<o:p></o:p></p><p class=MsoNormal><span style='font-size:8.5pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal>I just added the DBAppender and have some unusual errors that get generated.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My append statement works fine and it does log entries to the database:<o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>appender</span><span style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>name</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"DataBase"</span></i> <span style='color:#7F007F'>class</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"ch.qos.logback.classic.db.DBAppender"</span></i><span style='color:teal'>></span><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>connectionSource</span><span style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>class</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"ch.qos.logback.core.db.JNDIConnectionSource"</span></i><span style='color:teal'>></span><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'><</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>param</span><span style='font-size:10.0pt;font-family:Consolas'> <span style='color:#7F007F'>name</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"jndiLocation"</span></i> <span style='color:#7F007F'>value</span><span style='color:black'>=</span><i><span style='color:#2A00FF'>"UCS_DS."</span></i> <span style='color:teal'>/></span><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>connectionSource</span><span style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span style='font-size:10.0pt;font-family:Consolas'><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:black'> </span><span style='font-size:10.0pt;font-family:Consolas;color:teal'></</span><span style='font-size:10.0pt;font-family:Consolas;color:#3F7F7F'>appender</span><span style='font-size:10.0pt;font-family:Consolas;color:teal'>></span><span style='font-size:10.0pt;font-family:Consolas'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Weblogic reports the following about the datasource creation (This pool on my local machine starts at 6 and grows by 2 up to 40 connections):<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><BEA-001177> <Creating Connection Pool named UCS_DS, URL = jdbc:oracle:thin:@localhost:1521:XE, Properties = user=logback;.> <o:p></o:p></p><p class=MsoNormal><BEA-000626> <Free resources in pool "UCS_DS" will be tested every "120" seconds.> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-001516> <Connection Pool "UCS_DS" connected to Database: "Oracle", Version: "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production".> <o:p></o:p></p><p class=MsoNormal><BEA-001517> <Connection Pool "UCS_DS" using Driver: "Oracle JDBC driver", Version: "11.2.0.2.0".> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-001066> <Delaying 6 seconds before making a UCS_DS pool connection.> <o:p></o:p></p><p class=MsoNormal><BEA-000628> <Created "6" resources for pool "UCS_DS", out of which "6" are available and "0" are unavailable.> <o:p></o:p></p><p class=MsoNormal><BEA-001124> <Created Connection Pool named UCS_DS.> <o:p></o:p></p><p class=MsoNormal><BEA-001174> <Creating Data Source named UCS_DS, JNDI Name = UCS_DS.> <o:p></o:p></p><p class=MsoNormal><BEA-001512> <Data Source UCS_DS has been successfully created.> <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But this error is thrown quite frequently.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>20:38:56,700 |-ERROR in ch.qos.logback.classic.db.DBAppender[DataBase] - problem appending event java.sql.SQLException: Cannot call commit when using distributed transactions at java.sql.SQLException: Cannot call commit when using distributed transactions<o:p></o:p></p><p class=MsoNormal> at at weblogic.jdbc.wrapper.JTAConnection.commit(JTAConnection.java:355)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.core.db.DBAppenderBase.append(DBAppenderBase.java:116)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.core.UnsynchronizedAppenderBase.doAppend(UnsynchronizedAppenderBase.java:88)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.core.spi.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:48)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.classic.Logger.appendLoopOnAppenders(Logger.java:282)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.classic.Logger.callAppenders(Logger.java:269)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:470)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:424)<o:p></o:p></p><p class=MsoNormal> at at ch.qos.logback.classic.Logger.info(Logger.java:628)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>And I also see this:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><BEA-001153> <Forcibly releasing inactive connection "[weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection-UCS_DS-2, oracle.jdbc.driver.LogicalConnection@11d5e99]" back into the connection pool "UCS_DS", currently reserved by: java.lang.Exception<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:325)<o:p></o:p></p><p class=MsoNormal> at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:363)<o:p></o:p></p><p class=MsoNormal> at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:417)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:324)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:94)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:63)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1677)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1475)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)<o:p></o:p></p><p class=MsoNormal> at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.db.JNDIConnectionSource.getConnection(JNDIConnectionSource.java:63)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.db.ConnectionSourceBase.discoverConnectionProperties(ConnectionSourceBase.java:47)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.db.JNDIConnectionSource.start(JNDIConnectionSource.java:50)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.action.NestedComplexPropertyIA.end(NestedComplexPropertyIA.java:167)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:318)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:197)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:183)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:147)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:133)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:96)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:55)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)<o:p></o:p></p><p class=MsoNormal> at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:148)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:84)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:54)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.LoggerFactory.bind(LoggerFactory.java:128)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:108)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:279)<o:p></o:p></p><p class=MsoNormal> at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:252)<o:p></o:p></p><p class=MsoNormal> at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:156)<o:p></o:p></p><p class=MsoNormal> at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:132)<o:p></o:p></p><p class=MsoNormal> at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:645)<o:p></o:p></p><p class=MsoNormal> at org.displaytag.tags.TableTag.<clinit>(TableTag.java:104)<o:p></o:p></p><p class=MsoNormal> at java.lang.Class.forName0(Native Method)<o:p></o:p></p><p class=MsoNormal> at java.lang.Class.forName(Class.java:169)<o:p></o:p></p><p class=MsoNormal> at org.displaytag.tags.TableTagBeanInfo.class$(TableTagBeanInfo.java:42)<o:p></o:p></p><p class=MsoNormal> at org.displaytag.tags.TableTagBeanInfo.getPropertyDescriptors(TableTagBeanInfo.java:41)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.getTargetPropertyInfo(Introspector.java:501)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.getBeanInfo(Introspector.java:410)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.getBeanInfo(Introspector.java:232)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.<init>(Introspector.java:389)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.getBeanInfo(Introspector.java:232)<o:p></o:p></p><p class=MsoNormal> at java.beans.Introspector.getBeanInfo(Introspector.java:218)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.tag.TagInfoEx.getPropertyDescriptorSetterTypes(TagInfoEx.java:554)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.tag.TagInfoEx.getSetterTypes(TagInfoEx.java:499)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.tag.TagInfoEx.initAttributeTypes(TagInfoEx.java:395)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspActionChecker.checkActionStart(JspActionChecker.java:287)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspActionChecker.checkActions(JspActionChecker.java:214)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspActionChecker.checkActions(JspActionChecker.java:228)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspActionChecker.check(JspActionChecker.java:150)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspCheckContext.check(JspCheckContext.java:67)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.jsp.JspAnalyzer.check(JspAnalyzer.java:57)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.ProxySourceFile._check(ProxySourceFile.java:136)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.SourceFile.masterCheck(SourceFile.java:762)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.SourceFile.check(SourceFile.java:314)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.SourceFile.check(SourceFile.java:335)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.ProxySourceFile.codeGen(ProxySourceFile.java:224)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.SourceFile.codeGen(SourceFile.java:327)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.client.ClientUtilsImpl$CodeGenJob.run(ClientUtilsImpl.java:599)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.client.Job.performJob(Job.java:83)<o:p></o:p></p><p class=MsoNormal> at weblogic.jsp.internal.client.ThreadPool$WorkerThread.run(ThreadPool.java:217)<o:p></o:p></p><p class=MsoNormal>.><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So my questions are: <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Is there a way to not throw the error?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>What type of performance impact can this cause?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Larry Smith<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p></div></body></html>