I located an example webapp to test using a datasource.

I added the following to my Tomcat\conf\context.xml file

/<Resource name=&quot;jdbc/TestDB&quot;
        auth=&quot;Container&quot;
        factory=&quot;org.apache.tomcat.jdbc.pool.DataSourceFactory&quot;
       
driverClassName=&quot;com.microsoft.sqlserver.jdbc.SQLServerDriver&quot;
        type=&quot;javax.sql.DataSource&quot;
        maxActive=&quot;50&quot;
        maxIdle=&quot;10&quot;
        maxWait=&quot;15000&quot;
        username=&quot;syncope&quot;
        password=&quot;&lt;password>"
        url="jdbc:sqlserver://localhost:1433;databaseName=TestDB;"
        removeAbandoned="true"
        removeAbandonedTimeout="30"
        logAbandoned="true" />/

The database TestDB has been created and populated. However I get the
following error:

/Unable to get connection, DataSource invalid: "java.sql.SQLException: No
suitable driver found for jdbc/TestDB"/

I need to research how to install the JDBC driver. I thought it was just as
simple as placing the .jar file that I downloaded from microsoft and placing
it in the Tomcat\lib folder.

--
Sent from: http://syncope-user.1051894.n5.nabble.com/

Reply via email to