Re: JDK 9 EA Build 178 & JDK 8u152 b05 are available on jdk.java.net

2017-07-18 Thread Rick Hillegas 

On 7/18/17 1:40 AM, Rory O'Donnell wrote:


Hi Rick,

We tried this on the following releases - OSX 10.10.3 , 10.11.4, 
10.11.6 & 10.12.5 without any issues.


Thanks for running those experiments, everyone. I have downloaded the 
jdk dmg 4 times, using two different browsers (Firefox 54.0.1 and Safari 
9.1.1). The behavior is always the same: a hang during initial verification.


I also tried downloading the jre instead. After I double clicked on the 
installer, I got a popup window with this message:


"A newer version of Java is already installed.

You are trying to install Java 9, however 10.6.0 is already installed. 
Visit java.com/newerversionexists.com for more information."


For the record, this is the version stamp on my currently installed Java 
9 jdk:


java version "9-ea"
Java(TM) SE Runtime Environment (build 9-ea+174)
Java HotSpot(TM) 64-Bit Server VM (build 9-ea+174, mixed mode)

Is there some log file I should inspect or some tracing trick I should 
try in order to tease more information out of the installer?


Thanks,
-Rick


Can you try to download again ?

Rgds,Rory


On 18/07/2017 02:05, Rick Hillegas wrote:

Hi Rory,

When I try to install the dmg image on my mac, (OSX 10.11.5), I get 
as far as initial verification, a little window which says "Verifying 
JDK 9.pkg". The progress indicator never moves and, in fact, it never 
registers any progress. It just hangs. This was not my experience 
with previous versions of JDK 9.


Thanks,
-Rick

On 7/17/17 4:56 AM, Rory O'Donnell wrote:

Hi Rick,


*JDK 9 Early Access*  build 178  is available at : - jdk.java.net/9/

A summary of all the changes in this build are listed here 
.


Changes which were introduced since the last availability email that 
may be of interest :


  * b175 - Module system implementation refresh**(6/2017 update)
  * b175 - no longer has "-ea" in the version string and the system
property "java version" is now simply "9"
 o

*java -version*

>java version "9"
>Java(TM) SE Runtime Environment (build 9+175)
>Java HotSpot(TM) 64-Bit Server VM (build 9+175, mixed mode)
 o

*Bundle name changes:*  e.g. jdk-9+175_linux-x86_bin.tar.gz


*JDK 8u152 Early Access*  build 05 is available at : - 
jdk.java.net/8/ 


A summary of all the changes in this build are listed here 
.


Rgds,Rory
--
Rgds,Rory O'Donnell
Quality Engineering Manager
Oracle EMEA , Dublin, Ireland





--
Rgds,Rory O'Donnell
Quality Engineering Manager
Oracle EMEA , Dublin, Ireland

[jira] [Commented] (DERBY-4041) NullPointerException on query with misplaced DERBY-PROPERTIES clause

2017-07-18 Thread Dimuthu Wickramanayake (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16092479#comment-16092479
 ] 

Dimuthu Wickramanayake commented on DERBY-4041:
---

Thank you very much Bryan.

