posted March 27, 2000 01:26 PM            

I need of a clue,

posted March 30, 2000 01:27 PM            

Hold on there's a tutorial here at Devshed that looks like it may have what I need.

posted March 31, 2000 02:19 AM            

I've a different problem, whenever I post details from a form thru servlets into Mysql database, the data goes in as Null. The solution I got is to use Prepared Statement of Java. I've tried that but in vain. If any one has an example of data being posted into Mysql database using servlets please share it with me.

Thanx.

posted April 12, 2000 11:14 AM            

I added the directories to the CLASSPATH in the jserv.properties file and I've since got the driver loading but I still cannot get a connection. Are you saying I need to add the CLASSPATH in the zone.properties file as well?

Here is a more detailed description of the situation as I posted on Sun's Java discussion list.

"This is my setup/configuration:
Sun UltraSparc 2
Solaris 7
Apache 1.3.12 with JServ
ApacheJserv 1.1
JSDK2.0
java1.2
jdk1.2.2 mm.mysql.jdbc-1.2c (was using b but just switched thinking maybe it would fix it)

I'm fairly new to Java and servlets. So I've been working with some of the demo apps and servlets available from Sun, here and other sites on the net. Applications seem to load the driver and connect with no problems but servlets either don't load the driver (I've checked for it with a DriverManager.getDrivers() call and then iterate through the enumeration) or the connection is null. The driver is loaded on the first instantiation (call to the servlet) but if I refresh the browser it disappears. Isn't it supposed to persist once loaded? At first I didn't RTFM so I hadn't put the driver directory in the jserv.properties file. Once I did that the driver started showing up but the connection is always null. I've also tried putting my servers IP number in instead of localhost but then apache returned an internal server error problem. Seems to work sortof with localhost or *."

I've since determined that the driver is staying loaded but the connection isn't connecting.

Robman

posted April 12, 2000 02:44 PM            

Connection dbConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name?username=nobody");

so that was what I put in. What it should be is
Connection dbConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/error_report?nobody");

Could have sworn I tried that but perhaps had something else wrong somewhere. Or perhaps the network gods smiled upon me. Anyway I'm off and running. Extracting data but will soon be trying to post data to the database.

More to follow or perhaps we should start a new thread on posting data into mysql.