大海Online的博客

Looking for Interest

c3p0.properties .vs. c3p0-config.xml

 

摘自c3p0.jar,方便查看

//c3p0.properties

#
#Thisfileisdetritusfromvarioustestingattempts
#thevaluesbelowmaychange
,andoftendonotrepresent
#reasonablevaluesfortheparameters.
#

#c3p0.testConnectionOnCheckout
=true
#c3p0.testConnectionOnCheckin
=true
#c3p0.minPoolSize
=3
#c3p0.maxPoolSize
=20
#c3p0.checkoutTimeout
=2000
#c3p0.idleConnectionTestPeriod
=5
#c3p0.maxConnectionAge
=10
#c3p0.maxIdleTime
=2
#c3p0.maxIdleTimeExcessConnections
=1
#c3p0.propertyCycle
=1
#c3p0.numHelperThreads
=10
#c3p0.unreturnedConnectionTimeout
=15
#c3p0.debugUnreturnedConnectionStackTraces
=true
#c3p0.maxStatements
=30
#c3p0.maxStatementsPerConnection
=5
#c3p0.maxAdministrativeTaskTime
=3
#c3p0.preferredTestQuery
=SELECT1
#c3p0.preferredTestQuery
=SELECTaFROMemptyyukyukWHEREa=5
#c3p0.preferredTestQuery
=SELECTaFROMtestpbdsWHEREa=5
#c3p0.usesTraditionalReflectiveProxies
=true
#c3p0.automaticTestTable
=PoopyTestTable
#c3p0.acquireIncrement
=4
#c3p0.acquireRetryDelay
=1000
#c3p0.acquireRetryAttempts
=60
#c3p0.connectionTesterClassName
=com.mchange.v2.c3p0.test.AlwaysFailConnectionTester
#c3p0.initialPoolSize
=10

c3p0.jdbcUrl
=jdbc:postgresql://localhost/c3p0-test
c3p0.driverClass
=org.postgresql.Driver
c3p0.user
=swaldman
c3p0.password
=test
#c3p0.user
=poop
#c3p0.password
=scoop

#com.mchange.v2.log.MLog
=com.mchange.v2.log.log4j.Log4jMLog
#com.mchange.v2.log.MLog
=com.mchange.v2.log.jdk14logging.Jdk14MLog
#com.mchange.v2.log.MLog
=com.mchange.v2.log.FallbackMLog
#com.mchange.v2.log.NameTransformer
=com.mchange.v2.log.PackageNames
#com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL
=ALL


#com.mchange.v2.c3p0.VMID
=poop

 

 

//c3p0-config.xml

<c3p0-config>
<default-config>
<!--<propertyname="automaticTestTable">con_test</property>-->
<!--<propertyname="checkoutTimeout">30000</property>-->
<!--<propertyname="idleConnectionTestPeriod">30</property>-->
<!--<propertyname="initialPoolSize">10</property>-->
<!--<propertyname="maxIdleTime">30</property>-->
<!--<propertyname="maxIdleTimeExcessConnections">10</property>-->
<!--<propertyname="maxConnectionAge">60</property>-->
<!--<propertyname="propertyCycle">1</property>-->
<!--<propertyname="maxPoolSize">25</property>-->
<!--<propertyname="minPoolSize">5</property>-->
<!--<propertyname="maxStatements">0</property>-->
<!--<propertyname="maxStatementsPerConnection">5</property>-->
<!--<propertyname="maxAdministrativeTaskTime">4</property>-->
<!--<propertyname="connectionCustomizerClassName">com.mchange.v2.c3p0.test.TestConnectionCustomizer</property>-->
<!--<propertyname="unreturnedConnectionTimeout">15</property>-->
<!--<propertyname="debugUnreturnedConnectionStackTraces">true</property>-->

<!--
<user-overridesuser="swaldman">
<propertyname="debugUnreturnedConnectionStackTraces">true</property>
</user-overrides>
-->

</default-config>

<!--
<named-configname="dumbTestConfig">
<propertyname="maxStatements">200</property>
<propertyname="jdbcUrl">jdbc:test</property>
<user-overridesuser="poop">
<propertyname="maxStatements">300</property>
</user-overrides>
</named-config>
-->

