Install JEUS server runtime on Eclipse

http://technet.tmax.co.kr/kr/pds/bin/jeus/readBoardForm.do?bbsCode=bin_jeus&fc=pds&sc=pds_bin&tc=pds_bin_jeus&currentPage=1&seqNo=38947&categoryId=&productCode=&range=10&searchType=ALL&searchText=

JEUS의 Boot, Down, Deploy 기능을 Eclipse를 사용자들을 위해서 제공하는 Plugin입니다.

* Requirements for "JEUS + Eclipse(galileo) Bridge"
JEUS Version
아래 명시된 JEUS 를 지원합니다.
• JEUS 5.0 : fix#27
• JEUS 6.0 : fix#6
plug -in
Bridge를 사용하기 위해서는 'eclipse IDE for javaee developers' 패키지나 webtools 플러그인이 설치된 이클립스가 필요합니다.
• eclipse-jee-galileo-win32.zip [다운로드]

* 설치방법
1. Eclipse에서 Help >  Install New Software 메뉴를 선택합니다.
2. Add 버튼을 선택 후 Archive 버튼을 선택합니다.
3. New Archive Site 메뉴를 선택 후 다운로드 받은 Eclipse(galileo) Bridge for JEUS.zip 파일을 선택합니다.
4. Finish 버튼을 선택하여 설치합니다.

* 메뉴얼
Eclipse에서 Help > Help Conents 메뉴에 JEUS 서버 설정 가이드를 참고하시면 됩니다.

AIX 에서 특정 port 를 사용하는 Process ID 찾기

# netstat -Aan | grep 8080
f1000500003e9bb8 tcp4       0      0  *.10431               *.*                   LISTEN

# rmsock f1000500003e9bb8 tcpcb
The socket 0xf1000500003e9808 is being held by proccess 4849780 (wsm).

Windows PowerShell 에서 Linux의 time 명령 사용하기

Measure-Command { dir }

Firefox sqlite-manager(plugin)를 firefox 없이 실행하기

* 아래 파일을 다운로드 받아 C:\Program Files (x86)\xulrunner 에 압축 해제
http://ftp.mozilla.org/pub/mozilla.org/xulrunner/releases/10.0.2/runtimes/xulrunner-10.0.2.en-US.win32.zip

* 아래 파일을 다운받아 C:\utils\sqlitemanager-xr-0.7.7-all에 압축 해제
http://sqlite-manager.googlecode.com/files/sqlitemanager-xr-0.7.7-all.zip

* 배치 파일에 아래 내용을 넣고 저장 & 실행



* xulrunner site
https://developer.mozilla.org/en-US/docs/XULRunner

* sqlite-manager site
http://sqlite-manager.googlecode.com

Install ffmpeg on Ubuntu 10.04 LTS

reference
http://ubuntuforums.org/showthread.php?t=786095
http://ffmpeg.org/trac/ffmpeg/wiki/UbuntuCompilationGuideLucid


$ mkdir /home/user0/ffmpeg_packages
$ cd /home/user0/ffmpeg_packages

$ sudo apt-get remove ffmpeg x264 libx264-dev yasm
$ sudo apt-get update

$ wget http://security.ubuntu.com/ubuntu/pool/multiverse/f/faac/libfaac0_1.26-0.1ubuntu2_amd64.deb
$ wget http://security.ubuntu.com/ubuntu/pool/multiverse/f/faac/libfaac-dev_1.26-0.1ubuntu2_amd64.deb

$ dpkg -i libfaac0_1.26-0.1ubuntu2_amd64.deb
$ sudo dpkg -i libfaac-dev_1.26-0.1ubuntu2_amd64.deb

$ sudo apt-get install -y build-essential git-core checkinstall texi2html \
  libopencore-amrnb-dev libopencore-amrwb-dev libtheora-dev libvorbis-dev zlib1g-dev


* yasm
$ cd /home/user0/ffmpeg_packages
$ wget http://www.tortall.net/projects/yasm/releases/yasm-1.2.0.tar.gz
$ tar xzvf yasm-1.2.0.tar.gz
$ cd yasm-1.2.0
$ ./configure
$ make
$ sudo checkinstall --pkgname=yasm --pkgversion="1.2.0" --backup=no --deldoc=yes --default


* x264
$ cd /home/user0/ffmpeg_packages
$ git clone --depth 1 git://git.videolan.org/x264
$ cd x264
$ ./configure --enable-static
$ make
$ sudo checkinstall --pkgname=x264 --default --pkgversion="3:$(./version.sh | \
    awk -F'[" ]' '/POINT/{print $4"+git"$5}')" --backup=no --deldoc=yes


* LAME
$ cd /home/user0/ffmpeg_packages
$ sudo apt-get remove libmp3lame-dev
$ sudo apt-get install nasm

$ wget http://downloads.sourceforge.net/project/lame/lame/3.99/lame-3.99.5.tar.gz
$ tar xzvf lame-3.99.5.tar.gz
$ cd lame-3.99.5
$ ./configure --enable-nasm --disable-shared
$ make
$ sudo checkinstall --pkgname=lame-ffmpeg --pkgversion="3.99.5" --backup=no --default \
    --deldoc=yes


