This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
Hello everyone am using windows 7 64 bit operating system and developing my first servlet which contains a database in it. can anybody tell me which DBMS should i use so that i can create a table and save records in it? Many thanks!!!
Tim, i have been taught that we should use JDBC-ODBC bridge and ODBC driver to connect your standalone or a web application to the database but i dont know if we can use or connect the application with the database using something else...please help..i know this may be funny for you but am sorry am very new to this all...thanks!!!
Pranit Sonawane wrote:Hello everyone am using windows 7 64 bit operating system and developing my first servlet which contains a database in it. can anybody tell me which DBMS should i use so that i can create a table and save records in it? Many thanks!!!
- Don't bother to connect using ODBC - there are jdbc drivers available for all the database servers and they work very well because they were developed by the same people who developed the actual server. The fastest in my opinion is to install mysql (comes with a very handy msi installer) and download the jdbc driver from the same place.
- Please don't use the DriverManager.registerDriver approach to get the connection, rather install the jdbc jar file in the application server classpath (lib folder for tomcat 6 - 7) and register a data source.
- As it was mentioned in other messages from this forum, accessing database from the presentation tier or controller should be avoided and instead you should define a service tier and access it from there. But if you just want to "see how it works" that's different.
Joined: Sep 21, 2011
Pranit Sonawane wrote:Tim, i have been taught that we should use JDBC-ODBC bridge and ODBC driver to connect your standalone or a web application to the database
You need to unlearn that. The JDBC/ODBC bridge driver is buggy and not thread-safe; the latter point alone makes it unsuitable for web applications. The type of driver pretty much everyone uses these days is called type 4 driver, and that's what you'll find on that Oracle page.
Alright people now i need to download a database management system for my windows 7 64 bit please help me with this. I have oracle 10 g but dont have a driver to connect it and create a DSN. please help me with the link also. Many thanks!!!