</c3p0-config>


 

 

//解析properties

 

/*
*Distributedaspartofc3p0v.0.9.1.2
*
*Copyright(C)2005MachineryForChange,Inc.
*
*Author:SteveWaldman<swaldman@mchange.com>
*
*Thislibraryisfreesoftware;youcanredistributeitand/ormodify
*itunderthetermsoftheGNULesserGeneralPublicLicenseversion2.1,as
*publishedbytheFreeSoftwareFoundation.
*
*Thissoftwareisdistributedinthehopethatitwillbeuseful,
*butWITHOUTANYWARRANTY;withouteventheimpliedwarrantyof
*MERCHANTABILITYorFITNESSFORAPARTICULARPURPOSE.Seethe
*GNULesserGeneralPublicLicenseformoredetails.
*
*YoushouldhavereceivedacopyoftheGNULesserGeneralPublicLicense
*alongwiththissoftware;seethefileLICENSE.Ifnot,writetothe
*FreeSoftwareFoundation,Inc.,59TemplePlace,Suite330,
*Boston,MA02111-1307,USA.
*/



packagecom.mchange.v2.c3p0.cfg;

importjava.io.*;
importjava.lang.reflect.*;
importjava.util.*;
importcom.mchange.v2.cfg.*;
importcom.mchange.v2.log.*;
importcom.mchange.v2.c3p0.impl.*;

publicfinalclassC3P0ConfigUtils
{
publicfinalstaticStringPROPS_FILE_RSRC_PATH="/c3p0.properties";
publicfinalstaticStringPROPS_FILE_PROP_PFX="c3p0.";
publicfinalstaticintPROPS_FILE_PROP_PFX_LEN=5;

privatefinalstaticString[]MISSPELL_PFXS={"/c3pO","/c3po","/C3P0","/C3PO"};

finalstaticMLoggerlogger=MLog.getLogger(C3P0ConfigUtils.class);

static
{
if(logger.isLoggable(MLevel.WARNING)&&C3P0ConfigUtils.class.getResource(PROPS_FILE_RSRC_PATH)==null)
{
//warnonamisspelling...itsanuglywaytodothis,butsinceresourcesarenotlistable...
for(inti=0;i<MISSPELL_PFXS.length;++i)
{
Stringtest
=MISSPELL_PFXS[i]+".properties";
if(C3P0ConfigUtils.class.getResource(MISSPELL_PFXS[i]+".properties")!=null)
{
logger.warning(
"POSSIBLYMISSPELLEDc3p0.propertiesCONFIGRESOURCEFOUND."+
"Pleaseensurethefilenameisc3p0.properties,alllowercase,"+
"withthedigit0(NOTtheletterO)inc3p0.Itshouldbeplaced"+
"inthetoplevelofc3p0'seffectiveclasspath.");
break;
}

}

}

}


publicstaticHashMapextractHardcodedC3P0Defaults(booleanstringify)
{
HashMapout
=newHashMap();

try
{
Method[]methods
=C3P0Defaults.class.getMethods();
for(inti=0,len=methods.length;i<len;++i)
{
Methodm
=methods[i];
intmods=m.getModifiers();
if((mods&Modifier.PUBLIC)!=0&&(mods&Modifier.STATIC)!=0&&m.getParameterTypes().length==0)
{
if(stringify)
{
Objectval
=m.invoke(null,null);
if(val!=null)
out.put(m.getName(),String.valueOf(val));
}

else
out.put(m.getName(),m.invoke(
null,null));
}

}

}

catch(Exceptione)
{
logger.log(MLevel.WARNING,
"Failedtoextracthardcodeddefaultconfig!?",e);
}


returnout;
}


publicstaticHashMapextractHardcodedC3P0Defaults()
{returnextractHardcodedC3P0Defaults(true);}

publicstaticHashMapextractC3P0PropertiesResources()
{
HashMapout
=newHashMap();

//Propertiesprops=findResourceProperties();
//props.putAll(findAllC3P0Properties());

Propertiesprops
=findAllC3P0Properties();
for(Iteratorii=props.keySet().iterator();ii.hasNext();)
{
Stringkey
=(String)ii.next();
Stringval
=(String)props.get(key);
if(key.startsWith(PROPS_FILE_PROP_PFX))
out.put(key.substring(PROPS_FILE_PROP_PFX_LEN).trim(),val.trim());
}


returnout;
}


publicstaticC3P0ConfigconfigFromFlatDefaults(HashMapflatDefaults)
{
NamedScopedefaults
=newNamedScope();
defaults.props.putAll(flatDefaults);

HashMapconfigNamesToNamedScopes
=newHashMap();

returnnewC3P0Config(defaults,configNamesToNamedScopes);
}


publicstaticStringgetPropFileConfigProperty(Stringprop)
{returnMultiPropertiesConfig.readVmConfig().getProperty(prop);}

privatestaticPropertiesfindResourceProperties()
{returnMultiPropertiesConfig.readVmConfig().getPropertiesByResourcePath(PROPS_FILE_RSRC_PATH);}

privatestaticPropertiesfindAllC3P0Properties()
{returnMultiPropertiesConfig.readVmConfig().getPropertiesByPrefix("c3p0");}

staticPropertiesfindAllC3P0SystemProperties()
{
Propertiesout
=newProperties();

SecurityExceptionsampleExc
=null;
try
{
for(Iteratorii=C3P0Defaults.getKnownProperties().iterator();ii.hasNext();)
{
Stringkey
=(String)ii.next();
StringprefixedKey
="c3p0."+key;
Stringvalue
=System.getProperty(prefixedKey);
if(value!=null&&value.trim().length()>0)
out.put(key,value);
}

}

catch(SecurityExceptione)
{sampleExc=e;}

returnout;
}


privateC3P0ConfigUtils()
{}
}


 

 

