Re: How to determine version of a derby database

Great! Thanks for the follow-up and the example code, very helpful. On Thu, Feb 18, 2021 at 1:01 PM Lisa Ruby wrote: > > Thank you again Bryan. I just got it working. From what I read about the > versioning, it would seem that being able to obtain only the major and minor > versions returned

Re: How to determine version of a derby database

Thank you again Bryan. I just got it working. From what I read about the versioning, it would seem that being able to obtain only the major and minor versions returned from SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('DataDictionaryVersion') should be enough to know if a database upgrade is needed.

Re: How to determine version of a derby database

I had not seen this Bryan. Thank you for pointing it out. Seems like it would provide the information I'm looking for. I'll look into it. Lisa On 2/18/2021 6:48 AM, Bryan Pendleton wrote: > Have you tried this? > https://db.apache.org/derby/docs/10.15/ref/rrefproperdatadictversion.html > >

Re: How to determine version of a derby database

Have you tried this? https://db.apache.org/derby/docs/10.15/ref/rrefproperdatadictversion.html thanks, bryan On Wed, Feb 17, 2021 at 4:23 PM Lisa Ruby wrote: > > Probably should have mentioned that I'm using derby version 10.15.2.0 > and AdoptOpenJDK Java 11.0.9.11-hotspot > > Lisa > > On

Re: How to determine version of a derby database

Probably should have mentioned that I'm using derby version 10.15.2.0 and AdoptOpenJDK Java 11.0.9.11-hotspot Lisa On 2/17/2021 4:08 PM, Lisa Ruby wrote: > Hi, > > I am using derby in the embedded mode for a Java Windows desktop > application. I am trying to find a way that I can determine what

How to determine version of a derby database

Hi, I am using derby in the embedded mode for a Java Windows desktop application. I am trying to find a way that I can determine what version my database is. When I use the Java Connection class getMetaData().getDatabaseProductVersion() call it always returns the version of the derby driver I am

Re: How to migrate a Derby database?

.n7.nabble.com/How-to-migrate-a-Derby-database-tp151268p151269.html I'm NOT completely sure what I'm doing right now.  I think this message should end up being an email addressed to Rick Hillegas.  I'm able to do this because of his reply to my original post which was done by sending an email

Re: How to migrate a Derby database?

should be copied on the whole conversation. Thanks, -Rick On 6/29/20 7:39 AM, recei...@gowdygroup.net wrote: Hi Ajax, Here are a couple points to consider: ... Quoted from: http://apache-database.10148.n7.nabble.com/How-to-migrate-a-Derby-database-tp151268p151269.html I'm NOT completely sure

Re: How to migrate a Derby database?

:39 AM, recei...@gowdygroup.net wrote: Hi Ajax, Here are a couple points to consider: ... Quoted from: http://apache-database.10148.n7.nabble.com/How-to-migrate-a-Derby-database-tp151268p151269.html I'm NOT completely sure what I'm doing right now. I think this message should end up being

Re: How to migrate a Derby database?

to quiesce the source database first, that is, gracefully shut it down. The Derby database format has not changed since the code was open-sourced in the early noughties. It is a platform-agnostic format, so you can simply tar up the whole directory tree holding the old database and then un-tar

How to migrate a Derby database?

It would be nice to have a way to convert a database to a form that is independent of the software used to support the database. For example, when using phpMyAdmin on a MySQL database there is an option referred to as "Export".  This option causes the creation of a text file that contains all

Re: Installing Derby Database

Hi all have sorted the problem :) whew Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Installing Derby Database

Which instructions are you following? And where did you enter 'java org.apache.derby.tools.sysinfo'? On Sat, Apr 7, 2018 at 3:06 PM, Bob M wrote: > Hi > > Am trying to install the latest version 10.14.1.0 > > Following instructions - I get to verifying Derby > > I

Installing Derby Database

Hi Am trying to install the latest version 10.14.1.0 Following instructions - I get to verifying Derby I input the command - java org.apache.derby.tools.sysinfo when I enter this command, there is an extremely brief flash on the screen and that is it ? what am I doing wrong ? Bob M --

