James JDBC Progress V91B Blob's

MWillems

New Member
Hello Guru's out there

I'm trying to make it possible to connect the Apache (James) mailserver with the progress database for future usage as user and message reposetory. At this moment there are MySQL and MS-SQL scripts available for usage, but that's something i don't wanna hear ;-)

The Jdbc connection is no problem but the creation of the table is a problem to me, there are two datatype's which will be deployed by the mailserver that as far as I can see are cousing the problems (BLOB's and DateTime) and I can't get them in there, Help ;-((

Please take a look at this MySql script and tell me if it can be converted to progress format and how it should be done
CREATE TABLE Message (
message_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 (100) NOT NULL ,
recipients text NOT NULL ,
remote_host varchar (100) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
last_updated datetime NOT NULL
);



Please help me on this one TIA,

Marc Willems
 
Top