RE: Tomcat returns HTTP status of 200 when HttpServletResponse.sendError() called.
> From: Nathan Potter [mailto:n...@opendap.org] > Subject: Re: Tomcat returns HTTP status of 200 when > HttpServletResponse.sendError() called. > > docs > /docs > The above mapping is not useful; since it contains no wildcards, it can only be used as an exact match for the directory, and you've disabled directory listings. > In my web.xml it simply doesn't work. Are you seeing errors in the logs? What are you trying that "doesn't work"? What errors are you seeing? > It appears that no servlet is associated with > /docs or /docs/*. What leads you to that conclusion? > Interestingly my IDE can't seem to find the class Take the IDE out of the picture - run Tomcat by itself and see what happens. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat returns HTTP status of 200 when HttpServletResponse.sendError() called.
Chuck et. al, I tried the thing below, but Tomcat can't find the class: org.apache.catalina.servlets.DefaultServlet On this page of the Tomcat docs: http://tomcat.apache.org/tomcat-6.0-doc/default-servlet.html There is good infrormation but when I put this: docs org.apache.catalina.servlets.DefaultServletservlet-class> debug 0 listings false 1 ... docs /docs docs /docs/* In my web.xml it simply doesn't work. It appears that no servlet is associated with /docs or /docs/*. Interestingly my IDE can't seem to find the class, although it is used in $CATALINA_HOME/conf/web.xml Is there something else I need to do? Include or copy a jar file from somewhere? Nathan On Jan 14, 2009, at 9:20 PM, Caldarale, Charles R wrote: From: Nathan Potter [mailto:n...@opendap.org] Subject: Re: Tomcat returns HTTP status of 200 when HttpServletResponse.sendError() called. So do you mean something like this? default org.apache.catalina.servlets.DefaultServlet 1 default /err/* Yes, but I think you're going to have to change the value to something else so it doesn't conflict with the one in conf/ web.xml that's shared by all webapps. (It's been a while since I had to do this, but I seem to recall that was necessary to avoid ugly messages at startup.) And I place all of my default error pages in $CATALINA_HOME/webapps/myContext/err/ Yes. You could also use the same technique to have the DefaultServlet handle other static content if you want. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org = = = Nathan Potterndp at opendap.org OPeNDAP, Inc.541.752.1852
Re: PostgreSQL vs MySQL with Tomcat
Regarding MySQL's autoincrement type, it looks like PostgreSQL has something similar: http://www.postgresql.org/docs/8.3/interactive/datatype-numeric.html#DATATYPE-SERIAL I'm in the process of migrating a MySQL database to PostgrSQL. Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ken, Ken Bowen wrote: Unfortunately, MySQL isn't really that tunable. On the other hand, MySQL requires very little in the way of tuning! This was my comment, and that's the gist I got from reading Zawodny's and Balling's "High Performance MySQL" from O'Reilly. There are /some/ things you can tune, but not much. It's like an auto-adjusting clutch. Sure, you can adjust it, but it's going to do a pretty good job on its own. I created a couple of proof-of-concept projects with PostgreSQL for someone about six months ago, and the only really puzzling thing what how to set up "sequences" corresponding to MySQL's AUTOINCREMENT (I'm not sure I've really wrapped head around it completely anyway). For those small projects, it worked well, but there was no stress involved. I have no experience with PostgreSQL, but I was always irritated by lack of support (in previous JDBC specifications) for the AUTOINCREMENT fields (fixed, of course, in JDBC 1.4 when Statement.getGeneratedKeys was added). Oracle-style SEQUENCES always made more sense to me -- although they require an additional query to be issued every time you want a new id, you can use them for anything; not just record PKs. I think PostgreSQL has Oracle-style sequences. There are no auto-incrementing PKs or anything like that: you first SELECT the next value from the sequence, then use that as the PK for your INSERT that you issue immediately afterward. If you don't need to capture the new id from the code, you could probably even do this: INSERT INTO my_table (id, ...) VALUES ((SELECT next FROM my_sequence), ...) I have no idea if that would even work. Give it a try! I'd like to hear about people's experiences and what they think are the strengths and weaknesses of each DBMS for use behind Tomcat. MySQL has always had super good performance for me, especially using MyISAM tables. The addition of InnoDB tables was great because you got the relatively fast speed of MySQL (compared to, say, Oracle) with the integrity you really expect from a production-quality RDBMS. Since I'm not a DBA, I'm appreciated the fact that MySQL can often be a fire-and-forget kind of service. It just doesn't need much care and feeding. I remember my first job out of college required new engineering hires to go through their one-box-wonder runbooks to make sure we "understood how installs went and how the pieces fit together". Installing Apache Jserv (yeah!), httpd, and most everything else took about one or two printed pages of documentation. The rest of the runbook was Oracle install and configuration. Install. Run the command-line tool. Quit the command-line tool. Edit a config file. Re-run the command-line tool. Create the database. Quit the command-line tool. Change the rollback segment size. Etc. etc. etc. I never even understood anything I was doing, and neither did the folks that were supervising our execution of these tasks. These were just instructions that probably worked for someone in the past, so they wrote them down and nobody ever bothered to figure out if there were any better options. I was one of the first engineers who used MySQL in a project that went to production (and I had to implement my own pre-innodb manual rollback logic -- yikes!). MySQL supports a lot of functions that are, of course, outside the SQL standard, but are nonetheless useful. Here is what my MySQL driver (Connector/J 5.0.8) reports for the functions available to the client (server version is 5.0.70): Supported functions: Numeric: ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE String: ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER System: DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION Time/Date: DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC Some stuff is a bit far-fetched (SOUNDEX? come on...) but others are very useful (like the statistical functions, regular expressions, etc.). I definitely make use of these functions in my apps, even though they are MySQL-specific (I just mak
Re: JK connector fails with long URLs
Christopher Schultz-2 wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Br1, > > br1 wrote: >> Do you think this limit will be increased in the next versions? >> >> In theory, no limit is imposed by the protocol itself. I would tend to >> think >> JK should at least support what the JK supported platforms support. > > The source code /is/ available; you could try poking around for where > that limit is set. There are a lot of files, but grep could help. > > For instance, I found this (in jk 1.2.26): > > ./common/jk_uri_worker_map.h:#define JK_MAX_URI_LEN 4095 > > ..which could suggest that the max URL length is 4k, not 2k. Maybe > that's not the right setting. > > I can see this in the IIS source files: > > ./iis/jk_isapi_plugin.c:char uri[INTERNET_MAX_URL_LENGTH]; > > INTERNET_MAX_URL_LENGTH does not seem to be defined in mod_jk's source, > so it probably comes from IIS itself. Is it possible that IIS is the one > ruining your day? I don't know of a good IIS API resource, so you might > have to track this one down yourself. > > Just a thought. > - -chris > Hi Chris, Thank you for your reply. The key factor is: with the JK connector I get the error, without the JK connector I don't get the error. :-) As I said previously, it also shows up with non-JK redirected URLs, and it also comes out with just long query strings. For instance: /testalias/testpage.asp?param=[put 3000 "a"s here] The above works without the JK connector, but it does not work with the JK connector. I don't call it an IIS problem, I call it a JK connector problem. About recompiling, I am really not that good at this, and I would prefer not to take this responsibility.. I am quite protective with my prod servers. :-) Should this be a bug, I would prefer to wait someone that knows where to put his hands on the code. And avoid the need to correct and recompile every time a new version comes out.. Thank you for the hints, Br1. -- View this message in context: http://www.nabble.com/JK-connector-fails-with-long-URLs-tp21443475p21511740.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Writing a proxy transformation servlet.
Hi, I need to set up a proxy-server-with-transformation that frontends the clients and transforms the incoming request (HTTP post) and forwards it to the actual application server, and then get a response back and transforms it back into data format that the client understands and send it to the client. I am thinking of implementing this as a Servlet in tomcat (since the transformation code has to be Java). How should I go about doing this servlet ? Do I need to write a Servlet from scratch or is there a HttpProxyServlet or something similar that takes care of the proxy aspect which I can extend from and plug in my transformation code ? -thanks. -- View this message in context: http://www.nabble.com/Writing-a-proxy-transformation-servlet.-tp21511444p21511444.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
> From: Pid [mailto:p...@pidster.com] > Subject: Re: How to turn off JNDI datasource connection pooling > > I'm getting a little confused trying to follow this thread. There was a distinct lack of specifics in the beginning. However, I think I understand why he's doing this. As Keith mentioned, he's using a legacy DB that likely implements its own access restrictions based on credentials supplied on the connection. Once the connection is established, the credentials cannot be changed. When a new end-user logs in, that user will need a connection specific to that userid. (How do I know this? We've got the same situation on our mainframes.) > Keith: you want to use DataSources to define the location > of the DB via JNDI, but earlier you said you wanted to > supply authentication credentials on a per user basis. Those are not incompatible requirements. The DataSource interface includes a getConnection() method that takes a userid and password as arguments. > When you say 'per user' do you mean 'per client of my business', > or do you mean actual individual end-users of the application, > (the former I presume)? I think the latter; as mentioned above, most mainframe DBs do their own authentication and authorization checks. > I'm also not clear on why you're dead set against using connection > pooling, would you mind explaining? He actually said he might try pooling later, but if so, he'll need a pool per client userid, not a global one. (Been there, done that.) - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
Caldarale, Charles R wrote: >> From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] >> Subject: RE: How to turn off JNDI datasource connection pooling >> >> Look at the construct in the servlet spec. > > O.k., that was too simplistic. You'll also need the following. > > Does your DB driver include some factory class that creates Connnection > objects? (It should.) If so, you can specify that in the factory attribute > of the element in your webapp's . This will override > Tomcat's normal pooling factory. Make sure you set auth=Servlet in the > . > > If absolutely necessary, you can write a simple custom factory, as described > here: > http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#Adding%20Custom%20Resource%20Factories > > You might be able to get away with a element in web.xml to > further simplify things. I'm getting a little confused trying to follow this thread. Keith: you want to use DataSources to define the location of the DB via JNDI, but earlier you said you wanted to supply authentication credentials on a per user basis. When you say 'per user' do you mean 'per client of my business', or do you mean actual individual end-users of the application, (the former I presume)? I'm also not clear on why you're dead set against using connection pooling, would you mind explaining? Regards, p > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you received > this in error, please contact the sender and delete the e-mail and its > attachments from all computers. > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
On Fri, Jan 16, 2009 at 16:45, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Keith, > > Keith Thomas wrote: >> As part of the >> deployment I just need a way of defining the datasource in a manner that is >> external to my code and configurable by administrators. > > Use of a DataSource implies the use of a connection pool, which seems > contrary to your requirements. > > You will need to manage your own database connections. Why is that? From the Java docs, it seems that DataSource is required for connections that are managed by JNDI. Isn't the use of JNDI without pooling a valid use case? -- Len - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Tomcat Beginner - Step 2!
> From: g f [mailto:gfo...@gmail.com] > Subject: Re: Tomcat Beginner - Step 2! > > Change your port forwarding(virtual server) to forward port 80 (on the > outside) to port 8080 on the inside. If your router/modem doesn't support port forwarding, change the port in conf/server.xml to use 80 rather than 8080. You must restart Tomcat whenever you make changes to the server.xml file. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat Beginner - Step 2!
Your public address will be your wan ip address(ienot 192.168.0.101). Look in your dlink router config webpage under WAN and that will be your public ip address. Change your port forwarding(virtual server) to forward port 80 (on the outside) to port 8080 on the inside. If you kept tomcat config as is running on 8080, then your webservice url will be http://WAN_IP/mywebservice Flowchart: User navigates to: http://WAN_IP/mywebservice dlink forwards this to http://192.168.0.101:8080/mywebservice BTW, WAN_IP is a variable for what your actual public ip address is. 192.168.0.101 would be the ip address dlink router assigned your machine (assuming it was the only machine on your network). ipconfig will tell you your 192 address if different. Not sure about number 4. HTH On Sat, Jan 17, 2009 at 4:02 PM, Toriacht wrote: > > Hi, > > I have written my first web service which works fine and is visible at > //localhost:8080/mywebservice. I still can't make it publicly visible. > > I have a beginner few questions. > > 1. What is the default public address of my tomcat server, and the > applications on it. Is it just my external IP address/applicationName? Does > the address include port number? > > 2. I am connected thru a DLink wireless modem to my ISP modem. My ISP modem > is v simple and lets all thru. I enabled Virtual Server Http on my wireless > modem, public port 80, private port 80 and associated with my 192.x.x > address > > I edited my Windows firewall to allow tomcat still nothing. > > 3. What other steps do I have to take to make my Tomcat publicly visible..? > > 4. I am intermittently getting a jvm_bind error. Is this because I'm > not shutting Tomcat down properly? What steps should be taken to avoid this > error? > > Thanks, > T > -- > View this message in context: > http://www.nabble.com/Tomcat-Beginner---Step-2%21-tp21509364p21509364.html > Sent from the Tomcat - User mailing list archive at Nabble.com. > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
Tomcat Beginner - Step 2!
Hi, I have written my first web service which works fine and is visible at //localhost:8080/mywebservice. I still can't make it publicly visible. I have a beginner few questions. 1. What is the default public address of my tomcat server, and the applications on it. Is it just my external IP address/applicationName? Does the address include port number? 2. I am connected thru a DLink wireless modem to my ISP modem. My ISP modem is v simple and lets all thru. I enabled Virtual Server Http on my wireless modem, public port 80, private port 80 and associated with my 192.x.x address I edited my Windows firewall to allow tomcat still nothing. 3. What other steps do I have to take to make my Tomcat publicly visible..? 4. I am intermittently getting a jvm_bind error. Is this because I'm not shutting Tomcat down properly? What steps should be taken to avoid this error? Thanks, T -- View this message in context: http://www.nabble.com/Tomcat-Beginner---Step-2%21-tp21509364p21509364.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith, Keith Thomas wrote: > As part of the > deployment I just need a way of defining the datasource in a manner that is > external to my code and configurable by administrators. Use of a DataSource implies the use of a connection pool, which seems contrary to your requirements. You will need to manage your own database connections. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklw/+wACgkQ9CaO5/Lv0PA2bACdFqZzxKv//wdveAETdrowl3KR ZF8AnApwQvz5L6Xxw2rdQi0h9eU4nxYH =HwS0 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: PostgreSQL vs MySQL with Tomcat
As far as schemas in Postgres go, a normal way to handle them is to create schema-specific users with an appropriately-set default schema, e.g. something like: CREATE SCHEMA company_a ; CREATE USER company_a_user PASSWORD 'foo' ; ALTER USER company_a_user SET search_path TO company_a, public ; GRANT USAGE ON SCHEMA company_a TO company_a_user ; -- ...or (I think) GRANT ALL PRIVILEGES ON SCHEMA company_a TO company_a_user On Fri, Jan 16, 2009 at 3:28 PM, Rusty Wright wrote: > That may be true about the public schema being used when one isn't > specified. But when I use their pgAdmin gui tool and open the query window > and try to run the tiger sample from the Jailer tutorial it blows up on the > table creates, saying: > > ERROR: no schema has been selected to create in > > ** Error ** > > ERROR: no schema has been selected to create in > SQL state: 3F000 > > I wonder if iBatis is adding the public schema automatically for you? Or > maybe when I set up my db account I didn't do something I should have? Or I > changed something and don't remember. > > And you've prompted me to remember another reason why I thought schemas are > required. > > When our DBA set up PostgreSQL he didn't do much tweaking and the public > schema had odd permissions; if I remember correctly it allowed me to create > tables in the databases of other users in their public schema. I didn't try > dropping their tables in their public schema but it may have allowed that as > well. > > On my test db the sql for the public schema is > > CREATE SCHEMA public > AUTHORIZATION postgres; > GRANT ALL ON SCHEMA public TO postgres; > COMMENT ON SCHEMA public IS 'Standard public schema'; > > Just after I installed postgres it had another grant line which I think was > (or similar to) "GRANT ALL ON SCHEMA public TO public;" which I deleted (and > in my usual boneheaded fashion, forgot to document my change, but it's my > personal test database). > > > > Ingmar Lötzsch wrote: > >> Some comments (and answers to Christopher and Rusty) on PostgreSQL: >> >> ... >> >> This isn't true. You can (and perhaps should) always omit the schema. >> The default schema "public" is used in this case. You can execute >> > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
RE: How to turn off JNDI datasource connection pooling
> From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] > Subject: RE: How to turn off JNDI datasource connection pooling > > Look at the construct in the servlet spec. O.k., that was too simplistic. You'll also need the following. Does your DB driver include some factory class that creates Connnection objects? (It should.) If so, you can specify that in the factory attribute of the element in your webapp's . This will override Tomcat's normal pooling factory. Make sure you set auth=Servlet in the . If absolutely necessary, you can write a simple custom factory, as described here: http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#Adding%20Custom%20Resource%20Factories You might be able to get away with a element in web.xml to further simplify things. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
> From: Caldarale, Charles R > Subject: RE: How to turn off JNDI datasource connection pooling > > Make sure you set auth=Servlet in the . That should be auth="Application". - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
> From: Keith Thomas [mailto:keith.tho...@gmail.com] > Subject: Re: How to turn off JNDI datasource connection pooling > > I just want to be able to define the datasource using JNDI so > it is external to my application. That's another piece of information you haven't supplied before. Look at the construct in the servlet spec. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
Thanks Jan. I don't want to use Tomcat's database pool, I just want to be able to define the datasource using JNDI so it is external to my application. I am doing this for various web servers and I'm beginning to think I will have to tell my customers Tomcat does not support JNDI datasource definition without also bringing along database connection pooling so they cannot use Tomcat. -- View this message in context: http://www.nabble.com/How-to-turn-off-JNDI-datasource-connection-pooling-tp21490681p21507767.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: PostgreSQL vs MySQL with Tomcat
That may be true about the public schema being used when one isn't specified. But when I use their pgAdmin gui tool and open the query window and try to run the tiger sample from the Jailer tutorial it blows up on the table creates, saying: ERROR: no schema has been selected to create in ** Error ** ERROR: no schema has been selected to create in SQL state: 3F000 I wonder if iBatis is adding the public schema automatically for you? Or maybe when I set up my db account I didn't do something I should have? Or I changed something and don't remember. And you've prompted me to remember another reason why I thought schemas are required. When our DBA set up PostgreSQL he didn't do much tweaking and the public schema had odd permissions; if I remember correctly it allowed me to create tables in the databases of other users in their public schema. I didn't try dropping their tables in their public schema but it may have allowed that as well. On my test db the sql for the public schema is CREATE SCHEMA public AUTHORIZATION postgres; GRANT ALL ON SCHEMA public TO postgres; COMMENT ON SCHEMA public IS 'Standard public schema'; Just after I installed postgres it had another grant line which I think was (or similar to) "GRANT ALL ON SCHEMA public TO public;" which I deleted (and in my usual boneheaded fashion, forgot to document my change, but it's my personal test database). Ingmar Lötzsch wrote: Some comments (and answers to Christopher and Rusty) on PostgreSQL: ... This isn't true. You can (and perhaps should) always omit the schema. The default schema "public" is used in this case. You can execute - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
I am managing the database connection credentials because this is the only way to access this legacy database. Otherwise I have very little code because Hibernate takes care of all the heavy lifting. As part of the deployment I just need a way of defining the datasource in a manner that is external to my code and configurable by administrators. I am trying JNDI as my standard because this has various levels of security of db uid/pw from web server to web server. If I fallback to using spring/hibernate xml to configure the datasource then my customers will always have to decide if they can live with the uid/pw being stored in a clear text xml file before taking my app. -- View this message in context: http://www.nabble.com/How-to-turn-off-JNDI-datasource-connection-pooling-tp21490681p21507739.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Multi-level context broken in Tomcat 6.0.18?
> From: jclark42796 [mailto:jclark42...@gmail.com] > Subject: Multi-level context broken in Tomcat 6.0.18? > > Everything works ok and the app is deployed in > C:\tomcat-5.5.20\webapps\abc.gov\wiki I think "working" in this case was accidental. > However, when I tried doing the same thing w/ 6.0.18, the > deployed file structure is this: > C:\apache-tomcat-6.0.18\webapps\abc.gov#wiki That is where it should be for 6.0.18. > and the app fails to deploy. What messages do you see in the log concerning the deployment? - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
Dear Keith, It's not clear what you want to do (as opposed to what you don't want to do). Is your goal to use a >> new DB connection for every DB access your webapp makes, or do you want to do DB connection >> pooling inside your webapp, or ??? Not using connection pooling at all is a real performance killer. - Chuck The security for the data within the database is entirely baked into the restriction that every user has their own database connection. As far as I can tell it is not possible to use connection pooling a retain secure access to the data without an awful lot of re-work. At the moment I am using a new DB connection for every DB access my app makes. Later I may implement my own database polling but either way it will be my code initiating connection requests not Tomcat's. Setting maxactive to zero stops exceptions but the app just seems to be hanging. Two options that I see: 1) Why are you still using Tomcat's pool at all? Just create your own connections in the code. Instead of each lookup just do the old "driver.createConnection()" etc. Where driver is some static somewhere. 2) Write a trivial connection pool and drop it into the Tomcat lib. Use the new Tomcat JDBC pool code as a starting point. -- Kees Jan http://java-monitor.com/forum/ kjkos...@kjkoster.org 06-51838192 The secret of success lies in the stability of the goal. -- Benjamin Disraeli - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
> From: Keith Thomas [mailto:keith.tho...@gmail.com] > Subject: RE: How to turn off JNDI datasource connection pooling > > The security for the data within the database is entirely > baked into the restriction that every user has their own > database connection. >From the DB server perspective, the only "user" is whatever userid Tomcat is >running under. Or are you passing credentials on every DB connection? If so, >where do you get the credentials from? If you don't want to use pooling at all, you'll need to use the DB connection creation methods directly in your webapp - which seems to be a major step backwards. Security in a servlet container environment is normally provided by specifying appropriate role names and URL patterns in the webapp's WEB-INF/web.xml file. If you're rolling your own instead, you're doing a ton of extra work, and not taking advantage of the capabilities an app server provides. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Multi-level context broken in Tomcat 6.0.18?
I've been deploying under Tomcat 5.5.20 where my context is located here: C:\tomcat-5.5.20\conf\Catalina\localhost\abc.gov#wiki.xml Everything works ok and the app is deployed in C:\tomcat-5.5.20\webapps\abc.gov\wiki However, when I tried doing the same thing w/ 6.0.18, the deployed file structure is this: C:\apache-tomcat-6.0.18\webapps\abc.gov#wiki and the app fails to deploy. As far as I know the documentation says this should still work.Should I be doing something different w/ tomcat 6? Thanks, Jim -- View this message in context: http://www.nabble.com/Multi-level-context-broken-in-Tomcat-6.0.18--tp21507526p21507526.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
>> It's not clear what you want to do (as opposed to what you don't want to do). Is your goal to use a >> new DB connection for every DB access your webapp makes, or do you want to do DB connection >> >> pooling inside your webapp, or ??? >> Not using connection pooling at all is a real performance killer. >> - Chuck The security for the data within the database is entirely baked into the restriction that every user has their own database connection. As far as I can tell it is not possible to use connection pooling a retain secure access to the data without an awful lot of re-work. At the moment I am using a new DB connection for every DB access my app makes. Later I may implement my own database polling but either way it will be my code initiating connection requests not Tomcat's. Setting maxactive to zero stops exceptions but the app just seems to be hanging. -- View this message in context: http://www.nabble.com/How-to-turn-off-JNDI-datasource-connection-pooling-tp21490681p21507284.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to turn off JNDI datasource connection pooling
> From: Keith Thomas [mailto:keith.tho...@gmail.com] > Subject: Re: How to turn off JNDI datasource connection pooling > > provided enough explanation but what I want is for Tomcat > to keep out of connection creation It's not clear what you want to do (as opposed to what you don't want to do). Is your goal to use a new DB connection for every DB access your webapp makes, or do you want to do DB connection pooling inside your webapp, or ??? Not using connection pooling at all is a real performance killer. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
Apologies if I don't understand how a jndi datasource should work or if I've not provided enough explanation but what I want is for Tomcat to keep out of connection creation. Even if I have maxactive set to 1 I still get a stacktrace like this, at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) ... 16 more Everything works fine if I don't use JNDI and I really don't understand why these dbcp classes with Pool or Pooling in the name are getting involved. -- View this message in context: http://www.nabble.com/How-to-turn-off-JNDI-datasource-connection-pooling-tp21490681p21506964.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: setup default webapp in tomcat 6 and apache
> From: johnrock [mailto:johnpi...@yahoo.com] > Subject: RE: setup default webapp in tomcat 6 and apache > > What is the best way to configure/deploy an app so that it > will be accessed from the url: > http://localhost/index.jsp There's nothing wrong with the way you're doing it, and there are certain advantages to keeping your webapps outside of Tomcat's directory structure (e.g., somewhat easier to update Tomcat versions). However, as pid pointed out, the typical way to deploy a webapp is to place its .war file or directory immediately under the appBase directory. The default webapp *must* be named ROOT (upper case), so that's why using /ROOT.war or /ROOT or conf/Catalina/localhost/ROOT.xml is necessary to achieve what you want. Note that a webapp is more than just an index.jsp file; there's a whole directory structure that can be used for complex ones, as defined in the servlet spec. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: setup default webapp in tomcat 6 and apache
johnrock wrote: > > Caldarale, Charles R wrote: >>> Isn't this a very standard thing to do? >> No; one normally deploys webapps under the appBase. >> - Chuck >> > > Ok, I would like to follow the normal, best practices way. If you will > indulge me one more try: > > What is the best way to configure/deploy an app so that it will be accessed > from the url: > http://localhost/index.jsp > > call the webapp by the special, case-sensitive name "ROOT", ROOT.war if you're deploying war files. p - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: setup default webapp in tomcat 6 and apache
Caldarale, Charles R wrote: > >> Isn't this a very standard thing to do? > > No; one normally deploys webapps under the appBase. > - Chuck > Ok, I would like to follow the normal, best practices way. If you will indulge me one more try: What is the best way to configure/deploy an app so that it will be accessed from the url: http://localhost/index.jsp -- View this message in context: http://www.nabble.com/setup-default-webapp-in-tomcat-6-and-apache-tp21488197p21505190.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [OT] Tomcat 6.x security-constraint redirection problem... please help!
Christopher Schultz wrote: > Pid, > > Pid wrote: >> I have an app with a page which contains a flash object (displays a nice >> graph) that calls a groovy script periodically to get data. > >> If the user session times out in between requests for the script then >> when it's requested it's the first one after de-auth, so it becomes the >> target that is re-established after re-login, (obviously not useful for >> users). > > I have a part of my application served by Cocoon which calls-back the > "real" application to get XML data. What I've done is put the > XML-generating URLs into an unprotected space. These servlets (Struts > actions, actually) do their own (mild) checking to see if the user is > authenticated and authorized before returning the data. Otherwise, they > return appropriate XML-formatted data that says "no credentials". > > Here's where things would be different for you and me, because I use > securityfilter. I simply show a login page directly from Cocoon, make > the action="j_security_check" and set a special "forward_to" URL > parameter that tells securityfilter to redirect the user back to the > page they originally requested (tricky, eh?). > > In your case, you could redirect the user to some other page (like a > trampoline page), Tomcat would demand credentials in the meantime, and > then the trampoline would send the user back to your page with the flash > movie. > > Would that work for you? It may indeed. It's worth a try anyway - thanks - as my attempts to inform Javascript/Flash of the session expiry time are producing unfortunately uneven results. p > -chris - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Dara P Maginnis/IR/AIB is out of the office.
André Warnier wrote: > #12 : make sure that the Tomcat users list gets your absentee email > notifications. #12a : Especially if all you're doing is announcing that you're not working at the weekend. p > dara.p.magin...@aib.ie wrote: >> I will be out of the office starting 16/01/2009 and will not return >> until >> 18/01/2009. >> >> I will out of the office and will action my mails on my return >> >> >> Dara.P.Maginnis >> AIB IFS >> IT >> AIB International Centre, IFSC >> 6417986 >> > [...] > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to know when tomcat was started/stopped?
> From: uddav [mailto:adi.upr...@gmail.com] > Subject: RE: How to know when tomcat was started/stopped? > > I looked into both the files and wasn't able to tell what > wordings were pointing to shutdown and what to startup. You didn't bother to tell us what version of Tomcat you're using (or the platform you're running on), so the following is based on current levels. If you're on an older level (e.g., 4.1) you'll need help from someone else, since I've never used it (or your could upgrade). The catalina.out file is not used by Tomcat; it doesn't exist at all on Windows, and on Linux it's simply a redirect of System.out and System.err to catch print statements in applications too lazy to use proper logging. The localhost.-mm-dd.log contains only log messages generated by the components inside Tomcat; it's not the one you want. What you do want to look at is catalina.-mm-dd.log; the messages in there should be fairly self-explanatory. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to know when tomcat was started/stopped?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 uddav, uddav wrote: > The logs directory as i see it has two types of file. > One of the types is "localhost_log.-MM-DD.txt" which looks like being > generated one for each day and updated regularly through out the day where > as another one is "catalina.out". > > I looked into both the files and wasn't able to tell what wordings were > pointing to shutdown and what to startup. I apologize , i am novice in this > area. You want catalina.out. After successful startup, you should see these lines (possibly among others, such as connector startup messages). Jan 16, 2009 7:41:28 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 7944 ms when you shut down, you should see this: Jan 16, 2009 7:42:12 AM org.apache.catalina.core.StandardService stop INFO: Stopping service Catalina (Then I get an APR shutdown error, since I'm not using APR). Hope that helps, - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklwuQMACgkQ9CaO5/Lv0PAkCwCeKP3S0Pydt2mir7TBRVlMx7ki u3IAoJq9eqAKmRFbM4V8VSRI+QUPVfB2 =hqlU -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JK connector fails with long URLs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Br1, br1 wrote: > Do you think this limit will be increased in the next versions? > > In theory, no limit is imposed by the protocol itself. I would tend to think > JK should at least support what the JK supported platforms support. The source code /is/ available; you could try poking around for where that limit is set. There are a lot of files, but grep could help. For instance, I found this (in jk 1.2.26): ./common/jk_uri_worker_map.h:#define JK_MAX_URI_LEN 4095 ..which could suggest that the max URL length is 4k, not 2k. Maybe that's not the right setting. I can see this in the IIS source files: ./iis/jk_isapi_plugin.c:char uri[INTERNET_MAX_URL_LENGTH]; INTERNET_MAX_URL_LENGTH does not seem to be defined in mod_jk's source, so it probably comes from IIS itself. Is it possible that IIS is the one ruining your day? I don't know of a good IIS API resource, so you might have to track this one down yourself. Just a thought. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklwtM4ACgkQ9CaO5/Lv0PCBeQCfYaiXgWD3DFyPg5sey4gXGlqH CxcAnijSP/NX/+bbNxWh3ilJWA2381Sv =nvXT -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat 6.x security-constraint redirection problem... please help!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pid, Pid wrote: > I have an app with a page which contains a flash object (displays a nice > graph) that calls a groovy script periodically to get data. > > If the user session times out in between requests for the script then > when it's requested it's the first one after de-auth, so it becomes the > target that is re-established after re-login, (obviously not useful for > users). I have a part of my application served by Cocoon which calls-back the "real" application to get XML data. What I've done is put the XML-generating URLs into an unprotected space. These servlets (Struts actions, actually) do their own (mild) checking to see if the user is authenticated and authorized before returning the data. Otherwise, they return appropriate XML-formatted data that says "no credentials". Here's where things would be different for you and me, because I use securityfilter. I simply show a login page directly from Cocoon, make the action="j_security_check" and set a special "forward_to" URL parameter that tells securityfilter to redirect the user back to the page they originally requested (tricky, eh?). In your case, you could redirect the user to some other page (like a trampoline page), Tomcat would demand credentials in the meantime, and then the trampoline would send the user back to your page with the flash movie. Would that work for you? - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklwsooACgkQ9CaO5/Lv0PB1tACgiB5j2sIWXOU+kpMzYAqkOr+V ny4AoJmlQVdeBOM8wtiGh0YFC8030M1F =zKqx -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to know when tomcat was started/stopped?
Thank you for pointing it out. The logs directory as i see it has two types of file. One of the types is "localhost_log.-MM-DD.txt" which looks like being generated one for each day and updated regularly through out the day where as another one is "catalina.out". I looked into both the files and wasn't able to tell what wordings were pointing to shutdown and what to startup. I apologize , i am novice in this area. uddav Caldarale, Charles R wrote: > >> From: uddav [mailto:adi.upr...@gmail.com] >> Subject: How to know when tomcat was started/stopped? >> >> Is there a way to know when tomcat was started/stopped >> manually by using the startup and shutdown scripts? > > It's in the Tomcat logs. > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you > received this in error, please contact the sender and delete the e-mail > and its attachments from all computers. > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/How-to-know-when-tomcat-was-started-stopped--tp21502265p21502799.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Address already in use: JVM_Bind /87.230.103.25:80
great, I just needed to remove CATALINA_HOME works now ok, many thanks! Caldarale, Charles R wrote: > >> From: kareda [mailto:k...@digiplace.ch] >> Subject: RE: Address already in use: JVM_Bind /87.230.103.25:80 >> >> there is a system variable set to the first tomcat binary >> instance that runs as service (tomcat #1): >> CATALINA_HOME=C:\apache-tomcat-6.0.18 > > You can safely remove that - the service does not use environment > variables. > >> I can't define another system variable CATALINA_HOME I guess? > > You can override the existing one by replacing it in the command prompt > session before calling the catalina.bat script. However, you don't need > the CATALINA_HOME variable for the service, so just get rid of the system > variable. > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you > received this in error, please contact the sender and delete the e-mail > and its attachments from all computers. > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Address-already-in-use%3A-JVM_Bind--87.230.103.25%3A80-tp21477831p21502778.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: How to turn off JNDI datasource connection pooling
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith, Keith Thomas wrote: > I have an application that runs against a legacy database. For reasons I > won't go into here I need to turn off jndi datasource connection pooling. I > have been unsuccessful finding documentation or mailing list entries on how > to do this. Which part of the pool do you need to get rid of: 1. Multiple connections? Easy: just set maxActive="1" 2. Connection re-use? See #3. 3. The DataSource itself? Easy: just change your getConnection method from using JNDI to using DriverManager, etc. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklwsMUACgkQ9CaO5/Lv0PBmowCeLwHoeeL/chOVGLoTNHgiqV8I sj4AnRs1hx6kU5ab8SAHYdgu7VzdHT6w =diju -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: setup default webapp in tomcat 6 and apache
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, johnrock wrote: > # send all requests ending in .jsp to worker1 > JkMount /*.jsp worker1 > # send all requests ending /servlet to worker1 > JkMount /*/servlet/ worker1 [snip] > What I am trying to do is very simple, but I am confused of course. > apache document root is: > DocumentRoot "C:/perfroot/depot/myApp/web" > > So if you go to http://localhost you will be served > "C:/perfroot/depot/myApp/web/index.html". That works fine. > What I want to happen is that if you go to http://localhost/index.jsp tomcat > should serve > C:/perfroot/depot/myApp/web/index.jsp Where have you deployed your web application (that is, where is your WEB-INF directory)? If you've deployed to /perfroot/depot/myApp/web then your webapp is probably called "web" as far as Tomcat is concerned. $TOMCAT_HOME/conf/server.xml contains a element which specifies where applications "usually" live. Have you altered that? If not, you may want to either alter that to point to /perfroot/depoy/myapp/web or, better yet, create a context.xml file and put it in TOMCAT_HOME/conf/[enginename]/[hostname]/ROOT.xml. See http://tomcat.apache.org/tomcat-6.0-doc/config/context.html for details on how to create elements in context.xml files. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklvyN8ACgkQ9CaO5/Lv0PBPPgCfVZvjJ01U/wF6ThbER5Ds1fWb ZsMAn1q1w3epNOUvj+dta++LIt/FoG9r =bIJE -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: How to know when tomcat was started/stopped?
> From: uddav [mailto:adi.upr...@gmail.com] > Subject: How to know when tomcat was started/stopped? > > Is there a way to know when tomcat was started/stopped > manually by using the startup and shutdown scripts? It's in the Tomcat logs. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Address already in use: JVM_Bind /87.230.103.25:80
> From: kareda [mailto:k...@digiplace.ch] > Subject: RE: Address already in use: JVM_Bind /87.230.103.25:80 > > there is a system variable set to the first tomcat binary > instance that runs as service (tomcat #1): > CATALINA_HOME=C:\apache-tomcat-6.0.18 You can safely remove that - the service does not use environment variables. > I can't define another system variable CATALINA_HOME I guess? You can override the existing one by replacing it in the command prompt session before calling the catalina.bat script. However, you don't need the CATALINA_HOME variable for the service, so just get rid of the system variable. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
How to know when tomcat was started/stopped?
Hello everyone, Is there a way to know when tomcat was started/stopped manually by using the startup and shutdown scripts? I suggestions/ideas/recomendations in this direction would be greatly appreciated. Thanks in advance uddav -- View this message in context: http://www.nabble.com/How-to-know-when-tomcat-was-started-stopped--tp21502265p21502265.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Address already in use: JVM_Bind /87.230.103.25:80
there is a system variable set to the first tomcat binary instance that runs as service (tomcat #1): CATALINA_HOME=C:\apache-tomcat-6.0.18 The issue I have with the second tomcat binary instance (tomcat #2): C:\digiplace\test2\apache-tomcat-6.0.18 yes, in 'catalina.bat run' output for tomcat #2 I have the wrong paths: Using CATALINA_BASE: C:\apache-tomcat-6.0.18 Using CATALINA_HOME: C:\apache-tomcat-6.0.18 I can't define another system variable CATALINA_HOME I guess? Where should I define a new CATALINA_BASE? I see it in many places in catalina.bat many thanks for the help! Caldarale, Charles R wrote: > >> From: kareda [mailto:k...@digiplace.ch] >> Subject: Re: Address already in use: JVM_Bind /87.230.103.25:80 >> >> it's probably using the server.xml from the other tomcat installation, >> right? strange.. what may cause this? > > What is your current directory when you run catalina.bat? > > What environment variables do you have set when you run catalina.bat? > > If CATALINA_HOME or CATALINA_BASE is set, the script will use those rather > than the current directory. > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you > received this in error, please contact the sender and delete the e-mail > and its attachments from all computers. > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Address-already-in-use%3A-JVM_Bind--87.230.103.25%3A80-tp21477831p21502171.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Dara P Maginnis/IR/AIB is out of the office.
#12 : make sure that the Tomcat users list gets your absentee email notifications. dara.p.magin...@aib.ie wrote: I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 [...] - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Address already in use: JVM_Bind /87.230.103.25:80
> From: kareda [mailto:k...@digiplace.ch] > Subject: Re: Address already in use: JVM_Bind /87.230.103.25:80 > > it's probably using the server.xml from the other tomcat installation, > right? strange.. what may cause this? What is your current directory when you run catalina.bat? What environment variables do you have set when you run catalina.bat? If CATALINA_HOME or CATALINA_BASE is set, the script will use those rather than the current directory. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Address already in use: JVM_Bind /87.230.103.25:80
kareda: > thanks for the tip. indeed, the server.xml is not used at all. I removed it > completely from the conf dir and when I ran catalina.bat run, the log output > didn't change at all - still the same error. > I have another tomcat instance on the same server, running as a service. so > it's probably using the server.xml from the other tomcat installation, > right? Maybe, I don't know. > strange.. what may cause this? Among the first lines printed when you start Tomcat by using catalina.bat run should be the values of CATALINA_HOME and CATALINA_BASE. Are these (especially CATALINA_BASE) what you'd expect them to be - i. e. do the point to the dir where the Tomcat you just started is located? If not, is one or both of them already set in your environment? Regards mks - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Address already in use: JVM_Bind /87.230.103.25:80
On Fri, Jan 16, 2009 at 3:41 PM, kareda wrote: > > > right? strange.. what may cause this? > Eclipse's Tomcat-plugin. Check out ${your_workspace}\Servers\... and appropriate sub-directories. Cheers Gregor -- just because your paranoid, doesn't mean they're not after you... gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat Bug-database not accepting any new registrations?
Hi Mark actually I sent my answer directly to your account at apache.org since I don't want my email-adress to show up in the mailing-list. To be on the safe side: The email I used was "myem...@googlemail.com" where "myemail" has to be replaced with my real Googlemail-account. Is it possible that Tomcat's bugzilla doesn't accept registrations from googlemail? TIA Gregor -- just because your paranoid, doesn't mean they're not after you... gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Address already in use: JVM_Bind /87.230.103.25:80
thanks for the tip. indeed, the server.xml is not used at all. I removed it completely from the conf dir and when I ran catalina.bat run, the log output didn't change at all - still the same error. I have another tomcat instance on the same server, running as a service. so it's probably using the server.xml from the other tomcat installation, right? strange.. what may cause this? tnx, Kaur Markus Schönhaber-10 wrote: > > kareda: > > You did the right thing. If Tomcat still tries to bind to port 80, make > sure that > a) there's no other configured to listen on port 80, > b) Tomcat really uses the server.xml that you modified. > > Additionally you can take a look at the logs. Also, if you start Tomcat > by issuing > catalina.bat run > the console will stay open, allowing you to see Tomcat's startup messages. > > Regards > mks > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Address-already-in-use%3A-JVM_Bind--87.230.103.25%3A80-tp21477831p21500899.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Dara P Maginnis/IR/AIB is out of the office.
paul.ocklef...@nhs.net wrote: > Yes, I have had about 15 now! > > -Original Message- > From: Pid [mailto:p...@pidster.com] > Sent: 16 January 2009 14:26 > To: Tomcat Users List > Subject: Re: Dara P Maginnis/IR/AIB is out of the office. > > that was annoying after 3 copies... > someone unsubscribe him please? Done. And blocked from re-subscribing since the auto reply may manage to re-subscribe the address. Mark > > p > > > dara.p.magin...@aib.ie wrote: >> I will be out of the office starting 16/01/2009 and will not return >> until 18/01/2009. >> >> I will out of the office and will action my mails on my return >> >> >> Dara.P.Maginnis >> AIB IFS >> IT >> AIB International Centre, IFSC >> 6417986 >> >> This e-mail (and any files transmitted with it) is intended solely for >> the use of the individual(s) to whom it is addressed and is intended >> to provide general information on a particular subject(s) and is not >> an exhaustive treatment of such subject(s). Accordingly, the >> information in this e-mail is not intended to constitute accounting, >> tax, legal, investment or other professional advice. Before making any >> decision or taking any action that might affect your business, you should > consult a professional adviser. >> AIB International Financial Services Limited is regulated by the Irish >> Financial Regulator. >> >> Allied Irish Banks >> >> http://www.aibifs.com >> >> AIB and AIB Group are registered business names of Allied Irish Banks >> p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. >> Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 >> 6600311; Registered in Ireland: Registered No. 24173. >> >> ~~~Please consider the environment before printing this >> Email >> >> This Disclaimer has been generated by CMDis >> >> >> > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > > *** > This message may contain confidential and privileged information. > If you are not the intended recipient you should not disclose, copy > or distribute information in this e-mail or take any action in reliance > on its contents. To do so is strictly prohibited and may be unlawful. > Please inform the sender that this message has gone astray before > deleting it. Thank you. > > 2008 marks the 60th anniversary of the NHS. It's an opportunity to pay > tribute to the NHS staff and volunteers who help shape the service, and > celebrate their achievements. > > If you work for the NHS and would like an NHSmail email account, go > to: www.connectingforhealth.nhs.uk/nhsmail > *** > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
RE: Dara P Maginnis/IR/AIB is out of the office.
Yes, I have had about 15 now! -Original Message- From: Pid [mailto:p...@pidster.com] Sent: 16 January 2009 14:26 To: Tomcat Users List Subject: Re: Dara P Maginnis/IR/AIB is out of the office. that was annoying after 3 copies... someone unsubscribe him please? p dara.p.magin...@aib.ie wrote: > I will be out of the office starting 16/01/2009 and will not return > until 18/01/2009. > > I will out of the office and will action my mails on my return > > > Dara.P.Maginnis > AIB IFS > IT > AIB International Centre, IFSC > 6417986 > > This e-mail (and any files transmitted with it) is intended solely for > the use of the individual(s) to whom it is addressed and is intended > to provide general information on a particular subject(s) and is not > an exhaustive treatment of such subject(s). Accordingly, the > information in this e-mail is not intended to constitute accounting, > tax, legal, investment or other professional advice. Before making any > decision or taking any action that might affect your business, you should consult a professional adviser. > > AIB International Financial Services Limited is regulated by the Irish > Financial Regulator. > > Allied Irish Banks > > http://www.aibifs.com > > AIB and AIB Group are registered business names of Allied Irish Banks > p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. > Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 > 6600311; Registered in Ireland: Registered No. 24173. > > ~~~Please consider the environment before printing this > Email > > This Disclaimer has been generated by CMDis > > > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org *** This message may contain confidential and privileged information. If you are not the intended recipient you should not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents. To do so is strictly prohibited and may be unlawful. Please inform the sender that this message has gone astray before deleting it. Thank you. 2008 marks the 60th anniversary of the NHS. It's an opportunity to pay tribute to the NHS staff and volunteers who help shape the service, and celebrate their achievements. If you work for the NHS and would like an NHSmail email account, go to: www.connectingforhealth.nhs.uk/nhsmail *** - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Dara P Maginnis/IR/AIB is out of the office.
that was annoying after 3 copies... someone unsubscribe him please? p dara.p.magin...@aib.ie wrote: > I will be out of the office starting 16/01/2009 and will not return until > 18/01/2009. > > I will out of the office and will action my mails on my return > > > Dara.P.Maginnis > AIB IFS > IT > AIB International Centre, IFSC > 6417986 > > This e-mail (and any files transmitted with it) is intended solely for the > use of the individual(s) to whom it is addressed and is intended to provide > general information on a particular subject(s) and is not an exhaustive > treatment of such subject(s). Accordingly, the information in this e-mail > is not intended to constitute accounting, tax, legal, investment or other > professional advice. Before making any decision or taking any action that > might affect your business, you should consult a professional adviser. > > AIB International Financial Services Limited is regulated by the Irish > Financial Regulator. > > Allied Irish Banks > > http://www.aibifs.com > > AIB and AIB Group are registered business names of Allied Irish Banks > p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. > Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; > Registered in Ireland: Registered No. 24173. > > ~~~Please consider the environment before printing this Email > > This Disclaimer has been generated by CMDis > > > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
RE: setup default webapp in tomcat 6 and apache
> From: johnrock [mailto:johnpi...@yahoo.com] > Subject: RE: setup default webapp in tomcat 6 and apache > Is that the typical way this should be done? If you're keeping your webapp outside of the appBase directory, it's the only way it can be done. > I can't understand why I could not find the > instructions that you gave me in any other > documentation or tutorials I read Did you read the real Tomcat doc? http://tomcat.apache.org/tomcat-6.0-doc/config/context.html > Isn't this a very standard thing to do? No; one normally deploys webapps under the appBase. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Re: PostgreSQL vs MySQL with Tomcat
Ken Bowen wrote: Hi all (especially Chris -- very informative long post today on Tomcat/MySQL): For a several reasons (including the apparent infinite default for connection timeout), I'm contemplating switching one or two projects from MySQL to PostgreSQL. I'd like to gather opinions on the tradeoffs, including: Unfortunately, MySQL isn't really that tunable. On the other hand, MySQL requires very little in the way of tuning! Not true, unless your needs are very modest. The InnoDB engine has a large number of tunable parameters - however, they are poorly and incompletely documented in the MySQL manual, while changing them may cause your indexes to be silently dropped when you restart MySQL. The MyISAM engine also has a number of tunable parameters, but I would only use this engine in preference to InnoDB if you need full text indexing, and only for the specific tables that require full text indexes. I created a couple of proof-of-concept projects with PostgreSQL for someone about six months ago, and the only really puzzling thing what how to set up "sequences" corresponding to MySQL's AUTOINCREMENT (I'm not sure I've really wrapped head around it completely anyway). For those small projects, it worked well, but there was no stress involved. Where you would use an AUTO_INCREMENT column in MySQL, use a SERIAL column in PostgreSQL which creates a sequence for you. There's a good description in the PostgreSQL manual: http://www.postgresql.org/docs/8.3/static/datatype-numeric.html#DATATYPE-SERIAL I'd like to hear about people's experiences and what they think are the strengths and weaknesses of each DBMS for use behind Tomcat. PostgreSQL is not perfect, but it has proven to be faster and far more reliable than MySQL in the projects where I have tested both. The full text indexing in PostgreSQL is far more sophisticated, although at the cost of slightly more complexity to use. Tuning is generally straightforward, and far less of a black art than it is with MySQL. Finally, I spend far less time analysing query plans and optimising by hand when using PostgreSQL rather than MySQL, as the former handles joins across more than one table far better. Thanks much in advance, Ken Bowen Chris -- Chris Wareham Senior Software Engineer Visit London Ltd 6th floor, 2 More London Riverside, London SE1 2RR Tel: +44 (0)20 7234 5848 Fax: +44 (0)20 7234 5753 www.visitlondon.com 'Visit London Limited' is registered in England under No.761149; Registered Office: Visit London, 2 More London Riverside, London SE1 2RR. Visit London is the official visitor organisation for London. Visit London is partly funded by Partnership, the Mayor's London Development Agency and London Councils. The information contained in this e-mail is confidential and intended for the named recipient(s) only. If you have received it in error, please notify the sender immediately and then delete the message. If you are not the intended recipient, you must not use, disclose, copy or distribute this email. The views expressed in this e-mail are those of the individual and not of Visit London. We reserve the right to read and monitor any email or attachment entering or leaving our systems without prior notice. Please don't print this e-mail unless you really need to. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
Dara P Maginnis/IR/AIB is out of the office.
I will be out of the office starting 16/01/2009 and will not return until 18/01/2009. I will out of the office and will action my mails on my return Dara.P.Maginnis AIB IFS IT AIB International Centre, IFSC 6417986 This e-mail (and any files transmitted with it) is intended solely for the use of the individual(s) to whom it is addressed and is intended to provide general information on a particular subject(s) and is not an exhaustive treatment of such subject(s). Accordingly, the information in this e-mail is not intended to constitute accounting, tax, legal, investment or other professional advice. Before making any decision or taking any action that might affect your business, you should consult a professional adviser. AIB International Financial Services Limited is regulated by the Irish Financial Regulator. Allied Irish Banks http://www.aibifs.com AIB and AIB Group are registered business names of Allied Irish Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the Financial Regulator. Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered No. 24173. ~~~Please consider the environment before printing this Email This Disclaimer has been generated by CMDis
[ANNOUNCEMENT] ApacheTomcat Native 1.1.16 Released
The Apache Tomcat team is proud to announce the immediate availability of Tomcat Native 1.1.16 stable. This build contains a small number of bug fixes over the previous release. Please refer to the changelog: http://tomcat.apache.org/native-doc/miscellaneous/changelog.html for a complete list of changes. Downloads: http://tomcat.apache.org/download-native.cgi Note: This announcement note has been sent later then actual release was made because of delayed voting. The Apache Tomcat Team - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JESESSIONID
James Hoare wrote: > Thanks for the response on this. I don't think I explained myself very > clearly though, as we're not actually using a cluster so we never pass > session deltas between the nodes. Our JBOSS instances are round robin load > balanced via mod_jk, therefore if a user has a session created on one server > and that server is taken off line, mod_jk will route that users next request > to the next available app server. The users original session data is never > persisted as we don't currently use Tomcat's PersistentStoreManager. > > But I thought that the app server receiving this request with a JSESSIONID > that is doesn't recognise would overwrite the cookie with it's own JESSIONID, > if there is a call to req.getSession()? > > Our JBOSS instances have an embedded Tomcat v5.5 instance and we deploy our > app as a WAR. > > Could anyone confirm that the above is the correct behavior of Tomcat? Confirmed. Mark - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat Bug-database not accepting any new registrations?
Gregor Schneider wrote: > Hi guys, > > I've tried to register as a new user with the Tomcat bug-database > (https://issues.apache.org/bugzilla/createaccount.cgi?login=myEmail%40somemailaccount.com, > however, I don't receive any mail containing the activation-link. > > Tried it 2 times already, with a gap of 2 days in between the 2 > registration-processes, to no avail. > > Anything wrong with the bugzilla, am I missing something here? > > TIA > > Gregor What e-mail address did you use? Mark - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat 6.x security-constraint redirection problem... please help!
Christopher Schultz wrote: > Pid, > > Pid wrote: >> There's a couple of things that may be confusing the config below, which >> have some simple corrections. > >> I usually place "login.jsp" and "error.jsp" in "WEB-INF/login/", where >> they are protected from unwanted attention by default - this avoids the >> need to protect them with a security-contstraint. > > Agreed. I've found that when using Tomcat to serve static content, these > things tend to happen. The reason is that Tomcat saves the first > unauthorized request and then repeats it after successful > authentication. If the last request was for something like a CSS file > (say, because the CSS file was protected, but the main page wasn't), > then you'll end up being served the CSS file after login. It can be very > disorienting. > >> Tomcat returns the *first* file you requested inside the secured area >> after authentication is completed. So for some reason your browser is >> requesting a script or CSS file before the JSP page. > > For some reason, I thought it was the most recent request it saved. > First makes more sense; thanks for mentioning it. I have an app with a page which contains a flash object (displays a nice graph) that calls a groovy script periodically to get data. If the user session times out in between requests for the script then when it's requested it's the first one after de-auth, so it becomes the target that is re-established after re-login, (obviously not useful for users). I've been attempting to stop the periodic request by monitoring the session period, but haven't had time to properly address it yet. :( p > -chris > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JK connector fails with long URLs
Hi, Thank you.. if this was this easy.. :-) Unfortunately, one of their requirements is to send the URLs by email. I already told them to use a different method, but I still hope to see an higher limit in the next JK version. Thanks again, Br1. awarnier wrote: > > br1 wrote: >> >> Rainer Jung-3 wrote: >>> It looks like we only support URLs up to 2047 Bytes (+/- 1). >>> >>> Regards, >>> >>> Rainer >>> >> >> Hey Rainer, >> >> Do you think this limit will be increased in the next versions? >> >> In theory, no limit is imposed by the protocol itself. I would tend to >> think >> JK should at least support what the JK supported platforms support. >> >> What is annoying - at least on IIS - is that all requests get blocked, >> not >> just the ones getting redirected to Tomcat. This limit is not present on >> any >> other ISAPI filter I know. >> >> Don't get me wrong: my personal opinion is that 2k are more than enough >> for >> any URL, but the only place I can impose this limit is at home. And maybe >> not for much longer. :-) >> > > > has the browser send request parameters in the body of the request, > instead of the URL. No 2K limit there. > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/JK-connector-fails-with-long-URLs-tp21443475p21496454.html Sent from the Tomcat - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Tomcat Bug-database not accepting any new registrations?
Hi guys, I've tried to register as a new user with the Tomcat bug-database (https://issues.apache.org/bugzilla/createaccount.cgi?login=myEmail%40somemailaccount.com, however, I don't receive any mail containing the activation-link. Tried it 2 times already, with a gap of 2 days in between the 2 registration-processes, to no avail. Anything wrong with the bugzilla, am I missing something here? TIA Gregor -- just because your paranoid, doesn't mean they're not after you... gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: JESESSIONID
Thanks for the response on this. I don't think I explained myself very clearly though, as we're not actually using a cluster so we never pass session deltas between the nodes. Our JBOSS instances are round robin load balanced via mod_jk, therefore if a user has a session created on one server and that server is taken off line, mod_jk will route that users next request to the next available app server. The users original session data is never persisted as we don't currently use Tomcat's PersistentStoreManager. But I thought that the app server receiving this request with a JSESSIONID that is doesn't recognise would overwrite the cookie with it's own JESSIONID, if there is a call to req.getSession()? Our JBOSS instances have an embedded Tomcat v5.5 instance and we deploy our app as a WAR. Could anyone confirm that the above is the correct behavior of Tomcat? -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Thu 15/01/2009 17:41 To: Tomcat Users List Subject: Re: JESESSIONID -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 James, James Hoare wrote: > Hi, was wondering if someone could clear this up for me. I probably can't clear it up, 'cause I have no experience with JBOSS (or even Tomcat) clusters, but I have a few thoughts... > We have mod_jk in apache loadbalancing our JBOSS cluster with session > affinity. We've noticed that once the JESSIONID has been created with > the call to req.getSession() and the jvmroute encoded by the tomcat > worker, that if the JBOSS instance that originally created the > HttpSession is taken off line the next JBOSS instance that receives > the request doesn't rewrite the cookie with the new JESSIONID for > that app server? > > Is that the correct behaviour? If the server instance is participating in a cluster, presumably the session ids are unique across the cluster. If that's the case, then the session id is valid no matter which server instance you get and so the session id wouldn't change if you switched servers. Does the session continue to "work" after this failover? That is, is there actually a problem, or are you just asking because you are observing something unexpected? - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAklvdTsACgkQ9CaO5/Lv0PDX/gCdHs0EIQT8VWAxauRZAjCurHEP YBcAmwQAlsnXBSymUwdwPGmNbFtObNUv =Akmg -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: PostgreSQL vs MySQL with Tomcat
Some comments (and answers to Christopher and Rusty) on PostgreSQL: In 2004 our team decided to use PostgreSQL instead of the well-known MySQL (current version 4). The main reasons where - real referential integrity - real transactions - support for UTF-8 enoding - better compliance with the SQL standard > The one warning I can think of with PostgreSQL is that you have to use > schemas; you either have to set the schema after you connect, and I > think I couldn't figure out how to do that with jdbc, or you specify it > as part of every table name; "create table schema_name.table_name ...; > select whatever from schema_name.table_name;". Schemas are quite cool, > so don't take this as a criticism. This isn't true. You can (and perhaps should) always omit the schema. The default schema "public" is used in this case. You can execute CREATE TABLE foo ( id serial NOT NULL PRIMARY KEY, description text NOT NULL ); >NOTICE: CREATE TABLE will create implicit sequence "foo_id_seq" for serial column "foo.id" >NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo" INSERT INTO foo (description) VALUES ('foo'); SELECT * FROM foo; >1;"foo" SELECT currval('foo_id_seq'); >1 In the persistende layer we have switched from JDBC to iBATIS. There you have the SQL statements organized in XML files. One approach for INSERT is SELECT nextval('foo_id_seq') INSERT INTO foo (id, description) VALUES ( #id:INTEGER#, #description:VARCHAR# ) In the DAO implementation you have public Integer insert(Foo foo) { Integer id = (Integer) getSqlMapClientTemplate().insert("foo.insert", foo); return id; } or simply public void insert(Foo foo) { getSqlMapClientTemplate().insert("foo.insert", foo); } After the call the Foo instance contains the generated ID in both cases. We didn't need much support for PostgreSQL. The documentation is comprehensive. The installation under Windows is easy. The installation unter UNIX systems can have some difficulties. Ingmar - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org