David & Alex, Thanks for your help. The following connection info worked for me.
SQL Client: iSQL-Viewer v2.1.0 Driver: org.hsqldb.jdbcDriver URL: jdbc:hsqldb:hsql://localhost:1476 User: sa Password: (none) As such, I've been able to verify that at least some of the INSERT statements are working. The failure of the SELECT statements is still a mystery... - Matt Munz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Ward Sent: Thursday, May 30, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] incorrect SQL generated for findAll() on CMP bean Have you tried sqldeveloper yet? 1) Make you have $JBOSS_HOME/lib/hsqldb.jar in your $CLASSPATH for your jdbc client. 2) Make sure JBoss has hsqldb-service.xml in $JBOSS_HOME/server/default/deploy/. 3) Make sure JBoss is running. ;) 4) Use these settings from your jdbc client (if you haven't tweaked hsqldb-service.xml or ../config/login-config.xml): Driver: org.hsqldb.jdbcDriver URL: jdbc:hsqldb:hsql://localhost:1476 User: sa Password: (none) Name: default (database name) This works for me since I do it all the time. Hope this helps, David -- Matt Munz wrote: > Alex, > > Thanks for the pointer. I seem to be having trouble, however, > constructing the correct jdbc url. Any ideas? > > Also, if anyone has any ideas about how to solve my problem with incorrect > SQL being generated for findAll(), please share them. If not, is there some > other mailing list I should try? > > - Matt > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Alex > Loubyansky > Sent: Thursday, May 30, 2002 2:12 AM > To: Matt Munz > Cc: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] incorrect SQL generated for findAll() on CMP > bean > > > Hello Matt, > > MM> Also, I would like to familiarize myself with the Hypersonic db > embedded > MM> in jboss, and to verify that the shirts are in fact being added to that > MM> database. Is there a SQL or other tool that I can use to access the db > MM> manually? > > Not sure how it's good comparing to other tools (just haven't tried others) > but you can try > ISQL-Viewer. http://www.isqlviewer.com > > -- > Best regards, > Alex Loubyansky > > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user -- --------------------- David Ward [EMAIL PROTECTED] http://www.dotech.com _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
