Re: Tomcat with external JBoss (JNDI problems)...
Since the local TOMCAT JNDI server is not compatible with the JBOSS JNDI server you probably have the -nonaming switch activated. Since this deactivates the TOMCAT JNDI server you can access the local JNDI properties that way. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Andrzej Jan Taramina [EMAIL PROTECTED] To: Becker, Michael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 22, 2002 6:39 PM Subject: RE: Tomcat with external JBoss (JNDI problems)... Copy %JBOSS_HOME%/client/[jboss-client.jar,jboss-common-client.jar, jbosssx-client.jar, jnp-client.jar, jboss-j2ee.jar, and log4j.jar] to %CATALINA_HOME%/shared/lib. Doesn't work.it still does not pick up my JBoss-specific jndi.properties file. I've got that file in the WEB-INF/classes and the shared/classes directories...to no avail. This works for me: // Try to find each of these individual parameters // and construct the properties // object appropriately java.util.Properties p = new java.util.Properties(); p.put(InitialContext.INITIAL_CONTEXT_FACTORY, org.jnp.interfaces.NamingContextFactory); p.put(InitialContext.URL_PKG_PREFIXES, org.jboss.naming:org.jnp.interfaces); p.put(InitialContext.PROVIDER_URL,yourservername); InitialContext context = new InitialContext(p); After that you can do your EJB lookup's with that context. That works for me too Michaelhas for some time now. The issue I have with it is that I don't want to hard-code the JBoss server URL's and such into my code, since then the servlet can't be deployed by others with different setups without a code change and a recompile. What I am trying to figure out is how to just do a: InitialContext context = new InitialContext(); call...without the hardcoded properties objectand have it pick up the properties from the jndi.properties file...like it's supposed to. Thanks! Andrzej Jan Taramina Chaeron Corporation: Enterprise System Solutions http://www.chaeron.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Problem in Tomcat Servlet calling JBoss EJB running on a different machine
Tomcat -nonaming switch used?
The Tomcat JNDI server conflicts with JBOSS's
you have to switch it off from the command line.
Best Regards,
Anthony Geoghegan.
J2EE Developer
CPS Ireland Ltd.
- Original Message -
From: Giuseppe Sorce [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 1:53 PM
Subject: Problem in Tomcat Servlet calling JBoss EJB running on a different
machine
Scenario:
* Client Development Machine
Win2K prof.
NetBeans IDE 3.4
Tomcat 4.0 (integrated in NetBeans)
JDK 1.3.1
* Server EJB Container
Linux RedHat 7.1
JDK 1.3.1
jboss-3.0.3_tomcat-4.1.12
* Test Application
Very simple, look at http://www.adwanted.com/jboss/ for details
- Only 1 Stateless Session Bean (com.web_tomorrow.interest.InterestBean),
implementing just a simple method:
public double calculateCompoundInterest(double principle,
double rate, double periods) {
System.out.println (Someone called `calculateCompoundInterest!');
return principle * Math.pow(1+rate, periods) - principle;
}
- Compiled and deployed using NetBeans (very useful the JAR Recipe!).
Copied
the jar file on the Linux server. All works fine!
- Tested with a simple Java Client:
System.setProperty(java.naming.factory.initial,
org.jnp.interfaces.NamingContextFactory);
System.setProperty(java.naming.provider.url, ewlpasrv1);
InitialContext jndiContext = new InitialContext();
Object ref = jndiContext.lookup(examples/Interest);
InterestHome home = (InterestHome)
PortableRemoteObject.narrow (ref, InterestHome.class);
Interest interest = home.create();
System.out.println
(Interest on 1000 units, at 10% per period, compounded over 2 periods
is:);
System.out.println (interest.calculateCompoundInterest (1000, 0.10, 2));
No error reported.
* PROBLEM
We made a simple Servlet (look at the bottom of this document...), similar
to the client.
- we created a Web Module using netbeans
- we copied jboss client jar files under (...)\tomcat404\lib
- we copied the app's deployment jar file under (...)\WEB-INF\lib
Running the servlet from NetBeans IDE (using internal Tomcat), here is the
result:
Servlet interface to EJB
Calling EJB...
Got context
Got reference
Got Home Interface
java.rmi.UnmarshalException: Error unmarshaling return; nested exception
is:
java.net.SocketException: Connection aborted by peer: JVM_recv in socket
input stream read
(the full error stack is listed at the end of this mail).
Any idea?
Thanx in advance
Giuseppe Sorce
ITALY
- Error -
Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error
type Exception report
message Internal Server Error
description The server encountered an internal error (Internal Server
Error)
that prevented it from fulfilling this request.
exception
java.rmi.UnmarshalException: Error unmarshaling return; nested exception
is:
java.net.SocketException: Connection reset by peer: JVM_recv in socket
input stream read
java.net.SocketException: Connection reset by peer: JVM_recv in socket
input stream read
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
at java.io.ObjectInputStream.peekCode(ObjectInputStream.java:1550)
at
java.io.ObjectInputStream.skipToEndOfBlockData(ObjectInputStream.java:1480)
at
java.io.ObjectInputStream.inputClassDescriptor(ObjectInputStream.java:927)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:366)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:236)
at java.io.ObjectInputStream.inputObject(ObjectInputStream.java:1186)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:386)
at
java.io.ObjectInputStream.inputClassFields(ObjectInputStream.java:2263)
at
java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:519)
at java.io.ObjectInputStream.inputObject(ObjectInputStream.java:1412)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:386)
at
java.io.ObjectInputStream.inputClassFields(ObjectInputStream.java:2263)
at
java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:519)
at java.io.ObjectInputStream.inputObject(ObjectInputStream.java:1412)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:386)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:236)
at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:212)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122)
at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown
Source)
at
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProx
y.java:129)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:108
Re: how do I invoke servlet from a servlet in different web application?
You could try a client-side redirect. response.sendRedirect(..URL..); Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Jason Novotny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 10:05 AM Subject: how do I invoke servlet from a servlet in different web application? Hi, I would like to know how I can invoke a servlet in one web application from a servlet in another web application? Also, how would I do this if the other servlet is hosted in another servlet container on another machine? My goal is to provide a web application framework that other web applications can plug into, so that I can re-deploy the secondary web application while still running my main framework servlet. What are the potential security/performance issues associated with this? Finally, I see that server.xml has an option to allow for the reloading of web applications whose servlet classes/JSP's have changed. However this may be to resource consumptive on a production server-- is there any way I can send an admin command to reload servlets whose timestamp has changed (push rather than pull model)? Thanks for the help, Jason -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Re: Apache 2, Tomcat, JBoss configuration
You have to use remote interfaces and turn off the TOMCAT JNDI server to use
the JBOSS JNDI server, otherwise it's fine.
Best Regards,
Anthony Geoghegan.
J2EE Developer
CPS Ireland Ltd.
- Original Message -
From: Jim Haggerty [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 5:31 PM
Subject: Apache 2, Tomcat, JBoss configuration
Current versions:
FreeBSD 4.6.2-RELEASE
Apache 2.0.42 (although FreeBSD port now has 2.0.43)
Tomcat 4.0.5
JBoss 3.0.0 (NB: This installation is the package WITHOUT Tomcat)
Apache and Tomcat are getting along fine and I can access deployed webapps
through the warp connection (Is JK2 preferred over warp?) on both port 80
and 8080.
JBoss is alive and well on port 8082.
However, virtually ALL the documentation I have found regarding connecting
the three refers to the JBoss+Tomcat package (modify the server.xml in
${JBOSS_HOME}/catalina). Does anyone have an example of connecting
Apache -
Tomcat - JBoss WITHOUT JBoss+Tomcat?
Thanks,
Jim
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: migration questions
Yes but it's normally something like: www.example.com/servlet/~richard so that Apache can forward the request with anything like www.example.com/servlet to Tomcat. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Richard Chamberlain [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 11:45 AM Subject: migration questions Hello Everyone, A quick warning that I'm a complete Tomcat newbie.. We're currently using resin because when we originally evaluated Tomcat was a nightmare in reloading classes, I'm hoping things have improved. I'm currently suffering problems because I'm using resin with apache and trying to map a url and username to a particular webapp i.e. www.example.com/~richard, this doesn't really work with mod_caucho. For example I have to have all my servlets mapped to .jsp extensions otherwise mod_caucho doesn't forward the request to resin. So my first question is I'm hoping my situation will improve with tomcat (i.e the integration of apache and tomcat) has anybody done this username mapping before? I've download 4.1.9 and I'm very impressed with the new administration and management pages. I'm trying to add a host tag (using the management tool) for a virtualhost and it's not working. The host is already working correctly in resin (it's a set of simple jsp pages) so I just wanted to map tomcat to it to see if I could get it to work. Firstly I created the host (www.sunsetandlabrea.com) with all the defaults. For the application base I put /home/richardc/. The setup is /home/richardc is my home directory, /home/richardc/public_html is my site, and so there is a /home/richardc/public_html/WEB-INF/ Then I added a context with all the defaults except Document Base which I set to /home/richardc/public_html/. Now when I browse sunsetandlabrea.com:8080 instead of getting the tomcat default pages I get a requested resource not found. If I try sunsetandlabrea.com:8080/index.jsp I get a tomcat 404 error. Apologies for the long message and thanks for any help anyone can offer, Richard -- http://fastmail.fm - Sent .002 seconds ago -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: MVC and caching
Is that a client caching issue? If so a variety of http header settings can be used to clear a client-side cache. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Josh G [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:06 AM Subject: MVC and caching Hi, I'm using a model-view-controller setup for my application, and I've run into problems with caching - here's a workflow: 1. User gets presented with viewDetails.jsp?id=1 2. User updates details, submits forms to a controller servlet 3. Servlet commits the changes via the model objects, and redirects to viewDetails.jsp?id=1 4. ??? 5. Profit!!! The problem is, the user is seeing (sometimes) a cached version of viewDetails.jsp?id=1 not always mind, just most of the time. Anybody run into similar problems? Is there a simple solution? Perhaps adding a variable with random data in it? Any answers appreciated! -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: MVC and caching
Additionally to use the clientside cache as it was meant to be used have a look at the last-modified response header. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Andreas Mohrig [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 11:57 AM Subject: RE: MVC and caching Another method I once noticed has to do with never letting your user request the exact same URL twice, which could be accomplished by always sending (and incrementing) an additional sequence-number: 1. User gets presented with viewDetails.jsp?id=1sequencenumber=A_NUMBER 2. User updates details, submits forms to a controller servlet 3. Servlet commits the changes via the model objects, and redirects to viewDetails.jsp?id=1sequencenumber=A_NUMBER+1 4. ??? 5. Profit!!! [hopefully!] This can't be cashed, since it has to be expected that the output based an the different input will also be different. greetings Andreas Mohrig -Original Message- From: Andreas Mohrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:50 PM To: 'Tomcat Users List' Subject: RE: MVC and caching Either the browser or some proxy is caching your page. Try to tell them to not do that with either a http-header: response.addHeader(pragma,no-cache); [I hope this is right] or some HTML-Tags (pick one or use all, I haven't tested them or checked for compliance with the HTML-Standard; just found them on the web): META HTTP-EQUIV=cache-control CONTENT=no-cache META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=expires CONTENT=Tue, 7 July 1998 10:00:00 GMT The header seems to be preferable, since proxies might ignore the tags. Let us know if you succeeded and if so, with what method. Andreas Mohrig -Original Message- From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:18 PM To: Tomcat Users List Subject: Re: MVC and caching Is that a client caching issue? If so a variety of http header settings can be used to clear a client-side cache. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Josh G [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:06 AM Subject: MVC and caching Hi, I'm using a model-view-controller setup for my application, and I've run into problems with caching - here's a workflow: 1. User gets presented with viewDetails.jsp?id=1 2. User updates details, submits forms to a controller servlet 3. Servlet commits the changes via the model objects, and redirects to viewDetails.jsp?id=1 4. ??? 5. Profit!!! The problem is, the user is seeing (sometimes) a cached version of viewDetails.jsp?id=1 not always mind, just most of the time. Anybody run into similar problems? Is there a simple solution? Perhaps adding a variable with random data in it? Any answers appreciated! -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Java servlets html escape codes.
Anyone know a low overhead class or method for converting text strings to html escape coded strings (and back again) for java Servlet implementation? i.e. -- amp; etc. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Java servlets html escape codes.
Thanks Simon perfect. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Simon Stewart [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 11:44 AM Subject: Re: Java servlets html escape codes. On Tue, Jul 30, 2002 at 11:05:31AM +0100, Anthony Geoghegan wrote: Anyone know a low overhead class or method for converting text strings to html escape coded strings (and back again) for java Servlet implementation? i.e. -- amp; Alex Chafee's PurpleTech classes have something that do that. http://www.purpletech.com/ You get the source as well, so you can slim the class down even more if you need to. Cheers, Simon -- A debugged program is one for which you have not yet found the conditions that make it fail. -- Jerry Ogdin -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Request forwarding to a specific target frame?
Can't be done server-side. This is a client issue. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Andreas Schlegel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 10:18 AM Subject: Request forwarding to a specific target frame? Hi, does anyone know how to forward a request to a specific frame? I use: dispatcher = getServletContext().getRequestDispatcher( /servlet/MyServlet ); dispatcher.forward( request, response ); Is there any way to define a target frame (TARGET='myFrame') in such a request forwarding? Greetings, Andreas -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
client authorization.
Is it possible to use client certificate authorization without a password and its associated dialog? Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: client authorization.
What if the client isn't a browser but a Microsoft ASP based HTTPXML call? Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. - Original Message - From: Craig R. McClanahan [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 5:09 PM Subject: RE: client authorization. On Wed, 17 Jul 2002, Tathagat (London) wrote: Date: Wed, 17 Jul 2002 16:03:30 +0100 From: Tathagat (London) [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Subject: RE: client authorization. They only describe how to get a certificate on server side. I mean server can show a certificate to client, but it does not say how do the client sends a certificate to the server. You need to import a *client* certificate into your browser (following the procedures for your browser -- it has nothing to do with Tomcat). Then, when the server is set up to challenge for client certificates (which it will if you use CLIENT-CERT as the authentication mechanism, or you've set the clientAuth attribute on the HTTPS connector), the browser will pop up a dialog asking you which of your client certificates you want to send in response. I think we need to find this thing out., Craig -Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 16:59 To: Tomcat Users List Subject: Re: client authorization. On Wed, 17 Jul 2002, Anthony Geoghegan wrote: Date: Wed, 17 Jul 2002 11:18:33 +0100 From: Anthony Geoghegan [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: client authorization. Is it possible to use client certificate authorization without a password and its associated dialog? Tomcat 4.x can do this. See the docs for the version of Tomcat you are using: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/ssl-howto.html http://jakarta.apache.org/tomcat/tomcat-4.1-doc/ssl-howto.html Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. Craig -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.drkw.com/disc/email/ or contact the sender. -- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
client cert authorization method.
Hi guys, Does anybody have any links on simple implementations of cert based authentication for stand-alone implementations of TOMCAT 4.x? Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Virtual JSP folders...
Is it possible to set up virtual jsp/image folders in a stand-alone implementation of Tomcat? Ant. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: The best website database!
I agree fully with Liam I'm an Apache/Tomcat user with a MySQL database, I use MySQL Front and have found it to be an excellent client application for accessing, importing and exporting data. Access can export data to CSV format which can simply be imported via MySQL Front for cross compatibility. Beware though, there are certain MySQL issue to be aware of: 1/ No support for UNION (at least in 3.23) 2/ No support for Sub-Queries 3/ No stored procedures or even stored queries/views (except in a sql text file). A variety of workarounds are available some of them more successful than others though. And it's not difficult to install. Best Regards, Anthony Geoghegan. J2EE Oracle Consultant. - Original Message - From: Liam Morley [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 10:14 AM Subject: Re: The best website database! I've only witnessed one occasion where someone else was able to do something pretty cool with Access, but it was sufficient enough for Access to earn a bit of respect from me. I think many Tomcat users use MySQL and PostgresSQL due to the fact that they've got an open-source (as well as free) solution. At least I do; I can't afford Oracle, nor do I need it. Will, I use MySQL, and I'm happy with the MySQL Front free gui interface for it, however I don't think it's /quite/ what you're looking for. You don't design queries in MySQL (or in other apps I've seen) the same hands-off way you can in Access. Be this a blessing or a curse, I couldn't tell you. MySQL Front's website http://www.mysqlfront.de has some screenshots, check them out and see if they're helpful at all. Liam Morley Clay Graham wrote: well I have never heard any of my friends say MSACCESS is good for anything. most small tomcat sites that I know use MySql or postgresSQL, most big ones use Oracle 8i/9i clay -Original Message- From: Will Hartung [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 28, 2002 6:10 PM To: Tomcat Users List Subject: Re: The best website database! - Original Message - From: [EMAIL PROTECTED] Hi All I currently use MS ACCESS as my backend to my website and other developers in the forum have advised this is not a good choice and I am aware of this but I was forced to use it as all data comes to me in MS ACCESS from database admin that supply the data for the website. I want to know what is the best database to use for a website? It Depends Now that that is out of the way... features I am looking for are: 1- An excellent GUI (Very important) front like MS ACCESS where I can quickly design queries, tables and so on. I normally design all the queries in MS ACCESS and then I just write the single line command SELECT QUERY1 rather than writing the full query in a javabean or jsp page by hand as this saves me alot of time. Ideally, you will, in time, wean yourself of this reliance, as most databases do not have a GUI. In the long term it's better to have a more intimate relathionship with SQL, minimally for performance reasons. But, it seems pretty clear you haven't reached that threshold yet. However, all is not completely lost. One of the Neat Things(tm) about MS ACCESS is not so much that it has a built-in database based on Microsofts Jet Engine, but that it can act as a central access point for, technically, any number of ODBC compliant databases. So, you can theoretically still use ACCESS as your primary database, but have all of the tables be linked from the true database host. This will certainly cost you performance, and the queries you devise may not work quite like they do in native ACCESS, but it will be close. Particularly if you are sticking close to the most basic of SQL functionality, and not relying on a lot of the higher level functions provided within ACCESS. If you're using mostly Pure SQL, then ACCESS is simply a data broker, and yet another layer between your app and your DB. As long as the contention and locking facilities are being used in the native backend, versus within ACCESS, you should gain quite a bit of reliablity over pure ACCESS as well. I'm not totally sure if this is the case, but it probably is, again for basic SQL statements. The goal is to use ACCESS simply as an interface into your new database, and have it broker your SQL statements to and from the database, with hopefully as little intervention as possible. Your SELECT QUERY1 will still work, however, but beware that ACCESS will potentially happily suck in all of the data from the new DB, churn on it, and then spit it back out to you. Depending on the query, this can be expensive and isn't what you want. If you like the simplicity of SELECT QUERY1 from ACCESS, I would suggest that you perhaps use ACCESS to develop your basic queries, and then use the actual SQL generated to turn them
