db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sandeep Samdaria <ssam...@ncsu.edu>
Subject Re: Unable to run the test to reproduce DERBY-4091
Date Tue, 15 Mar 2016 00:01:06 GMT
Hi Bryan,
Placing the derby.properties in the tests directory made the MailJdbc test
run. As per the JIRA, I have removed the column "size_problem" from the
insertStr (Statements.java) query and rebuilt the jars. Now, when I am
trying to run the MailJdbc test it is taking too much time(potentially due
to many sleep calls).
I have left this test running for 4 hours and I still see it is running. I
have attached the Activity.out on JIRA for the MailJdbc test.
Please let me know if I can upload the patch on the jira, so that it can be
tested on some test server for longer duration.


On Sun, Mar 13, 2016 at 12:35 PM, Bryan Pendleton <
bpendleton.derby@gmail.com> wrote:

> From, the classes directory of the source I am executing the above command
>> and getting the following error:
>> java.sql.SQLSyntaxErrorException: GRANT not allowed unless database
>> property derby.database.sqlAuthorization has value 'TRUE'.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:103)
>> I have also copied the derby.properties with
>> 'derby.database.sqlAuthorization' already set to true.
> Hi Sandeep,
> It sounds like you didn't quite get the derby.properties file in place.
> Here's what I did (after I did 'ant buildjars' to build the jars):
>         mkdir tests
>         cd tests
>         cp
> /home/bpendleton/derby/trunk/java/testing/org/apache/derbyTesting/system/mailjdbc/derby.properties
> .
>         export
> CLASSPATH=/home/bpendleton/derby/trunk/jars/sane/derbyrun.jar:/home/bpendleton/derby/trunk/jars/sane/derbyTesting.jar
>         java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded
> The test then prints several pages of messages about the schema
> processing, and then announces:
>         ...
>         ij> CREATE INDEX attach_at_Index on attach(attach_id);
>         0 rows inserted/updated/deleted
>         ij> created the schema
> and then it is running.
> Perhaps you can triple-check your derby.properties file, looking
> at https://db.apache.org/derby/docs/10.12/devguide/cdevsetprop13074.html
> to ensure your file is as expected by Derby.
> thanks,
> bryan

View raw message