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:[email protected]]
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>,
'[email protected]'<mailto:'[email protected]'>,
'[email protected]'<mailto:'[email protected]'>, '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 = '[email protected]'<mailto:'[email protected]'>,
recipients = '[email protected]'<mailto:'[email protected]'>, 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>,
'[email protected]'<mailto:'[email protected]'>,
'[email protected]'<mailto:'[email protected]'>, '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>,
'[email protected]'<mailto:'[email protected]'>,
'[email protected]'<mailto:'[email protected]'>, '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>,
'[email protected]'<mailto:'[email protected]'>,
'[email protected]'<mailto:'[email protected]'>, '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>,
'[email protected]'<mailto:'[email protected]'>,
'[email protected]'<mailto:'[email protected]'>,
'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:[email protected]]
Sent: Wednesday, December 16, 2009 9:34 PM
To: [email protected]
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>, '[email protected]', '[email protected]',
'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: [email protected]
For additional commands, e-mail: [email protected]
