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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
