* °³¿ä
¿ÀÁî ¼¹ö¿¡¼ DB¿¡ ¿¬°áÇÏ·Á¸é ´ÙÀ½ ÀÛ¾÷À» ÇØ¾ß ÇÕ´Ï´Ù.
1. DB ¿¬°áÁ¤º¸ ¼³Á¤
2. JDBC µå¶óÀ̹ö ÆÄÀÏ ¾÷·Îµå
3. Java ¹öÀü È®ÀÎ
* »ó¼¼ ¼³¸í
¿ÀÁî ¼¹ö¿¡¼ DB¿¬°áÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.
¿ÀÁî ¼¹ö°¡ WAS (Tomcat, Jeus, WebLogic µî) ¿¡ ¼³Ä¡µÈ °æ¿ìÀÔ´Ï´Ù.
1. DB ¿¬°áÁ¤º¸ ¼³Á¤
´ÙÀ½ °æ·Î¿¡ db.properties ÆÄÀÏÀ» »ý¼ºÇÕ´Ï´Ù.
¿¹)
Windows : C:\Tomcat8.5\webapps\oz80\WEB-INF\conf\db.properties
Linux : /usr/tomcat/oz80/WEB-INF/conf/db.properties
(db.properties ¿¹½Ã)
# oracle example
TestOracle.vendor=oracle TestOracle.serverAddress=123.11.22.33 TestOracle.portNo=1521 TestOracle.sid=ORCL TestOracle.user=scott TestOracle.password=tiger TestOracle.maxconns=20 TestOracle.initconns=5 TestOracle.timeout=5 TestOracle.doConnectionCheck=true TestOracle.testQueryString=select sysdate from dual
# mssql example TestMssql.vendor=mssql2008 TestMssql.serverAddress=123.11.22.33 TestMssql.portNo=1433 TestMssql.dbName=northwind TestMssql.user=sa TestMssql.password=sapw TestMssql.maxconns=20 TestMssql.initconns=5 TestMssql.timeout=5 TestMssql.doConnectionCheck=true TestMssql.testQueryString=select 1
# tibero example
TestTibero.vendor=user TestTibero.driver=com.tmax.tibero.jdbc.TbDriver TestTibero.url=jdbc:tibero:thin:@123.11.22.33:Æ÷Æ®:tibero TestTibero.props=user=À¯Àú;password=¾ÏÈ£ TestTibero.user=À¯Àú TestTibero.maxconns=20 TestTibero.initconns=5 TestTibero.timeout=5 TestTibero.doConnectionCheck=true TestTibero.testQueryString=select 1 |
* oz80/WEB-INF/conf/sample/ Æú´õ¿¡ db.properties ¿¹Á¦ ÆÄÀÏÀÌ ÀÖ½À´Ï´Ù.
* vendor´Â dbconfig.xmlÀÇ <VENDOR NAME=".."> ¿¡ ¼³Á¤µÈ °ªÀ» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
¸í½ÃµÇÁö ¾ÊÀº °æ¿ì vendor=user·Î ÇÏ°í driver, urlÀ» Á÷Á¢ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
* WASÀÇ datasource¸¦ ÀÌ¿ëÇÏ¿© ¿¬°áÇÏ·Á¸é ´ÙÀ½ ±â¼ú¹®¼¸¦ Âü°íÇϽñ⠹ٶø´Ï´Ù.
http://oztn.net/kb/article/kbserver/119131426198800
2. JDBC µå¶óÀ̹ö ÆÄÀÏ ¾÷·Îµå
JDBC µå¶óÀ̹ö´Â oz80/WEB-INF/UniversalDriver Æú´õ¿¡ ÀϺΠÁ¦°øµË´Ï´Ù.
db¿¬°áÀÌ ¾ÈµÇ¸é DB¹öÀü¿¡ ¸Â´Â JDBC µå¶óÀ̹ö¸¦ »ç¿ëÇÏ¼Å¾ß ÇÕ´Ï´Ù.
JDBC µå¶óÀ̹ö´Â DBMS º¥´õ»ç¿¡¼ Á¦°øÇÕ´Ï´Ù.
DB |
JDBC µå¶óÀ̹ö |
Oracle 8 |
classes12.zip (±âº»Á¦°ø) |
Oracle 11.2 |
ojdbc5.jar ¶Ç´Â ojdbc6.jar |
Oracle 12.1 |
ojdbc6.jar ¶Ç´Â ojdbc7.jar |
Oracle 12.2 |
ojdbc8.jar |
Oracle 19.7 |
ojdbc8.jar |
Mssql 2000 |
msbase.jar, mssqlserver.jar, msutil.jar (±âº»Á¦°ø) |
Mssql 2008 |
sqljdbc.jar (±âº»Á¦°ø) |
WEB-INF/lib/ Æú´õ¿¡ jdbc µå¶óÀ̹ö ÆÄÀÏÀ» ¾÷·ÎµåÇÕ´Ï´Ù.
WEB-INF/lib/ ÀÇ .jar È®ÀåÀÚ´Â WAS ±¸µ¿½Ã ÀÚµ¿À¸·Î ·ÎµùµÇ¾î º°µµ·Î Ŭ·¡½ºÆнº¸¦ Àâ¾ÆÁÖÁö ¾Ê¾Æµµ µË´Ï´Ù.
¿¹)
- oracle 19 : oz80/WEB-INF/lib/ojdbc8.jar
- mssql2000 : oz80/WEB-INF/lib/msbase.jar, mssqlserver.jar, msutil.jar
- mssql2008 : oz80/WEB-INF/lib/sqljdbc.jar
-> ´Ü, °°Àº DBº¥´õÀÇ ´Ù¸¥ ¹öÀü µå¶óÀ̹ö´Â »èÁ¦ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
¿¹¸¦ µé¾î, oracle19c¿¡ ¿¬°áÇϱâ À§ÇØ lib¿¡ ojdbc8.jar¸¦ ³Ö´Â °æ¿ì classes12.zipÀ̳ª ´Ù¸¥ ¹öÀü odjbc~.jar¸¦ »èÁ¦ÇØ¾ß ÇÕ´Ï´Ù.
mssql2008¿¡ ¿¬°áÇϱâ À§ÇØ lib¿¡ sqljdbc.jar¸¦ ³Ö´Â °æ¿ì ÇÏÀ§ ¹öÀüÀÇ msbase.jar, mssqlserver.jar, msutil.jar À» »èÁ¦ÇØ¾ß ÇÕ´Ï´Ù.
3. Java ¹öÀü È®ÀÎ
JDBC µå¶óÀ̹ö¿¡ ¸Â´Â java ¹öÀüÀ» ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
¿À¶óŬÀÇ °æ¿ì ojdbc µÚÀÇ ¼ýÀÚ´Â Áö¿øµÇ´Â java ¹öÀüÀÔ´Ï´Ù. ojdbc6.jar´Â java1.6, ojdbc8.jar´Â java1.8 À̻󿡼 µ¿À۵˴ϴÙ.
¿ÀÁî ¼¹ö´Â WAS(Tomcat, Jeus, WebLogic µî) À§¿¡¼ ½ÇÇàµÇ±â ¶§¹®¿¡
WAS¸¦ ±¸µ¿µÈ java°¡ JDBC µå¶óÀ̹ö°¡ Áö¿øµÇ´Â java ¹öÀü(¶Ç´Â ±× ÀÌ»ó)À̾î¾ß ÇÕ´Ï´Ù.
4. DB ¿¬°á
À§¿Í °°ÀÌ ÀÛ¾÷ÀÌ µÇ¸é ¿ÀÁî ¼¹ö¸¦ Àç½ÃÀÛ (WAS À籸µ¿) ÇÕ´Ï´Ù.
º¸°í¼¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌÅÍ°¡ Á¤»óÀûÀ¸·Î Á¶È¸µÇ´ÂÁö È®ÀÎÇÕ´Ï´Ù.
oz80/WEB-INF/logs/server.log ·Î±× ÆÄÀÏ¿¡ ¿ÀÁî ¼¹ö ±¸µ¿½Ã µ¥ÀÌÅͺ£À̽º Ä¿³Ø¼Ç Ç®ÀÌ »ý¼ºµÇ´Â °úÁ¤ÀÌ ±â·ÏµË´Ï´Ù.
(Á¤»óÀÎ °æ¿ì)
2022-05-19 10:47:37,815 [http-nio-80-exec-1] INFO ConnectionPool - Start initialize... 2022-05-19 10:47:37,820 [http-nio-80-exec-1] INFO ConnectionPool-TestMssql - Loading properties is done. 2022-05-19 10:47:37,831 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - loading driver: 'com.microsoft.sqlserver.jdbc.SQLServerDriver' 2022-05-19 10:47:37,832 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - newConnectionByURL.... url: jdbc:sqlserver://123.11.22.33:1433;DatabaseName=northwind 2022-05-19 10:47:37,835 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - com.microsoft.sqlserver.jdbc.SQLServerDriver is acceptsURL :true 2022-05-19 10:47:38,329 [http-nio-80-exec-1] INFO ConnectionPool-TestMssql - Opened a new connection by URL. 2022-05-19 10:47:38,331 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - Total connections: 1 Available: 1 Checked-out: 0 2022-05-19 10:47:38,332 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - newConnectionByURL.... url: jdbc:sqlserver://123.11.22.33:1433;DatabaseName=northwind 2022-05-19 10:47:38,334 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - com.microsoft.sqlserver.jdbc.SQLServerDriver is acceptsURL :true 2022-05-19 10:47:38,348 [http-nio-80-exec-1] INFO ConnectionPool-TestMssql - Opened a new connection by URL. 2022-05-19 10:47:38,349 [http-nio-80-exec-1] DEBUG ConnectionPool-TestMssql - Total connections: 2 Available: 2 Checked-out: 0 2022-05-19 10:47:59,709 [http-nio-80-exec-1] INFO ConnectionPool - End initialize. ... 2022-05-19 10:48:03,803 [http-nio-80-exec-1] DEBUG server - OS Name : Windows 10 2022-05-19 10:48:03,805 [http-nio-80-exec-1] DEBUG server - OS Version : 10.0 2022-05-19 10:48:03,806 [http-nio-80-exec-1] DEBUG server - Java Vendor : Oracle Corporation 2022-05-19 10:48:03,806 [http-nio-80-exec-1] DEBUG server - Java Version : 1.8.0_111 ... 2022-05-19 10:48:03,809 [http-nio-80-exec-1] INFO server - OZ Server : 8.0.0101.20220330 20:00.00 2022-05-19 10:48:03,815 [http-nio-80-exec-1] INFO server - License expiration date : 2022-06-15 ... 2022-05-19 10:48:03,817 [http-nio-80-exec-1] INFO server - OZ Servlet is ready up. |
(¿¡·¯³ °æ¿ì)
2022-05-19 10:47:37,815 [http-nio-80-exec-1] INFO ConnectionPool - Start initialize... 2022-04-18 17:06:27,262 [http-nio-80-exec-2] INFO ConnectionPool-TestOracle - Loading properties is done. 2022-04-18 17:06:27,299 [http-nio-80-exec-2] DEBUG ConnectionPool-TestOracle - loading driver: 'oracle.jdbc.driver.OracleDriver' 2022-04-18 17:06:27,300 [http-nio-80-exec-2] DEBUG ConnectionPool-TestOracle - newConnectionByURL.... url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS...=(SID=ORCL))) 2022-04-18 17:06:27,302 [http-nio-80-exec-2] DEBUG ConnectionPool-TestOracle - oracle.jdbc.driver.OracleDriver is acceptsURL :true 2022-04-18 17:06:48,464 [http-nio-80-exec-2] ERROR ConnectionPool-TestOracle - Fail to connect. error
2022-05-19 10:47:59,709 [http-nio-80-exec-1] INFO ConnectionPool - End initialize. ... 2022-05-19 10:48:03,803 [http-nio-80-exec-1] DEBUG server - OS Name : Windows 10 2022-05-19 10:48:03,805 [http-nio-80-exec-1] DEBUG server - OS Version : 10.0 2022-05-19 10:48:03,806 [http-nio-80-exec-1] DEBUG server - Java Vendor : Oracle Corporation 2022-05-19 10:48:03,806 [http-nio-80-exec-1] DEBUG server - Java Version : 1.8.0_111 ... 2022-05-19 10:48:03,809 [http-nio-80-exec-1] INFO server - OZ Server : 8.0.0101.20220330 20:00.00 2022-05-19 10:48:03,815 [http-nio-80-exec-1] INFO server - License expiration date : 2022-06-15 ... 2022-05-19 10:48:03,817 [http-nio-80-exec-1] INFO server - OZ Servlet is ready up. |
* Âü°í »çÇ×
¿À¶óŬ JDBC µå¶óÀ̹ö ´Ù¿î·Îµå :
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
* ÷ºÎÀÚ·á ¼³¸í
> '¿ÀÁî - DB ¿¬°á ¹æ¹ý.docx' : º»¹® ³»¿ëÀ» doc·Î ÀÛ¼ºÇÑ ¹®¼ÀÔ´Ï´Ù.
|