Tomcat4 to 5 migration

[Kevin Passey]

Hi I am migrating my apps from a server running Tomcat4 on a RHEL3 to a 
Tomcat5 installation of a FC4 box.


The apps work on the TC4 box but I am getting the following on the TC 5 box 
when I try and run anything.


Can someone point me to any migration docs.

I have the jt400.jar installed at /var/lib/tomcat5/common/lib as per the 
docs. "and $CATALINA_HOME/common/lib directories, are made visible through 
this class loader. By default, that includes the following:

 a.. ant.jar - Apache Ant.
 b.. commons-collection.jar - Jakarta commons collection.
 c.. commons-dbcp.jar - Jakarta commons DBCP, providing a JDBC connection 
pool to web applications.
 d.. commons-el.jar - Jakarta commons el, implementing the expression 
language used by Jasper.

 e.. commons-pool.jar - Jakarta commons pool.
 f.. jasper-compiler.jar - The JSP 2.0 compiler.
 g.. jasper-runtime.jar - The JSP 2.0 runtime.
 h.. jsp-api.jar - The JSP 2.0 API.
 i.. naming-common.jar - The JNDI implementation used by Tomcat 5 to 
represent in-memory naming contexts.
 j.. naming-factory.jar - The JNDI implementation used by Tomcat 5 to 
resolve references to enterprise resources (EJB, connection pools).
 k.. naming-resources.jar - The specialized JNDI naming context 
implementation used to represent the static resources of a web application.

 l.. servlet-api.jar - The Servlet and JSP API classes.
 m.. xerces.jar - The XML parser that is visible by default to Tomcat 
internal classes and to web applications. "

Or did I get it wrong.

Thanks

Kevin

org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,
 boolean) (Unknown Source) 
org.apache.jasper.servlet.JspServlet.serviceJspFile(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse, java.lang.String,java.lang.Throwable, 
boolean) (Unknown Source) 
org.apache.jasper.servlet.JspServlet.service(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse) (Unknown Source) 
javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest,javax.servlet.ServletResponse)
 (Unknown Source) 
org.apache.catalina.valves.ErrorReportValve.invoke(org.apache.catalina.Request, 
org.apache.catalina.Response, org.apache.catalina.ValveContext)(Unknown Source) 
org.apache.coyote.tomcat5.CoyoteAdapter.service(org.apache.coyote.Request,org.apache.coyote.Response)
 (Unknown Source)root causejava.lang.NullPointerException 
com.ibm.as400.access.SystemProperties.getProperty(java.lang.St
ring)(Unknown Source) 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(com.ibm.as400.access.JDDataSourceURL,
 com.ibm.as400.access.JDProperties,java.util.Properties) (Unknown Source) 
com.ibm.as400.access.AS400JDBCDriver.connect(java.lang.String,java.util.Properties)
 (Unknown Source) 
org.apache.commons.dbcp.DriverConnectionFactory.createConnection() 
(UnknownSource) org.apache.commons.dbcp.PoolableConnectionFactory.makeObject() 
(UnknownSource) 
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(org.apache.commons.dbcp.PoolableConnectionFactory)
 (Unknown Source) org.apache.commons.dbcp.BasicDataSource.createDataSource() 
(Unknown Source) org.apache.commons.dbcp.BasicDataSource.getConnection() 
(Unknown Source) org.apache.taglibs.dbtags.connection.ConnectionTag.doEndTag() 
(UnknownSource) 
org.apache.jsp.warehouseInquiry_jsp._jspService(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse) (Unknown Source) 
org.apache.jasper.runtime.Http
JspBase.service(javax.servlet.http.HttpServletRequest, 
javax.servlet.http.HttpServletResponse) (Unknown Source) 
javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest,javax.servlet.ServletResponse)
 (Unknown Source) 
org.apache.jasper.servlet.JspServletWrapper.service(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse, boolean) (UnknownSource) 
org.apache.jasper.servlet.JspServlet.serviceJspFile(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse, java.lang.String,java.lang.Throwable, 
boolean) (Unknown Source) 
org.apache.jasper.servlet.JspServlet.service(javax.servlet.http.HttpServletRequest,
 javax.servlet.http.HttpServletResponse) (Unknown Source) 
javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest,javax.servlet.ServletResponse)
 (Unknown Source)


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Upgrade to 4.1.30 and IBMJava2-141 causes this error

[Kevin Passey]

Hi,

can anybody help me

<%@ page import="org.adultcf.*" %>


This was working before I upgraded to enterprise Linux and Tomcat 4.1.30 and
IBMJava2-141

Now I get this - any ideas.

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 22 in the jsp file: /login.jsp

Generated servlet error:
[javac] Compiling 1 source file

/home/tomcat/jakarta-tomcat-4.1.30/work/Standalone/localhost/adultcf/login_j
sp.java:7: '.' expected
import LogInBean;
^
/home/tomcat/jakarta-tomcat-4.1.30/work/Standalone/localhost/adultcf/login_j
sp.java:60: cannot resolve symbol
symbol  : class LogInBean
location: class org.apache.jsp.login_jsp
  LogInBean LogInBean = null;
  ^

Thanks in advance.

Kevin


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Cannot load JDBC driver class 'null' and org.apache.jasper.Ja sperException: Exception retrieving attribute 'driverClassName'

[Kevin Passey]

No the xml file should be called myapp.xml in webapps along with your war
file

Did you note my other comment about myDS and fsaDS that looks like it's more
your problem.

Leave it how you had it and just change that - stop and start tomcat and see
if that flies.

Regards

Kevin

-Original Message-
From: Wynkoop, Robert M [mailto:[EMAIL PROTECTED]
Sent: 11 September 2003 14:54
To: 'Tomcat Users List'
Subject: RE: Cannot load JDBC driver class 'null' and
org.apache.jasper.Ja sperException: Exception retrieving attribute
'driverClassName'


I thought about this and then went into the 
Tomcat admin. Under service/localhost/context When 
I click Datasource(under my apps context) I get the error:

org.apache.jasper.JasperException: Exception retrieving attribute
'driverClassName'
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
54)

in my browser window.

My app is at p:.../somename/web/WEB-INF/.  
So are you telling me I need to create a file 
called web.xml.  Can't do that.  
I already have my real web.xml there.  
Where can I find more information on this config file in the tomcat docs?


Later,


Robert Wynkoop
-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 8:26 AM
To: 'Tomcat Users List'
Subject: RE: Cannot load JDBC driver class 'null'


Rather than changing your server XML create an xml file in your webapps
directory with the same name as your app directory.

Here is an example:- 

- 
   
   
- 
- 
  factory 
  org.apache.commons.dbcp.BasicDataSourceFactory 
  
- 
  maxActive 
  100 
  
- 
  maxIdle 
  5 
  
- 
  maxWait 
  100 
  
- 
  username 
  INTERNET 
  
- 
  password 
  ** 
  
- 
  driverClassName 
  com.ibm.as400.access.AS400JDBCDriver 
  
- 
  url 
  jdbc:as400://REX 
  
  
  

Stop and re-start Tomcat and hey presto!! OK I mine is for DB2 on an iSeries
- by hey it works !!

Anyway shouldn't your Web XML file have myDS not fsaDS.

Good luck 

Kevin


