04.IT Knowledge2009. 5. 17. 15:22

데비안의 apt-get 간단 사용 방법

apt는 최신 패키지를 다운로드 하여 설치하게 되는데 upgrade 하기전에 update 해서 source.list 를 갱신 하는것이 좋다.

1. 패키지 캐쉬 갱신 및 자동 업그레이드
# apt-get update
# apt-get upgrade

2. 개별 패키지 설치
# apt-get install <패키지명>

3. 원하는 패키지 찾기
# apt-cache  serach <패키지명>

4. 원하는 패키지 찾은 다음 정보 출력
# apt-cache show <패키지명>

5. 의존성 검사 수행하면서 업그레이드
# apt-get -s dist-upgrade

6. 설치한 패키지에 이상이 있어 다시 설치시
# apt-get --reinstall install <패키지명>

7. CD-ROM 목록 추가
# apt-cdrom add

8. 패키지 삭제
# apt-get remove <패키지명>
또는 # dpkg -P <패키지명>

9. 삭제하는 패키지의 설정화일들가지 모두 삭제시
# apt-get --purge remove <패키지명>

10. dselect에서 선택한 패키지의 설치 및 삭제
# apt-get dselect-upgrade

11. 설치된 패키지를 볼때
# dpkg -l

참고)   apt-get install 명령어로 받은 deb 파일의 저장 위치
          /var/cache/apt/archive/
        위 폴더에 .deb 패키지파일로 저장됨

출처 : http://www.fduser.org/blog/65

Posted by 아주 오래된 미래
04.IT Knowledge/Java2009. 3. 22. 09:34

JBoss Virtualhost 설정

server.xml

<!--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    +
    + javarang.net
    +
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-->
        <Host name="javarang.test" autoDeploy="true" deployOnStartup="true"
            configClass="org.jboss.web.tomcat.security.config.JBossContextConfig"
            deployXML="false">
            <Context path="" docBase="D:\\workspaces\\javarang.test" reloadable="true"/>
            <Alias>www.javarang.test</Alias>
            <Alias>javarang.test</Alias>
            <Valve className="org.jboss.web.tomcat.service.jca.CachedConnectionValve"
                cachedConnectionManagerObjectName="jboss.jca:service=CachedConnectionManager"
                transactionManagerObjectName="jboss:service=TransactionManager" />
            <Valve className="org.apache.catalina.valves.AccessLogValve" prefix="access" suffix=".log"
                fileDateFormat="yyyy-MM-dd"
                pattern="%t [%a] [%l] [%m] [%U] [%H] [%q] [%s] [%b] [%{User-Agent}i] [%{Referer}i]"
                directory="D:\\workspaces\\javarang.test\\logs"/>
        </Host>

jboss-web.xml
<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
  <security-domain flushOnSessionInvalidation="false"/>
  <context-root>/</context-root>
  <virtual-host>javarang.test</virtual-host>
</jboss-web>
Posted by 아주 오래된 미래
04.IT Knowledge/Adobe Flex2009. 3. 3. 14:33

Flex3 SDK를 사용한 일반 Component build

<?xml version="1.0" encoding="utf-8"?>
<project name="Flex3 SDK Sample" default="all" basedir="../">
<taskdef resource="flexTasks.tasks" classpath="${basedir}/ant/flexTasks.jar" />

<property name="src"            value="${basedir}/src"/>
<property name="build"          value="${basedir}/deploy"/>
<property name="config"         value="${basedir}/ant/config"/>
<property name="FLEX_HOME"      value="D:/flex_sdk_3"/>
<property name="targetbuild"    value="C:/Tomcat/webapps/JavarangFlex/resources/flex3"/>

<target name="all">
    <antcall target="JavarangFlex"/>
</target>
<target name='JavarangFlex'>
    <property name='targetsrc' value='${src}' />
    <property name='targetbuild' value='${targetbuild}' />
    <property name='targetconfig' value='${config}' />

    <mxmlc file='${targetsrc}/Sample.mxml'
        output='${targetbuild}/Sample.swf'
        actionscript-file-encoding='UTF-8'
        optimize="true" debug="false"
        services='${config}/services-config.xml'>

        <load-config filename='${FLEX_HOME}/frameworks/flex-config.xml'/>
        <context-root>JavarangFlex</context-root>
        <source-path path-element='${FLEX_HOME}/frameworks'/>

        <compiler.library-path dir='${FLEX_HOME}/frameworks' append='true'>
            <include name='libs'/>
            <!--include name="${localePath}"/-->
        </compiler.library-path>
    </mxmlc>
</target>
</project>

Posted by 아주 오래된 미래
04.IT Knowledge/Java2009. 1. 1. 18:56

JavaFX Eclipse Plug-in 설치

http://www.riaportal.net/?mid=JavaFX_SeniorPapers&_cm_=23&document_srl=189&listStyle=&cpage=

