You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Lenny Sorey <lr...@fatdot.com> on 2003/12/28 17:04:45 UTC
[users@httpd] Fwd: Need Help - JDBC MySQL + Velocity - Apache 2.0.48 + Tomcat 4.1.29 + Mod_jk2 + Windows 2000 Server ( No IIS)
I couldn't tell if this email went through on 12/27/2003 when I sent it.
If it did, please accept my apologies.
Thanks for your help.
Lenny Sorey
==================BEGIN FORWARDED MESSAGE==================
>From: "Lenny Sorey" <lr...@fatdot.com>
>To: "Tomcat Users Group" <to...@jakarta.apache.org>
>Cc: "Apache HTTP Users List" <us...@httpd.apache.org>
>Date: Sat, 27 Dec 2003 19:02:11 -0600
>Priority: Normal
>X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.0.2195;3)
>MIME-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>Subject: Need Help - JDBC MySQL + Velocity - Apache 2.0.48 + Tomcat 4.1.29 + Mod_jk2 + Windows 2000 Server ( No IIS)
>
I currently have Apache 2.0.48 + Tomcat 4.1.29 + Mod_jk2 + Windows 2000 Server ( No IIS) partially working. I get the static
content served via http://mysite. This displays the index.jsp which has not database connection.
First of all, I will have to share two web sites with one IP address.
The problem starts when I try to connect to a page that connect to a 4.1 MySQL database table. I can access everything normally when I use
http://mysite:8080/mscarloans/index.jsp as well as when I use http://mysite:8080/mscarloans/creditapp.jsp.
I can access the index.jsp, testamonies.jsp static pages from http://mysite/index.jsp or http://mysite/testamonies.jsp.
I cannot access any of the jsp pages that have a database connection. I keep getting a org.apache.jasper.JasperException: IO Problems
Is there some additional configuration in workers2.properties for a jdbc connection. I am currently connecting to MySQL
4.1 thought a properties file with the following jdbc:mysql://mysite/mscarcredit.
In addition, on bannersite, I cannot connect at all when I use http://bannersite, I can connect when I use http://bannersite:8080.
I have a jsp that redirects index.jsp to login.vm. Is there a special configuration in workers2.properties where Velocity is used.
I have many *.vm templates that are used in this site. In addition, I am using Mysql 4.10 where I'm using mysql-connector-java-3.0.9-stable-bin.jar
to connect to my Mysql database via Hibernate.
I realize that I've furnished my configuration many times, but I feel with each answer I get back that I'm coming that much closer to success.
Thanks for all y'alls help.
Lenny Sorey
Here's the platform that I am using:
Windows 2000 Server - no IIS
Tomcat 4.1.29
Apache Http Server 2.0.48
Mod_jk2 or jakarta-tomcat-connectors-jk2.0.2-win32-apache2.0.43.zip
J2SDK 1.4.2
MySQL 4.1.0
mysql-connector-java-3.0.9-stable-bin.jar
Here's my configuration for my server:
jk2.properties - located in d:/java/Tomcat41/conf
***************************************************************************************************************************************************************************************
*
#
# Socket configuration
#
handler.list=request,container,channelSocket
#
# socket configuration
#
channelSocket.port=8009
channelSocket.address=127.0.0.1
channelSocket.maxPort=port+10
***************************************************************************************************************************************************************************************
**
end - jk2.properties
workers2.properties - located in d:/java/Apache2/conf
***************************************************************************************************************************************************************************************
**
#
# basic workers2.properties file
#
#
# shared memory
#
[shm]
file=D:/java/Apache2/logs/shm.file
size=1048576
[workerEnv:]
info=Global server options
timing=1
debug=0
#
# IP socket channel
#
[channel.socket:localhost:8009]
port=8009
host=127.0.0.1
#
# define the ajp13 worker
#
[ajp13:localhost:8009]
channel=channel.socket:localhost:8009
#
# Uri mapping examples - jsp files only
#
#[uri:/examples/*.jsp]
#worker=ajp13:localhost:8009
#
# Uri mapping examples - all servlets
#
#[uri:/examples/servlet/*]
#worker=ajp13:localhost:8009
[uri:mysite/]
info=Example webapp in the default context.
context=/mscarloans
debug=0
[uri:mysite/*.jsp]
worker=ajp13:localhost:8009
info=Extension mapping
[uri:mysite/*]
info=Map the whole webapp
[uri:mysite/webapp/*]
info=mysite data
#
#
[uri:bannersite/]
info=Example webapp in the default context.
context=/bs
debug=0
[uri:bannersite/*.jsp]
worker=ajp13:localhost:8009
info=Extension mapping
[uri:bannersite/*.vm]
worker=ajp13:localhost:8009
info=Map the whole webapp
[uri:bannersite/*.do]
worker=ajp13:localhost:8009
info=Map the whole webapp
[uri:bannersite/*]
worker=ajp13:localhost:8009
info=Map the whole webapp
[uri:bannersite/script]
info=Map the whole webapp
[uri:bannersite/click]
info=Map the whole webapp
[uri:bannersite/banner]
info=Map the whole webapp
[status:status]
[status:]
info=Status worker,displays run time informations
[uri:/jkstatus/*]
info=Display status information and checks the config file for changes.
worker=status:status
[uri:/status/*]
worker=status:status
***************************************************************************************************************************************************************************************
********************************************
end - workers2.properties
***************************************************************************************************************************************************************************************
*******************************************
ServerRoot "D:/java/Apache2"
PidFile logs/httpd.pid
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule mpm_winnt.c>
ThreadsPerChild 250
MaxRequestsPerChild 0
</IfModule>
Listen 80
LoadModule jk2_module modules/mod_jk2.dll
LoadModule access_module modules/mod_access.so
LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_module modules/mod_auth.so
#LoadModule auth_anon_module modules/mod_auth_anon.so
#LoadModule auth_dbm_module modules/mod_auth_dbm.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule autoindex_module modules/mod_autoindex.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule cgi_module modules/mod_cgi.so
#LoadModule dav_module modules/mod_dav.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule dir_module modules/mod_dir.so
LoadModule env_module modules/mod_env.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule file_cache_module modules/mod_file_cache.so
#LoadModule headers_module modules/mod_headers.so
LoadModule imap_module modules/mod_imap.so
LoadModule include_module modules/mod_include.so
#LoadModule info_module modules/mod_info.so
LoadModule isapi_module modules/mod_isapi.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
#LoadModule proxy_module modules/mod_proxy.so
#LoadModule proxy_connect_module modules/mod_proxy_connect.so
#LoadModule proxy_http_module modules/mod_proxy_http.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule negotiation_module modules/mod_negotiation.so
#LoadModule rewrite_module modules/mod_rewrite.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule speling_module modules/mod_speling.so
#LoadModule status_module modules/mod_status.so
#LoadModule unique_id_module modules/mod_unique_id.so
LoadModule userdir_module modules/mod_userdir.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so
#LoadModule ssl_module modules/mod_ssl.so
ServerAdmin lrsorey@fatdot.com
ServerName localhost:80
UseCanonicalName Off
#DocumentRoot "D:/java/Apache2/htdocs"
DocumentRoot "D:/java/Tomcat41/webapps"
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory "D:/java/Tomcat41/webapps">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>
UserDir "My Documents/My Website"
DirectoryIndex index.html index.jsp
AccessFileName .htaccess
<Files ~ "^\.ht">
Order allow,deny
Deny from all
</Files>
TypesConfig conf/mime.types
DefaultType text/plain
<IfModule mod_mime_magic.c>
MIMEMagicFile conf/magic
</IfModule>
HostnameLookups Off
ErrorLog logs/error.log
LogLevel warn
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
CustomLog logs/access.log common
ServerTokens Full
ServerSignature On
Alias /icons/ "D:/java/Apache2/icons/"
#Alias /examples/ "D:/java/Tomcat41/webapps/examples/"
#Alias /mscarloans/ "D:/java/Tomcat41/webapps/mscarloans/"
<Directory "D:/java/Apache2/icons">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
AliasMatch ^/manual(?:/(?:de|en|fr|ja|ko|ru))?(/.*)?$ "D:/java/Apache2/manual$1"
<Directory "D:/java/Apache2/manual">
Options Indexes
AllowOverride None
Order allow,deny
Allow from all
<Files *.html>
SetHandler type-map
</Files>
SetEnvIf Request_URI ^/manual/de/ prefer-language=de
SetEnvIf Request_URI ^/manual/en/ prefer-language=en
SetEnvIf Request_URI ^/manual/fr/ prefer-language=fr
SetEnvIf Request_URI ^/manual/ja/ prefer-language=ja
SetEnvIf Request_URI ^/manual/ko/ prefer-language=ko
SetEnvIf Request_URI ^/manual/ru/ prefer-language=ru
RedirectMatch 301 ^/manual(?:/(de|en|fr|ja|ko|ru)){2,}(/.*)?$ /manual/$1$2
</Directory>
ScriptAlias /cgi-bin/ "D:/java/Apache2/cgi-bin/"
<Directory "D:/java/Apache2/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>
IndexOptions FancyIndexing VersionSort
AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip
AddIconByType (TXT,/icons/text.gif) text/*
AddIconByType (IMG,/icons/image2.gif) image/*
AddIconByType (SND,/icons/sound2.gif) audio/*
AddIconByType (VID,/icons/movie.gif) video/*
AddIcon /icons/binary.gif .bin .exe
AddIcon /icons/binhex.gif .hqx
AddIcon /icons/tar.gif .tar
AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv
AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip
AddIcon /icons/a.gif .ps .ai .eps
AddIcon /icons/layout.gif .html .shtml .htm .pdf
AddIcon /icons/text.gif .txt
AddIcon /icons/c.gif .c
AddIcon /icons/p.gif .pl .py
AddIcon /icons/f.gif .for
AddIcon /icons/dvi.gif .dvi
AddIcon /icons/uuencoded.gif .uu
AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl
AddIcon /icons/tex.gif .tex
AddIcon /icons/bomb.gif core
AddIcon /icons/back.gif ..
AddIcon /icons/hand.right.gif README
AddIcon /icons/folder.gif ^^DIRECTORY^^
AddIcon /icons/blank.gif ^^BLANKICON^^
DefaultIcon /icons/unknown.gif
ReadmeName README.html
HeaderName HEADER.html
IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t
#
AddLanguage ca .ca
AddLanguage cs .cz .cs
AddLanguage da .dk
AddLanguage de .de
AddLanguage el .el
AddLanguage en .en
AddLanguage eo .eo
AddLanguage es .es
AddLanguage et .et
AddLanguage fr .fr
AddLanguage he .he
AddLanguage hr .hr
AddLanguage it .it
AddLanguage ja .ja
AddLanguage ko .ko
AddLanguage ltz .ltz
AddLanguage nl .nl
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pl .po
AddLanguage pt .pt
AddLanguage pt-BR .pt-br
AddLanguage ru .ru
AddLanguage sv .sv
AddLanguage zh-CN .zh-cn
AddLanguage zh-TW .zh-tw
LanguagePriority en ca cs da de el eo es et fr he hr it ja ko ltz nl nn no pl pt pt-BR ru sv zh-CN zh-TW
ForceLanguagePriority Prefer Fallback
AddDefaultCharset ISO-8859-1
#
AddCharset ISO-8859-1 .iso8859-1 .latin1
AddCharset ISO-8859-2 .iso8859-2 .latin2 .cen
AddCharset ISO-8859-3 .iso8859-3 .latin3
AddCharset ISO-8859-4 .iso8859-4 .latin4
AddCharset ISO-8859-5 .iso8859-5 .latin5 .cyr .iso-ru
AddCharset ISO-8859-6 .iso8859-6 .latin6 .arb
AddCharset ISO-8859-7 .iso8859-7 .latin7 .grk
AddCharset ISO-8859-8 .iso8859-8 .latin8 .heb
AddCharset ISO-8859-9 .iso8859-9 .latin9 .trk
AddCharset ISO-2022-JP .iso2022-jp .jis
AddCharset ISO-2022-KR .iso2022-kr .kis
AddCharset ISO-2022-CN .iso2022-cn .cis
AddCharset Big5 .Big5 .big5
# For russian, more than one charset is used (depends on client, mostly):
AddCharset WINDOWS-1251 .cp-1251 .win-1251
AddCharset CP866 .cp866
AddCharset KOI8-r .koi8-r .koi8-ru
AddCharset KOI8-ru .koi8-uk .ua
AddCharset ISO-10646-UCS-2 .ucs2
AddCharset ISO-10646-UCS-4 .ucs4
AddCharset UTF-8 .utf8
#
AddCharset GB2312 .gb2312 .gb
AddCharset utf-7 .utf7
AddCharset utf-8 .utf8
AddCharset big5 .big5 .b5
AddCharset EUC-TW .euc-tw
AddCharset EUC-JP .euc-jp
AddCharset EUC-KR .euc-kr
AddCharset shift_jis .sjis
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
AddHandler type-map var
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0
BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully
BrowserMatch "^WebDrive" redirect-carefully
BrowserMatch "^WebDAVFS/1.[012]" redirect-carefully
BrowserMatch "^gnome-vfs" redirect-carefully
<IfModule mod_ssl.c>
Include conf/ssl.conf
</IfModule>
NameVirtualHost 192.168.1.100:80
<VirtualHost 192.168.1.100:80>
ServerName mysite
ServerAdmin lrsorey@fatdot.com
DocumentRoot d:/java/Tomcat41/webapps/mscarloans
Alias /mscarloans/ "D:/java/Tomcat41/webapps/mscarloans/"
<Directory "D:/java/Tomcat41/webapps/mscarloans">
Options Indexes FollowSymLinks
DirectoryIndex index.jsp
</Directory>
<Location "/mscarloans/WEB-INF/*">
AllowOverride None
deny from all
</Location>
<Location "/mscarloans/META-INF/*">
AllowOverride None
deny from all
</Location>
<Directory "D:/java/Tomcat41/webapps/mscarloans/WEB-INF/">
AllowOverride None
deny from all
</Directory>
<Directory "D:/java/Tomcat41/webapps/mscarloans/META-INF/">
AllowOverride None
deny from all
</Directory>
<Location "/*.jsp">
JkUriSet worker ajp13:localhost:8009
</Location>
ErrorLog logs/mysite.log
CustomLog logs/mysite-access_log.log common
DirectoryIndex default.jsp index.jsp
</VirtualHost>
#
#
<VirtualHost 192.168.1.100:80>
ServerName bannersite
ServerAdmin lrsorey@fatdot.com
DocumentRoot d:/java/Tomcat41/webapps/bs
Alias /bs/ "D:/java/Tomcat41/webapps/bs/"
<Directory "D:/java/Tomcat41/webapps/bs">
Options Indexes FollowSymLinks
DirectoryIndex index.jsp login.vm
</Directory>
<Location "/bs/WEB-INF/*">
AllowOverride None
deny from all
</Location>
<Location "/bs/META-INF/*">
AllowOverride None
deny from all
</Location>
<Directory "D:/java/Tomcat41/webapps/bs/WEB-INF/">
AllowOverride None
deny from all
</Directory>
<Directory "D:/java/Tomcat41/webapps/bs/META-INF/">
AllowOverride None
deny from all
</Directory>
<Location "/*.jsp">
JkUriSet worker ajp13:localhost:8009
</Location>
ErrorLog logs/bannersite.log
CustomLog logs/bannersite-access_log.log common
DirectoryIndex default.jsp index.jsp
</VirtualHost>
***************************************************************************************************************************************************************************************
**************************************************
end - http.conf
***************************************************************************************************************************************************************************************
**************************************************
<!-- Example Server Configuration File -->
<Server port="8005" shutdown="SHUTDOWN" debug="0">
<!-- Uncomment these entries to enable JMX MBeans support -->
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
debug="0"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
debug="0"/>
<!-- Global JNDI resources -->
<GlobalNamingResources>
<!-- Test entry for demonstration purposes -->
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users -->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<!-- Define the Tomcat Stand-Alone Service -->
<Service name="Tomcat-Standalone">
<!-- Define a non-SSL Coyote HTTP/1.1 Connector on port 8081 -->
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="8080" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8443"
acceptCount="100" debug="0" connectionTimeout="20000"
useURIValidationHack="false" disableUploadTimeout="true" />
<!-- Note : To disable connection timeouts, set connectionTimeout value
to -1 -->
<!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="8009" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8443"
acceptCount="10" debug="0" connectionTimeout="20000"
useURIValidationHack="false"
protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"/>
<!-- Define the top level container in our container hierarchy -->
<Engine name="Standalone" defaultHost="localhost" debug="0">
<!-- Global logger unless overridden at lower levels -->
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<!-- Because this Realm is here, an instance will be shared globally -->
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
debug="0" resourceName="UserDatabase"/>
<!-- Define the default virtual host -->
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log." suffix=".txt"
timestamp="true"/>
<!-- Tomcat Root Context -->
<!-- Tomcat Examples Context -->
<Context path="/examples" docBase="examples" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_examples_log." suffix=".txt"
timestamp="true"/>
<Ejb name="ejb/EmplRecord" type="Entity"
home="com.wombat.empl.EmployeeRecordHome"
remote="com.wombat.empl.EmployeeRecord"/>
<Environment name="maxExemptions" type="java.lang.Integer"
value="15"/>
<Parameter name="context.param.name" value="context.param.value"
override="false"/>
<Resource name="jdbc/EmployeeAppDb" auth="SERVLET"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/EmployeeAppDb">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value></value></parameter>
<parameter><name>driverClassName</name>
<value>org.hsql.jdbcDriver</value></parameter>
<parameter><name>driverName</name>
<value>jdbc:HypersonicSQL:database</value></parameter>
</ResourceParams>
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"/>
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
<ResourceLink name="linkToGlobalResource"
global="simpleValue"
type="java.lang.Integer"/>
</Context>
</Host>
<Host name="mysite" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<!-- Start of mscarloans-->
<Context path="" docBase="mscarloans" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="mscarloans_log." suffix=".txt" timestamp="true" />
<Environment name="maxExemptions" type="java.lang.Integer" value="15" />
<Parameter name="context.param.name" value="context.param.value" override="false" />
<Resource name="mail/Session" auth="Container" type="javax.mail.Session" />
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
</Context>
<!-- End of mscarloans-->
</Host>
<Host name="bannersite" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<!-- Start of banners-->
<Context path="" docBase="bs" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="bs_log." suffix=".txt" timestamp="true" />
<Environment name="maxExemptions" type="java.lang.Integer" value="15" />
<Parameter name="context.param.name" value="context.param.value" override="false" />
<Resource name="mail/Session" auth="Container" type="javax.mail.Session" />
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
</Context>
<!-- End of banners-->
</Host>
</Engine>
</Service>
</Server>
***************************************************************************************************************************************************************************************
**************************************************
End - Server.xml
===================END FORWARDED MESSAGE===================
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org