> NullPointerException on query with misplaced DERBY-PROPERTIES clause
> 
>
> Key: DERBY-4041
> URL: https://issues.apache.org/jira/browse/DERBY-4041
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.3.3.0, 10.4.2.0, 10.5.1.1
>Reporter: Kathey Marsden
>Assignee: Dimuthu Wickramanayake
>Priority: Minor
>  Labels: derby_triage10_8
> Attachments: querynperepro.sql
>
>
> The following sql  throws  a NullPointerException
> ij> CREATE TABLE "APP"."T1" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t1 values (1, 2), (2, 4), (3, 6), (4, 8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T2" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t2 values (1, 2), (2, -4), (3, 6), (4, -8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T3" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into T3 values (1,1), (2,2), (3,3), (4,4), (6, 24),
>   (7, 28), (8, 32), (9, 36), (10, 40);
> 9 rows inserted/updated/deleted
> ij> insert into t3 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t3 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T4" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t4 values (3, 12), (4, 16);
> 2 rows inserted/updated/deleted
> ij> insert into t4 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t4 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> select count(*) from (select * from t1 union select * from t3 
> --DERBY-PROPERTIES joinStrategy=HASH
> ) x1 (c, d), (select * from t2 union select * from t4) x2 (e, f) where x1.c = 
> x2.e ;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
> at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
> at 
> org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
> at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
> at org.apache.derby.tools.ij.main(ij.java:59)
> Caused by: java.sql.SQLException: Java exception: ': 
> java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> ... 16 more
> Caused by: java.lang.NullPointerException
> at 
> org.apache.derby.impl.sql.compile.OptimizerImpl.getFinalCost(OptimizerImpl.java:2498)
> at 
> org.apache.derby.impl.sql.compile.SelectNode.getFinalCostEstimate(SelectNode.java:1987)
> at 
> org.apache.derby.impl.sql.compile.UnionNode.getFinalCostEstimate(UnionNode.java:653)
> at 
> org.apache.derby.impl.sql.compile.SetOperatorNode.modifyAccessPath(SetOperatorNode.java:169)
> at 
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(ProjectRestrictNode.java:718)
> at 
>

[jira] [Commented] (DERBY-5261) NetworkServerControl prints usage message twice on some errors

2017-07-18 Thread Bryan Pendleton (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-5261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16092422#comment-16092422
 ] 

Bryan Pendleton commented on DERBY-5261:


For an overview of how Derby's regression tests are organized, how to run a 
regression test, and how to contribute new regression tests, please look here: 
https://wiki.apache.org/db-derby/DerbyJUnitTesting

In your particular case, you should be able to run the current 
NetworkServerControlClientCommandTest by:

ant 
-Dderby.junit.testclass=org.apache.derbyTesting.functionTests.tests.derbynet.NetworkServerControlClientCommandTest
  junit-single

To add a new test to this suite, you would modify this Java class, to add a new 
"testDerby5261" method, which would run the command "java -jar derbynet.jar 
abc" and verify that you get the expected message once and only once.

You could add some other syntax error commands, and verify that they get the 
expected message, too, that would be great.

thanks,

bryan



> NetworkServerControl prints usage message twice on some errors
> --
>
> Key: DERBY-5261
> URL: https://issues.apache.org/jira/browse/DERBY-5261
> Project: Derby
>  Issue Type: Bug
>  Components: Network Server
>Affects Versions: 10.8.1.2
>Reporter: Knut Anders Hatlen
>Assignee: INDIKA KUMARA
>Priority: Minor
>  Labels: derby_triage10_9
>
> If you invoke NetworkServerControl with an invalid command, the usage message 
> will be printed twice.
> $ java -jar derbynet.jar abc
> Mon Jun 06 10:14:25 CEST 2011 : Command abc is unknown.
> Usage: NetworkServerControl  
> Commands:
> start [-h ] [-p ] [-noSecurityManager] [-ssl ]
> shutdown [-h ][-p ] [-ssl ] [-user ] 
> [-password ]
> ping [-h ][-p ] [-ssl ]
> sysinfo [-h ][-p ] [-ssl ]
> runtimeinfo [-h ][-p ] [-ssl ]
> logconnections {on|off} [-h ][-p ] [-ssl ]
> maxthreads [-h ][-p ] [-ssl ]
> timeslice [-h ][-p ] [-ssl ]
> trace {on|off} [-s ][-h ][-p ] [-ssl ]
> tracedirectory [-h ][-p ] [-ssl ]
> Mon Jun 06 10:14:25 CEST 2011 : No command given.
> Usage: NetworkServerControl  
> Commands:
> start [-h ] [-p ] [-noSecurityManager] [-ssl ]
> shutdown [-h ][-p ] [-ssl ] [-user ] 
> [-password ]
> ping [-h ][-p ] [-ssl ]
> sysinfo [-h ][-p ] [-ssl ]
> runtimeinfo [-h ][-p ] [-ssl ]
> logconnections {on|off} [-h ][-p ] [-ssl ]
> maxthreads [-h ][-p ] [-ssl ]
> timeslice [-h ][-p ] [-ssl ]
> trace {on|off} [-s ][-h ][-p ] [-ssl ]
> tracedirectory [-h ][-p ] [-ssl ]
> Printing it once should be enough.
> The same problem is seen if you don't specify a required argument for an 
> option. For example "java -jar derbynet start -p" (no port number).



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Assigned] (DERBY-4041) NullPointerException on query with misplaced DERBY-PROPERTIES clause

