You are viewing a plain text version of this content. The canonical link for it is here.

Posted to server-user@james.apache.org by "Jankiraman, Radhakrishnan" <rj...@emptoris.com> on 2009/12/16 17:04:01 UTC

[Using a JDBC Repository] Error trying to insert a message into inbox table.

Hi,

I am just getting started with JAMES. I am trying to use version 2.3.2 configured to use mysql db. I connected using remote manager and created a user named 'rk'. When I send a test email, the email is not to be found. I notice the following error in the jdbc sql logs :-

-----> 2009-12-16 21:08:22.301 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com', 'rk@emptoris.com', 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'repository_name' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
        at net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
        at org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
        at org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
        at org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
        at org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
        at org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
        at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
        at java.lang.Thread.run(Thread.java:619)

I thought that the table 'inbox' would be used to store messages for all users. The table does get created ( Please see attached the sql log file. I am using log4jdbc to log the sqls ). However a table 'inboxrk' also gets created and this is the one that seems to be used for the user 'rk'.

The apps/james/SAR-INF/config.xml file :-


Attached is the sql logs:-



Looks like I am missing something in the configuration. Can someone help me with this ?

Thanks,
Radhakrishnan

RE: [Using a JDBC Repository] Error trying to insert a message into inbox table.

Posted by "Jankiraman, Radhakrishnan" <rj...@emptoris.com>.

I got it working. Herez the change in configuration that got things working :-

      <!-- Alternative inbox repository definition for DB use. -->
      <!-- The format for the destinationURL is "db://<data-source>/<table>" -->
      <!-- <data-source> is the datasource name set up in the database-connections block, below -->
      <!-- <table> is the name of the table to store user inboxes in -->
      <!-- The user name is used as <repositoryName> for this repository config. -->

      <inboxRepository>
         <repository destinationURL="db://maildb/inbox/inbox" type="MAIL"/>
      </inboxRepository>

I had to add the last 'inbox' in the URL. IMO, the comment is incorrect. It seems to suggest that the repository name does not have to be specified and will be set to the user name whose email is being processed. However this is not the case. If the last 'inbox' is not specified, a separate inbox<user-name> table gets created and the repository name is not defined which leads to constraint violation in the db. With this configuration, there is ONLY one inbox table and repository name is set to 'inbox<user-name>'.

Thanks,
Radhakrishnan

-----Original Message-----
From: Jankiraman, Radhakrishnan [mailto:rjankiraman@emptoris.com]
Sent: Wednesday, December 16, 2009 9:46 PM
To: James Users List
Subject: RE: [Using a JDBC Repository] Error trying to insert a message into inbox table.

For some reason, the log file that I attached didn't get through. Please find the sql logs below :-

-----> 2009-12-16 21:07:19.020 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
3. CREATE TABLE users (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20),
useForwarding SMALLINT, forwardDestination VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255),
PRIMARY KEY(username))

