Derby 10.1.1 - Question about transactions

2005-08-29 Thread Kostas Karadamoglou
Hello all, I am developing an application wich uses Derby 10.1.1 The application has multiple clients/ read connections that read tables and one write conenction that write into the tables. The connection that modifies the table mostly inserts rows. There is a potential problem of a user/r

How to start derby netserver within an application

2005-08-27 Thread Kostas Karadamoglou
Hello all, I am developing an applicaiton that uses Derby 10.1.1. Since now I start the database indepedently from the main application. I use ant to invoke the derby net server. Here is one of my targets: classname="org.apache.derby.drda.NetworkServerControl" dir="db" classpath="${

Re: Security restriction on a remote connection of Derby 10.1.1

2005-08-26 Thread Kostas Karadamoglou
No I haven't done it, I 'll do it immediately. A silly question: What's the meaning of 0.0.0.0 ? Does permit all kinds of connections? Knut Anders Hatlen wrote: Kostas Karadamoglou <[EMAIL PROTECTED]> writes: Hello all, I have developed a java application that use

Security restriction on a remote connection of Derby 10.1.1

2005-08-26 Thread Kostas Karadamoglou
Hello all, I have developed a java application that uses Apache Derby 10.1.1 from a remote machine. The remote machine also operates another application that uses the same database. The problem occurs when the application tries to connect with the database. It receives the following exceptio

Re: How to compute the duration of two timestamps

2005-08-23 Thread Kostas Karadamoglou
n two dates? Date: Sun, 07 Aug 2005 18:38:15 GMT Kostas Karadamoglou a écrit : Hi Oyvind, The link is broken can you send me the valid one. Prior of my first post I searched my gmane mailing list using the "duration" keyword but I didn't find anything

Re: How to compute the duration of two timestamps

2005-08-23 Thread Kostas Karadamoglou
Hi Oyvind, The link is broken can you send me the valid one. Prior of my first post I searched my gmane mailing list using the "duration" keyword but I didn't find anything [EMAIL PROTECTED] wrote: Kostas Karadamoglou wrote: Hi, How can I compute the duration of two times

How to compute the duration of two timestamps

2005-08-23 Thread Kostas Karadamoglou
Hi, How can I compute the duration of two timestamps? Is there any built-in function that helps? Are any alternative options? Thank you in advance, Kostas

Re: Simple question about Derby and Transactions

2005-08-22 Thread Kostas Karadamoglou
Thank you very much for the hint! [EMAIL PROTECTED] wrote: Kostas Karadamoglou wrote: Can I set the isolation level using JDBC? Yes. How can I do it? Connection.setTransactionIsolation() See http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Connection.html

Re: Simple question about Derby and Transactions

2005-08-22 Thread Kostas Karadamoglou
Can I set the isolation level using JDBC? How can I do it? [EMAIL PROTECTED] wrote: Kostas Karadamoglou wrote: Hello, I am new to Derby and to Transactions in general. I want to perform some tasks to my databases using one thread and lock the table that it uses from the remaining threads

Simple question about Derby and Transactions

2005-08-21 Thread Kostas Karadamoglou
Hello, I am new to Derby and to Transactions in general. I want to perform some tasks to my databases using one thread and lock the table that it uses from the remaining threads. My qyestion is simple! Haw can this be done with Jdbc and Derby? I dont care about distributed transaction. Th

Design problem About application related with cached rows

2005-08-13 Thread Kostas Karadamoglou
Hello again! I try to create an application for my dissertation that caches rows from an romote database. The application handles a cache database which is identical with the original. The only difference is that it does not have autogenerated fields and referential integrity is omitted. I h

Re: Problems with Derby 10.1.1 and derbyclient.jar [SQLException: No suitable driver]

2005-08-13 Thread Kostas Karadamoglou
this "jdbc:derby:net://localhost:1527/sampleDb:user=u1;password=p1;" url scheme with the org.apache.derby.jdbc.ClientDriver driver. I quess that is my mistake. Isn't it true? thank you in advance, Kostas Sunitha Kambhampati wrote: Kostas Karadamoglou wrote: Hi all, I was u

Problems with Derby 10.1.1 and derbyclient.jar [SQLException: No suitable driver]

2005-08-13 Thread Kostas Karadamoglou
Hi all, I was using Derby 10.0 with db2cc.jar and db2_licensecc.jar in network mode. The driver was called com.ibm.db2.jdbcDriver. Everything was working fine :) But now I changed to 10.1.1. The driver jar is derbyclient.jar and the driver org.apache.derby.jdbc.ClientDriver. Whenever I load

JDBC RowSet in Derby

2005-08-06 Thread Kostas Karadamoglou
Hello, I am new to Apache Derby. Does Derby's JDBC Driver implements RowSets. Is it a stable implementation? Thank you in advance, Kostas

export schema of db in xml format

2005-07-24 Thread Kostas Karadamoglou
Hello, I am new to derby database. I just wanted to ask you, is there any way to export the schema in xml format? If no, how can I do it by myself?