Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
Homepage des Plugins:
[http://confluence.atlassian.com/display/CONFEXT/SQL+Plugin]
 
Das jar-File downloaden zur passenden Version und über die Administration uploaden.
 
Datasource in Datei /opt/wiki/conf/server.xml definieren:
In unmittelbarem Anschluß an den Eintrag <context ...> einfügen:
&nbsp;

{code}
<Resource
name="jdbc/confluence"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/datenbankname?autoReconnect=true"
username="login"
password="password"
maxActive="25"
maxIdle="5"
maxWait="10000"
/>
{code}\\ \\
\\

Dann Macrocode verwenden:
\\
{sql-query:dataSource=confluence|output=wiki}
select * from wuensche
{sql-query}\\ \\
\\
\\
\\