Hi Jon

On Mon, 10 Jan 2000, jon * wrote:

> on 1/10/00 3:56 AM, Bernie <[EMAIL PROTECTED]> wrote:

> What is the exception? Could you please copy/paste it into an email?

It is the same as I reported ealier to this list:

Get/Post Data:

 action         = AddNewProject
 screen         = DisplayProjects
 display_order  = 
 project_value  = testproj
 submit2        = Save


java.sql.SQLException: No value specified for parameter 1
        at java.lang.Throwable.fillInStackTrace(Native Method)
        at java.lang.Throwable.fillInStackTrace(Compiled Code)
        at java.lang.Throwable.(Compiled Code)
        at java.lang.Exception.(Exception.java:42)
        at java.sql.SQLException.(SQLException.java:64)
        at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Compiled  Code)
        at com.workingdogs.village.Record.saveWithInsert(Compiled Code)
        at com.workingdogs.village.Record.save(Record.java:185)
        at com.workingdogs.village.Record.save(Record.java:166)
        at org.apache.jyve.actions.AddNewProject.build(AddNewProject.java:109)
        at org.apache.turbine.modules.ActionLoader.exec(Compiled Code)
        at org.apache.turbine.pages.DefaultPage.build(DefaultPage.java:84)
        at org.apache.turbine.modules.PageLoader.exec(Compiled Code)
        at Turbine.doGet(Compiled Code)
        at Turbine.doPost(Turbine.java:338)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
        at org.apache.jserv.JServConnection.run(Compiled Code)
        at java.lang.Thread.run(Compiled Code)

java.sql.SQLException: No value specified for parameter 1


> database.default.url=jdbc:mysql://drwho.ethz.ch/bhoeneis
> 
> what is bhoeneis? You should make that the name of the database.

"bhoeneis" is the name of the database.

> > The problem is somehow connected to the MySQL classes. At
> > least the Exception is thrown in the PreparedStatement from the
> > executeUpdate() methode.
> 
> yea, this doesn't do me any good...i don't know what line is causing you the
> problems. Also, I believe that I usually use the 1.2b version of the MySQL
> classes...

I marked the line where the Exception is thrown with a comment:
"// THE EXECPTION IS THROWN HERE:" in the file on URL
http://www.ee.ethz.ch/~faq/jyve/PreparedStatement.java

I'll try the other changes you proposed. But tomorrow morning.
(yes it's almost midnight here in Central Europe...)

Have fun!

 Bernie



--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]

Reply via email to