-Original Message-
From: Ben Anderson [mailto:[EMAIL PROTECTED]
Sent: 11 September 2003 13:17
To: [EMAIL PROTECTED]
Subject: Cannot load JDBC driver class 'null'


Ok, I know this topic has been posted many times, but I can't find anything 
to help.

I have OracleDriver in [$CATALINA_HOME]/common/lib
here's my server.xml

..


  
validationQuery
select user from dual;
  
  
url
jdbc:oracle:thin:myMachine:1521:myDBName
  
  
username
hris
  
  
password

  
  
maxActive
4
  
  
maxWait
5000
  
  
driverClassName
oracle.jdbc.driver.OracleDriver
  
  
maxIdle
2
  

  

and my web.xml:


jdbc/fsaDS
javax.sql.DataSource
Container
Shareable


in the administrative tool:
the top level Resources->DataSources looks ok as MyDS is listed there
but the /my_context->Resources->Datasources gives:
org.apache.jasper.JasperException: Exception retrieving attribute 
'driverClassName'

and the localhost_log.xxx.txt (when it tries to use myDS):
java.sql.SQLException: Cannot load JDBC driver class 'null

Any help would be great - I've been trying everything - reloading with 
different configurations about 50 times - looking through books, mailing 
lists/archives.
Thanks,
Ben

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Cannot load JDBC driver class 'null'

[Kevin Passey]

Rather than changing your server XML create an xml file in your webapps
directory with the same name as your app directory.

Here is an example:- 

- 
   
   
- 
- 
  factory 
  org.apache.commons.dbcp.BasicDataSourceFactory 
  
- 
  maxActive 
  100 
  
- 
  maxIdle 
  5 
  
- 
  maxWait 
  100 
  
- 
  username 
  INTERNET 
  
- 
  password 
  ** 
  
- 
  driverClassName 
  com.ibm.as400.access.AS400JDBCDriver 
  
- 
  url 
  jdbc:as400://REX 
  
  
  

Stop and re-start Tomcat and hey presto!! OK I mine is for DB2 on an iSeries
- by hey it works !!

Anyway shouldn't your Web XML file have myDS not fsaDS.

Good luck 

Kevin


-Original Message-
From: Ben Anderson [mailto:[EMAIL PROTECTED]
Sent: 11 September 2003 13:17
To: [EMAIL PROTECTED]
Subject: Cannot load JDBC driver class 'null'


Ok, I know this topic has been posted many times, but I can't find anything 
to help.

I have OracleDriver in [$CATALINA_HOME]/common/lib
here's my server.xml

..


  
validationQuery
select user from dual;
  
  
url
jdbc:oracle:thin:myMachine:1521:myDBName
  
  
username
hris
  
  
password

  
  
maxActive
4
  
  
maxWait
5000
  
  
driverClassName
oracle.jdbc.driver.OracleDriver
  
  
maxIdle
2
  

  

and my web.xml:


jdbc/fsaDS
javax.sql.DataSource
Container
Shareable


in the administrative tool:
the top level Resources->DataSources looks ok as MyDS is listed there
but the /my_context->Resources->Datasources gives:
org.apache.jasper.JasperException: Exception retrieving attribute 
'driverClassName'

and the localhost_log.xxx.txt (when it tries to use myDS):
java.sql.SQLException: Cannot load JDBC driver class 'null

Any help would be great - I've been trying everything - reloading with 
different configurations about 50 times - looking through books, mailing 
lists/archives.
Thanks,
Ben

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Which is the best way to install an application with connection p ooling

[Kevin Passey]

John,

I can easily deploy a basic app using the manager. But when it comes to
deploying something that needs additional "Context" information I come
un-stuck.

I basically have an app that I want to connect to an AS/400 database using
connection pooling.

The only way I can get it to work is to manually insert the entries in the
server XML file and then re-start.

Any other pointer greatly appreciated.

Regards

Kevin


-Original Message-
From: John Turner [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 13:45
To: Tomcat Users List
Subject: Re: Which is the best way to install an application with
connection p ooling



There are a number of ways.

If autoDeploy = "true" then you can just drop the WAR file in the Host's 
appBase directory.

You can also use the manager app's various tasks (install, deploy, etc):

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/manager-howto.html

This is easily accomplished with ant.

John

Kevin Passey wrote:

> I have normally stopped the server - edited the server XML file, put my
war
> file in the webapps folder and re-started tomcat.
> 
> Using the manager app - is there a way I can do this 1)from a remote
system
> and 2)without manually editing the server XML file.
> 
> I've have tried putting the jndi info using the admin console but I keep
> getting NULL driver exceptions.
> 
> Thanks
> 
> Kevin
> 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Which is the best way to install an application with connection pooling

[Kevin Passey]

I have normally stopped the server - edited the server XML file, put my war
file in the webapps folder and re-started tomcat.

Using the manager app - is there a way I can do this 1)from a remote system
and 2)without manually editing the server XML file.

I've have tried putting the jndi info using the admin console but I keep
getting NULL driver exceptions.

Thanks

Kevin

admin question ??

[Kevin Passey]

Has anybody set up a datasource in the admin console and got it to work?

If so can you enlighten me.

Regards

Kevin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

How To define+use a datasource for mysql in the admin console

[Kevin Passey]

Hi all,
 
Can somebody point me in the right direction.
 
I have normally set up a data source in the server XML file as a part of my
project's context entry.
 
With some entries in the projects Web XML file.
 
What I want to do is define this as a data source in the admin console.
 
Has anybody done this for MySQL - I would like to see some examples.
 
Thanks in advance.

Kevin

JDBC - driver and connection pooling question.

[Kevin Passey]

I have just loaded 4.1.24 and want to do as much as I can thru the admin and
manager functions without hand crafting the server.xml file.

Now this may not be possible but here goes:-

Previously I put the connection pooling entries in the server.xml file like
this:-





factory
org.apache.commons.dbcp.BasicDataSourceFactory


maxActive
100


maxIdle
5


maxWait
100


username
myuserid


password
**


driverClassName
org.gjt.mm.mysql.Driver


url
jdbc:mysql://localhost:3306/rbh




And the following in my app web XML


DB Connection
jdbc/adultcfDB
javax.sql.DataSource
Container


Now I've added the data source via the admin console - I get the following
error:-

org.apache.jasper.JasperException: java.sql.SQLException: Cannot load JDBC
driver class 'null'

What am I missing?

Thanks in advance.


Kevin Passey 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: (How to) Tomcat as a Linux service

[Kevin Passey]

Hi,

Is this good for RH Linux 7.2

Thanks

Kevin

