Dear Derby users,
The next feature release of Derby will close some security holes:
1) When authentication is turned on, only the owner of a database will
be allowed to shut it down, encrypt it, and hard-upgrade it.
2) When you boot the network server as the VM's entry point, the server
will
Stephen Caine wrote:
Derby User List:
Does anyone have an idea as to when v10.3 might be released? I know
everyone is working hard on this release. We include Derby as part of
our application package and the specific feature, removing a column,
is very important to our users.
Stephen Cain
Hi Shelley,
There is an enhancement request logged for this feature:
http://issues.apache.org/jira/browse/DERBY-672. No-one has picked up
this enhancement request yet--you are welcome to! Most of the code
needed for this feature is actually in the Derby codeline. I think the
blocking issue is
It seems to me that the compiler should not think it has enough
information at prepareStatement() time to assign the ? a type of
VARCHAR. That looks like a bug to me.
As a workaround, the following statement gives the compiler enough
information to correctly type the ? parameter. This allows y
Hey folks,
Sun Microsystems is hosting a Derby party at Java One. Here are the
specifics. Hope to see you there!
You are cordially invited to:
An Apache Derby unBoF at JavaONE 2007!
hosted by Sun
Come learn what's cool and what's new in Apache Derby -- the database
for Java applications
Hi Sameer,
You might try using a temporary table to hold the values in the IN list.
For more details, see the section in the Derby Reference Manual titled
"DECLARE GLOBAL TEMPORARY TABLE statement". Here's an example of this
technique.
Regards,
-Rick
autocommit off;
ij> drop table t;
0 rows
Hi Dustin,
Table and column names are called SQL identifiers and, according to the
SQL standard, they are case-insensitive. Like many databases, Derby
stores table and column names in uppercase.
You can get the behavior you want by double-quoting your table and
column names. If you double qu
Hi Kevin,
I think that Kristian and Bernt have given you the workarounds for this
issue. It is true that Java ADTs were supported in earlier versions of
Cloudscape. However, those ADTs were declared in a non-standard way. ADT
support was disabled before the code was open-sourced as Derby--Derb
Don't forget the Derby party at Java One tonight!
Cheers,
-Rick
Rick Hillegas wrote:
Hey folks,
Sun Microsystems is hosting a Derby party at Java One. Here are the
specifics. Hope to see you there!
You are cordially invited to:
An Apache Derby unBoF at JavaONE 2007!
hosted by Sun
The upcoming release of Derby 10.3 will make networked configurations
safer by installing a Java security manager if the user forgets to
install one. This will happen only if the user boots the network server
without installing a security manager. As a result, it will be harder
for hackers to c
The Apache Derby project is pleased to announce a new feature release
of Derby, 10.3.1.4.
Apache Derby is a subproject of the Apache DB project.
Derby is a pure Java relational database engine which conforms to the
ANSI SQL and JDBC standards. Derby aims to be easy for developers
and end-users to
Williamson, Nick wrote:
Hi all,
In Oracle, it's possible to have an index column that is the result of a
function, for example:
CREATE INDEX index_name ON table_name
(
UPPER("column_name")
);
It doesn't seem possible to do this in Derby. What would be the best way
to mimic this behavio
Getting Started Guide. The
Working with Derby Guide was removed in this release.
Laura
On 8/10/07, Rick Hillegas <[EMAIL PROTECTED]> wrote:
The Apache Derby project is pleased to announce a new feature release
of Derby, 10.3.1.4.
Apache Derby is a subproject of the Apache DB project.
De
Hi Mike,
I think the problem is the datatype of the function's return value. The
VARCHAR datatype needs a length. This should work:
CREATE FUNCTION FUNC_NO_ARGS() RETURNS VARCHAR( 100 )
...
Hope this helps,
-Rick
Mike Norman wrote:
latest Derby:
Apache Derby
10.3.1.4 - (561794)
Apa
Thanks for finding this bug, Tim. I have verified that this occurs in
the development mainline as well. I have created DERBY-3061 to track
this issue.
Regards,
-Rick
Tim Dudgeon wrote:
This query that used to work on the 10.2 version now return no results
on 10.3.1.4:
SELECT MYTABLE.MY_ID
Hi Brandon,
This syntax works in the latest Derby release (10.3.1.4). Are you using
an older version of Derby?
Thanks,
-Rick
Brandon Dohman wrote:
I was wondering what the sql syntax is to drop a column from a derby
database.
i tried this and it gave me the error below: ALTER TABLE contact
Hi Mike,
Try passing in null as the catalog and schema arguments. The javadoc for
DatabaseMetaData.getProcedures() is a little vague about this.
Hope this helps,
-Rick
Mike Norman wrote:
latest Derby:
Apache Derby
10.3.1.4 - (561794)
Apache Derby Network Client JDBC Driver
10.1.2.1
Hi Brandon,
This is described in the Derby Developer's Guide,
http://db.apache.org/derby/docs/10.3/devguide/ The left pane is a table
of contents--near the top you will see a link for the section on Upgrade.
Hope this helps,
-Rick
Brandon Dohman wrote:
what is the process for upgrading from
Hi Kevin,
Derby does support databases stored in jar files. This is described in
the Derby Developer's Guide
(http://db.apache.org/derby/docs/10.3/devguide/) in a subsection called
"Accessing databases from a jar or zip file". Just follow these headings
to get to that subsection:
JDBC appli
Hi Geoff,
Several DatabaseMetaData methods return ResultSets which have a column
named REMARKS. For instance, getColumns(), getTables(), and
getProcedures() return ResultSets which contain a REMARKS column. The
contents of these columns are determined by queries stored in the
following Derby
Hi Geoff,
You're welcome to create a JIRA issue, describing this new feature.
Instructions on how to create a JIRA can be found in the "Provide
Feedback" section at the top of the following webpage:
http://db.apache.org/derby/derby_comm.html At a minimum, other people
may be able to help you
Hi Paulo,
It doesn't appear to me that you have set ANT_HOME as described in
trunk/BUILDING.txt. That may be part of the problem.
Hope this helps,
-Rick
Paulo Jesus wrote:
I'm building from console.
I use ant ver. 1.6.5. It works fine compiling derby 10.2.2.0.
I keep ant.properties and modif
Tim Dudgeon wrote:
How do you find out which UNIQUE constraints exist for a table, and
which columns they use?
DatabaseMetaData.getIndexInfo( ... ) can give me the information about
the indexes, but it seems that in Derby a UNIQUE index is not the same
thing as a UNIQUE constraint.
Thanks
Ti
;m pretty sure
that's a left-over from the environment where Rick (Hillegas) built
the documentation for the 10.3 release...
Hmm, I thought Myrna Van Lunteren was the release manager for the
10.3 release... strange. I'll let them comment when they see this.
As no css files ar
Alan Burlison wrote:
I have a Java database-side function that does a simple lookup of a
string on a reference table and returns the corresponding integer. If
the string can't be found I want to return NULL, but if I return a
Java null I get a database exception rather than the desired behavio
Alan Burlison wrote:
Rick Hillegas wrote:
It is hard to say where the NullPointerException originates. Could
you post a reproducible test case and the full stack trace from
derby.log?
Umm, it may be my bad, I have the following:
public static int iGoBang() {
int pop = 0 == 0
Hi Rene,
The following ij command will give you the current version of the data
stored on disk. I don't think that this is a documented part of Derby's
api, so this could change in a future release:
values syscs_util.syscs_get_database_property( 'DataDictionaryVersion' );
Hope this helps,
Cloudscape (the codeline which Derby is based on) used to include
user-defined aggregates, which you could declare with a CREATE AGGREGATE
statement. DERBY-672 tracks the effort to put user-defined aggregates
into Derby. It sounds as though you might want to volunteer for this
effort. That woul
Hi Jon,
The situation with case-insensitive searching did not change in the
latest 10.3 release and no one has volunteered to address this issue in
the next feature release, 10.4. If you want to avoid the full table
scan, you can store the text in two columns: mixed case in one column,
and
Daniel Noll wrote:
Hi all.
Is there some way for the Derby server to allow custom code to determine
whether a directory can be opened for a database? I read something about a
policy file but that doesn't really suit our use case as the list of
directories can be changed by the admin at runti
Jørgen Løland wrote:
A client/server Derby will soon be used in a university course to
teach students SQL etc.
Previous experience has revealed that students who are not familiar
with Java programming and JDBC/DBs tend to open a new connection for
every Statement. There will be peaks with a f
Amir Michail wrote:
Hi,
I would like to copy rows from one table to another while copying
only the first row from sets of similar rows.
In particular, for rows in which two particular fields are the same, I would
like to copy only the first row in that set. The rows have more than these
two fi
Dag H. Wanvik wrote:
Daniel John Debrunner <[EMAIL PROTECTED]> writes:
Rick Hillegas wrote:
One way to solve this problem would be to put a filtering function
in the WHERE clause of the driving SELECT statement. Something like
this:
INSERT INTO targetTable
SELECT * FROM sourc
The next feature release of Derby, 10.4, will provide a new feature,
table functions. This feature will let you use SQL to slice, dice, and
zipper together data sets which live outside Derby. I talked about this
feature at ApacheCon last week. You can find my presentation at:
http://people.apac
digi_pixel wrote:
When running my Java program a SqlException is thrown when trying to return
data from the ResultSet. What is really strange is that the first row is
reported as being present using the ResultSet's first method. I am using the
"sample" DB that comes with NB 5.5.1. Upon a closer i
position.
Rick Hillegas-2 wrote:
Without seeing your code, I can only speculate about what the problem
is. However, your problem may be that you are trying to retrieve the
first column using the index 0. Annoyingly, the JDBC methods use
1-based, not 0-based indexing. So the first thing to
Stavros Macrakis wrote:
Hi, I have an application whose output is about 500,000 pairs (string,
integer) -- this is the result of some fairly fancy text processing.
I'd like to put this data into a (new) Derby table. Using individual
Inserts for each row takes over an hour, which seems much too lo
Hi Ivan,
There are several distributions of Derby, including Sun's Java DB as
well as Cloudscape (available in IBM products), and of course the
community releases. Sun sells support for the Java DB distributions.
Sun, however, does not sell support for Cloudscape or for the community
releases
Priya B wrote:
Does Derby allow users to create VTI calls with
parameter markers for arguments; so that we can
prepare the vti once and execute it with different
values?
Something like:
SELECT vti.* FROM new MyVTI(?) vti;
and then set the parameter value at run time?
__
Hi Jay,
As Thomas points out, the builtin COS and EXP functions may be useful to
you. If these functions don't give you what you need, you can always
write your own function in Java and register it with Derby using the
CREATE FUNCTION command. This command is described in the "SQL language
re
tom_ wrote:
Isn't there a possibility to select the database users from the systables? In
the documentation I've not found it.
Hi Tom,
I may be missing the point of your question, but here's some more
information: Derby doesn't have a system table which stores the names of
users who are al
wrote:
Hi Rick,
in my database it shows the name of the schemas, not of the users that I've
created afterwards, but I've found a way how to proceed without querying the
usernames.
Rick Hillegas-2 wrote:
tom_ wrote:
Isn't there a possibility to select the database users fro
Hi Gavin,
You may find the answers you need here: http://www.apache.org/licenses/
In particular, that page points at a useful FAQ:
http://www.apache.org/foundation/licence-FAQ.html The FAQ addresses the
issue of using the Apache license for your own code. The FAQ also has a
very useful summar
Hi Tom,
The database is successfully booted in only one VM and can be shut down
only in that VM. The second application, running in a different VM, can
not get a connection to the database and can not shut down the database,
either. The second application should abandon its trial and not attem
und out that another
application by whatever reasons tries to make a shutdown in the described
situation. I wonder if this trial could result in a database crash -
eventually afterwards when the other application does the shutdown. It would
explain why I am observing the recovery problem so often.
R
Hi Jim,
Derby, complying with the ANSI SQL standard, does not allow you to cast
non-BLOB to BLOB. The ANSI rules are documented in part 2 of the 2003
SQL standard, section 6.12. The Derby behavior is documented in the
Derby Reference Guide section titled "Data type assignments and
comparison,
Hi Andreas,
Some comments inline...
Andreas Haufler wrote:
Hi there,
we're trying to use Derby's VTI interface in order to integrate Derby with
Lucene. I already saw some efforts to integrate Lucene via "normal" function
calls, but I think, using the VTI is a better approach. However, I only f
Hi David,
Do you know what version of Derby is being used and what the error is?
Does the problem occur if they user Derby 10.1? When running 10.2 or
10.3 on Java 6, Derby uses different JDBC implementations. There could
be some problem there.
Regards,
-Rick
David Van Couvering wrote:
Hi,
Hi Sai,
This problem comes up frequently. One solution to it is an unimplemented
feature called computed columns (see DERBY-481). Hopefully, we can raise
the visibility of that issue.
In the meantime, I think that changing your INSERT and UPDATE code is a
good approach. You can give yourself
Hi Raymond,
Derby does not provide a command to rename a schema. Tables, columns,
and indexes can be renamed but not schemas.
Regards,
-Rick
Raymond Kroeker wrote:
I would like to know if it is possible to rename a schema; if anyone
has tried it; and what their results were.
I've looked fo
[EMAIL PROTECTED] wrote:
Briggs <[EMAIL PROTECTED]> writes:
Hey, thanks for your reply. I am still way confused on this. And
trying to find examples of the SQL/JRT spec is almost impossible. I
am trying to make some sense of the examples of creating store
procedures off the http://wiki.ap
Hi Hong,
The max and min values of the Derby double datatype are not the max and
min values of the Java double type. The Derby behavior is documented in
the Derby Reference Guide in the section titled "DOUBLE PRECISION data
type". Here's what that section says:
"DOUBLE value ranges:
* Sm
James A. Shepherd wrote:
Hi,
I added a comment to DERBY-3216 that means I believe it still affects
released version 10.3.2.1. Currently DERBY-3216 is closed. Can someone
reopen it please, or should I file a new jira?
https://issues.apache.org/jira/browse/DERBY-3216?focusedCommentId=1256
Hi Brad,
Writing a valid security policy file can be a bit tricky. I am not sure
that you have identified the codebase of your jar file with a legal URL.
I would expect to see some double slashes in the URL. The following kind
of URL works for me:
grant codeBase "file:///opt/DerbyTrunk/jars/
Chris wrote:
I'm wanting to drop a row/record/index in my Derby Embedded
installation (pre-installed in ColdFusion 8 Developer's Edition), but
the index-names aren't as simple as I had originally assumed (0, 1,
2,...). I visited
http://db.apache.org/derby/docs/10.3/ref/rrefsqlj59893.html to
I suspect that a lot of Derby users and developers will be in San
Francisco for Java One this year (May 6-9,
http://java.sun.com/javaone/sf/). This would be a great opportunity to
get together, connect faces with names, and generally talk about what
we're all doing and what we want out of Derb
Hi Mike,
I agree. We should meet somewhere that doesn't require a Java One pass.
Regards,
-Rick
Mike Matrigali wrote:
I would be interested in attending but may not have a javaone pass, so
would be nice if the location was somewhere nearby but not need a
javaone pass to attend.
Hi Varun,
The getArray() and setArray() methods are part of the JDBC api and they
operate on the SQL Array datatype. Derby does not support this datatype
so these methods throw "not implemented" exceptions as Narayanan said.
The supported datatypes are described in the Derby Reference manual i
Forums @ Existanze wrote:
Hello all,
As the subject reads, my development team and I are trying to migrate
to apache derby, because
we will start deploying our application with the database embedded,
instead of having the hassle
of installing a database on each client. Following are some of my
Forums @ Existanze wrote:
Rick Hillegas wrote:
Forums @ Existanze wrote:
Hello all,
As the subject reads, my development team and I are trying to
migrate to apache derby, because
we will start deploying our application with the database embedded,
instead of having the hassle
of installing a
Hi Art,
Can you tell us what section of the Reference Guide makes this claim?
The old Cloudscape engine offered syntax for creating user-defined
aggregates but that machinery does not work in Derby. There is a JIRA
for this feature: DERBY-672. You may be able to do what you need by
using Derb
Hi Chris,
I may be misunderstanding your question so please bear with me. The
upcoming 10.4 release of Derby will provide a feature called Table
Functions. This will let you make your external data look like a table
to Derby so that you can issue SELECTs against it. The feature is
described b
Stanley Bradbury wrote:
David Parker wrote:
I would like to be able to create a java stored procedure that
returns a ResultSet. Ideally, I would be able to call this as a
function from within an SQL statement.
The application requires that given a parent-child relationship where
a given row
Hi Bayless,
DERBY-499 is an issue which tracks the work needed to add a boolean
datatype to Derby. A functional spec has been written for this issue,
but no-one has volunteered to do the work. The boolean datatype will not
appear in the upcoming 10.4 release which is now being tested.
Regard
rse.
Where can I find the DERBY-499 issue? I'm new to this list so just
starting to learn the ropes.
Bayless
- Original Message - From: "Rick Hillegas"
<[EMAIL PROTECTED]>
To: "Derby Discussion"
Sent: Monday, April 07, 2008 7:32 AM
Subject: Re: Boolean data
Brandon Dohman wrote:
I can’t manage to find the information that I used previously on how
to load data from a comma delimited file into derby. Could someone
either provide the code, or the link to the information on it.
Thanks
No virus found in this outgoing message.
Checked by AVG.
day
sounds good to you.
Thanks,
-Rick
Rick Hillegas wrote:
I suspect that a lot of Derby users and developers will be in San
Francisco for Java One this year (May 6-9,
http://java.sun.com/javaone/sf/). This would be a great opportunity to
get together, connect faces with names, and gener
Hi Brandon,
The Derby interactive sql tool, ij, supports a describe command, which
you can use to display the structure of tables and views. You can find
an explanation of this command in the "ij commands and errors reference"
section of the Derby Tools and Utilities Guide:
http://db.apache.o
Mike Matrigali wrote:
Knut Anders Hatlen wrote:
Rick Hillegas <[EMAIL PROTECTED]> writes:
A number of Derby people have expressed interest in getting together
the week of Java One. I'm thinking that people may be busy attending
sessions during Java One itself, so it might be bet
Hi Geoff,
You have asked a lot of interesting questions. I will try to give you
some feedback on some of your questions. Hopefully others can provide
more information. Please see my responses inline...
Six Fried Rice wrote:
I'm a first-time poster so I hope I'm following protocol here. I
se
Six Fried Rice wrote:
Rick:
Thank you very much for your responses. I have a few followup
questions below:
On Apr 15, 2008, at 1:03 PM, Rick Hillegas wrote:
Please take a look at the section titled "Accessing a read-only
database in a zip/jar file" in the Derby Developer'
Hi Brandon,
I can see that Kristian is already giving you excellent advice on this
issue. You may also want to take a look at the large section titled
"Controlling Derby application behavior" in the Derby Developer's Guide:
http://db.apache.org/derby/docs/10.3/devguide/ In particular, you may
Hi David,
No-one has volunteered to produce another release from the 10.3 branch.
At this time, engineers seem to be backporting fixes from the trunk to
the 10.4 branch but I don't see a lot of backports to 10.3.
You can, of course, check out the 10.3 branch yourself and build your
own distr
Hi Brad,
As Thomas points out, Derby hews closely to the SQL standard, which does
not allow an ORDER BY clause in subqueries. The gnarly details of the
standard grammar can be found here:
http://savage.net.au/SQL/sql-2003-2.bnf.html
Regards,
-Rick
Bradley Munz wrote:
Hi there,
I have a bi
Hi Nic,
The "." is used to separate identifiers in valid SQL names. For a schema
object like a procedure, the name can have only one dot in it. The piece
before the dot identifies a unique schema in the database and the piece
after the dot identifies a unique procedure name inside that schema
Sripada naresh wrote:
Hi,
This is Naresh. I want to know the Derby database default username and
password. Please let me know it.
Thanks & regards,
-Naresh S.
Hi Naresh,
By default, Derby runs without user authentication. This means that
there is no default username and password. Derby au
Hi Geoff,
The new 10.4 release provides support for the sql standard ROW_NUMBER
function, which you can use for paging through query results. You can
find this function documented in the ROW_NUMBER subsection of the
"Built-in functions" section of the 10.4 Reference Manual.
Hope this helps,
Mike Matrigali wrote:
Knut Anders Hatlen wrote:
Rick Hillegas <[EMAIL PROTECTED]> writes:
A number of Derby people have expressed interest in getting together
the week of Java One. I'm thinking that people may be busy attending
sessions during Java One itself, so it might be bet
Hi Stephen,
You may be able to write a user function to help. There's an example of
a median-calculating user function in the "scores" demo. For an example
of how to write and use this function, search for "getMedianTestScore"
in the demo subtree of your Derby distribution (it should be availa
Hi Brandon,
From the stack trace, it appears that the engine doesn't know where
your database lives. From the server startup command and connection URL,
it appears that Derby is looking for the database in the current
directory of the server process. You can modify that startup command to
poi
Hi Shaoyong,
For tips on how to avoid deadlocks, please see the "Deadlocks" section
of the Derby Developer's Guide:
http://db.apache.org/derby/docs/10.3/devguide/
Hope this helps,
-Rick
Shaoyong Wang wrote:
We are using Derby 10.3.1.4. Occasionally, we saw the following error.
Can anybody
Hi Brandon,
I suspect that you need to put single quotes around the string value
which you want to match in PDFNAME. Something like the following:
select pdflocation from files where pdfname = 'foo'
Without the single quotes, Derby thinks that foo is the name of a column
and Derby objects t
Hi Dev,
Do you know what version of Derby you are using with Netbeans? Column
dropping and renaming were added to Derby in release 10.3.1.4.
Hope this helps,
-Rick
Devang kamdar wrote:
Hi,
I am trying to get started with Derby and Netbeans
I am not able to use the DROP command.
Getting fol
Hi Mike,
One solution would be to do this:
1) Create a dummy table with the same shape as your target table
2) Import the data into the dummy table
3) Copy from the dummy table into the target table but specify that you
only want rows which won't generate collisions.
Something like this:
--
Hi Nicholas,
I don't have anything smarter to recommend than the tried-and-true
design pattern of a portability library. Here you would have an
interface which abstracts out the differences between the databases
which you have to support. In your case you would have two
implementations of thi
s creating and populating tables much faster.
OR
as an alternative, are there any GUIs available to work with bare
JAVA-DB database like toad?
Please let me know your suggestions.
Thanks
Dev.
On Thu, May 1, 2008 at 6:38 PM, Rick Hillegas
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
Six Fried Rice wrote:
On Apr 28, 2008, at 8:02 AM, Rick Hillegas wrote:
The new 10.4 release provides support for the sql standard ROW_NUMBER
function, which you can use for paging through query results. You can
find this function documented in the ROW_NUMBER subsection of the
"Bui
Hi Łukasz,
Can you give us some more information on what you can do in ij but not
in your own Java client? Samples of the successful and unsuccessful code
might help us better understand what's not working for you.
Thanks,
-Rick
Łukasz Kaleta wrote:
Hi,
I have problem with getting data fr
Hi Kalyan,
Derby does not support spatial datatypes. The question comes up often. I
am certain that the community would be very supportive if someone wanted
to add spatial datatypes to Derby.
Regards,
-Rick
[EMAIL PROTECTED] wrote:
Hello,
I was wondering if Derby supports Spatial Indexing
Bogdan Calmac wrote:
To concatenate two numbers in a string you have to do something like this (in
derby 10.3):
trim(char(min_value)) || trim(char(max_value))
This is pretty ugly, considering that it could have been as simple as:
min_value || max_value
Also, the documentation for the concaten
Bogdan Calmac wrote:
To concatenate two numbers in a string you have to do something like this (in
derby 10.3):
trim(char(min_value)) || trim(char(max_value))
This is pretty ugly, considering that it could have been as simple as:
min_value || max_value
Also, the documentation for the concaten
Hi Maris,
When you declare a constraint, Derby creates a backing index for that
constraint. If you do not explicitly name the constraint, then Derby
will make up a name. The constraint name which Derby makes up is the
same name that Derby gives to the backing index. If you don't name your
con
Hi Tian,
It sounds as though the old procedure class is stuck in Derby's
classloaders. This topic comes up occasionally and the user guides
should probably explain this better.
1) If your user-written procedures and functions live inside jar files
which you have loaded into your Derby datab
Hi Sebastian,
The following query will show you the names of the jar files loaded into
your database:
select s.schemaname, f.filename
from sys.sysschemas s, sys.sysfiles f
where s.schemaid=f.schemaid
So, for instance, the following script runs like this for me:
ij> call sqlj.install_jar( '/U
gards && tnx in advance
Sebastian
On Mon, May 12, 2008 at 6:23 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote:
Hi Sebastian,
The following query will show you the names of the jar files loaded into
your database:
select s.schemaname, f.filename
from sys.sysschemas s, sys.sysfile
tabase will be stored in the jar directory of the database (e.g.
My_databse/jar). If i'm wrong, please correct me.
Regards
Sebastian Pfaff
On Tue, May 13, 2008 at 12:54 AM, Rick Hillegas
<[EMAIL PROTECTED]> wrote:
Hi Sebastian,
I'm not sure I'm understanding your que
fter every reboot every processes will be closed. The effect is
always the same :(
Regards && tnx for answer :-]
Sebastian
On Tue, May 13, 2008 at 3:30 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote:
Thanks for the detailed explanation, Sebastian. Now I think I am tracking
you.
Th
Hi Ian,
You can use Derby as an XA data source. There is a small section on this
topic ("XA and the Network Server") in the Server and Administration
Guide. There is also some related material in the section titled "J2EE
Compliance: Java Transaction API and javax.sql Interfaces" in the
Refere
Hi Will,
Thanks for bringing this up. I have logged DERBY-3676 to track this
request. At first blush this looks like a straightforward project for a
newcomer. If you want to implement this yourself, I would be happy to
coach you through the code.
Regards,
-Rick
wbecker wrote:
Is there a wa
Hi Sai,
Single-node master/slave replication with manual failover was added to
Derby in version 10.4. You should not try to manually copy a Derby
database which is in use.
Hope this helps,
-Rick
Sai Pullabhotla wrote:
Hello,
We have a need to replicate Derby Database from the production sy
101 - 200 of 1044 matches
Mail list logo