파란크리스마스

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()..

1. 다운로드(mysql-5.5.12-win32.zip) http://dev.mysql.com/downloads/mysql/5.5.html 2. 압축풀기 압축폴더 : C:\mysql\mysql-5.5.12-win32 3. mysql.ini 파일 작성 경로 : C:\mysql\mysql-5.5.12-win32\mysql.ini ---------------------------------------------------- [mysqld] port=2233 basedir=C:\mysql\mysql-5.5.12-win32 datadir=C:\mysql\mysql-5.5.12-win32\data character-set-server=utf8 collation-server=utf8_general_ci [mysql]..

출처 : http://www.lug.or.kr/docs/LINUX/KLDP/KoreanDoc/html/JServ_PgSQL-KLDP-html/JServ_PgSQL-KLDP-5.html 1. JDBC 드라이버 받기 http://jdbc.postgresql.org/download.html 2. JDBC Connection 접속 소스 /** * JDBC Connection String Examples * * jdbc:postgresql:database_name * jdbc:postgresql://host/database_name * jdbc:postgresql://host:port/database_name */ import java.sql.*; public class PgsqlJdbcTest { public ..