LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Leaner

I've been trying all kinds to get JDBC working on LAE 5.0.0.1 (Windows) but I cannot get the driver to work. Which version of Java should I be running?

I looked at forum posts here of where the jre files should go, but they are all years old and those paths do not exist on my Lavastorm installation. Could some one please verify where the jres should go?

Nevertheless, my whole aim of getting JDBC to work is because I need to connect to our MySQL web servers via SSH (however this takes me, I am not opening port 3306). I've dug in here and even used Google to search this forum and cannot find anyone else doing the same?

Guide to tunnel the MySQL connections: http://dev.mysql.com/doc/refman/5.1/...s-and-ssh.html

Any help is appreciated.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

Perhaps someone else can answer about using MySQL over SSH, however, regarding your other questions:

1. The JDBC drivers should be placed into lib/java/ext in your installation directory. The ext directory won't be created by the installation, you'll need to create that directory yourself (I believe in the upcoming 5.1 release, this directory is created automatically).
2. On windows, Java is installed with the LAE instance, so you don't need to install that yourself or change anything to use a different version. This will be the 32 bit 1.7.0_51 version of the JDK.
3. When you are asking about where the JRE's should go - are you referring to the JAR files (location mentioned above).
4. The 5.1 MySQL JDBC drivers (jar files) available here: http://dev.mysql.com/downloads/connector/j/ should be fine to use.

Regards,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Leaner

Hi Tim,

Thanks for the reply, I just ended up building an SSH tunnel to the server to query the DB in it. It quite fast too and avoids any potential Java issues.