RE: Working of Tomcat with MS Access

2011-04-19 Thread George Sexton
-Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, April 15, 2011 1:02 PM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeff, On 4/15/2011 11:11 AM, Jeff Hubbs

Re: Working of Tomcat with MS Access

2011-04-16 Thread Pid
On 4/15/11 6:58 PM, RAHUL RAJ wrote: This is like a small assignment that has to be submitted urgently Is this student coursework? p signature.asc Description: OpenPGP digital signature

Re: Working of Tomcat with MS Access

2011-04-16 Thread RAHUL RAJ
Yes On Sat, Apr 16, 2011 at 8:44 PM, Pid p...@pidster.com wrote: On 4/15/11 6:58 PM, RAHUL RAJ wrote: This is like a small assignment that has to be submitted urgently Is this student coursework? p

Re: Working of Tomcat with MS Access

2011-04-15 Thread Mikolaj Rydzewski
On Fri, 15 Apr 2011 15:34:37 +0530, RAHUL RAJ omrahulraj...@gmail.com wrote: I am working on building a jsp website with MS Access as database. I usually do not express my opinions about others code, but your is really the worst code sample I have ever seen... I know that everyone

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
I know my code is not perfect. But I just want to resolve this error now. Can u say how to solve this? pls answer to the question.have u read my message completely? On 4/15/11, Mikolaj Rydzewski m...@ceti.pl wrote: On Fri, 15 Apr 2011 15:34:37 +0530, RAHUL RAJ omrahulraj...@gmail.com

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
The code I gave is just a sample code, it might change afterwards..but before that, I need to resolve this error, sorry for your inconvenience... On 4/15/11, RAHUL RAJ omrahulraj...@gmail.com wrote: I know my code is not perfect. But I just want to resolve this error now. Can u say how to solve

Re: Working of Tomcat with MS Access

2011-04-15 Thread Mikolaj Rydzewski
On Fri, 15 Apr 2011 17:01:05 +0530, RAHUL RAJ omrahulraj...@gmail.com wrote: I know my code is not perfect. But I just want to resolve this error now. Can u say how to solve this? pls answer to the question.have u read my message completely? How do you run your tomcat - as a service? --

RE: Working of Tomcat with MS Access

2011-04-15 Thread Propes, Barry L
I know from previous experience that driver you show is horribly outdated, and horrible in general. I assume no credentials are needed to access the DB in the Connection object, con? Maybe I'm reading that incorrectly. Does the JDBC program connect to MS Access at all? -Original

Re: Working of Tomcat with MS Access

2011-04-15 Thread Jeff Hubbs
You do realize, I hope, that what you're proposing is akin to sourcing parts for your jet engine from Fisher-Price? IMHO MS Access is not and never has been useful as a professional database product. I'm not even sure if what you are proposing even holds up in the

Re: Working of Tomcat with MS Access

2011-04-15 Thread Angel Java Lopez
One question: You should have an ODBC declaration named rahul. It is declared for your user, or as a system odbc name? My guess, your Tomcat is running as a service, or under other user (not your user), and ODBC rahul Data Source name is only for your user. Is it the case? Did you solve the

Re: Working of Tomcat with MS Access

2011-04-15 Thread Troy
Raj; To all reading this response, this is my first response on this list so if I get it a little wrong have patience. You may want to look at the light weight RDBMS mysql. It is free, easily installed and can be utilized with the companion Workbench to make dealing with the db very easy, a

Re: Working of Tomcat with MS Access

2011-04-15 Thread Jeff Hubbs
MySQL is indeed another good Open Source RDBMS; I would not call it lightweight in that it is used to power some mighty big Web apps, but the implementation does seem a little quaint. On 4/15/11 11:38 AM, Troy wrote: Raj; To all reading this response, this is my first response on this list

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
I got communications exception when I did this with mysql...and no one knows the reason perfectly...no response from mysql forum too... On Fri, Apr 15, 2011 at 9:08 PM, Troy troylparr...@aol.com wrote: Raj; To all reading this response, this is my first response on this list so if I get it a

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
Yes I already did , that you might think I should. Now I am trying with MS ACCESS...and new error came : SQLException: general error I didn't found any error in my sql syntax or jdbc code. jdbc code alone is working perfectly.. On Fri, Apr 15, 2011 at 9:02 PM, Angel Java Lopez

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
Since I am a beginner, I have to start with some trial projects, right? I know this is nothing! and help me...pls answer to the question.. On Fri, Apr 15, 2011 at 8:41 PM, Jeff Hubbs jhubbsl...@att.net wrote: You do realize, I hope, that what you're proposing is akin to sourcing parts for your

