Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How could I Write data into a field in Oracle whose data type is VARCHAR2

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
The sample data I want to write into Oracle is in http://tw.yahoo.com/info/utos.html.

Now, these data is stored in Mysql database and the field which stores these data uses "Text" as its data type.

I want to derive these data from mysql database and store them into a field of oracle database.

In oracle, I create field whose data type is varchar2(4000) to store these data.

I use JSP to derive data from mysql and insert into oracle through JDBC.

But the result of the page shows me that "javax.servlet.ServletException: Data size bigger than max size for this type: 25623".

Please anyone could help to resolve this problem?

Thank you very much.
[ September 11, 2004: Message edited by: Vince Chen ]
 
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Use datatype "LONG" in Oracle. It's limit is almost unlimited....
Cheers
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
I've try use LONG to store the data. But LONG only can appear once in a table. I have the need that field will more than one.Therefore, what can I do?
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
If the data type of field is CLOB, I can insert those data into Oracle through TOAD of QUEST SOFTWARE.But it can't be inserted through JDBC. Does anyone know why?
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Vince Chen. please do not cross-post the same question in multiple forums. Please continue any further discussion of this topic in the JDBC forum.
 
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic