'예제' 태그의 글 목록

1. 필요한 정보

- URL:Port

- RequestMapping 정보

ex) http://127.0.0.1:8080/getData

- URL:PORT => http://127.0.0.1:8080

- RequestMapping => getData

> 자바 문장

@RequestMapping(value = "/getData", method = RequestMethod.POST)

2. 보낼 데이터

- 일반적인 Parameter인 경우가 아닌 param 으로 Hashmap 데이터 전송시 예제

xmin:-111.11111

ymin:20.40121

xmax:-95.1231231

ymax:26.99383

3. POSTMAN 설정하기

- 주소창에 POST 타입(Java에서 POST 타입으로 받기로 되어 있음)과 RequestMapping값을 맞춰줍니다.

- Header 설정 값들을 맞춰줍니다.

> Key 값 : Content-Type / Value 값 : application/json

> Key 값 : Accept / Value 값 : application/json

> Body에 raw로 선택후 입력 창에 다음과 같은 형태로 값을 입력합니다.

{
"xmin":-111.11111,
"ymin":20.40121,
"xmax":-95.1231231,
"ymax":26.99383
}

Send를 눌러 전송하면 정상적으로 값을 보내고 받아오는 것을 알수 있습니다.

'UTILITY' 카테고리의 다른 글

Scouter Batch 설정 옵션 (1)	2020.06.15
ghost 옵션 (0)	2019.11.27
정규식 방법 (0)	2014.06.17
Process Hacker (0)	2014.03.26
SSH System Administration Tool (0)	2014.03.01

// 그냥 배열을 통해 값 출력
function getRGB(number)
{

var rgb_list = new Array();
rgb_list[0] = '616264';
rgb_list[1] = 'D8C8B2';
rgb_list[2] = 'B82647';
rgb_list[3] = '683235';
rgb_list[4] = 'C23352';
rgb_list[5] = 'BF2F7B';
rgb_list[6] = 'BE577B';
rgb_list[7] = 'F9D537';
rgb_list[8] = 'F7B938';
rgb_list[9] = 'DDA28F';

document.myform.change_value11.value = rgb_list[number];
document.all.test2.style.background = rgb_list[number];
// 참고 사이트
//http://july.tistory.com/290
// http://parangsaekr.com.ne.kr/rgb01.html
}

// 대문자 헥사로 출력
function decimalToHex(number)
{
var my_number1 = (parseInt(number) * 10) % 256;
var my_number2 = (parseInt(number) * 20) % 256;
var my_number3 = (parseInt(number) * 30) % 256;

document.myform.change_value11.value = my_number1 + '_' + my_number2 + '_' + my_number3;
//alert(my_number1);

var rgb_r = my_number1.toString(16).toUpperCase();
var rgb_g = my_number2.toString(16).toUpperCase();
var rgb_b = my_number3.toString(16).toUpperCase();

alert(rgb_r.length);

// 2자리로 보정 처리
if (rgb_r.length == 1) rgb_r = '0' + rgb_r;
if (rgb_g.length == 1) rgb_g = '0' + rgb_g;
if (rgb_b.length == 1) rgb_b = '0' + rgb_b;

document.myform.change_value.value = rgb_r + '_' + rgb_g + '_' + rgb_b;
document.all.test2.style.background=rgb_r + rgb_g + rgb_b;

//n = (123).toString(16).toUpperCase();
//document.write(n, '<br />');
// 출력 결과: 7B
}
</script>

저작자표시

'Language > JAVASCRIPT' 카테고리의 다른 글

javascript : event.keyCode (0)	2010.10.01
브라우져에서 입력 키값 찾아내기 ! (0)	2010.01.18
[스크립트] [퍼옴] 즐겨찾기에 추가 (IE, FF, Opera 지원) (0)	2010.01.18
같은 페이지 계속 리로드(리로딩)하는 자바스크립트소스 (0)	2009.03.08

출처(Reference) : http://www.javafaq.nu/java-example-code-141.html

// -----------------------------------------------------------------------------
// CLOBFileExample.java
// -----------------------------------------------------------------------------