Re: Derby Database Corruption Issues

gt; "Switch off the machine's write caching" . now the article is written in > 2013. Is it still application to derby database corruption or now it has no > effect. > > Regards, > Shreyans Jain > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered

Re: Derby Database Corruption Issues

ation. > > > Regards, > -- > Kristian > > Den ons. 12. jul. 2017, 20:04 skrev Shreyans Jain <shreyans2...@gmail.com > >: > >> I was reading https://wiki.apache.org/db-derby/DatabaseCorruption and i >> found prevention of corruption which states >&g

Re: Derby Database Corruption Issues

0:04 skrev Shreyans Jain <shreyans2...@gmail.com>: > I was reading https://wiki.apache.org/db-derby/DatabaseCorruption and i > found prevention of corruption which states > "Switch off the machine's write caching" . now the article is written in > 2013. Is it still applicati

Re: Derby Database Corruption Issues

ding Derby Database Corruption Issues on wiki of derby and i found prevention of corruption which states "Switch off the machine's write caching" . Now the article was last edited 2014-12-13 16:32:01 by 50. Is it still application to derby database corruption or now it has no effect. Regards, Shreyans Jain

Derby Database Corruption Issues

I was reading Derby Database Corruption Issues on wiki of derby and i found prevention of corruption which states "Switch off the machine's write caching" . Now the article was last edited 2014-12-13 16:32:01 by 50. Is it still application to derby database corruption or now it has

Derby Database Corruption Issues

I was reading https://wiki.apache.org/db-derby/DatabaseCorruption and i found prevention of corruption which states "Switch off the machine's write caching" . now the article is written in 2013. Is it still application to derby database corruption or now it has no effect. Regards, Shreyans Jain

Opening Derby database from a Path (not a File, not a String)

Hi all. A while ago I opened this ticket to allow opening a database from an NIO2 Path. https://issues.apache.org/jira/browse/DERBY-6912 I want to be able to open from a Path because everything other file we modify is done via a Path, allowing more universal abstraction of where the data

Re: Shutdown Derby database using JPA not DriverManager

lt;derby-user@db.apache.org> Subject: Re: Shutdown Derby database using JPA not DriverManager You should avoid using Persistence.createEntityManagerFactory. It does not work well in OSGi. Instead use Aries JPA or Aries transaction control. Both can provide you with a fully configured Enti

RE: Shutdown Derby database using JPA not DriverManager

cschneider...@gmail.com] On Behalf Of Christian Schneider Sent: Monday, January 2, 2017 07:32 To: Derby Discussion <derby-user@db.apache.org> Subject: Re: Shutdown Derby database using JPA not DriverManager You should avoid using Persistence.createEntityManagerFactory. It does not work well in OSGi. I

Re: Shutdown Derby database using JPA not DriverManager

