Hi Ruslan, rssh wrote: Please, is not this also a requirement?... *Configure JNDI data store in application container, where you xwiki instance is running. Thanks! Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

On Fri, 11 Apr 2008 01:05:18 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote As I remember, for this you must extract log4j.properties from lib/xwiki-core-<version>.jar and put extracted file in classes. Than add to log4j.properties additional statements. http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Logging -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

Hi Ruslan! rssh wrote: I've extracted the file, added the required line and modified xwiki.cfg accordingly. Here it is a block containing the line loading xwikisql plugin. com.xpn.xwiki.plugin.scheduler.SchedulerPlugin,\ com.xpn.xwiki.plugin.mailsender.MailSenderPlugin,\ com.xpn.xwiki.plugin.watchlist.WatchListPlugin,\ ua.gradsoft.xwikisql.SqlPlugin Then, I've restarted XWiki and here the error I got: ***** type Informe de Excepcio'n mensaje descripcio'n El servidor encontro' un error interno () que hizo que no pudiera rellenar este requerimiento. excepcio'n javax.servlet.ServletException: La ejecucio'n del Servlet lanzo' una excepcio'n com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) causa rai'z java.lang.UnsupportedClassVersionError: Bad version number in .class file java.lang.ClassLoader.defineClass1(Native Method) java.lang.ClassLoader.defineClass(ClassLoader.java:675) java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1817) org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:872) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1325) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204) java.lang.ClassLoader.loadClassInternal(ClassLoader.java:374) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:164) com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:70) com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:107) com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:853) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:785) com.xpn.xwiki.XWiki.<init>(XWiki.java:721) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:292) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:490) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:118) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) nota La traza completa de la causa de este error se encuentra en los archivos de diario de Apache Tomcat/6.0.14. ***** It I remove the entry in xwiki.cfg loading the plugin, XWiki works fine. Does this make any sense for you? Thanks. I am wondering why Loggin or log4j returns nothing when searched in http://www.xwiki.org. Does it work for you? Cheers, Ricardo -- Ricardo Rodri'guez Your EPEC Network ICT Team

rssh wrote: Even worse! Our production server runs java version "1.4.2_10", any drawback running this release? Thanks! Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Thanks, Ruslan. rssh wrote: Digging into code and building xwiki and its plugins is in my ToDo list, but I'm afraid I am a bit far from understand how to do this right now. Please, could you provide me some "simple" guidelines to build xwikisql here? Thank you so much for your help, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Simple... :-) rssh wrote: I've downloaded xwiki-plugin-sql-src-1.4.tar.gz <http://xwikisql.googlecode.com/files/xwiki-plugin-sql-src-1.4.tar.gz>, extracted it, changed build.xml by adding target="1.5" to ... ***** <target name="build" depends="retrieve-libs"> <javac srcdir="src/main/java" includes="**/*.java" deprecation="on" debug="${debug}" target="1.5"> <classpath refid="std.build.path" /> </javac> <jar basedir="src/main/java" includes="**/*.class" destfile="target/xwiki-plugin-sql-${version}.jar" index="true"> <include name="build"/> <manifest> <attribute name="Build-By" value="${user-name}"/> </manifest> </jar> </target> ***** and... ***** <target name="build-tests" depends="build,retrieve-test-libs"> <javac srcdir="src/test/java" includes="**/*.java" deprecation="on" debug="${debug}" target="1.5"> <classpath refid="test.std.build.path" /> </javac> </target> ***** Then, started ant. And build failed recording the following messages: ***** sh-3.2# ant Buildfile: build.xml download-ivy: [get] Getting: http://repo1.maven.org/maven2/org/apache/ivy/ivy/2.0.0-beta2/ivy-2.0.0-beta… [get] To: /var/root/.ivy/jars/ivy.jar [get] Not modified - so not downloaded declare-ivy: init-ivy: No ivy:settings found for the default reference 'ivy.instance'. A default instance will be used [null] :: Ivy 2.0.0-beta2 - 20080225093827 :: http://ant.apache.org/ivy/ :: [null] :: loading settings :: file = /Users/rrodriguez/Downloads/xwiki-plugin-sql-src-1.4/ivysettings.xml [null] DEPRECATED: 'checkUpToDate' is deprecated, use 'caches[@checkUpToDate]' instead (file:/Users/rrodriguez/Downloads/xwiki-plugin-sql-src-1.4/ivysettings.xml) BUILD FAILED /Users/rrodriguez/Downloads/xwiki-plugin-sql-src-1.4/build.xml:39: java.lang.NoClassDefFoundError: com/jcraft/jsch/JSchException Total time: 1 second sh-3.2# ***** Please, does this any sense for your? What I am doing wrong? Thank you so much for your help, Ricardo -- Ricardo Rodri'guez Your EPEC Network ICT Team