//解析xml

 

/*
*Distributedaspartofc3p0v.0.9.1.2
*
*Copyright(C)2005MachineryForChange,Inc.
*
*Author:SteveWaldman<swaldman@mchange.com>
*
*Thislibraryisfreesoftware;youcanredistributeitand/ormodify
*itunderthetermsoftheGNULesserGeneralPublicLicenseversion2.1,as
*publishedbytheFreeSoftwareFoundation.
*
*Thissoftwareisdistributedinthehopethatitwillbeuseful,
*butWITHOUTANYWARRANTY;withouteventheimpliedwarrantyof
*MERCHANTABILITYorFITNESSFORAPARTICULARPURPOSE.Seethe
*GNULesserGeneralPublicLicenseformoredetails.
*
*YoushouldhavereceivedacopyoftheGNULesserGeneralPublicLicense
*alongwiththissoftware;seethefileLICENSE.Ifnot,writetothe
*FreeSoftwareFoundation,Inc.,59TemplePlace,Suite330,
*Boston,MA02111-1307,USA.
*/



packagecom.mchange.v2.c3p0.cfg;

importjava.io.*;
importjava.util.*;
importjavax.xml.parsers.*;
importorg.w3c.dom.*;
importcom.mchange.v2.log.*;

importcom.mchange.v1.xml.DomParseUtils;

