using postgres jdbc driver in tomcat

[Joakim Verona <jo...@verona.se>]

hello,

im using the postgress jdbc driver in tomcat, with the poolman
connection pooling package.

it works well, but there is a strange limit on the lengths of texts
that are possible to insert, i can only insert about 8k long texts using
the setString function.

does anybody have any experience with this problem?
i tried the setCharacter steram functions, but they were unimplemented.

(i realise this is sligthly off topic)

-- 
Joakim Verona
joakim@verona.se
http://www.verona.se/

/servlet under NT

[Joe Laffey <jo...@laffeycomputer.com>]

By some miracle I got this working under Mac OSX (BSD style), but now I
need it under NT. I have some existing apps that require the serverts to
by accessed under
http://www.yourcompany.com/servlet/com.your.company.servlet

So I need to setup a "/servlet" context right? I want these servlets
(class files) to reside in
"C:\Program Files\Apache Group\Apache\htdocs\servlets"

I do not want anything in the TOMCAT_HOME tree. I also want JSP files to
work from any web directory (think this works).

So my question is, where do I put this? Do I use forward slashes or
backslashes?

On my OS X box I edited tomcat.properties to add a new zone called
"servlets". I defined a properties files "servlet.properties" that
specified a repository in the right directory. I then added "ApJServMount
/servlet /servlets" to my tomcat.conf (which is included in httpd.conf).
This worked fine.

Is there some new way to do this with Tomcat? The way I am trying is more
of a mod_JServ way.

Thanks!

Joe Laffey
LAFFEY Computer Imaging
St. Louis, MO
-------------------------
With no walls or fences on the Internet, who needs Windows or Gates?
---------------------------------------------------------------------

Re: using postgres jdbc driver in tomcat

[ro...@zzict.nl]

On Thu, 2 Nov 2000, Joakim Verona wrote:

> hello,
> 
> im using the postgress jdbc driver in tomcat, with the poolman
> connection pooling package.
> 
> it works well, but there is a strange limit on the lengths of texts
> that are possible to insert, i can only insert about 8k long texts using
> the setString function.

I don't know wether this is normal or not, but
with SQL you can expect a low of irregular behaviour.
fe, some SQL implementations don't allow all text in 
a VARCHAR (fi they don't like commas) so you have to PEM
encode them.
You can expect al sorts of other problems if you switch database.

> (i realise this is sligthly off topic)

it is.

Sloot.