...
Tip | ||
---|---|---|
| ||
|
...
Database examples
...
output | wiki |
---|
Wiki Markup |
---|
{csv:output=wiki} Database, Information, JDBC driver example, Resource configuration PostgreSQL, [PostgreSQL JDBC|http://jdbc.postgresql.org/], postgresql-8.2-507.jdbc3.jar, "{noformat} <Resource name=""jdbc/ConfluenceDS"" 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\\ [Oracke JDBC|http://wiki.oracle.com/page/JDBC], , "{noformat} <Resource name=""jdbc/myDS"" auth=""Container"" type=""javax.sql.DataSource"" driverClassName=""oracle.jdbc.driver.OracleDriver"" url=""jdbc:oracle:thin:@www.some_server.com:1521:some_schema"" username=""username"" password=""password"" connectionProperties=""SetBigStringTryClob=true"" maxActive=""25"" maxIdle=""5"" maxWait=""10000"" /> {noformat}" 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}" {csv} |
Other databases
Support for other databases depends on the capabilities provided by the JDBC driver. The SQL expects certain JDBC features to be available. In some cases, parameter choices can affect which capabilities are needed. User testing and community support is about the only help that is available for less popular databases/JDBC drivers. If you have had success with other databases, please add information to this page.
...