JDBC (2) 썸네일형 리스트형 [Java] Oracle JDBC releases Vs JDK versions 참고: https://www.oracle.com/database/technologies/faq-jdbc.html Oracle JDBC Frequently Asked Questions For byte data, there are three Oracle SQL types: VARCHAR2, LONG and CLOB. VARCHAR2 data is of limited length, is stored directly in a column, and is transmitted to the server in inline packets. LONG data has a much larger limit (2 Gigibytes), is stored via www.oracle.com [Java] JDBC Test (ORACLE DB, tnsnames.ora) // Instant Client 설치 및 TNS_ADMIN 환경변수 세팅 후 tnsnames.ora의 TNS_IDENTIFIER 참고하여 Oracle DB에 접근하는 예제 import java.sql.*; public class JDBCTest { public static void main(String[] args) throws Exception { System.setProperty("oracle.net.tns_admin", System.getenv("TNS_ADMIN")); String dbURL = "jdbc:oracle:thin:@MYDB"; Class.forName ("oracle.jdbc.OracleDriver"); Connection conn = null; Statement stmt = nul.. 이전 1 다음
