Examples of org.sd_network.db.ConnectionPool.engageConnection()

org.sd_network.db.ConnectionPool.engageConnection()
ConnectionPool�ɂ�� {@link java.sql.Connection} �C��X�^��X��Ԃ��܂��B��Connection��݂��Ȃ��ꍇ�A�w�肳�ꂽ�^�C��A�E�g��Ԃ܂� �ȉ��̏��J��Ԃ��܂��B
- ConnectionPool�ɕێ��Ă��Connection�� {@link #MAX_POOL_SIZE}�ɒB��Ă��Ȃ��ꍇ�A�V�K��Connection�𐶐��܂��B
- ConnectionPool�ɕێ��Ă��Connection�� {@link #MAX_POOL_SIZE}�ɒB��Ă��ꍇ�A�w�肳�ꂽ�^�C��A�E�g��Ԃ܂ŁA {@link #WAIT_TIME} ��ConnectionPool��Connection��ԋp��̂��҂��A�ԋp��ꂽ�炻��Connection��Ԃ��܂��B
��A�^�C��A�E�g��Ԃ܂łɁAConnection�̐��Connection�� ԋp��Ȃ��ꍇ�A {@link org.sd_network.db.ConnectTimeoutException}��X��[��܂��B
��̃��\�b�h�͓��Ă��܂��B ��̃��\�b�h��́A��X��b�h��̂��̃��\�b�h�̌Ăяo�� ҂��܂��B��āAConnection�̍ő吔��Connection�̃`�F�b�N�A�E�g ��͕ۏႳ��܂��B @param timeout Connection��擾��܂ł̃^�C��A�E�g��ԁi�b�j @return {@link java.sql.Connection} �̃C��X�^��X�B @throws ConnectTimeoutException �w�肳�ꂽ�^�C��A�E�g��Ԃ܂ł�Connection��擾�ł��Ȃ�� ꍇ�ɃX��[��܂��B

            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

     */
    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

        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 (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

            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

    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

0 1

TOP

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.