blogjava's web log

? <!-- ??configure?DataSource.?Add?the?following?code?into?server.xml?? --> ?
?
? < ?Context? path? =?"?/test?" ??docBase? =?"test?" ??debug? =?"?0?" ?
reloadable? =?"?true?" ??? > ?
?
?
??? < ?Resource? name? =?"?jdbc/first?" ?
???????????????auth? =?"?Container?" ?
???????????????type? =?"?javax.sql.DataSource?" ??? /> ?
?
??? < ?ResourceParams? name? =?"?jdbc/first?" ? > ?
????? < ?parameter? > ?
??????? < ?name? > ?factory? </ ?name? > ?
??????? < ?value? > ?org.apache.commons.dbcp.BasicDataSourceFactory? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??Maximum?number?of?dB?connections?in?pool.?Make?sure?you
?????????configure?your?mysqld?max_connections?large?enough?to?handle
?????????all?of?your?db?connections.?Set?to??0???for??no?limit.
?????????? --> ?
????? < ?parameter? > ?
??????? < ?name? > ?maxActive? </ ?name? > ?
??????? < ?value? > ?100? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??Maximum?number?of?idle?dB?connections?to?retain?in?pool.
?????????Set?to??0???for??no?limit.
?????????? --> ?
????? < ?parameter? > ?
??????? < ?name? > ?maxIdle? </ ?name? > ?
??????? < ?value? > ?30? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??Maximum?time?to?wait??for??a?dB?connection?to?become?available
?????????in?ms,?in??this??example??10??seconds.?An?Exception?is?thrown??if?
??????????this??timeout?is?exceeded.??Set?to??-?1??to?wait?indefinitely.
????????Maximum?time?to?wait??for??a?dB?connection?to?become?available
?????????in?ms,?in??this??example??10??seconds.?An?Exception?is?thrown??if?
??????????this??timeout?is?exceeded.??Set?to??-?1??to?wait?indefinitely.
?????????? --> ?
????? < ?parameter? > ?
??????? < ?name? > ?maxWait? </ ?name? > ?
??????? < ?value? > ?10000? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??MySQL?dB?username?and?password??for??dB?connections??? --> ?
????? < ?parameter? > ?
?????? < ?name? > ?username? </ ?name? > ?
?????? < ?value? > ?dbuser? </ ?value? > ?
????? </ ?parameter? > ?
????? < ?parameter? > ?
?????? < ?name? > ?password? </ ?name? > ?
?????? < ?value? > ?1234? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??Class?name??for??mm.mysql?JDBC?driver?? --> ?
????? < ?parameter? > ?
???????? < ?name? > ?driverClassName? </ ?name? > ?
???????? < ?value? > ?com.mysql.jdbc.Driver? </ ?value? > ?
????? </ ?parameter? > ?
?
????? <!-- ??The?JDBC?connection?url??for??connecting?to?your?MySQL?dB.
?????????The?autoReconnect?=?true??argument?to?the?url?makes?sure?that?the
?????????mm.mysql?JDBC?Driver?will?automatically?reconnect??if??mysqld?closed?the
?????????connection.??mysqld?by??default??closes?idle?connections?after??8??hours.
?????????? --> ?
????? < ?parameter? > ?
??????? < ?name? > ?url? </ ?name? > ?
??????? < ?value? > ?jdbc:mysql:?//?localhost:3306/test?autoReconnect=true </ value > ?
?????? </ ?parameter? > ?
??? </ ?ResourceParams? > ?
?
? </ ?Context? > ?