james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Serge Knystautas" <ser...@lokitech.com>
Subject Re: latest cvs compile but doesn't start up
Date Tue, 11 Sep 2001 18:03:19 GMT
It's supposed to have 2 primary keys.

You need to be able to store a message with the same message_name in the
same table as it could reside in multiple repositories.  For instance, if a
message gets delivered to 2 people with inboxes, they would have the same
message name and different repositories (inbox/user1 and inbox/user2)

Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Gabriel Bucher" <gabriel.bucher@razor.ch>
To: <james-dev@jakarta.apache.org>
Sent: Tuesday, September 11, 2001 1:53 PM
Subject: latest cvs compile but doesn't start up


> Hi together
>
> I check out the latest cvs and had a couple of problems to get it working.
>
> Here a couple of patches:
>
> Two primary keys are specified!
> ---------------------------------------
> --- sqlResources.xml.orig Tue Sep 11 04:29:30 2001
> +++ sqlResources.xml Tue Sep 11 17:19:35 2001
> @@ -117,7 +117,7 @@
>       <sql name="createTable" db="mysql">
>           CREATE TABLE ${table} (
>           message_name varchar (200) NOT NULL PRIMARY KEY,
> -        repository_name varchar (200) NOT NULL PRIMARY KEY,
> +        repository_name varchar (200) NOT NULL ,
>           message_state varchar (30) NOT NULL ,
>           error_message varchar (200) NULL ,
>           sender varchar (200) NULL ,
>
>
> moved mysql.jar from <james_app_home>/lib to <phoenix_home>/lib and
> added sqlResources.xml to the <phoenix_home>/conf!
> ---------------------------------------
> --- build.xml.orig Sat Aug 11 10:31:18 2001
> +++ build.xml Tue Sep 11 17:17:00 2001
> @@ -326,7 +326,7 @@
>           <include name="activation.jar"/>
>           <include name="mail_1_2.jar"/>
>           <include name="jakarta-oro-2.0.1.jar"/>
> -        <include name="mysql-2.0.4.jar"/>
> +<!--        <include name="mysql-2.0.4.jar"/> -->
>         </zipfileset>
>
>         <zipfileset dir="${build.conf}" fullpath="conf/config.xml">
> @@ -374,6 +374,7 @@
>           <include name="jmxtools.jar"/>
>           <include name="logkit.jar"/>
>           <include name="xerces.jar"/>
> +        <include name="mysql-2.0.4.jar"/>
>         </fileset>
>       </copy>
>
> @@ -390,6 +391,7 @@
>           <include name="inet*"/>
>           <include name="maildatabase*"/>
>           <include name="*.properties"/>
> +        <include name="sqlResources.xml"/>
>         </fileset>
>       </copy>
>
>
> And the last is, change the attribute name from 'type' to 'class' in the
> section <database-connections>/<data-sources>/<data-source>:
>    <data-source name="maildb"
>       class="org.apache.avalon.excalibur.datasource.JdbcDataSource">
>
>
> Buchi
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org
>
>


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


Mime
View raw message