Problem with using Data sources in ESB 3.0.0.
Submitted by st.casper.live.com on July 27, 2010 - 07:12
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?
Bookmark/Search this post with:
- Login or register to post comments
- 108 reads
- Printer-friendly version
- Send to friend
- PDF version
Post to twitter
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/
ok, thanks
ok, thanks