Read MS ADO XML using Java

Question

0.00/5 (No votes)

See more:

, +

I know it's like asking where the Coke machine is at the Pepsi factory but is there any way to read MS ADO XML using Java?

I've been stuck with Visual Studio 6 since 1998 because my company refused to upgrade to .NET and more recently decided they're never going to and we became a Java shop. I have a set of transmission files that I'm writing in XML format

VB

Dim rstCycle As New ADODB.Recordset
rstCycle.CursorLocation = adUseClient
rstCycle.CursorType = adOpenStatic
rstCycle.LockType = adLockOptimistic
rstCycle.Open strSql, cnnSql

If rstCycle.RecordCount > 0 Then
   rstCycle.Save strOutFile, adPersistXML
End If

and reading at the server using ADO.

Now, I have to update this functionality and the only development environment I have is Java. Is there any way to read that data or do I need to redesign the transmission files?

Thanks for any help.

P.S. Java newbie.

Posted 13-Oct-15 10:56am

keithd1965

Add a Solution

Comments

George Jonsson 13-Oct-15 22:22pm

What does the format, the schema, of your XML file look like?
And how do you get your input data?
If I understand you correctly, your task is to write data to an XML file and that is possible in Java or basically any language.

keithd1965 14-Oct-15 9:27am

The write to is handled through Microsoft tools to nonstandard XML formatting. The read from is the problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2015-10-13T22:27:00

Solution 1

Take a look at https://www.google.com/search?q=java+xml[^].

Posted 13-Oct-15 22:27pm

Richard MacCutchan

Comments

keithd1965 14-Oct-15 9:28am

Thank you but this is not standard XML but Microsoft going their own way.

Richard MacCutchan 14-Oct-15 11:00am

Well then I suspect you will need to consult the Microsoft documentation to establish how you can read it. If Java does not have a built in class to handle it you will need to write your own, or use a C/C++ library linked via JNI.