Re: Exception running RunOptimizerTest

i have not used netbeans so can't help much there. A good place to start looking for errors is derby.log, which should be in your testdb directory. it is probably in your current directory, but could be elsewhere based on various environmental variables. It definitely seems like a setup/jar f

Re: Exception running RunOptimizerTest

I am getting the exception below when running RunOptimizerTest (in org.apache.derbyTesting.system.optimizer). My goal is to step through the query compilation code to understand how it works. I am using Java 1.8. I am using netbeans 8.0.1 and the class path includes derbyrun.jar and derbyTesti

Exception running RunOptimizerTest

Hi Derby devs, I am getting the exception below when running RunOptimizerTest (in org.apache.derbyTesting.system.optimizer). My goal is to step through the query compilation code to understand how it works. I am using Java 1.8. I am using netbeans 8.0.1 and the class path includes derbyrun.jar an

Subscribe

Re: using log4j in user defined system procedure

On 12/17/15 6:39 AM, Anjana Prakash wrote: Hi , Does user defined system procedure enable logging using log4j. or using derby.log for logging the output from system procedure. Appreciate any reference on same. Thanks Anjana Hi Anjana, Take a look at the derby.stream.error properties doc

RE: create resultset from user defined system stored procedure

Thanks Alex will check on same. Thanks, Anjana. From: Alex [mailto:alex3...@zoho.com] Sent: Thursday, December 17, 2015 4:59 PM To: derby-dev@db.apache.org Subject: Re: create resultset from user defined system stored procedure Hi, You can read on stored procedures here: https://db.apache.org/d

RE: freeze database during export

Hi Rick, Thanks for follow-up will do as directed. Thanks, Anjana. From: Rick Hillegas [mailto:rick.hille...@gmail.com] Sent: Thursday, December 17, 2015 7:34 PM To: Anjana Prakash Cc: derby-dev@db.apache.org Subject: Re: freeze database during export On 12/16/15 8:01 PM, Anjana Prakash wrote:

using log4j in user defined system procedure

Hi , Does user defined system procedure enable logging using log4j. or using derby.log for logging the output from system procedure. Appreciate any reference on same. Thanks Anjana

Re: freeze database during export

On 12/16/15 8:01 PM, Anjana Prakash wrote: Hi Rick, Thanks for follow-up. I found the issue. The export block was raising exception due to incorrect table name. In that exception had missed to call unfreeze Hence db never came out of freeze mode. On that note Is there way to detect if db i

Re: create resultset from user defined system stored procedure

Hi, You can read on stored procedures here: https://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html They are supposed to be returning a Derby data types (except BLOB, CLOB, LONG VARCHAR, LONG VARCHAR FOR BIT DATA, and XML) in SQL expressions, so I don't think returning a Re

create resultset from user defined system stored procedure

Hi, Is there any reference available where in a user defined system stored procedure can return resultset. Thanks, Anjana.