수다닷컴

안녕하세요.
WebShpere 3.5와 MySQL 5 DB를 사용하여 개발하려고 합니다.
JDBC Driver 화일(mysql-connector-java-3.1.8-bin.jar)을 받아서 D:\WebSphere\AppServer\lib 폴더에 복사하고, Classpath를 아래와 같이 설정을 하였습니다.
1. Windows 환경변수의 Classpath에 D:\WebSphere\AppServer\lib\mysql-connector-java-3.1.8-bin.jar를 추가
[Full Script]
.;D:\Program Files\SQLLIB\java\db2java.zip;D:\Program Files\SQLLIB\java\runtime.zip;D:\Program Files\SQLLIB\java\sqlj.zip;D:\Program Files\SQLLIB\bin;D:\WebSphere\AppServer\lib\mysql-connector-java-3.1.8-bin.jar
2. D:\WebSphere\AppServer\bin\admin.config 화일의 com.ibm.ejs.sm.adminserver.classpath에 d\:/WebSphere/AppServer/lib/mysql-connector-java-3.1.8-bin.jar를 추가
[Full Script]
com.ibm.ejs.sm.adminserver.classpath=d\:/WebSphere/AppServer/lib/ibmwebas.jar;d\:/WebSphere/AppServer/properties;d\:/WebSphere/AppServer/lib/servlet.jar;d\:/WebSphere/AppServer/lib/webtlsrn.jar;d\:/WebSphere/AppServer/lib/lotusxsl.jar;d\:/WebSphere/AppServer/lib/compat.jar;d\:/WebSphere/AppServer/lib/xalan.jar;d\:/WebSphere/AppServer/lib/ns.jar;d\:/WebSphere/AppServer/lib/ejs.jar;d\:/WebSphere/AppServer/lib/ujc.jar;d\:/WebSphere/AppServer/lib/idb.jar;d\:/WebSphere/AppServer/lib/repository.jar;d\:/WebSphere/AppServer/lib/admin.jar;d\:/WebSphere/AppServer/lib/swingall.jar;d\:/WebSphere/AppServer/lib/console.jar;d\:/WebSphere/AppServer/lib/was20cm.jar;d\:/WebSphere/AppServer/lib/tasks.jar;d\:/WebSphere/AppServer/lib/xml4j.jar;d\:/WebSphere/AppServer/lib/vaprt.jar;d\:/WebSphere/AppServer/lib/sslight.jar;d\:/WebSphere/AppServer/lib/ibmjndi.jar;d\:/WebSphere/AppServer/lib/deployTool.jar;d\:/WebSphere/AppServer/lib/databeans.jar;d\:/WebSphere/AppServer/classes;d\:/WebSphere/AppServer/jdk/lib/tools.jar;d\:/WebSphere/AppServer/lib/bsf.jar;d\:/WebSphere/AppServer/lib/dertrjrt.jar;d\:/WebSphere/AppServer/lib/derdbpw.jar;d\:/WebSphere/AppServer/lib/ivjejb35.jar;D\:/WebSphere/AppServer/lib/js.jar;d\:/WebSphere/AppServer/lib/mysql-connector-java-3.1.8-bin.jar
3. D:\WebSphere\AppServer\bin\adminclient.bat File에 아래와 같이 추가
[Full Script]
rem setup the classpath
set WAS_CP=%WAS_HOME%\lib\ibmwebas.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\properties
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\chart.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\ejs.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\ujc.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\repository.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\admin.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\servlet.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\servletconsole.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\tasks.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\console.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\vaprt.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\sslight.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\lib\xml4j.jar
set WAS_CP=%WAS_CP%;%WAS_HOME%\web\help
set WAS_CP=%WAS_CP%;%JAVA_HOME%\lib\tools.jar
set WAS_CP=%WAS_CP%;D:\WebSphere\AppServer\lib\mysql-connector-java-3.1.8-bin.jar

%JAVA_HOME%\bin\java -Xms9m -Xminf0.15 -Xmaxf0.25 -classpath %WAS_CP% %CLIENTSAS% -Dcom.ibm.CORBA.principalName=%COMPUTERNAME%/AdminClient -Dserver.root=%WAS_HOME% com.ibm.ejs.sm.client.ui.EJSConsole %DEST% %DESTPORT% %DEBUGOPTS% %QUALIFYNAMES%
위의 3가지 방법 모두 설정을 하였는데, 아래와 같은 에러가 발생합니다.

[JSP 페이지의 에러 내용]
java.lang.NoClassDefFoundError: java/sql/Savepoint
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java(Compiled Code))
at java.sql.DriverManager.getConnection(DriverManager.java:139)
JSP Page 소스 화일을 아래에 첨부 합니다.[자바 에러 내용]
Exception in thread main java.lang.NoClassDefFoundError: java/sql/Savepoint
 sp; at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:459)
at java.sql.DriverManager.getConnection(DriverManager.java:139)
at TestMySQL.main(TestMySQL.java:34)
자바 소스 화일도 아래에 첨부합니다.
혹시 해결 방법을 아시는 고수님들의 많은 조언 부탁드리겠습니다.
수고하시고요.
즐겁고 행복한 하루 보내십시오.

신청하기