how to use a java class in a table function in the client server mode

2008-07-22 Thread michael . gulich
Hi, i wanted to explore the tablefunctions of derby a bit, but struggle to get one run in the client server environment. in the embedded mode everything works fine. i did this after doing the derby tutotial, so for my tests i used the tutorial db. i wrote a javaclass and put the jar(called ta

Re: cannot invoke other java.sql.Clob

2008-07-22 Thread Daniel Noll
Kristian Waagan wrote: Regarding the problem you mention above, I think similar issues might have been logged already. I'll keep my eyes open, and maybe someone else remembers the Jira issue. Providing any of the following information could help: a) Is there an error in derby.log on the server

Re: Choosing Database Location Programatically with Embedded Driver

2008-07-22 Thread Kai Ponte
On Tuesday 22 July 2008 05:29:15 am Shinkan wrote: > Hi there ! > > I'm really happy that I discovered Derby. It's a perfect embedded > lightweight data management system ! > As I really think that documentation is complete, it's sometimes hard to > find something precise. > > I would like to know

Re: Choosing Database Location Programatically with Embedded Driver

2008-07-22 Thread Rick Hillegas
Hi Pierre, The location of database files is determined by two variables: 1) the database location in your connection URL and 2) the location of the Derby system directory indicated by the "derby.system.home" system property. For more detail, please see the section titled "Connecting to datab

Choosing Database Location Programatically with Embedded Driver

2008-07-22 Thread Shinkan
Hi there ! I'm really happy that I discovered Derby. It's a perfect embedded lightweight data management system ! As I really think that documentation is complete, it's sometimes hard to find something precise. I would like to know if I can (and how), using Java JDBC Derby Embedded Driver, choose

Re: cannot invoke other java.sql.Clob

2008-07-22 Thread Kristian Waagan
Daniel Noll wrote: Hi all. I have someone getting an error like this on the client driver v10.4.1.3. java.sql.SQLException: You cannot invoke other java.sql.Clob/java.sql.Blob methods after calling the free() method or after the Blob/Clob's transaction has been committed or rolled back. a