Could not get JDBC Connection

amy

Hello,

I'm a newbie to spring but I somehow got it to work properly, so that data access worked fine for all database operations.

However, yesterday suddenly an error occured during a database operation.Since then, I always get the same error when trying to compile:Code:
Exception in thread quot;mainquot; org..jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: User not found: SA  at org..jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)  at org..jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)  at org..jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)  at org..jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)  at org..jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698)  at org..jdbc.object.SqlQuery.execute(SqlQuery.java:112)  at org..jdbc.object.SqlQuery.execute(SqlQuery.java:122)  at org..jdbc.object.SqlQuery.execute(SqlQuery.java:137)  at pmdbproject.pmdb.databasehandling.dao.MovieManager.getAllMovies(MovieManager.java:176)  at pmdbproject.Controls.MediaTableModel.getDataFromDB(MediaTableModel.java:90)  at pmdbproject.Controls.MediaTableModel.lt;initgt;(MediaTableModel.java:35)  at pmdbproject.Controls.MediaTable.lt;initgt;(MediaTable.java:48)  at pmdbproject.Controls.MediaLibrary.setupSwing(MediaLibrary.java:113)  at pmdbproject.Controls.MediaLibrary.lt;initgt;(MediaLibrary.java:52)  at pmdbproject.UI.PMDB.setupSwing(PMDB.java:269)  at pmdbproject.UI.PMDB.lt;initgt;(PMDB.java:75)  at pmdbproject.UI.PMDB.main(PMDB.java:63)
Caused by: java.sql.SQLException: User not found: SA  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)  at org.hsqldb.jdbc.jdbcConnection.lt;initgt;(Unknown Source)  at org.hsqldb.jdbcDriver.getConnection(Unknown Source)  at org.hsqldb.jdbcDriver.connect(Unknown Source)  at java.sql.DriverManager.getConnection(DriverManager.java:582)  at java.sql.DriverManager.getConnection(DriverManager.java:154)  at org..jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)  at org..jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)  at org..jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)  at org..jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)  at org..jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)  at org..jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)  ... 16 more
I'm not an expert, but I think that the relevant part in the XML file for the database access is mainly this one:Code:
lt;bean id=quot;HsqldbDataSourcequot;     class=quot;org..jdbc.datasource.DriverManagerDataSourcequot;gt;     lt;property name=quot;driverClassNamequot; value=quot;org.hsqldb.jdbcDriverquot; /gt;     lt;property name=quot;uclquot; value=quot;jdbc:hsqldb:file:/pmdbquot; /gt;     lt;property name=quot;usernamequot; value=quot;saquot; /gt;     lt;property name=quot;passwordquot; value=quot;quot; /gt;     lt;property name=quot;connectionPropertiesquot;gt;        lt;propsgt;lt;prop key=quot;shutdownquot;gt;truelt;/propgt;        lt;/propsgt;     lt;/propertygt;
lt;/beangt;

I haven't changed the username, so I'm totally confused about this error. If you need any more information, please ask me to post it.

I'm using eclipse and hsqldb.

Maybe you need have a look for the database.script to check the username.

Or use a database tool to connect the db for try..