1 Reply Latest reply on Nov 16, 2005 11:17 AM by Marco

    Jboss 3.2.5 + spring + hsql

    Marco Novice

      hello 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