Bug #51618 | error connecting: java.sql.SQLException: Column Index out of range, 0 < 1 | ||
---|---|---|---|
Submitted: | 1 Mar 2010 18:25 | Modified: | 9 Mar 2010 6:55 |
Reporter: | Greg Beis | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / J | Severity: | S3 (Non-critical) |
Version: | mysql-connector-java-5.1.12 | OS: | Windows (XP) |
Assigned to: | CPU Architecture: | Any |
[1 Mar 2010 18:25]
Greg Beis
[3 Mar 2010 17:18]
Tonci Grgin
Hi Greg and thanks for your report. It seems you have troubles connecting. Did you passed username and password (jdbc:mysql://opensol:3306/test?user=root&password=***)? If you do and you confirmed driver connected to server, can you please attach small but complete stand-alone test case exhibiting this error?
[9 Mar 2010 6:03]
Greg Beis
Hello Tonci, I managed to solve the problem by switching from MySQL 5.0 to MySQL 5.1 and by placing the mysq-connector-java5.1.12 under WEB-INF/lib/. Thank you for the support. Regards, Greg
[9 Mar 2010 6:55]
Tonci Grgin
Greg, glad things work now. If you can just determine which of the two changes caused code to work it might be helpful for others.