±Û¾´ÀÌ :ÀÌ¿ø¿µ 1999³â 1¿ù 04ÀÏ 14:00:28
In Reply to: Java¿¡¼ DB¿¬°á...... (µµ¿ÍÁÖ¼¼¿ä!) posted by ÃÖ¿ëÈÆ on 1998³â 12¿ù 29ÀÏ 10:49:30:
Sybase DB¸¦ Java¿¡¼ »ç¿ëÇÏ·Á¸é ¿©ÇÏÇÑÀÇ DB¿Í ¸¶Âù°¡Áö·Î
JDBC Driver°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
Sybase´Â jConnect¶ó´Â JDBC Driver¸¦ »ç¿ëÇÕ´Ï´Ù.
Free´Â ¾Æ´Ï±¸¿ä, ÀÏÁ¤±â°£µ¿¾È »ç¿ëÇÒ ¼ö ÀÖ´Â »ó¿ë JDBC DriverÀÔ´Ï´Ù.
¾Æ·¡¿¡¼ ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.
URLÀÌ ¹Ù²î¾úÀ¸¸é www.sybase.com¿¡¼ ´Ù½Ã±Ý ã¾Æº¸¼¼¿ä.
http://www.sybase.com/products/internet/jconnect/jconnect41_drp.html
Username: jdbc, password: sybeta
ÀÏ´Ü ¹ÞÀ¸½Ã¸é fullinst.jar ÆÄÀÏÀÌ ´Þ¶û Çϳª°¡ ¿À´Âµ¥¿ä,
JDK°¡ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
C:\TEMP> set classpath=%classpath%;c:\temp\fullinst.jar
C:\TEMP> java com.sybase.install.Install
Java¿ë Install Shelled·Î ±¸¼ºµÇ¾î Àֳ׿ä.
Install¸¦ ¸¶Ä¡¸é, jConnect ÀνºÅç µð·ºÅ丮 ¹Ø¿¡
classes µð·ºÅ丮°¡ Àִµ¥¿ä, ÀÌ µð·ºÅ丮¸¦ CLASSPATH¿¡ ¼³Á¤Çϼ¼¿ä.
»ç¿ëÇϽô ¹æ¹ýÀº Oracle Thin Driver»ç¿ëÇϵíÀÌ »ç¿ëÇÏ¸é µÇ±¸¿ä,
¾Æ·¡¿¡ ¿¹Á¦°¡ ÀÖ½À´Ï´Ù.
Class c = Class.forName("com.sybase.jdbc.SybDriver");
DriverManager.registerDriver ((Driver)c.newInstance());
(À§ÀÇ µÎ ÁÙÀº DriverManager.registerDriver ( new com.sybase.jdbc.SybDriver() ); ¿Í
µ¿ÀÏÇÕ´Ï´Ù.)
java.util.Properties prop = new java.util.Properties();
prop.put("user", "java");
prop.put("password", "java01");
prop.put("CHARSET", "eucksc");
DriverManager.getConnection("jdbc:sybase:Tds:165.244.227.196:5000/lgeds", prop );
ÇѱÛÀ» ¿øÇÒÈ÷ »ç¿ëÇϽ÷Á¸é prop.put("CHARSET", "eucksc"); ÀÌ ºÎºÐÀÌ ¹Ýµå½Ã ÀÖ¾î¾ß
Çϱ¸¿ä, Çѱۺ¯È¯À» À§ÇØ Æ¯º°È÷ ÀÛ¾÷ÇÒ °ÍÀº ¾ø½À´Ï´Ù.
ServletÀÌµç ¹¹µç DB¿Í ¿¬°áÀ» ÇÏ·Á¸é Sybase´Â jConnect JDBC Driver¸¦
»ç¿ëÇÕ´Ï´Ù. ServletÀº ±×·¯¸é ¾î¶»°Ô ÇÏ´À³Ä? ÀÌ°ÍÀº Sybase¿Í °ü·ÃÀÌ ¾ø´Â
¾ê±â³×¿ä, Servlet¿¡ °ü·ÃµÈ ÀÌ°÷ Àڷᳪ ´Ù¸¥ Servlet »çÀÌÆ®¸¦ Âü°í Çϼ¼¿ä.