MySQL drivers, getObject (and Ultradev)

[Alex McLintock <al...@arcfan.demon.co.uk>]

Hi folks,

INFO, followed by a problem, followed by my setup information.

I am hoping to get Dreamweaver Ultradev working with Tomcat and MySQL. I 
read with interest the problem with Ultradev generating code like

PreparedStatement StatementrsReleaseSummaries =
    ConnrsReleaseSummaries.prepareCall("SELECT PRID, PRTitle, PRShort, 
PRDate FROM PressReleases");
ResultSet rsReleaseSummaries = StatementrsReleaseSummaries.executeQuery();

when it should say this with MySQL

PreparedStatement StatementrsReleaseSummaries =
ConnrsReleaseSummaries.prepareStatement("SELECT PRID, PRTitle, PRShort, 
PRDate FROM PressReleases");
ResultSet rsReleaseSummaries = StatementrsReleaseSummaries.executeQuery();


(Also it tries to do this which the MySQL driver (mm version 1.2 ) doesn;t like
/* StatementrsReleaseSummaries.setQueryTimeout(0); */
)

Anyway I now get as far as the JSP call

<%= 
((rsReleaseSummaries.getObject("PRTitle")!=null)?rsReleaseSummaries.getObject("PRTitle"):"") 
%>

which causes this error

javax.servlet.ServletException
         at 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java, 
Compiled Code)
         at 
jsp.diverse._0002fjsp_0002fdiverse_0002fextranet_0005fnews_0005fmysql_0002ejspextranet_0005fnews_0005fmysql_jsp_17._jspService(_0002fjsp_0002fdiverse_0002fextranet_0005fnews_0005fmysql_0002ejspextranet_0005fnews_0005fmysql_jsp_17.java:106)
         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, 
Compiled Code)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java, 
Compiled Code)
         at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java, 
Compiled Code)
         at 
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java, 
Compiled Code)
         at org.apache.jasper.runtime.JspServlet.service(JspServlet.java, 
Compiled Code)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java, 
Compiled Code)
         at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, 
Compiled Code)
         at 
org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled 
Code)
         at 
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, 
Compiled Code)
         at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, 
Compiled Code)
         at java.lang.Thread.run(Thread.java, Compiled Code)

Root cause:

java.lang.NullPointerException
         at org.gjt.mm.mysql.ResultSet.getObject(ResultSet.java, Compiled Code)
         at org.gjt.mm.mysql.ResultSet.getObject(ResultSet.java, Compiled Code)
         at 
jsp.diverse._0002fjsp_0002fdiverse_0002fextranet_0005fnews_0005fmysql_0002ejspextranet_0005fnews_0005fmysql_jsp_17._jspService(_0002fjsp_0002fdiverse_0002fextranet_0005fnews_0005fmysql_0002ejspextranet_0005fnews_0005fmysql_jsp_17.java:83)
         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, 
Compiled Code)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java, 
Compiled Code)
         at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java, 
Compiled Code)
         at 
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java, 
Compiled Code)
         at org.apache.jasper.runtime.JspServlet.service(JspServlet.java, 
Compiled Code)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java, 
Compiled Code)
         at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, 
Compiled Code)
         at 
org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled 
Code)
         at 
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, 
Compiled Code)
         at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, 
Compiled Code)
         at java.lang.Thread.run(Thread.java, Compiled Code)




I don't believe it is a permissions problem (though I think MySQL 
permissions are a nightmare).
If I change the password to something else it does give me a sensible 
access denied failure different to this.

SETUP
NT4 runnning apache, jserv (downloaded from the Tomcat site - not built 
myself), and old copy of TomCat,
MySQL running on a separate Linux box.

I am using the latest mm.MySQL driver version 1.2 but a three month old 
copy of Tomcat. Of course I will update to the latest version of TomCat but 
is that the problem?

(PS Yes - I am going through Apache and the JServ but I seem to get the 
same problem if I go straight to Tomcat.)

Any ideas.

I tried switching on the MySQL log but couldn't seem to figure out how.

Cheers

Alex