/*
* =============================================================================
* Copyright (c) 1998-2005 Jeffrey M. Hunter. All rights reserved.
*
* All source code and material located at the Internet address of
* http://www.idevelopment.info is the copyright of Jeffrey M. Hunter, 2005 and
* is protected under copyright laws of the United States. This source code may
* not be hosted on any other site without my express, prior, written
* permission. Application to host any of the material elsewhere can be made by
* contacting me at jhunter@idevelopment.info.
*
* I have made every effort and taken great care in making sure that the source
* code and other content included on my web site is technically accurate, but I
* disclaim any and all responsibility for any loss, damage or destruction of
* data or any other property which may arise from relying on it. I will in no
* case be liable for any monetary damages arising from such loss, damage or
* destruction.
*
* As with any code, ensure to test this code in a development environment
* before attempting to run it in production.
* =============================================================================
*/

import java.sql.*;
import java.io.*;
import java.util.*;

// Needed since we will be using Oracle's CLOB, part of Oracle's JDBC extended
// classes. Keep in mind that we could have included Java's JDBC interfaces
// java.sql.Clob which Oracle does implement. The oracle.sql.CLOB class
// provided by Oracle does offer better performance and functionality.
import oracle.sql.*;

// Needed for Oracle JDBC Extended Classes
import oracle.jdbc.*;

/**
* -----------------------------------------------------------------------------
* Used to test the functionality of how to load and unload text data from an
* Oracle CLOB.
*
* This example uses an Oracle table with the following definition:
*
* CREATE TABLE test_clob (
* id NUMBER(15)
* , do*****ent_name VARCHAR2(1000)
* , xml_do*****ent CLOB
* , timestamp DATE
* );
* -----------------------------------------------------------------------------
* @version 1.0
* @author Jeffrey M. Hunter (jhunter@idevelopment.info)
* @author http://www.idevelopment.info
* -----------------------------------------------------------------------------
*/