2017-07-18 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton reassigned DERBY-4041:
--

Assignee: Dimuthu Wickramanayake

> NullPointerException on query with misplaced DERBY-PROPERTIES clause
> 
>
> Key: DERBY-4041
> URL: https://issues.apache.org/jira/browse/DERBY-4041
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.3.3.0, 10.4.2.0, 10.5.1.1
>Reporter: Kathey Marsden
>Assignee: Dimuthu Wickramanayake
>Priority: Minor
>  Labels: derby_triage10_8
> Attachments: querynperepro.sql
>
>
> The following sql  throws  a NullPointerException
> ij> CREATE TABLE "APP"."T1" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t1 values (1, 2), (2, 4), (3, 6), (4, 8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T2" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t2 values (1, 2), (2, -4), (3, 6), (4, -8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T3" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into T3 values (1,1), (2,2), (3,3), (4,4), (6, 24),
>   (7, 28), (8, 32), (9, 36), (10, 40);
> 9 rows inserted/updated/deleted
> ij> insert into t3 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t3 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T4" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t4 values (3, 12), (4, 16);
> 2 rows inserted/updated/deleted
> ij> insert into t4 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t4 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> select count(*) from (select * from t1 union select * from t3 
> --DERBY-PROPERTIES joinStrategy=HASH
> ) x1 (c, d), (select * from t2 union select * from t4) x2 (e, f) where x1.c = 
> x2.e ;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
> at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
> at 
> org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
> at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
> at org.apache.derby.tools.ij.main(ij.java:59)
> Caused by: java.sql.SQLException: Java exception: ': 
> java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> ... 16 more
> Caused by: java.lang.NullPointerException
> at 
> org.apache.derby.impl.sql.compile.OptimizerImpl.getFinalCost(OptimizerImpl.java:2498)
> at 
> org.apache.derby.impl.sql.compile.SelectNode.getFinalCostEstimate(SelectNode.java:1987)
> at 
> org.apache.derby.impl.sql.compile.UnionNode.getFinalCostEstimate(UnionNode.java:653)
> at 
> org.apache.derby.impl.sql.compile.SetOperatorNode.modifyAccessPath(SetOperatorNode.java:169)
> at 
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(ProjectRestrictNode.java:718)
> at 
>

[jira] [Commented] (DERBY-4041) NullPointerException on query with misplaced DERBY-PROPERTIES clause

2017-07-18 Thread Bryan Pendleton (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16092419#comment-16092419
 ] 

Bryan Pendleton commented on DERBY-4041:


Welcome to Derby! I've marked you as assigned to DERBY-4041.

> NullPointerException on query with misplaced DERBY-PROPERTIES clause
> 
>
> Key: DERBY-4041
> URL: https://issues.apache.org/jira/browse/DERBY-4041
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.3.3.0, 10.4.2.0, 10.5.1.1
>Reporter: Kathey Marsden
>Assignee: Dimuthu Wickramanayake
>Priority: Minor
>  Labels: derby_triage10_8
> Attachments: querynperepro.sql
>
>
> The following sql  throws  a NullPointerException
> ij> CREATE TABLE "APP"."T1" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t1 values (1, 2), (2, 4), (3, 6), (4, 8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T2" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t2 values (1, 2), (2, -4), (3, 6), (4, -8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T3" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into T3 values (1,1), (2,2), (3,3), (4,4), (6, 24),
>   (7, 28), (8, 32), (9, 36), (10, 40);
> 9 rows inserted/updated/deleted
> ij> insert into t3 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t3 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T4" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t4 values (3, 12), (4, 16);
> 2 rows inserted/updated/deleted
> ij> insert into t4 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t4 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> select count(*) from (select * from t1 union select * from t3 
> --DERBY-PROPERTIES joinStrategy=HASH
> ) x1 (c, d), (select * from t2 union select * from t4) x2 (e, f) where x1.c = 
> x2.e ;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
> at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
> at 
> org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
> at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
> at org.apache.derby.tools.ij.main(ij.java:59)
> Caused by: java.sql.SQLException: Java exception: ': 
> java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> ... 16 more
> Caused by: java.lang.NullPointerException
> at 
> org.apache.derby.impl.sql.compile.OptimizerImpl.getFinalCost(OptimizerImpl.java:2498)
> at 
> org.apache.derby.impl.sql.compile.SelectNode.getFinalCostEstimate(SelectNode.java:1987)
> at 
> org.apache.derby.impl.sql.compile.UnionNode.getFinalCostEstimate(UnionNode.java:653)
> at 
> org.apache.derby.impl.sql.compile.SetOperatorNode.modifyAccessPath(SetOperatorNode.java:169)
> at 
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(ProjectRestrictNode.java:718)
> at 
>

Re: About an issue

2017-07-18 Thread Bryan Pendleton 
Welcome to Derby! I've marked you as assigned to DERBY-4998.

bryan


On Mon, Jul 17, 2017 at 10:40 PM, shamodya hashantha <
shamodya.hashantha...@gmail.com> wrote:

> I'm shamodya hashantha and my jira user name is hash .I searched some
> issues in derby project and i found an issue DERBY-4998
>   to work on . I
> request to assign me to this issue for work on it.
>

[jira] [Assigned] (DERBY-4998) Dynamic values in arithmetic operation must be explicitly casted to decimal when using PreparedStatement

2017-07-18 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-4998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton reassigned DERBY-4998:
--

Assignee: shamodya hashantha

> Dynamic values in arithmetic operation must be explicitly casted to decimal 
> when using PreparedStatement
> 
>
> Key: DERBY-4998
> URL: https://issues.apache.org/jira/browse/DERBY-4998
> Project: Derby
>  Issue Type: Bug
>  Components: JDBC, SQL
>Affects Versions: 10.7.1.1
>Reporter: Marco Rico-Gomez
>Assignee: shamodya hashantha
>Priority: Minor
>  Labels: derby_triage10_8
> Attachments: DerbyArithmeticTest.java
>
>
> The following SQL statement works as expected without an error:
> ---
> update T_Professor set weight_In_B_D = weight_In_B_D + 10) - 5) *
> 4) / 2) where (id = 1)
> ---
> But the same statement as a PreparedStatement throws an exception:
> --
> update T_Professor set weight_In_B_D = weight_In_B_D + ?) - ?) *
> ?) / ?) where (id = ?)
> --
> --
> java.sql.SQLException: The resulting value is outside the range for the data 
> type DECIMAL/NUMERIC(31,31).
>   at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
>   at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
>   ... 34 more
> Caused by: ERROR 22003: The resulting value is outside the range for
> the data type DECIMAL/NUMERIC(31,31).
>   at org.apache.derby.iapi.error.StandardException.newException(Unknown 
> Source)
>   at org.apache.derby.iapi.types.SQLDecimal.setWidth(Unknown Source)
>   at 
> org.apache.derby.exe.ac0b5b0099x012dxe042x51f3x00e17f003.e3(Unknown
> Source)
>   at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown 
> Source)
>   at 
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(Unknown
> Source)
>   at 
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
> Source)
>   at 
> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
> Source)
>   at 
> org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
> Source)
>   at 
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
>   at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown 
> Source)
>   at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
> Source)
>   at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown 
> Source)
>   ... 28 more
> --
> (The connection is made to an embedded in memory instance.)
> The values must be explicitly casted to decimal to get it working (even when 
> the values are set as BigDecimal):
> --
> update T_Professor set weight_In_B_D = weight_In_B_D + cast(? as 
> decimal)) - cast(? as decimal)) *
> cast(? as decimal)) / cast(? as decimal)) where (id = ?)
> --



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Assigned] (DERBY-6032) Concatenation operator confuses collation

