-
1. Re: Is DefaultDS and hsqldb-service.xml required?
gary_kephart Jan 29, 2003 8:13 PM (in response to jbig)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. -
2. Re: Is DefaultDS and hsqldb-service.xml required?
jbig Jan 29, 2003 9:14 PM (in response to 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 -
3. Re: Is DefaultDS and hsqldb-service.xml required?
gary_kephart Jan 30, 2003 12:39 PM (in response to jbig)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)?