Hi Jorge, Download the driver from here [1], and get the sqljdbc4.jar and copy it to /repository/components/lib. And clear out any other mssql jars that's already there in /repository/components/[lib|dropins]. Your approach is not working maybe because, those separate jars have same Java packages inside them, which would be a problem in OSGi (you can merge those jars to a single jar also and see).
[1] http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en Cheers, Anjana. On Mon, May 23, 2011 at 10:34 PM, Jorge Infante Osorio <[email protected]>wrote: > 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.SQLServerDriver</property> > > > <property > name="org.wso2.ws.dataservice.protocol">jdbc:sqlserver://BD:1433;databaseName=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(DSOMDataSource.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.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:42) > > at > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114) > > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178) > > at > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.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(ProxyServlet.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(ApplicationFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) > > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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</property> > > > <property > name="org.wso2.ws.dataservice.protocol">jdbc:jtds:sqlserver://BD:1433/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> > > > > > > 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:1116) > > at > org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) > > at > org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) > > at > org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) > > at > org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) > > at > org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) > > at > org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) > > at > org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) > > at > org.apache.axis2.transport.http.AbstractHTTPSender.executeMethod(AbstractHTTPSender.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.writeMessageWithCommons(CommonsHTTPTransportSender.java:403) > > at > org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:228) > > at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443) > > at > org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:406) > > at > org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229) > > at > org.apache.axis2.client.OperationClient.execute(OperationClient.java:165) > > at > org.wso2.carbon.dataservices.ui.service.DataServiceAdminStub.testJDBCConnection(DataServiceAdminStub.java:839) > > at > org.wso2.carbon.dataservices.ui.DataServiceAdminClient.testJDBCConnection(DataServiceAdminClient.java:85) > > at > org.apache.jsp.ds.connection_005ftest_005fajaxprocessor_jsp._jspService(connection_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:332) > > 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(ContextPathServletAdaptor.java:36) > > at > org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) > > at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.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(ApplicationFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: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.processConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) > > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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 > > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
