continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krishnaiah, Shankar" <Shankar.Krishna...@Travelex.com>
Subject RE: Connecting to the Continuum Derby Database
Date Sat, 08 Sep 2007 10:30:22 GMT

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:amorgovsky@deloitte.com] 
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:Olivier.LAMY@accor.com]
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:amorgovsky@deloitte.com] 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:emmanuel@venisse.net]
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.


Mime
View raw message