At one point in the application, I need to stop the underlying Derby database. All of the examples show calling: Class.forName("org.apache.derby.jdbc.EmbeddedD

Shutdown Derby database using JPA not DriverManager

At one point in the application, I need to stop the underlying Derby database. All of the examples show calling: Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); DriverManager.getConnection("jdbc

Derby database insert/update performance in Embedded Linux Box

back to normal. We are running derby in network server mode, and another java application running with multi threads trying insert update. Please suggest me how to find tune this scenario. Thanks Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby

Re: Derby database insert/update performance in Embedded Linux Box

Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-database-insert-update-performance-in-Embedded-Linux-Box-tp143263.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Derby database insert/update performance in Embedded Linux Box

this message in context: http://apache-database.10148.n7.nabble.com/Derby-database-insert-update-performance-in-Embedded-Linux-Box-tp143263.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Multiple open/close of a derby database

mode which is exclusive to that Jvm. You need to start an instanceof derby in server mode And have the applications connect to it. Sent from my iPhone On Sep 25, 2014, at 18:14, Bob M rgmatth...@orcon.net.nz wrote: Hi I have an application which opens a derby database and then does some

Multiple open/close of a derby database

Hi I have an application which opens a derby database and then does some things with table A I have now cloned this application to give me three applications which are 98% identical App 1 opens the database and actions table 1 App 2 opens the same database and actions table 2 App3 opens the same

Re: Multiple open/close of a derby database

opens a derby database and then does some things with table A I have now cloned this application to give me three applications which are 98% identical App 1 opens the database and actions table 1 App 2 opens the same database and actions table 2 App3 opens the same database and actions table 3

Re: Multiple open/close of a derby database

to it. Sent from my iPhone On Sep 25, 2014, at 18:14, Bob M rgmatth...@orcon.net.nz wrote: Hi I have an application which opens a derby database and then does some things with table A I have now cloned this application to give me three applications which are 98% identical App 1 opens the database

Re: Connect to derby database on raspberry pi

that the database server runs under port 1527. But I can´t get a connection to the database from my windows 7 PC. I checked my firewall (comodo) and opened the port 1527. The database server does run on port 1527 (by default), but you have to start that server yourself.

Connect to derby database on raspberry pi

. Andreas -- View this message in context: http://apache-database.10148.n7.nabble.com/Connect-to-derby-database-on-raspberry-pi-tp137344.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Number of connection to an embedded derby database

On 2/18/14 9:04 AM, Rohit Jhunjhunwala wrote: Hi, I am using an embedded derby database (Apache Derby 10.8.1.2) in my java desktop application. I would like to know that is there any way to monitor the number of active connections from my desktop application to the derby database. I

Re: Number of connection to an embedded derby database

I have used *EmbeddedConnectionPoolDataSource *class for connection pooling and I just want to check if my connection are actually being pooled. You could attach a memory debugger, like the Eclipse Heap Analysis Tool, and look at the histogram of classes, and look at the number of instances of

Number of connection to an embedded derby database

Hi, I am using an embedded derby database (Apache Derby 10.8.1.2) in my java desktop application. I would like to know that is there any way to monitor the number of active connections from my desktop application to the derby database. I understand that embedded derby db does not allows

Re: Biggest Apache Derby database(s).

... Hi Paul, At Sun Microsystems we ran a stress test on a Derby database which successfully grew to 500GB. At that point, we halted the test, not because it was failing, but because we had satisfied ourselves that Derby could handle large data sets. However, I can't give you an URL because those

Re: Biggest Apache Derby database(s).

Hi Rick, I would like to know (with references/URLs preferably) what are the kinds of sizes that large Derby installs stretch to? Would it go to 1TB? More? Less? At Sun Microsystems Straight from the horse's mouth no less! :) we ran a stress test on a Derby database which successfully

Biggest Apache Derby database(s).

Hi all, I would like to know (with references/URLs preferably) what are the kinds of sizes that large Derby installs stretch to? Would it go to 1TB? More? Less? Thanks in advance for any info, pointers and esp. references and URLs. Rgs, Paul... -- lineh...@tcd.ie Mob: 00 353 86 864

Re: How to repair derby database

, -Rick On 10/31/13 5:28 AM, Narasimha Rao. Thangella wrote: Dear Sir, Greetings from Narasimha Rao, I using derby database, in that i was unable to open one table and below i am sending error msg. So How can I open single table/ repair table Error msg : Error code 4, SQL state 08006

How to repair derby database

Dear Sir, Greetings from Narasimha Rao, I using derby database, in that i was unable to open one table and below i am sending error msg. So How can I open single table/ repair table Error msg : Error code 4, SQL state 08006: A network protocol error was encountered and the connection has

Re: selecting records in a derby database

On 20. okt. 2013, at 04:01, Bob M rgmatth...@orcon.net.nz wrote: hi I have a derby database and a table with over 4,000 records… It is easier to think about a table as a hash table or tree, rather than an array. So there isn't really a concept of first or last other than

Re: selecting records in a derby database

in context: http://apache-database.10148.n7.nabble.com/selecting-records-in-a-derby-database-tp134896p134901.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: selecting records in a derby database

rs = s.executeQuery(SELECT COUNT(*) FROM TABLE_NAME); int recordCount = ??; The query returned a result set. Call next() on the result set to move to the first (and only) row in the result set. Then you can call getInt() to get the integer value of the first (and only) column in that row.

Re: selecting records in a derby database

://apache-database.10148.n7.nabble.com/selecting-records-in-a-derby-database-tp134896p134906.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: selecting records in a derby database

int recordCount = rs.getInt(); I get compilation error on last line The method getInt(int) in the type ResultSet in not applicable for the arguments () Indeed, you have to specify the columnIndex. http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getInt(int) Specify getInt( 1

Able to reconnect previously shutdown in-memory derby database

Hi, Could someone please explain whats wrong with this little unit test that I mocked up? I'm using derby version 10.10.1.1 Basically I create an in-memory derby database, shut it down and then expected it to not exist anymore. But if the unit test is right, I can actually reconnect

Re: Able to reconnect previously shutdown in-memory derby database

explain whats wrong with this little unit test that I mocked up? I'm using derby version 10.10.1.1 Basically I create an in-memory derby database, shut it down and then expected it to not exist anymore. But if the unit test is right, I can actually reconnect to it. Best regards /Pelle Code

Re: Able to reconnect previously shutdown in-memory derby database

On 10/9/2013 5:26 AM, pelle.ullberg wrote: Hi, Could someone please explain whats wrong with this little unit test that I mocked up? I'm using derby version 10.10.1.1 Basically I create an in-memory derby database, shut it down and then expected it to not exist anymore. But if the unit test

Reg: Restoring the Derby Database.

Hi, I need to Restore the Derby Database when database is running. But in my observation I found we can only restore in the first connection (JDBC) after the database(Derby Network Server) boot up. If any another connection already connected normally then we if we pass the *restoreFrom

Re: Reg: Restoring the Derby Database.

On 7/8/13 11:40 PM, Sekhar Kosuru wrote: Hi, I need to Restore the Derby Database when database is running. But in my observation I found we can only restore in the first connection (JDBC) after the database(Derby Network Server) boot up. If any another connection already connected normally

Re: Is there some way to shut down a Derby database faster?

Trejkaz trej...@trypticon.org writes: On Tue, Jul 2, 2013 at 10:18 PM, Rick Hillegas rick.hille...@oracle.com wrote: If you simply exit the VM without requesting an orderly shutdown, then the checkpoint won't be performed. However, the cleanup performed by that checkpoint still has to be

Re: Is there some way to shut down a Derby database faster?

Exiting the VM isn't really an option for me anyway, this is just when someone is closing the database, potentially planning to open another one. Another question along the same lines then - if I kick off the shutdown in another thread, what happens if the same database is then reopened while

Re: Is there some way to shut down a Derby database faster?

On Fri, Jul 5, 2013 at 12:44 AM, Bryan Pendleton bpendleton.de...@gmail.com wrote: Have you considered using a connection pool in between your application layer and the database, so that the connections are retained and re-used, rather than being fully reclaimed and fully reopened? From the

Re: Is there some way to shut down a Derby database faster?

So if users need data after working with database give them consistent copy using backup http://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt43.html#HDRSII-BUBBKUP-63476 Peter On 4. 7. 2013, at 23:17, Trejkaz trej...@trypticon.org wrote: On Fri, Jul 5, 2013 at 12:44 AM, Bryan Pendleton

Re: Is there some way to shut down a Derby database faster?

On 7/1/13 6:01 PM, Trejkaz wrote: Hi all. Is there some way to shut down a Derby database in a faster way? The current ;shutdown=true we're using is doing a checkpoint, which seems to be a particularly expensive operation. I can't rely on the if you don't want to do the checkpoint, just don't

Re: What do you use to get an ER diagram of an existing Derby database?

Wie are using http://schemaspy.sourceforge.net together with http://www.graphviz.org Result look nice and it is intgratable with maven vor ant. Am 23.01.2013 20:20 schrieb Al Eridani al.erid...@gmail.com: Hello, we have an existing Derby database that we would like to document with an entity

Re: What do you use to get an ER diagram of an existing Derby database?

are using http://schemaspy.sourceforge.net together with http://www.graphviz.org Result look nice and it is intgratable with maven vor ant. Am 23.01.2013 20:20 schrieb Al Eridani al.erid...@gmail.com: Hello, we have an existing Derby database that we would like to document with an entity

Re: How to reset Derby Database in JVM

Zinger Rick Hillegas-3 wrote: On 10/10/12 6:35 PM, Oskar Zinger wrote: Hi Derby Community, I'm having some difficulties resetting a Derby Database without restarting the whole application (JVM). I'm deploying Derby Network Server. My application has a service that executes shutdown

Re: How to reset Derby Database in JVM

On 11/13/2012 3:27 PM, Oskar Zinger wrote: Hi Rick, Thank you for the pointers to the right places in the documentation. Here is what I used: Shutting down the system: http://db.apache.org/derby/docs/10.8/devguide/tdevdvlp20349.html Shutting down Derby or an individual database:

Re: How to reset Derby Database in JVM

from getting the nested exception for the SQLException returned because the system is shutdown. If you are using embedded Server I would recommend using the embedded URL if you can. -- View this message in context: http://old.nabble.com/How-to-reset-Derby-Database-in-JVM

How to reset Derby Database in JVM

Hi Derby Community, I'm having some difficulties resetting a Derby Database without restarting the whole application (JVM). I'm deploying Derby Network Server. My application has a service that executes shutdown / start of the Derby Network Server on demand. // code here to clear Derby

Reg: Derby Database Connection From Cross Platform

Hi, I am new bie to Apache Derby, i have been asked to test the performance of Derby database with 1000 concurrent Threads, In each thread open a connection do one insert, select, update quries on one table. I implemented the simulation code and tested in my local machine (Windows 7) where i am

Re: Reg: Derby Database Connection From Cross Platform

the performance of Derby database with 1000 concurrent Threads, In each thread open a connection do one insert, select, update quries on one table. I implemented the simulation code and tested in my local machine (Windows 7) where i am running my Derby database in networking mode. Even i tested

Java DB (Derby Database) queries

Hi , Can somebody please help with the customer queries below regarding Java DB (Derby Database) that comes bundled with the Oracle Glassfish server. 1) Does Java DB support database level audit trail ? 2) Does Java DB support database level encryption ? Any pointers will be most

