Problem with using Data sources in ESB 3.0.0.

st.casper.live.com's picture
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} Problem with using Data sources in ESB 3.0.0. Hi, 1. I created new “Data Source” (oracle) from “Management Console” menu -> “Configure Data Sources” 2. This connection works. (I used ’Validation Query’ to test it) 3. I tried to re-use this connection but without success. I created a simple Sequence. I chose “dblookup” from “advanced”  -> “dblookup” menu. 4. I set “Connection Information” - “Data Source”, “Datasource Type” – “Carbon Datasource” “Data Source Name” -> “Load Data Sources” link and chose my connection from combo box. Add some SQL statement… 5. Try to save sequence got error   [2010-07-27 17:50:29,820] ERROR -  Unable to read configuration value for : {htt ://ws.apache.org/ns/synapse}url {org.apache.synapse.config.xml.DBReportMediator Factory} [2010-07-27 17:50:29,820] ERROR -  Error adding sequence : Unable to read config uration value for : {http://ws.apache.org/ns/synapse}url {org.wso2.carbon.sequen ces.services.SequenceAdmin} org.apache.synapse.SynapseException: Unable to read configuration value for : {h ttp://ws.apache.org/ns/synapse}url         at org.apache.synapse.config.xml.AbstractMediatorFactory.handleException (AbstractMediatorFactory.java:169)         at org.apache.synapse.config.xml.AbstractDBMediatorFactory.getValue(Abst ractDBMediatorFactory.java:338)         at org.apache.synapse.config.xml.AbstractDBMediatorFactory.readLookupCon fig(AbstractDBMediatorFactory.java:138)         at org.apache.synapse.config.xml.AbstractDBMediatorFactory.buildDataSour ce(AbstractDBMediatorFactory.java:124)         at org.apache.synapse.config.xml.DBReportMediatorFactory.createMediator( DBReportMediatorFactory.java:76)         at org.apache.synapse.config.xml.MediatorFactoryFinder.getMediator(Media torFactoryFinder.java:180)         at org.apache.synapse.config.xml.AbstractListMediatorFactory.addChildren (AbstractListMediatorFactory.java:39)         at org.apache.synapse.config.xml.SequenceMediatorFactory.createMediator( SequenceMediatorFactory.java:79)         at org.apache.synapse.config.xml.MediatorFactoryFinder.getMediator(Media torFactoryFinder.java:180)         at org.apache.synapse.config.xml.SynapseXMLConfigurationFactory.defineSe quence(SynapseXMLConfigurationFactory.java:152)         at org.wso2.carbon.sequences.services.SequenceAdmin.addSequence(Sequence Admin.java:247)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)         at java.lang.reflect.Method.invoke(Method.java:597)         at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.jav a:205)         at org.apache.axis2.rpc.receivers.RPCInOnlyMessageReceiver.invokeBusines sLogic(RPCInOnlyMessageReceiver.java:63)         at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMe ssageReceiver.java:114)         at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)         at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReq uest(HTTPTransportUtils.java:179)         at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:1 44)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)         at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR equest(ServletRegistration.java:90)         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P roxyServlet.java:111)         at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS ervlet.java:67)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)       This is source code of my sequence <sequence xmlns="http://ws.apache.org/ns/synapse" name="testL">    <dblookup>       <connection>          <pool>             <dsName>x64DBTest</dsName>          </pool>       </connection>       <statement>          <sql>             <![CDATA[select 1 from dual]]></sql>          </statement>       </dblookup>    </sequence>   Downloaded from registry connection <properties version="1.0"> <comment /> <entry key="synapse.datasources.x64DB.numTestsPerEvictionRun">3</entry> <entry key="synapse.datasources.x64DB.defaultReadOnly">false</entry> <entry key="synapse.datasources.x64DB.registry">memory</entry> <entry key="synapse.datasources.x64DB.removeAbandonedTimeout">0</entry> <entry key="synapse.datasources.x64DB.dsName">x64DBTest</entry> <entry key="synapse.datasources.x64DB.accessToUnderlyingConnectionAllowed">false</entry> <entry key="synapse.datasources.x64DB.defaultAutoCommit">true</entry> <entry key="synapse.datasources.x64DB.driverClassName">oracle.jdbc.driver.OracleDriver</entry> <entry key="synapse.datasources.x64DB.minEvictableIdleTimeMillis">1800000</entry> <entry key="synapse.datasources.x64DB.logAbandoned">true</entry> <entry key="synapse.datasources.x64DB.validationQuery">select 1 from dual</entry> <entry key="synapse.datasources.x64DB.initialSize">0</entry> <entry key="synapse.datasources.x64DB.type">BasicDataSource</entry> <entry key="synapse.datasources.x64DB.maxOpenPreparedStatements">-1</entry> <entry key="synapse.datasources.x64DB.maxIdle">8</entry> <entry key="synapse.datasources.x64DB.defaultTransactionIsolation">-1</entry> <entry key="synapse.datasources.x64DB.maxWait">-1</entry> <entry key="synapse.datasources.x64DB.password">ESB</entry> <entry key="synapse.datasources.x64DB.testOnBorrow">true</entry> <entry key="synapse.datasources.x64DB.testOnReturn">false</entry> <entry key="synapse.datasources.x64DB.maxActive">8</entry> <entry key="synapse.datasources.x64DB.timeBetweenEvictionRunsMillis">-1</entry> <entry key="synapse.datasources.x64DB.poolPreparedStatements">true</entry> <entry key="synapse.datasources.x64DB.url">jdbc:oracle:thin:@x64-2:1521:test</entry> <entry key="synapse.datasources.x64DB.testWhileIdle">false</entry> <entry key="synapse.datasources.x64DB.username">ESB</entry> <entry key="synapse.datasources.x64DB.removeAbandoned">false</entry> <entry key="synapse.datasources.x64DB.minIdle">0</entry> </properties>     In WSO2 2.1.3 all works fine.   Any suggestions?
indika's picture

Hi Due to an issue in the

Hi Due to an issue in the DBReportMediatorFactory.java, the use of Carbon DataSource inside the db mediators had broken in the 3.0.0 release. However, if you give the complete information (i.e dsName, url,user,password)as per Sample 363 , it should work. As per the code, this issues should be fixed in the synapse svn trunk [1]. You may incorporate the changes done to the truck into the 3.0.0 release branch and take a new binary of the synapse core. Thanks Indika [1] https://svn.apache.org/repos/asf/synapse/trunk/
st.casper.live.com's picture

ok, thanks

ok, thanks
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)