Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
MIME-Version: 1.0
In-Reply-To: <56E596DE.1080602@gmail.com>
References: 
 <CAOxbHAGMft9+ckHCB+oOrshQPoXVK9QrH7-AXKx_SNs6xc98vA@mail.gmail.com>
 <56E596DE.1080602@gmail.com>
From: Sandeep Samdaria <ssamdar@ncsu.edu>
Date: Mon, 14 Mar 2016 20:01:06 -0400
Message-ID: 
 <CAOxbHAGGtFdDgkRHs9-GtZAoofO=wFwG83yU1cipNRPrvhEzNw@mail.gmail.com>
Subject: Re: Unable to run the test to reproduce DERBY-4091
To: derby-dev@db.apache.org
Content-Type: multipart/alternative; boundary=089e0122a0d433d3dd052e0b1917

--089e0122a0d433d3dd052e0b1917
Content-Type: text/plain; charset=UTF-8

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.

Regards,
Sandeep.

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
>
>

--089e0122a0d433d3dd052e0b1917
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Bryan,<div>Placing the derby.properties in the tests di=
rectory made the MailJdbc test run. As per the JIRA, I have removed the col=
umn &quot;size_problem&quot; from the insertStr (Statements.java)<i> </i>qu=
ery 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).=C2=A0</div><=
div>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.=C2=A0</di=
v><div>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.=C2=A0</div><div><br=
></div><div>Regards,</div><div>Sandeep.</div></div><div class=3D"gmail_extr=
a"><br><div class=3D"gmail_quote">On Sun, Mar 13, 2016 at 12:35 PM, Bryan P=
endleton <span dir=3D"ltr">&lt;<a href=3D"mailto:bpendleton.derby@gmail.com=
" target=3D"_blank">bpendleton.derby@gmail.com</a>&gt;</span> wrote:<br><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><span class=3D""><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
>
From, the classes directory of the source I am executing the above command =
and getting the following error:<br>
<br>
java.sql.SQLSyntaxErrorException: GRANT not allowed unless database propert=
y derby.database.sqlAuthorization has value &#39;TRUE&#39;.<br>
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExcept=
ionFactory.java:103)<br>
<br>
I have also copied the derby.properties with &#39;derby.database.sqlAuthori=
zation&#39; already set to true.<br>
</blockquote>
<br>
<br></span>
Hi Sandeep,<br>
<br>
It sounds like you didn&#39;t quite get the derby.properties file in place.=
<br>
<br>
Here&#39;s what I did (after I did &#39;ant buildjars&#39; to build the jar=
s):<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 mkdir tests<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 cd tests<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 cp /home/bpendleton/derby/trunk/java/testing/or=
g/apache/derbyTesting/system/mailjdbc/derby.properties .<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 export CLASSPATH=3D/home/bpendleton/derby/trunk=
/jars/sane/derbyrun.jar:/home/bpendleton/derby/trunk/jars/sane/derbyTesting=
.jar<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 java org.apache.derbyTesting.system.mailjdbc.Ma=
ilJdbc embedded<br>
<br>
The test then prints several pages of messages about the schema<br>
processing, and then announces:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 ...<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 ij&gt; CREATE INDEX attach_at_Index on attach(a=
ttach_id);<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 0 rows inserted/updated/deleted<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 ij&gt; created the schema<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
and then it is running.<br>
<br>
Perhaps you can triple-check your derby.properties file, looking<br>
at <a href=3D"https://db.apache.org/derby/docs/10.12/devguide/cdevsetprop13=
074.html" rel=3D"noreferrer" target=3D"_blank">https://db.apache.org/derby/=
docs/10.12/devguide/cdevsetprop13074.html</a><br>
to ensure your file is as expected by Derby.<br>
<br>
thanks,<br>
<br>
bryan<br>
<br>
</blockquote></div><br></div>

--089e0122a0d433d3dd052e0b1917--