The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes EJB and MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "EJB and MySQL" Watch "EJB and MySQL" New topic


Duran Harris
Ranch Hand

Joined: Nov 09, 2008
Posts: 608

Hi ..i've been going through Paul Sanghera's SCBCD study guide in an attempt to create a solution.(Okay I know this isn't a certification question but I thought I would post here because I am using the certification book+sylabbus)

The current situation is that we have a MySQL database on our server that is accessed through a (PHP&Javascript)web application that is distributed to all the branches of the business.We now have a need to provide certain contractors the ability to query subsets of the DB remotely from their business premises...Hence why I'm study the SCBCD study guide.

What I would like to know is if it is possible to have the entity beans operate on the mysql database somehow?

===>SCJP 1.5(72%)<===
Christophe Verré

Joined: Nov 24, 2005
Posts: 14688

Any databases providing a JDBC driver can be used. So MySQL can be used.

[My Blog]
All roads lead to JavaRanch
Duran Harris
Ranch Hand

Joined: Nov 09, 2008
Posts: 608

Wow thanks..
So the same packages are used for mySQL...javax.SQL?
Also my EJB book is old....should I get additional study material
for EJB3.0?I dont even know if the examples will work on j2ee 5
I agree. Here's the link:
subject: EJB and MySQL
jQuery in Action, 3rd edition