This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which Oracle database to use in a 64 bit laptop to make a JDBC connection.

 
Yuta Lolap
Ranch Hand
Posts: 86
Eclipse IDE Java jQuery
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to work on Eclipse and make a Billing System. They have asked me to use a Oracle DB and Tomcat.

The problem i am facing is my laptop is 64 bit. I found Exlipsee IDE JEE for 64 bit . But i cant find the right database or tomcat apache. I installed Oracle 11g ExpressEdition(only Windows 32 bit is available on their website) but when i create a table in it. I cant access it while making the jdbc connection when i do so by going in the Device manager and so on. I can see something called SQL Native Client and Microsoft Access and so on. It says driver doesnt exists and architecture not supported.

I have 4 weeks left to complet this project! And i havent started at all! Please help me in finding the right versions which will work!


IDE – Integrated Development Environment
Suggested Tool: Eclipse 3.x
CMS – Configuration Management System
Suggested Tool: CVS
Web Server
Suggested Tool: Tomcat
Development Platform: J2EE
Framework: Struts 1.2 and above
Architecture: MVC (Model View Controller)
Languages: Model (PL/SQL), View(JSP), Controller(Struts/Core Java)
Database: Oracle


Above mentioned are the techincal specifications required for my project. In the Model Layer of MVC architecture they have said Pl/SQL . I need a Database compatible with my 64 bit laptop. Also are there any jdbc drivers that i need to install? Please Suggest Something. I would be very grateful to all.

Thanks & Regards,
Ms. Yuta Lolap.
 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you should have an Oracle JDBC driver in your libraries in Eclipse. Check which version it is and make sure it is the correct one.

The reports are mixed on using the 32 bit version of Oracle Express on 64 bit windows. If you can't get Oracle to work, you can use a different database for development.

Your application should be loosely coupled with the database anyway so that it won't matter which one you use while you develop. Get HSQLDB, MySQL, or Postgresql and develop against that until they give you an oracle DEV environment on their servers to deploy against.
 
Yuta Lolap
Ranch Hand
Posts: 86
Eclipse IDE Java jQuery
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Where can I download these? Via torrents? Are these 64 bit versions?

HSQLDB, MySQL, or Postgresql.


I have oracle 9i. will that work properly? I have the jdbc driver for it also. I haven't installed it.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HSQLDB, MySQL, Postgresql

Ya know, SearchFirst. The first hit on Google is actually the correct one in each of these cases.

I have oracle 9i. will that work properly? I have the jdbc driver for it also. I haven't installed it.

If you have an 9i instance installed somewhere, you certainly can use it. I doubt you'll be able to install in on the newest version of Windows, though.

We have an Oracle FAQ page with useful links and infos on Oracle JDBC drivers here.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic