Trunk test help for 2.3.0a2 release (JAMES-485 java.sql.SQLException)

[Stefano Bagnara <ap...@bago.org>]

I cannot reproduce this issue.

I'm not able to reproduce other sql errors reported by Norman previously.

Can anyone test the current trunk against mysql 4+ with mysqlconnector 
3.1.12 or 5.0beta and provide feedback on the issue Norman reported?

I would be happy if someone could test the spooling after changing the 
default inMemorySizeLimit to "1" in JDBCMailRepository and 
JDBCSpoolRepository.

This should be tested with both db and dbfiles.

Once we close this we will be ready for a 2.3.0a2 release.

Stefano

Norman Maurer (JIRA) wrote:
> java.sql.SQLException: Incorrect arguments to mysql_stmt_execute in current trunk
> ---------------------------------------------------------------------------------
> 
>          Key: JAMES-485
>          URL: http://issues.apache.org/jira/browse/JAMES-485
>      Project: James
>         Type: Bug
> 
>  Environment: debian sarge, java 1.5, mysql 4.1, mysql connector 3.1 or 5.0-beta
>     Reporter: Norman Maurer
>     Priority: Critical
> 
> 
> After upgrade to rhe latest trunk i get and java.sql.SQLException: Incorrect arguments to mysql_stmt_execute. Here it is:
> 
> 04/05/06 15:16:17 ERROR James: Error storing message: Exception caught while storing mail Container:
> javax.mail.MessagingException: Exception caught while storing mail Container: ;
>   nested exception is:
>         java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
>         at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:762)
>         at org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRepository.java:236)
>         at org.apache.james.mailrepository.MailStoreSpoolRepository.store(MailStoreSpoolRepository.java:124)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134)
>         at $Proxy5.store(Unknown Source)
>         at org.apache.james.James.sendMail(James.java:486)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134)
>         at $Proxy9.sendMail(Unknown Source)
>         at org.apache.james.smtpserver.SendMailHandler.onMessage(SendMailHandler.java:60)
>         at org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:407)
>         at org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:422)
>         at org.apache.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.java:55)
>         at org.apache.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:116)
> Caused by: java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
>         at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1159)
>         at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:684)
>         at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:768)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
>         at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:750)
>         ... 20 more
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org