파란크리스마스

출처 : Passing Arrays between Java and Oracle Procedures how to call procedure with out parameter as table type from a java class Oracle procedure 'out' 'table of varchar2' type parameter Oracle stored procedure using array as parameter for table insert Jdbc array binding: character set encoding Oracle Database 11g Release 2 JDBC Drivers 주의사항 1. Spring을 사용하는 경우 OracleConnection을 가지고 오기 위해서 2. 인코딩 ..

Oracle Connection Pool Context 경로 추가 URIEncoding

MySQL JDBC 연결import java.sql.Connection; import java.sql.DriverManager; public class Test { public static void main(String[] args) throws Exception { Connection conn = null; try { Class.forName("org.gjt.mm.mysql.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:5515/dbname?user=id&useUnicode=true&characterEncoding=UTF8", "id", "pw"); } catch (Exception e) { e.printStackTrace()..

출처 Oracle XE 웹 포트 8080 변경하기.. : 나의 지식 창고 테이블 스페이스 생성 CREATE TABLESPACE user1_data DATAFILE 'C:\app\bluesanta\product\18.0.0\oradata\XE\USER1_DATA.DBF' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE 1024M; 오라클 계정 추가, 수정, 삭제 계정 추가 create user user1 identified by pwd default tablespace user1_data temporary tablespace temp; 권한 부여 grant connect, resource to user1; grant dba to user1; 계정 삭제 drop user user1 ..

CREATE TABLE ERD_EMP ( EMP_ID NUMBER NOT NULL, EMP_NAME VARCHAR2(256) NULL, EMP_ADDRESS VARCHAR2(256) NULL, EMP_TEL VARCHAR2(256) NULL, DEPT_ID NUMBER NULL, CONSTRAINT PK_ERD_EMP PRIMARY KEY(EMP_ID) ); CREATE TABLE ERD_DEPT ( DEPT_ID NUMBER NOT NULL, DEPT_NAME VARCHAR2(256) NULL, CONSTRAINT PK_ERD_DEPT PRIMARY KEY(DEPT_ID) ); ALTER TABLE ERD_EMP ADD ( CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPT_ID )..

- 오류 메시지 ORA-01031: insufficient privileges ORA-06512: at "SYS.PBSDE", line 78 ORA-06512: at "SYS.DBMS_DEBUG", line 224 ORA-06512: at line 2 debug connect session debug any procedure - 권한 부여 GRANT DEBUG CONNECT SESSION TO "SCOTT"; GRANT DEBUG ANY PROCEDURE TO "SCOTT";

- 출처 http://hyunayarn.tistory.com/9 - 오류 내용 - Lock 유저 확인 질의문 SELECT USERNAME, ACCOUNT_STATUS, TO_CHAR(LOCK_DATE,'YYYY.MM.DD HH24:MI') LOCK_DATE FROM DBA_USERS WHERE USERNAME = 'SCOTT' - 질의결과 USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- ---------------- SCOTT EXPIRED & LOCKED 2010.03.22 23:45 1 row selected. - Lock 해제 ALTER USER scott ACCOUNT U..