I located an example webapp to test using a datasource.
I added the following to my Tomcat\conf\context.xml file
/<Resource name="jdbc/TestDB"
auth="Container"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="10"
maxWait="15000"
username="syncope"
password="<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/