...
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:
...
| Code Block |
|---|
<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}\\ \\
\\
\\
\\
\\
\\
\\
\\ |
Dann Macrocode verwenden: