Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • 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 ]
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Duplicate post
 
Susanta Chatterjee
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used to do this and previously found help in OTN site maintained by Oracle for Oracle 9i. I searched it now and found Oracle 10g site hosting the same example. It is little different for 10g, but it should give you an idea. Look here.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65337
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have closed the dup in JSP. Vince, please don't do that. Thanks.
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault, I am sorry for that. Do you mean I continues this topic in the JDBC board?
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65337
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes Vince, please continue the discussion in this very topic. When a question is posted multiple times, people can end up wasting time when multiple redundant conversations take place.

Welcome to the Ranch,
bear
 
Vince Chen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks to Susanta Chatterjee. I use oracle 9i. I try the methods provided from the url you recommand. I change the JDBC driver form 9i to 10g and still use 9i as my database. I use those code shown in that url, and it can run correctly and solve my difficulty. Thank you again!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic