Oracle makes not guarantees about the
order of rows in a table – if you want a particular order you must enforce it
by sorting or using an extra column that you can sort on.
Conor
-----Original Message-----
From: yuanxinyu
[mailto:[EMAIL PROTECTED]]
Sent: 20 December 2002 10:21
To: [EMAIL PROTECTED]
Subject: [castor-dev] Question
about saving strings to Oracle as clob
Say I want save five strings to Oracle
database ,and there are five clob fields in the table. When I
store these strings, I found that their order is incorrect in the
database. And if some string is larger than 4KB, I get a error message
"java.sql.SQLException: Io Exception: Connection reset by peer".
--This e-mail is confidential and is intended for the named recipient only. If
you receive it in error please destroy the message and all copies. Kainos
Software Ltd. does not accept liability for damage sustained as a result of
malicious software (e.g. viruses). Kainos does not accept liability for, or
permit, the creation of contracts on its behalf by e-mail, the publication of
any defamatory statement by its employees by e-mail, or changes subsequently
made to the original message. The Company's registered office is located at
4-6 Upper Crescent, Belfast, BT7 1NT, Northern Ireland, Tel +44 28 9057 1100.
|