public class CLOBFileExample {

private String inputTextFileName = null;
private File inputTextFile = null;

private String outputTextFileName1 = null;
private File outputTextFile1 = null;

private String outputTextFileName2 = null;
private File outputTextFile2 = null;

private String dbUser = "SCOTT";
private String dbPassword = "TIGER";
private Connection conn = null;

/**
* Default constructor used to create this object. Responsible for setting
* this object's creation date, as well as incrementing the number instances
* of this object.
* @param args Array of string arguments passed in from the command-line.
* @throws java.io.IOException
*/
public CLOBFileExample(String[] args) throws IOException {

inputTextFileName = args[0];
inputTextFile = new File(inputTextFileName);

if (!inputTextFile.exists()) {
throw new IOException("File not found. " + inputTextFileName);
}

outputTextFileName1 = inputTextFileName + ".getChars.out";
outputTextFileName2 = inputTextFileName + ".Streams.out";

}

/**
* Obtain a connection to the Oracle database.
* @throws java.sql.SQLException
*/
public void openOracleConnection()
throws SQLException
, IllegalAccessException
, InstantiationException
, ClassNotFoundException {

String driver_class = "oracle.jdbc.driver.OracleDriver";
String connectionURL = null;

try {
Class.forName (driver_class).newInstance();
connectionURL = "jdbc:oracle:thin:@melody:1521:JEFFDB";
conn = DriverManager.getConnection(connectionURL, dbUser, dbPassword);
conn.setAutoCommit(false);
System.out.println("Connected.\n");
} catch (IllegalAccessException e) {
System.out.println("Illegal Access Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (InstantiationException e) {
System.out.println("Instantiation Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (ClassNotFoundException e) {
System.out.println("Class Not Found Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Open Connection).");
e.printStackTrace();
throw e;
}

}

/**
* Close Oracle database connection.
* @throws java.sql.SQLException
*/
public void closeOracleConnection() throws SQLException {

try {
conn.close();
System.out.println("Disconnected.\n");
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Closing Connection).");
e.printStackTrace();
if (conn != null) {
try {
conn.rollback();
} catch (SQLException e2) {
System.out.println("Caught SQL (Rollback Failed) Exception.");
e2.printStackTrace();
}
}
throw e;
}

}

/**
* Method used to print program usage to the console.
*/
static public void usage() {
System.out.println("\nUsage: java CLOBFileExample \"Text File Name\"\n");
}

/**
* Validate command-line arguments to this program.
* @param args Array of string arguments passed in from the command-line.
* @return Boolean - value of true if correct arguments, false otherwise.
*/
static public boolean checkArguments(String[] args) {

if (args.length == 1) {
return true;
} else {
return false;
}

}

/**
* Override the Object toString method. Used to print a version of this
* object to the console.
* @return String - String to be returned by this object.
*/
public String toString() {

String retValue;

retValue = "Input File : " + inputTextFileName + "\n" +
"Output File (1) : " + outputTextFileName1 + "\n" +
"Output File (2) : " + outputTextFileName2 + "\n" +
"Database User : " + dbUser;
return retValue;

}

/**
* Method used to write text data contained in a file to an Oracle CLOB
* column. The method used to write the data to the CLOB uses the putChars()
* method. This is one of two types of methods used to write text data to
* a CLOB column. The other method uses Streams.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void writeCLOBPut()
throws IOException, SQLException {

FileInputStream inputFileInputStream = null;
InputStreamReader inputInputStreamReader = null;
BufferedReader inputBufferedReader = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int chunkSize;
char[] textBuffer;
long position;
int charsRead = 0;
int charsWritten = 0;
int totCharsRead = 0;
int totCharsWritten = 0;

try {

stmt = conn.createStatement();

inputTextFile = new File(inputTextFileName);
inputFileInputStream = new FileInputStream(inputTextFile);
inputInputStreamReader = new InputStreamReader(inputFileInputStream);
inputBufferedReader = new BufferedReader(inputInputStreamReader);

sqlText =
"INSERT INTO test_clob (id, do*****ent_name, xml_do*****ent, timestamp) " +
" VALUES(1, '" + inputTextFile.getName() + "', EMPTY_CLOB(), SYSDATE)";
stmt.executeUpdate(sqlText);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 1 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new char[chunkSize];

position = 1;
while ((charsRead = inputBufferedReader.read(textBuffer)) != -1) {
charsWritten = xmlDo*****ent.putChars(position, textBuffer, charsRead);
position += charsRead;
totCharsRead += charsRead;
totCharsWritten += charsWritten;
}

inputBufferedReader.close();
inputInputStreamReader.close();
inputFileInputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" PUT METHOD\n" +
"==========================================================\n" +
"Wrote file " + inputTextFile.getName() + " to CLOB column.\n" +
totCharsRead + " characters read.\n" +
totCharsWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value - Put Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value - Put Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write the contents (data) from an Oracle CLOB column to
* an O/S file. This method uses one of two ways to get data from the CLOB
* column - namely the getChars() method. The other way to read data from an
* Oracle CLOB column is to use Streams.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void readCLOBToFileGet()
throws IOException, SQLException {

FileOutputStream outputFileOutputStream = null;
OutputStreamWriter outputOutputStreamWriter = null;
BufferedWriter outputBufferedWriter = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
long clobLength;
long position;
int chunkSize;
char[] textBuffer;
int charsRead = 0;
int charsWritten = 0;
int totCharsRead = 0;
int totCharsWritten = 0;

try {

stmt = conn.createStatement();

outputTextFile1 = new File(outputTextFileName1);
outputFileOutputStream = new FileOutputStream(outputTextFile1);
outputOutputStreamWriter = new OutputStreamWriter(outputFileOutputStream);
outputBufferedWriter = new BufferedWriter(outputOutputStreamWriter);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 1 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

clobLength = xmlDo*****ent.length();
chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new char[chunkSize];

for (position = 1; position <= clobLength; position += chunkSize) {

// Loop through while reading a chunk of data from the CLOB
// column using the getChars() method. This data will be stored
// in a temporary buffer that will be written to disk.
charsRead = xmlDo*****ent.getChars(position, chunkSize, textBuffer);

// Now write the buffer to disk.
outputBufferedWriter.write(textBuffer, 0, charsRead);

totCharsRead += charsRead;
totCharsWritten += charsRead;

}

outputBufferedWriter.close();
outputOutputStreamWriter.close();
outputFileOutputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" GET METHOD\n" +
"==========================================================\n" +
"Wrote CLOB column data to file " + outputTextFile1.getName() + ".\n" +
totCharsRead + " characters read.\n" +
totCharsWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value to file - Get Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value to file - Get Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write text data contained in a file to an Oracle CLOB
* column. The method used to write the data to the CLOB uses Streams.
* This is one of two types of methods used to write text data to
* a CLOB column. The other method uses the putChars() method.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void writeCLOBStream()
throws IOException, SQLException {

FileInputStream inputFileInputStream = null;
OutputStream clobOutputStream = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int bufferSize;
byte[] byteBuffer;
int bytesRead = 0;
int bytesWritten = 0;
int totBytesRead = 0;
int totBytesWritten = 0;

try {

stmt = conn.createStatement();

inputTextFile = new File(inputTextFileName);
inputFileInputStream = new FileInputStream(inputTextFile);

sqlText =
"INSERT INTO test_clob (id, do*****ent_name, xml_do*****ent, timestamp) " +
" VALUES(2, '" + inputTextFile.getName() + "', EMPTY_CLOB(), SYSDATE)";
stmt.executeUpdate(sqlText);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 2 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

bufferSize = xmlDo*****ent.getBufferSize();

// Notice that we are using an array of bytes as opposed to an array
// of characters. This is required since we will be streaming the
// content (to either a CLOB or BLOB) as a stream of bytes using
// using an OutputStream Object. This requires that a byte array to
// be used to temporarily store the contents that will be sent to
// the LOB. Note that they use of the byte array can be used even
// when reading contents from an ASCII text file that will be sent
// to a CLOB.
byteBuffer = new byte[bufferSize];

clobOutputStream = xmlDo*****ent.getAsciiOutputStream();

while ((bytesRead = inputFileInputStream.read(byteBuffer)) != -1) {

// After reading a buffer from the text file, write the contents
// of the buffer to the output stream using the write()
// method.
clobOutputStream.write(byteBuffer, 0, bytesRead);

totBytesRead += bytesRead;
totBytesWritten += bytesRead;

}

// Keep in mind that we still have the stream open. Once the stream
// gets open, you cannot perform any other database operations
// until that stream has been closed. This even includes a COMMIT
// statement. It is possible to loose data from the stream if this
// rule is not followed. If you were to attempt to put the COMMIT in
// place before closing the stream, Oracle will raise an
// "ORA-22990: LOB locators cannot span transactions" error.

inputFileInputStream.close();
clobOutputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" OUTPUT STREAMS METHOD\n" +
"==========================================================\n" +
"Wrote file " + inputTextFile.getName() + " to CLOB column.\n" +
totBytesRead + " bytes read.\n" +
totBytesWritten + " bytes written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value - Stream Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value - Stream Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write the contents (data) from an Oracle CLOB column to
* an O/S file. This method uses one of two ways to get data from the CLOB
* column - namely using Streams. The other way to read data from an
* Oracle CLOB column is to use getChars() method.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void readCLOBToFileStream()
throws IOException, SQLException {

FileOutputStream outputFileOutputStream = null;
InputStream clobInputStream = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int chunkSize;
byte[] textBuffer;
int bytesRead = 0;
int bytesWritten = 0;
int totBytesRead = 0;
int totBytesWritten = 0;

try {

stmt = conn.createStatement();

outputTextFile2 = new File(outputTextFileName2);
outputFileOutputStream = new FileOutputStream(outputTextFile2);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 2 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

// Will use a Java InputStream object to read data from a CLOB (can
// also be used for a BLOB) object. In this example, we will use an
// InputStream to read ASCII characters from a CLOB.
clobInputStream = xmlDo*****ent.getAsciiStream();

chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new byte[chunkSize];

while ((bytesRead = clobInputStream.read(textBuffer)) != -1) {

// Loop through while reading a chunk of data from the CLOB
// column using an InputStream. This data will be stored
// in a temporary buffer that will be written to disk.
outputFileOutputStream.write(textBuffer, 0, bytesRead);

totBytesRead += bytesRead;
totBytesWritten += bytesRead;

}

outputFileOutputStream.close();
clobInputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" INPUT STREAMS METHOD\n" +
"==========================================================\n" +
"Wrote CLOB column data to file " + outputTextFile2.getName() + ".\n" +
totBytesRead + " characters read.\n" +
totBytesWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value to file - Streams Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value to file - Streams Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Sole entry point to the class and application.
* @param args Array of string arguments passed in from the command-line.
*/
public static void main(String[] args) {

CLOBFileExample cLOBFileExample = null;

if (checkArguments(args)) {

try {

cLOBFileExample = new CLOBFileExample(args);

System.out.println("\n" + cLOBFileExample + "\n");

cLOBFileExample.openOracleConnection();

cLOBFileExample.writeCLOBPut();
cLOBFileExample.readCLOBToFileGet();

cLOBFileExample.writeCLOBStream();
cLOBFileExample.readCLOBToFileStream();

cLOBFileExample.closeOracleConnection();

} catch (IllegalAccessException e) {
System.out.println("Caught Illegal Accecss Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (InstantiationException e) {
System.out.println("Instantiation Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (ClassNotFoundException e) {
System.out.println("Class Not Found Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (SQLException e) {
System.out.println("Caught SQL Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (IOException e) {
System.out.println("Caught I/O Exception. Exiting.");
e.printStackTrace();
System.exit(1);
}

} else {
System.out.println("\nERROR: Invalid arguments.");
usage();
System.exit(1);
}

System.exit(0);
}

저작자표시

'Language > JAVA' 카테고리의 다른 글

System.out.println()은 잊어라 log4sql이 온다. (0)	2011.03.15
Log for SQL (PL/SQL 개발환경에서 로그 정보 확인하기) (0)	2011.03.15
FILE을 CLOB에 INSERT하고, 반대로 컬럼을 읽어 FILE로 WRITE하는 JDBC PROGRAM 예제 (JDBC 8.1 이상 (0)	2011.01.07
Heap Dump 분석을 통한 Perm Area Memory Leak 원인 진단 (0)	2010.12.14
Java ARchives (JAR) (0)	2010.11.17

Simple compression with GZIP

The GZIP interface is simple and thus is probably more appropriate when you have a single stream of data that you want to compress (rather than a container of dissimilar pieces of data). Here’s an example that compresses a single file:

//: c12:GZIPcompress.java
// {Args: GZIPcompress.java}
// {Clean: test.gz}
import com.bruceeckel.simpletest.*;
import java.io.*;
import java.util.zip.*;

public class GZIPcompress {
  private static Test monitor = new Test();
  // Throw exceptions to console:
  public static void main(String[] args)
  throws IOException {
    if(args.length == 0) {
      System.out.println(
        "Usage: \nGZIPcompress file\n" +
        "\tUses GZIP compression to compress " +
        "the file to test.gz");
      System.exit(1);
    }
    BufferedReader in = new BufferedReader(
      new FileReader(args[0]));
    BufferedOutputStream out = new BufferedOutputStream(
      new GZIPOutputStream(
        new FileOutputStream("test.gz")));
    System.out.println("Writing file");
    int c;
    while((c = in.read()) != -1)
      out.write(c);
    in.close();
    out.close();
    System.out.println("Reading file");
    BufferedReader in2 = new BufferedReader(
      new InputStreamReader(new GZIPInputStream(
        new FileInputStream("test.gz"))));
    String s;
    while((s = in2.readLine()) != null)
      System.out.println(s);
    monitor.expect(new String[] {
      "Writing file",
      "Reading file"
    }, args[0]);
  }
} ///:~

The use of the compression classes is straightforward; you simply wrap your output stream in a GZIPOutputStream or ZipOutputStream, and your input stream in a GZIPInputStream or ZipInputStream. All else is ordinary I/O reading and writing. This is an example of mixing the char-oriented streams with the byte-oriented streams; in uses the Reader classes, whereas GZIPOutputStream’s constructor can accept only an OutputStream object, not a Writer object. When the file is opened, the GZIPInputStream is converted to a Reader.

출처 : http://www.linuxtopia.org/

저작자표시

'Language > JAVA' 카테고리의 다른 글

Java ARchives (JAR) (0)	2010.11.17
Multifile storage with Zip (ZIP으로 여러 파일 저장하기) (0)	2010.11.17
자바 파일 압축 (0)	2010.11.17
JAVA File Locking(자바 파일 잠금) (0)	2010.11.17
자바 메모리를 사용한 큰 파일 조작하기 (0)	2010.11.17

No. 10707

DBMS_JOB PACKAGE의 사용 방법과 예제
===================================

Purpose
-------
DBMS_JOB package의 사용방법에 대해 알아보자.

Explanation
-----------

Unix의 cron과 같이 오라클에서도 일정한 시점, 또는 간격으로 반복해서
job을 수행시킬 수 있다. DBMS_JOB package를 이용하여 수행시킬 수 있는
데, 이것을 위해서는 SNP background process가 start되어 있어야 한다.

다음의 parameter를 init<SID>.ora file에 설정한 후 oracle을 startup하면
SNP0 혹은 J000 process가 뜨게된다.

    job_queue_processes = 1
      -> 이 파라미터는 snp process를 몇 개 띄울지를 결정한다.
         default=0

job_queue_interval = 60
-> 이 파라미터는 snp process가 깨어나는 간격을 초로 설정한다.

(Oracle9i부터는 job_queue_interval parameter가 없어졌으므로
job_queue_processes 만 설정하면 된다.)

DBMS_JOB Package는 다음과 같은 procedure를 이용하여 사용한다.

DBMS_JOB.submit(job           out   binary_integer,
                what          in    varchar2,
   next_date     in    date defalut sysdate,
interval      in    varchar2 default 'null',
  no_parse      in    boolean default false)

-> dbms_job.submit procedure는 job의 내용을 정의하고 oracle이 job을
수행할 수 있도록 한다.

Example
-------

[ 예제 ] file jobcre.sql

begin
dbms_job.submit(:jobno,
-- job 의 번호
'insert into scott.testdate values(1, sysdate);',
-- job의 내용 : ' '으로 감싸준다.
-- procedure를 실행하는 경우 ' username.procedure_name;' 만 쓰면 된다.
    sysdate,
-- job이 실행될 시간
'sysdate + 5/24/60' ,
-- job이 실행되는 간격 , 위의 경우는 5분마다 실행하도록 했다.
-- ' '으로 감싸준다.
   FALSE );
end;
/

$ sqlplus scott/tiger

SQL> variable jobno number;
SQL> @jobcre
SQL> print jobno -- job 번호 확인 : 여기서는 166번
SQL> exec dbms_job.run(166);
SQL> commit;

지금부터 interval에 따라 job이 실행된다.
job 실행 여부를 알아보기 위해서 다음의 sql 문장을 수행한다.

SQL> col what format a20
SQL> select what, job, next_date, next_sec, failures, broken
from user_jobs;

      그 외에

SQL> exec dbms_job.run(jobno);
      - job의 강제 실행, job이 16번 fail되어 broken된 경우는
        위의 명령어로 강제로 run을 시켜서 실행되면 다시 interval마다
        실행된다.

SQL> exec dbms_job.broken(jobno, TRUE);
- job을 disable시킴

SQL> exec dbms_job.remove(jobno);
- job의 삭제

참고1. snapshot과 job과의 관계

snapshot 도 job 으로 등록되어 실행된다.
즉, select job, what from dba_jobs; 를 조회하면,
what 부분에 snapshot 이 정의되어 있다.
따라서, snapshot 에 대한 disable 방법 등은 job 과 같은 방법으로
실행하면 된다.

참고2. interval 시간 지정 예제

1. 10분에 한번씩 실행하는 경우

   sysdate + 1/24/6       또는 sysdate + 1/144
     -> 1/24 (1시간-60분) / 6 : 10분 단위
        1/144   : 24*6 으로 나누어도 같은 의미가 된다.

2. 1분에 한번으로 지정하는 경우

sysdate + 1/24/60 또는 sysdate + 1/1440

3. 매일 새벽 2시로 지정하는 경우

trunc(sysdate) + 1 + 2/24 -> 다음날 새벽 2시를 지정함.

4. 매일 밤 11시로 지정하는 경우

trunc(sysdate) + 23/24 -> 오늘 밤 11시를 지정했음.

Reference Documents
-------------------
Oracle Developer's Guide and Oracle PL/SQL Guide

otn.oracle.co.kr

'Database > ORACLE' 카테고리의 다른 글

집합 함수 (0)	2009.03.08
ORACLE 10G PL/SQL USER GUIDE AND REFERENCE (0)	2009.03.08
INVALID OBJECT 컴파일 하는 방법 (0)	2009.03.08
오라클 백업 방식과 백업 방법 (0)	2009.03.08
TAB 뷰 에 정보 생성하기 (0)	2009.03.08

웹 개발과 관련된 모든 것들

예제

POSTMAN Spring 에 Post 데이터 전송 예

'UTILITY' 카테고리의 다른 글

자바스크립트 RGB 색상 함수 적용 예제

'Language > JAVASCRIPT' 카테고리의 다른 글

CLOB 파일 다루기 예제

'Language > JAVA' 카테고리의 다른 글

자바 간단한 GZIP 압축 예제

Simple compression with GZIP

'Language > JAVA' 카테고리의 다른 글

DBMS_JOB PACKAGE의 사용 방법과 예제

'Database > ORACLE' 카테고리의 다른 글

+ Recent posts

티스토리툴바