-Original Message-
From: Jeremy Whitlock [mailto:[EMAIL PROTECTED]
Sent: 18 July 2003 23:43
To: 'Tomcat Users List'
Subject: RE: (How to) Tomcat as a Linux service


Euclides,
Save the attached file in "/etc/init.d/" and update the paths to
suit your needs.  Once that's done, you can use it like any other
service.  Later, Jeremy



-Original Message-
From: Jose Euclides da Silva Junior - DATAPREVRJ
[mailto:[EMAIL PROTECTED] 
Sent: Friday, July 18, 2003 4:45 PM
To: '[EMAIL PROTECTED]'
Subject: (How to) Tomcat as a Linux service

Hi everybody,
where can i find tips about how  to make TomCat be a Linux's service?
Regards,
Euclides.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: installing a servlet

[Kevin Passey]

I would agree with John - I am no expert by any stretch of the imagination -
I installed the latest java, apache and Tomcat and got it working in a
morning.

Read more is the answer. If you ask nicely there are many people in this
list who can point you at the relevant documentation.

I for one am grateful to many people in this list.

Good luck - don't go backwards, go forwards...

Kevin

-Original Message-
From: John Turner [mailto:[EMAIL PROTECTED]
Sent: 24 June 2003 13:42
To: Tomcat Users List
Subject: Re: installing a servlet



Donwgrading and using mod_webapp is the WORST thing you could do, for all 
sorts of reasons.  Security, for one.  Performance, for another.  Future 
extensibility and growth, for another.

Mod_jk and mod_jk2 work.  This is a fact.  There's nothing anyone can do if 
you want to give up learning how they work and use something else instead, 
but the truth is they work, and not just on someone's desktop.  Many, many 
people are using Tomcat and a connector under heavy load in production on a 
daily basis (I'm one of them and there are many more).  Load balancing, 
multiple instances, all sorts of advanced configurations.  If you want to 
take the time to learn how things work, and why they work that way (Tomcat 
MUST obey the servlet spec, there is no alternative), then you can get your 
answers and have a robust, stable system.  Its a personal choice.  Good 
luck.

John

On 24 Jun 2003 07:56:47 +0200, Tony Grant <[EMAIL PROTECTED]> wrote:

>> From my work of yesterday it seems that the easiest way to get a servlet
> to run is to downgrade to Tomcat 4.0.x and use mod_webapp...
>
> This isn't a very encouraging experience.
>
> Cheers
> Tony Grant



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Configuring Apache to work with Tomcat

[Kevin Passey]

I struggled with that on my WIN2K pro machine. I got it working though.

In the documentation it does say "use short names" - so I used exactly the
names in the howto and it worked.

I don't know why but it did - I'd start from there.

Good luck

Kevin



-Original Message-
From: Matt Kwid [mailto:[EMAIL PROTECTED]
Sent: 23 June 2003 08:14
To: Tomcat Users List
Subject: RE: Configuring Apache to work with Tomcat


I have tried following these steps before with the newer versions of both
servers that I am working with.  I also just tried it again with the version
of Tomcat that is used in the "howto" with the newest version of Apache,
using mod_jk_2.0.46.dll to match the release.  I keep getting to this step,

"Save the changes you made to server.xml. Restart the Tomcat service. Wait a
few seconds, and then check to see if there is a file called mod_jk.conf in
c:\tomcat\tomcat-4-1-18\conf\auto
(c:\tomcat\tomcat-4-1-18\conf\auto\mod_jk.conf). If there is, all is well."

The new mod_jk.conf file is not being created.

Any and all suggestions are appreciated.

~Matt

-Original Message-
From: Logan Scott [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 11:20 PM
To: Tomcat Users List
Subject: RE: Configuring Apache to work with Tomcat


Try this:

http://www.johnturner.com/howto/winxp-howto.html

-Original Message-
From: Matt Kwid [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 11:12 PM
To: [EMAIL PROTECTED]
Subject: Configuring Apache to work with Tomcat


Greetings,

I just read through a bunch of the emails sent at the mail archive for this
mailing list and read about other issues concerning mod_jk as well as the
many different versions of mod_jk configurations for different versions of
Tomcat.

I have followed the  "for the impatients" JK documentation that comes in my
installations Tomcat docs to the T on two Windows XP machines multiple times
to no avail.  I am working with Tomcat 4.1.24 and Apache 2.0.46.  I am able
to load the pages found at http://localhost and
http://localhost:8080/index.jsp for both servers.

Can someone please give me a hand in configuring them to work together or
point me to any resources?


~Matt the noob


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Best versions - of Tomcat to run with apache

[Kevin Passey]

John thanks for that - I think it is about time I upgraded anyway.

I have tried it and it comes up with a blank page in the editor - so I'm not
too worried.

Would you say it was better to run tomcat behind apache - the server in
question only runs JSP all my static stuff is served by my ISP. I would not
prefer the hassle of plugging in apache if I don't have to.

Regards

Kevin 
-Original Message-
From: John Turner [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 17:14
To: Tomcat Users List
Subject: Re: Best versions - of Tomcat to run with apache



I've never heard of that vulnerability.  Have you tried it?  Have you 
checked the security lists to confirm?

If memory serves, it wasn't known as of 4.1.18 when the "Apache Tomcat 
Security Handbook" from Wrox Press was published.

John

On Wed, 18 Jun 2003 16:37:22 +0100, Kevin Passey 
<[EMAIL PROTECTED]> wrote:

> Hi,
>
> Yes I've done the apache/tomcat/mod_jk2 and it works fine.
>
> The reason I wanted to do this is because I was using nessus to scan my 
> web
> server and it reports a vulnerability it TOMCAT 4.1.12 which allows 
> someone
> to retrieve any file on your system by putting ../../ in front of the 
> file
> name. It recommends to use another web server - yeah right - .
>
> So I thought if I put apache in front of it - running tomcat in process 
> that
> would cure it.
>
> Thanks anyway.
>
> Kevin
> -Original Message-
> From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
> Sent: 18 June 2003 16:29
> To: Tomcat Users List
> Subject: RE: Best versions - of Tomcat to run with apache
>
>
>
> Howdy,
> I did the standard apache2 - tomcat mod_jk configuration once, just to
> try it out.  But I run tomcat standalone, including in production, as I
> find its performance more than adequate and don't need any apache
> features.
>
> Yoav Shapira
> Millennium ChemInformatics
>
>
>> -Original Message-
>> From: Kevin Passey [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, June 18, 2003 11:27 AM
>> To: 'Tomcat Users List'
>> Subject: RE: Best versions - of Tomcat to run with apache
>>
>> Hi Yoav,
>>
>> I know that - I want to load it on a RH7.2 box with apache using mod_jk
> or
>> 2.
>>
>> Have you ever configured tomcat to run "in-process" with apache. All
> you do
>> is start apache and it calls tomcat when and if it needs it.
>>
>> I'm on the verge of getting the latest 4.1.24 rpms and the latest
> apache2
>> rpms and just installing the whole lot.
>>
>> What I wondered was - if there were ony compatibility issues between
>> tomcat(latest) and apache2 running mod_jk2.
>>
>> Thanks anyway + regards
>>
>> Kevin
>> -Original Message-
>> From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>> Sent: 18 June 2003 16:14
>> To: Tomcat Users List
>> Subject: RE: Best versions - of Tomcat to run with apache
>>
>>
>>
>> Howdy,
>> The latest stable release, 4.1.24.
>>
>> Yoav Shapira
>> Millennium ChemInformatics
>>
>>
>>> -Original Message-
>>> From: Kevin Passey [mailto:[EMAIL PROTECTED]
>>> Sent: Wednesday, June 18, 2003 11:14 AM
>>> To: Tomcat (E-mail)
>>> Subject: Best versions - of Tomcat to run with apache
>>>
>>> Hi,
>>>
>>> Can anybody tell me the best version of Tomcat that will run with
>> apache
>>> using say mod_jk or mod_jk2.
>>>
>>> Thanks
>>>
>>> Kevin Passey
>>> Tel +44(0)1273 712830
>>> http://www.kdpsoftware.co.uk
>>> http://www.freeas400software.com
>>>
>>>
>>> -
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>> This e-mail, including any attachments, is a confidential business
>> communication, and may contain information that is confidential,
>> proprietary
>> and/or privileged.  This e-mail is intended only for the individual(s)
> to
>> whom it is addressed, and may not be saved, copied, printed, disclosed
> or
>> used by anyone else.  If you are not the(an) intended recipient, please
>> immediately delete this e-mail from your computer system and notify the
>> sender.  Thank you.
>>
>>
>> -
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>

RE: Best versions - of Tomcat to run with apache

[Kevin Passey]

Hi,

Yes I've done the apache/tomcat/mod_jk2 and it works fine.

The reason I wanted to do this is because I was using nessus to scan my web
server and it reports a vulnerability it TOMCAT 4.1.12 which allows someone
to retrieve any file on your system by putting ../../ in front of the file
name. It recommends to use another web server - yeah right - .

So I thought if I put apache in front of it - running tomcat in process that
would cure it.

Thanks anyway.

Kevin
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 16:29
To: Tomcat Users List
Subject: RE: Best versions - of Tomcat to run with apache



Howdy,
I did the standard apache2 - tomcat mod_jk configuration once, just to
try it out.  But I run tomcat standalone, including in production, as I
find its performance more than adequate and don't need any apache
features.

Yoav Shapira
Millennium ChemInformatics


>-Original Message-
>From: Kevin Passey [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 18, 2003 11:27 AM
>To: 'Tomcat Users List'
>Subject: RE: Best versions - of Tomcat to run with apache
>
>Hi Yoav,
>
>I know that - I want to load it on a RH7.2 box with apache using mod_jk
or
>2.
>
>Have you ever configured tomcat to run "in-process" with apache. All
you do
>is start apache and it calls tomcat when and if it needs it.
>
>I'm on the verge of getting the latest 4.1.24 rpms and the latest
apache2
>rpms and just installing the whole lot.
>
>What I wondered was - if there were ony compatibility issues between
>tomcat(latest) and apache2 running mod_jk2.
>
>Thanks anyway + regards
>
>Kevin
>-Original Message-
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>Sent: 18 June 2003 16:14
>To: Tomcat Users List
>Subject: RE: Best versions - of Tomcat to run with apache
>
>
>
>Howdy,
>The latest stable release, 4.1.24.
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
>>-Original Message-
>>From: Kevin Passey [mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, June 18, 2003 11:14 AM
>>To: Tomcat (E-mail)
>>Subject: Best versions - of Tomcat to run with apache
>>
>>Hi,
>>
>>Can anybody tell me the best version of Tomcat that will run with
>apache
>>using say mod_jk or mod_jk2.
>>
>>Thanks
>>
>>Kevin Passey
>>Tel +44(0)1273 712830
>>http://www.kdpsoftware.co.uk
>>http://www.freeas400software.com
>>
>>
>>-
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>This e-mail, including any attachments, is a confidential business
>communication, and may contain information that is confidential,
>proprietary
>and/or privileged.  This e-mail is intended only for the individual(s)
to
>whom it is addressed, and may not be saved, copied, printed, disclosed
or
>used by anyone else.  If you are not the(an) intended recipient, please
>immediately delete this e-mail from your computer system and notify the
>sender.  Thank you.
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]




This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential, proprietary
and/or privileged.  This e-mail is intended only for the individual(s) to
whom it is addressed, and may not be saved, copied, printed, disclosed or
used by anyone else.  If you are not the(an) intended recipient, please
immediately delete this e-mail from your computer system and notify the
sender.  Thank you.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Best versions - of Tomcat to run with apache

[Kevin Passey]

Hi Yoav,

I know that - I want to load it on a RH7.2 box with apache using mod_jk or
2.

Have you ever configured tomcat to run "in-process" with apache. All you do
is start apache and it calls tomcat when and if it needs it.

I'm on the verge of getting the latest 4.1.24 rpms and the latest apache2
rpms and just installing the whole lot.

What I wondered was - if there were ony compatibility issues between
tomcat(latest) and apache2 running mod_jk2.

Thanks anyway + regards

Kevin
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 16:14
To: Tomcat Users List
Subject: RE: Best versions - of Tomcat to run with apache



Howdy,
The latest stable release, 4.1.24.

Yoav Shapira
Millennium ChemInformatics


>-Original Message-
>From: Kevin Passey [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 18, 2003 11:14 AM
>To: Tomcat (E-mail)
>Subject: Best versions - of Tomcat to run with apache
>
>Hi,
>
>Can anybody tell me the best version of Tomcat that will run with
apache
>using say mod_jk or mod_jk2.
>
>Thanks
>
>Kevin Passey
>Tel +44(0)1273 712830
>http://www.kdpsoftware.co.uk
>http://www.freeas400software.com
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]




This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential, proprietary
and/or privileged.  This e-mail is intended only for the individual(s) to
whom it is addressed, and may not be saved, copied, printed, disclosed or
used by anyone else.  If you are not the(an) intended recipient, please
immediately delete this e-mail from your computer system and notify the
sender.  Thank you.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Best versions - of Tomcat to run with apache

[Kevin Passey]

Hi,

Can anybody tell me the best version of Tomcat that will run with apache
using say mod_jk or mod_jk2.

Thanks

Kevin Passey
Tel +44(0)1273 712830
http://www.kdpsoftware.co.uk
http://www.freeas400software.com


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Newbie: Apache & Tomcat Configuration.

[Kevin Passey]

Muhammad

You actually configure apache to call tomcat when ever it needs it - i.e
tomcat runs in-process

This configuration is done in your jk2 config file in the tomcat/conf
directory and in your apache2/conf workers2.properties file.

If you search on Google you will find lots of info on the subject - I have
just configured the latest versions of apache,tomcat and mod_jk2.dll to run
on a win2k machine - my next job is to get it running on rh7.2.

Good luck.

Regards

Kevin

-Original Message-
From: Sohail Muhammad [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 10:33
To: Tomcat Users List
Subject: RE: Newbie: Apache & Tomcat Configuration.


Hello,

i have added the following lines in my conf/server.xml file:

 

when i start the tomcat server i get the ClassNotFoundException for
org.apache.ajp.tomcat4.Ajp13Connector

is there some file missing in my tomcat. i'm using tomcat 4.0

Regards,

Muhammad Sohail
Assistant Programmer Analyst
SSD, UBL I.T & T Division, Karachi
Voice: 90332418,90332415-6


-Original Message-
From: John Turner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:37 PM
To: Tomcat Users List
Subject: Re: Newbie: Apache & Tomcat Configuration.



No, AJP is a protocol.

John

On Wed, 11 Jun 2003 10:32:53 -0400, Phillip Qin <[EMAIL PROTECTED]> 
wrote:

> Is there a connector called ajp14?
>
> -Original Message-
> From: Michele Neylon :: Blacknight Solutions
> [mailto:[EMAIL PROTECTED] Sent: June 11, 2003 5:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Newbie: Apache & Tomcat Configuration.
>
>
>> Hello All,
>>
>> Newbie Question:
>>
>> I believe these questions have been answered before but i have not been
>> able to grasp the procedure.
>>
>> 1)  I want to use Tomcat 4.0 with Apache 2.0.43 . How do i integrate the
>> two?
>
> If you look in the archive some links to tutorials were posted yesterday.
> General consensus is to use mod_jk either v1 or v2
>
>> 2)  After these are integrated what should i do to make the Apache
>> webserver transfer requests for servlet and jsp execution to   Tomcat
>> and the other way around i.e. transfer http requests from Tomcat to
>> Apache?
>
> See the links mentioned. Basically you would be  using an ajp13 or ajp14
> handler to pass the requests from one to the other.
>
>> 3)  Is it possible to adjust both Apache and Tomcat in such a
>> way that whenever Apache is started Tomcat starts automatically and
>> whenever Apache stops Tomcat also shutsdown?
>
> That would be nice. If anybody has a simple way of doing it please please
> share :-)
>



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: where to find sample config files for JK2

[Kevin Passey]

Hi Tim,

I've just installed this this morning on my w2k machine, it should be
similar.

Have a look in the tomcat documentation - there is a quick start section for
this.

Start the server and go to
http://ratbert/tomcat-docs/jk2/jk2/confighowto.html Note:ratbert is my
machine - localhost will do. You will have to put 8080 in the URL - I've put
mine behind apache.

Regards

Kevin

-Original Message-
From: Tim Robinson [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 14:48
To: [EMAIL PROTECTED]
Subject: where to find sample config files for JK2


Hi,

I have downloaded the JK2 redirector for IIS, but all I get is a single DLL.
I have found the JK documentation but no sign of any configuration files.

Sorry if I'm being dumb, but can someone point me where to get the config
files - from what I can see they're called jk2.properties and
workers2.properties. I found a jk2.properties in my vanilla tomcat
installation but every line is commented out.

Thanks in advance for any help.

--- Tim Robinson


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Tomcat working with apache

[Kevin Passey]

Has anybody go this working from this info

http://localhost:8080/tomcat-docs/jk2/jk2/confighowto.html


Thanks

Kevin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Where do I get MOD_JK2 - directory is empty

[Kevin Passey]

Thanks David.

It's here now:-

http://jakarta.apache.org/builds/jakarta-tomcat-connectors/jk2/release/v2.0.
2/bin/win32/

Regards

Kevin

-Original Message-
From: David Legg [mailto:[EMAIL PROTECTED]
Sent: 09 June 2003 13:04
To: 'Tomcat Users List'
Subject: RE: Where do I get MOD_JK2 - directory is empty


I got my copy from : -

 
http://jakarta.apache.org/builds/jakarta-tomcat-connectors/jk2/release/v2.0.
2/bin/win32/

David Legg


-Original Message-----
From: Kevin Passey [mailto:[EMAIL PROTECTED]
Sent: 09 June 2003 12:38
To: Tomcat (E-mail)
Subject: Where do I get MOD_JK2 - directory is empty


The d/l page is empty - what's wrong??

http://jakarta.apache.org/builds/jakarta-tomcat-connectors/jk/release/v1.2.4
/bin/win32/

Regards

Kevin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Where do I get MOD_JK2 - directory is empty

[Kevin Passey]

The d/l page is empty - what's wrong??

http://jakarta.apache.org/builds/jakarta-tomcat-connectors/jk/release/v1.2.4
/bin/win32/

Regards

Kevin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Tomcat with apache

[Kevin Passey]

Hi everyone,

I have searched thru the archives and cannot find a pointer on this. Can
anybody point me to some how-to's on getting the latest version of Tomcat to
run with Apache Http.

Regards

Kevin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: tomcat 4.1.12 just stopped working, help !

[Kevin Passey]

Or use cooktop if you don't have XML Spy

Cheers

Kevin

-Original Message-
From: Holger Brozio [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 09:14
To: Tomcat Users List
Subject: Re: tomcat 4.1.12 just stopped working, help !


Whats about using a tool like XML Spy. With this one you can check, if the
web.xml files are well formed and valid.
Valid means, that they match the rules defined in the web-app_2_3.dtd, which
seems to be the problem in that case.

HTH

Holger
- Original Message -
From: "Peng Tuck Kwok" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 9:53 AM
Subject: Re: tomcat 4.1.12 just stopped working, help !


> Hmm, it looks like an error in the web.xml of a certain app. Did you by
> any chance change the web.xml of any of your web applications ?
>
> [EMAIL PROTECTED] wrote:
> > Hi all
> > Some time during christmas Tomcat 4.1.12 stopped working for me, I don´t
know why, thought anyone here might have a clue.
> > This is what I know:
> > If I start tomcat with ".../bin/startup.sh" and then run a portscan I
can see:
> > 8009/tcp   openajp13
> > 8080/tcp   openhttp-proxy
> > So evidently something happens ;)
> >
> > But if I try to access http://my.ip:8080/index.wml (or just
http://my.ip:8080) I don´t get any answer at all, it seems totally dead.
> >
> > If I then stop Tomcat (.../bin/shutdown.sh) and run a portscan the
services on ports 8009 and 8080 are gone.
> >
> > But if I directly run ".../bin/catalina.sh run" I get this: (if someone
can get any clue from this)
> >
> > [root@star bin]# ./catalina.sh run
> > Using CATALINA_BASE:   /etc/jakarta-tomcat-4.1.12
> > Using CATALINA_HOME:   /etc/jakarta-tomcat-4.1.12
> > Using CATALINA_TMPDIR: /etc/jakarta-tomcat-4.1.12/temp
> > Using JAVA_HOME:   /usr/java/j2sdk1.4.1
> > Jan 7, 2003 9:40:58 AM org.apache.commons.modeler.Registry loadRegistry
> > INFO: Loading registry information
> > Jan 7, 2003 9:40:58 AM org.apache.commons.modeler.Registry getRegistry
> > INFO: Creating new Registry instance
> > Jan 7, 2003 9:41:03 AM org.apache.commons.modeler.Registry getServer
> > INFO: Creating MBeanServer
> >
> > Starting service Tomcat-Standalone
> > Apache Tomcat/4.1.12
> > Jan 7, 2003 9:47:29 AM org.apache.commons.digester.Digester error
> > SEVERE: Parse Error at line 114 column 15: The content of element type
"servlet" must match
"(icon?,servlet-name,display-name?,description?,(servlet-class|jsp-file),ini
t-param*,load-on-startup?,run-as?,security-role-ref*)".
> > org.xml.sax.SAXParseException: The content of element type "servlet"
must match
"(icon?,servlet-name,display-name?,description?,(servlet-class|jsp-file),ini
t-param*,load-on-startup?,run-as?,security-role-ref*)".
> > at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(ErrorHand
lerWrapper.java:232)
> > at
org.apache.xerces.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:17
3)
> > at
org.apache.xerces.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:36
2)
> > at
org.apache.xerces.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:29
6)
> > at
org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(XMLDTDValidator.
java:1953)
> > at
org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(XMLDTDValidator.java:8
78)
> > at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.handleEndElement(XMLDo
cumentFragmentScannerImpl.java:1144)
> > at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocu
mentFragmentScannerImpl.java:987)
> > at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatc
her.dispatch(XMLDocumentFragmentScannerImpl.java:1445)
> > at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocume
ntFragmentScannerImpl.java:333)
> > at
org.apache.xerces.parsers.DTDConfiguration.parse(DTDConfiguration.java:524)
> > at
org.apache.xerces.parsers.DTDConfiguration.parse(DTDConfiguration.java:580)
> > at org.apache.xerces.parsers.XMLParser.parse(XMLParser.java:152)
> > at
org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:116
9)
> > at
org.apache.commons.digester.Digester.parse(Digester.java:1495)
> > at
org.apache.catalina.startup.ContextConfig.applicationConfig(ContextConfig.ja
va:282)
> > at
org.apache.catalina.startup.ContextConfig.start(ContextConfig.java:639)
> > at
org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:
243)
> > at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:166)
> > at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3493)
> > at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
> > at
org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
> > at
org.apache.catalina.co

RE: Is there a problem with tomcat JNDI resources (I don't think so)

[Kevin Passey]

Hi,

I've got this in my web xml for the app..Not doing global though.

- 
  DB Connection 
  jdbc/shiltonDB 
  javax.sql.DataSource 
  Container 
  

Regards

Kevin

-Original Message-
From: Iran Marcius [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2002 14:06
To: [EMAIL PROTECTED]
Subject: Is there a problem with tomcat JNDI resources (I don't think
so)


Hi fellows.

I think I'm doing something wrong, but I can't get a JNDI Datasource
configured in GlobalNamingResource section.

Here is my configuration:




factory

org.apache.commons.dbcp.BasicDataSourceFactory


driverClassName
org.postgresql.Driver


url
jdbc:postgresql://localhost/global


validationQuery  
select 1


username
global


password
password



In my context I have the following:





But when I perform the lookup operations in my servlet, got the
following error:

javax.servlet.ServletException: Name java:comp is not bound in this
Context
at org.apache.naming.NamingContext.list(NamingContext.java:386)
at org.apache.naming.NamingContext.list(NamingContext.java:409)
at javax.naming.InitialContext.list(InitialContext.java:387)
at com.isic.tests.JNDITestServlet.doGet(JNDITestServlet.java:27)

My lookup line is: DataSource ds =
(DataSource)ic.lookup("java:comp/env/jdbc/global"); Is it correct?
Sometimes I got really confused about these names.

Am I missing some configuration in context or web.xml (is resource-ref
necessary?).

My application is running in a virtual host I created (with a
SingleSignOn valve). Could it be the problem?

Thanks for any help.

iran




--
To unsubscribe, e-mail:

For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Connection Pooling - additions to server.xml crashes 4.1.12

[Kevin Passey]

Hi all, especially Jake

Thanks for that - I had worked that out the hard way - but the alternative
you give will be my way ahead (assuming it works in my env).

Thanks for that Jake.

Cheers 

Kevin

-Original Message-
From: Jacob Kjome [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2002 14:08
To: Tomcat Users List
Subject: Re: Connection Pooling - additions to server.xml crashes 4.1.12



If you name a context in server.xml, your .war file will *not* be expanded 
automatically.  What you will need to do is stop Tomcat, manually expand 
the .war file to a directory named "shilton" and then 
restart.  alternatively, you can avoid editing the server.xml and put this 
in a context configuration file.  See the admin.xml and manager.xml files 
in "webapps" for examples.  Basically, you just copy your entire  entry to a separate .xml file.  I'd name it the same thing as your 
webapp to make it clear what that file if for, but I don't think that is a 
requirement.  Either way, you need to manually expand your .war file 
*before* tomcat is restarted.

Alternatively, you can start Tomcat (making sure to have removed the 
 entry from server.xml), create your context configuration 
file and name it "context.xml".  Put that in META-INF of your .war file, 
and then use the Tomcat manager app's "deploy" command to deploy your .war 
file.  Modify your context to have a docbase with the name of the .war file 
(I believe).  The easiest way to do this is to use the catalina ant manager 
tasks.

Jake

At 11:46 AM 12/17/2002 +, you wrote:
>Can anybody shed any light on this.
>
>If I add this to my server XML file :-
>
>- crossContext="true">
>   type="javax.sql.DataSource" />
>- 
>- 
>   factory
>   org.apache.commons.dbcp.BasicDataSourceFactory
>   
>- 
>   maxActive
>   100
>   
>- 
>   maxIdle
>   5
>   
>- 
>   maxWait
>   100
>   
>- 
>   username
>   INTERNET
>   
>- 
>   password
>   INTERNET
>   
>- 
>   driverClassName
>   com.ibm.as400.access.AS400JDBCDriver
>   
>- 
>   url
>   jdbc:as400://NORBERT
>   
>   
>   
>
>When I try to publish via a war file Tomcat will not start. If I delete the
>war file and publish the folder manually Tomcat starts - have I done
>something wrong.
>
>Some notes - I have my test server installed on a WIN2K box and it works ok
>- I am using IBM's WSAD 4.0.3 so I presume the files are not published via
a
>war.
>
>My production box is Linux RH7.2.
>
>Thanks for any input.
>
>Kevin
>
>--
>To unsubscribe, e-mail:

>For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Connection Pooling - additions to server.xml crashes 4.1.12

[Kevin Passey]

Can anybody shed any light on this.

If I add this to my server XML file :-

- 
   
- 
- 
  factory 
  org.apache.commons.dbcp.BasicDataSourceFactory 
  
- 
  maxActive 
  100 
  
- 
  maxIdle 
  5 
  
- 
  maxWait 
  100 
  
- 
  username 
  INTERNET 
  
- 
  password 
  INTERNET 
  
- 
  driverClassName 
  com.ibm.as400.access.AS400JDBCDriver 
  
- 
  url 
  jdbc:as400://NORBERT 
  
  
  

When I try to publish via a war file Tomcat will not start. If I delete the
war file and publish the folder manually Tomcat starts - have I done
something wrong.

Some notes - I have my test server installed on a WIN2K box and it works ok
- I am using IBM's WSAD 4.0.3 so I presume the files are not published via a
war.

My production box is Linux RH7.2.

Thanks for any input.

Kevin

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Enough please!

[Kevin Passey]

Mine works as well now - thanks Eric.

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 14:05
To: Tomcat Users List
Subject: Enough please!


Folks,

Can we stop the "I don't understand the objective of this open list.."
thread.

While we all have our opinions, this is meant to be a list where we help
each other technically.

I have been attempting to help people with database pooling (mine works :-))
for the last few days, but I have had to spend far too much time deleting
the hundred or so reponses to this thread.

Can we get back to sanity please?

Thanks

Eric

--
To unsubscribe, e-mail:

For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

FW: Connection Pooling - It works now - thanks list

[Kevin Passey]

Thanks to everyone who contributed to this thread - especially Eric Roberts
- I now have a connection pool to my AS/400 (iSeries) DB2 database server.

Here is what I did - Upgraded my 4.0.1 Tomcat to 4.1.12.

Put jt400.jar in /common/lib

Here is what I put in my server.xml file ---

 

   

   
  
 factory

 
org.apache.commons.dbcp.BasicDataSourceFactory
  

  
 maxActive

 100
  

  
 maxIdle

 3
  

  
 maxWait

 100
  

  
 username

 AUSERNAME
  

  
 password

 APASSWD
  

  
 driverClassName

 com.ibm.as400.access.AS400JDBCDriver
  

  
 url

 jdbc:as400://NORBERT
  
   


In the web.XML in WEB-INF I put :-




Resource reference to a factory for java.sql.Connection

instances that may be used for talking to a particular

database that is configured in the server.xml file.





jdbc/testDB





javax.sql.DataSource





Container








And the java code references a data source.

Hope this helps anyone else - I am now going to put together some pages
using the apache tag libraries.

Regards

Kevin




-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 15:07
To: Kevin Passey
Subject: RE: Connection Pooling


The current "production" version is 4.1.12 - all I can say is that it works
on that version!

-Original Message-----
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Montag, 09. Dezember 2002 16:01
To: Roberts, Eric
Subject: RE: Connection Pooling


Ha ha - that's what's prompted me to d/l 4.06 - I will start from there -
unless you recommend another version.

Thanks

Kevin

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 15:01
To: Kevin Passey
Subject: RE: Connection Pooling


Whoops! - what version of Tomcat are you running?

-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Montag, 09. Dezember 2002 15:49
To: Roberts, Eric
Subject: RE: Connection Pooling


Hi Eric,

I don't have anything like this in my Server.XML file ??

Regards

Kevin

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 14:41
To: Kevin Passey
Subject: RE: Connection Pooling


Kevin,

As I say, there appears to be nothing wrong with the resource definition,
but Tomcat is definitely not resolving it - hence the previous question
about restarting.

The only other thing I can suggest is that to use JNDI, the entries at the
top of server.xml - 

  
  
  

- perhaps need to be uncommented (mine are).


-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Montag, 09. Dezember 2002 15:28
To: Roberts, Eric
Subject: RE: Connection Pooling


Hi Eric,

one other thing - here is where I have put the shiltonDB context entries:-

  --> 
-  
-  
-  
- 
   
- 
- 

If that makes any sense - you can see it is just after the commented Root
Context.

Thanks again

Kevin

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 14:20
To: Kevin Passey
Subject: RE: Connection Pooling


OK - tomcat is not seeing your resource name jdbc/shiltonDB,(jdbc/shiltonDB
: null) but from what you have already said, it is declared in your context
correctly.

So - stupid question - have you restarted Tomcat since you added the
resource?

-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Montag, 09. Dezember 2002 15:06
To: Roberts, Eric
Subject: RE: Connection Pooling


Eric,

Here is what I got:-

Simple lookup test : 
jdbc/shiltonDB : null
list() on /comp/env Context : 
Binding : jdbc: org.apache.naming.NamingContext
listBindings() on /comp/env Context : 
Binding : jdbc:
org.apache.naming.NamingContext:org.apache.naming.NamingContext@1bfbcffb
Creating data source failed

I haven't changed the file name yet - but I presume it hasn't got that far.

Regards

Kevin

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 13:56
To: [EMAIL PROTECTED]
Subject: Connection Pooling


Kevin,

Attached is a small test servlet which works for me (just edit the select
statement to something real).
It will give you the resources defined for your context. 

Hope it helps. &

RE: Connection Pooling Help

[Kevin Passey]

Eric,

It's the same - DS == null. :-(

Thanks anyway.

Kevin

-Original Message-
From: Roberts, Eric [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 13:33
To: Tomcat Users List
Subject: RE: Connection Pooling Help


Kevin,

Try:

  Context ctx = new InitialContext();
Context envCtx = (Context) ctx.lookup("java:/comp/env/");
DataSource ds = (DataSource) envCtx.lookup("/jdbc/shiltonDB");


-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Montag, 09. Dezember 2002 14:25
To: Tomcat Users List (E-mail)
Subject: Connection Pooling Help


Hi,

Can somebody point out my mistake for me - I'm starting to bang my head..

I am trying to get connection pooling working on my AS/400 using the
Commons-DBCP.

I have placed this JAR in /common/lib along with the JT400.JAR

I have added the context entries to my server.xml file - thus:-



   

   
  
 factory

 
org.apache.commons.dbcp.BasicDataSourceFactory
  

  
 maxActive

 100
  

  
 maxIdle

 3
  

  
 maxWait

 100
  

  
 username

 INTERNET
  

  
 password

 INTERNET
  

  
 driverClassName

 com.ibm.as400.access.AS400JDBCDriver
  

  
 url

 jdbc:as400://10.0.0.1
  
   


I have added this to my WEB-INF web.xml file:-





Resource reference to a factory for java.sql.Connection

instances that may be used for talking to a particular

database that is configured in the server.xml file.





jdbc/shiltonDB





javax.sql.DataSource





Container





And I have this java program to test the connection

import javax.naming.*;
import javax.sql.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletOutputStream;
import java.sql.*;

public class DBCPServlet extends HttpServlet {

   public void doGet(HttpServletRequest req,
 HttpServletResponse res) {

  try {
 ServletOutputStream out = res.getOutputStream();
 out.println("");
 out.println("Using Tomcat Connection Pooling with DBCP");

 Context ctx = new InitialContext();
 if (ctx == null)
out.println("Something is wrong with Tomcat");

 DataSource ds = (DataSource)
ctx.lookup("java:comp/env/jdbc/shiltonDB");

 if (ds != null) {
Connection conn = ds.getConnection();

if (conn != null) {
   out.println("Got Connection: " + conn.toString() +
"");
   Statement stmt = conn.createStatement();
   String sql = "select * from BSSTYL";
   ResultSet rst = stmt.executeQuery(sql);
   if (rst.next()) {
  out.println("Value of HDCUST on first record: "+
rst.getString("dbfield1")+ "");
   }
   out.println("This was our little database-access
servlet...");
   conn.close();
}
 }
  } catch (Exception e) {
 e.printStackTrace();
  }
   }

   /**
* if somebody does a http-post, we do an interal dispatch to doGet()
*/
   public void doPost(HttpServletRequest req,
  HttpServletResponse res) {
  doGet(req, res);
   }
}

"ds" is alway null - what am I missing.

Thanks in advance.



Kevin 

--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Connection Pooling Help

[Kevin Passey]

Hi,

Can somebody point out my mistake for me - I'm starting to bang my head..

I am trying to get connection pooling working on my AS/400 using the
Commons-DBCP.

I have placed this JAR in /common/lib along with the JT400.JAR

I have added the context entries to my server.xml file - thus:-



   

   
  
 factory

 
org.apache.commons.dbcp.BasicDataSourceFactory
  

  
 maxActive

 100
  

  
 maxIdle

 3
  

  
 maxWait

 100
  

  
 username

 INTERNET
  

  
 password

 INTERNET
  

  
 driverClassName

 com.ibm.as400.access.AS400JDBCDriver
  

  
 url

 jdbc:as400://10.0.0.1
  
   


I have added this to my WEB-INF web.xml file:-





Resource reference to a factory for java.sql.Connection

instances that may be used for talking to a particular

database that is configured in the server.xml file.





jdbc/shiltonDB





javax.sql.DataSource





Container





And I have this java program to test the connection

import javax.naming.*;
import javax.sql.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletOutputStream;
import java.sql.*;

public class DBCPServlet extends HttpServlet {

   public void doGet(HttpServletRequest req,
 HttpServletResponse res) {

  try {
 ServletOutputStream out = res.getOutputStream();
 out.println("");
 out.println("Using Tomcat Connection Pooling with DBCP");

 Context ctx = new InitialContext();
 if (ctx == null)
out.println("Something is wrong with Tomcat");

 DataSource ds = (DataSource)
ctx.lookup("java:comp/env/jdbc/shiltonDB");

 if (ds != null) {
Connection conn = ds.getConnection();

if (conn != null) {
   out.println("Got Connection: " + conn.toString() +
"");
   Statement stmt = conn.createStatement();
   String sql = "select * from BSSTYL";
   ResultSet rst = stmt.executeQuery(sql);
   if (rst.next()) {
  out.println("Value of HDCUST on first record: "+
rst.getString("dbfield1")+ "");
   }
   out.println("This was our little database-access
servlet...");
   conn.close();
}
 }
  } catch (Exception e) {
 e.printStackTrace();
  }
   }

   /**
* if somebody does a http-post, we do an interal dispatch to doGet()
*/
   public void doPost(HttpServletRequest req,
  HttpServletResponse res) {
  doGet(req, res);
   }
}

"ds" is alway null - what am I missing.

Thanks in advance.



Kevin 

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Connecting to mysql - Server configuration denies access to data source

[Kevin Passey]

Has anybody seen this.

I've set the mysql tables correctly.

Can anybody shed any light on this.

Thanks

Kevin Passey
KDP Software Limited
Tel: 01273 712830
Fax: 08700 510103
mailto:kpassey@;kdpsoftware.co.uk
http://www.kdpsoftware.co.uk

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Connecting to mysql - Server configuration denies access to data source

[Kevin Passey]

Has anybody seen this.

I've set the mysql tables correctly.

Can anybody shed any light on this.

Thanks

Kevin Passey
KDP Software Limited
Tel: 01273 712830
Fax: 08700 510103
mailto:kpassey@;kdpsoftware.co.uk
http://www.kdpsoftware.co.uk

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

RE: How do I Hide version specific information

[Kevin Passey]

I have been using Nessus to scan my server - and they recommend that you do
not give out exactly the version information of your web server "as it helps
a hacker define what webserver you have, and thus any vulnerabilities that
may exist on your server"

Does that help?

Kevin

-Original Message-
From: Henner Zeller [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2002 15:37
To: Tomcat Users List
Subject: Re: How do I Hide version specific information



mail.NoSuchExplainingContentException
at task.reading.MailReader(MailReader.java:42)
;-)

Anyway .. what version specific information of what you want to hide .. 
from whom ?

On Thu, 18 Jul 2002, Kevin Passey wrote:

> Thanks
> 
> Kevin Passey

-hen



--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

How do I Hide version specific information

[Kevin Passey]

Thanks

Kevin Passey

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Mailer TAG question

[Kevin Passey]

Why does this not work?



Thanks


Kevin Passey

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: How to hide a download file

[Kevin Passey]

I was thinking of setting something in the session for the download page
anyway which would direct a user back to the form.

But if I create a directory called "downloads" and put the file in there -
what's to stop someone just typing the folder URL and grabbing the file?

Thanks everyone for your input.

Kevin

-Original Message-
From: Cox, Charlie [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2002 17:46
To: 'Tomcat Users List'
Subject: RE: How to hide a download file


you can use a filter to see if the referring page is your form and then
allow the download or redirect to your form appropriately. Alternatively,
you could set a value in the session that is only set by your form
submission that your filter can look for.

I do a similar thing in a filter where I verify a form has been filled out
by checking the database for the user. I also enforce a login to do this,
but you don't need to if you just put something in the session. 

Charlie

> -Original Message-
> From: Alex Short [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 12:36 PM
> To: Tomcat Users List
> Subject: Re: How to hide a download file
> 
> 
> Certainly not the most elegant solution but you could keep 
> the real file 
> in a unreachable location, and upon submitting it copy's the 
> file to a 
> cookie_date_time_filename.ext and has them download that.  
> Then you run a 
> cleaner script to erase these temp files after 24 hours.
> 
> Alex
> 
>  > Hi all, > 
> > I need to pick your brains again.
> > 
> > I need to publish a site that requires a user to fill in a 
> form before
> > displaying a download link.
> > 
> > What I need to do is to hide the file to be downloaded so 
> that it cannot be
> > downloaded without the form being filled in - i.e it can 
> only be downloaded
> > from a particular generated JSP page.
> > 
> > Can I do this with Tomcat?
> > 
> > Thanks in advance.
> > 
> > 
> > Kevin 
> > 
> > --
> > To unsubscribe, e-mail:   

> For additional commands, e-mail:

> 
> 
> 
> 


--
To unsubscribe, e-mail:

For additional commands, e-mail:


--
To unsubscribe, e-mail:

For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

How to hide a download file

[Kevin Passey]

Hi all,

I need to pick your brains again.

I need to publish a site that requires a user to fill in a form before
displaying a download link.

What I need to do is to hide the file to be downloaded so that it cannot be
downloaded without the form being filled in - i.e it can only be downloaded
from a particular generated JSP page.

Can I do this with Tomcat?

Thanks in advance.


Kevin 

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Tomcat 4.0.3-HTTP Status 500-Internal Server Error

[Kevin Passey]

Are you referencing the page as x.jsp or just 

That caught me out a couple of times. Additionally check the servlet entries
in your web.XML file.

Regards

Kevin

-Original Message-
From: John and Alicia Scott [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 20:19
To: [EMAIL PROTECTED]
Subject: Tomcat 4.0.3-HTTP Status 500-Internal Server Error


Hi,

I've just started to use Tomcat 4.0.3.  All of the applications in the
\webapps\examples file that came with Tomcat run correctly.  I added a new
folder, \webapps\examples\jsp\forms, that contains form.jsp.  This file
sends/receives data from a javabean that I put in the
\webapps\examples\WEB_INF\classes\forms folder.  The bean is named
FormBean.java.  When I try to run the jps page from my browser, I get the
following error message: Tomcat 4.0.3-HTTP Status 500-Internal Server Error.
I copies part of the long root cause output below.
java.lang.ClassNotFoundException: com.jguru.FormBean
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav
a:1394)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav
a:1243)
at
org.apache.jasper.compiler.BeanRepository.getBeanType(BeanRepository.java:18
1)
at
org.apache.jasper.compiler.GetPropertyGenerator.generate(GetPropertyGenerato
r.java:102)
at
org.apache.jasper.compiler.JspParseEventListener$GeneratorWrapper.generate(J
spParseEventListener.java:834)
at
org.apache.jasper.compiler.JspParseEventListener.generateAll(JspParseEventLi
stener.java:241)
at
org.apache.jasper.compiler.JspParseEventListener.endPageProcessing(JspParseE
ventListener.java:197)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:215)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:552)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspSe
rvlet.java:177)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:189)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
This appears to be a classpath problem, but I can't identify what is wrong
with my configuration, if anything.  Do you have suggestions
on how to correct this problem?
Thanks,
John


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: updating records in a Mysql db using jsp.

[Kevin Passey]

Sorry that should be DB2/400.

Kevin

-Original Message-
From: Maarten van Heiningen [mailto:[EMAIL PROTECTED]]
Sent: 03 July 2002 14:42
To: [EMAIL PROTECTED]
Subject: updating records in a Mysql db using jsp.


Hi,

I am using a mysql db with jdbc on a win2000 server with Tomcat. I wonder
how I can update or delete items in a row or delete a complete row. I can
select the specific data in the table and put it on the webpage, but I also
want to edit this selected item.

any sugestions?

Maarten

sample code:

<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags"; prefix="sql" %>

<%-- open a database connection --%>

  jdbc:mysql://localhost/producten
  org.gjt.mm.mysql.Driver


<%-- open a database query --%>


 
  
SELECT manuf, type, prijs FROM mobile WHERE
manuf='<%=request.getParameter("manuf") %>' AND
type='<%=request.getParameter("type") %>'
order by 1
  
  <%-- loop through the rows of your query --%>
  

  
  
  
  

  










<%-- close a database connection --%>



Disclaimer

This communication together with any attachments transmitted with it ('this
E-mail') is intended only for the use of the addressee and may contain
information which is privileged and confidential. If the reader of this
E-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient you are notified that any use of
this E-mail is prohibited. Addressees should ensure this E-mail is checked
for viruses. The Carphone Warehouse Group PLC makes no representations as
regards the absence of viruses in this E-mail. If you have received this
E-mail in error please notify our ISe Response Team immediately by telephone
on + 44 (0)20 8896 5828 or via E-mail at [EMAIL PROTECTED] Please then
immediately destroy this E-mail and any copies of it.

Please feel free to visit our website: 

UK
http://www.carphonewarehouse.com

Group
http://www.phonehouse.com

RE: updating records in a Mysql db using jsp.

[Kevin Passey]

One other thing I forgot to mention my database is BD2/400.

Regards

Kevin

-Original Message-
From: Maarten van Heiningen [mailto:[EMAIL PROTECTED]]
Sent: 03 July 2002 14:42
To: [EMAIL PROTECTED]
Subject: updating records in a Mysql db using jsp.


Hi,

I am using a mysql db with jdbc on a win2000 server with Tomcat. I wonder
how I can update or delete items in a row or delete a complete row. I can
select the specific data in the table and put it on the webpage, but I also
want to edit this selected item.

any sugestions?

Maarten

sample code:

<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags"; prefix="sql" %>

<%-- open a database connection --%>

  jdbc:mysql://localhost/producten
  org.gjt.mm.mysql.Driver


<%-- open a database query --%>


 
  
SELECT manuf, type, prijs FROM mobile WHERE
manuf='<%=request.getParameter("manuf") %>' AND
type='<%=request.getParameter("type") %>'
order by 1
  
  <%-- loop through the rows of your query --%>
  

  
  
  
  

  










<%-- close a database connection --%>



Disclaimer

This communication together with any attachments transmitted with it ('this
E-mail') is intended only for the use of the addressee and may contain
information which is privileged and confidential. If the reader of this
E-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient you are notified that any use of
this E-mail is prohibited. Addressees should ensure this E-mail is checked
for viruses. The Carphone Warehouse Group PLC makes no representations as
regards the absence of viruses in this E-mail. If you have received this
E-mail in error please notify our ISe Response Team immediately by telephone
on + 44 (0)20 8896 5828 or via E-mail at [EMAIL PROTECTED] Please then
immediately destroy this E-mail and any copies of it.

Please feel free to visit our website: 

UK
http://www.carphonewarehouse.com

Group
http://www.phonehouse.com

RE: updating records in a Mysql db using jsp.

[Kevin Passey]

Like this


<%-- insert a row into the database --%>
 <%-- set the SQL query --%>
  insert into rbh.fdbk (uid,date,comm,instime)
  values ( '<%=LogInBean.getUid()%>',
   current_date ,
   '<%=request.getParameter("comments")%>',
   current_time)
  
  
 
  <%-- execute the query --%>
  


<%-- close a database connection --%>

or this

<%-- update the database --%>
 
<%-- set the SQL query --%>
 
 delete from RBH.fdbk WHERE UID = '<%=request.getParameter("uid")%>' and
date = '<%=request.getParameter("date")%>' and instime =
'<%=request.getParameter("instime")%>'
  
 
  <%-- execute the query --%>
  


<%-- close a database connection --%>

Good luck.

Kevin

-Original Message-
From: Maarten van Heiningen [mailto:[EMAIL PROTECTED]]
Sent: 03 July 2002 14:42
To: [EMAIL PROTECTED]
Subject: updating records in a Mysql db using jsp.


Hi,

I am using a mysql db with jdbc on a win2000 server with Tomcat. I wonder
how I can update or delete items in a row or delete a complete row. I can
select the specific data in the table and put it on the webpage, but I also
want to edit this selected item.

any sugestions?

Maarten

sample code:

<%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags"; prefix="sql" %>

<%-- open a database connection --%>

  jdbc:mysql://localhost/producten
  org.gjt.mm.mysql.Driver


<%-- open a database query --%>


 
  
SELECT manuf, type, prijs FROM mobile WHERE
manuf='<%=request.getParameter("manuf") %>' AND
type='<%=request.getParameter("type") %>'
order by 1
  
  <%-- loop through the rows of your query --%>
  

  
  
  
  

  










<%-- close a database connection --%>



Disclaimer

This communication together with any attachments transmitted with it ('this
E-mail') is intended only for the use of the addressee and may contain
information which is privileged and confidential. If the reader of this
E-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient you are notified that any use of
this E-mail is prohibited. Addressees should ensure this E-mail is checked
for viruses. The Carphone Warehouse Group PLC makes no representations as
regards the absence of viruses in this E-mail. If you have received this
E-mail in error please notify our ISe Response Team immediately by telephone
on + 44 (0)20 8896 5828 or via E-mail at [EMAIL PROTECTED] Please then
immediately destroy this E-mail and any copies of it.

Please feel free to visit our website: 

UK
http://www.carphonewarehouse.com

Group
http://www.phonehouse.com

Connection Pooling

[Kevin Passey]

Hi,

I am new to Tomcat so bear with me.

I have developed something using Websphere application server which has
connection pooling built-in.

Is there anything simple to plug in so that I can do the same with Tomcat?

Any docs or Howto's would be appreciated

Thanks

Kevin

RE: TOMCAT 4.0 on port 80

[Kevin Passey]

Pascal - 

We have shut down apache using "rcapache stop" and have modified the
rc.config file so that it does not start on bootup.

Thanks anyway - what we are trying is to change the server.xml file back to
80 and to restart tomcat under root.

Do you think that was our problem - not starting under root.

Regards

Kevin Passey

-Original Message-
From: Pascal Forget [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 11:42 AM
To: Tomcat Users List
Subject: Re: TOMCAT 4.0 on port 80


Kevin Passey wrote:

>Hi  all,
>
>We have temporarily given up on trying to get Tomcat working with apache as
>we seemed to be getting nowhere. What we wanted to do was to only serve
>JSP's anyway, but thought it would be a good idea to run it through apache
-
>commercially we don't have the time to persue this and our static pages are
>served by our ISP anyway.
>
>The next problem I need to overcome is to get Tomcat running on port 80 -
we
>have changed the server.xml file so that both instances of 8080 were
changed
>to 80. This works on windows but not on SuSE Linux 7.3 - please can you
give
>me any pointers.
>
If you can't get tomcat to bind to port 80 on a Linux box - or on any 
box for
that matter - you should check that there is no other web server running on
the machine.

For example, Red Hat installs an apache web server by default.  I don't know
about SuSe, but this could be your problem.  In order to ensure that 
there is
no httpd server running on your Linux box, do the following:

/etc/rc.d/init.d/httpd stop
rm -f /etc/rc.d/rc?.d/S??httpd

And then try to launch tomcat again.

I hope this helps,

Pascal Forget

 





--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

TOMCAT 4.0 on port 80

[Kevin Passey]

Hi  all,

We have temporarily given up on trying to get Tomcat working with apache as
we seemed to be getting nowhere. What we wanted to do was to only serve
JSP's anyway, but thought it would be a good idea to run it through apache -
commercially we don't have the time to persue this and our static pages are
served by our ISP anyway.

The next problem I need to overcome is to get Tomcat running on port 80 - we
have changed the server.xml file so that both instances of 8080 were changed
to 80. This works on windows but not on SuSE Linux 7.3 - please can you give
me any pointers.

Regards

Kevin Passey

To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

RE: TOMCAT 4.X - mod_jk

[Kevin Passey]

Hi again,

I have found my answer here
http://dcb.sun.com/practices/howtos/tomcat_apache.jsp

Thanks anyway.


Kevin Passey
--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>



-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2002 11:39
To: '[EMAIL PROTECTED]'
Subject: TOMCAT 4.X - mod_jk 


Hi,

I am somewhat confused..

I have TOMCAT 4 running quite happily on my Linux (SuSE 7.3) server - no
problem.

I also have the apache 1.3 distribution with my 7.3 running - no problem.

What I want to do is run TOMCAT as an apache plugin so that Apache is
serving my static pages and TOMCAT is doing the cool stuff.

The question is - do I have to use TOMCAT 3.3 as I cannot see a mod_jk
version for 4.x - or have I missed something?

Thanks

Kevin Passey
--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

TOMCAT 4.X - mod_jk

[Kevin Passey]

Hi,

I am somewhat confused..

I have TOMCAT 4 running quite happily on my Linux (SuSE 7.3) server - no
problem.

I also have the apache 1.3 distribution with my 7.3 running - no problem.

What I want to do is run TOMCAT as an apache plugin so that Apache is
serving my static pages and TOMCAT is doing the cool stuff.

The question is - do I have to use TOMCAT 3.3 as I cannot see a mod_jk
version for 4.x - or have I missed something?

Thanks

Kevin Passey
--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>