Re: JDBC with JavaServlet

Dear all,
	I can solve my problem. It occure because the admin(http-server) does not h
as a accessibility. I set http-server/realm/admin/groups and then it work.
	I ever use Jigsaw 1.0 before and it has some setting like this. But, Jigsaw
 2.0's document does not perfect yet. Please insert this case in the documen
t.

Bye,
Re> I have a servlet that access a mSQL database, and it works. 
Re>
Re> If the user has no password, call getConnection with a password 
Re> equals to "".
Re>
Re> Benoit.
Re>
Re>Somchai LIMSIRORATANA writes:
Re>
Re>> Dear all,
Re>> 	I don't know which group I should post my problem. Sorry, if I was
Re>>  wrong.
Re>> 	I write a Java servlet run on Jigsaw which use JDBC connect to mys
Re>> ql server
Re>> . I use a com.mm.mysql driver to connect the sql server.
Re>> 	When my servlet connect(getConnection()), Jigsaw return error mess
Re>> age like 
Re>> this :
Re>> =======================================================================
=
Re>> java.lang.IllegalAccessError: com.mm.mysql.MysqlIO.HEADER_LENGTH
Re>>         at
Re>>         at com.mm.mysql.MysqlIO.init(MysqlIO.java)
Re>>         at com.mm.mysql.Connection.<init>(Connection.java)
Re>>         at com.mm.mysql.Driver.connect(Driver.java)
Re>>         at java.sql.DriverManager.getConnection(DriverManager.java:91)
Re>>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
Re>>         at coe.servlet.WebCounter.countSQL(WebCounter.java:102)
Re>>         at coe.servlet.WebCounter.doGet(WebCounter.java:80)
Re>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
Re>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
Re>>         at org.w3c.jigsaw.servlet.ServletWrapper.service(ServletWrapper.
Re>> java
Re>> :166
Re>> )
Re>>         at org.w3c.jigsaw.servlet.ServletWrapperFrame.perform(ServletWr
a
Re>> pper
Re>> Fram
Re>> e.java:98)
Re>>         at org.w3c.tools.resources.FramedResource.performFrames(FramedR
e
Re>> sour
Re>> ce.j
Re>> ava:559)
Re>>         at org.w3c.tools.resources.FramedResource.perform(FramedResourc
e
Re>> .jav
Re>> a:57
Re>> 3)
Re>>         at org.w3c.jigsaw.http.httpd.perform(httpd.java:1516)
Re>>         at org.w3c.jigsaw.http.Client.processRequest(Client.java:384)
Re>>         at org.w3c.jigsaw.http.Client.startConnection(Client.java:459)
Re>>         at org.w3c.jigsaw.http.socket.SocketClient.run(SocketClient.jav
a
Re>> :114
Re>> )
Re>>         at org.w3c.util.CachedThread.run(ThreadCache.java:86)
Re>> =======================================================================
=
Re>> 	I try to check which wrong.
Re>> 	So, I try to use JDBCTest1_03, a test suit from Sun. Its work well
Re>> . No prob
Re>> lem to connect to mysql with the same url,user and password.
Re>> 	I think, it is a problem of the password, because I don't know, if
Re>>  the user
Re>>  has no password, how I call the getConnection().
Re>> 
Re>> bye,
Re>> 
Re>> ----------<Somchai Limsiroratana>lsomchai@e7sun-1.kais.kyoto-u.ac.jp---
-
Re>> W Agric. Process Engineering and Technology Lab.   H c/o Tawa sama     
 
Re>> W Dept. of Bio-production Engineering,             H Tanaka-asukai-cho 
60  
Re>> W Division of Environmental Science and Technology H Sakyo-ku, Kyoto   
 
Re>> W Graduate School of Agric. Science,               H 606-8226 JAPAN    
 
Re>> W KYOTO UNIVERSITY, Kyoto, JAPAN 606-01            H Tel:075-703-8169
Re>- Beno$B{U(B Mah$Bq(B-------------------------------------------------------
Re>                      World Wide Web Consortium (W3C)
Re>                    Architecture domain - Jigsaw Team           
Re>  http://www.w3.org/People/Mahe - bmahe@w3.org - +33.4.92.38.79.89 
Re>---------------------------------------------------------------------
----------<Somchai Limsiroratana>lsomchai@e7sun-1.kais.kyoto-u.ac.jp----------
W Agric. Process Engineering and Technology Lab.   H c/o Tawa sama         
W Dept. of Bio-production Engineering,             H Tanaka-asukai-cho 60  
W Division of Environmental Science and Technology H Sakyo-ku, Kyoto       
W Graduate School of Agric. Science,               H 606-8226 JAPAN        
W KYOTO UNIVERSITY, Kyoto, JAPAN 606-01            H Tel:075-703-8169

Received on Monday, 6 July 1998 12:55:27 UTC