JSP and MySQL.. Help Please

[aarushi2001]

Hi,

Can anyone help me with mysql-connector-java-3.1.11 and tomcat??

I have installed Tomcat 5.5.12 and MySql-Connector-Java-3.1.11 under common/lib

How can I use JSP and MySql? Please help..

 

[Diancecht]

I think some more details are needed.

You need help about everything, a tutorial or anything special?

Cheers,
Dian

 

[aarushi2001]

I dont need help abt everything.. I have worked with JSP and MySQL but that was like 2 years back. cant understand MySql Connector.. thats all..

More info: I have installed JDK, MySQL, Tomcat and MySQL Connector. JDK is working well (wrote a java program and worked well), MySQL is also working and I can even code in JSP.

Once I understand MySQLConnector, I can create database-driven website (basically how to set up MySQL connector and access database).

I hope I clarified myself.

Thanks

 

[sedj]

Not sure what you mean by "MySQLConnector" - but the jar file you talk of provides JDBC support for connecting to a MySQL (or any other db) database via JDBC.

Read the tutorials and documentation here :

http://java.sun.com/products/jdbc/

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[aarushi2001]

I am not able to use that jar file, the way tutorial asks to put it under common/lib.. I have done but when I try n connect, am given an error..

 

[Diancecht]

If you post the error, it can be a good beginning.

Cheers,
Dian

 

[aarushi2001]

thanks Dian.. I will email tomorrow..

 

[timw]

... in addition, posting the code you're using to connect might be a good idea.

Tim
---------------------------
"Your morbid fear of losing,
destroys the lives you're using." - Ozzy

 

[sedj]

What do you mean by "I am not able to use that jar file" ? In what way are you not able ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[aarushi2001]

Hey, I did it!! Can connect to MySQL through JSP

 

[timw]

Well done

Tim
---------------------------
"Your morbid fear of losing,
destroys the lives you're using." - Ozzy