subject:"\[Carbon\-dev\] Carbon\-3.0.0 Iridium \- 4RC22"

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

2010-06-10 Thread Sumedha Rubasinghe

Hi,
You have passed String 'null' as the parameter value. Try calling the
service without setting anything to the fields you have allowed null
compatible in the following SQL.

select id, name, created_at, updated_at, quantity from products where (:id
is null or id = :id) or (:name is null or name like :name) or (:created_at
is null or created_at = :created_at) or (:updated_at is null or updated_at =
:updated_at) or (:quantity is null or quantity = :quantity)

Anyway, this is a bug we need to fix in the next release. Please raise a
JIRA issue.
/sumedha


On Wed, Jun 9, 2010 at 10:41 PM, vy...@maneh.org wrote:

 Occurred errors in my tests with WSO2 Data Services Server 2.5.0 4RC22.

 My problems occurred when I use field type for input of types: date,
 timestamp and int and I try passed null in value.

 In attachment my service and mysql dump.



 Erros recevieds in log:

 === with all fields NULL

 Name: Products
 Location:

 /home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
 Description: N/A
 Default Namespace: http://ws.wso2.org/dataservice
 Current Request Name: selectProduct
 Current Params: {id=null, updated_at=null, name=null, created_at=null,
 quantity=null}
 Nested Exception:-
 java.lang.NumberFormatException: For input string: null
at

 java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at java.lang.Integer.parseInt(Integer.java:499)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setIntValue(SQLQuery.java:1329)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:832)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
at
 org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
at
 org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
at

 org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
at

 org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
at

 org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
at

 org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)


 === with id = 1 and other all fields NULL

 Name: Products
 Location:

 /home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
 Description: N/A
 Default Namespace: http://ws.wso2.org/dataservice
 Current Request Name: selectProduct
 Current Params: {id=1, updated_at=null, name=null, created_at=null,
 quantity=null}
 Nested Exception:-
 java.lang.RuntimeException: In valid string to parse
at

 org.apache.axis2.databinding.utils.ConverterUtil.convertToDate(ConverterUtil.java:603)
at org.wso2.carbon.dataservices.DBUtils.getDate(DBUtils.java:521)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setDateValue(SQLQuery.java:995)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:851)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
at

 org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
at
 org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
at
 org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
at

 org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
at

 org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
at

 org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
at

 org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)



 On Sat, 5 Jun 2010 09:25:03 +0530, Milinda Pathirage mili...@wso2.com
 wrote:
  http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/
 
  http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/Thanks
  Milinda
 
 

 ___
 Carbon-dev mailing list
 Carbon-dev@wso2.org
 https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

___
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

2010-06-10 Thread vyper

On Thu, 10 Jun 2010 17:35:30 +0530, Sumedha Rubasinghe sume...@wso2.com
wrote:
 Hi,
 You have passed String 'null' as the parameter value. Try calling the
 service without setting anything to the fields you have allowed null
 compatible in the following SQL.

I try passed nothing, but the error changed to Error in
'CallQuery.extractParams', cannot find Param with type:query-param
name:id. 

 select id, name, created_at, updated_at, quantity from products where
(:id
 is null or id = :id) or (:name is null or name like :name) or
(:created_at
 is null or created_at = :created_at) or (:updated_at is null or
updated_at
 =
 :updated_at) or (:quantity is null or quantity = :quantity)
 
 Anyway, this is a bug we need to fix in the next release. Please raise a
 JIRA issue.

I think this, but cannot found JIRA for this version. I found only 2.4. I
open in this version?

 /sumedha

[]s
Leonardo

___
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

2010-06-09 Thread vyper

Occurred errors in my tests with WSO2 Data Services Server 2.5.0 4RC22.

My problems occurred when I use field type for input of types: date,
timestamp and int and I try passed null in value.

In attachment my service and mysql dump.



Erros recevieds in log:

=== with all fields NULL

Name: Products
Location:
/home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
Description: N/A
Default Namespace: http://ws.wso2.org/dataservice
Current Request Name: selectProduct
Current Params: {id=null, updated_at=null, name=null, created_at=null,
quantity=null}
Nested Exception:-
java.lang.NumberFormatException: For input string: null
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at java.lang.Integer.parseInt(Integer.java:499)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setIntValue(SQLQuery.java:1329)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:832)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
at
org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
at
org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
at
org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
at
org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
at
org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
at
org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)


