Jboss 3.2.5 + spring + hsql
mmarcom Nov 16, 2005 5:51 AMhello all,
i am trying to deploy a spring-based application that uses HSQL in memory database.
I have a bean (defined in spring) that , when applicationContext is initialized, will connect to an in memory instance of HSQL database and try to populate it..
But when my application is starting, i am receiving the following exception :
2005-11-16 10:41:10,632 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourcePopulator' defined in ServletContext resource [/WEB-INF/dataSourcePopulator.xml]: Initialization of bean failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: User not found: SA
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: User not found: SA
java.sql.SQLException: User not found: SA
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.UserManager.get(Unknown Source)
at org.hsqldb.UserManager.getUser(Unknown Source)
at org.hsqldb.Database.connect(Unknown Source)
at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:290)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:276)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:258)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:240)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:107)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:246)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:293)
at com.myapp.backend.util.DataSourcePopulator.createTables(DataSourcePopulator.java:102)
at com.myapp.backend.util.DataSourcePopulator.init(DataSourcePopulator.java:81)
anyone could help me out?
i have no hsql-ds.xml deployed, i thought i don' tneed it for in-memory database....
thanks and regards
marco