Thanks Markus,
Just what I need; it has all the rpm files for linux and a jdbc driver so I
can migrate off of MSSQL server. It supports long varchar so I will not have
to kludge code to make it work. I wonder if others on this list are aware of
the sap database?
TK
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Markus Gieppner
Sent: Monday, December 23, 2002 9:52 PM
To: [EMAIL PROTECTED]
Subject: Re: Text Area & Limit ed datbase fields.
Tom,
Take a look at SAP DB www.sapdb.org. It allows to create VARCHAR fields up
to 8000 bytes, and has many other goodies as well (transactions, views,
stored procedures etc.).
Actually, it's much closer to Oracle-type databases than MySQL, but it's
even free-er than MySQL.
Markus
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Tom
Kochanowicz
Sent: Monday, December 23, 2002 7:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Text Area & Limit ed datbase fields.
The data will be used to store information on pets (dogs, cats etc). The max
number of characters is to be 1000. Their will be as many as 10000 records
and searches will be performed using either a key field e.g. customer number
or using a %LIKE% sql command. So it is simply a store and retrival type of
operation. Perhaps I need to look at a database that supports varchar of
1000 characters rather then mySQL. We are running Linux so this will go
beyond our low budget. Thanks for the reponces.
TK
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Will
Hartung
Sent: Monday, December 23, 2002 11:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Text Area & Limit ed datbase fields.
> I am using a JSP/Servlet to capture data to be inserted into an
mySQL
> database. The database has a maximum limit on varchar of 255 charaters. I
> need to have double that amount. I could use MEDIUM_BLOB but that is way
too
> big. Is their a way to use one text area on my JSP and two varchar fields
to
> insert the data into. I heard of other databases with this restriction.
What
> is the most effective way to handle this problem?
How is the data going to be used? What kind of operations are going to be
performed on it? How many rows of data do you plan on storing?
All of these can affect the final solution that you choose.
Regards,
Will Hartung
([EMAIL PROTECTED])
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.431 / Virus Database: 242 - Release Date: 12/17/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.431 / Virus Database: 242 - Release Date: 12/17/2002
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
