Portal Home > Knowledgebase > Articles Database > Need help with Java
Need help with Java
| Posted by openXS, 06-12-2007, 02:35 AM |
| Hi,
I've a jsp web search engine running on Windows, Apache 2.0.59 and Tomcat 5.5.17 using Mod_jk, db is MySQL 4.1.22. The App was running fine on the previous server until I switched to this new dedicated server.
I'm getting an error (check error.txt attached) on every search. Also attached is the log file (log.txt).
Last time this happened, I reinstalled mysql and it worked, but it isnt working this time no matter what I do.
Error can ve repeated using this link: http://www.q3lly.com/v/search.do?dis...t&p=&q=keyword (replace '3' with 'e' in q3lly)
Its a windows server and can be accessed via RDC (remote desktop).
(I can pay a small fee for this via PayPal.)
Thanks.
Attached Files
error.txt
(2.3 KB, 42 views)
log.txt
(66.5 KB, 38 views)
|
| Posted by cywkevin, 06-12-2007, 02:39 AM |
| I think that signifies mysql is not running or connection cannot be established to it.
|
| Posted by openXS, 06-12-2007, 02:44 AM |
| MySQL is running, for sure. How can the connection not establish? I didn't change a thing since last time. Everything (including paths) is same.
Attached is the applications torque.properties (made it torque.properties.txt to attach), please see if it needs any change?
Many Thanks
Last edited by openXS; 06-14-2007 at 01:53 AM.
|
| Posted by cywkevin, 06-12-2007, 02:52 AM |
| First off edit that file so you don't give out your mysql root password
|
| Posted by openXS, 06-12-2007, 02:55 AM |
| Errmmm.....!! (Currently theres nothing in there though. Its a test server.)
Pass changed. MODS: Please remove the torque.properties.txt
|
| Posted by openXS, 06-12-2007, 03:09 AM |
| So do you see any solution for this? Last time I just reinstalled Mysql and it worked, but that trick isn't working now.
|
| Posted by openXS, 06-12-2007, 10:38 AM |
| bump* anyone?
Any help greatly appreciated.
|
| Posted by vselvara, 06-13-2007, 07:14 PM |
| 1. Are you able to connect to the mysql server using the client?
2. What version of the MySQL JDBC driver are you using? Some versions are not compatiable with some mysql server versions.
|
| Posted by openXS, 06-13-2007, 09:51 PM |
| 1. Yes, I think so.
2. I'm not sure about this, where/how do I check for this?
|
| Posted by openXS, 06-13-2007, 11:41 PM |
| I downloaded MySQL Java connection 3.1.14 (zip) and tried replacing mysql-connector-java-3.0.8-stable-bin.jar in C:\www\tomcat5\webapps\v\WEB-INF\lib with mysql-connector-java-3.1.14-bin.jar
(Restarted Tomcat) But still the same error. Do I need to reboot or configure something to get it work?
Thanks
|
| Posted by openXS, 06-14-2007, 12:25 AM |
| I also tried replacing mysql-connector-java-3.0.8-stable-bin.jar with mysql-connector-java-3.0.17-ga.zip in C:\www\tomcat5\webapps\v\WEB-INF\lib.
And now I get a different error:
(replace '3' with 'e' in q3lly)
..but there's no such table! What do I do now?
Thanks.
|
| Posted by vselvara, 06-14-2007, 06:31 PM |
| Do you have a script to create the tables? Connect to the DB and list the tables "show tables". Check if it exists. If not, do you have a script to recreate those tables? You may also want to get support from the developer(s) of that application.
|
| Posted by openXS, 06-14-2007, 09:40 PM |
| Everythings good on the application end. I'm sure its just related to mysql and connector-j version issue. But it worked last time with the same setup.
Mysql-Java-Connector-3.0.8
with
Mysql 4.1.22
I even tried Mysql 4.1.20 with Connector- J 3.0.17 and 3.1.14
:-(
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
