setting db.url in Spring tutorial

[Mirrell Knabe]

Hi All -

For the life of me I am not setting the db.url in build.properties correctly for the Spring tutoiral...I have tried everything to no avail...

this is the error I am receiving when launching the page:

    
java.sql.SQLException: Table not found in statement [select id, description, price from products]
	org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
	org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)

this is my build.properties:

    
# Ant propert
appserver.home=${user.home}/latest versions/apache-ant-1.8.1-bin/apache-ant-1.8.1
# for Tomcat 5 use $appserver.home}/server/lib
# for Tomcat 6 use $appserver.home}/lib
appserver.lib=${appserver.home}/lib

deploy.path=${appserver.home}/webapps

tomcat.manager.url=http://localhost:8080/manager
tomcat.manager.username=tomcat
tomcat.manager.password=s3cret

db.driver=org.hsqldb.jdbcDriver
db.url=jdbc:hsqldb:MyDB
db.user=sa
db.pw=

this is the HSQLDB properties screen within the Eclipse IDE:

    
Database: products
Database Location: MyDB
User Name: sa
Password:
URL: jdbc:hsqldb:MyDB

when I do a TEST CONNECTION it is successful....

Any help would be GREATLY appreciated!

Thanks!

[Mirrell Knabe]

Hi All -

I was able to fix the problem, by putting the same database entries into the jdbc.properties file...

Thanks!