Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to Reverse an XML file

user121437May 4 2010 — edited Jun 24 2010
I am using the ODI 10.1.3.5 and trying to reverse an XML Model.

I am using a basic data file, nothing special and always getting this error:

java.lang.NullPointerException
at com.sunopsis.jdbc.driver.xml.t.getPrimaryKeys(t.java:260)
at com.sunopsis.dwg.reverse.Reverse.a(Reverse.java)
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java)
at com.sunopsis.graphical.frame.b.ip.a(ip.java)
at com.sunopsis.graphical.frame.b.ip.a(ip.java)
at com.sunopsis.graphical.frame.b.hq.b(hq.java)
at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:619)

Seems like an error/bug in the XML JDBC driver

I tried using an external database for the XML driver but that fails since some of the attributes are longer than 2000, requiring a CLOB to store.

Any help would be greatly appreciated

Comments

Hemant K Chitale

Also see "Certification Information for Oracle Database on Linux x86-64 (Doc ID 1304727.1)"

Hemant K  Chitale

JohnWatson2

The database and XFS are not certified together. It should work, but if you ever have a problem you are on your own. Oracle's database support group can say "not our problem, because we don't support XFS" and Oracle's Linux support group can say "not our problem, because we don't support the database".

Does this matter? Probably not, as you are using VMware, which is not certified no matter what file system you use. The aphorism "might as well be hung for a sheep as a lamb" springs to mind.

Stefan Koehler

Hi Alex,

i guess all your questions are answered in MOS ID #1632127.1. We also discussed this on Twitter some time ago.

> Anybody using xfs for Oracle 12c databases? Any experience with support problems due to this stack?

Yes, several of my clients are running 11g and 12c on XFS (OEL 6 and 7). No experience with support, because they had no issue until yet - just better I/O performance (in contrast to EXT)

Best Regards

Stefan Koehler

Freelance Oracle performance consultant and researcher

<Moderator Edit - deleted signature spam link - pl see FAQ on where signature information is allowed>

Hemant K Chitale

Quoting Support Note 1304727.1

  • XFS - XFS is supported when using OL7 or RHEL 7. Oracle has not tested XFS with earlier versions of OL or RHEL.

Hemant K Chitale

Alex Bardos

FYI - Oracle Support's response to my SR: "As per the certification team, XFS with OL7 is supported for database."

This fact is also "kind of" expressed in the note pointed to by earlier in the thread: https://support.oracle.com/rs?type=doc&id=1304727.1

I am not sure why it has to be such a pain to get a clear, unambiguous answer to a question like this.

Thanks.

Alex Bardos

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 22 2010
Added on May 4 2010
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration, #xml
2 comments
1,355 views