[REBOL] network timeout with mysql-protocol.r 0.8.5
From: ryan:christiansen:intellisol at: 26-Mar-2001 15:36
The MySQL scheme for /Core is pretty nice so far. But I frequently
encounter network timeouts, often when it has been less than 90 seconds
since the last activity. Do I need to 'open and 'close the database for
each entry? Is it common for a database connection to timeout so quickly?
(I'm new at using SQL of any kind, but REBOL is getting me there.) Here is
my script:
REBOL []
do %mysql-protocol.r
print "MySQL protocol loaded"
print newline
database: open mysql://username:[password--localhost]/test
print "Test database loaded"
print newline
forever [
print "Author:" author: input
print "Subject:" subject: input
print "Content:" content: input
insert database ["insert into messages values (?,?,?)" author subject
content]
print "Values inserted into table"
probe read join mysql://username:[password--localhost]/test? "select *
from messages"
]
Ryan C. Christiansen
Web Developer
Intellisol International
4733 Amber Valley Parkway
Fargo, ND 58104
701-235-3390 ext. 6671
FAX: 701-235-9940
http://www.intellisol.com
Global Leader in People Performance Software
_____________________________________
Confidentiality Notice
This message may contain privileged and confidential information. If you
think, for any reason, that this message may have been addressed to you in
error, you must not disseminate, copy or take any action in reliance on it,
and we would ask you to notify us immediately by return email to
[ryan--christiansen--intellisol--com]
