This question about Configuration: Asked

DATABASE_SQL configuration

-- JackieLester - 20 Nov 2013

I've found my version! It says it is Foswiki-1.1.7, Plugin API version 2.2

-- JackieLester - 20 Nov 2013

I am a complete newcomer to this foswiki world (I can't even work out what version I am using - that's how much of a numpty I am) so please be patient with me.

I am trying to use the DATABASE_SQL plugin to get some data out of an Oracle database and display it in my wiki page. The database is on a different server. I have attempted to configure the database plugin, assumed I shoud use "remote" and told it things like servername, database SID, username, password, but when I subsequently try and use %DATABASE_SQL% in my wiki page, nothing happens - it just sits there with its % signs as a bit of text instead of weaving the magic.

At least two things are confusing me:

1) It never asks me for a port number for the database listener, so how will it try and connect to my database?

2) The DATABASE_SQL uses a description in its syntax and I can't work out what value I should be using.

All top tips gratefully received.

QuestionForm edit

Subject Configuration
Extension DatabasePlugin
Status Asked
Related Topics
Topic revision: r2 - 20 Nov 2013, JackieLester - This page was cached on 09 Jan 2018 - 15:38.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License