* °³¿ä
MSSQL2000°ú MSSQL2005 µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
* »ó¼¼ ¼³¸í
1. db.properties ¼³Á¤
MSSQL2000°ú MSSQL2005 DBMS¿¡ ¿¬°áÇϱâ À§ÇØ db.properties ÆÄÀÏÀ» ¾Æ·¡¿Í °°ÀÌ ¼³Á¤ÇÕ´Ï´Ù.
1-1. ¿ÀÁî 3.5 ¹öÀü ¼³Á¤ ¹æ¹ý
1-1-1. mssql 2000ÀÎ °æ¿ì
# # sample1 # mssql_example.vendor=mssql mssql_example.serverAddress=127.0.0.1 mssql_example.portNo=1433 mssql_example.dbName=***** mssql_example.user=*** mssql_example.password=*** mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 mssql_example.doConnectionCheck=true mssql_example.testQueryString=select 1
# # sample2 #
user_example1.vendor=user user_example1.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver user_example1.url=jdbc:microsoft:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName};SelectMethod=Cursor user_example1.props=user=****;password=**** user_example1.user=**** user_example1.password=**** user_example1.maxconns=20 user_example1.initconns=5 user_example1.timeout=5 user_example1.doConnectionCheck=true user_example1.testQueryString=select 1
1-1-2. mssql 2005 ÀÎ °æ¿ì
# # mssql2005 - sample1 # user_example2.vendor=user user_example2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver user_example2.url=jdbc:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName} user_example2.props=user=****;password=**** user_example2.user=**** user_example2.password=**** user_example2.maxconns=20 user_example2.initconns=5 user_example2.timeout=5 user_example2.doConnectionCheck=true user_example2.testQueryString=select 1
1-2. ¿ÀÁî 4.0 ÀÌ»ó ¹öÀü ¼³Á¤ ¹æ¹ý
1-2-1. mssql 2000ÀÎ °æ¿ì
# # sample1 # mssql_example.vendor=mssql mssql_example.serverAddress=127.0.0.1 mssql_example.portNo=1433 mssql_example.dbName=***** mssql_example.user=*** mssql_example.password=*** mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 mssql_example.doConnectionCheck=true mssql_example.testQueryString=select 1
# # sample2 #
user_example1.vendor=user user_example1.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver user_example1.url=jdbc:microsoft:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName};SelectMethod=Cursor user_example1.props=user=****;password=**** user_example1.user=**** user_example1.password=**** user_example1.maxconns=20 user_example1.initconns=5 user_example1.timeout=5 user_example1.doConnectionCheck=true user_example1.testQueryString=select 1
1-2-2. mssql 2005 ÀÎ °æ¿ì
# # mssql2005 - sample1 # mssql_example.vendor=mssql2005 mssql_example.serverAddress=127.0.0.1 mssql_example.portNo=1433 mssql_example.dbName=***** mssql_example.user=*** mssql_example.password=*** mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 mssql_example.doConnectionCheck=true mssql_example.testQueryString=select 1
# # mssql2005 - sample2 # user_example2.vendor=user user_example2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver user_example2.url=jdbc:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName} user_example2.props=user=****;password=**** user_example2.user=**** user_example2.password=**** user_example2.maxconns=20 user_example2.initconns=5 user_example2.timeout=5 user_example2.doConnectionCheck=true user_example2.testQueryString=select 1
2. JDBCµå¶óÀ̹ö, JDK ¼³Á¤
mssql ¹öÀü¿¡ ¸Â´Â JDBC µå¶óÀ̹ö¸¦ classpath¿¡ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
2000 µå¶óÀ̹ö : msbase.jar, mssqlserver.jar, msutil.jar 2005 µå¶óÀ̹ö : sqljdbc.jar |
JDK Áö¿ø ¹öÁ¯Àº ´ÙÀ½°ú °°½À´Ï´Ù.
2000 µå¶óÀ̹ö : JDK 1.2 ÀÌ»óÀÇ È¯°æ 2005 µå¶óÀ̹ö : JDK 1.4 ÀÌ»óÀÇ È¯°æ |
2-1. ¿ÀÁî µðÀÚÀÌ³Ê ¼³Á¤
QueryDesigner, ReportDesigner, ApplicationDesigner¿¡¼ mssql¿¡ ¿¬°áÇÒ ¶§´Â µðÀÚÀ̳ʰ¡ ¼³Ä¡µÈ µð·ºÅ丮 ÇÏÀ§ÀÇ
config\launch.cfg ÆÄÀÏ¿¡ ¾Æ·¡¿Í °°ÀÌ ¼³Á¤ÇÕ´Ï´Ù.
- OZ Query Designer\config\launch.cfg
- OZ Report Designer\config\launch.cfg
- OZ Application Designer\config\launch.cfg
(mssql2000)
CLASSPATH = .\lib\ozsfw.jar;.\UniversalDriver\msbase.jar;.\UniversalDriver\mssqlserver.jar;.\UniversalDriver\msutil.jar; ..»ý·«.. ;.\UniversalDriver\parser.jar JRE_PATH = ..\jre\bin\hotspot\jvm.dll |
(mssql2005)
CLASSPATH = .\lib\ozsfw.jar;.\UniversalDriver\sqljdbc.jar; ..»ý·«.. ;.\UniversalDriver\parser.jar JRE_PATH = C:\j2sdk1.4.2_14\jre\bin\client\jvm.dll |
2-2. ¿ÀÁî ¼¹ö ¼³Á¤
2-1-1. ¼ºí¸´ ŸÀÔ ¿ÀÁî ¼¹ö ¼³Á¤
"OZ Servlet\UniversalDriver\" Æú´õ¿¡ ÀÖ´Â jarÆÄÀÏÀ» "OZ Servlet\WEB-INF\lib\" Æú´õ¿¡ º¹»çÇÕ´Ï´Ù.
mssql2005¿¡ ¿¬°á½Ã ¿ÀÁî¼ºí¸´ÀÌ ±¸µ¿µÇ´Â WASÀÇ jdk¹öÀüÀÌ 1.4ÀÌ»óÀ̾î¾ß ÇÕ´Ï´Ù.
2-1-2. µ¥¸ó ŸÀÔ ¿ÀÁî ¼¹ö ¼³Á¤
"OZ Server\UniversalDriver\" Æú´õ¿¡ ÀÖ´Â jarÆÄÀÏ °æ·Î¸¦ ¾Æ·¡ ÆÄÀÏ¿¡ ¼³Á¤ÇÕ´Ï´Ù.
- unix ȯ°æ :
ozcntrl.sh ÆÄÀÏ¿¡ JAVA_HOME, OZLIB ¼³Á¤
- windows ȯ°æ :
ozcntrl.bat ÆÄÀÏ¿¡ JAVA_HOME, OZLIB¼³Á¤
OZServerInstallService.bat ÆÄÀÏ¿¡ JRE_PATH, OZLIB ¼³Á¤
windows¿¡ ¼ºñ½º·Î ¿ÀÁî ¼¹ö°¡ µî·ÏµÇ¾î ÀÖ´Â °æ¿ì, OZServerInstallService.bat ¼³Á¤À» º¯°æÇÏ°Ô µÇ¸é
OZServerUninstallService.bat, OZServerInstallService.batÀ» ´Ù½Ã ½ÇÇàÇÏ¿© ¼ºñ½º¸¦ Àçµî·ÏÇØ¾ß ¼ºñ½º·Î
¿ÀÁî¼¹ö ±¸µ¿½Ã º¯°æµÈ ¼³Á¤ÀÌ ¹Ý¿µµË´Ï´Ù.
* À§ÀÇ ¼³Á¤À» ÇÏ°í ³ª¼ µðÀÚÀÌ³Ê ¶Ç´Â ¼¹ö¸¦ Àç½ÃÀÛÇØ¾ß ¹Ý¿µµË´Ï´Ù.
* Âü°í »çÇ×
mssql2000, mssql2005¿¡ µ¿½Ã¿¡ ¿¬°áÇØ¾ß ÇÏ´Â °æ¿ì ¾Æ·¡¿Í °°ÀÌ ¼³Á¤Çϼ¼¿ä.
1. jdbcµå¶óÀ̹ö¿Í jdk¹öÀüÀº 2005±âÁØÀ¸·Î ¼³Á¤ÇÕ´Ï´Ù. (sqljdbc.jar, jdk1.4ÀÌ»ó)
2. 2005µå¶óÀ̹ö¸¦ 2000¿¡¼µµ »ç¿ëÇϱâ À§ÇØ dbconfig.xml ÆÄÀÏÀÇ DRIVER, URLÁ¤º¸¸¦ 2005±âÁØÀ¸·Î º¯°æÇØ¾ß ÇÕ´Ï´Ù.
- OZ Query Designer\dbconfig.xml
- OZ Report Designer\dbconfig.xml
- OZ Application Designer\dbconfig.xml
- OZ Servlet\conf\dbconfig.xml
- OZ Server\conf\dbconfig.xml
(dbconfig.xml)
<VENDOR NAME="mssql"> <DISPLAYNAME> <LABEL LANG="en_us">MS-SQL</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.microsoft.sqlserver.jdbc.SQLServerDriver</JAVA> <NET>System.Data.SqlClient.SqlConnection</NET> </DRIVER>
<URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName}</JAVA> <NET>Network Library=DBMSSOCN;Data Source={serverAddress},{portNo};Initial Catalog={dbName};User ID={user};Password={password};</NET> </URL> |
3. db.properties ¿¡¼ mssql2000Àº ¾Æ·¡¿Í °°ÀÌ ¼³Á¤Çϼ¼¿ä.
# # sample1 # mssql_example.vendor=mssql mssql_example.serverAddress=127.0.0.1 mssql_example.portNo=1433 mssql_example.dbName=***** mssql_example.user=*** mssql_example.password=*** mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 mssql_example.doConnectionCheck=true mssql_example.testQueryString=select 1
# # sample2 #
user_example1.vendor=user user_example1.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver user_example1.url=jdbc:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName} user_example1.props=user=****;password=**** user_example1.user=**** user_example1.password=**** user_example1.maxconns=20 user_example1.initconns=5 user_example1.timeout=5 user_example1.doConnectionCheck=true user_example1.testQueryString=select 1 |
Âü°í·Î dbNameÀÇ SelectMethod=Cursor´Â mssql2000 µå¶óÀ̹ö¸¦ »ç¿ëÇÒ ¶§ °¡´ÉÇÕ´Ï´Ù.
* ÷ºÎÀÚ·á ¼³¸í
- sqljdbc.jar : 1.2 ¹öÀü (2008.10.29 ±âÁØ ÃֽŠmssql2005 µå¶óÀ̹ö)
|