Ishu Sharma

Hi,

Sorry, it is a database question.

How can I move columns from one table to another with all data?

Thanks

Finished all levels, Done..

Good time pass and very addictive

Congratulations.. excellent score..

Can you please tell us about your preparation like Books and mock exams you followed and time taken for preparation.

Cheers!
Ish

I have two tables,

columns of first table contains Table name and column name of another table.

I want to retrieve one field from first table and one field from second table (but name of second table is not known until runtime as it is stored in first table)

Can anyone suggest how this can be done in one query if possible?

Look forward to an early reply

Thanks Manohar,

It is solved now, had a weird problem. All is working fine now..

Cheers and Thanks!
Ish

thanks for replying..
I dint get your point about XML stream is empty, could you please elaborate?
I am getting the error at the last line..

DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder = factory.newDocumentBuilder();
Document document = builder.parse(new InputSource(new StringReader(this.xmlToBeParsed)));

Thanks again..

Ish

I am building an application which use XForms and Chiba, Chiba and XForms works fine, after doing all the validation and processing, I get an XML String in my servlet..
The XML string is as follows:

<data xmlns="" xmlns:chiba="http://chiba.sourceforge.net/xforms" xmlns:xf="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<order>
<item amount="1" price="2.50">article 1</item>
<item amount="1" price="5.00">article 2</item>
<item amount="1" price="9.95">article 3</item>
<item amount="1" price="15.37">article 4</item>
<item amount="1" price="12.25">article 5</item>
</order>
<total>0</total>
<formName>address</formName>
</data>


My problem is I want to extract the values from the XML String, I have written a parser but when I use it I am getting this error:

org.xml.sax.SAXParseException: Reference is not allowed in prolog.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.chiba.xml.xforms.XMLParser.convertXMLStringToDOMObject(XMLParser.java:41)
at org.chiba.xml.xforms.XMLParser.getXMLValuesInHashMap(XMLParser.java:34)
at org.chiba.adapter.servlet.ExecServlet.doPost(ExecServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)


Anyone please help me about where I am making a mistake and why this error is happening?

Cheers!
Ish

HI,

All done.. thanks

Cheers!

Hi,

Many thanks for your reply.
I have installed it and all sample programs are working fine as well. (I have gone through the documentation as well).Actually I have some questions:

1) How can I call my own handler from my XForms page instead of
HttpRequestHandler? (As of now, IT calls HttpRequestHandler class when I submit the form and I want the control to go to my own handler rather than HttpRequestHandler)

2) How and where(Which class) can I get the instance data submitted by the user?

Many thanks

Anyone help please?

Hi All,

Has anyone worked on Chiba? Would like to have some help in the implementation please.

Thanks

Yes, I have learnt my lesson mate. Apologies for my mistake..

Thanks for the replies friends, It is solved now.
I was using the import statement as
import com.java.swing.*

but Sun has changed this package to javax.swing.* long time ago but I dint know that. Havnt used swings for past four years or so..

Many thanks for your replies.. thanks again

Hi,

All my java files are in the jdk\bin directory but still I am not able to compile the Swing classes. The problem is only for swing classes.
I guess this is a classpath problem. Could anyone please let me know which jar file I need to include in classpath for swings?

Look forward to responses

Regards

Hi,

All my java files are in the jdk\bin directory but still I am not able to compile the Swing classes. The problem is only for swing classes.
I guess this is a classpath problem. Could anyone please let me know which jar file I need to include in classpath for swings?

Look forward to responses

Regards