publicfinalclassC3P0ConfigXmlUtils
{
publicfinalstaticStringXML_CONFIG_RSRC_PATH="/c3p0-config.xml";

finalstaticMLoggerlogger=MLog.getLogger(C3P0ConfigXmlUtils.class);

publicfinalstaticStringLINESEP;

privatefinalstaticString[]MISSPELL_PFXS={"/c3p0","/c3pO","/c3po","/C3P0","/C3PO"};
privatefinalstaticchar[]MISSPELL_LINES={'-','_'};
privatefinalstaticString[]MISSPELL_CONFIG={"config","CONFIG"};
privatefinalstaticString[]MISSPELL_XML={"xml","XML"};

//itsanuglywaytodothis,butsinceresourcesarenotlistable...
//
//thisisonlyexecutedonce,anddoesabout40tests(fornow)
//shouldIcareaboutthecostininitializationtime?
//
//shouldonlyberunifwe'vecheckedforthecorrectfile,but
//notfoundit
privatefinalstaticvoidwarnCommonXmlConfigResourceMisspellings()
{
if(logger.isLoggable(MLevel.WARNING))
{
for(inta=0,lena=MISSPELL_PFXS.length;a<lena;++a)
{
StringBuffersb
=newStringBuffer(16);
sb.append(MISSPELL_PFXS[a]);
for(intb=0,lenb=MISSPELL_LINES.length;b<lenb;++b)
{
sb.append(MISSPELL_LINES*);
for(intc=0,lenc=MISSPELL_CONFIG.length;c<lenc;++c)
{
sb.append(MISSPELL_CONFIG[c]);
sb.append(
'.');
for(intd=0,lend=MISSPELL_XML.length;d<lend;++d)
{
sb.append(MISSPELL_XML[d]);
Stringtest
=sb.toString();
if(!test.equals(XML_CONFIG_RSRC_PATH))
{
ObjecthopefullyNull
=C3P0ConfigXmlUtils.class.getResource(test);
if(hopefullyNull!=null)
{
logger.warning(
"POSSIBLYMISSPELLEDc3p0-conf.xmlRESOURCEFOUND."+
"Pleaseensurethefilenameisc3p0-config.xml,alllowercase,"+
"withthedigit0(NOTtheletterO)inc3p0.Itshouldbeplaced"+
"inthetoplevelofc3p0'seffectiveclasspath.");
return;
}

}

}

}


}

}

}

}


static
{
Stringls;

try
{ls=System.getProperty("line.separator","");}
catch(Exceptione)
{ls="";}

LINESEP
=ls;

}


publicstaticC3P0ConfigextractXmlConfigFromDefaultResource()throwsException
{
InputStreamis
=null;

try
{
is
=C3P0ConfigUtils.class.getResourceAsStream(XML_CONFIG_RSRC_PATH);
if(is==null)
{
warnCommonXmlConfigResourceMisspellings();
returnnull;
}

else
returnextractXmlConfigFromInputStream(is);
}

finally
{
try{if(is!=null)is.close();}
catch(Exceptione)
{
if(logger.isLoggable(MLevel.FINE))
logger.log(MLevel.FINE,
"ExceptiononresourceInputStreamclose.",e);
}

}

}


publicstaticC3P0ConfigextractXmlConfigFromInputStream(InputStreamis)throwsException
{
DocumentBuilderFactoryfact
=DocumentBuilderFactory.newInstance();
DocumentBuilderdb
=fact.newDocumentBuilder();
Documentdoc
=db.parse(is);

returnextractConfigFromXmlDoc(doc);
}


publicstaticC3P0ConfigextractConfigFromXmlDoc(Documentdoc)throwsException
{
ElementdocElem
=doc.getDocumentElement();
if(docElem.getTagName().equals("c3p0-config"))
{
NamedScopedefaults;
HashMapconfigNamesToNamedScopes
=newHashMap();

ElementdefaultConfigElem
=DomParseUtils.uniqueChild(docElem,"default-config");
if(defaultConfigElem!=null)
defaults
=extractNamedScopeFromLevel(defaultConfigElem);
else
defaults
=newNamedScope();
NodeListnl
=DomParseUtils.immediateChildElementsByTagName(docElem,"named-config");
for(inti=0,len=nl.getLength();i<len;++i)
{
ElementnamedConfigElem
=(Element)nl.item(i);
StringconfigName
=namedConfigElem.getAttribute("name");
if(configName!=null&&configName.length()>0)
{
NamedScopenamedConfig
=extractNamedScopeFromLevel(namedConfigElem);
configNamesToNamedScopes.put(configName,namedConfig);
}

else
logger.warning(
"ConfigurationXMLcontainednamed-configelementwithoutnameattribute:"+namedConfigElem);
}

returnnewC3P0Config(defaults,configNamesToNamedScopes);
}

else
thrownewException("Rootelementofc3p0configxmlshouldbe'c3p0-config',not'"+docElem.getTagName()+"'.");
}


privatestaticNamedScopeextractNamedScopeFromLevel(Elementelem)
{
HashMapprops
=extractPropertiesFromLevel(elem);
HashMapuserNamesToOverrides
=newHashMap();

NodeListnl
=DomParseUtils.immediateChildElementsByTagName(elem,"user-overrides");
for(inti=0,len=nl.getLength();i<len;++i)
{
ElementperUserConfigElem
=(Element)nl.item(i);
StringuserName
=perUserConfigElem.getAttribute("user");
if(userName!=null&&userName.length()>0)
{
HashMapuserProps
=extractPropertiesFromLevel(perUserConfigElem);
userNamesToOverrides.put(userName,userProps);
}

else
logger.warning(
"ConfigurationXMLcontaineduser-overrideselementwithoutuserattribute:"+LINESEP+perUserConfigElem);
}


returnnewNamedScope(props,userNamesToOverrides);
}


privatestaticHashMapextractPropertiesFromLevel(Elementelem)
{
//System.err.println("extractPropertiesFromLevel()");

HashMapout
=newHashMap();

try
{
NodeListnl
=DomParseUtils.immediateChildElementsByTagName(elem,"property");
intlen=nl.getLength();
for(inti=0;i<len;++i)
{
ElementpropertyElem
=(Element)nl.item(i);
StringpropName
=propertyElem.getAttribute("name");
if(propName!=null&&propName.length()>0)
{
StringpropVal
=DomParseUtils.allTextFromElement(propertyElem,true);
out.put(propName,propVal);
//System.err.println(propName+"->"+propVal);
}

else
logger.warning(
"ConfigurationXMLcontainedpropertyelementwithoutnameattribute:"+LINESEP+propertyElem);
}

}

catch(Exceptione)
{
logger.log(MLevel.WARNING,
"AnexceptionoccurredwhilereadingconfigXML."+
"Someconfigurationinformationhasprobablybeenignored.",
e);
}


returnout;
}


privateC3P0ConfigXmlUtils()
{}
}


 

 