looks like I forgot attachment in previous letter.

Hi, rssh wrote: Thanks to you! I've downloaded and applied the patch to build.xml. Now I get a long log with a number of errors. Please, could you take a look at it? I've tried it twice. This log belongs to the second turn. So, compilation time is not affected by the time invested in the first turn fetching jars. The recorded errors are the same. Here it is... http://mire.environmentalchange.net/~webmaster/txt/xwikisql.txt Do you find any clue in this log? What am I doing wrong? Thanks. Greetings, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Thanks Ruslan, rssh wrote: As I've been able to find by googling, only java.sql.Types.DATALINK data type has been added to the JDBC 3.0 API. So, please, what exactly must I comment out? The whole import java.sql.Types line? Only case Types.DATALINK: return "DATALINK";? As I am "a bit" lost in this arena, I do prefer to ask instead of doing no-sense things! Thanks for your patience! Of course I will try it. But, please, I don't know if I am the only one running XWiki in a Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_10-b03) box, but this is our production server and it will be difficult either to update Java or to have a new box in the following few months. Does this trick work also with 1.4? Or, do this plugin work in such an installation? Thanks! Cheers, Ricardo -- Ricardo Rodri'guez Your EPEC Network ICT Team

On Sat, 12 Apr 2008 13:56:20 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote JDK1.4 docs http://java.sun.com/j2se/1.4.2/docs/api/ (see java,sql.types) JDK1.6 docs http://java.sun.com/javase/6/docs/api/ So, all typoes which exists in J2SE1.6 but not in J2SE1.4 must be commented out. I will test this. -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

On Sat, 12 Apr 2008 19:03:25 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote commented out. Something really change. let's test all steps. 1. plugin is installed. test page: $plugin = $xwiki.sql plugin is $plugin (page must print something like 'plugin is ua.gradsoft.xwikisql.SqlPluginApi$3333' ) 2. database is retrieved test page: $plugin = $xwiki.sql plugin is $plugin <br> $db = $plugin.getDatabase('myDs'); db is $db (page must print something like 'plugin is ua.gradsoft.xwikisql.SqlPluginApi$3333' db is '$db' (if it was not found) ) and in xwiki.log we will see error message. (also, check, that you have no entry xwikisql.logEnabled=false in you xwiki.cfg ) If not - something very strange, will think about new experiments. -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

