글쓴이 :조신제 1999년 1월 25일 18:10:59
어플리케이션으로 짜면 DB에 연결이 되는데
웹에서만 아래와 같은 에러가 나요.
혹시 Informix DBMS 사용하시는 분 계시면 좀 봐주세요.
프로그램 소스
import java.sql.*;
import java.util.*;
import java.applet.*;
public class Money extends Applet {
public void init()
{
String in_host = "jdbc:informix-sqli://210.126.14.1:";
String in_info = "/stores7:informixserver=ius;user=informix;password=informix";
// 패스워드는 위와 다릅니다.
String url = in_host + "1998" + in_info;
Connection conn = null;
int rc;
String cmd=null;
Statement stmt = null;
String testName = "Simple Select Statement";
System.out.println(">>>" + testName + " test.");
System.out.println("URL = \"" + url + "\"");
try
{
Class.forName("com.informix.jdbc.IfxDriver");
}
catch (Exception e)
{
System.out.println("ERROR: failed to load Informix JDBC driver.");
}
try
{
conn = DriverManager.getConnection(url);
}
catch (SQLException e)
{
System.out.println("ERROR: failed to connect!" + e);
}
try {
stmt=conn.createStatement();
cmd="drop table x;";
rc=stmt.executeUpdate(cmd);
}
catch (SQLException e)
{
System.out.println("Error:"+e.getMessage());
}
try
{
stmt = conn.createStatement();
cmd = "create table x(a char(20));";
rc = stmt.executeUpdate(cmd);
}
catch (SQLException e)
{
System.out.println("ERROR: execution failed - statement: " + cmd);
System.out.println("ERROR: " + e.getMessage());
}
try
{
// String name=ko2asc("인포믹스");
String name="인포믹스";
// name = name.replace("'","''");
cmd = "insert into x values ('"+name+"');";
rc = stmt.executeUpdate(cmd);
}
catch (SQLException e)
{
System.out.println("ERROR: execution failed - statement: " + cmd);
System.out.println("ERROR: " + e.getMessage());
}
/**
* Select Data from hoho table
*/
try{
String select="select * from x";
System.out.println(select);
PreparedStatement pstmt = conn.prepareStatement(select);
ResultSet rset = pstmt.executeQuery();
while(rset.next()){
// System.out.println(asc2ko(rset.getString(1)));
System.out.println(rset.getString(1));
}
rset.close();
pstmt.close();
}catch(SQLException e){
System.out.println("Failed to connect!");
}
try
{
conn.close();
}
catch (SQLException e)
{
System.out.println("ERROR: failed to close the connection!");
}
System.out.println(">>>End of " + testName + " test.");
}
public static String ko2asc(String str) {
String result = null;
try {
byte[] rawBytes = str.getBytes("KSC5601");
result = new String(rawBytes, "8859_1");
}
catch(java.io.UnsupportedEncodingException e) {
System.err.println(e.toString());
}
return result;
}
public static String asc2ko(String str) {
String result = null;
try {
byte[] rawBytes = str.getBytes("8859_1");
result = new String(rawBytes, "KSC5601");
}
catch(java.io.UnsupportedEncodingException e) {
System.err.println(e.toString());
}
return result;
}
}
에러 메시지
>>>Simple Select Statement test.
URL = "jdbc:informix-sqli://210.126.14.1:1998/stores7:informixserver=ius;user=informix;password=eogksalsrnr"
ERROR: failed to connect!java.sql.SQLException: No suitable driver
java.lang.NullPointerException
at Money.init(Compiled Code)
* at netscape.applet.DerivedAppletFrame$InitAppletEvent.dispatch(Compiled Code)
at java.awt.EventDispatchThread$EventPump.dispatchEvents(Compiled Code)
at java.awt.EventDispatchThread.run(Compiled Code)
at netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(Compiled Code)