Re: Java DB (Derby Database) queries

Hi Deepali, Some comments inline... On 7/25/12 10:02 PM, Deepali Pandey wrote: Hi , Can somebody please help with the customer queries below regarding Java DB (Derby Database) that comes bundled with the Oracle Glassfish server. 1) Does Java DB support database level audit trail ? Derby

Re: Java DB (Derby Database) queries

1) Does Java DB support database level audit trail ? Derby does not provide any support for tracking security-related operations. If you only need to audit update statements, you may be able to define triggers that do what you need. Typically this is done by having your triggers append

Problem upgrading a derby database, ArrayIndexOutOfBoundsException on getIndexInfo()

Hi, I posted time ago on this mailing list a similar question about an upgrading problem but i never found a solution, now i think i have the same problem with another derby database, i hope i can find a solution this time. I have a derby database 10.8.x and i use it with jdo/datanuclues. I am

Re: Problem upgrading a derby database, ArrayIndexOutOfBoundsException on getIndexInfo()

On 06/30/2012 02:24 PM, fed wrote: I have a derby database 10.8.x and i use it with jdo/datanuclues. I am trying to update it to 10.9 but after updating it the database becomes unusable, it gives me an ArrayIndexOutOfBoundsException on conn.getMetaData().getIndexInfo(... ). From time to time

