...
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/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 11g JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html]\\ [Oracle 12c JDBC|http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-111060download-0843211958347.html], ojdbc6.jar\\ ojdbc7.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 11g JDBC|http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html]\\ [Oracle 12c JDBC|http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-111060download-0843211958347.html], ojdbc6.jar\\ ojdbc7.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}" {csv} |
...