Thanks for these links, Steinar.
On 8/19/17 7:01 AM, Steinar Bang wrote:
I needed to temporarily run a derby network server to examine behaviour
of some of my SQL queries, that was different in derby (which I use for
tests, both unit tests and integration tests), and PostgreSQL.
What I did
I needed to temporarily run a derby network server to examine behaviour
of some of my SQL queries, that was different in derby (which I use for
tests, both unit tests and integration tests), and PostgreSQL.
What I did, was to create a maven project that uses the
derby-maven-plugin[1] to start
On 25/08/2016 15:58, Hohl, Gerrit wrote:
Yes, but an attacker can't access the database if that person is not
on the machine itself.
Exactly.
And in this case I also don't have to encrypt it, right? ;-)
As long as you don't allow remote shells or anything stupid like that.
And if an
On 25/08/2016 10:58, Hohl, Gerrit wrote:
But if that person sniffs the IP traffic on 127.0.0.1, he/she may be
able to read the boot password as well as user and password.
And of course IP traffic to 127.0.0.1 should *never* go outside the
local machine, according to the spec. So any sniffer
Betreff: Re: Use Apache Derby Network Server with encrypted database
Just a note on "If a person is already on the machine and would be able to
sniff the local IP traffic, that person may also have access on the files of
Derby.". To prevent this you encrypt the database and carefu
ely would
> recommend using SSL, of course.
>
>
>
> Thanks for your mails again. :-)
>
>
>
> Gruß
>
> Gerrit
>
>
>
> *Von:* toma.georg...@yahoo.com [mailto:toma.georg...@yahoo.com]
> *Gesendet:* Mittwoch, 24. August 2016 22:13
> *An:* derby-user@db.apac
]
Gesendet: Mittwoch, 24. August 2016 22:13
An: derby-user@db.apache.org
Betreff: Re: Use Apache Derby Network Server with encrypted database
Hi Gerrit,
Based on Apache Derby page, between the embedded mode and network mode there is
no difference,
https://db.apache.org/derby/docs/10.0
Hi Gerrit,
Based on Apache Derby page, between the embedded mode and network mode there is
no difference,
https://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt19.html#Differences+between+running+Derby+in+embedded+mode+and+using+the+Network+Server
Have you tried to create an
Dear Gerrit,
from my understanding the only difference with Derby network server and
embedded is relevant part of connection string. The rest where you put
parameters after semicolon and where you would specify encryption
properties is the same. Just start network server and then connect using
Hello everyone,
I've used Apache Derby for years now as an embedded RDBMS.
BTW: Thanks to all developer doing a great job developing this database
system. :-D
But now I want to use it as a separate service running on Ubuntu Linux.
This is no problem.
But I haven't found any
On 5/22/15 4:57 AM, kosurusekhar wrote:
Hi All,
We are using derby as database in our two different kind of applications.
In the desktop application the design is when ever we open my application
we have to start the Derby network server while closing the application we
have to close
Hi All,
We are using derby as database in our two different kind of applications.
In the desktop application the design is when ever we open my application
we have to start the Derby network server while closing the application we
have to close the derby database also. In another application
On 10/28/14 2:51 AM, shoyeb sheikh wrote:
Hi,
I am using netbeans 8 and derby DB, I want a java code to start apache
derby network server automatically at the start of my program codings,
Right now I have to manually start network from Java DB node after
right clicking the node
Please
Hi,
I am using netbeans 8 and derby DB, I want a java code to start apache derby
network server automatically at the start of my program codings,
Right now I have to manually start network from Java DB node after right
clicking the node
Please help,
Thanks,
Shoyeb
Hi
1 - Is it possible to run multiple Derby Network Server instances on a same
computer? (each one with a different port and a different system derby
directory) ?
2 - Can I do it in a single thread or should I use separate threads ?
3 - Is there a maximum number of databases on witch users can
Hi AirDT,
On 1/17/14 7:41 AM, AirDT wrote:
Hi
1 - Is it possible to run multiple Derby Network Server instances on a same
computer? (each one with a different port and a different system derby
directory) ?
Yes, you can run multiple servers on the same machine. The system
directory is a JVM
Hi Rick,
Thanks for reply.
How to brought down the derby engine. I am using
networkcontrolserver.shutdown() method to shut down the derby.
Help me to solve this problem.
Regards
Sekhar
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Derby-Network-Server
Hi Sekhar,
The Derby components can be puzzling to people familiar with other
databases. There is no such thing as a Derby Embedded Server. There is a
Derby engine and a Derby network server.
1) The engine manages the databases. The Derby engine can be embedded in
any Java application.
2
components can be puzzling to people familiar with other
databases. There is no such thing as a Derby Embedded Server. There is a
Derby engine and a Derby network server.
1) The engine manages the databases. The Derby engine can be embedded in
any Java application.
2) The network server manages
Hi,
I am using Derby network server in my application, i am starting derby by
using NetworkServerControl Class.
So far No issues, we made one java application it is taking care of starting
the derby server we made this application as service.
Now we have to implement restore feature for our
thoughts?
Thanks!
Date: Mon, 12 Aug 2013 17:13:58 -0600
From: geor...@mhsoftware.com
To: derby-user@db.apache.org
Subject: Re: derby network server can not be started automatically
Start derby after the network interface comes up?
On 8/12/13 4:35 PM, Rong Qu wrote
!
Date: Mon, 12 Aug 2013 17:13:58 -0600
From: geor...@mhsoftware.com
To: derby-user@db.apache.org
Subject: Re: derby network server can not be started automatically
Start derby after the network interface comes up?
On 8/12/13 4:35 PM, Rong Qu wrote:
On Linux, we
On Linux, we wrote a script to call NetworkServerControl so that derby network
server can be started automatically after reboot.
After reboot, we got following error message from derby
Can not listen on port on host **
java.net.BindException
Can not assign
Start derby after the network interface comes up?
On 8/12/13 4:35 PM, Rong Qu wrote:
On Linux, we wrote a script to call NetworkServerControl so that derby
network server can be started automatically after reboot.
After reboot, we got following error message from derby
Can not listen
Hi,
I'm seeing a strage behaviour which I seem to cannot get a hold of. I have the
problem that sometimes when I do a select on a table, that table is reported as
being empty (empty result set) although it definitely contains data.
What I'm doing is I'm starting a Derby network server within
.
What I'm doing is I'm starting a Derby network server within one program,
doing some selects, inserts, etc. in that program and it works perfectly.
I then try to access the same database from another Java program. And here it
depends.
If I use a debugger and set a breakpoint in the server
On 4/6/2013 6:27 AM, Ralph Rauscher wrote:
RE: Empty tables returned in the second connection to the Derby
network server (Derby 10.9.1.0)
Got it :)
Problem was at some point after the creation of the Derby server and
creation of a connection to it in the server, this code was called
(also
What's the recommended sequence of shutdown of Derby... if for example I have
Derby Network Server and Derby Engine running. What should be shutdown first?
Currently, I shutdown Network Server and then the Engine, the reason is so that
Derby does not get rebooted by someone else making a call
On 27.02.2013 00:29, Oskar Zinger wrote:
What's the recommended sequence of shutdown of Derby... if for example
I have Derby Network Server and Derby Engine running. What should be
shutdown first?
Currently, I shutdown Network Server and then the Engine, the reason
is so that Derby does
Hello Derby Community,
I have a question about Derby Network Server start and specifically about
-h option / parameter.
NetworkServerControl(InetAddress address, int portNumber)
This constructor creates an instance that listens on the specified
portNumber on the specified address
/how-to-support-both-ipv4-ipv6-on-java
Hope that helps...
On Tue, Aug 28, 2012 at 12:56 PM, Oskar Zinger ozin...@us.ibm.com wrote:
Hello Derby Community,
I have a question about Derby Network Server start and specifically about
-h option / parameter.
NetworkServerControl(InetAddress address
Hello everbody!
I would like to ask the community how to see a list of connected clients to
Derby Network Server? I tried to lookup anwser in this mainlinglist
archive and google but without result. Any system procedure or table?
I found only that there is SHOW CONNECTIONS command of ij tool
On 02/26/2012 08:43 AM, Libor Jelinek wrote:
Hello everbody!
I would like to ask the community how to see a list of connected clients to
Derby Network Server?
Have you tried runtimeinfo:
http://db.apache.org/derby/docs/10.8/adminguide/tadminappsruntimeinfo.html
thanks,
bryan
how to see a list of connected clients
to Derby Network Server?
Have you tried runtimeinfo:
http://db.apache.org/derby/**docs/10.8/adminguide/**
tadminappsruntimeinfo.htmlhttp://db.apache.org/derby/docs/10.8/adminguide/tadminappsruntimeinfo.html
thanks,
bryan
Unfortunatelly I need to analyze if my app is closing connection to Derby
Network Server properly, so to have list of active connection from Derby
point of view will be great.
Thanks however!
Libor
2012/2/26 Libor Jelinek ljeli...@virtage.com
It doesn't provide info who is connected
For this you may ask operating system (something like netstat ... | grep
1527),
although it gives only low level connections informations.
Le 26/02/2012 18:50, Libor Jelinek a écrit :
Unfortunatelly I need to analyze if my app is closing connection to
Derby Network Server properly, so to have
On 03/05/2011 16:35, Bryan Pendleton wrote:
In the webapp:
server = new NetworkServerControl();
server.start(null);
Perhaps your webapp is trying to run these lines multiple times?
Nope, it does it from the context initialisation. It definitely
only happens once (various status things are
On 02/05/2011 20:53, Kristian Waagan wrote:
Hi John,
Looks to me like you are trying to access, or more specifically boot,
the database with the embedded driver. This won't work since the network
server has already booted the database [1].
The only change required should be to add the host name
On 02/05/2011 20:53, Kristian Waagan wrote:
Hi John,
Looks to me like you are trying to access, or more specifically boot,
the database with the embedded driver. This won't work since the network
server has already booted the database [1].
The only change required should be to add the host name
In the webapp:
server = new NetworkServerControl();
server.start(null);
Perhaps your webapp is trying to run these lines multiple times?
It can be very tricky to ensure that your webapp starts the
Network Server once and only once. You may be starting it
a second time, and the second instance
I have a webapp which runs a networked Derby server. I want to be able
to access it from a separate app. The webapp starts the server from the
contextInitialized() method of a ServletContextListener:
server = new NetworkServerControl();
server.start(null);
which works fine. However, when I
On 02.05.11 15:13, John English wrote:
I have a webapp which runs a networked Derby server. I want to be able
to access it from a separate app. The webapp starts the server from the
contextInitialized() method of a ServletContextListener:
server = new NetworkServerControl();
to run Apache Derby - so when Derby
attempts to look in the 'current' directory for the database files, it can't
find them.
Jazz
- Original Message -
From: Fabricio Pedroso Jorge
To: Derby Discussion
Sent: Wednesday, May 05, 2010 4:32 AM
Subject: Re: Problems to use Derby Network
Hello... This is my first e-mail, and i hope i can help and be helped...
At this moment, i need help. My problem is tah a can't connect my
application to a database, using Derby Network Server. Let me explain
better:
I have 2 machines in my LAN, using the following IPs: (203.203.1.1) - Server
On 05/04/2010 07:54 PM, Fabricio Pedroso Jorge wrote:
Thats the problem: i simply can't connect mai client to the server..
On your server machine, when starting the Network Server, did you
pass the '-h' argument?
If you didn't, that's probably the problem.
thanks,
bryan
Hi... thanks for the fast reply.
@Thomas J. Taylor: I've completely disabled my Windows Firewall.
@Bryan Pendleton: I've used the following parameter on my server:
startNetworkServer -h 203.203.1.1 -p 1527. With it, the server started
correctly, but now, when i try to create a new connection via
On 03/28/10 11:21 PM, [SAS] Justin Swall wrote:
I have an LOB application that uses a Derby Embedded DB (Openbravo POS @
sourceforge.net). Their application does support using the network
server however so I spent some time over my weekend running some tests
with a copy of the app, installing
I have an LOB application that uses a Derby Embedded DB (Openbravo POS @
sourceforge.net). Their application does support using the network
server however so I spent some time over my weekend running some tests
with a copy of the app, installing the JDK Derby and seeing if I can
get it talking
more.
Justin Swall
Swall's Associated Services
-Original Message-
From: [SAS] Justin Swall [mailto:jsw...@swallservices.com]
Sent: Sunday, March 28, 2010 2:22 PM
To: derby-user@db.apache.org
Subject: Opening/Converting a Derby Embedded DB with the Derby Network
Server
I have an LOB
Message-
From: [SAS] Justin Swall [mailto:jsw...@swallservices.com]
Sent: Sunday, March 28, 2010 2:50 PM
To: Derby Discussion
Subject: RE: Opening/Converting a Derby Embedded DB with the Derby
Network Server
I figured out my first problem. The version of the LOB we are currently
using is one
...@swallservices.com]
Sent: Sunday, March 28, 2010 2:50 PM
To: Derby Discussion
Subject: RE: Opening/Converting a Derby Embedded DB with the Derby
Network Server
I figured out my first problem. The version of the LOB we are
currently
using is one subversion older than the new version I am
Hi all,
I'm using Derby 10.4.2.0. I have a problem regarding shutdown derby network
server in ij.
I have derby installed here, D:\devtools\derby\db-derby-10.4.2.0-bin
I have bin\derby.properties with following informatin to enable user
authentication:
derby.connection.requireAuthentication
booted the database again.
In my
example, show tables still works. Meanwhile, my first command window which
starts derby network server is listenning on port 1527. It seems derby is
still alive.
Yes, that observation is correct. In Derby, shutting down the database
engine and shutting down
Bryan,
thanks for your advise. With your guidance and some further reading how to
deploy apps under Tomcat I finally managed to get this running.
As a short summary:
1) Deploying the war file into tomcat using the tomcat manager application
placed the war file 'derby.war' into tomcat's webapps
Thomas Hill wrote:
I finally managed to get this running.
Great!
I took your notes and edited them into a page on the Derby wiki
http://wiki.apache.org/db-derby/NetworkServerServletInterface
so that hopefully it will be useful to others in the future.
One question:
3) Restarting Tomcat
10) when typing http://localhost:8180/derby/derbynet into the browser instead
I am getting HTTP 500 'Wrapper can not find servlet
org.apache.drda.NetServlet or a class it depends on'
Hi Thomas,
I'm not a big user of derby.war so I'm not sure what's wrong here, but
the first thing to know is
Thx it work's for me fine ;-)
On Sun, Mar 22, 2009 at 3:50 PM, Bryan Pendleton
bpendle...@amberpoint.comwrote:
Can I start the derby network server as a linux service?
Absolutely. Just write yourself a short init.d script and install it
using chkconfig or whatever you use.
I pasted a copy
Hello,
Can I start the derby network server as a linux service?
Regards
Christoph
Can I start the derby network server as a linux service?
Absolutely. Just write yourself a short init.d script and install it
using chkconfig or whatever you use.
I pasted a copy of something I use on a RedHat system below.
thanks,
bryan
#!/bin/sh
#
# Startup script for Derby, the database
Kathey Marsden wrote:
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance using
something other than Java (C, Python Perl etc), what's the recommended
mechanism? Google suggests the DB2 driver, but most of the articles
and howto's are several years old, and
Kim Haase wrote:
Kathey Marsden wrote:
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance using
something other than Java (C, Python Perl etc), what's the
recommended mechanism? Google suggests the DB2 driver, but most of
the articles and howto's are
Rick Hillegas wrote:
Kim Haase wrote:
Kathey Marsden wrote:
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance using
something other than Java (C, Python Perl etc), what's the
recommended mechanism? Google suggests the DB2 driver, but most of
the articles
Kim Haase wrote:
Rick Hillegas wrote:
Kim Haase wrote:
Kathey Marsden wrote:
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance
using something other than Java (C, Python Perl etc), what's the
recommended mechanism? Google suggests the DB2 driver, but most
Rick Hillegas wrote:
Kim Haase wrote:
Rick Hillegas wrote:
Kim Haase wrote:
Kathey Marsden wrote:
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance
using something other than Java (C, Python Perl etc), what's the
recommended mechanism? Google suggests
After looking into this some more, I think a problem with the
UsesOfDerby page is that it consists entirely of links to other sites
(off the wiki). There are a number of apparently obsolete IBM links,
including one to the IBM DB2 JDBC Universal Driver under JDBC
Drivers. I feel hesitant to
Alan Burlison wrote:
Related question: If you want to connect to a Derby instance using
something other than Java (C, Python Perl etc), what's the recommended
mechanism? Google suggests the DB2 driver, but most of the articles
and howto's are several years old, and date back to the
rigel wrote:
Hello, I would like to understand when and why is it useful to prefer
the DB2UDB jdbc driver instead DerbyClient to access a DERBY NETWORK
SERVER? Performance reasons or jdbc version implementation? Thanks for
attention, bye
Stanley Bradbury wrote:
With release 10.0 of Derby there was no open source client driver so the
DB2 driver was required to use Network Server. With Derby 10.1 the
Derby Client driver was introduced and the recommendation made everyone
use that client driver. This remains true today.
Alan Burlison wrote:
Stanley Bradbury wrote:
With release 10.0 of Derby there was no open source client driver so
the DB2 driver was required to use Network Server. With Derby 10.1
the Derby Client driver was introduced and the recommendation made
everyone use that client driver. This
Hello, I would like to understand when and why is it useful to prefer the
DB2UDB jdbc driver instead DerbyClient to access a DERBY NETWORK SERVER?
Performance reasons or jdbc version implementation?
Thanks for attention, bye
--
View this message in context:
http://www.nabble.com/When-and-why
started the Derby network server.
You could start out by doing this from the same machine, then another
machine in you home network and finally from a machine outside your home
network.
If it doesn't happen, or you are not able to connect, there is something
blocking the traffic. Not so
I am trying to run the derby network server on one machine and trying to
access the database on that machine from another machine.
just for testing purposes,on the client program i give the IP address of the
server machine(found out by going to findmyip.com).
When i try to connect using
musky wrote:
I am trying to run the derby network server on one machine and trying to
access the database on that machine from another machine.
just for testing purposes,on the client program i give the IP address of the
server machine(found out by going to findmyip.com).
Hello,
As I'm
-h 0.0.0.0
but still nothing seems to work.
i dont know what more i have to do.
please help.
Thanks,
Varun.M
Kristian Waagan-4 wrote:
musky wrote:
I am trying to run the derby network server on one machine and trying to
access the database on that machine from another machine.
just
musky wrote:
i have a name mapped to my IP address called j2m3world.servehttp.com using
a no-ip dynamic update client.
have added derby to the list of exceptions in windows firewall.
i have configured my modem to run in bridged mode,so there is no question of
forwarding ports.
i start derby
in context:
http://www.nabble.com/Connecting-to-Derby-Network-Server-through-the-Internet-tp17584140p17594454.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
When i run derby network server from within eclipse in fc7 i get the
following error:
java.lang.InternalError:couldn't find bean info.
I have no idea what this means.
Could someone please help me.
Thank you,
Good day.
--
View this message in context:
http://www.nabble.com/Running-Derby
i want to know how many hosts can access(both insertion and retrieval)the
derby database via the derby network server.
--
View this message in context:
http://www.nabble.com/Help-Urgent%3AApache-derby-network-server-tp14458006p14458006.html
Sent from the Apache Derby Users mailing list archive
network server.
You mean, at the same time? Thousands.
The limits aren't in Derby itself, but involve things like:
- whether your operating system can scale well
- how much hardware you can afford
- how carefully you write your application.
If your clients aren't simultaneously accessing
Hi Ture,
Ture Munter wrote:
For me this minor bug in my own code is not so bad as the uploaded program
is only used once (by myself) to insert all data in the database. But that
Derby can run out of memory if somebody forgets to close created statements is
potentially a more serious bug. Of
John Embretsen wrote:
Hi Ture,
[ snip ]
I didn't think it was this easy to fill up the heap (by not explicitly
closing Statement objects) anymore (see e.g. DERBY-210), but there are
obviously some vulnerabilities left. So thank you for sharing your code
and for reporting this!
Hi John,
Kristian Waagan wrote:
John Embretsen wrote:
Hi Ture,
[ snip ]
I didn't think it was this easy to fill up the heap (by not explicitly
closing Statement objects) anymore (see e.g. DERBY-210), but there are
obviously some vulnerabilities left. So thank you for sharing your
code and for
John Embretsen wrote:
Kristian Waagan wrote:
John Embretsen wrote:
Hi Ture,
[ snip ]
I didn't think it was this easy to fill up the heap (by not
explicitly closing Statement objects) anymore (see e.g. DERBY-210),
but there are obviously some vulnerabilities left. So thank you for
sharing
consist of some strings and some floats (6 fields in total) and the
operation requires two inserts and one select. During insert I run Derby
as a Derby network server, the problem is that no matter what I do I get
OutOfMemory exceptions (Derby ran out of heap space) all the time.
Setting the max
records, 30MB). Each row
consist of some strings and some floats (6 fields in total) and the
operation requires two inserts and one select. During insert I run Derby
as a Derby network server, the problem is that no matter what I do I get
OutOfMemory exceptions (Derby ran out of heap space) all
database (total size before insert around 1 records, 30MB). Each row
consist of some strings and some floats (6 fields in total) and the
operation requires two inserts and one select. During insert I run Derby
as a Derby network server, the problem is that no matter what I do I get
The problem was solved by running Derby embedded in the program that
inserted data into the database and only commit every 50th row.
When you were running in the Network Server configuration, were you
also committing your transaction after every 50th row?
thanks,
bryan
database. As the data are published scientific data I can share my source code
and the data. Everything is available on
www.fysik.dtu.dk/~munter/derby/
Thanks for sharing your sample program. It looks like you are creating
statements, but never closing them.
Each call to
Bryan Pendleton wrote:
database. As the data are published scientific data I can share my
source code
and the data. Everything is available on
www.fysik.dtu.dk/~munter/derby/
Thanks for sharing your sample program. It looks like you are creating
statements, but never closing them.
Each call
Bryan Pendleton [EMAIL PROTECTED] writes:
database. As the data are published scientific data I can share my
source code
and the data. Everything is available on
www.fysik.dtu.dk/~munter/derby/
Thanks for sharing your sample program. It looks like you are creating
statements,
Kristian Waagan [EMAIL PROTECTED] writes:
As Bryan says, you should close your statements. Even better would be to
use a PreparedStatement for all you queries (including those without any
variables).
Unless it is an application requirement, you could also do with just one
table and
Hi Susan,
Susan Cline wrote:
org.apache.derby.ui.launch.SysInfoDerbyLaunchConfigurationDelegate
org.apache.derby.ui.launch.IJDerbyLaunchConfigurationDelegate
org.apache.derby.ui.launch.StopDerbyServerLaunchConfigurationDelegate
Hi Kai,
If you are 'unjarring' the ui.jar file then you must be using the IBM Integration Plug-in for Derby.
Presently, the 1.0 Derby UI plug-in is only available in source format.
Therefore if you really need to use Eclipse 3.1M7 and want to use the Derby plug-ins you'll need to do the
Hi Susan,
i've also this problem with the eclipse version 3.1M7.
I don't understand the solution from Tony.
Kai
Susan Cline wrote:
Thanks for the info Tony.
Susan
*/Tony Kennedy
[EMAIL PROTECTED]/* wrote:
The Replacement class is:
public class
server, I get anerror popup with the following message :"Error starting Derby Network Server : Pluging com.ibm.clouscape.ui was unable to load class com.ibm.clouscape.ui.launch.StartDerbyServerLaunchConfigurationDelegate".When i look at the .log file in the workspace's metadata
the
derby
network server. Hélas, when trying to start the network server,
I get an
error popup with the following message :
Error starting Derby Network Server :
Pluging com.ibm.clouscape.ui was unable to load class
Thanks for the info Tony.
SusanTony Kennedy [EMAIL PROTECTED] wrote:
The Replacement class is:public class IJDerbyLaunchConfigurationDelegate extends// JavaLocalApplicationLaunchConfigurationDelegateorg.eclipse.jdt.launching.JavaLaunchDelegate{}Tony Kennedy
97 matches
Mail list logo