i intend on using a javaapplet in conjuction with a mySql databse using jdbc. Before i throw myself into it, can this be done? and if so is there anything i should watch out for? or additionally need to install or download? best regards, zapf
We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
i intend on using a java applet in conjuction with a mySql databse using jdbc. Before i throw myself into it, can this be done? and if so is there anything i should watch out for? or additionally need to install or download? best regards, zack,
I think the gotchas are on the Applet site rather than on the JDBC side, so you may be better off posting in the Applets forum. Here are a few things to bear in mind that I've picked up from using this forum (I've never used Applets myself, however):
You'll need to use a type 3 (pure Java, net protocol) JDBC driver
You can only connect to a DB via the same location that served the applet
I've seen first-timers struggling with JNDI and javax.sql.DataSource; something to do with configuration parameters