a few questions to Apache Derby Database

Dear All, I have the following questions to Apache Derby Database: 1. Does Derby have any limit on the database size? ( the size of our Database is about 3,1 GB ) 2. Dose Derby have any problems to manage database sizes over 1GB? 3. We have with Derby database many

Re: a few questions to Apache Derby Database

Hello, Some responses inline... On 5/18/12 1:32 AM, Awad, Luay wrote: Dear All, I have the following questions to Apache Derby Database: 1.Does Derby have any limit on the database size?( the size of our Database is about 3,1 GB ) 2.Dose Derby have any problems to manage database sizes

Re: a few questions to Apache Derby Database

*_java.lang.OutOfMemoryError: Java heap space_* Is it because of the size of our database (3,1 GB!)? and what can I do to improve the performance of the Derby Database, and to resolve the error? The Derby Tuning Guide provides a lot of useful general advice about how to tune the performance

Re: Derby database

On 05.05.12 12:13, Aristedes Maniatis wrote: Running Derby 10.8, a customer has managed to corrupt their database somehow (possibly by forcing the database to quit when it did not shut down fast enough to their liking). I see that when I connect to it with ij in embedded mode, I get the

Derby database

Running Derby 10.8, a customer has managed to corrupt their database somehow (possibly by forcing the database to quit when it did not shut down fast enough to their liking). I see that when I connect to it with ij in embedded mode, I get the following: ERROR 40XD2: Container Container(0,

Re: Derby Database start failed on Z/OS

Pallimakkal, Ambili V ambili.pallimak...@ca.com writes: Hi, We are having some issues with derby database on Z/OS. You are using a fairly old version of Derby, 10.5.3.0. Can you reproduce this problem with a newer version [1]? [1] http://db.apache.org/derby/releases/release-10.8.2.2.cgi

Derby Database start failed on Z/OS

Hi, We are having some issues with derby database on Z/OS. The install is created on a HFS file system. And we create DB using this command java -cp . -jar derbyrun.jar ij databaseAuth.sql and databaseAuth.sql content is given below. connect 'jdbc:derby: /HO43/Vantagegmi/webclientdb

Re: Derby database started in READ ONLY mode

freeing up some space on that disk or move your database to a disk with more room. Hope this helps, -Rick On 2/6/12 5:44 AM, Ram T wrote: Hi All, I am using derby database to store the information related the URL's in my content. I will insert the records using Java language and read them

Re: Derby database started in READ ONLY mode

freeing up some space on that disk or move your database to a disk with more room. Hope this helps, -Rick On 2/6/12 5:44 AM, Ram T wrote: Hi All, I am using derby database to store the information related the URL's in my content. I will insert the records using Java language and read

Re: Derby database started in READ ONLY mode

=== java.io.IOException: No space left on device at sun.nio.ch.FileDispatcher.pwrite0(Native Method) at Also check if your database is located on a FAT-32 filesystem or similar, where database files are limited by the filesystem to a max 2GB size. Similar things can happen with

Re: Derby database started in READ ONLY mode

://old.nabble.com/Derby-database-started-suddenly-in-READ-ONLY-mode-tp33271488p33276887.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: How to SELECT data from in-memory Derby database table?

On 11/11/11 4:39 AM, Jonas Pettersson wrote: DECLARE GLOBAL TEMPORARY TABLE SESSION.memtable (id int, name varchar(10)) NOT LOGGED Hi Jonas, It's likely that you are running with autocommit turned on (this is the default). Your temporary table was declared in a way which causes it to throw

Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption

On 9/30/2011 8:24 AM, rob wrote: Sorry here are the full stacktrace: Rob, I think you should go ahead and file a bug for this and work on a reproduction that you can attach to the issue. http://db.apache.org/derby/DerbyBugGuidelines.html Please make sure you include the exact 10.5 version you

Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption

Hi, I have a derby database i use it in embeeded mode with datanucleus JDO, it was at version 10.5 and i have updated it to version 10.8, i used it for a while with no problems but now, with no reason, it becomes unusable with datanucleus. I am able to connect to it with a client like squirrel

Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption

On 9/30/2011 7:38 AM, rob wrote: I write below some of the exceptions from derby.log, the problem seems on the SYS.getIndexInfo. Rob can you provide the stack trace from the derby.log for the ArrayIndexOutOfBoundsException?

Re: Problem with a derby database - connection closed and ArrayIndexOutOfBoundsExeption

Sorry here are the full stacktrace: Fri Sep 30 16:24:45 CEST 2011 Thread[main,5,main] (XID = 3784650), (SESSIONID = 5), (DATABASE = db/rilevdata), (DRDAID = null), Executing prepared statement: EXECUTE STATEMENT SYS.getTables :End prepared statement with 7 parameters begin parameter #1: % :end

Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup

with result [true] -- Its look like bug in derby database. -- Some one noticed about this error before but no one suggested work around for this issue. This issue highly blocking the customers to take the database backup in production. Regards, Jayaprakash Kumar

Re: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup

)         at com.topgear.executer.impl.StdJobExecutionShell.run(StdJobExecutionShell.java:207)         at com.topgear.threadpool.impl.StdThreadPool.run(StdThreadPool.java:168)         at java.lang.Thread.run(Thread.java:595) Job execution COMPLETED with result [true] -- Its look like bug in derby

