Skip to Content
author's profile photo Former Member
Former Member

Inserting data through JDBC Adapter

Hi Hart Liu,

My system is on the latest patches of XI3.0 SP9. I am trying to insert some records into a database through JDBC adapter.

We have been facing with problem XSD structure in the jdbc side. We r manually created XSD structure. In the adapter engine we don’t have any action item. In u r mail

U r structure contains action attribute.

Can u plz help me out to generate the right XSD structure?

We have one more doubt, is there any automatically structure-generated option? plz let us know.......

We r waiting for u r reply....

Plz help me!!!!!!!!

Regards,

Anil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 03:13 AM

    Hi Anil,

    The structure of the data type for inserting data into DB should be

    <name of data type>

    <Statement>

    <table name>

    action(attribute)

    <access>

    <field 1>

    <field 2>

    .

    .

    .

    <field n>

    U can generate the xsd structure of the required table using xml spy and use that, instead of manually doing(which becomes very difficult in case of huge tables)

    Hope it answers ur query.

    Regards

    Sunita

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.