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

        try {
            // setup configurations.
            Config config = Config.load(propertyFilePath);


            // setup database connection information.
            ConnectionPool pool = ConnectionPool.getInstance("vfs");
            pool.setJDBCDriver(
                    config.getProperty("org.sd_network.vfs.db.JDBCDriver"));
            pool.setDatabaseURL(
                    config.getProperty("org.sd_network.vfs.db.URL"));
            pool.setDatabaseUserName(
                    config.getProperty("org.sd_network.vfs.db.UserName"));
            pool.setDatabasePassword(
                    config.getProperty("org.sd_network.vfs.db.Password"));


            // setup database schema.
            Schema.setup();

View Full Code Here

        if (loginName == null || loginName.length() == 0)
            throw new IllegalArgumentException("loginName is empty.");
        if (password == null || password.length() == 0)
            throw new IllegalArgumentException("password is empty.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            PreparedStatement stmt = con.prepareStatement(
                    "SELECT user_id, login_name, is_admin FROM user " +
                    " WHERE login_name = ? AND password = ?");
            stmt.setString(1, loginName);

View Full Code Here

     *          Throws when each argument is specified null or empty.
     */
    public static final User create(String loginName, String password, 
            boolean isAdmin)
    {
        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            con.setAutoCommit(true);
            return create(con, loginName, password, isAdmin);
        } catch (SQLException e) {
            throw new DBException(e);

View Full Code Here

        User user = userSession.getUser();
        if (!user.isAdmin())
            throw new PermissionException(
                    "You have not permission as an Administrator.");


        ConnectionPool pool = ConnectionPool.getInstance("vfs");
        Connection con = pool.engageConnection(10);
        try {
            con.setAutoCommit(false);
            User newUser = UserDB.create(con, loginName, password, isAdmin);


            // If new user is not administrator, create HOME directory of user.

View Full Code Here

     */
    public byte[] getContent() {
        if (_content != null)
            return _content;


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

View Full Code Here

        if (_initialized)
            return;


        // setup database connection informations.
        try {
            ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        } catch (ConnectionPoolException e) {
            throw new SectorException(e.getMessage());
        }


        try {

View Full Code Here

            throw new IllegalArgumentException("content was empty.");
        if (content.length < size || size <= 0)
            throw new IllegalArgumentException("invalid size.");


        String sectorID = UUID.randomUUID().toString();
        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "INSERT INTO sector " +
                    " (sector_id, file_id, seq_num, size, content) " +

View Full Code Here

     */
    public static final byte[] getContent(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 content FROM sector WHERE sector_id=?");
            stmt.setString(1, sectorID);

View Full Code Here

        if (content.length == 0)
            throw new IllegalArgumentException("content was empty.");
        if (content.length < size || size <= 0)
            throw new IllegalArgumentException("invalid size.");


        ConnectionPool pool = ConnectionPool.getInstance("vfssector");
        Connection con = pool.engageConnection(10);
        PreparedStatement stmt = null;
        try {
            stmt = con.prepareStatement(
                    "UPDATE sector SET size=?, content=? " +
                    "WHERE sector_id=?");

View Full Code Here

     */
    public static final Sector getLastSector(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, file_id, seq_num, size " +
                    "FROM " +

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.