* °³¿ä
¿ÀÁî µðÀÚÀ̳ʿ¡¼ DB¿¡ ¿¬°áÇÏ·Á¸é ´ÙÀ½À» ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
1. db ¿¬°áÁ¤º¸ ¼³Á¤
2. jdbc µå¶óÀ̹ö ¼³Á¤
3. jre ¼³Á¤
* »ó¼¼ ¼³¸í
¿ÀÁî Äõ¸®µðÀÚÀ̳Ê, ¸®Æ÷Æ®µðÀÚÀ̳ʿ¡¼ DB¿¬°áÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.
1. DB ¿¬°áÁ¤º¸ ¼³Á¤
´ÙÀ½ °æ·Î¿¡ db.properties ÆÄÀÏÀ» »ý¼ºÇÕ´Ï´Ù.
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Query Designer 8.0\db.properties
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Report Designer 8.0\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 |
* vendor´Â dbconfig.xmlÀÇ <VENDOR NAME=".."> ¿¡ ¼³Á¤µÈ °ªÀ» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
¸í½ÃµÇÁö ¾ÊÀº °æ¿ì vendor=user·Î ÇÏ°í driver, urlÀ» Á÷Á¢ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
2. JDBC µå¶óÀ̹ö ¼³Á¤
JDBC µå¶óÀ̹ö´Â µðÀÚÀ̳ÊÀÇ 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 (±âº»Á¦°ø) |
´ÙÀ½ °æ·Î¿¡ jdbc µå¶óÀ̹ö ÆÄÀÏÀ» º¹»çÇÕ´Ï´Ù.
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Query Designer 8.0\UniversalDriver\
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Report Designer 8.0\UniversalDriver\
launch.cfg ÆÄÀÏÀ» ¿°í CLASSPATH¸¦ º¯°æÇÕ´Ï´Ù.
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Query Designer 8.0\config\launch.cfg
C:\Program Files (x86)\Forcs\OZ Report 8.0\OZ Report Designer 8.0\config\launch.cfg
(oracle8)
CLASSPATH = .\lib\ozsfw80.jar;.\lib\log4j.jar;...»ý·«... ;.\UniversalDriver\classes12.zip
JRE_PATH = ..\jre\bin\client\jvm.dll |
(oracle19c)
CLASSPATH = .\lib\ozsfw80.jar;.\lib\log4j.jar;...»ý·«... ;.\UniversalDriver\ojdbc8.jar
JRE_PATH = "C:\Program Files (x86)\Java\jre1.8.0_121\bin\client\jvm.dll" |
(mssql2000)
CLASSPATH = .\lib\ozsfw80.jar;.\lib\log4j.jar;...»ý·«... ;.\UniversalDriver\msbase.jar;.\UniversalDriver\mssqlserver.jar;.\UniversalDriver\msutil.jar
JRE_PATH = ..\jre\bin\client\jvm.dll |
(mssql2008)
CLASSPATH = .\lib\ozsfw80.jar;.\lib\log4j.jar;...»ý·«... ;.\UniversalDriver\sqljdbc.jar
JRE_PATH = "C:\Program Files (x86)\Java\jre7\bin\client\\jvm.dll" |
-> CLASSPATH¿¡ °°Àº DBº¥´õÀÇ ´Ù¸¥ ¹öÀü µå¶óÀ̹ö °æ·Î´Â »èÁ¦ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
¿¹¸¦ µé¾î, oracle19c¿¡ ¿¬°áÇϱâ À§ÇØ ojdbc8.jar¸¦ ¼³Á¤ÇÑ °æ¿ì classes12.zipÀ̳ª ´Ù¸¥ ¹öÀü odjbc~.jar °æ·Î¸¦ »èÁ¦ÇØ¾ß ÇÕ´Ï´Ù.
mssql2008¿¡ ¿¬°áÇϱâ À§ÇØ sqljdbc.jar¸¦ ¼³Á¤ÇÑ °æ¿ì ÇÏÀ§ ¹öÀüÀÇ msbase.jar, mssqlserver.jar, msutil.jar °æ·ÎÀ» »èÁ¦ÇØ¾ß ÇÕ´Ï´Ù.
3. jre ¼³Á¤
µðÀÚÀ̳ʿ¡¼ »ç¿ëµÇ´Â java´Â 32bit¸¸ Áö¿øµË´Ï´Ù. (¿ÀÁî¼¹ö´Â 32bit, 64bit ¸ðµÎ Áö¿øµË´Ï´Ù)
jdbc µå¶óÀ̹ö¿¡ ¸Â´Â java ¹öÀüÀ» ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
¿À¶óŬÀÇ °æ¿ì ojdbc µÚÀÇ ¼ýÀÚ´Â Áö¿øµÇ´Â java ¹öÀüÀÔ´Ï´Ù. ojdbc6.jar´Â java1.6, ojdbc8.jar´Â java1.8 À̻󿡼 µ¿À۵˴ϴÙ.
¿ÀÁî µðÀÚÀ̳ʸ¦ ÀνºÅçÇÒ ¶§ ¼³Ä¡µÇ´Â java¹öÀüÀº 1.5ÀÔ´Ï´Ù. (µðÀÚÀÌ³Ê ¹öÀü¿¡ µû¶ó ´Þ¶óÁú ¼ö ÀÖ½À´Ï´Ù)
JDBC µå¶óÀ̹ö¿¡¼ Áö¿øÇÏ´Â Java°¡ »óÀ§ ¹öÀüÀÎ °æ¿ì º°µµ·Î 32bit¿ëÀ» ¼³Ä¡ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
launch.cfgÀÇ JRE_PATH¿¡ °æ·Î¸¦ ¼³Á¤ÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
°æ·Î¿¡ °ø¹éÀÌ µé¾î°£ °æ¿ì ½Öµû¿ÈÇ¥·Î °¨½ÎÁÖ¼Å¾ß ÇÕ´Ï´Ù.
¿¹)
JRE_PATH = ..\jre\bin\client\jvm.dll
JRE_PATH = "C:\Program Files (x86)\Java\jre7\bin\client\\jvm.dll"
JRE_PATH = "C:\Program Files (x86)\Java\jre1.8.0_121\bin\client\jvm.dll"
4. DB ¿¬°á
À§ÀÇ ¼³Á¤ÀÌ µÇ¸é Äõ¸® µðÀÚÀ̳ʸ¦ ½ÇÇàÇÑ ÈÄ µ¥ÀÌÅͺ£À̽º¿¡ '½ºÅä¾î Ãß°¡'¸¦ ÇÕ´Ï´Ù.
'¾Ù¸®¾î½º'¸¦ üũÇÏ°í db.properties ¿¡ ÀÔ·ÂµÈ . ¾ÕÀÇ ¾Ù¸®¾î½º ¸íÀ» ÀÔ·ÂÇÕ´Ï´Ù.
db.properties ¾Õ¿¡ °æ·Î¸¦ µû·Î ÀÔ·ÂÇÏÁö ¾ÊÀ¸¸é Äõ¸®µðÀÚÀ̳Ê, ¸®Æ÷Æ® µðÀÚÀÌ³Ê °¢°¢ Æú´õ ¾Æ·¡¿¡¼ ã°Ô µË´Ï´Ù.
5. µð¹ö±ë
DB ¿¬°á ¿¡·¯°¡ ¹ß»ýÇϸé Äõ¸® µðÀÚÀ̳ÊÀÇ 'ÆÄÀÏ > ·ÎÄà ¼¹ö ·Î±× º¸±â' ¸Þ´º¸¦ Ŭ¸¯ÇÑ ÈÄ ÀÚ¼¼ÇÑ ·Î±×¸¦ È®ÀÎÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
* Âü°í »çÇ×
¿À¶óŬ JDBC µå¶óÀ̹ö ´Ù¿î·Îµå : https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
* ÷ºÎÀÚ·á ¼³¸í
> '¿ÀÁî - DB ¿¬°á ¹æ¹ý.docx' : º»¹® ³»¿ëÀ» doc·Î ÀÛ¼ºÇÑ ¹®¼ÀÔ´Ï´Ù.
> '¿ÀÁî - oracle19c ¿¬°á ¹æ¹ý.docx' º»¹® ³»¿ë¿¡¼ oracle19c °ü·Ã ºÎºÐ¸¸ doc·Î ÀÛ¼ºÇÑ ¹®¼ÀÔ´Ï´Ù.
|