...
Warning | ||
---|---|---|
| ||
This page has been replaced by Configure application server based data sources and Data source configuration - problem determination. Some of the information is out of date with respect to new releases of the app. However, we have kept the page as it has comments and answers that may still be helpful. |
...
Modify <install-dir>/conf/server.xml to add one or more data source resource elements. User's Guide is an example of adding a few data sources for various local and non-local databases.
...
Csv | ||
---|---|---|
| ||
Database, Information, JDBC driver example, Resource configuration
PostgreSQL, [PostgreSQL JDBC|http://jdbc.postgresql.org/], postgresql-8.2-507.jdbc3.jar, "{noformat}
<Resource name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
username=""confluence""
password=""confluence""
maxActive=""100""
maxIdle=""10""
driverClassName=""org.postgresql.Driver""
url=""jdbc:postgresql://localhost:5432/confluence""
validationQuery=""Select 1""
/>{noformat}"
MySQL, [MySql connector|http://dev.mysql.com/downloads/connector/j/5.1.html], mysql-connector-java-3.1.14-bin.jar, "{noformat}
<Resource name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
driverClassName=""com.mysql.jdbc.Driver""
url=""jdbc:mysql://localhost/mydatabase?autoReconnect=true""
username=""username""
password=""password""
maxActive=""25""
maxIdle=""5""
maxWait=""10000""
/> {noformat}\\ See SQL-146 for info on how to configure multiple result sets."
Oracle, Thin Driver\\ [Oracle JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html], ojdbc6.jar, "{noformat}
<Resource
name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
driverClassName=""oracle.jdbc.OracleDriver""
url=""jdbc:oracle:thin:@www.some_server.com:1521:mysid""
username=""username""
password=""password""
connectionProperties=""SetBigStringTryClob=true""
maxActive=""25""
maxIdle=""5""
maxWait=""10000""
/> {noformat}"
Oracle Advanced, Thin Driver \\ [Oracle JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html], ojdbc6.jar, See [Tomcat 6.0 using Oracle Universal Connection Pool|http://www.oracle.com/technetwork/articles/oem/ucp-jdbc-tomcat-355431.html]
Microsoft SQL Server, [jtds driver|http://jtds.sourceforge.net/], jtds-1.2.2.jar, "{noformat}
<Resource
name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
driverClassName=""net.sourceforge.jtds.jdbc.Driver""
url=""jdbc:jtds:sqlserver://mysqlserver:1433/mydatabase""
username=""username""
password=""password""
maxActive=""20""
maxIdle=""10""
maxWait=""-1""
/> {noformat}"
DB2 for IBM i, [JTOpen|http://www-03.ibm.com/systems/i/software/toolbox/troubleshooting.html], jt400.jar, "{noformat}
<Resource
name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
driverClassName=""com.ibm.as400.access.AS400JDBCDriver""
url=""jdbc:as400://ibmi;prompt=false;translate binary=true; extended metadata=true""
username=""username""
password=""password""
maxActive=""20""
maxIdle=""10""
maxWait=""-1""
/>{noformat}"
Derby, [Derby|http://db.apache.org/derby/], derbyclient.jar, "{noformat}
<Resource
name=""jdbc/myDS""
auth=""Container""
type=""javax.sql.DataSource""
driverClassName=""org.apache.derby.jdbc.ClientDriver""
url=""jdbc:derby://localhost:1527/dbname""
username=""username""
password=""password""
maxActive=""20""
maxIdle=""10""
/>{noformat}"
|
...
After upgrading Confluence or your application server, this error can occur if your data source configuration is out of date. Look for something like factory="org.apache.commons.dbcp.BasicDataSourceFactory" in your server.xml. Either remove it or rename it to factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory". Reference is SQL-68.
No Format java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory
...