* libvpx
$ cd /home/user0/ffmpeg_packages
$ git clone --depth 1 http://git.chromium.org/webm/libvpx.git
$ cd libvpx
$ ./configure
$ make
$ sudo checkinstall --pkgname=libvpx --pkgversion="$(date +%Y%m%d%H%M)-git" --backup=no \
    --default --deldoc=yes


* ffmpeg
$ cd /home/user0/ffmpeg_packages
$ git clone --depth 1 git://source.ffmpeg.org/ffmpeg
$ cd ffmpeg
$ ./configure --enable-gpl --enable-libfaac --enable-libmp3lame --enable-libopencore-amrnb \
  --enable-libopencore-amrwb --enable-libtheora --enable-libvorbis --enable-libvpx \
  --enable-libx264 --enable-nonfree --enable-version3 --enable-x11grab
$ make
$ sudo checkinstall --pkgname=ffmpeg --pkgversion="5:$(./version.sh)" --backup=no \
  --deldoc=yes --default
$ hash x264 ffmpeg ffplay ffprobe

Convert video file using QuickTime for Java (MOV -> MP4)

1. Install QuickTime 7
http://www.apple.com/quicktime/

2. Copy QTJava.zip
Source : C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip
Destination : ${JAVA_HOME}/jre/lib/ext

--------------------------------------------------------------------------------
* sample code
--------------------------------------------------------------------------------
package quicktime;

import java.io.File;

import org.apache.commons.lang.time.StopWatch;

import quicktime.io.IOConstants;
import quicktime.io.OpenMovieFile;
import quicktime.io.QTFile;
import quicktime.std.StdQTConstants;
import quicktime.std.movies.Movie;
import quicktime.std.qtcomponents.MovieExporter;
import quicktime.util.QTUtils;

public class QtjConverter {

    public static void main(String[] args) {
        String src = "c:\\temp\\Wildlife.mov";
        String dest = "c:\\temp\\Wildlife.mp4";
       
        StopWatch sw = new StopWatch();
        sw.start();
        try {
            boolean result = qtjConvert(src, dest);
            System.out.println("result="+result);
        }
        catch ( Exception e ) {
            e.printStackTrace();
        }
        sw.stop();
        long time = sw.getTime();
        System.out.println("time="+time);
    }
   
    public static boolean qtjConvert(String src, String dest) throws Exception {
        boolean result = false;
       
        QTSession.open();
       
        try {
            QTFile movieFile = new QTFile(src);
            Movie movie = Movie.fromFile (OpenMovieFile.asRead(movieFile));
            //MovieExporter
            //new Thread (new Exporter(movie)).start();
           
            QTFile destFile = new QTFile (new File (dest));
//            int flags = StdQTConstants.createMovieFileDeleteCurFile |
//                    StdQTConstants.createMovieFileDontCreateResFile |
//                    StdQTConstants.showUserSettingsDialog;
            int flags = StdQTConstants.createMovieFileDontCreateResFile;
           
//            int type = StdQTConstants.kQTFileTypeMovie;
//            type = QTUtils.toOSType("mpg4");
//            type = QTUtils.toOSType("MooV");
           
           
//            MovieExporter exporter = new MovieExporter (StdQTConstants.kQTFileTypeMovie);
//            movie.convertToFile(null, destFile, StdQTConstants.kQTFileTypeMovie,
//                    StdQTConstants.kMoviePlayer, IOConstants.smSystemScript,
//                    StdQTConstants.showUserSettingsDialog | StdQTConstants.movieToFileOnlyExport
//                            | StdQTConstants.movieFileSpecValid, exporter);
//            movie.convertToFile(destFile, StdQTConstants.kQTFileTypeMovie, 0, 0);
//            movie.convertToFile(destFile, StdQTConstants.kQTFileTypeMovie, StdQTConstants.kMoviePlayer, IOConstants.smAllScripts, flags);
//            movie.convertToFile(destFile, StdQTConstants.kQTFileTypeMovie, StdQTConstants.kMoviePlayer, IOConstants.smSystemScript, flags);
//            movie.convertToFile(destFile, QTUtils.toOSType("MooV"), 0, 0);
            movie.convertToFile(destFile, QTUtils.toOSType("mpg4"), 0, 0);
           
            result = true;
        }
        catch ( Exception e ) {
            throw e;
        }
       
        QTSession.close();
       
        return result;
    }

}

sqlite에 auto increment 값 입력하고 입력된 일련번호 값 받아오기

CREATE TABLE userInfo
  userId INTEGER PRIMARY KEY,
  first_name TEXT NOT NULL,
  last_name TEXT NOT NULL,
);


<insert id="insertUser" parameterType="userVo">
<![CDATA[
INSERT INTO userInfo (
first_name
   ,last_name
) VALUES (
    #{firstName}
   ,#{lastName}
)
]]>
<selectKey keyProperty="userId" resultType="int">
SELECT LAST_INSERT_ROWID()
</selectKey>
</insert>


public class UserInfoDAOImpl extends BaseDAO implements UserInfoDAO{
    @Override
    public int insertJob(UserVo userVo) throws OSPException {
        int returnVal = -1;
        returnVal = (Integer) getSqlSession().insert("com.test.dao.UserInfoDAO.insertUser", userVo);
       
        System.out.println("userId="+userVo.getUserId());
       
        return returnVal;
    }
   
}