RE: Working of Tomcat with MS Access

2011-04-15 Thread Leo Donahue - PLANDEVX
-Original Message- From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] Sent: Friday, April 15, 2011 10:35 AM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access Since I am a beginner, I have to start with some trial projects, right? I know this is nothing! and help me...pls

Re: Working of Tomcat with MS Access

2011-04-15 Thread Jeff Hubbs
A beginner needs to at least begin with workable platforms and software. PostgreSQL on Linux has a total software license cost of $0.00; your barrier to entry with inappropriate software is considerably higher. On 4/15/11 1:35 PM, RAHUL RAJ wrote: Since I am a beginner, I have to start with

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
, Leo Donahue - PLANDEVX leodona...@mail.maricopa.gov wrote: -Original Message- From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] Sent: Friday, April 15, 2011 10:35 AM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access Since I am a beginner, I have to start with some

Re: Working of Tomcat with MS Access

2011-04-15 Thread Troy
; Connection conn = DriverManager.getConnection(url, , ); Troy -Original Message- From: RAHUL RAJ omrahulraj...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: Fri, Apr 15, 2011 1:31 pm Subject: Re: Working of Tomcat with MS Access I got communications exception

RE: Working of Tomcat with MS Access

2011-04-15 Thread Propes, Barry L
using MS Access, he's probably not on Linux, is he? -Original Message- From: Jeff Hubbs [mailto:jhubbsl...@att.net] Sent: Friday, April 15, 2011 12:46 PM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access A beginner needs to at least begin with workable platforms

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
is: String url = jdbc:mysql://localhost/dbName; Connection conn = DriverManager.getConnection(url, , ); Troy -Original Message- From: RAHUL RAJ omrahulraj...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: Fri, Apr 15, 2011 1:31 pm Subject: Re: Working of Tomcat

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
List Subject: Re: Working of Tomcat with MS Access A beginner needs to at least begin with workable platforms and software. PostgreSQL on Linux has a total software license cost of $0.00; your barrier to entry with inappropriate software is considerably higher. On 4/15/11 1:35 PM, RAHUL RAJ

Re: Working of Tomcat with MS Access

2011-04-15 Thread Mikolaj Rydzewski
RAHUL RAJ wrote: This is like a small assignment that has to be submitted urgently..so I have to run away from the error! and tried with MS ACCESS. The jdbc program for access works perfect alone.. So run tomcat as a 'standalone' java program - that means not as a service. -- Mikolaj

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
running 'tomcat as standalone java program'? can u explain for me sir? 2011/4/15 Mikolaj Rydzewski m...@ceti.pl RAHUL RAJ wrote: This is like a small assignment that has to be submitted urgently..so I have to run away from the error! and tried with MS ACCESS. The jdbc program for access

Re: Working of Tomcat with MS Access

2011-04-15 Thread Troy
@tomcat.apache.org Sent: Fri, Apr 15, 2011 1:59 pm Subject: Re: Working of Tomcat with MS Access ya...I did the same thing you told in mysql...but communications Exception occured.. This is like a small assignment that has to be submitted urgently..so I have to run away from the error! and tried with MS

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
drivers added to your library for the web app? I make this mistake ALL the time. Troy -Original Message- From: RAHUL RAJ omrahulraj...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: Fri, Apr 15, 2011 1:59 pm Subject: Re: Working of Tomcat with MS Access ya

Re: Working of Tomcat with MS Access

2011-04-15 Thread Troy
I believe the drivers should be located in: YourApp/WEB-INF/lib/ Troy -Original Message- From: RAHUL RAJ omrahulraj...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: Fri, Apr 15, 2011 2:35 pm Subject: Re: Working of Tomcat with MS Access Thank you very much

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
-Original Message- From: RAHUL RAJ omrahulraj...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: Fri, Apr 15, 2011 2:35 pm Subject: Re: Working of Tomcat with MS Access Thank you very much for your help! When I did with mysql, the corresponding jdbc driver is stored

