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" <[EMAIL PROTECTED]> >To: "Tomcat Users Group" <[EMAIL PROTECTED]> >Cc: "Apache HTTP Users List" <[EMAIL PROTECTED]> >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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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=================== --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]