Frank Farkel

I know this is 5y old, but it is astounding how few online code examples actually work to go from JSON to CSV.

Although this does look like a path/jar issue in the stacktrace, it was in the source, as the OP pointed out. But they didn't explain in a way that is useful.

This is from an API, and will cause the error:

{    "endpoint": "Global Market Open & Close Status",    "markets": [ <--- note        {            "market_type": "Equity",            "region": "United States",            "primary_exchanges": "NASDAQ, NYSE, AMEX, BATS",            "local_open": "09:30",            "local_close": "16:15",            "current_status": "closed",            "notes": ""        },        {            "market_type": "Equity",            "region": "Canada",            "primary_exchanges": "Toronto, Toronto Ventures",            "local_open": "09:30",            "local_close": "16:00",            "current_status": "closed",            "notes": ""        },        { ...    ]    <--- note }
The above failed. When I simply wrapped the entire contents in a pair of brackets ("[ ...]"), though, it was all a single line, not discernable as CSV.

However, when I trimmed the characters before AND after the existing outer brackets, like this:
[        {            "market_type": "Equity",            "region": "United States",            "primary_exchanges": "NASDAQ, NYSE, AMEX, BATS",            "local_open": "09:30",            "local_close": "16:15",            "current_status": "closed",            "notes": ""        },        {            "market_type": "Equity",            "region": "Canada",            "primary_exchanges": "Toronto, Toronto Ventures",            "local_open": "09:30",            "local_close": "16:00",            "current_status": "closed",            "notes": ""        },        } ... ]
joy.

No header values, but that is a separate issue. To help those running recent java, here is a snippet that works:

