Re: Maximum amount of data suitable for Derby

in the java.sql.Statement api is returned in the resulting update count array. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Re: Maximum amount of data suitable for Derby

Derby try to execute the remaining statements, after an error has occurred? Thanks in advance Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Maximum amount of data suitable for Derby

into Derby and then displayed in form of reports (based on Crystal Reports). 1) I would like to know whether Derby is suitable for such amounts of data? 2) What is the threshold, maximum amount of data Derby was designed to cope with? Thanks in advance Dmitri Pissarenko -- http://www.xing.com

Re: Maximum amount of data suitable for Derby

Hello! Many thanks for your answer, John! Could you tell me, what documents explain how to use (performance-optimize) Derby with large amounts of data? Thanks in advance Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Re: Maximum amount of data suitable for Derby

Hello! The main problem (at the moment) is the insertion of these data. What can I do to improve the speed, at which the data are inserted (apart from using prepared statements instead of normal ones and setting durability=test) ? Thanks in advance Dmitri Pissarenko -- http://www.xing.com

Re: Problem with UNIQUE constraint

(?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Re: Problem with UNIQUE constraint

timestamp.setNanos(0); before inserting a timestamp into the database. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Re: Problem with UNIQUE constraint

Hello! I found the problem - in one of the timestamps, nanos were not set to zero. Thanks for the hint! Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko

Problem with UNIQUE constraint

Hello! I have a table in my database with a UNIQUE -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Problem with UNIQUE constraint

a duplicate record in this table? Thanks in advance Dmitri Pissarenko

Re: Problem with UNIQUE constraint

for this particular table. I have other tables, too, with UNIQUE constraint and there the constraint works properly, i. e. when an attempt is made to insert a duplicate record, an exception is thrown. I appreciate any help about how to solve this problem. Thanks in advance Dmitri Pissarenko

Creating derby database in eclipse

Hello! I want to create a new Derby database in eclipse 3.2.2, Database explorer. Which values should I enter into the fields a) Class location (C:\Programme\Java\jdk1.5.0_06\lib\tools.jar ?), b) User ID and c) Password ? TIA Dmitri Pissarenko -- http://www.xing.com/profile

Re: Configuring derby (hard disk access frequency)

Hello! Thanks for your recommendations! Now it works. Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Configuring derby (hard disk access frequency)

Derby so that it accesses the hard disk less frequently. I suppose that the application will work the quickly, the less frequent Derby writes data to the hard disk. Thanks in advance Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Re: Sum of time

. Instead, first I convert this int (seconds) to a) hours b) minutes c) seconds. Then I create a string hours:minutes:seconds and parse it with TimeFormat. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Re: Sum of time

to be printed as hours, minutes and seconds (01:30:40), not as seconds/milliseconds. Of course, I could do the conversion (seconds/milliseconds to HH:MM:SS) in Crystal Reports, but it's easier for me to do it this way. Best regards Dmitri Pissarenko -- http://www.xing.com/profile

Sum of time

Message = Aggregate SUM cannot operate on type TIME. Exception message = java.sql.SQLSyntaxErrorException: Aggregate SUM cannot operate on type TIME. How can I run this query (determine sum of duration per place) nevertheless? TIA Dmitri Pissarenko -- http://www.xing.com/profile

Re: Views in Derby

, column 1. Exception message = java.sql.SQLSyntaxErrorException: Syntax error: Encountered ORDER at line 5, column 1. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Re: Views in Derby

15.05.2007 17:26:44 | 15.05.2007 17:26:44 | LOC_01 | B How can I fix this error? TIA Dmitri Pissarenko

Re: Views in Derby

Hello! Now I understand why this error happens: GROUP BY doesn't take into account the sort order (Starttime). Is there an elegant way to make GROUP BY take into account sort order of the records? TIA Dmitri Pissarenko

Views in Derby

| Loc1 | BName1, BName2 I have two questions: How to do this in Derby with a) minimum amount of Java coding and b) with minimum amount of duplicated data (if I have to use tables, instead of views for views #1 and #2, then data are being duplicated) ? Thanks in advance Dmitri Pissarenko -- http

Re: Shutting down built-in Derby

) at com.mycompany.myprogram.myprogram.main(myprogram.java:128) Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Re: Shutting down built-in Derby

Hello! Thanks for your answer! maybe you can: 1.make sure no ij is currently running What is an ij? 2.check if there are any threads keeping the connection to Derby is running How can I do it? TIA Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http

Re: Shutting down built-in Derby

); } catch (Exception exception) { logger.error(, exception); } } but I'm still getting the same error. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/

Shutting down built-in Derby

] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) [emmajava] at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) ... How can I close Derby database manually after a crash (except rebooting the machine) ? TIA Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http

Re: Difference between two timestamp fields

Hello! I found the error. This query is correct (SQL_TSI_SECOND instead of SQL_TSI_FRAC_SECOND): SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_SECOND, APP.MyTable.startTime, APP.MyTable.endTime)} FROM APP.MyTable WHERE APP.MyTable.startTime IS NOT NULL Thanks again. Dmitri