Re: big text in string as object over the network: very strange?

2001-06-22 Thread Tobias Streckel
I think the specification has declareted this but orion support the BLOB under CMP. See the database schema oracle.xml: type-mapping type=java.io.Serializable name=blob / this entry is a default! -Ursprüngliche Nachricht- Von: Simon Evans [EMAIL PROTECTED] An: Orion-Interest [EMAIL

RE: big text in string as object over the network:

2001-06-22 Thread elephantwalker
AFAIK, the Oracle 1.2 jdbc driver has problems with clobs and blobs. They don't work. The oci drivers don't seem to have this issue, but that doesn't help you if you are using linux. You should try a simple servlet w/jdbc code Oracle database. Skip the ejb's in this step just to see if it is a

Re: big text in string as object over the network:

2001-06-21 Thread Tobias Streckel
It dosn't work with a StringBuffer object. I will get the same error message, I think it was a connection problem - but I don't know what to do? Anyone a idea? -Ursprüngliche Nachricht- Von: Jens Stutte [EMAIL PROTECTED] An: Orion-Interest [EMAIL PROTECTED] Datum: Donnerstag, 21. Juni

Re: big text in string as object over the network: very strange?

2001-06-21 Thread Tobias Streckel
Very strange Okay, now I want to create a entity bean which have as attribute a object(this object have a only StringBuffer() object). The create method of the entity will be access from a session bean(in the same apps). The client have access on the session bean. If the session bean call

RE: big text in string as object over the network:

2001-06-21 Thread Setlur, Atul (MED)
You need to select the row for update, then open a stream and write the string by opening an output stream. I am including a link to the Oracle documentation: http://oradoc.photo.net/ora81/DOC/java.815/a64685/oraext4.htm#1043272 Hope it helps. -Atul -Original Message- From: Tobias

RE: big text in string as object over the network:

2001-06-21 Thread Smith Jason
Is there some sort of connection time out stuff on the Oracle server? Is there something on the Oracle server that kills connections after X seconds? Can you save another binary object of the same size as your String to the BLOB field? There is an inactivity timeout variable in the Orion

RE: big text in string as object over the network: very strange?

2001-06-21 Thread Metla, Suri
Are there any Data types in Java to access the Long and CLOB columns of the Oracle Database? The first bottleneck comes with the JDBC driver to map the Database columns of these types (BLOBS, CLOBS). Regards, Suri -Original Message- From: Tobias Streckel [mailto:[EMAIL PROTECTED]]

RE: big text in string as object over the network:

2001-06-21 Thread Eduardo Estefano
We also had a similar problem and so far have not found any fix. I think the error is in the oracle driver but I'm not sure. Strings less than 4000 chars can be converted to binary and saved using a stmt.setBinaryStream() Strings over 4000 chars do not get saved. -Original Message-