On Mon, 14 Apr 2008 11:33:19 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote Yet one quick question: are you have programming rights ? (I trying reproduce situation and still can't understand it) [UTF-8?]> Ricardo Rodrцґguez -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

[Ricardo Rodriguez] Your EPEC Network ICT Team wrote: Same behavior in the main server: no message recorded in xwiki.log. Same answer to the document scripts: ***** plugin is installed $plugin = ua.gradsoft.xwikisql.SqlPluginApi@d7cb7e plugin is $plugin database is retrieved $plugin = ua.gradsoft.xwikisql.SqlPluginApi@820993 plugin is $plugin $db = $plugin.getDatabase('myDs'); db is $db ***** I am "sure" I am working with an user with programming rights because I using the same user to open/save the SendByEmail application that also requires programming rights. It is doing well and recording error messages in xwiki.log. I would like to go to JNDI configuration having this issue solved as it seems the only way of getting informative log messages so, please, let me know if I could try any other thing. Thank you so much for your help! Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

rssh wrote: Tomcat. I guess when you say Apache you mean Apache Tomcat, doesn't you? Not only your fault! I've not been critic with your code and the lacking set was obvious! Sorry. http://mire.environmentalchange.net/~webmaster/images/XwikiSqlTest02.png The message in Spanish is equivalent to the version in English you have posted upper here. Yeap, it is true! No messages in xwiki.log yet. Cool! I will be pending of this update and try it here ASAP. Thanks! Greetings, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

rssh wrote: Patch applied. Please, see what Ant says now... build: [javac] Compiling 5 source files [javac] /Users/rrodriguez/Downloads/xwiki-plugin-sql-src-1.4/src/main/java/ua/gradsoft/xwikisql/SqlDatabase.java.bak.java:13: class SqlDatabase is public, should be declared in a file named SqlDatabase.java [javac] public class SqlDatabase implements SqlErrorable [javac] ^ [javac] 1 error BUILD FAILED /Users/rrodriguez/Downloads/xwiki-plugin-sql-src-1.4/build.xml:97: Compile failed; see the compiler error output for details. Total time: 13 seconds Any error of mine? Something unexpected? Thanks! Of course I can. Here they are... http://mire.environmentalchange.net/~webmaster/txt/SqlTypes.java http://mire.environmentalchange.net/~webmaster/txt/SqlPlugin.java But I've not commented out the lines, but removed them :-( I do hope they are still useful. Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

rssh wrote: My fault: I'd renamed the old SqlDatabase.java to *.java.bak but my clever MacBook had added .java to the file and I didn't realize. And I dind't read the error message :-( Sorry. Build successful, *.jar in place, XWiki restarted and here they are the error messages in XWiki.log: 2008-04-15 01:14:13,276 [http://test01.xen.net/xwiki/bin/view/Main/Database] [http-80-1] ERROR xwikisql.SqlPlugin - exception during creation of datasource myDs javax.naming.NameNotFoundException: El nombre myDs no este asociado a este contexto Now, the text code... 1.1.1 database is retrieved #set($plugin = $xwiki.sql) plugin is $plugin #set($db = $plugin.getDatabase('myDs')) db is $db Gives... http://mire.environmentalchange.net/~webmaster/images/XwikiSqlTest03.png Well, great! this works fine, as far as I can understand. Thanks, Ruslan! Now, I can move to JNDI set up. Any other thing I could try here before moving ahead? I will try the new *.jar tomorrow in the production server (java version "1.4.2_10") and post here the results. I've been trying in a java version "1.5.0_13" so far. Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

On Tue, 15 Apr 2008 10:55:06 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote http://xepecnet.environmentalchange.net/xwiki/bin/view/ICT/IsXwikiSqlPlugin… 1. can you recheck that patch is applied to version plugin, compiled with JDK-1.4 ? 2. Are we have something in log on info level (may be one message about programming rights [?]) 3. what say: $plugin.getSqlPlugin().getConfiguration().getThrowExceptions() <br> $plugin.getSqlPlugin().getConfiguration().getLogEnabled() <br> [?] [UTF-8?]> Ricardo Rodrцґguez -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

On Tue, 15 Apr 2008 13:12:00 +0300, rssh wrote http://xepecnet.environmentalchange.net/xwiki/bin/view/ICT/IsXwikiSqlPlugin… -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua

On Tue, 15 Apr 2008 14:36:30 +0200, [Ricardo Rodriguez] Your EPEC Network ICT Team wrote box. I'll recompile it and try again. Sorry. http://mire.environmentalchange.net/~webmaster/txt/XwikiSqlPluginCompilingI… Hmm - You try compile xwikisql with jdk-1.4 (this will not work). Instead -- compile and create jar with JDK-1.5 but set target to JDK-1.4 (yes, this is possible) In such case JDK-1.5 will create jar, applicable for JDK-1.4. -- Ruslan Shevchenko GradSoft. http://www.gradsoft.ua