Hello Matt, Thursday, May 30, 2002, 6:07:17 PM, you wrote:
MM> Alex, >>What the trouble is? Do you know the correct url to connect to your >>database? MM> no. that is the problem >>If you successfully use it with JBoss, just copy&paste it from >>xxx-service.xml or jboss.jcml.\ By 'xxx' I meant the service file for your database connection management configuartion, i.e. for hypersonic it is hsqldb-service.xml There you should find this line: <config-property name="ConnectionURL" type="java.lang.String">jdbc:hsqldb:hsql://localhost:1476</config-property> That's it. Goodluck! MM> jboss-service.xml does not contain this information, and I can't find MM> jboss.jcml. Is there anywhere else I should look? MM> - Matt MM> -----Original Message----- MM> From: Alex Loubyansky [mailto:[EMAIL PROTECTED]] MM> Sent: Thursday, May 30, 2002 10:57 AM MM> To: Matt Munz MM> Cc: [EMAIL PROTECTED] MM> Subject: Re[2]: [JBoss-user] incorrect SQL generated for findAll() on MM> CMP bean MM> Hello Matt, MM> Thursday, May 30, 2002, 5:34:57 PM, you wrote: MM>> Alex, MM>> Thanks for the pointer. I seem to be having trouble, however, MM>> constructing the correct jdbc url. Any ideas? MM> What the trouble is? Do you know the correct url to connect to your MM> database? MM> If you successfully use it with JBoss, just copy&paste it from MM> xxx-service.xml or jboss.jcml. MM>> Also, if anyone has any ideas about how to solve my problem with MM> incorrect MM>> SQL being generated for findAll(), please share them. If not, is there MM> some MM>> other mailing list I should try? MM>> - Matt MM>> -----Original Message----- MM>> From: [EMAIL PROTECTED] MM>> [mailto:[EMAIL PROTECTED]]On Behalf Of Alex MM>> Loubyansky MM>> Sent: Thursday, May 30, 2002 2:12 AM MM>> To: Matt Munz MM>> Cc: [EMAIL PROTECTED] MM>> Subject: Re: [JBoss-user] incorrect SQL generated for findAll() on CMP MM>> bean MM>> Hello Matt, MM>>> Also, I would like to familiarize myself with the Hypersonic db MM>> 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? MM>> Not sure how it's good comparing to other tools (just haven't tried MM> others) MM>> but you can try MM>> ISQL-Viewer. http://www.isqlviewer.com MM>> -- MM>> Best regards, MM>> Alex Loubyansky MM>> _______________________________________________________________ MM>> Don't miss the 2002 Sprint PCS Application Developer's Conference MM>> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm MM>> _______________________________________________ MM>> JBoss-user mailing list MM>> [EMAIL PROTECTED] MM>> https://lists.sourceforge.net/lists/listinfo/jboss-user MM>> _______________________________________________________________ MM>> Don't miss the 2002 Sprint PCS Application Developer's Conference MM>> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm MM>> _______________________________________________ MM>> JBoss-user mailing list MM>> [EMAIL PROTECTED] MM>> https://lists.sourceforge.net/lists/listinfo/jboss-user MM> -- MM> Best regards, MM> Alex Loubyansky -- 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