Java Errors

[pcarpen]

My Subsonic install suddenly stopped working with this error:

Error

Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.
Exception org.springframework.jdbc.CannotGetJdbcConnectionException
Message Could not get JDBC Connection; nested exception is java.sql.SQLException: File input/output error: Unexpected token: �
Java version Sun Microsystems Inc. 1.6.0_03
Operating system Windows XP 5.1
Server jetty-6.1.x
Memory Used 5 of 7 MB
Stack trace org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: File input/output error: Unexpected token: � at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:552) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
....

I tried uninstalling both subsonic and Tomcat, but I get the same issues. I also tried using the Windows standalone installer, again with the same results. Could this be due to a new Java version.

Thanks,
pete

[sindre_mehus]

I haven't seen this before. Looks like the database is corrupt. It's located in c:\subsonic\db, and is a HSQL database.

If you are technically inclined you might wanna head to http://hsqldb.org/ and see if there are some database recovery tools. Otherwise, you can delete the entire c:\subsonic\db directory, and let it be re-created by Subsonic. You will of course loose all your data (users, statistics, config etc).

Cheers,
Sindre

[pcarpen]

Thanks Sindre. That did the trick. I simply deleted the C:\subsonic directory and let it genereate the database. I lost my settings, but those are easy to set up again. Thanks for your help.