LONG data type caters for instances of field lengths > 4000 with maximum capacity of 2GB of text. It strictly holds text value. Using varchar2 which is equivalent to varchar (MySQL) holds text up to 4000 characters in length which is inadequate. That's the reason of my using LONG.
Can anyone please help with this issue? Sam. >long is the wrong datatype ... I dont know what Oracle datatype it >should >be, but MySQL has one called LONGTEXT that I use. >d. > >-----Original Message----- >From: Samuel Sadek [mailto:[EMAIL PROTECTED]] >Sent: Saturday, February 23, 2002 1:05 AM >To: [EMAIL PROTECTED] >Subject: RE: How to make James work with Oracle database? > > >Danny, > >I've followed the suggested instructions below and these are the >output I've >got from my POP server: > > >what does the content of the message_body field contain? it >should >hold a > >complete mail message with all its headers. > >Initially I sqlplus'd into my oracle db and executed the following SQL >statements: > >SQL> select message_state from inbox; > >MESSAGE_STATE >------------------------------ >root >root >root >root >root >root > >6 rows selected. > >SQL> select message_body from inbox; > >MESSAGE_BODY >------------------------------------------------------------------ >-------------- >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 > >6 rows selected. > >Could you please explain to me what root in message_state means and if it >reflects successful mail delivery. > > > >Does the POP server serve the mail correctly? you could try >telnetting >to > >port 110, the commands are > >I've telnetted to my POP server and got the following response back: > >+OK secemail.dnsalias.com POP3 server (JAMES POP3 Server 2.0a2) ready > >which suggests to me that it's up and running. > > >USER [username] > >logged in as a recipient attempting to read the delivered mail >and got the >following response back: > >+OK > > >PASS [password] > >entered valid password for above user and got back: > >+OK Welcome monica > > >LIST > >+OK 6 24000 >1 4000 >2 4000 >3 4000 >4 4000 >5 4000 >6 4000 >. > > >RETR [number of a message from list] > >typed in RETR 3 to yield third message content and got back: > >+OK Message follows >333533323336333533373334333733353337333233363435333234343335333033 >36333133373334 >333633383333343133323330333334333337333333363331333634343337333533 >36333533363433 >333433303337333333363335333633333336333533363434333633313336333933 >36343333323435 >333633343336343533373333333633313336343333363339333633313337333333 >32343533363333 >333634363336343433333435333034343330343133353332333633353336333333 >36333533363339 >333733363336333533363334333334313332333033363336333733323336343633 >36343433323330 >333733323336333833363335333634353336333933373335333634343332343533 >36333233373334 >333633393336343533373334333633353337333233363435333633353337333433 >32343533363333 >333634363336343433323330333233383335343233333331333333393333333433 >32343533333337 >333333333332343533333337333333333332343533333339333333333335343433 >32333933303434 >333034313332333033323330333233303332333033323330333233303332333033 >32333033323330 >333233303336333233373339333233303337333333363335333633333336333533 >36343433363331 >333633393336343333323435333633343336343533373333333633313336343333 >36333933363331 >333733333332343533363333333634363336343433323330333233383334343133 >34333133343434 >333433353335333333323330333533333334343433353334333533303332333033 >35333333363335 >333733323337333633363335333733323332333033333332333234353333333033 >36333133333332 >333233393332333033373337333633393337333433363338333233303335333333 >34343433353334 >333533303332333033343339333433343332333033333332333333383333333433 >30343433303431 >333233303332333033323330333233303332333033323330333233303332333033 >32333033323330 >333633363336343633373332333233303333343333363434333634363336343533 >36333933363333 >333633313334333033373333333633353336333333363335333634343336333133 >36333933363433 >333234353336333433363435333733333336333133363433333633393336333133 >37333333323435 >333633333336343633363434333334353333343233303434333034313332333033 >32333033323330 >333233303332333033323330333233303332333033323330333233303335333333 >36333133373334 >333234333332333033333332333333333332333033343336333633353336333233 >32333033333332 >333333303333333033333332333233303333333033333330333334313333333033 >33333333333431 >333333353333333733323330333234323333333033333330333333303333333033 >30343433303431 >333533323336333533363333333633353336333933373336333633353336333433 >33343133323330 >333633363337333233363436333634343332333033363338333634363337333333 >37333433333332 >333333313333333733323434333333333333333933323434333333343333333033 >32343433333331 >333333323333333433323435333633393336343533323434333633313336333433 >36333433373332 >333234353336333233373334333634363337333033363335333634353337333733 >36343633373332 >333634333336333433323435333633333336343633363434333233303332333833 >35343233333332 >333333313333333733323435333333333333333933323435333333343333333033 >32343533333331 >333333323333333433353434333233303336333833363335333634333336343633 >33343433363436 >333733323336333133363435333633373336333533323339333034343330343133 >30333933363332 >333733393332333033373332333633383336333533363435333633393337333533 >36343433323435 >333633323337333433363339333634353337333433363335333733323336343533 >36333533373334 >333234353336333333363436333634343332333033373337333633393337333433 >36333833323330 >333633353337333333363434333733343337333033323330333233383334333533 >37333833363339 >333634343332333033333333333234353333333233333332333233303332333333 >33333833323339 >333034343330343133303339333633393336333433323330333333313333333633 >36333533353330 >333633353333333733323434333333303333333033333330333333353333333833 >37333033323434 >333333303333333033303434333034313330333933363336333634363337333233 >32333033363434 >333634363336343533363339333633333336333133343330333733333336333533 >36333333363335 >333634343336333133363339333634333332343533363334333634353337333333 >36333133363433 >333633393336333133373333333234353336333333363436333634343333343233 >32333033353333 >333633313337333433323433333233303333333233333333333233303334333633 >36333533363332 >333233303333333233333330333333303333333233323330333333303333333033 >33343133333330 >333333323333343133333333333333353332333033323432333333303333333033 >33333033333330 >. > > >QUIT > >and then quitted pop session from console. > > >d. > >Can you please tell me if any aspect of oracle config is incorrect, the >message's body is actually stored correctly in the db, and if so, >what could >be the cause of my pop3 client not able to receive the message header and >more importantly, the message body? > >One point I need to make is I'm able to query the message headers >from the >db correctly... > >Would appreciate your feedback. > >Thanks in advance, > >Sam. > > >-----Original Message----- > >From: Samuel Sadek [mailto:[EMAIL PROTECTED]] > >Sent: Friday, February 22, 2002 7:44 PM > >To: [EMAIL PROTECTED] > >Subject: RE: How to make James work with Oracle database? > > > > > >I'm experiencing some major problems with JAMES hooked with Oracle 8.1.7. > >The problem doesn't reside receiving, processing new mail and > >thus storing > >the resulting message in the inbox table in Oracle as I've ran a check on > >the size of the table via "select count(*) from inbox", but > >actually reading > >the new mail off from inbox table using a customised POP mail client > >software using JavaMail. I've used the same client to access > >other POP mail > >with no problems at all, but when I attempt to read from JAMES > >POP server it > >doesn't receive it!!! > > > >Please find below the create SQL clause I've used to create the > >inbox table > >in the first place: > > > ><sql name="createTable" db="oracle"> > > CREATE TABLE ${table} ( > > message_name varchar2 (200) NOT NULL, > > repository_name varchar2 (200) NOT NULL, > > message_state varchar2 (30) NOT NULL , > > error_message varchar2 (200) NULL , > > sender varchar2 (200) , > > recipients varchar2 (1000) NOT NULL , > > remote_host varchar2 (100) NOT NULL , > > remote_addr varchar2 (20) NOT NULL , > > message_body long NOT NULL , > > last_updated date NOT NULL , > > PRIMARY KEY (message_name, repository_name) > > ) > > TABLESPACE system > ></sql> > > > >I'm also aware of Sun's problem with ot reading data off from > >clob so I've > >used a long data type which is standard and should not be the > >cause of the > >problem (althought I'm hoping that's not the case!). > > > >This thread seems to be rather long-winded and pervasive but I would > >appreciate it your comments/feedback on the matter. > > > >Thanks. > > > >Sam. > > > > > > _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
