Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

memo field in SQL

 
prashant mokkarala
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am facing problems with the Memo field of MS Access in my database that i used for my online shopping.
If I have even one memo field in my table, the SQL engine in the Netscape enterprise webserver (running on novell netware) would give "Invalid descriptor" error whenever i query the table thru my servlet program and thereby the query would fail.
Now, after learning that the memo field in the Access database creates problem, I decided to re-create the table itself, thru my servlet program by giving the following SQL "create table" statement:
st1.executeUpdate("create table Game( idGame integer not null, Rows integer not null, Cols integer not null, Boxes integer not null, Md5 char(32) not null, Layout memo not null, primary key (idGame), unique (Md5) )");
But when i run this servlet class file, the webserver says that it cannot understand the "memo" datatype.
This is really driving me crazy, cause SQL defines "memo" field!!
How in the world can i create a field that could take more than 255 chars without using a memo datatype??
Please help me out!!
Sincerely,
Prashant

 
Tim Holloway
Saloon Keeper
Pie
Posts: 18167
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try "varchar". If the core SQL spec includes a datatype of "memo", I missed it - not that I've read it lately .
 
Marcus Green
arch rival
Rancher
Posts: 2813
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are using the jdbc-odbc bridge from Sun you should be aware of the following. I believe that it does not support the MS Access memo type
The following is a quote from the page at
http://java.sun.com/products/jdk/1.2/docs/guide/jdbc/bridge.html
"The JDBC-ODBC Bridge should be considered a transitional solution. Javasoft and Intersolv are working to make the Bridge more reliable and robust, but they do not consider it a supported product."

Marcus
------------------
http://www.jchq.net Mock Exams, FAQ, Tutorial, Links, Book reviews
=================================================
Almost as good as JavaRanch
=================================================
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic