Re: JDBC with JavaServlet

 I have a servlet that access a mSQL database, and it works. 

 If the user has no password, call getConnection with a password 
 equals to "".

 Benoit.

Somchai LIMSIRORATANA writes:

> Dear all,
> 	I don't know which group I should post my problem. Sorry, if I was
>  wrong.
> 	I write a Java servlet run on Jigsaw which use JDBC connect to mys
> ql server
> . I use a com.mm.mysql driver to connect the sql server.
> 	When my servlet connect(getConnection()), Jigsaw return error mess
> age like 
> this :
> ========================================================================
> java.lang.IllegalAccessError: com.mm.mysql.MysqlIO.HEADER_LENGTH
>         at
>         at com.mm.mysql.MysqlIO.init(MysqlIO.java)
>         at com.mm.mysql.Connection.<init>(Connection.java)
>         at com.mm.mysql.Driver.connect(Driver.java)
>         at java.sql.DriverManager.getConnection(DriverManager.java:91)
>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
>         at coe.servlet.WebCounter.countSQL(WebCounter.java:102)
>         at coe.servlet.WebCounter.doGet(WebCounter.java:80)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
>         at org.w3c.jigsaw.servlet.ServletWrapper.service(ServletWrapper.
> java
> :166
> )
>         at org.w3c.jigsaw.servlet.ServletWrapperFrame.perform(ServletWra
> pper
> Fram
> e.java:98)
>         at org.w3c.tools.resources.FramedResource.performFrames(FramedRe
> sour
> ce.j
> ava:559)
>         at org.w3c.tools.resources.FramedResource.perform(FramedResource
> .jav
> a:57
> 3)
>         at org.w3c.jigsaw.http.httpd.perform(httpd.java:1516)
>         at org.w3c.jigsaw.http.Client.processRequest(Client.java:384)
>         at org.w3c.jigsaw.http.Client.startConnection(Client.java:459)
>         at org.w3c.jigsaw.http.socket.SocketClient.run(SocketClient.java
> :114
> )
>         at org.w3c.util.CachedThread.run(ThreadCache.java:86)
> ========================================================================
> ====
> ===========
> 	I try to check which wrong.
> 	So, I try to use JDBCTest1_03, a test suit from Sun. Its work well
> . No prob
> lem to connect to mysql with the same url,user and password.
> 	I think, it is a problem of the password, because I don't know, if
>  the user
>  has no password, how I call the getConnection().
> 
> bye,
> 
> ----------<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 6
> 0  
> 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
> 
> 
> 


- Benoît Mahé -------------------------------------------------------
                      World Wide Web Consortium (W3C)
                    Architecture domain - Jigsaw Team           

  http://www.w3.org/People/Mahe - bmahe@w3.org - +33.4.92.38.79.89 
---------------------------------------------------------------------

Received on Monday, 6 July 1998 10:58:08 UTC