Re: Pooling

2009-09-28 Thread Matt Doran
Kristian Waagan wrote: Matt Doran wrote: Peter Ondruška wrote: Yes, Derby does not provide connection pool, pick your favourite (I can confirm c3p0 works very well for me). Peter We also use c3p0 with embedded derby, but it's mainly just our default configuration so if you switch our app ove

Re: SQLException: Syntax error: Encountered "" at line 1, column 19.

2009-09-28 Thread jstrunk
At my level, its too hard to understand the demo programs. I did find several places online that said you DO NOT code the parens on the procedure name if there are no parameters. So I took that out. Here is my code now and the error I get now. import java.sql.*; public class InstallProcs {

Re: SQLException: Syntax error: Encountered "" at line 1, column 19.

2009-09-28 Thread Rick Hillegas
jstrunk wrote: I was coding "create procedure show_suppliers " and the error went away when I changed it to "create procedure show_suppliers() ". Does that make sense? It is like declaring a method with no arguments in Java: you still need an empty argument list. There are no parms on

[no subject]

2009-09-28 Thread Malte.Kempff
Hi, I am a bit confused by this log. The SQL-Statements are alright, but the there are a lot of commitings and rolling backs I cannot explain, since my program actually does one commit as far I can see from the logs of my application. Also I am wondering about Sessionid=0? As far I know my pro

Re: SQLException: Syntax error: Encountered "" at line 1, column 19.

2009-09-28 Thread jstrunk
I was coding "create procedure show_suppliers " and the error went away when I changed it to "create procedure show_suppliers() ". Does that make sense? There are no parms on the method but I saw the parens in a syntax diagram and thought they might be required anyway. The sample code I

Re: SQLException: Syntax error: Encountered "" at line 1, column 19.

2009-09-28 Thread Knut Anders Hatlen
Rick Hillegas writes: > jstrunk wrote: >> I am using Eclipse 3.5.0 with Derby 10.5.3.0 (not the Derby Plugin). I >> created an SQLJ stored procedure and stored it. When I try to execute it I >> get SQLException: Syntax error: Encountered "" at line 1, >> column 19. >> >> That is the only error i

AW: Information for derby-user@db.apache.org

2009-09-28 Thread Malte.Kempff
Hi to all, Well I found the trouble. I was doing something weird on Freiday evening, and was not able to see it today as well being a bit blind. So never mind ... Malte -Ursprüngliche Nachricht- Von: malte.kem...@de.equens.com [mailto:malte.kem...@de.equens.com] Gesendet: Montag, 2

Re: tool to sync to derby databases?

2009-09-28 Thread Rick Hillegas
Hi J.V., I think that some people have gotten traction with the Daffodil replicator: http://enterprise.replicator.daffodilsw.com/ Hope this helps, -Rick J.V. wrote: Seeking: A free or commercial product / api / tool that can be embedded into a Java app to sync two derby databases and handl

Re: SQLException: Syntax error: Encountered "" at line 1, column 19.

2009-09-28 Thread Rick Hillegas
jstrunk wrote: I am using Eclipse 3.5.0 with Derby 10.5.3.0 (not the Derby Plugin). I created an SQLJ stored procedure and stored it. When I try to execute it I get SQLException: Syntax error: Encountered "" at line 1, column 19. That is the only error information I get. How can I get a listin

Re: Pooling

2009-09-28 Thread Kristian Waagan
Matt Doran wrote: Peter Ondruška wrote: Yes, Derby does not provide connection pool, pick your favourite (I can confirm c3p0 works very well for me). Peter We also use c3p0 with embedded derby, but it's mainly just our default configuration so if you switch our app over to a network based da

lock timeout on an insert with auto-id

2009-09-28 Thread gordon wilcox
Hi - can anyone answer my question - I have serched Jira but cant find the answer. In March 08 there was discussion about a timeout that occurred when processing lots of Inserts, when the ID of the row was auto. This caused a lock timeout in syscolumns. My question is simple - has this issu

AW: Information for derby-user@db.apache.org

2009-09-28 Thread Malte.Kempff
Hi, I have a little routine, that is supposed to delete some records after a certain due date. It looks like the following: public void reorganize(long defermentPeriod) { m_strBuf.delete(0, m_strBuf.length()); m_strBuf.append("delet