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
