Thank you for the info on conf/sqlResources.xml using PostgreSQL. It is very helpful.
I took a look at the configuration and could not figure out all the table names in the database used in JAMES. Is James create the tables automatically? Can we use different table names as I am afraid of the possible conflict if table names.
I would like to integrate it with our web application and put data in the same database as our application database so that I can directly retrieve messages, delete message and etc.
Anyone has detailed information about it.
Thanks,
Alice
----Original Message Follows----
From: simon <[EMAIL PROTECTED]>
Reply-To: "James Users List" <[EMAIL PROTECTED]>
To: James Users List <[EMAIL PROTECTED]>
Subject: Re: Anyone uses Interbase/firebird Database for James
Date: Sun, 24 Nov 2002 14:14:56 +1100
Alice,
No but -
I am using PostgreSQL 7.2.3 with james and have a simple trigger on the inbox table to count messages.
I added postgres bit to conf/sqlResources.xml because I needed to have the types as
message_body bytea NOT NULL ,
last_updated timestamp NOT NULL,
to get it to work.
Postgres supports triggers, view and stored procedures.
So with Firebirdsql you may need to use a blob for message body and
whatever function name is needed to get the length of message_body column..
As Noel has indicated - have a look at sqlResources.xml for queries that james uses.
Noel - I have attached my sqlResources.xml for postgresql.
Simon
Alice K wrote:
Just wonder anyone has configured James to use Borland Interbase (borland.com/interbase) or its Open-source version Firebird (firebirdsql.org) for James.<< sqlResources.xml >>
Both Commercial/Open-source Interbase/Firebird is available in all platforms with zero management with support all db features such as view, trigger, stored procedures.
Also, JDBC Type 4 driver is available. Comments, suggestions and helps are appreciated.
Alice
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
--
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]>
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
