From 6e25ab8da8a90a6d9bf40ccc83e36f119fb27568 Mon Sep 17 00:00:00 2001 From: joonhoekim <26rote@gmail.com> Date: Tue, 1 Jul 2025 10:44:02 +0000 Subject: (김준회) 비활성화한 node-cron 진입점 (instrumentation.ts) 추가 및 NONSAP 동기화 개발건 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/oracle-db/db.ts | 39 ++------------------------------------- 1 file changed, 2 insertions(+), 37 deletions(-) (limited to 'lib/oracle-db/db.ts') diff --git a/lib/oracle-db/db.ts b/lib/oracle-db/db.ts index 62321df0..211fd04b 100644 --- a/lib/oracle-db/db.ts +++ b/lib/oracle-db/db.ts @@ -1,3 +1,5 @@ +"use server"; + import knex from 'knex'; // import oracledb from 'oracledb'; // eslint-disable-next-line @typescript-eslint/no-require-imports @@ -30,40 +32,3 @@ export async function getOracleConnection() { } } -// 연결을 테스트하는 함수 -export async function testOracleConnection() { - try { - const connection = await getOracleConnection(); - const result = await connection.execute('SELECT 1 FROM DUAL'); - await connection.close(); - return { - success: true, - message: 'Oracle DB 연결 성공', - data: result.rows - }; - } catch (error: unknown) { - return { - success: false, - message: 'Oracle DB 연결 실패', - error: error instanceof Error ? error.message : '알 수 없는 오류' - }; - } -} - -// Knex를 사용하여 Oracle 연결 테스트 -export async function testKnexOracleConnection() { - try { - const result = await oracleKnex.raw('SELECT 1 FROM DUAL'); - return { - success: true, - message: 'Knex Oracle DB 연결 성공', - data: result - }; - } catch (error: unknown) { - return { - success: false, - message: 'Knex Oracle DB 연결 실패', - error: error instanceof Error ? error.message : '알 수 없는 오류' - }; - } -} \ No newline at end of file -- cgit v1.2.3