 |  |  |  |  |  |  |  |
servlet +tomcat 5.0.28+access database+problems
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Oct 2007
Posts: 32
Reputation: 
Solved Threads: 2
Light Poster
hi all
new to tomcat..
i installed tomcat on c:/tomcat 5.0.28 and c:\j2sdk1.4.1_07. i run my hello world servlet ,did all stuff making diretories,web.xml for running a servlet .it execute on my system.
i search for this in google,but i don't understand !!!!
but if my servlets are using or want to connect to ms-access database then i have no idea .how to configure or connect my servlets to database.?
from rohit sharma
new to tomcat..
i installed tomcat on c:/tomcat 5.0.28 and c:\j2sdk1.4.1_07. i run my hello world servlet ,did all stuff making diretories,web.xml for running a servlet .it execute on my system.
i search for this in google,but i don't understand !!!!
but if my servlets are using or want to connect to ms-access database then i have no idea .how to configure or connect my servlets to database.?
from rohit sharma
Last edited by rohitrohitrohit; Sep 29th, 2008 at 4:39 am. Reason: clearing my question for reading...
•
•
Join Date: Jul 2007
Posts: 1,176
Reputation: 
Solved Threads: 125
Have you tried connecting to a database via a Normal Java program before jumping to Servlets ???
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
Join Date: Dec 2004
Posts: 4,117
Reputation:
Solved Threads: 471
Java Sun JDBC Basics tutorial, what more you need? Don't forget to get proper drivers for that crappy database of Microsoft (sorry I just do not like Access).
I do not really understand why people do not use free available MySQL Community Server
I do not really understand why people do not use free available MySQL Community Server
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
•
•
Join Date: Jul 2007
Posts: 1,176
Reputation:
Solved Threads: 125
For MS Access I think you do not have a choice but to use the JDBC-ODBC Bridge.
<EDIT> At least thats what I thought before I came across this page </EDIT>
Also if you would like to connect to your database with out creating a DSN by using the following connection string:-
Just replace {PATH_TO_MDB_FILE} with the absolute path to your MS Access file.
By the way why are you using such an old version of the JDK ???
I can round up all the possible reasons from that in word "IGNORANCE".
<EDIT> At least thats what I thought before I came across this page </EDIT>
Also if you would like to connect to your database with out creating a DSN by using the following connection string:-
JSP Syntax (Toggle Plain Text)
Just replace {PATH_TO_MDB_FILE} with the absolute path to your MS Access file.
By the way why are you using such an old version of the JDK ???
•
•
•
•
I do not really understand why people do not use free available MySQL Community Server
Last edited by stephen84s; Sep 29th, 2008 at 3:30 pm.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
•
•
Join Date: Jun 2006
Posts: 7,581
Reputation:
Solved Threads: 461
•
•
•
•
Originally Posted by peter_budo 
I do not really understand why people do not use free available MySQL Community Server
•
•
•
•
Originally Posted by stephen84s
By the way why are you using such an old version of the JDK ???
I can round up all the possible reasons from that in word "IGNORANCE".
Oh and BTW, when projects related to real money are involved, MySQL isn't even there; the market here is dominated by age old tried and tested database vendors like Oracle, Sybase and DB2. And please let me not hear about how real world high traffic sites like YouTube and message boards use MySQL. No one gives a damn if a few screw ups happen when you are creating a thread, making a post or uploading a video. But when real world money transactions are involved...
I don't accept change; I don't deserve to live.
•
•
Join Date: Dec 2004
Posts: 4,117
Reputation:
Solved Threads: 471
I'm not sure she is not on microsoft pay book 
I'm sure that large projects involve other databases then MySQL. However you have to admit that it is largely used by smaller and medium size companies. Secondly it one of the "have" skill/knowledge when you looking for job as far I seen on job offers in UK. And lastly I still consider to be better starting option then Access as rohitrohitrohit is beginner
•
•
•
•
Originally Posted by ~s.o.s~
Oh and BTW, when projects related to real money are involved, MySQL isn't even there; the market here is dominated by age old tried and tested database vendors like Oracle, Sybase and DB2. And please let me not hear about how real world high traffic sites like YouTube and message boards use MySQL. No one gives a damn if a few screw ups happen when you are creating a thread, making a post or uploading a video. But when real world money transactions are involved...
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
•
•
Join Date: Jul 2007
Posts: 1,176
Reputation:
Solved Threads: 125
Well I agree with ~sos~ as far as maintaining compatibility with legacy systems is concerned, but if we look at the current context, the thread starter I do not think is dealing with such critical systems and sounds more like a beginner to Java, so its got to be Ignorance .
<EDIT> @Peter Budo's post ... didn't see it, damn I should learn to refresh my pages more often
And yes I agree Small and Mid-Size firms prefer going for MySQL, an example is the firm which employs me has got 70% its critical data in MySQL DBs.
.<EDIT> @Peter Budo's post ... didn't see it, damn I should learn to refresh my pages more often
And yes I agree Small and Mid-Size firms prefer going for MySQL, an example is the firm which employs me has got 70% its critical data in MySQL DBs.
Last edited by stephen84s; Oct 2nd, 2008 at 5:16 am.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
"How to ask questions the smart way ?"
"How to ask questions the smart way ?"
|
Similar Threads
- Opinions? javascript/php/etc and programming standards (JavaScript / DHTML / AJAX)
- URGENT: JSP - StackOverFlow Error (JSP)
- hover over text tips (JavaScript / DHTML / AJAX)
Other Threads in the JSP Forum
- Previous Thread: help me
- Next Thread: Disabling text-wrapping for f:selectItem tags
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest JSP Posts
- Today's Posts
- Unanswered Threads
apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish imagetodatabse imageupload internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial video web