AW: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup

: Donnerstag, 9. Juni 2011 15:10 An: derby-user@db.apache.org Betreff: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup Hi Team We are facing the problem with derby Backup Database procedure function SYSCS_UTIL.SYSCS_BACKUP_DATABASE

Fw: Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup

Technologies übermittelt? - Forwarded by Jayaprakash Kumar/ext/dbcom on 09/06/2011 16:54 - Jayaprakash Kumar/ext/dbcom 09/06/2011 15:09 To derby-user@db.apache.org cc Subject Derby Database stored procedure (SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)) is failing to take database backup Hi

How to convert MSSqlServer to Derby DataBase?

I want to use derby database for my java project. Now I have MSSqlServer DataBase. How to convert MSSqlServer to Derby dataBase? Thank you reading my email!

Re: Derby database backup and restore

the data into my latest derby database version. Cf derby.storage.pageSize as described here: http://db.apache.org/derby/docs/10.6/ref/rrefproper40688.html This value will be used for the lifetime of the newly created conglomerates. So upgrading won't change the pageSize. You could use a temporary

Derby database backup and restore

of older version and create a new database with newer version along with increase in page size and just import the data into my latest derby database version. -- View this message in context: http://old.nabble.com/Derby-database-backup-and-restore-tp30239556p30239556.html Sent from the Apache

