Examples of org.sd_network.db.ConnectionPool

org.sd_network.db.ConnectionPool
{@link java.sql.Connection} �̃C��X�^��X��Ǘ��ConnectionPool��܂��B�قȂ�f�[�^�x�[�X�ڑ��ConnectionPool��񋟂�� \�ŁA {@link #getInstance(String)} ��\�b�h�̈��Ɏw�肷�鎯�ʎq�ɂ��ĈقȂ�ConnectionPool�C��X�^��X��Ǘ��܂��B�f�[�^�x�[�X�ڑ�� {@link ConnectionParameter} �ŊǗ��Ă��AConnectionPool�C��X�^��X��ɈقȂ��g�p��܂��B
�P��ConnectionPool�C��X�^��X�ł́A {@link #MAX_POOL_SIZE} �Œ�`��Ă��鐔�� {@link java.sql.Connection} �C��X�^��X��ێ��鎖��ł��܂��B
Connection�C��X�^��X�� {@link #engageConnection(long)} ��\�b�h�Ŏ擾��܂��B��̃��\�b�h�ł́AConnectionPool�ɗ��p�\��Connection ��݂��邩�ǂ��m�F��A��݂��ꍇ�͂��Connection��Ԃ��܂��B ConnectionPool�ł́A��Connection��pool��폜��A�g�p��Connection�� J�E��g��܂��B
ConnectionPool�ɗ��p�\��Connection��݂��A��Pool��Ă��Connection �� {@link #MAX_POOL_SIZE} �ɓ��B��Ă��Ȃ��ꍇ�A�V��Connection�C��X�^��X�𐶐��Ă��A�g�p��Connection��J�E��g��A ��Connection��Ԃ��܂��B
ConnectionPool�ɗ��p�\��Connection��݂��A��Pool��Ă��Connection �� {@link #MAX_POOL_SIZE} �ɓ��B��Ă��ꍇ�A��Ɏw�肳�ꂽ�^�C��A�E�g��ԁi�b�j��o�߂��܂ŁAPool�ɗ��p�\��Connection��ԋp�� ̂�҂��܂��B
Connection�̕ԋp�� {@link java.sql.Connection#close()} ��\�b�h��Ăяo��ƂŎ��I�ɍs��܂��B {@link #engageConnection(long)} ��\�b�h��Ԃ��̂́A��ۂɂ� {@link ConnectionProxy} �C��X�^��X�ł��A{@link java.sql.Connection} ��b�v��Ă��܂��BConnectionProxy��close()��\�b�h�ł́AConnection��close()��\�b�h�͌Ăяo��AConnectionPool �ւ̕ԋp��s��邾��ł��B��̍ہA�S�Ẵg��U�N�V��̓��[��o�b�N ��܂��B
�܂��AConnection��close()��\�b�h��Ăяo��Ȃ��Ă��Afinalize()��\�b�h ��Ăяo��ꂽ��iGC��j��ConnectionPool�ւ̕ԋp��s��܂��A finalize()��\�b�h��Ăяo��^�C�~��O��JVM�̎��Ɉˑ��\�� 邽�߁A��҂��͍s�킸�A�K��Connection�g�p��close()��\�b�h ��ĂԂ悤�ɂ��Ă��B
$Id$ @author Masatoshi sato

     */
    public static final long getFileSize(String fileID) {
        if (fileID == null)
            throw new NullPointerException("fileID.");


        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "SELECT sum(size) as total_bytes " +
                    "FROM sector " +

View Full Code Here

     */
    public static final long getTotalSectorNumber(String fileID) {
        if (fileID == null)
            throw new NullPointerException("fileID");


        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "SELECT count(*) as total_sector_number " +
                    "FROM sector " +

View Full Code Here

     */
    public static final String[] getSectorIDs(String fileID) {
        if (fileID == null)
            throw new NullPointerException("fileID");


        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "SELECT sector_id FROM sector " +
                    "WHERE file_id=? " +

View Full Code Here

     *
     * @throws  DBException
     *          �f�[�^�x�[�X�A�N�Z�X���ɃG���[�����������ꍇ�ɃX���[���܂��B
     */
    public static final long getUsedBytes() {
        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "SELECT sum(size) as used_bytes FROM sector");
            ResultSet rs = stmt.executeQuery();

View Full Code Here

     */
    private static final boolean exists(String sectorID) {
        if (sectorID == null)
            throw new NullPointerException("sectorID.");


        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "SELECT sector_id FROM sector WHERE sector_id=?");
            stmt.setString(1, sectorID);

View Full Code Here

        if (fileID == null || fileID.trim().length() == 0)
            throw new IllegalArgumentException("fileID is empty.");
        if (ownerID == null || ownerID.trim().length() == 0)
            throw new IllegalArgumentException("ownerID is empty.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            PreparedStatement stmt = con.prepareStatement(
                    "SELECT count(*) as number_of_child " +
                    "FROM vfs_file " +
                    "WHERE parent_file_id=? AND owner_id=?");

View Full Code Here

        if (fileID == null || fileID.trim().length() == 0)
            throw new IllegalArgumentException("fileID is empty.");
        if (ownerID == null || ownerID.trim().length() == 0)
            throw new IllegalArgumentException("ownerID is empty.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            PreparedStatement stmt = con.prepareStatement(
                    "SELECT file_id, name, type_id, parent_file_id, size, " +
                    " owner_id, created " +
                    "FROM vfs_file " +

View Full Code Here

        if (fileName == null || fileName.trim().length() == 0)
            throw new IllegalArgumentException("fileName is empty.");
        if (ownerID == null || ownerID.trim().length() == 0)
            throw new IllegalArgumentException("ownerID is empty.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            PreparedStatement stmt = con.prepareStatement(
                    "SELECT file_id, name, type_id, parent_file_id, size, " +
                    " owner_id, created " +
                    "FROM vfs_file " +

View Full Code Here

        if (parentFileID == null || parentFileID.trim().length() == 0)
            throw new IllegalArgumentException("parentFileID is empty.");
        if (ownerID == null || ownerID.trim().length() == 0)
            throw new IllegalArgumentException("ownerID is empty.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            PreparedStatement stmt = con.prepareStatement(
                    "SELECT file_id, name, type_id, parent_file_id, size, " +
                    " owner_id, created " +
                    "FROM vfs_file " +

View Full Code Here

        return create(con, name, 2, parentID, size, ownerID);
    }




    public static final void delete(String fileID, String ownerID) {
        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            con.setAutoCommit(true);
            delete(con, fileID, ownerID);
        } catch (SQLException e) {
            throw new DBException(e);

View Full Code Here

0 1 2

TOP

Related Classes of org.sd_network.db.ConnectionPool

org.sd_network.vfs.db.UserDB

org.sd_network.vfs.db.VfsFileDB

org.sd_network.vfs.VfsContext

org.sd_network.vfs.VfsService

org.sd_network.vfssector.db.Sector

org.sd_network.vfssector.db.SectorDB

org.sd_network.vfssector.VfsSectorDriver

java.sql.Connection

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.