* °³¿ä
Äõ¸® µðÀÚÀÌ³Ê ¿É¼ÇÀÇ ·ÎÄà ¼¹ö ŸÀÔÀÌ ÀÚ¹Ù°¡ ¾Æ´Ñ ´å³ÝÀÏ ¶§ÀÇ µ¥ÀÌÅͺ£À̽º ¿¬°á ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
¾Æ·¡ÀÇ ¼³¸íÀº Oracle ¿¹¸¦ µé¾î ¼³¸íÇÕ´Ï´Ù.
* »ó¼¼ ¼³¸í
1. Provider¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
MSSQL ¿¡ ¿¬°áÇÒ ¶§´Â MS»ç¿¡¼ ±âº»ÀûÀ¸·Î Á¦°øµÇ´Â ¾î¼Àºí¸®¸¦ »ç¿ëÇؼ º°µµ ¼³Ä¡°¡ ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù. ±×·¯³ª, ƯÁ¤ ¾î¼Àºí¸®ÀÇ »ç¿ëÀ» ¿øÇÒ °æ¿ì º°µµ Provider¸¦ ¼³Ä¡ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
ÀÌ¿ÜÀÇ µ¥ÀÌÅͺ£À̽º´Â ¿¬°áÇÒ µ¥ÀÌÅͺ£À̽º ´å³Ý¿ë µå¶óÀ̹ö¸¦ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.
OracleÀÇ °æ¿ì ´ÙÀ½°ú °°ÀÌ ¼³Ä¡ÇÕ´Ï´Ù.
[Type1 - Microsoft Oracle ADO.NET Provider ¼³Ä¡]
´å³ÝÇÁ·¹ÀÓ¿öÅ©°¡ ¼³Ä¡µÇ¸é Providerµµ °°ÀÌ ¼³Ä¡µË´Ï´Ù.
´Ü, ¾Æ·¡ 4¹øÀÇ ¼ºñ½ºÀ̸§À» È®ÀÎÇÏ·Á¸é oracle cilentÀÎ Net Manager¸¦ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.
[Type2 - Oracle Data Provider for .NET(ODP) ¼³Ä¡]
http://www.oracle.com > Downloads > Database 11g > .NET Data Access Components ¿¡¼ "Oracle Data Provider for .NET"À» Æ÷ÇÔÇÑ ¼³Ä¡ ÆÄÀÏÀ» ´Ù¿î·Îµå ¹Þ¾Æ ½ÇÇàÇÕ´Ï´Ù.
(ex. ODAC92070.exe)
2. ProviderÀÇ ¼Ó¼ºÀ» È®ÀÎÇÕ´Ï´Ù.
[Type1 - Microsoft Oracle ADO.NET Provider ¼³Á¤]
C:\WINDOWS\assembly\System.Data.OracleClient ¿¡¼ ¸¶¿ì½º ¿À¸¥ÂÊ ¹öÆ°À¸·Î ¼Ó¼ºÀ» È®ÀÎÇÕ´Ï´Ù.
[Type2 - Oracle Data Provider for .NET(ODP) ¼³Á¤]
C:\WINDOWS\assembly\Oracle.DataAccess (À§ÀÇ 1¹ø ¼³Ä¡ ½Ã »ý¼ºµË´Ï´Ù.)¿¡¼ ¸¶¿ì½º ¿À¸¥ÂÊ ¹öÆ°À¸·Î ¼Ó¼ºÀ» È®ÀÎÇÕ´Ï´Ù.
3. À§ÀÇ 2¹ø ¼Ó¼ºÀ» ¹ÙÅÁÀ¸·Î OZ Query Designer 4.0/config/assembly.properties¸¦ ¼öÁ¤ÇÕ´Ï´Ù.
assembly.propertiesÆÄÀÏÀº DB¿¡¼ »ç¿ëÇÒ ¾î¼Àºí¸® Á¤º¸¸¦ ¼³Á¤ÇÏ´Â ÆÄÀÏÀÔ´Ï´Ù.
MSSQL ¿¡ ¿¬°áÇÒ ¶§´Â MS»ç¿¡¼ ±âº»ÀûÀ¸·Î Á¦°øµÇ´Â ¾î¼Àºí¸®¸¦ »ç¿ëÇؼ º°µµ ¼³Á¤ÀÌ ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù.
±×·¯³ª, ƯÁ¤ ¾î¼Àºí¸®ÀÇ »ç¿ëÀ» ¿øÇÒ °æ¿ì assembly.properties¿¡¼ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
[Type1 - assembly.properties]
handler.filepath=%OZ_HOME%/../Assembly/OZDatabaseHandler.dll
OracleAssemblyAlias1.name=System.Data.OracleClient
OracleAssemblyAlias1.version=1.0.5000.0
OracleAssemblyAlias1.culture=Neutral
OracleAssemblyAlias1.publickey=b77a5c561934e089 |
[Type2 - assembly.properties]
handler.filepath=%OZ_HOME%/../Assembly/OZDatabaseHandler.dll
OracleAssemblyAlias2.name=Oracle.DataAccess
OracleAssemblyAlias2.version=9.2.0.700
OracleAssemblyAlias2.culture=Neutral
OracleAssemblyAlias2.publickey=89b483f429c47342 |
ÆĶõ»ö ±ÛÀÚ OracleAssemblyAlias ºÎºÐ¿£ ÀÓÀÇÀÇ À̸§À» »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.
¾Æ·¡ db.propertiesÀÇ assembly¸í¿¡ ÁöÁ¤ÇÒ À̸§ÀÔ´Ï´Ù.
4. db.properties¸¦ ÀÛ¼ºÇÕ´Ï´Ù.
ÀÏ´Ü ¸ÕÀú È®ÀÎÇغÁ¾ß ÇÒ ºÎºÐÀº tnsname.ora¿Í oracle cilentÀÎ Net ManagerÀÇ ·ÎÄÃ-¼ºñ½ºÀ̸§À» È®ÀÎÇغÁ¾ß ÇÕ´Ï´Ù.
¿¹) # TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TestORA) // TestORA´Â LOCALÀÇ SERVICE NAMEÀÔ´Ï´Ù.
)
) |
±×¸®°í OZ Query Designer 4.0\db.properties ¼³Á¤Àº ´ÙÀ½°ú °°ÀÌ ÇÕ´Ï´Ù.
[Type1 - db.properties]
#
# sample configuraion for Oracle
#
OracleAlias.vendor=oracle OracleAlias.serverAddress=100.100.100.100 OracleAlias.portNo=1521 OracleAlias.sid=LOCAL // TestORA°¡ ¾Æ´Ï°í ¹Ýµå½Ã NET MANAGER¿¡ ÀÖ´Â ¼ºñ½º À̸§ÀÔ´Ï´Ù. OracleAlias.user=scott OracleAlias.password=tiger OracleAlias.maxconns=20 OracleAlias.initconns=5 OracleAlias.timeout=5 OracleAlias.doConnectionCheck=true OracleAlias.testQueryString=select 1 from dual OracleAlias.assembly=OracleAssemblyAlias1 // assembly.propertiesÀÇ ¾î¼Àºí¸® Á¤º¸ ÁöÁ¤
|
[Type2 - db.properties]
#
# sample configuraion for Oracle
#
OracleAlias.vendor=oracle OracleAlias.serverAddress=100.100.100.100 OracleAlias.portNo=1521 OracleAlias.sid=LOCAL // TestORA°¡ ¾Æ´Ï°í ¹Ýµå½Ã NET MANAGER¿¡ ÀÖ´Â ¼ºñ½º À̸§ÀÔ´Ï´Ù. OracleAlias.user=scott OracleAlias.password=tiger OracleAlias.maxconns=20 OracleAlias.initconns=5 OracleAlias.timeout=5 OracleAlias.doConnectionCheck=true OracleAlias.testQueryString=select 1 from dual OracleAlias.assembly=OracleAssemblyAlias2 // assembly.propertiesÀÇ ¾î¼Àºí¸® Á¤º¸ ÁöÁ¤
|
5. OZ Query Designer4.0\dbconfig.xml ¼³Á¤À» È®ÀÎÇÕ´Ï´Ù.
dbconfig.xml ÆÄÀÏÀº DB Vendorº° DRIVER, URL µîÀ» ¼³Á¤ÇÏ´Â ÆÄÀÏÀÔ´Ï´Ù. À§ÀÇ TYPE¿¡ µû¶ó ´å³Ý µå¶óÀ̹ö¸íÀÌ ¾Æ·¡¿Í °°ÀÌ ¼³Á¤µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
[Type1] (±âº»°ª)
<VENDOR NAME="oracle">
...
<DRIVER>
...
<NET>System.Data.OracleClient.OracleConnection</NET>
</DRIVER> |
[Type2]
<VENDOR NAME="oracle">
...
<DRIVER>
...
<NET>Oracle.DataAccess.Client.OracleConnection</NET>
</DRIVER> |
6. Äõ¸®µðÀÚÀ̳ʿ¡¼ ¾Ù¸®¾î½º Á¤º¸¸¦ ³Ö°í DB¿¡ ¿¬°áÇÕ´Ï´Ù.
* Âü°í »çÇ×
1. ¸®Æ÷Æ® µðÀÚÀ̳ÊÀÇ ¼¹öŸÀÔÀÌ .NETÀÎ °æ¿ì Äõ¸®µðÀÚÀÌ³Ê¿Í µ¿ÀÏÇÑ ¹æ¹ýÀ¸·Î ¼³Á¤ÇÕ´Ï´Ù.
2. º¸°í¼ ¹èÆ÷ ÈÄ ´å³Ý ¼¹ö¸¦ »ç¿ëÇÒ °æ¿ì¿¡µµ Äõ¸®µðÀÚÀÌ³Ê¿Í µ¿ÀÏÇÑ ¹æ¹ýÀ¸·Î ¼¹ö ¼³Á¤À» ÇÕ´Ï´Ù.
|