=== with id = 1 and other all fields NULL

Name: Products
Location:
/home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
Description: N/A
Default Namespace: http://ws.wso2.org/dataservice
Current Request Name: selectProduct
Current Params: {id=1, updated_at=null, name=null, created_at=null,
quantity=null}
Nested Exception:-
java.lang.RuntimeException: In valid string to parse
at
org.apache.axis2.databinding.utils.ConverterUtil.convertToDate(ConverterUtil.java:603)
at org.wso2.carbon.dataservices.DBUtils.getDate(DBUtils.java:521)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setDateValue(SQLQuery.java:995)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:851)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
at
org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
at
org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
at
org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
at
org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
at
org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
at
org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)



On Sat, 5 Jun 2010 09:25:03 +0530, Milinda Pathirage mili...@wso2.com
wrote:
 http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/
 
 http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/Thanks
 Milinda
 


___
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

2010-06-09 Thread vyper

Sorry, I forgot the attachments. 

On Wed, 09 Jun 2010 14:11:57 -0300, vy...@maneh.org wrote:
 Occurred errors in my tests with WSO2 Data Services Server 2.5.0 4RC22.
 
 My problems occurred when I use field type for input of types: date,
 timestamp and int and I try passed null in value.
 
 In attachment my service and mysql dump.
 
 
 
 Erros recevieds in log:
 
 === with all fields NULL
 
 Name: Products
 Location:

/home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
 Description: N/A
 Default Namespace: http://ws.wso2.org/dataservice
 Current Request Name: selectProduct
 Current Params: {id=null, updated_at=null, name=null, created_at=null,
 quantity=null}
 Nested Exception:-
 java.lang.NumberFormatException: For input string: null
   at

java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
   at java.lang.Integer.parseInt(Integer.java:449)
   at java.lang.Integer.parseInt(Integer.java:499)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setIntValue(SQLQuery.java:1329)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:832)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
   at
 org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
   at

org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
   at

org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
   at

org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
   at

org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
   at

org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)
 
 
 === with id = 1 and other all fields NULL
 
 Name: Products
 Location:

/home/lsaraiva/Applications/wso2/wso2dataservices-2.5.0/repository/deployment/server/dataservices/Products.dbs
 Description: N/A
 Default Namespace: http://ws.wso2.org/dataservice
 Current Request Name: selectProduct
 Current Params: {id=1, updated_at=null, name=null, created_at=null,
 quantity=null}
 Nested Exception:-
 java.lang.RuntimeException: In valid string to parse
   at

org.apache.axis2.databinding.utils.ConverterUtil.convertToDate(ConverterUtil.java:603)
   at org.wso2.carbon.dataservices.DBUtils.getDate(DBUtils.java:521)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setDateValue(SQLQuery.java:995)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:851)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:813)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:471)
   at

org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1411)
   at
 org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:214)
   at

org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:154)
   at

org.wso2.carbon.dataservices.dispatch.CallQueryGroup.execute(CallQueryGroup.java:108)
   at

org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:63)
   at

org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:327)
   at

org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:90)
 
 
 
 On Sat, 5 Jun 2010 09:25:03 +0530, Milinda Pathirage mili...@wso2.com
 wrote:
 http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/
 
 http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/Thanks
 Milinda
 

 -- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhostDatabase: products
-- --
-- Server version   5.1.41-3ubuntu12.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;

[Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

2010-06-04 Thread Milinda Pathirage

http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/

http://builder.wso2.org/~carbon/releases/carbon/3.0.0/4RC22/Thanks
Milinda

-- 
Milinda Pathirage
Technical Lead and Product Manager, Business Process Server - WSO2 Inc;
http://wso2.com
Blog: http://blog.mpathirage.com

Lean Enterprise Middleware
___
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

Re: [Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

[Carbon-dev] Carbon-3.0.0 Iridium - 4RC22

5 matches

Site Navigation

Mail list logo

Footer information