Hello all.

I am trying to setup James using HypersonicSQL as my db stores. I just downloaded 
james-2.1a1 in an attempt to start with the latest version (short of CVS).

I have 
- modified my SAR-INF/config.xml so that all (I hope) mailets and stores use the db 
option.
- I have added hypersonic connection parameters to the <database-connections> section.
- I have updated the sqlResources.xml
    added dbMatcher for Hypersonic
    added sql's for hypersonic

James now starts up without reporting any errors.
I can use the telnet client to add and list users.
I can send emails to James, from james, and within james.

Once, when I was sending an email to myself, I noted the following in the run window:

C:\james-2.1a1\bin>run
Using PHOENIX_HOME:   C:\james-2.1a1
Using PHOENIX_TMPDIR: C:\james-2.1a1\temp
Using JAVA_HOME:      c:\jdk1.3

Phoenix 4.0a4

James 2.1a1
Started POP3 Server plain:110
Started SMTP Server plain:25
Started NNTP Server plain:119
java.lang.RuntimeException: Did not find a record Mail1029306580132-2 in spool
        at org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:454)
        at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
        at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
        at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
java.lang.RuntimeException: Exception while retrieving mail: Did not find a reco
rd Mail1029306580132-2 in spool
        at org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailR
epository.java:494)
        at org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:205)
        at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
        at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)

However, I did receive the email. Is this a problem? In general, I want to test the 
setup. What tests would you suggest, and what logs should I look for?

Thanks!

Steve B.

PS - the JDBC How-To makes it sound like you have only to add info to the 
database-connections section. This may be a bit misleading as there are many places in 
the config.xml that need to be commented and uncommented. It may be worth listing them 
as when I eventually realized there were additional changes to be made, it took me a 
couple tries to find them all...just a suggestion.

Reply via email to