Hi all.
About $subject I download the jar msbase.jar, mssqlserver.jar and msutil.jar
and put it inside /components/extensions and in components/lib without
success after restart WSAS 3.2.1.
This is the config
<property
name="org.wso2.ws.dataservice.driver">com.microsoft.sqlserver.jdbc.SQLServer
Driver</property>
<property
name="org.wso2.ws.dataservice.protocol">jdbc:sqlserver://BD:1433;databaseNam
e=BD</property>
<property name="org.wso2.ws.dataservice.user">user</property>
<property name="org.wso2.ws.dataservice.password">pass</property>
<property name="org.wso2.ws.dataservice.minpoolsize"></property>
<property name="org.wso2.ws.dataservice.maxpoolsize"></property>
<property name="org.wso2.ws.dataservice.validation_query"></property>
Nested Exception:-
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.prefetchData(DSOMDat
aSource.java:97)
at
org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:
483)
at
org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java
:363)
at
org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:298)
at
org.wso2.carbon.dataservices.core.DBInOutMessageReceiver.invokeBusinessLogic
(DBInOutMessageReceiver.java:52)
at
org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLo
gic(AbstractInOutSyncMessageReceiver.java:42)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageRe
ceiver.java:114)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HT
TPTransportUtils.java:173)
at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:144)
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.handleRequest(
ServletRegistration.java:90)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxySer
vlet.java:111)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.
java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.xml.stream.XMLStreamException: DS Fault Message: Error in
opening DBMS connection.
Source Data Service:-
I download jtds-1.2.5.jar to use another way but without success:
<property
name="org.wso2.ws.dataservice.driver">net.sourceforge.jtds.jdbc.Driver</prop
erty>
<property
name="org.wso2.ws.dataservice.protocol">jdbc:jtds:sqlserver://BD:1433/BD</pr
operty>
<property name="org.wso2.ws.dataservice.user">user</property>
<property name="org.wso2.ws.dataservice.password">pass</property>
<property name="org.wso2.ws.dataservice.minpoolsize"></property>
<property name="org.wso2.ws.dataservice.maxpoolsize"></property>
<property name="org.wso2.ws.dataservice.validation_query"></property>
In this case I put the database engine as Generic and the Test Connection
button doesn´t work with this error in the wso2carbon.log and a blank page
after this:
[2011-05-23 13:01:56,618] INFO - Unable to sendViaPost to
url[https://10.0.2.2:9443/services/DataServiceAdmin]
{org.apache.axis2.transport.http.HTTPSender}
java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at
com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)
at
com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:789
)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java
:746)
at
com.sun.net.ssl.internal.ssl.AppInputStream.read(AppInputStream.java:75)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at
org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
at
org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
at
org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:11
16)
at
org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnect
ionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
at
org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.j
ava:1973)
at
org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.jav
a:1735)
at
org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:109
8)
at
org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethod
Director.java:398)
at
org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDir
ector.java:171)
at
org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at
org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTT
PSender.java:560)
at
org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:193)
at
org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:75)
at
org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithC
ommons(CommonsHTTPTransportSender.java:403)
at
org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTT
PTransportSender.java:228)
at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
at
org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperatio
n.java:406)
at
org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisO
peration.java:229)
at
org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
at
org.wso2.carbon.dataservices.ui.service.DataServiceAdminStub.testJDBCConnect
ion(DataServiceAdminStub.java:839)
at
org.wso2.carbon.dataservices.ui.DataServiceAdminClient.testJDBCConnection(Da
taServiceAdminClient.java:85)
at
org.apache.jsp.ds.connection_005ftest_005fajaxprocessor_jsp._jspService(conn
ection_005ftest_005fajaxprocessor_jsp.java:79)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
32)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:117)
at
org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPat
hServletAdaptor.java:36)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(
ServletRegistration.java:90)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxySer
vlet.java:111)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.
java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:685)
at java.lang.Thread.run(Thread.java:619)
Where I can find a proper solution to this case?
Thanks,
Ing. Jorge Infante Osorio.
J´Dpto Soluciones SOA.
CDAE.
UCI
_______________________________________________
Carbon-dev mailing list
[email protected]
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