-----> 2009-12-16 21:07:19.208 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
4. CREATE TABLE spool ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:19.426 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
5. CREATE TABLE inbox ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:19.676 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
6. CREATE TABLE deadletter ( message_name varchar (200) NOT NULL, repository_name varchar (100)
NOT NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:20.161 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
11. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:07:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
12. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:07:52.286 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
13. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:07:52.317 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
14. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:07:52.333 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
15. INSERT INTO users (username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias,
alias) VALUES ('rk','YmWkoHlop8HfFqYQBPtxkRd8','SHA',0,<null>,0,<null>)

-----> 2009-12-16 21:08:20.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
16. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:20.770 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
17. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name =
'spool'

-----> 2009-12-16 21:08:20.817 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
17. INSERT INTO spool (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977900661-0',
'spool', 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:20.661, <Binary InputStream of length 29066>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:20.880 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
18. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:20.895 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
19. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:20.895 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
19. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:20.911 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
20. SELECT message_body FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
21. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:21.895 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
22. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:21.926 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
23. CREATE TABLE inboxrk ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:08:21.958 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
24. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name =
'spool'

-----> 2009-12-16 21:08:22.020 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
24. UPDATE spool SET message_state = 'transport', error_message = <null>, sender = 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>,
recipients = 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, remote_host = 'localhost', remote_addr = '127.0.0.1', last_updated
= 2009-12-16 21:08:20.0 WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'


-----> 2009-12-16 21:08:22.036 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
24. UPDATE spool SET message_attributes = <Binary InputStream of length 103> WHERE message_name
= 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.067 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
25. SELECT message_name, message_state, last_updated FROM inboxrk WHERE repository_name = <null>
ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
26. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
27. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
27. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.208 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
28. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.223 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
29. SELECT message_body FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.239 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
30. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.239 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
31. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.270 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
32. SELECT count(*) FROM inboxrk WHERE message_name = 'Mail1260977902255-0' AND repository_name
= <null>

-----> 2009-12-16 21:08:22.286 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:22.301 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'repository_name' cannot be null
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
 at net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
 at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
 at org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
 at org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
 at org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
 at org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
 at org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
 at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
 at java.lang.Thread.run(Thread.java:619)
-----> 2009-12-16 21:08:22.317 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
33. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name =
'spool'

-----> 2009-12-16 21:08:22.317 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
33. INSERT INTO spool (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902301-1',
'spool', 'error', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.301, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:22.364 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
34. DELETE FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'


-----> 2009-12-16 21:08:22.380 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
35. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.380 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.395 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.395 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
37. SELECT count(*) FROM deadletter WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'error'

-----> 2009-12-16 21:08:22.411 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
38. SELECT length(message_body) FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.473 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
39. SELECT message_body FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.473 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
37. INSERT INTO deadletter (message_name, repository_name, message_state, error_message, sender,
recipients, remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES
('Mail1260977902301-1', 'error', 'error', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>,
'localhost', '127.0.0.1', 2009-12-16 21:08:22.0, <Binary InputStream of length 29138>, <Binary
InputStream of length 82>)

-----> 2009-12-16 21:08:22.520 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
40. DELETE FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name = 'spool'


-----> 2009-12-16 21:08:23.098 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
41. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:23.098 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
42. SELECT message_name, message_state, last_updated FROM inboxrk WHERE repository_name = <null>
ORDER BY last_updated ASC

-----> 2009-12-16 21:09:20.208 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
43. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:09:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
44. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:09:22.426 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
45. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:20.208 <Spool Thread #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
46. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
47. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:22.426 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
48. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:20.208 <Spool Thread #7>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
49. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
50. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
51. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:20.208 <Spool Thread #2>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
52. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
53. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
54. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
55. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
56. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
57. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
58. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
59. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
60. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
61. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
62. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
63. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
64. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
65. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
66. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
67. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
68. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
69. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
70. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
71. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
72. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
73. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
74. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
75. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
76. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
77. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
78. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
79. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
80. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
81. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
82. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
83. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
84. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
85. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
86. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
87. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
88. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
89. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
90. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:20.223 <Spool Thread #5>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
91. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
92. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
93. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
94. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
95. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
96. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
97. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
98. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
99. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
100. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
101. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
102. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
103. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
104. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
105. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
106. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
107. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
108. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
109. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
110. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
111. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
112. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
113. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
114. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
115. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
116. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
117. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
118. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
119. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
120. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
121. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
122. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
123. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
124. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
125. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
126. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
127. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
128. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
129. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
130. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
131. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
132. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
133. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
134. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
135. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:20.223 <Spool Thread #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
136. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
137. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
138. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
139. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
140. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
141. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
142. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
143. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
144. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
145. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
146. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
147. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

________________________________
From: Jankiraman, Radhakrishnan [mailto:rjankiraman@emptoris.com]
Sent: Wednesday, December 16, 2009 9:34 PM
To: server-user@james.apache.org
Subject: [Using a JDBC Repository] Error trying to insert a message into inbox table.

Hi,

I am just getting started with JAMES. I am trying to use version 2.3.2 configured to use mysql db. I connected using remote manager and created a user named 'rk'. When I send a test email, the email is not to be found. I notice the following error in the jdbc sql logs :-

-----> 2009-12-16 21:08:22.301 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com', 'rk@emptoris.com', 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'repository_name' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
        at net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
        at org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
        at org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
        at org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
        at org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
        at org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
        at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
        at java.lang.Thread.run(Thread.java:619)

I thought that the table 'inbox' would be used to store messages for all users. The table does get created ( Please see attached the sql log file. I am using log4jdbc to log the sqls ). However a table 'inboxrk' also gets created and this is the one that seems to be used for the user 'rk'.

The apps/james/SAR-INF/config.xml file :-

Attached is the sql logs:-


Looks like I am missing something in the configuration. Can someone help me with this ?

Thanks,
Radhakrishnan


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

RE: [Using a JDBC Repository] Error trying to insert a message into inbox table.

Posted by "Jankiraman, Radhakrishnan" <rj...@emptoris.com>.

For some reason, the log file that I attached didn't get through. Please find the sql logs below :-

-----> 2009-12-16 21:07:19.020 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
3. CREATE TABLE users (username VARCHAR(64) NOT NULL, pwdHash VARCHAR(50), pwdAlgorithm VARCHAR(20),
useForwarding SMALLINT, forwardDestination VARCHAR(255), useAlias SMALLINT, alias VARCHAR(255),
PRIMARY KEY(username))

-----> 2009-12-16 21:07:19.208 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
4. CREATE TABLE spool ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:19.426 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
5. CREATE TABLE inbox ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:19.676 <main>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
6. CREATE TABLE deadletter ( message_name varchar (200) NOT NULL, repository_name varchar (100)
NOT NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:07:20.161 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
11. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:07:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
12. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:07:52.286 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
13. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:07:52.317 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
14. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:07:52.333 <default Worker #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
15. INSERT INTO users (username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias,
alias) VALUES ('rk','YmWkoHlop8HfFqYQBPtxkRd8','SHA',0,<null>,0,<null>)

-----> 2009-12-16 21:08:20.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
16. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:20.770 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
17. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name =
'spool'

-----> 2009-12-16 21:08:20.817 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
17. INSERT INTO spool (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977900661-0',
'spool', 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:20.661, <Binary InputStream of length 29066>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:20.880 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
18. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:20.895 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
19. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:20.895 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
19. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:20.911 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
20. SELECT message_body FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
21. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:21.895 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
22. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:21.926 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
23. CREATE TABLE inboxrk ( message_name varchar (200) NOT NULL, repository_name varchar (100) NOT
NULL, message_state varchar (30) NOT NULL , error_message varchar (200) NULL , sender varchar
(255) NULL , recipients text NOT NULL , remote_host varchar (255) NOT NULL , remote_addr varchar
(20) NOT NULL , message_body longblob NOT NULL , message_attributes longblob NULL , last_updated
datetime NOT NULL, PRIMARY KEY (repository_name, message_name) )

-----> 2009-12-16 21:08:21.958 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
24. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name =
'spool'

-----> 2009-12-16 21:08:22.020 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
24. UPDATE spool SET message_state = 'transport', error_message = <null>, sender = 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>,
recipients = 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, remote_host = 'localhost', remote_addr = '127.0.0.1', last_updated
= 2009-12-16 21:08:20.0 WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'


-----> 2009-12-16 21:08:22.036 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
24. UPDATE spool SET message_attributes = <Binary InputStream of length 103> WHERE message_name
= 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.067 <default Worker #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
25. SELECT message_name, message_state, last_updated FROM inboxrk WHERE repository_name = <null>
ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
26. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
27. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.192 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
27. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.208 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
28. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.223 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
29. SELECT message_body FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.239 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
30. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.239 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
31. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:22.270 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
32. SELECT count(*) FROM inboxrk WHERE message_name = 'Mail1260977902255-0' AND repository_name
= <null>

-----> 2009-12-16 21:08:22.286 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:22.301 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'repository_name' cannot be null
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
 at net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
 at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
 at org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
 at org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
 at org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
 at org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
 at org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
 at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
 at java.lang.Thread.run(Thread.java:619)
-----> 2009-12-16 21:08:22.317 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
33. SELECT count(*) FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name =
'spool'

-----> 2009-12-16 21:08:22.317 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
33. INSERT INTO spool (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902301-1',
'spool', 'error', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>, 'localhost', '127.0.0.1',
2009-12-16 21:08:22.301, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

-----> 2009-12-16 21:08:22.364 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
34. DELETE FROM spool WHERE message_name = 'Mail1260977900661-0' AND repository_name = 'spool'


-----> 2009-12-16 21:08:22.380 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
35. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:08:22.380 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36. SELECT message_state, error_message, sender, recipients, remote_host, remote_addr, last_updated
FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name = 'spool'

-----> 2009-12-16 21:08:22.395 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
36. SELECT message_attributes FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.395 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
37. SELECT count(*) FROM deadletter WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'error'

-----> 2009-12-16 21:08:22.411 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
38. SELECT length(message_body) FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.473 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
39. SELECT message_body FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name
= 'spool'

-----> 2009-12-16 21:08:22.473 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
37. INSERT INTO deadletter (message_name, repository_name, message_state, error_message, sender,
recipients, remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES
('Mail1260977902301-1', 'error', 'error', <null>, 'rjankiraman@emptoris.com'<mailto:'rjankiraman@emptoris.com'>, 'rk@emptoris.com'<mailto:'rk@emptoris.com'>,
'localhost', '127.0.0.1', 2009-12-16 21:08:22.0, <Binary InputStream of length 29138>, <Binary
InputStream of length 82>)

-----> 2009-12-16 21:08:22.520 <Spool Thread #6>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
40. DELETE FROM spool WHERE message_name = 'Mail1260977902301-1' AND repository_name = 'spool'


-----> 2009-12-16 21:08:23.098 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
41. SELECT username, pwdHash, pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias
FROM users WHERE username = 'rk'

-----> 2009-12-16 21:08:23.098 <default Worker #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
42. SELECT message_name, message_state, last_updated FROM inboxrk WHERE repository_name = <null>
ORDER BY last_updated ASC

-----> 2009-12-16 21:09:20.208 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
43. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:09:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
44. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:09:22.426 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
45. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:20.208 <Spool Thread #9>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
46. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
47. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:10:22.426 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
48. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:20.208 <Spool Thread #7>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
49. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
50. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:11:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
51. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:20.208 <Spool Thread #2>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
52. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
53. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:12:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
54. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
55. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
56. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:13:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
57. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
58. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
59. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:14:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
60. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
61. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
62. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:15:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
63. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:20.208 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
64. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
65. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:16:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
66. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
67. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
68. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:17:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
69. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
70. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
71. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:18:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
72. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
73. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
74. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:19:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
75. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
76. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
77. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:20:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
78. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
79. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
80. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:21:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
81. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
82. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
83. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:22:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
84. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
85. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
86. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:23:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
87. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
88. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
89. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:24:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
90. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:20.223 <Spool Thread #5>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
91. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
92. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:25:22.442 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
93. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
94. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
95. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:26:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
96. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
97. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
98. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:27:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
99. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:20.223 <Spool Thread #1>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
100. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
101. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:28:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
102. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
103. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
104. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:29:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
105. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
106. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
107. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:30:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
108. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
109. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
110. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:31:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
111. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
112. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
113. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:32:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
114. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
115. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
116. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:33:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
117. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
118. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
119. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:34:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
120. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:20.223 <Spool Thread #8>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
121. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
122. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:35:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
123. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
124. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
125. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:36:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
126. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
127. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
128. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:37:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
129. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
130. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
131. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:38:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
132. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
133. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
134. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:39:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
135. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:20.223 <Spool Thread #4>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
136. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
137. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:40:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
138. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
139. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
140. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:41:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
141. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
142. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
143. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:42:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
144. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:20.223 <Spool Thread #3>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
145. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:20.942 <Remote delivery thread (0)>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
146. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'outgoing' ORDER BY last_updated ASC

-----> 2009-12-16 21:43:22.520 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
147. SELECT message_name, message_state, last_updated, error_message FROM spool WHERE repository_name
= 'spool' ORDER BY last_updated ASC

________________________________
From: Jankiraman, Radhakrishnan [mailto:rjankiraman@emptoris.com]
Sent: Wednesday, December 16, 2009 9:34 PM
To: server-user@james.apache.org
Subject: [Using a JDBC Repository] Error trying to insert a message into inbox table.

Hi,

I am just getting started with JAMES. I am trying to use version 2.3.2 configured to use mysql db. I connected using remote manager and created a user named 'rk'. When I send a test email, the email is not to be found. I notice the following error in the jdbc sql logs :-

-----> 2009-12-16 21:08:22.301 <Spool Thread #0>  org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
32. INSERT INTO inboxrk (message_name, repository_name, message_state, error_message, sender, recipients,
remote_host, remote_addr, last_updated, message_body, message_attributes) VALUES ('Mail1260977902255-0',
<null>, 'root', <null>, 'rjankiraman@emptoris.com', 'rk@emptoris.com', 'localhost', '127.0.0.1',
2009-12-16 21:08:22.255, <Binary InputStream of length 29138>, <Binary InputStream of length
82>)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'repository_name' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
        at net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
        at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
        at org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
        at org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
        at org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
        at org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
        at org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
        at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
        at java.lang.Thread.run(Thread.java:619)

I thought that the table 'inbox' would be used to store messages for all users. The table does get created ( Please see attached the sql log file. I am using log4jdbc to log the sqls ). However a table 'inboxrk' also gets created and this is the one that seems to be used for the user 'rk'.

The apps/james/SAR-INF/config.xml file :-

Attached is the sql logs:-


Looks like I am missing something in the configuration. Can someone help me with this ?

Thanks,
Radhakrishnan