스프링필드 에버그린테라스 742

.

.

.

/: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY.

          (i.e., without -a or -p options)

                                                                             [FAILED]

*** An error occurred during the file system check.

*** Dropping you to a shell; the system will reboot

*** when you leave the shell.

Give root password for maintenance

(or type Control-D to continue): _

  (Repair filesystem) 1 # _

# e2fsck /dev/sda1

# e2fsck /dev/sda2

# e2fsck /dev/sda3

....

SELECT a.EMAIL

    FROM VM_OUT_SAWON a

    WHERE NOT EXISTS(SELECT email FROM VM_SAWON b WHERE a.email=b.email)

LPAD/RPAD(대상값 또는 컬럼, 대상값을 포함하여 채울크기, 채울값)

mysql -e 'SELECT * FROM 테이블명' -uDBID -pDBPASS DB_NAME > out.txt

<script language="javascript" type="text/JavaScript">
 function gogo_link() {
  if (window.opener && !window.opener.closed) {
   window.opener.location="주소를 입력합니다!";
   window.close();
  } else {
   alert("부모창이 닫혀있습니다");
  }
 }
</script>

<a href="javascript:gogo_link();">GOGO</a>

Can't find file: './CrediMail/tb_webhard554_hits.frm' (errno: 24)

.....

my.cnf 파일에

open_files_limit = 4096

mysql> show variables like 'open_files%';

[Warning] Could not increase number of max_open_files to more than 1024 (request: 4096)

root계정으로 들어간후

# vi /etc/security/limits.conf

을 열어서

....

web(계정명)        soft    nofile           4096

web(계정명)        hard    nofile           4096

....

추가하고 리눅스 재기동!

insert into db values('localhost','CrediMail_dev','mobigen','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');

flush privileges;

cp -a mail mail_dev

mysqldump -tn --skip-opt --default-character-set=euckr -uuserid -puserpass DBNAME userfile --where="email='condtion_value'"

    System.out.println("OS["+ System.getProperty("os.name")+"]" );

    System.out.println("OS_VER["+ System.getProperty("os.version")+"]" );

    System.out.println("USER["+ System.getProperty("user.name")+"]" );

    System.out.println("File_Separator["+ System.getProperty("file.separator")+"]" );

    System.out.println("Path_Separator["+ System.getProperty("path.separator")+"]" );

    System.out.println("Current_working_dir["+ System.getProperty("user.dir")+"]" );

OS[AIX]

OS_VER[5.3]

USER[webmail]

File_Separator[/]

Path_Separator[:]

Current_working_dir[/was/webmail/myst/java_test]

apple 사과

banana 바나나

kiwi 키위

subak 수박

melon 멜론

orange 오렌지

static void jwtest() {

try {

BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream("jwtest.txt"), "MS949"));

//BufferedReader br = new BufferedReader(new FileReader("jwtest.txt"));

String str ="";

Map<String, String> fruit = new HashMap<String, String>();

while ( (str = br.readLine()) != null ) {

String[] arr = str.split("\t");

fruit.put(arr[0], arr[1]);

}

Iterator kv = fruit.entrySet().iterator();

while(kv.hasNext()) {

Map.Entry entry = (Map.Entry) kv.next();

System.out.println(entry.getKey()+"__"+entry.getValue());

}

br.close();

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

CREATE TABLE JWUSER_NEW

(

  SEQ_USER         NUMBER(19),

  USERID           VARCHAR2(60 BYTE),

  USERDOMAIN       VARCHAR2(100 BYTE),

  ....

  ....

  ....

  CONSTRAINT JWUSER_NEW_PK PRIMARY KEY (seq_user)

);

INSERT INTO jwuser_new(SEQ_USER, USERID, USERDOMAIN, ....) SELECT * FROM jwuser;

-- 기존JWUSER -> JWUSER_OLD 로 변경

ALTER TABLE JWUSER RENAME CONSTRAINT JWUSER_PK to JWUSER_OLD_PK;

ALTER TABLE JWUSER RENAME TO JWUSER_OLD;

-- 신규테이블 JWUSER_NEW -> JWUSER 로 변경

ALTER TABLE JWUSER_NEW RENAME CONSTRAINT JWUSER_NEW_PK to JWUSER_PK;

ALTER TABLE JWUSER_NEW RENAME TO JWUSER;

SQL> SELECT TABLE_NAME, CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME IN('JWUSER');

TABLE_NAME                            CONSTRAINT_NAME

------------------------------ ------------------------------

JWUSER                                    JWUSER_PK

ALTER TABLE tuser_temp RENAME TO tuser;

my $euckr_to_utf8 = Text::Iconv->new("EUC-KR","UTF-8");

$ibuf = $euckr_to_utf8->convert($ibuf);

Unsupported conversion from EUC-KR to UTF-8: 잘못된 인수입니다. at ./test_encoding.pl line 12.

    my $euckr_to_utf8 = Text::Iconv->new("eucKR","utf8");

    $ibuf = $euckr_to_utf8->convert($ibuf);

package com.jw.customized.sync;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.quartz.JobExecutionContext;

import org.quartz.JobExecutionException;

import org.quartz.StatefulJob;

import org.springframework.scheduling.quartz.QuartzJobBean;

import com.jw.customized.migration.DeptMigration;

public class SyncJob extends QuartzJobBean implements StatefulJob {

private static final Log logger = LogFactory.getLog(SyncJob.class);

private DeptMigration deptMigration = null;

public DeptMigration getDeptMigration() {

return deptMigration;

}

public void setDeptMigration(DeptMigration deptMigration) {

this.deptMigration = deptMigration;

}

@Override

protected void executeInternal(JobExecutionContext jobexecutioncontext)

       throws JobExecutionException {

if (this.deptMigration != null) {

if (this.deptMigration.isDoingExecute()) {

logger.warn("실행중입니다.");

} else {

this.deptMigration.execute();

}

}

}

}

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">

<beans default-init-method="initialize">

.....

.....

        <bean id="migration.DeptMigration" class="com.jw.customized.migration.DeptMigration">

                <property name="dbConnectionManager"><ref bean="datasource.DBConnectionManager" /></property>

        </bean>

select * from user_sequences;

drop sequence SEQ_이름;

CREATE SEQUENCE SEQ_이름 START WITH 새로운값;

String euckr = “가나다”;  // EUC-KR

String utf8 = new String(eucStr.getBytes(“euc-kr”), “utf-8″);

INSERT INTO userfile(file_seq, fdate, filehosts)  VALUES('46', to_date('2011-07-15 08:26:54','YYYY-MM-DD HH24:MI:SS'), 'localhost');

 to_date('15/07/05 12','DD/MM/RR HH')