Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to register a Clob in the dataBase

 
Glen D'cruz
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai Everyone,
I want to register a Clob in the database, can any give me an example as to how to go about this.
What I mean is just as we create a table in the database, how do you create a clob.
I frequently get an error message stating "File not found"
Thanks to all
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Glen,
You can add a clob to a column of a table. I don't know of anyway of just adding a clob.
 
Glen D'cruz
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai Jeanne,
Thanks for your reply. Can you give me an example. The table only accepts int, float, string, but not Clobs. I tried it , but it did not work.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Glen,
When you create the table, you need to create a column with a clob type. This is a bit database specific. What database are you using?
 
Glen D'cruz
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai Jeanne,
I am using SQLServer, and haven't still figured out a way of doing it.
I will place the whole program for your crutinity on the web this weekend so go through it and modify it if required.
Once again thanks for your time and effort.
[ July 08, 2004: Message edited by: Glen D'cruz ]
 
Glen D'cruz
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jeanne,
I have fixed the problem. I used a varchar as the dataType instead of text. The database has accepted it and saved it. I have now to design
a program to retreive the clob.
Thanks once again.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic