[xwiki-users] XWiki SQL Plugin
Hi @all, did one of you guys get the SQL-Plugin to work with 2.4? I did everything the installation instructions said to do. Even made a sample jsp page which worked just fine with querying the database and displaying my table. But usage of the plugin in any xwiki page doesn't work. Even when using such stupid query as select '1' as 1, '2' as 2 there does not seem to be any resultset returned which i could display via velocity script. Is there any trick i don't know or is the plugin simply broken? Thx -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-SQL-Plugin-tp5530893p5530893.html Sent from the XWiki- Users mailing list archive at Nabble.com.
afra wrote:
Hi @all,
did one of you guys get the SQL-Plugin to work with 2.4? ...
Yes! I already tested XWiki SQL plugin with XWiki 2.4. It's working normal. My config - Glassfish v.3, Oracle 10. I use XWiki 2.4 and 2.3.2. 1) First, I made setup for GlassFish as described here - http://technology.amis.nl/blog/1276/configuring-a-oracle-datasource-on-glass.... Oracle jdbc driver I placed in a folder \glassfishv3\glassfish\domains\domain1\lib\ext 2) Second, I made setup for SQL plugin as described in a home page of SQL plugin - http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html 3) Third, I made changes in a web.xml. In the end of this file exists some rows with <resource-ref> and comments - "<!-- Uncomment if you wish to use a DataSource to define the Database connection". I uncomented this block and wrote here name of my defined Glassfish JDBC resource. After this setup, I can use examples from SQL plugin home page - all is working great! Only small thing - in a first example used "getDabase" - but need "getDatabase". In a full API all is correct, but at this example - not correct. -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-SQL-Plugin-tp5530893p5531725.html Sent from the XWiki- Users mailing list archive at Nabble.com.
OMG Thx The tip with the getDatabase did the trick This still failure when using a method not present killed my legit tries. I pledge for syntax highligting and checking in the wiki editor Thanks for your help. -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-SQL-Plugin-tp5530893p5533117.html Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
afra -
Colesnicov Eugen