You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by John Burgess <jo...@fastex.net> on 2000/07/05 02:53:20 UTC
Linux, Apache, Tomcat, Mysql, Ultradev
Grettings Tomcat Users,
I am new to Tomcat and Java, and I have successfully (I believe)
built/installed Apache with mod_jserv, Tomcat, and MySql using MM.MySQL
classes. The MySQL drivers load and I can connect to databases.
I am now attempting to use Ultradev as a development tool on top of this
combination. This shall be my first attempt at jsp web pages instead of
html and perl cgi.
I am trying to do a simple select that returns the following. Does anyone
have any idea what this means and what I might be doing wrong??
--John
fastex.net
Error: 500
Location: /test/beta/index.jsp
Internal Servlet Error:
javax.servlet.ServletException: Callable statments not suppoted.
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java, Compiled Code)
at
beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
ndex_0002ejspindex_jsp_1.java, Compiled Code)
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.ja
va, 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.sql.SQLException: Callable statments not suppoted.
at org.gjt.mm.mysql.Connection.prepareCall(Connection.java, Compiled Code)
at
beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
ndex_0002ejspindex_jsp_1.java, Compiled Code)
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.ja
va, 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)
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by John Burgess <jo...@fastex.net>.
Thanks to all who help out with this question with your insight. That is
exactly the problem. Although a recordset query was specified from UltraDev
it is generating a callable (stored procedure).
--John
----- Original Message -----
From: "John McKendry" <mc...@mediaone.net>
To: <to...@jakarta.apache.org>
Sent: Tuesday, July 04, 2000 9:21 PM
Subject: Re: Linux, Apache, Tomcat, Mysql, Ultradev
> John Burgess wrote:
> >
> > Grettings Tomcat Users,
> >
> > I am new to Tomcat and Java, and I have successfully (I believe)
> > built/installed Apache with mod_jserv, Tomcat, and MySql using MM.MySQL
> > classes. The MySQL drivers load and I can connect to databases.
> >
> > I am now attempting to use Ultradev as a development tool on top of this
> > combination. This shall be my first attempt at jsp web pages instead of
> > html and perl cgi.
> >
> > I am trying to do a simple select that returns the following. Does
anyone
> > have any idea what this means and what I might be doing wrong??
> >
> > --John
> > fastex.net
> >
> > Error: 500
> > Location: /test/beta/index.jsp
> > Internal Servlet Error:
> >
> > javax.servlet.ServletException: Callable statments not suppoted.
> > at
> >
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> > l.java, Compiled Code)
> > at java.lang.Thread.run(Thread.java, Compiled Code)
> > (...)
> > Root cause:
> > java.sql.SQLException: Callable statments not suppoted.
> > at org.gjt.mm.mysql.Connection.prepareCall(Connection.java,
Compiled Code)
> > at
> >
beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
> > ndex_0002ejspindex_jsp_1.java, Compiled Code)
> >(etc.)
>
> prepareCall() is used to prepare a call to a stored procedure. It appears
that
> MySQL doesn't support callable stored procedures. If you're trying to
execute a
> simple SELECT, you probably want to use prepareStatement() rather than
prepareCall().
>
> -John McKendry
>
> --------------------------------------------------------------------------
> To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commmands, email: tomcat-user-help@jakarta.apache.org
>
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by Holger Klawitter <ho...@klawitter.de>.
> Does PostgreSQL use stored procedures?
Yes, postgreSQL supports stored procedures
(written in SQL and other langauges).
Regards,
Mit freundlichem Gruß,
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger@klawitter.de http://www.klawitter.de/
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by Thomas <li...@jps.net>.
Does PostgreSQL use stored procedures?
----- Original Message -----
From: billd <po...@bill.co.uk>
To: <to...@jakarta.apache.org>
Sent: Wednesday, July 05, 2000 6:40 AM
Subject: Re: Linux, Apache, Tomcat, Mysql, Ultradev
> Hmmm, just found this over on the macromedia UltraDev newsgoup
> and thought it might be of interest to anyone else getting ready to
> spend time on getting apache/tomcat/jdbc to work with UltraDev as UltraDev
> uses .prepareCall instead of .prepareStatement... I haven't had an answer
from
> them yet, but hope to clarify and if necessary return UltraDev if this is
how they
> expect me to use it.
>
> Cheers
> Bill
>
>
> > > From: "Bruno"
> > > Organization: TOKOM
> > > Newsgroups: macromedia.ultradev
> > > Date: Thu, 29 Jun 2000 02:39:04 -0400
> > > Subject: Re: JSP, prepareCall() and MySql
> > >
> > >
> > > I replaced all "prepareCall" by "prepareStatement" in the appropriate
.js
> > > files in serverbehaviors/jsp (resultset.js, JSPResultSetMasks.js...)
and in
> > > translator/jps.htm (code inspector ?).
> > > It seems like working....
> >
> > Indeed this does work and you can alter the files which produces the
code so
> > you don't have to change it all the time. BUT this means that you can't
then
> > drag and drop dynamic content onto the page as there is no recordset
> > created. As Troy says, you'd be better off hand coding. I've contacted
MM
> > about this twice now and haven't got anywhere nearer solving the
problem.
> > UltraDev is currently sitting unused and gathering dust and we're a few
> > hundred quid lighter in the pocket.
> >
>
> --
> Priviliged/Confidential Information may be contained in this
> Electronic Message and is intended only for the use of the
> addressee. If you are not the addressee, or the person
> for delivering this Message to the addressee, you may not copy
> or deliver this Message to anyone else. If you receive this
> Message by mistake, please notify the sender. In fact, I highly
> recommend that this message not be read at all. Instead it should be
> deleted immediately and the computer upon which is was received
> be destroyed with an explosive device. If any remnants of this message
> should remain in the addressee's intellectual storage areas, these
> should also be destroyed using electroshock therapy. The senders
> "final remedy" in all cases will be to destroy the medium over which
> the electronic message was initially transmitted. This may be, but
> shall
> not be limited to part or all of the Internet and all computers
> connected
> to it.
>
>
>
> --------------------------------------------------------------------------
> To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commmands, email: tomcat-user-help@jakarta.apache.org
>
>
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by billd <po...@bill.co.uk>.
Hmmm, just found this over on the macromedia UltraDev newsgoup
and thought it might be of interest to anyone else getting ready to
spend time on getting apache/tomcat/jdbc to work with UltraDev as UltraDev
uses .prepareCall instead of .prepareStatement... I haven't had an answer from
them yet, but hope to clarify and if necessary return UltraDev if this is how they
expect me to use it.
Cheers
Bill
> > From: "Bruno"
> > Organization: TOKOM
> > Newsgroups: macromedia.ultradev
> > Date: Thu, 29 Jun 2000 02:39:04 -0400
> > Subject: Re: JSP, prepareCall() and MySql
> >
> >
> > I replaced all "prepareCall" by "prepareStatement" in the appropriate .js
> > files in serverbehaviors/jsp (resultset.js, JSPResultSetMasks.js...) and in
> > translator/jps.htm (code inspector ?).
> > It seems like working....
>
> Indeed this does work and you can alter the files which produces the code so
> you don't have to change it all the time. BUT this means that you can't then
> drag and drop dynamic content onto the page as there is no recordset
> created. As Troy says, you'd be better off hand coding. I've contacted MM
> about this twice now and haven't got anywhere nearer solving the problem.
> UltraDev is currently sitting unused and gathering dust and we're a few
> hundred quid lighter in the pocket.
>
--
Priviliged/Confidential Information may be contained in this
Electronic Message and is intended only for the use of the
addressee. If you are not the addressee, or the person
for delivering this Message to the addressee, you may not copy
or deliver this Message to anyone else. If you receive this
Message by mistake, please notify the sender. In fact, I highly
recommend that this message not be read at all. Instead it should be
deleted immediately and the computer upon which is was received
be destroyed with an explosive device. If any remnants of this message
should remain in the addressee's intellectual storage areas, these
should also be destroyed using electroshock therapy. The senders
"final remedy" in all cases will be to destroy the medium over which
the electronic message was initially transmitted. This may be, but
shall
not be limited to part or all of the Internet and all computers
connected
to it.
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by Bill Dossett <po...@bill.co.uk>.
ok... it should be using a prepareStatement.. and it works... now to find
out what Macromedia are up to...
sorry for the bother.... thanks
Bill
Bill Dossett wrote:
> Hi,
>
> I'm doing nearly the same, but using MSSQL with the
> FreeTDS driver installed... Ultradev produces:
>
> PreparedStatement StatementRecordset1 = ConnRecordset1.prepareCall("SELECT IR, Details
> FROM dbo.incident_reports WHERE IR = "+Recordset1__MMColParam + "");
>
> in my test.jsp....
>
> and I get a 500 internal servlet error
>
> Root cause:
>
> java.sql.SQLWarning: Could not find stored procedure 'SELECT'.
> at com.internetcds.jdbc.tds.SqlMessage.toSQLWarning(SqlMessage.java:80)
> at
> com.internetcds.jdbc.tds.PreparedStatement_base.executeCall(PreparedStatement_base.java:209)
>
> at
> com.internetcds.jdbc.tds.CallableStatement_base.execute(CallableStatement_base.java:394)
> at
> com.internetcds.jdbc.tds.PreparedStatement_base.executeQuery(PreparedStatement_base.java:330)
>
> at
> _0002ftest_0002ejsptest_jsp_6._jspService(_0002ftest_0002ejsptest_jsp_6.java:75)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
> at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
> at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:156)
>
> at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
> at java.lang.Thread.run(Thread.java:475)
>
> which is a different error message than below... but I'm still not sure about why it
> thinks this is a stored procedure... Ultradev produces the code and I have only started
> working out how the code works... but this is over my head... if anyone could tell
> me why it is trying to find an sp, rather than just execute the sql statement, I can
> probably work out why Ultradev isn't putting the right code in.... was hoping that
> I could do less coding by going this route as I'm only a hack type programmer.
>
> Thanks
>
> Bill
>
> John McKendry wrote:
>
> > John Burgess wrote:
> > >
> > > Grettings Tomcat Users,
> > >
> > > I am new to Tomcat and Java, and I have successfully (I believe)
> > > built/installed Apache with mod_jserv, Tomcat, and MySql using MM.MySQL
> > > classes. The MySQL drivers load and I can connect to databases.
> > >
> > > I am now attempting to use Ultradev as a development tool on top of this
> > > combination. This shall be my first attempt at jsp web pages instead of
> > > html and perl cgi.
> > >
> > > I am trying to do a simple select that returns the following. Does anyone
> > > have any idea what this means and what I might be doing wrong??
> > >
> > > --John
> > > fastex.net
> > >
> > > Error: 500
> > > Location: /test/beta/index.jsp
> > > Internal Servlet Error:
> > >
> > > javax.servlet.ServletException: Callable statments not suppoted.
> > > at
> > > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> > > l.java, Compiled Code)
> > > at java.lang.Thread.run(Thread.java, Compiled Code)
> > > (...)
> > > Root cause:
> > > java.sql.SQLException: Callable statments not suppoted.
> > > at org.gjt.mm.mysql.Connection.prepareCall(Connection.java, Compiled Code)
> > > at
> > > beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
> > > ndex_0002ejspindex_jsp_1.java, Compiled Code)
> > >(etc.)
> >
> > prepareCall() is used to prepare a call to a stored procedure. It appears that
> > MySQL doesn't support callable stored procedures. If you're trying to execute a
> > simple SELECT, you probably want to use prepareStatement() rather than prepareCall().
> >
> > -John McKendry
> >
> > --------------------------------------------------------------------------
> > To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commmands, email: tomcat-user-help@jakarta.apache.org
>
> --------------------------------------------------------------------------
> To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commmands, email: tomcat-user-help@jakarta.apache.org
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by Bill Dossett <po...@bill.co.uk>.
Hi,
I'm doing nearly the same, but using MSSQL with the
FreeTDS driver installed... Ultradev produces:
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareCall("SELECT IR, Details
FROM dbo.incident_reports WHERE IR = "+Recordset1__MMColParam + "");
in my test.jsp....
and I get a 500 internal servlet error
Root cause:
java.sql.SQLWarning: Could not find stored procedure 'SELECT'.
at com.internetcds.jdbc.tds.SqlMessage.toSQLWarning(SqlMessage.java:80)
at
com.internetcds.jdbc.tds.PreparedStatement_base.executeCall(PreparedStatement_base.java:209)
at
com.internetcds.jdbc.tds.CallableStatement_base.execute(CallableStatement_base.java:394)
at
com.internetcds.jdbc.tds.PreparedStatement_base.executeQuery(PreparedStatement_base.java:330)
at
_0002ftest_0002ejsptest_jsp_6._jspService(_0002ftest_0002ejsptest_jsp_6.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:156)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:475)
which is a different error message than below... but I'm still not sure about why it
thinks this is a stored procedure... Ultradev produces the code and I have only started
working out how the code works... but this is over my head... if anyone could tell
me why it is trying to find an sp, rather than just execute the sql statement, I can
probably work out why Ultradev isn't putting the right code in.... was hoping that
I could do less coding by going this route as I'm only a hack type programmer.
Thanks
Bill
John McKendry wrote:
> John Burgess wrote:
> >
> > Grettings Tomcat Users,
> >
> > I am new to Tomcat and Java, and I have successfully (I believe)
> > built/installed Apache with mod_jserv, Tomcat, and MySql using MM.MySQL
> > classes. The MySQL drivers load and I can connect to databases.
> >
> > I am now attempting to use Ultradev as a development tool on top of this
> > combination. This shall be my first attempt at jsp web pages instead of
> > html and perl cgi.
> >
> > I am trying to do a simple select that returns the following. Does anyone
> > have any idea what this means and what I might be doing wrong??
> >
> > --John
> > fastex.net
> >
> > Error: 500
> > Location: /test/beta/index.jsp
> > Internal Servlet Error:
> >
> > javax.servlet.ServletException: Callable statments not suppoted.
> > at
> > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> > l.java, Compiled Code)
> > at java.lang.Thread.run(Thread.java, Compiled Code)
> > (...)
> > Root cause:
> > java.sql.SQLException: Callable statments not suppoted.
> > at org.gjt.mm.mysql.Connection.prepareCall(Connection.java, Compiled Code)
> > at
> > beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
> > ndex_0002ejspindex_jsp_1.java, Compiled Code)
> >(etc.)
>
> prepareCall() is used to prepare a call to a stored procedure. It appears that
> MySQL doesn't support callable stored procedures. If you're trying to execute a
> simple SELECT, you probably want to use prepareStatement() rather than prepareCall().
>
> -John McKendry
>
> --------------------------------------------------------------------------
> To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commmands, email: tomcat-user-help@jakarta.apache.org
Re: Linux, Apache, Tomcat, Mysql, Ultradev
Posted by John McKendry <mc...@mediaone.net>.
John Burgess wrote:
>
> Grettings Tomcat Users,
>
> I am new to Tomcat and Java, and I have successfully (I believe)
> built/installed Apache with mod_jserv, Tomcat, and MySql using MM.MySQL
> classes. The MySQL drivers load and I can connect to databases.
>
> I am now attempting to use Ultradev as a development tool on top of this
> combination. This shall be my first attempt at jsp web pages instead of
> html and perl cgi.
>
> I am trying to do a simple select that returns the following. Does anyone
> have any idea what this means and what I might be doing wrong??
>
> --John
> fastex.net
>
> Error: 500
> Location: /test/beta/index.jsp
> Internal Servlet Error:
>
> javax.servlet.ServletException: Callable statments not suppoted.
> at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> l.java, Compiled Code)
> at java.lang.Thread.run(Thread.java, Compiled Code)
> (...)
> Root cause:
> java.sql.SQLException: Callable statments not suppoted.
> at org.gjt.mm.mysql.Connection.prepareCall(Connection.java, Compiled Code)
> at
> beta._0002fbeta_0002findex_0002ejspindex_jsp_1._jspService(_0002fbeta_0002fi
> ndex_0002ejspindex_jsp_1.java, Compiled Code)
>(etc.)
prepareCall() is used to prepare a call to a stored procedure. It appears that
MySQL doesn't support callable stored procedures. If you're trying to execute a
simple SELECT, you probably want to use prepareStatement() rather than prepareCall().
-John McKendry