• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

insert CLOB into MS SQL Server 2K

 
Dave Bosky
Ranch Hand
Posts: 72
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a large textarea field in a form field called details.

I get the textarea field value like so:
String details= request.getParameter("details");

But I need to convert the string datatype to CLOB datatype
so I can insert the data into a CLOB field.

Can I cast this somehow?

Thanks,
Dave
 
Natarajan Shankar
Ranch Hand
Posts: 53
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For CLOB/ BLOB data-type you need to open stream of the data-typoes and write the information through the stream. As I known, direct casting is not possible through API level.
 
Dave Bosky
Ranch Hand
Posts: 72
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you provide a simple example of creating the required stream?

Thanks,
Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic