my dog learned polymorphism
The moose likes BEA/Weblogic and the fly likes Data size error - urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Reply Bookmark "Data size error - urgent" Watch "Data size error - urgent" New topic
Author

Data size error - urgent

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I am using WL server 6.1 where I have deployed my contained managed entity beans. I use entity beans (EJB 1.1) to write data to my Oracle (8.1.7) tables. Some of the tables contain fields where rich text data is inserted and we are using LONG data type for these fields. As far as i know, maximum size for Oracle long data type fields are 2GB. But When my application tries to write data through entity beans, its failing after 4000 (approximatey) characters. The error message is :
---
<Exception in ejbStore: java.sql.SQLException: Data size bigger than max size for this type: 6072
java.sql.SQLException: Data size bigger than max size for this type: 6072
---
Any body can give me a clue why this is happening ? Anything to do with my configuration / CMP ?
Thanks in advance
SK
Michael Pearson
Ranch Hand

Joined: Mar 11, 2001
Posts: 351
Welcome to Java Ranch!
Please review this link for acceptable screen name information:
http://www.javaranch.com/name.jsp
Use this link to change your screen name:
http://www.coderanch.com/forums/user/edit
Your account may be locked out if you do not change your screen name to an acceptable format.
Michael Pearson
BEA Forum Moderator
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Data size error - urgent
 
Similar Threads
entity bean problem
difficulty in inserting value into oracle "long" datatype column
Inserting BLOB data
Data size bigger than the max size for this type;
java.sql.sqlexception data size bigger than max size for this type