Announcement Announcement Module
Collapse
No announcement yet.
springws +jdbc Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • springws +jdbc

    hi everyone!
    I'm working on a webservice that tries to connect to database via jdbc.when I try to test the ws on soap ui i get this error:
    SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
    <SOAP-ENV:Header/>
    <SOAP-ENV:Body>
    <SOAP-ENV:Fault>
    <faultcode>SOAP-ENV:Server</faultcode>
    <faultstring xml:lang="en">org.apache.commons.dbcp.SQLNestedExc eption: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'dbc:oracle:thin:@crmtest:1621:CRMDEV19'</faultstring>
    </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
    dbc:oracle:thin:@crmtest:1621:CRMDEV19' : is the url of the data base!
    here is the configuration file:

    <!--
    ===================== JDBC
    =====================
    -->

    <bean id="JdbcIdentiteDAO" class="com.sample.identite.dao.impl.JdbcIdentiteDA O">
    <property name="dataSource" ref="dataSource"/>
    </bean>


    <bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="dbc:oracle:thin:@crmtest:1621:CRMDEV19"/>
    <property name="username" value="android"/>
    <property name="password" value="android"/>
    <property name="poolPreparedStatements"><value>true</value></property>
    <property name="maxActive"><value>10</value></property>
    <property name="maxIdle"><value>10</value></property>
    </bean>


    any help please??
    thank you!

  • #2
    Please use [ code][/code ] tags when posting. Check your log judging from the error you probably haven't included the oracle driver on the classpath.

    Comment


    • #3
      You have
      Code:
      dbc:oracle:thin:@crmtest:1621:CRMDEV19
      use:
      Code:
      jdbc:oracle:thin:@crmtest:1621:CRMDEV19
      regards
      Grzegorz Grzybek

      Comment

      Working...
      X