위의 URL 을 참조할 것.
Posted by 아주 오래된 미래
04.IT Knowledge/SAS2008. 12. 31. 16:06

시스템(OS) 명령어 실행 후 결과 값 Dataset으로 받아오기

filename ff pipe 'dir /p' ;

data _null ;
  infile ff;
  input ;
  put _infile_ ;
  a = _infile_ ;
run;
Posted by 아주 오래된 미래
04.IT Knowledge/SAS2008. 12. 31. 16:02

현재 세션에서 작업중인 work의 경로 알아내기

%macro tttt;
data _null_;
aa=pathname("work");
put aa=;
run;
%mend tttt;
%tttt;
Posted by 아주 오래된 미래
04.IT Knowledge/RDBMS2008. 12. 18. 14:42

Join 및 Union 기본 개념

[SQL 작성 요령]
1. 중심축으로 삼을 테이블을 선정한다.
2. 건수를 기록한다.
3. 가로로 정보를 추가하는 경우 JOIN을 세로로 정보를 추가하는 경우는 UNION을 사용한다.
4. 건수를 조회하여 확인한다.

[[ 예제 테이블 ]]

T1 T2
C11 C12 C21 C22
A 1 E 11
B 2 F 12
C 3 G 13
D 4
E 5
F 6

INNER JOIN (건수의 손실을 주의할 것)
SQL>>
SELECT T1.C11, T1.C12, T2.C22
  FROM T1
 INNER JOIN T2
         ON T1.C11 = T2.C21
RESULT>>
C11 C12 C22
E 5 11
F 6 12

LEFT OUTER JOIN (의도치 않은 Null의 발생, 건수의 증가를 주의할 것)
SQL>>
SELECT T1.C11, T1.C12, T2.C22
  FROM T1
  LEFT OUTER JOIN T2
         ON T1.C11 = T2.C21
RESULT>>
C11 C12 C22
A 1 Null
B 2 Null
C 3 Null
D 4 Null
E 5 11
F 6 12

RIGHT OUTER JOIN (가급적 Left outer join으로 사용할 것을 고려한다.)
SQL>>
SELECT T1.C11, T1.C12, T2.C21, T2.C22
  FROM T1
  FULL OUTER JOIN T2
         ON T1.C11 = T2.C21
RESULT>>
C11 C12 C21 C22
A 1 Null Null
B 2 Null Null
C 3 Null Null
D 4 Null Null
E 5 E 11
F 6 F 12
Null Null G 13

UNION (중복이 제거된다. 정렬이 일어나므로 속도의 저하가 있을 수 있다.)
SQL>>
SELECT C11, C12
  FROM T1
UNION
SELECT C21, C22
  FROM T2
RESULT>>
C11 C12
A 1
B 2
C 3
D 4
E 5
F 6
G 13

UNION ALL
SQL>>
SELECT C11, C12
  FROM T1
UNION ALL
SELECT C21, C22
  FROM T2
RESULT>>
C11 C12
A 1
B 2
C 3
D 4
E 5
F 6
E 11
F 12
G 13

Posted by 아주 오래된 미래
04.IT Knowledge/RDBMS2008. 11. 28. 18:36

Oracle Tablespace의 크기를 MB 단위로 조회하고, 관련 정보를 조회하는 쿼리

SELECT TS.STATUS
     , DATA.NAME
     , TS.CONTENTS
     , EXTENT_MANAGEMENT
     , DATA.MBYTES "SPACE(MB)"
     , FREE.FREE "FREE(MB)"
     , TRUNC((DATA.MBYTES-FREE.FREE)/DATA.MBYTES*100,2) "Used(%)"
  FROM (SELECT TABLESPACE_NAME             AS NAME
             , TRUNC(SUM(BYTES/1024/1024)) AS MBYTES
          FROM DBA_DATA_FILES
         GROUP BY TABLESPACE_NAME
       ) DATA
     , (SELECT FREE.TABLESPACE_NAME
             , TRUNC(SUM(FREE.BYTES)/1024/1024,1) AS FREE
          FROM DBA_FREE_SPACE FREE
         GROUP BY FREE.TABLESPACE_NAME
        ) FREE
     , DBA_TABLESPACES    TS
 WHERE DATA.NAME = FREE.TABLESPACE_NAME
   AND DATA.NAME = TS.TABLESPACE_NAME
;

