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 < [email protected]> 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 > >
