login button

Project : WSO2 Data Services

namespace

Forums :

My wsdl file is generated with wso2 default targetNamespace:
< wsdl:definitions targetNamespace="http://ws.wso2.org/dataservice" >
How can i modify to my own targetNamespace???

Thanks in advance.

Do I need one datasource for every service?

Forums :

Hi all,

I'm testing WSO2 Data Services for the first time.

When I'm creating a new service, the wizard ask me for the datasource.

It ask me to create a new datasource for every dataservice... It don't offer me the possibility to use a previously created datasource already in use for another service.

So, the number of minimal pool is grooving very fast and I think it's not possible to use WSO2 Data Services in production, cause that in the real life I haven't unlimited database pool to use!

JDBC driver SAS - Transactions

Forums :

Hello,

I'm trying to create a dataservice containing a query for a SAS9 database.

I've placed the jdbc driver jars in: wso2wsas-2.3\libs\

JARS:
connect-1.0.jar
netutil-1.0.jar

Validation of connection via the wizard is successfull.

My dbs file:

Error when trying to fetch the wsdl

Forums :

Hi,

When I try to get (via the link in the admin console) a wsdl for a dataservice, I get the following error:

javax.xml.stream.FactoryConfigurationError: Provider com.bea.xml.stream.MXParserFactory not found
javax.xml.stream.FactoryFinder.newInstance(FactoryFinder.java:72)
javax.xml.stream.FactoryFinder.find(FactoryFinder.java:176)
javax.xml.stream.FactoryFinder.find(FactoryFinder.java:92)
javax.xml.stream.XMLInputFactory.newInstance(XMLInputFactory.java:136)
org.wso2.carbon.core.transports.util.RequestProcessorUtil.writeDocument(RequestProcessorUtil.java:55)

Where to put the jdbc jar files for my driver

Forums :

Hi,

I've tried connecting to a DB2 database and to do so I've put my db2 jdbc jar files. I've tried putting them in /lib and in /webapps/ROOT/WEB-INF/lib but I keep getting this error when I start the server:
Error locating class com.ibm.db2.jcc.DB2Driver {org.wso2.dataservices.DBCPConnectionManager}
java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)

Support for Transaction Isolation in Data Service

Forums :

Hi,

We are using Data services for the last one year now. 90% of the time we are using the data service to read data from database. We have developed stored procedures to update database. In the future we will like to use Data Service for all our DB operations (CRUD) and this means we might need to implement some transaction isolation. I am not sure if Data Services in its current form support Transaction Isolation...

Anand

Pool error Timeout

Forums :

I have got fallowing error with running large dataset with postgres , where can I increase the timeout :-

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at org.wso2.dataservices.DBUtils.createConnection(DBUtils.java:1563)
at org.wso2.dataservices.DBUtils.checkDBConnectionStatus(DBUtils.java:291)
at org.wso2.dataservices.DBUtils.getStoredProcedureResult(DBUtils.java:330)

Is it possible to send a blank field to Stored Procedure using data services

Forums :

Is there a way to configure data services to pass a blank field to my stored procedure? I get an exception whenever I have a field with no value. Currently I am sending the string "null" and I have to change the table to accept null values. Is there a better way to do this?

Syndicate content