Hope this helps: Continuum - SQuirreL SQL Client
continuum uses embedded derby database. This database only allows one connection at a time, so you need to stop the continuum server before you can connect with an SQL client. Ensure the continuum server is stopped if you want to attempt to run the SQL client below We have also installed SquirrelSQL under C:\Tools\SQuirreL SQL Client which should connect to the derby database. If you go to this directory and fire up squirrel via the squirrel-sql.bat file you should connect to the continuum database. Here are the connection details Aliase Name : Continuum URL : jdbc:derby:C:/Tools/continuum-1.0.3/apps/continuum/database User :sa Password : * just leave blank* Driver : Apache Derby Embedded ( see below how to configure driver details) Make sure "AutoLogon" and "Connect at Startup" checked. Configuring Driver details Driver Name : Apache Derby Embedded By default the following java classpath will be loaded Java Classpath: C:\Tools\SQuirreL SQL Client\squirrel-sql.jar C:\Tools\SQuirreL SQL Client\lib\commons-cli.jar C:\Tools\SQuirreL SQL Client\lib\forms.jar C:\Tools\SQuirreL SQL Client\lib\fw.jar C:\Tools\SQuirreL SQL Client\lib\log4j.jar C:\Tools\SQuirreL SQL Client\lib\nanoxml-2.1.jar C:\Tools\jdepend-2.9.1\lib\jdepend-2.9.1.jar C:\Tools\grinder-2.8.6\lib\grinder.jar You need to add these two extra classpath. First download derby database. Extra Classpath <derby_home>\lib\derby.jar <derby_home>\lib\derbyclient.jar ClassName: org.apache.derby.jdbc.EmbeddedDriver Regards, Shankar -----Original Message----- From: Morgovsky, Alexander (US - Glen Mills) [mailto:[EMAIL PROTECTED] Sent: 07 September 2007 15:58 To: continuum-users@maven.apache.org Subject: RE: Connecting to the Continuum Derby Database Thank you. I will look into this. -----Original Message----- From: LAMY Olivier [mailto:[EMAIL PROTECTED] Sent: Friday, September 07, 2007 10:46 AM To: continuum-users@maven.apache.org Subject: RE: Connecting to the Continuum Derby Database Maybe you can add an issue and explain what kind of reports you need ? -- Olivier -----Message d'origine----- De : Morgovsky, Alexander (US - Glen Mills) [mailto:[EMAIL PROTECTED] Envoyé : vendredi 7 septembre 2007 16:44 À : continuum-users@maven.apache.org Objet : RE: Connecting to the Continuum Derby Database Thank you. In my JSP I am trying to select all rows and search by field to create some reporting pages for our builds. -----Original Message----- From: Emmanuel Venisse [mailto:[EMAIL PROTECTED] Sent: Friday, September 07, 2007 10:28 AM To: continuum-users@maven.apache.org Subject: Re: Connecting to the Continuum Derby Database the username is 'sa' with an empty password. Just for my information, what do you try to do with your jsp? Emmanuel Nick Stolwijk a écrit : > By default, Derby only listens on localhost, so no remote connections. > Have a look at the derby documentation on how to change it. [1] > > Hth, > > Nick S. > > [1] > http://db.apache.org/derby/docs/dev/adminguide/cadminnetservsecurity.h > tml > > Morgovsky, Alexander (US - Glen Mills) wrote: >> I started the Derby Database server on the Continuum machine. It is >> listening on port 1527. In my JSP page deployed on an Application >> Server on another machine in the same network I have the code: >> >> Connection connection = >> DriverManager.getConnection("jdbc:derby://<Continuum >> IP>:1527/<Continuum File System Database"); >> >> However, upon accessing the JSP page I receive: >> java.sql.SQLException: java.net.ConnectException : Error connecting >> to server <ip> on port 1527 with message Connection refused: connect. >> >> What is the proper Java process for connecting to the Continuum Derby >> Database? Should I pass in a username/password? If so, should these >> be the Continuum admin username/password? >> >> I am using Continuum 1.1-alpha-2. >> >> Thank you. >> >> This message (including any attachments) contains confidential >> information intended for a specific individual and purpose, and is >> protected by law. If you are not the intended recipient, you should >> delete this message. >> >> Any disclosure, copying, or distribution of this message, or the >> taking of any action based on it, is strictly prohibited. [v.E.1] >> >> > > > > This e-mail, any attachments and the information contained therein ("this message") are confidential and intended solely for the use of the addressee(s). If you have received this message in error please send it back to the sender and delete it. Unauthorized publication, use, dissemination or disclosure of this message, either in whole or in part is strictly prohibited. ********************************************************************** Ce message électronique et tous les fichiers joints ainsi que les informations contenues dans ce message ( ci après "le message" ), sont confidentiels et destinés exclusivement à l'usage de la personne à laquelle ils sont adressés. Si vous avez reçu ce message par erreur, merci de le renvoyer à son émetteur et de le détruire. Toutes diffusion, publication, totale ou partielle ou divulgation sous quelque forme que se soit non expressément autorisées de ce message, sont interdites. ********************************************************************** This e-mail message (including any attachments) is private, intended solely for the recipient(s) or entity to whom it is addressed and may contain material which is confidential and privileged. No one other than the named recipient(s) may read, copy, rely on, redirect, save or alter any part of this message or attachment(s) in any way. The views, opinions and information expressed in this message represent those of the individual sender and do not reflect the views of the Travelex Group. Please take notice that the employees and/or agents of the Travelex Group are not authorized to make corporate commitments or representations via e-mail and no statement or representation made in this e-mail is binding upon the Travelex Group. While reasonable effort has been made to ensure this message (including any attachments) is free of viruses, opening and using this message (including any attachments) is at the risk of the recipient(s). The Travelex Group consists of Travelex Limited, Ruesch International, Inc. and any subsidiaries, affiliates or related entities. Travelex can be found on the World Wide Web at www.travelex.com. Ruesch can be found on the World Wide Web at www.ruesch.com.