2017-07-18 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton reassigned DERBY-6032:
--

Assignee: Kasun Prabath Amarasinghe

> Concatenation operator confuses collation
> -
>
> Key: DERBY-6032
> URL: https://issues.apache.org/jira/browse/DERBY-6032
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.8.3.0, 10.9.1.0, 
> 10.10.1.1
>Reporter: Knut Anders Hatlen
>Assignee: Kasun Prabath Amarasinghe
>  Labels: derby_triage10_11
>
> Given this table:
> ij> connect 
> 'jdbc:derby:memory:db;territory=en;collation=TERRITORY_BASED;create=true';
> ij> create table t(x varchar(10));
> 0 rows inserted/updated/deleted
> ij> insert into t values 'a' || 'b';
> 1 row inserted/updated/deleted
> The following query works:
> ij> select * from t where x = 'ab';
> X 
> --
> ab
> 1 row selected
> However, if the string is generated with the concatenation operator, an 
> exception is thrown:
> ij> select * from t where x = 'a' || 'b';
> ERROR 42818: Comparisons between 'VARCHAR (TERRITORY_BASED)' and 'CHAR 
> (UCS_BASIC)' are not supported. Types must be comparable. String types must 
> also have matching collation. If collation does not match, a possible 
> solution is to cast operands to force them to the default collation (e.g. 
> SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 
> 'T1')
> I'd expect the two queries to be equivalent.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Re: subscription

