You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com> on 2007/09/07 15:46:51 UTC
Connecting to the Continuum Derby Database
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]
RE: Connecting to the Continuum Derby Database
Posted by "Krishnaiah, Shankar" <Sh...@Travelex.com>.
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.
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
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.
**********************************************************************
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
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.html
>
> 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]
>>
>>
>
>
>
>
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Sure.
-----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.html
>
> 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]
>>
>>
>
>
>
>
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
I am trying to create some reporting pages which show statistics of
number of builds per project, elapsed build times, average build times,
and other similar information. Thank you.
-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@gmail.com]
Sent: Friday, September 07, 2007 10:36 AM
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
On 9/7/07, Emmanuel Venisse <em...@venisse.net> wrote:
> the username is 'sa' with an empty password.
I knew I wrote this down somewhere. Here's a page talking about
Archiva and Derby Network Server. It should be easily adaptable to
Continuum.
http://docs.codehaus.org/display/MAVENUSER/Archiva+User+DB+on+Derby+Netw
ork+Server
> Just for my information, what do you try to do with your jsp?
Also curious. Continuum needs some "reporting" but I'm waiting for
actual requests to come in before I start guessing what people need.
--
Wendy
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]
Re: Connecting to the Continuum Derby Database
Posted by Wendy Smoak <ws...@gmail.com>.
On 9/7/07, Emmanuel Venisse <em...@venisse.net> wrote:
> the username is 'sa' with an empty password.
I knew I wrote this down somewhere. Here's a page talking about
Archiva and Derby Network Server. It should be easily adaptable to
Continuum. http://docs.codehaus.org/display/MAVENUSER/Archiva+User+DB+on+Derby+Network+Server
> Just for my information, what do you try to do with your jsp?
Also curious. Continuum needs some "reporting" but I'm waiting for
actual requests to come in before I start guessing what people need.
--
Wendy
Re: Connecting to the Continuum Derby Database
Posted by Emmanuel Venisse <em...@venisse.net>.
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.html
>
> 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]
>>
>>
>
>
>
>
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Thank you for your help. I was successfully able to have Continuum
connect to the Derby Network Server. After looking at the database
results, I have a question.
In the BUILDRESULT table, there is a column PROJECT_ID_OID. What table
should I query to map this field to the name of the artifact of the
project? In a sense, I want to find how to relate the PROJECT_ID_OID to
the actual name of the project.
Thanks.
-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@gmail.com]
Sent: Saturday, September 08, 2007 8:10 PM
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> I would like to ask which file in the Continuum directory I should
edit
> for Continuum to use the Derby Network Server instead of the embedded
> database.
It should be pretty similar to the instructions for Archiva. If it
doesn't match exactly, look around for a file with simlar contents:
http://docs.codehaus.org/display/MAVENUSER/Archiva+User+DB+on+Derby+Netw
ork+Server
--
Wendy
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]
Re: Connecting to the Continuum Derby Database
Posted by Wendy Smoak <ws...@gmail.com>.
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> I would like to ask which file in the Continuum directory I should edit
> for Continuum to use the Derby Network Server instead of the embedded
> database.
It should be pretty similar to the instructions for Archiva. If it
doesn't match exactly, look around for a file with simlar contents:
http://docs.codehaus.org/display/MAVENUSER/Archiva+User+DB+on+Derby+Network+Server
--
Wendy
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
I would like to ask which file in the Continuum directory I should edit
for Continuum to use the Derby Network Server instead of the embedded
database.
-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@gmail.com]
Sent: Saturday, September 08, 2007 4:42 PM
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Correct. However, I have started Derby Network Server only when
having
> Continuum be shut down. My concern is that I need to be able to
> generate reports on the builds while Continuum is running. Would this
> be a possibility?
Yes. You'll need to configure Continuum to use Derby Network Server
instead of the embedded database.
Derby Network Server can accept multiple connections-- in this case
one from Continuum and one from your reporting app.
It's not clear exactly what you've done so far, so if you still need
help, list the steps you've taken, the config files you've edited,
etc.
--
Wendy
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]
Re: Connecting to the Continuum Derby Database
Posted by Wendy Smoak <ws...@gmail.com>.
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Correct. However, I have started Derby Network Server only when having
> Continuum be shut down. My concern is that I need to be able to
> generate reports on the builds while Continuum is running. Would this
> be a possibility?
Yes. You'll need to configure Continuum to use Derby Network Server
instead of the embedded database.
Derby Network Server can accept multiple connections-- in this case
one from Continuum and one from your reporting app.
It's not clear exactly what you've done so far, so if you still need
help, list the steps you've taken, the config files you've edited,
etc.
--
Wendy
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Correct. However, I have started Derby Network Server only when having
Continuum be shut down. My concern is that I need to be able to
generate reports on the builds while Continuum is running. Would this
be a possibility?
-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@gmail.com]
Sent: Saturday, September 08, 2007 4:19 PM
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Is there a way where I could connect to the Continuum DB while
Continuum
> is running?
If you are using the embedded Derby that Continuum uses by default, then
no.
But your earlier messages indicate you're using Derby Network Server,
which can handle multiple connections.
--
Wendy
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]
Re: Connecting to the Continuum Derby Database
Posted by Wendy Smoak <ws...@gmail.com>.
On 9/8/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Is there a way where I could connect to the Continuum DB while Continuum
> is running?
If you are using the embedded Derby that Continuum uses by default, then no.
But your earlier messages indicate you're using Derby Network Server,
which can handle multiple connections.
--
Wendy
RE: Connecting to the Continuum Derby Database
Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Is there a way where I could connect to the Continuum DB while Continuum
is running?
-----Original Message-----
From: Krishnaiah, Shankar [mailto:Shankar.Krishnaiah@Travelex.com]
Sent: Saturday, September 08, 2007 6:27 AM
To: continuum-users@maven.apache.org
Subject: RE: Connecting to the Continuum Derby Database
Continuum uses Derby as an embedded database.
And it allows only one application to connect at a point in time.
And yes no remote connections
So stop continuum and connect to derby locally.
-
Shankar
-----Original Message-----
From: Nick Stolwijk [mailto:nick_stolwijk@planet.nl]
Sent: 07 September 2007 15:10
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
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.htm
l
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 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.
RE: Connecting to the Continuum Derby Database
Posted by "Krishnaiah, Shankar" <Sh...@Travelex.com>.
Continuum uses Derby as an embedded database.
And it allows only one application to connect at a point in time.
And yes no remote connections
So stop continuum and connect to derby locally.
-
Shankar
-----Original Message-----
From: Nick Stolwijk [mailto:nick_stolwijk@planet.nl]
Sent: 07 September 2007 15:10
To: continuum-users@maven.apache.org
Subject: Re: Connecting to the Continuum Derby Database
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.htm
l
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 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.
Re: Connecting to the Continuum Derby Database
Posted by Nick Stolwijk <ni...@planet.nl>.
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.html
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]
>
>
Re: Connecting to the Continuum Derby Database
Posted by Wendy Smoak <ws...@gmail.com>.
On 9/7/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> 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.
>From playing with this a bit in the past, I remember that by default
the Derby Network Server only allows connections from the same machine
it's running on. You'll need to configure it to allow external
connections.
Google turned up this:
http://db.apache.org/derby/docs/dev/adminguide/cadminnetservsecurity.html
The Derby mailing list can probably help with related questions;
subscription info is here: http://db.apache.org/derby/derby_mail.html
--
Wendy