import com.opencsv.CSVWriter; import org.json.simple.JSONArray; import org.json.simple.JSONObject; import org.json.simple.parser.JSONParser; import java.io.FileReader; import java.io.FileWriter; import java.io.Writer; import java.util.ArrayList; import java.util.List; public class JsonToCsvConverter {     public static void convertFile(String inJson, String outCsv) {        JSONParser parser = new JSONParser();        try (FileReader reader = new FileReader(inJson)) {            Object obj = parser.parse(reader);         //var obj = parser.parse(reader);                        JSONArray jsonArray = (JSONArray) obj;                        Writer writer = new FileWriter(outCsv);            CSVWriter csvWriter = new CSVWriter(writer);                        // Assuming each JSON object is a flat structure            for (Object o : jsonArray) {                JSONObject jsonObject = (JSONObject) o;                List<String> data = new ArrayList<>();                                for (Object key : jsonObject.keySet()) {                    data.add(String.valueOf(jsonObject.get(key)));                }                                csvWriter.writeNext(data.toArray(new String[0]));            }                        csvWriter.close();            System.out.println("JSON has been converted to CSV successfully.");        } catch (Exception e) {            e.printStackTrace();        }    } }

HTH

I was on here for a million years when it was the java ranch... starting over.. oh well!

Rexa,

You may use JAX-WS client support to do this: http://publib.boulder.ibm.com/infocenter/wasinfo/v...ae/twbs_devwbsjaxwsclient.html.

Thanks! I was always under the impression that JCA was required for outbound connectivity. Obviously, I'd love to keep everything under a single, deployed app.

I'll go check this out, and thanks again!

Can a deployed application be used as a web services consumer?

I'd like to have my application to use the container's timer to periodically go fetch data from a remote web service.

Can it be done natively, or do I need to resort to applications outside the container?

TIA!

This has had me banging my head for days [ ], and I have nowhere else to turn. Please tell me this is a simple mistake so I can get back to programming...

Quick version:

15:44:17,680 INFO [DefaultEndpointRegistry] register: jboss.ws:context=gmsTest,endpoint=HelloWorld 15:44:17,787 INFO [WSDLFilePublisher] WSDL published to: file:/usr/java/jboss-5.0.1.GA/server/default/data/wsdl/gmsTest.jar/HelloWorldService3425215985790724981.wsdl [i](listed below)[/i] 15:44:17,802 INFO [TomcatDeployment] deploy, ctxPath=/gmsTest 15:44:17,820 WARN [config] Unable to process deployment descriptor for context '/gmsTest' 16:02:35,127 ERROR [[HelloWorld]] Servlet.service() for servlet HelloWorld threw exception java.lang.NoClassDefFoundError: Could not initialize class javax.xml.soap.SOAPException at javax.xml.soap.SOAPFactory.newInstance(SOAPFactory.java:96) [...]
Long version:

Environment:

-Linux server opensuse 11.1
-All packages/bundles downloaded and installed-no apt, yast, yum, etc.
-To keep things clean:
pat@mooie:/usr/java> l total 36 drwxr-xr-x 9 pat users 4096 2009-03-26 11:08 ./ drwxr-xr-x 16 root root 4096 2009-03-09 17:18 ../ lrwxrwxrwx 1 pat users 17 2009-03-26 11:08 ant -> apache-ant-1.7.1// drwxr-xr-x 6 pat users 4096 2009-03-26 11:07 apache-ant-1.7.1/ lrwxrwxrwx 1 pat users 16 2009-03-11 21:17 default -> /usr/java/latest/ drwxrwxr-x 2 pat users 4096 2009-03-12 20:05 eclipseWorkspace/ drwxrwxr-x 3 pat users 4096 2009-03-26 13:36 extJars/ lrwxrwxrwx 1 pat users 14 2009-03-10 10:58 jboss -> jboss-5.0.1.GA/ drwxr-xr-x 8 pat users 4096 2009-03-10 10:57 jboss-5.0.1.GA/ lrwxrwxrwx 1 pat users 12 2009-03-11 21:20 jdk -> jdk1.6.0_12// drwxr-xr-x 9 pat users 4096 2009-03-11 21:17 jdk1.6.0_12/ lrwxrwxrwx 1 pat users 11 2009-03-25 17:55 jre -> jre1.6.0_13/ drwxr-xr-x 8 pat users 4096 2009-03-10 14:04 jre1.6.0_12/ drwxr-xr-x 7 pat users 4096 2009-03-25 17:56 jre1.6.0_13/ lrwxrwxrwx 1 pat users 21 2009-03-24 17:17 latest -> /usr/java/jre1.6.0_13/
All the HOMEs:

pat@mooie:/usr/java> set | grep _HOME ANT_HOME=/usr/java/ant JAVA_HOME=/usr/java/jdk JBOSS_HOME=/usr/java/jboss JDK_HOME=/usr/java/jdk JRE_HOME=/usr/java/jre SDK_HOME=/usr/java/jdk _HOMEBASHRC=true
PATH & CLASSPATH:

pat@mooie:/usr/java> set | egrep '^PATH|^CLASSPATH' CLASSPATH=.:/usr/java/jre/lib:/usr/java/jboss/client:/usr/java/jboss/common/lib:/usr/java/jboss/lib:/usr/java/jboss/lib/endorsed:/usr/java/jdk/jre/lib:/usr/java/jdk/lib:/usr/java/extJars:/usr/java/extJars/joone:/usr/java/ant/lib PATH=/usr/lib64/mpi/gcc/openmpi/bin:/home/pat/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/usr/java/ant/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/NX/bin:/opt/gnome/bin:/usr/java/jdk/bin:/usr/java/ant/bin
Any web service I try fails. Here is an example web service:

package gms.ws; import javax.jws.*; import javax.jws.soap.SOAPBinding; import javax.ejb.Stateless; @Stateless @WebService(name="HelloWorld") @SOAPBinding(style = SOAPBinding.Style.RPC) public class HelloWorld { public String echo(String sInput){ sInput += "!!!"; } public int addOne(int iInput){ return iInput + 1; } }
Here is what the eclipse project looks like:

drwxr-xr-x 6 pat users 4096 2009-03-27 20:39 ./ drwxr-xr-x 8 pat users 4096 2009-03-27 20:33 ../ drwxr-xr-x 3 pat users 4096 2009-03-26 14:21 bin/ -rw-r--r-- 1 pat users 575 2009-03-26 14:25 build.xml -rw-r--r-- 1 pat users 324 2009-03-26 14:21 .classpath -rwxrwxrwx 1 pat users 1429 2009-03-28 15:44 gmsTest.jar* drwxr-xr-x 2 pat users 4096 2009-03-26 13:55 lib/ -rw-r--r-- 1 pat users 363 2009-03-25 20:26 .project drwxr-xr-x 2 pat users 4096 2009-03-27 20:39 .settings/ drwxr-xr-x 3 pat users 4096 2009-03-25 21:55 src/

One thing I haven't messed with is the .classpath entry in the project which is:

<?xml version="1.0" encoding="UTF-8"?> <classpath> <classpathentry kind="src" path="src"/> <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/> <classpathentry kind="lib" path="lib"/> <classpathentry kind="lib" path="lib/jboss-ejb3x.jar"/> <classpathentry kind="output" path="bin"/> </classpath>

The WSDL generated from this service is:

<?xml version="1.0" encoding="UTF-8"?> <definitions name="HelloWorldService" targetNamespace="http://ws.gms/" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://ws.gms/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"> <types> </types> <message name="HelloWorld_EchoResponse"> <part name="return" type="xsd:string"> </part> </message> <message name="HelloWorld_AddOne"> <part name="arg0" type="xsd:int"> </part> </message> <message name="HelloWorld_Echo"> <part name="arg0" type="xsd:string"> </part> </message> <message name="HelloWorld_AddOneResponse"> <part name="return" type="xsd:int"> </part> </message> <portType name="HelloWorld"> <operation name="AddOne" parameterOrder="arg0"> <input message="tns:HelloWorld_AddOne"> </input> <output message="tns:HelloWorld_AddOneResponse"> </output> </operation> <operation name="Echo" parameterOrder="arg0"> <input message="tns:HelloWorld_Echo"> </input> <output message="tns:HelloWorld_EchoResponse"> </output> </operation> </portType> <binding name="HelloWorldBinding" type="tns:HelloWorld"> <soap:binding style="rpc" transport="http://schemas.xmlsoap.org/soap/http"/> <operation name="AddOne"> <soap:operation soapAction=""/> <input> <soap:body use="literal" namespace="http://ws.gms/"/> </input> <output> <soap:body use="literal" namespace="http://ws.gms/"/> </output> </operation> <operation name="Echo"> <soap:operation soapAction=""/> <input> <soap:body use="literal" namespace="http://ws.gms/"/> </input> <output> <soap:body use="literal" namespace="http://ws.gms/"/> </output> </operation> </binding> <service name="HelloWorldService"> <port name="HelloWorldPort" binding="tns:HelloWorldBinding"> <soap:address location="http://10.0.18.203:8080/gmsTest/HelloWorld"/> </port> </service> </definitions>
It all looks like it should to me, but I have yet to get a single WS working, so what do I know?!

It has been extremely confusing. Some say jboss shouldn't be run on Java 6, some say a web.xml file is needed, all tutorials say this should just work.

The VB.NET component is ridiculously simple, as it just calls http://server:8080/gmsTest/HelloWorld?wsdl and sees the wsdl file no problem, adds the proxy code, and all LOOKS just dandy.

I have spent days going in circles, trying everything I could read about, and keep running in circles. Can one of you more knowledgeable folks point me in the right direction? I'll write an article on my blog about how to do this (to help others) if you can help me get it working!

TIA (big time)!

pat


A little more detail from the jboss server log:

2009-03-28 16:02:34,768 DEBUG [org.jboss.wsf.framework.DefaultSPIProvider] (http-10.0.18.203-8080-2) provide SPI 'class org.jboss.wsf.spi.management.EndpointRegistryFactory' 2009-03-28 16:02:34,782 DEBUG [org.jboss.wsf.framework.DefaultSPIProvider] (http-10.0.18.203-8080-2) class org.jboss.wsf.spi.management.EndpointRegistryFactory Implementation: org.jboss.wsf.stack.jbws.EndpointRegistryFactoryImpl@74ff364a 2009-03-28 16:02:34,782 DEBUG [org.jboss.wsf.stack.jbws.RequestHandlerImpl] (http-10.0.18.203-8080-2) doPost: /gmsTest/HelloWorld 2009-03-28 16:02:34,782 DEBUG [org.jboss.wsf.stack.jbws.RequestHandlerImpl] (http-10.0.18.203-8080-2) handleRequest: jboss.ws:context=gmsTest,endpoint=HelloWorld 2009-03-28 16:02:34,782 DEBUG [org.jboss.ws.core.soap.MessageContextAssociation] (http-10.0.18.203-8080-2) pushMessageContext: org.jboss.ws.core.jaxws.handler.SOAPMessageContextJAXWS@1f457048 (Thread http-10.0.18.203-8080-2) 2009-03-28 16:02:34,782 DEBUG [org.jboss.wsf.stack.jbws.RequestHandlerImpl] (http-10.0.18.203-8080-2) BEGIN handleRequest: jboss.ws:context=gmsTest,endpoint=HelloWorld 2009-03-28 16:02:34,782 DEBUG [org.jboss.ws.core.soap.MessageFactoryImpl] (http-10.0.18.203-8080-2) createMessage: [contentType=text/xml; charset=utf-8] 2009-03-28 16:02:35,126 DEBUG [javax.xml.soap.SOAPFactory] (http-10.0.18.203-8080-2) Cannot load factory: org.jboss.axis.soap.SOAPFactoryImpl 2009-03-28 16:02:35,126 DEBUG [org.jboss.wsf.stack.jbws.RequestHandlerImpl] (http-10.0.18.203-8080-2) END handleRequest: jboss.ws:context=gmsTest,endpoint=HelloWorld 2009-03-28 16:02:35,126 DEBUG [org.jboss.ws.core.soap.MessageContextAssociation] (http-10.0.18.203-8080-2) popMessageContext: org.jboss.ws.core.jaxws.handler.SOAPMessageContextJAXWS@1f457048 (Thread http-10.0.18.203-8080-2) 2009-03-28 16:02:35,127 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/gmsTest].[HelloWorld]] (http-10.0.18.203-8080-2) Servlet.service() for servlet HelloWorld threw exception java.lang.NoClassDefFoundError: Could not initialize class javax.xml.soap.SOAPException at javax.xml.soap.SOAPFactory.newInstance(SOAPFactory.java:96)