Jakarta Commons DBCP���g���Ă݂悤�B

[�T�v]
�ėp�R�l�N�V�����v�[�����O���C�u�����ł���A
Jakarta Commons�́ADBCP���g���Ă݂܂��B

[�K�{�‹�]
XML�p�[�T���f�t�H���g�œ����Ă���̂ŁAJ2SDK1.4���]�܂����ł��B
�܂��ACrimson�ӂ���E���Ă���΁A����������ł���...
Xerces���g���ꍇ�́Aorg.xml.sax.driver�Ɂuorg.apache.xerces.parsers.SAXParser�v���w�肵�܂��B

Jakarta Commons�́ACollections�ƁAPool�ADBCP���K�v�ł����A
2002/05/12���_�ŁADBCP�ɂ̓����[�X�ł������ANightly�r���h�ł݂̂ƂȂ��Ă��܂��B

[�������e]
DBCP���g�p�����ꍇ�ƁA�g�p���Ȃ������ꍇ�ŁA
Access�f�[�^�x�[�X�ɃA�N�Z�X���鎞�Ԃ��v�����A��r���܂��B

[�����‹�]
OS: WindowsXP Home Edition
CPU: Pentium4 1.8GHz
������: 384MB (DIMM)
JDK: J2SDK1.4
Access: Access2000

[�����p�\�[�X�R�[�h]
�Etest.java
(docs/JOCLPoolingDriverExample.java���J�X�^�}�C�Y�������́B)
�EpoolingDriverExample.jocl
(docs/poolingDriverExample.jocl.sample���J�X�^�}�C�Y�������́B)
�Edb1.mdb
ODBC�f�[�^�\�[�X�ɁAtest�Ƃ������O�œo�^���ĉ������B

[�R���p�C��]
javac -classpath commons-collections.jar;commons-dbcp.jar;commons-pool.jar test.java

[���s(�v�[�����O����)]
java -Djdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver -classpath commons-collections.jar;commons-dbcp.jar;commons-pool.jar;. test "jdbc:odbc:test" "select * from dual"

[���s(�v�[�����O�L��) - Crimson]
java -Dorg.xml.sax.driver=org.apache.crimson.parser.XMLReaderImpl -Djdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver:org.apache.commons.dbcp.PoolingDriver -classpath commons-collections.jar;commons-dbcp.jar;commons-pool.jar;. test "jdbc:apache:commons:dbcp:/poolingDriverExample" "select * from dual"

[���s(�v�[�����O�L��) - Xerces]
java -Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser -Djdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver:org.apache.commons.dbcp.PoolingDriver -classpath commons-collections.jar;commons-dbcp.jar;commons-pool.jar;xerces.jar;. test "jdbc:apache:commons:dbcp:/poolingDriverExample" "select * from dual"

[��������]
100��SQL�����s���́A���s���ԍ��v[ms]�B(3�񕽋�)

�Ƃ����킯�ŁA10�{�ȏ�̍����o�錋�ʂƂȂ�܂����B
Access�̂悤�ɁA�l�C�e�B�u��JDBC�h���C�o�������‹��ɂ́A�����Â��ƌ�����ł��傤�B