Versions Compared

Old Version 4

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

compared with

New Version 5

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Go to UPM and find SQL for Confluence
  2. Press Configure buttonLook for second section on Data Source Profiles
  3. Select the View and modify data source profiles tab.
  4. Click Add profile.
  5. Add an entry based on your specific configuration values and the examples give - column 3 specifically

...

Database InformationJDBC Driver

Profile Configuration

Application Server Resource Configuration


No Format
Type: PostgreSQL
Database name: test
Location: localhost
Port: 5432 (default)
 
Macro uses:
  dataSource=testDS



No Format
postgresql-942.2-1000.jdbc42.jar

In directory: 
    <install-dir>/lib



No Format
Add a profile named: testDS 
with profile value:
 
dbDriver=org.postgresql.Driver |
dbUrl=jdbc:postgresql://localhost:5432/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/postgresql-942.2-1000.jdbc42.jar



No Format
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="org.postgresql.Driver"
  url="jdbc:postgresql://localhost:5432/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>



No Format
Type: My SQL
Database name: test
Location: localhost
Port: 1433 (default)
 
Macro uses:
  dataSource=testDS



No Format
jtds-mysql-connector-java-5.1.2.247.jar

In directory: 
    <install-dir>/lib



No Format
Add a profile named: testDS 
with profile value:
 
dbDriver=netcom.sourceforge.jtdsmysql.jdbc.Driver |
dbUrl=jdbc:jtds:sqlserver://localhost:14333306/test |
dbUser=confluence|dbPassword=confluence |
dbJar=lib/jtds-mysql-connector-java-5.1.247.2.jar



No Format
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="net.sourceforge.jtds.jdbc.Driver"
  url="jdbc:jtds:sqlserver://localhost:1433/test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  validationQuery="Select 1"
/>



No Format
Type: MS SQL Server
Database name: test
Location: localhost
Port: 2433
 
Macro uses:
  dataSource=testDS



No Format
sqljdbc4mssql-jdbc-7.0.0.jre8.jar

In directory: 
    <install-dir>/lib



No Format
Add a profile named: testDS 
with profile value:
dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver |
dbUrl=jdbc:sqlserver://localhost:2433;database=test;integratedSecurity=false |
dbUser=confluence | dbPassword=confluence | 
dbJar=../lib/sqljdbc4mssql-jdbc-7.0.0.jre8.jar


Similarly.



No Format
Type: Oracle
Database name: test
Location: localhost
Port: 1521 (default)
 
Macro uses:
  dataSource=testDS



No Format
ojdbc5.jar or ojdbc6ojdbc6-11.2.0.3.jar

In directory: 
    <install-dir>/lib



No Format
Add a profile named: testDS 
with profile value:
 
dbDriver=oracle.jdbc.OracleDriver |
dbUrl=jdbc:oracle:thin:@206.189.142.13:491611521/XE |
dbUser=confluence|dbPassword=confluence |
dbJar=http://www..datanucleus.org/downloads/maven2/oracle/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar



No Format
<Resource name="jdbc/testDS" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.OracleDriver"
  url="jdbc:oracle:thin:@localhost:1521:test"
  username="confluence"
  password="confluence"
  maxActive="10"
  maxIdle="10"
  maxWait="10000"
  validationQuery="Select 1"
/>


...