Is DefaultDS and hsqldb-service.xml required?

[jbig]

When using other databases -

Is DefaultDS needed? can't make changes to the ../conf/standard* files on this value without getting a million errors...

Is ../deploy/hsqldb-service.xml needed? can't delete this without getting a million errors...

When I leave them as is the errors disapear but still can't get a simple db login to Postgres - only 1 'table not found' error - seems like it only connects to DefaultDS no PostgresDS
(the library and postgres-service.xml files are in place etc.)
thanks thanks

[gary_kephart]

I think your problem and mine are the same.
http://jboss.org/forums/thread.jsp?forum=144&thread=27575

I finally traced mine back to hsqldb. Looks like I've got the data source configured wrong. Don't know how to fix it yet.

[jbig]

I fell for that one too:

this.dataSource = (DataSource)ic.lookup("java:comp/env/jdbc/bahiawebDB");

it didn't work until I changed it to this:
this.dataSource = (DataSource)ic.lookup("java:/bahiawebDB");

now i actually get a login
and it turns out that hsqldb is irrelevant - it can just stay in the deploy directory as is, ditto for the ../conf/standard* files - just leave them alone.
d

[gary_kephart]

That may be _a_ solution, but I don't think it's the best solution. Using the full name worked in WebLogic, and all this JNDI stuff is supposed to be server-independent, right?

BTW, I seemed to have gotten a litter further after renaming the hsqldb from java:/DefaultDS to java:/hsqlDB. I then renamed my database to java:/DefaultDB.

But this leads to another question. Do we need to have one msaccess-service.xml (or whatever your database is) file for each database connection URL (just rename it to something unique)?