A better idea might be to subit a patch for sqlResources and simply a paragraph or two of config docs pointing up any specific Hypersonic heads-up to add to http://jakarta.apache.org/james/usingJDBC_v2.0.html
Rather than clutter up an already confusing config file with another alternative scheme. d. > -----Original Message----- > From: Noel J. Bergman [mailto:[EMAIL PROTECTED]] > Sent: 14 August 2002 20:26 > To: James Users List > Subject: RE: (Followup) Is this an error? Trying to create a hypersonic > db store > > > Steve, > > Are you going to continue testing, and contribute a diff against > sqlResources.xml and james-config.xml so that it can be included > in the CVS? > > Please see: http://jakarta.apache.org/james/contribute.html > > --- Noel > > -----Original Message----- > From: Steve [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 14, 2002 14:58 > To: James Users List > Subject: Re: (Followup) Is this an error? Trying to create a hypersonic > db store > > > I just downloaded the CVS version and verified that the HypersonicSQL > "works" on this version. (No heavy testing done, just looped message > to myself) Please let me kow if you try this configuration including > what worked and what failed. > > I am also thankful that with this CVS version I now pass the tests on > http://www.abuse.net/relay.html! > > Steve B. > > ----- Original Message ----- > From: "Steve" <[EMAIL PROTECTED]> > To: "James Users List" <[EMAIL PROTECTED]> > Sent: Wednesday, August 14, 2002 9:41 AM > Subject: Re: Is this an error? Trying to create a hypersonic db store > > > > (I am running james-2.1a1 binary dist, jdk1.3, WindowsXP running > > james as a service) > > > > Kudos to the developers! The sqlResources and config.xml implementation > > mad things as simple as they could be. > > > > I hope it is ok to send attachments to this mail list. Here is the > > sqlResources.xml I created for 2.1a1. The following instructions will > > setup James to use HypersonicSQL in "stand-alone" mode. > > > > 1) replace the sqlResources.xml in the /conf directory with the one > > attached to this email. > > 2) Add the following to the <database-connections> nest. (Note that the > > url will need to be modified to an existing pathname for your > installation.): > > > > <data-source name="maildb" > > class="org.apache.james.util.mordred.JdbcDataSource"> > > <driver>org.hsql.jdbcDriver</driver> > > > <dburl>jdbc:HypersonicSQL:<path-to-james>/apps/james/var/james.db</dburl> > > <user>sa</user> > > <password /> > > <max>10</max> > > </data-source> > > > > 3) There are many areas in the config.xml which have values for the file > > repository, but also have commented-out equivalents for the database > > repository; comment-out the file xml, and uncomment out the db > xml. (Hint: > > do a text search for "file:". Careful, some of these are the path to the > > sqlResources.xml which should not be changed.) > > > > 4) Put the HypersonicSQL jar file (hsql.jar) into the <james-home>/lib > > folder. You can download it from SourceForge (although IMHO it would be > > nice to distribute with James). > > > > Start-up James and test it out. You will see that the first > time you run, > > the database files will automatically be created by HypersonicSQL in the > > directory you indicated in the <dburl>. Note that this is in stand-alone > > mode, so if you would like to interact with the db directly, > you will need > > to stop james to un-lock the data files. > > > > HypersonicSQL includes its own interface. chdir to the james/lib folder > > ant type: > > java -cp hsql.jar org.hsql.util.DatabaseManager > > > > I just set this up last night. I sent and received a couple test > > messages - in other words, this is not well tested. If you have any > problems > > related to this setup, let me know. If I can recreate the problem, I can > try > > to fix it. > > > > Steve B. > > > > PS - If I get a chance, I will try to download the latest CVS today and > > apply the changes there as well. > > > > ----- Original Message ----- > > From: "Noel J. Bergman" <[EMAIL PROTECTED]> > > To: "James Users List" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 14, 2002 1:41 AM > > Subject: RE: Is this an error? Trying to create a hypersonic db store > > > > > > > Steve, > > > > > > Please submit that information. A lot of users have asked about using > > > HypersonicSQL with James. > > > > > > Please update to the CVS version. We've made a number of changes > > > specifically in the area you were exercising. > > > > > > If I recall correctly, there is a race condition in the > spooler scheme. > > > A message is acquired from the spool by a worker thread. The worker > > > thread then asks if it can own the message. If another thread has the > > > message locked (in a map), then the worker can't have it, and it goes > > > back to the spool for another. However, if a thread actively working > > > on the message should happen finish, delete and unlock the message > between > > > the time when the new worker thread tentatively acquires the message > from > > > the spool to work on and when it sees if someone else has locked it, > then > > > you'll see that exception. > > > > > > We've recently done a lot of work in that part of the code, and have > > > significantly reduced the possibility of that exception. When it does > > > happen, it is harmless. It simply means that a message was in the > > > queue, was pulled from the queue, but was already in use by another > thread > > > that finished with it and deleted it because there is nothing left to > do. > > > > > > --- Noel > > > > > > -----Original Message----- > > > From: Steve [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, August 14, 2002 2:36 > > > To: James Users List > > > Subject: Is this an error? Trying to create a hypersonic db store > > > > > > > > > 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 record 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. > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
