JSPWiki two instance using the same jspwiki.pageProvider (JDBCPageProvider - same database name )

[frano123]

Hi all,
Can anyone help me to answer this question? Sorry, I'm new in thiw area. I have 2 instance of JSPwiki. Can I use the same database(in mysql) in JDBCPageProvider for both instance? If yes, then will it be possible to create the page with the same names but different content in each wikis? How it will be work search funcionality in this case?
thank you
frano

[Florian Holeczek]

Hi Frano,

JDBCPageProvider is a third party component and as such not directly
supported by the JSPWiki team. However, maybe someone on the list
knows the exact answer.
In general, such a use case may be supported by allowing for a user
defined prefix in the table name, e.g. instance 1 would then use
tables inst1_*, instance 2 would use inst2_*. If JDBCPageProvider
supports this, it should work fine for JSPWiki. And yes, your content
would be completely separate.

Best regards
 Florian

[Terry Steichen]

I'm using the JDBCPageProvider.  When I have multiple JSPWiki instances,
I use multiple database instances (in Derby, in my case).

I don't think that JDBCPageProvider per se will provide what you're (as
I understand it) looking for.

I also used an embedded version of the Derby database.  If you chose to
use the client-server version, I suspect you could use the same database
for multiple JSPWiki instances.  However, in that configuration, it
might not be possible for each client (with its own JDBCPageProvider) to
duplicate the page names.



On Tue, 2009-06-16 at 04:59 -0700, frano123 wrote:

> Hi all,
> Can anyone help me to answer this question? Sorry, I'm new in thiw area. I
> have 2 instance of JSPwiki. Can I use the same database(in mysql) in
> JDBCPageProvider for both instance? If yes, then will it be possible to
> create the page with the same names but different content in each wikis? How
> it will be work search funcionality in this case?
> thank you
> frano