Hi,
I have to deal some external data in my XE 1.3.2. I am using Mysql 5.0
and Jetty 5.1.5. I followed this
http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html and write the
code
##receive database
#set($mydb=$xwiki.sql.getDatabase("test"))
#set($result=$mydb.executeUpdate("update student set Name = ? where RNo =
?", ["Happy", 28]))
When I saved this, nothing on the page but in the start console it shows:-
2008-05-21 12:53:54,781 [http://localhost:8181/xwiki/bin/view/main/amma]
[P1-18]
ERROR xwikisql.SqlPlugin - exception during creation of
datasource
test
javax.naming.NoInitialContextException: Need to specify class name in
environmen
t or system property, or as an applet parameter, or in an application
resource f
ile: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.lookup(Unknown Source)
at ua.gradsoft.xwikisql.SqlPlugin.createDataSource(SqlPlugin.java:95)
at ua.gradsoft.xwikisql.SqlPlugin.createDatabase(SqlPlugin.java:84)
at
ua.gradsoft.xwikisql.SqlPluginApi.getDatabase(SqlPluginApi.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.in
voke(UberspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.j
ava:245)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTRefer
ence.java:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReferen
ce.java:419)
at
org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpres
sion.java:73)
at
org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSet
Directive.java:125)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.
java:318)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:241)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:155)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRender
er.java:95)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXW
ikiRenderingEngine.java:252)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXW
ikiRenderingEngine.java:176)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXW
ikiRenderingEngine.java:145)
at
com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(Defau
ltXWikiRenderingEngine.java:134)
at
com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java
:418)
at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:371)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.in
voke(UberspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.j
ava:245)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTRefer
ence.java:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTRefere
nce.java:294)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.
java:318)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:241)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:155)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1429)
at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:598)
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.in
voke(UberspectImpl.java:295)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.j
ava:245)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTRefer
ence.java:203)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTRefere
nce.java:294)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.
java:318)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(Velocim
acroProxy.java:194)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirect
ive.java:170)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java
:74)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfSt
atement.java:88)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java
:74)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.
java:318)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfSt
atement.java:107)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.
java:318)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:241)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRend
erer.java:155)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1429)
at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:108)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:208)
at
org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:119
6)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428
)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
WebApplicationHandler.java:830)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnc
odingFilter.java:117)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
WebApplicationHandler.java:821)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:471)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
68)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Where is my fault?
Regards,
Project trainees.
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
