mysql, jdbc, tomcat, jsp...
hi,
i am new in this topic.
i have some simple questions:
i use windows. i downloaded eclipse wtp, mysql 5.0.41, apache tomcat 6.0.13 and installed them all.
what version of jdbc should i download and what are the steps for a working connection between jsp and mysql?
what is the code that i should copy on the classpath?
where is classpath?
i know it is very boring for you but if you could help i would be so pleased:)
thank you..
[487 byte] By [
yekocana] at [2007-11-27 10:02:38]
# 1
Download the newest Connector/J from www.mysql.orgThen read the JDBC tutorials (java.sun.com) and the Tomcat documentation.And, judging by the last question, maybe you should read through all the tutorials at java.sun.com.
# 2
> what version of jdbc should i download
JDBC is just available in the JDK.
If you mean the JDBC driver, the Connector/J, just refer to the manfacturer's site.
Here is a link: http://www.mysql.com/products/connector/j/
For Java 1.5 (JDBC 3.0), get the Connector/J 5.0.
For Java 1.6 (JDBC 4.0), get the Connector/J 5.1.
> and what are the steps for a working connection between jsp and mysql?
> what is the code that i should copy on the classpath?
Read the reference manual available at the Connector/J site.
http://dev.mysql.com/doc/refman/5.0/en/connector-j.html
> where is classpath?
It depends on the running environment. As you're using Eclipse, just rightclick at the project, choose Properties, navigate to Java Build Path, choose tab Libraries and add the JAR to the classpath.
