大海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()
{}
}