Getting J2EE to use mySQL
843830Jan 21 2005 — edited May 17 2005Hi
(I accidentally posted this in the portability forum, thought it would be ok, then noticed it's almost a month since the last post, so apologies for cross posting here)
I'm using a standalone RedHat 9 system with J2EE 1.3.1 and mySQL 3.23.54.
All are working individually.
My current application creates new tables every time it starts, so I thought it would be dead simple to just ask J2EE to use mySQL. There are currently only two entity beans, and there's the place in the deploytool to enter the database JNDI name, username and password.
I can't find any information on how to do it though. What do I enter where? Sun's site doesn't seem to tell me about mySQL and J2EE, while mySQL has not one mention of J2EE in its documentation, nor in Kofler (my mySQL book).
I looked back through this forum too, and there's a link to a blog that doesn't seem relevant either.
Clues anyone? Much appreciated. If I see you, I'll buy you a pint. Warm, obviously (I'm in the UK). You'll like it, honest :-)
J