Re: Problem Inserting Swedish Characters in Derby Database

Hi Kristian - Thank you for your help. Your suggestion was correct. After some Googling I found this page: http://illegalargumentexception.blogspot.com/2009/04/i18n-unicode-at-windows-command-prompt.html#charsets_pound which explains the problem I had. It turns out that the Windows command

Re: Problem Inserting Swedish Characters in Derby Database

Sorry, I forgot to mention this is with Derby 10.6.1.0 and JDK 1.6.0 update 20 on Windows 7 Professional 64-bit. Mark Johnson On 7/23/2010 10:35 PM, Mark D. Johnson wrote: Hi - I have run into a problem trying to insert the Swedish vowels Å, Ä and Ö into Varchar fields in a Derby database

Problem Inserting Swedish Characters in Derby Database

Hi - I have run into a problem trying to insert the Swedish vowels Å, Ä and Ö into Varchar fields in a Derby database. I first noticed a problem with the capital Å using ij to do the insert. When I did a select on the field, the character Å was shown as a question mark. This is the only

Re: Does derby database need periodic maintenance/cleanup activity ?

It is observed that, if derby database runs continuously for say around 5 hrs. It becomes really slow for further queries even with fresh DB calls. Unless you are adding data dramatically fast, I don't think you should need to do cleanup or maintenance on the database itself very frequently

how to repair a derby database

I have an openbravopos 2.30 with a broken Apache derby database and need some direction on how to repair the database. I am getting the flowing error. com.openbravo.basic.BasicException: Cannot connect to database. Database not available. java.sql.SQLException: Failed to start database '/home

Re: Copying an idle derby database that is currently open

On 04/ 9/10 06:40 AM, David Sitsky wrote: Hi all, I know this scenario is not recommended, but a couple of our customers had accidentally copied some Derby databases which were still opened by a program, however they claim the program had been idle for quite some time, so there should not

Fwd: Location of Embedded JavaDB (Derby) database - Java Web Start JNLP

Hi, This is a post in the Java Web Start Forum which I am posting here in case there is a Derby configuration solution. ie. Is it possible to set derby.system.home based on the user ie. C:\Documents and Settings\user\ http://forums.sun.com/thread.jspa?threadID=5429340tstart=0 Thanks

  1   2   >