2017-07-18 Thread Bryan Pendleton 
Welcome to Derby! I've marked you as assigned to DERBY-6032

bryan


On Mon, Jul 17, 2017 at 11:35 PM, Kasun Prabath Amarasinghe <
kasunprabath...@gmail.com> wrote:

> Hello,
> my jira user name is KasunPrabath. I like to work on the issue DERBY-6032
> . I request to assign
> me to this issue for work on it.
>
> On Sat, Jul 1, 2017 at 9:51 PM, Kasun Prabath Amarasinghe <
> kasunprabath...@gmail.com> wrote:
>
>>
>>
>

Re: Hello!

2017-07-18 Thread Bryan Pendleton 
Welcome to Derby! I've marked you as assigned to DERBY-6711.

bryan

On Mon, Jul 17, 2017 at 11:58 PM, Rajitha Rajasooriya <
rajitharajasoor...@gmail.com> wrote:

> I would like to work on the following issue. DERBY-6711
> 
>
> Apache jira user name -rajitharajasooriya
> 
>
> --
> Rajitha
>

[jira] [Assigned] (DERBY-6711) Missing database name in error message from LogToFile.stopReplicationSlaveRole()

2017-07-18 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-6711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton reassigned DERBY-6711:
--

Assignee: Rajitha rajasooriya

> Missing database name in error message from 
> LogToFile.stopReplicationSlaveRole()
> 
>
> Key: DERBY-6711
> URL: https://issues.apache.org/jira/browse/DERBY-6711
> Project: Derby
>  Issue Type: Bug
>  Components: Store
>Affects Versions: 10.11.1.1
>Reporter: Knut Anders Hatlen
>Assignee: Rajitha rajasooriya
>Priority: Minor
>
> I saw this error in derby.log after running replication tests:
> {noformat}
> ERROR 08006: Database '{0}' shutdown.
>   at 
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>   at 
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java:285)
>   at 
> org.apache.derby.impl.store.raw.log.LogToFile.stopReplicationSlaveRole(LogToFile.java:5253)
>   at 
> org.apache.derby.impl.store.replication.slave.SlaveController.stopSlave(SlaveController.java:266)
>   at 
> org.apache.derby.impl.store.replication.slave.SlaveController.access$500(SlaveController.java:64)
>   at 
> org.apache.derby.impl.store.replication.slave.SlaveController$SlaveLogReceiverThread.run(SlaveController.java:526)
> {noformat}
> The database name is missing from the message.
> LogToFile.stopReplicationSlaveRole() should either call newException() with 
> the database name as argument or use another message that doesn't take a 
> database name argument.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Re: Assigning to an issue

2017-07-18 Thread Bryan Pendleton 
Welcome to Derby! I've marked you as assigned to DERBY-5411.

bryan

On Mon, Jul 17, 2017 at 11:58 PM, RANAWELLAGE LILANTHA KAVIN RANAWELLA <
kavin.ranawe...@eng.pdn.ac.lk> wrote:

