aspose file tools*
The moose likes JDBC and the fly likes Connecting to MySQL locally via JNDI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to MySQL locally via JNDI " Watch "Connecting to MySQL locally via JNDI " New topic
Author

Connecting to MySQL locally via JNDI

Zein Nunna
Ranch Hand

Joined: Mar 31, 2005
Posts: 245
Hi guys,

I'm using a Tomcat 5.5.17, MySQL DB and and JSP's at this point in time, possibly changing to JSF.

What I've acheived currenlty is to use the code below (and some more) to connect to a DB - i.e.just java-database (no webserever)


On the Tomcat I'm using JNDI. I want to do the same locally, rather than use two distinct methodologies and then cut/paste code etc.

Does anyone know of a good code examples on how I could use JNDI locally i.e. between java-mySQL database (not using the browser).

Thanks in advance for your views
Zein
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
This sounds like a good idea, except there's only one problem: To use JNDI, you have to have a server that supports JNDI running or your JNDI lookup will fail. This means you're making your stand-alone java application so that it won't run unless a JNDI server is running. Not such a good idea.

With some good OO-Design, it's not that hard to design a flexible solution. Create an interface for a service that gets a database connection. Then create two different implementations of that interface -- one for JNDI and one for stand-alone Java. In your application code, you'd then code to the interface rather than the implementation.
[ March 03, 2007: Message edited by: Merrill Higginson ]

Merrill
Consultant, Sima Solutions
 
jQuery in Action, 2nd edition
 
subject: Connecting to MySQL locally via JNDI
 
Similar Threads
XA vs non-XA
MySQL IN an app locally no internet connection in app[no mysql], can you tell some key tricks/tips
Unable to load database schema in Jboss Dev Seam Project
JNDI connection to MySQL
mysql support to datamining