SELECT TS.STATUS
     , DATA.FILE_NAME
     , DATA.NAME
     , DATA.MBYTES "SPACE(MB)", FREE.FREE "FREE(MB)"
     , TRUNC((DATA.MBYTES-FREE.FREE)/DATA.MBYTES*100,2) "Used(%)"
  FROM (SELECT TABLESPACE_NAME NAME
             , FILE_NAME
             , FILE_ID
             , TRUNC(BYTES/1024/1024) MBYTES
          FROM DBA_DATA_FILES
        ) DATA
     , (SELECT TABLESPACE_NAME
             , FILE_ID
             , TRUNC(BYTES/1024/1024,1) FREE
          FROM DBA_FREE_SPACE FREE
        ) FREE
     , DBA_TABLESPACES    TS
 WHERE DATA.NAME    = FREE.TABLESPACE_NAME
   AND DATA.NAME    = TS.TABLESPACE_NAME
   AND DATA.FILE_ID = FREE.FILE_ID
   AND DATA.NAME    NOT IN ('UNDOTBS1', 'SYSTEM')
;
Posted by 아주 오래된 미래
04.IT Knowledge/SAS2008. 11. 27. 17:07

dataset 지우기

/* work 전체 지움 */
proc datasets library=work kill; run;

/* work.aa 데이터셋 지움 */
proc datasets library=work nolist;
delete aa;
run;
Posted by 아주 오래된 미래
01.살아가며.../퍼온글2008. 11. 23. 22:40

Eclipse for SilverLight

http://www.eclipse4sl.org/download/




Installation Guide

 

If you are looking for the source code of eclipse4sl, you'll get the download informations from the Community page.

 

eclipse4SL brings 2 experiences for the Eclipse Developer: it’s either you work in an Eclipse universe or you need to go back and forth between Eclipse and Microsoft Silverlight Tools (Visual Studio for development and Expression Blend for Design). We’ll call those configurations Pure Eclipse and Mixed Eclipse respectively.

1. Pure Eclipse configuration

If you want eclipse4SL to work Visual Studio and/or Expression Blend, you can follow the Pure Eclipse Configuration Steps, then take the Mixed Eclipse steps.

 

1.1 Pre-requisites

Check the following products are installed on your machine, or proceed to their installation in the following order :

 

 

1.2 eclipse4SL installation

You’ve got 2 options to install the Eclipse Tools for Silverlight : Eclipse Update or Offline installation.

 

The Eclipse Update wizard consists in an online installation. You can use this solution if your machine is correctly connected to the Internet. The installation is pretty straightforward and it doesn't require deep knowledges of the Eclipse environment. The Eclipse update wizard finds and installs all the required plugins.

 

The offline installation is used when your machine is not connected to the Internet or in case there is a firewall that prevents to access the Eclipse update infrastructure. You will be asked to download all required plugins beforehand.

 

1.2.1. Eclipse Update Wizard

 

Below are the step by step instructions for configuring Eclipse IDE with the eclipse4SL plugin package.

 

To install eclipse4SL, open Eclipse, select Help->Software Updates....

 

 

Select the "Available Software" tab and click the "Add Site..." button.

 

 

In the Add Site dialog, fill in the Location with http://www.eclipse4sl.org/update/, which corresponds to the eclipse4SL Web update site. Then click OK. If you encounter an error, it may be because you forgot the last “/” in the URL or because you’ve got firewall restrictions. In the latter case, proceed with the Offline Installation procedure.

 

 

Select the Eclipse Tools for Microsoft Silverlight entry and click Install button. Please see below screenshot.

 

 

In the next dialog, check the Eclipse Tools for Microsoft Silverlight, click Next button.

 

 

Then read carefully the license agreement. If you accept all conditions, select I accept... option and click Finish button.

 

 

Now, restart your Eclipse for the changes to take effect.

 

To check the plugin installation is successful, you can select Help->About Eclipse SDK. In the dialog box you will see a new icon with the eclipse4SL logo, next to the Eclipse Icon. .

 

 

When you click on the eclipse4SL icon, you should see the picture like below. Click OK to finish.

 


1.2.2. Offline installation

 

eclipse4SL relies on the following additional plugins, which are not part of Eclipse Basic 3.4.1 distribution.

 

EMF v2.4.1 Runtime Minimum executable code: emf-runtime-2.4.1.zip or equivalent
EMF XSD v2.4.1 Runtime Minimum executable code: xsd-runtime-2.4.1.zip or equivalent
Graphical Editing Framework (GEF): GEF-SDK-3.4.1.zip or equivalent
Web Standard Tools: wtp-wst-R-3.0.2.zip or equivalent

 

Therefore we recommend the all-in-one Eclipse distribution: Eclipse IDE for Java EE Developers.

 

And the download one of eclipse4SL distributions below:

 

Unzip and copy it into the folder where your Eclipse is installed, not in Eclipse folder. All plugins and features must install under the plugins and features folder in eclipse respectively.

 

2. Mixed mode

 

This configuration is best suited for Eclipse developpers who need to work with Visual Studio or Expression Blend developers and designers. It allows you to open Visual Studio and Expression Blend from Eclipse.

After following the Pure Eclipse configuration, installation steps,  proceed to the following installations :

Posted by 아주 오래된 미래

티스토리툴바