/*
*Distributedaspartofc3p0v.0.9.1.2
*
*Copyright(C)2005MachineryForChange,Inc.
*
*Author:SteveWaldman<swaldman@mchange.com>
*
*Thislibraryisfreesoftware;youcanredistributeitand/ormodify
*itunderthetermsoftheGNULesserGeneralPublicLicenseversion2.1,as
*publishedbytheFreeSoftwareFoundation.
*
*Thissoftwareisdistributedinthehopethatitwillbeuseful,
*butWITHOUTANYWARRANTY;withouteventheimpliedwarrantyof
*MERCHANTABILITYorFITNESSFORAPARTICULARPURPOSE.Seethe
*GNULesserGeneralPublicLicenseformoredetails.
*
*YoushouldhavereceivedacopyoftheGNULesserGeneralPublicLicense
*alongwiththissoftware;seethefileLICENSE.Ifnot,writetothe
*FreeSoftwareFoundation,Inc.,59TemplePlace,Suite330,
*Boston,MA02111-1307,USA.
*/



packagecom.mchange.v1.xml;

importjava.util.*;
importorg.xml.sax.*;
importorg.w3c.dom.*;
importcom.mchange.v1.util.DebugUtils;

publicfinalclassDomParseUtils
{
finalstaticbooleanDEBUG=true;

/**
*
@returnnullifchilddoesn'texist.
*/

publicstaticStringallTextFromUniqueChild(Elementelem,StringchildTagName)
throwsDOMException
{returnallTextFromUniqueChild(elem,childTagName,false);}

/**
*
@returnnullifchilddoesn'texist.
*/

publicstaticStringallTextFromUniqueChild(Elementelem,StringchildTagName,booleantrim)
throwsDOMException
{
ElementuniqueChild
=uniqueChildByTagName(elem,childTagName);
if(uniqueChild==null)
returnnull;
else
returnDomParseUtils.allTextFromElement(uniqueChild,trim);
}


publicstaticElementuniqueChild(Elementelem,StringchildTagName)throwsDOMException
{returnuniqueChildByTagName(elem,childTagName);}

/**
*
@deprecateduseuniqueChild(Elementelem,StringchildTagName)
*/

publicstaticElementuniqueChildByTagName(Elementelem,StringchildTagName)throwsDOMException
{
NodeListnl
=elem.getElementsByTagName(childTagName);
intlen=nl.getLength();
if(DEBUG)
DebugUtils.myAssert(len
<=1,
"Thereismorethanone("+len+")childwithtagname:"+
childTagName
+"!!!");
return(len==1?(Element)nl.item(0):null);
}


publicstaticStringallText(Elementelem)throwsDOMException
{returnallTextFromElement(elem);}

publicstaticStringallText(Elementelem,booleantrim)throwsDOMException
{returnallTextFromElement(elem,trim);}

/**@deprecateduseallText(Elementelem)*/
publicstaticStringallTextFromElement(Elementelem)throwsDOMException
{returnallTextFromElement(elem,false);}

/**@deprecateduseallText(Elementelem,booleantrim)*/
publicstaticStringallTextFromElement(Elementelem,booleantrim)throwsDOMException
{
StringBuffertextBuf
=newStringBuffer();
NodeListnl
=elem.getChildNodes();
for(intj=0,len=nl.getLength();j<len;++j)
{
Nodenode
=nl.item(j);
if(nodeinstanceofText)//includesTextandCDATA!
textBuf.append(node.getNodeValue());
}

Stringout
=textBuf.toString();
return(trim?out.trim():out);
}


publicstaticString[]allTextFromImmediateChildElements(Elementparent,StringtagName)
throwsDOMException
{returnallTextFromImmediateChildElements(parent,tagName,false);}

publicstaticString[]allTextFromImmediateChildElements(Elementparent,StringtagName,booleantrim)
throwsDOMException
{
NodeListnl
=immediateChildElementsByTagName(parent,tagName);
intlen=nl.getLength();
String[]out
=newString[len];
for(inti=0;i<len;++i)
out[i]
=allText((Element)nl.item(i),trim);
returnout;
}



publicstaticNodeListimmediateChildElementsByTagName(Elementparent,StringtagName)
throwsDOMException
{returngetImmediateChildElementsByTagName(parent,tagName);}

/**
*
@deprecateduseimmediateChildrenByTagName(Elementparent,StringtagName)
*/

publicstaticNodeListgetImmediateChildElementsByTagName(Elementparent,StringtagName)
throwsDOMException
{
finalListnodes=newArrayList();
for(Nodechild=parent.getFirstChild();child!=null;child=child.getNextSibling())
if(childinstanceofElement&&((Element)child).getTagName().equals(tagName))
nodes.add(child);
returnnewNodeList()
{
publicintgetLength()
{returnnodes.size();}

publicNodeitem(inti)
{return(Node)nodes.get(i);}
}
;
}


publicstaticStringallTextFromUniqueImmediateChild(Elementelem,StringchildTagName)
throwsDOMException
{
ElementuniqueChild
=uniqueImmediateChildByTagName(elem,childTagName);
if(uniqueChild==null)
returnnull;
returnDomParseUtils.allTextFromElement(uniqueChild);
}


publicstaticElementuniqueImmediateChild(Elementelem,StringchildTagName)
throwsDOMException
{returnuniqueImmediateChildByTagName(elem,childTagName);}

/**
*
@deprecateduseuniqueImmediateChild(Elementelem,StringchildTagName)
*/

publicstaticElementuniqueImmediateChildByTagName(Elementelem,StringchildTagName)
throwsDOMException
{
NodeListnl
=getImmediateChildElementsByTagName(elem,childTagName);
intlen=nl.getLength();
if(DEBUG)
DebugUtils.myAssert(len
<=1,
"Thereismorethanone("+len+")childwithtagname:"+
childTagName
+"!!!");
return(len==1?(Element)nl.item(0):null);
}


/**
*
@deprecateduseElement.getAttribute(Stringval)
*/

publicstaticStringattrValFromElement(Elementelement,StringattrName)
throwsDOMException
{
Attrattr
=element.getAttributeNode(attrName);
return(attr==null?null:attr.getValue());
}


privateDomParseUtils()
{}
}