Re: Working of Tomcat with MS Access

2011-04-15 Thread Angel Java Lopez
Rahul: Stop tomcat as a service. Go to /tomcatdir/bin Run startup.bat Try your app again. Only to discard user account/access problems. On Fri, Apr 15, 2011 at 3:13 PM, RAHUL RAJ omrahulraj...@gmail.com wrote: running 'tomcat as standalone java program'? can u explain for me sir? 2011/4/15

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
There is no startup.bat file in the directory u specified. In my system the directory path is C:\Program Files\Apache Software Foundation\Tomcat 5.5\bin On Sat, Apr 16, 2011 at 12:14 AM, Angel Java Lopez ajlopez2...@gmail.comwrote: Rahul: Stop tomcat as a service. Go to /tomcatdir/bin Run

Re: Working of Tomcat with MS Access

2011-04-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeff, On 4/15/2011 11:11 AM, Jeff Hubbs wrote: You do realize, I hope, that what you're proposing is akin to sourcing parts for your jet engine from Fisher-Price? :) MS Access is a desktop application that accesses files on disk. Java apps

Re: Working of Tomcat with MS Access

2011-04-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, On 4/15/2011 1:56 PM, Propes, Barry L wrote: Like Jeff says, you can do this basically for no cost using both Tomcat and mySQL. Even better, use JavaDB: it comes with Java and is pretty much guaranteed to work. - -chris -BEGIN PGP

RE: Working of Tomcat with MS Access

2011-04-15 Thread Propes, Barry L
Oh, ok - that's good. Although I'm not familiar with it, but will take it under advisement. -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, April 15, 2011 2:03 PM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access

RE: Working of Tomcat with MS Access

2011-04-15 Thread Leo Donahue - PLANDEVX
-Original Message- From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] Subject: Re: Working of Tomcat with MS Access Yes, it runs as a service. But how to know under what account does that service run? does it mean 'admin' or 'normal user' or 'system'? I made a system DSN

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
...@gmail.com] Subject: Re: Working of Tomcat with MS Access Yes, it runs as a service. But how to know under what account does that service run? does it mean 'admin' or 'normal user' or 'system'? I made a system DSN for this...not the user DSN(Data Source Name) and I launched tomcat service

RE: Working of Tomcat with MS Access

2011-04-15 Thread Leo Donahue - PLANDEVX
-Original Message- From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] Subject: Re: Working of Tomcat with MS Access you said: You need to change that account to one that has access to your mdb. You can do that through the Services console. Or try starting Tomcat via the startup.bat file

Re: Working of Tomcat with MS Access

2011-04-15 Thread André Warnier
Also startup.bat is not there in the specified directory. It is not there because you have downloaded and installed the Tomcat installer version, and that one does not have a startup.bat file. Stop your existing Tomcat service. Go back to the Tomcat website, and download the appropriate

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
I am working on windows platform. I downloaded tomcat setup, md5(.exe) and installed it. On Sat, Apr 16, 2011 at 3:18 AM, André Warnier a...@ice-sa.com wrote: Also startup.bat is not there in the specified directory. It is not there because you have downloaded and installed the Tomcat

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
vista home basic. No, I can restart tomcat each time, by clicking the start/stop button. On Sat, Apr 16, 2011 at 2:49 AM, Leo Donahue - PLANDEVX leodona...@mail.maricopa.gov wrote: -Original Message- From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] Subject: Re: Working of Tomcat

RE: Working of Tomcat with MS Access

2011-04-15 Thread Leo Donahue - PLANDEVX
From: RAHUL RAJ [omrahulraj...@gmail.com] Subject: Re: Working of Tomcat with MS Access vista home basic. No, I can restart tomcat each time, by clicking the start/stop button. Did you try any of the suggestions André or I offered

Re: Working of Tomcat with MS Access

2011-04-15 Thread RAHUL RAJ
: Working of Tomcat with MS Access vista home basic. No, I can restart tomcat each time, by clicking the start/stop button. Did you try any of the suggestions André or I offered? - To unsubscribe, e-mail: users-unsubscr