This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Memo field in SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Memo field in SQL" Watch "Memo field in SQL" New topic
Author

Memo field in SQL

prashant mokkarala
Greenhorn

Joined: Jul 23, 2001
Posts: 3
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
 
wood burning stoves
 
subject: Memo field in SQL
 
Similar Threads
Servlet-JDBC with Access databse
Problems in inserting data to MS Access Database
problem in inserting data into ms access
Servlet-JDBC with Access databse
memo field in SQL