> I would like to contribute to this project based on the following issue.
> Can you please assign me to it.
>
> https://issues.apache.org/jira/browse/DERBY-5411
>
> Thank you.
>
> --
> Undergraduate,
> Department of Computer Engineering,
> Faculty of Engineering,
> University of Peradeniya.
>
> Vice President in Marketing and Communication,
> Project 'Blue Marble v1.0',
> AIESEC in University of Peradeniya.
>
> Secretary,
> Engineering Students' Publication Society,
> Faculty of Engineering,
> University of Peradeniya.
>
>
>
>

[jira] [Assigned] (DERBY-5411) Client that does not have Security manager permission to connect gets "ERROR 08006: Insufficient data while reading from the network" Message should be clearer

2017-07-18 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton reassigned DERBY-5411:
--

Assignee: Kavin Ranawella

> Client that does not have Security manager permission to connect gets "ERROR 
> 08006: Insufficient data while reading from the network" Message should be 
> clearer
> ---
>
> Key: DERBY-5411
> URL: https://issues.apache.org/jira/browse/DERBY-5411
> Project: Derby
>  Issue Type: Bug
>  Components: Network Client
>Affects Versions: 10.8.2.2
>Reporter: Kathey Marsden
>Assignee: Kavin Ranawella
>Priority: Minor
>  Labels: derby_triage10_9
>
> I was doing a little remote testing for the release candidate and noticed if 
> a machine does not have permission to connect, then the client shows the 
> following exception:
> ij> connect  'jdbc:derby://x.xx.xxx.xx:1527/wombat';
> ERROR 08006: Insufficient data while reading from the network - expected a 
> minimum of 6 bytes and received only 0 bytes.  The connection has been term
> inated.
> java.sql.SQLNonTransientConnectionException: Insufficient data while reading 
> from the network - expected a minimum of 6 bytes and received only 0 byte
> s.  The connection has been terminated.
> at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:322)
> at java.sql.DriverManager.getConnection(DriverManager.java:297)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown 
> Source)
> at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> at org.apache.derby.tools.ij.main(Unknown Source)
> Caused by: org.apache.derby.client.am.DisconnectException: Insufficient data 
> while reading from the network - expected a minimum of 6 bytes and receiv
> ed only 0 bytes.  The connection has been terminated.
> at org.apache.derby.client.net.Reply.fill(Unknown Source)
> at org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown 
> Source)
> at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
> at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown 
> Source)
> at 
> org.apache.derby.client.net.NetConnectionReply.readExchangeServerAttributes(Unknown
>  Source)
> at 
> org.apache.derby.client.net.NetConnection.readServerAttributesAndKeyExchange(Unknown
>  Source)
> at 
> org.apache.derby.client.net.NetConnection.flowServerAttributesAndKeyExchange(Unknown
>  Source)
> at 
> org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowConnect(Unknown 
> Source)
> at org.apache.derby.client.net.NetConnection.(Unknown Source)
> at org.apache.derby.client.net.NetConnection40.(Unknown Source)
> at 
> org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
>  Source)
> ... 12 more
> It would be good to have a clearer error message:
> To Reproduce, use the script and policy file below changing the url for 
> derby.codejars to the correct path for  your enviroment also in the policy 
> file my.policy exchange x.x.x.x with the permitted host and y.y.y.y with the 
> disallowed host.  Then try to connect from the disllowed host with connect  
> 'jdbc:derby://x.x.x.x:1527/wombat';
> Script startServer.sh:
> java  -Djava.security.manager 
> -Dderby.codejars="file:c:/cygwin/home/kmarsden/projects/10.8.2testing/db-derby-10.8.2.1-lib/lib/"
>  -Djava.security.policy=my.policy org.apache.derby.drda.NetworkServerControl 
> start -h 0.0.0.0
> Policy File my.policy (change x.x.x.x and y.y.y.y) to the allowed and 
> disallowed host respectively. )Since the y.y.y.y line is commented it is not 
> really relevant except for testing that remote connections work properly)
> grant codeBase "${derby.codejars}derby.jar"
> {
> //
> // These permissions are needed for everyday, embedded Derby usage.
> //
>   permission

Assigning to an issue

2017-07-18 Thread RANAWELLAGE LILANTHA KAVIN RANAWELLA 
I would like to contribute to this project based on the following issue.
Can you please assign me to it.

https://issues.apache.org/jira/browse/DERBY-5411

Thank you.

-- 
Undergraduate,
Department of Computer Engineering,
Faculty of Engineering,
University of Peradeniya.

Vice President in Marketing and Communication,
Project 'Blue Marble v1.0',
AIESEC in University of Peradeniya.

Secretary,
Engineering Students' Publication Society,
Faculty of Engineering,
University of Peradeniya.

Hello!

2017-07-18 Thread Rajitha Rajasooriya 
I would like to work on the following issue. DERBY-6711


Apache jira user name -rajitharajasooriya


-- 
Rajitha

[jira] [Commented] (DERBY-4041) NullPointerException on query with misplaced DERBY-PROPERTIES clause

2017-07-18 Thread Dimuthu Wickramanayake (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-4041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16091202#comment-16091202
 ] 

Dimuthu Wickramanayake commented on DERBY-4041:
---

i LIKE TO WORK ON THIS ISSUE


> NullPointerException on query with misplaced DERBY-PROPERTIES clause
> 
>
> Key: DERBY-4041
> URL: https://issues.apache.org/jira/browse/DERBY-4041
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.3.3.0, 10.4.2.0, 10.5.1.1
>Reporter: Kathey Marsden
>Priority: Minor
>  Labels: derby_triage10_8
> Attachments: querynperepro.sql
>
>
> The following sql  throws  a NullPointerException
> ij> CREATE TABLE "APP"."T1" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t1 values (1, 2), (2, 4), (3, 6), (4, 8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T2" ("I" INTEGER, "J" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t2 values (1, 2), (2, -4), (3, 6), (4, -8), (5, 10);
> 5 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T3" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into T3 values (1,1), (2,2), (3,3), (4,4), (6, 24),
>   (7, 28), (8, 32), (9, 36), (10, 40);
> 9 rows inserted/updated/deleted
> ij> insert into t3 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t3 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> CREATE TABLE "APP"."T4" ("A" INTEGER, "B" INTEGER);
> 0 rows inserted/updated/deleted
> ij> insert into t4 values (3, 12), (4, 16);
> 2 rows inserted/updated/deleted
> ij> insert into t4 (a) values 11, 12, 13, 14, 15, 16, 17, 18, 19, 20;
> 10 rows inserted/updated/deleted
> ij> update t4 set b = 2 * a where a > 10;
> 10 rows inserted/updated/deleted
> ij> select count(*) from (select * from t1 union select * from t3 
> --DERBY-PROPERTIES joinStrategy=HASH
> ) x1 (c, d), (select * from t2 union select * from t4) x2 (e, f) where x1.c = 
> x2.e ;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
> at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
> at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
> at 
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
> at 
> org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
> at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
> at org.apache.derby.tools.ij.main(ij.java:59)
> Caused by: java.sql.SQLException: Java exception: ': 
> java.lang.NullPointerException'.
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> ... 16 more
> Caused by: java.lang.NullPointerException
> at 
> org.apache.derby.impl.sql.compile.OptimizerImpl.getFinalCost(OptimizerImpl.java:2498)
> at 
> org.apache.derby.impl.sql.compile.SelectNode.getFinalCostEstimate(SelectNode.java:1987)
> at 
> org.apache.derby.impl.sql.compile.UnionNode.getFinalCostEstimate(UnionNode.java:653)
> at 
> org.apache.derby.impl.sql.compile.SetOperatorNode.modifyAccessPath(SetOperatorNode.java:169)
> at 
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.modifyAccessPath(ProjectRestrictNode.java:718)
> at 
>

Re: subscription

2017-07-18 Thread Kasun Prabath Amarasinghe 
Hello,
my jira user name is KasunPrabath. I like to work on the issue DERBY-6032
. I request to assign me
to this issue for work on it.

On Sat, Jul 1, 2017 at 9:51 PM, Kasun Prabath Amarasinghe <
kasunprabath...@gmail.com> wrote:

>
>