mysql To XML on a folder. Problems

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

mysql To XML on a folder. Problems

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> mysql To XML on a folder. Problems

Page: [1]

Message

<< Older Topic Newer Topic >>

mysql To XML on a folder. Problems - 21 July 2005

luisevalencia

Posts: 4
Score: 0
Joined: 18 July 2005
Status: offline

I generated an adapter from a table in mysql, after it a added a receive shape on biztalk on the message I choose the MultiPart message that the adapter generated, then I added the port and put specify later on binding.
Then I deployed it but I don't see the receive port on biztalk explorer. But the send ports are present.
What should I do?

Post #: 1

RE: mysql To XML on a folder. Problems - 21 July 2005

luisevalencia

Posts: 4
Score: 0
Joined: 18 July 2005
Status: offline

There was a failure executing the send pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLTransmit" Source: "Ensamblador de XML" Send Port: "C:\Proyectos\mySQLtoXMLtoSqlServer\Salida\Customer.xml" Reason: This Assembler cannot retrieve document specification by using this type: http://Customer#Customer.
Thats the error.

I already created a receive por and created the filter on the sendport to BTS.REceiveportname= the newport created.

It seems that its receiving messages but not processing due to a problem with namespaces or something

This is the schema
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" elementFormDefault="qualified" targetNamespace="http://NS" id="Customer" xmlns:xs="http://www.w3.org/2001/XMLSchema">

- <xs:element msdata:IsDataSet="true" msdata:Locale="es-CO" msdata:EnforceConstraints="False" name="Customer">

- <xs:complexType>

- <xs:choice maxOccurs="unbounded">

- <xs:element name="Customer">

- <xs:complexType>

- <xs:sequence>

<xs:element msdata:AutoIncrement="true" name="id" type="xs:int" />
- <xs:element name="FirstName">

- <xs:simpleType>

- <xs:restriction base="xs:string">

<xs:maxLength value="100" /> </xs:restriction> </xs:simpleType> </xs:element>
- <xs:element name="LastName">

- <xs:simpleType>

- <xs:restriction base="xs:string">

<xs:maxLength value="100" /> </xs:restriction> </xs:simpleType> </xs:element>
<xs:element name="Age" type="xs:int" />
<xs:element name="BirthDate" type="xs:dateTime" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element>
- <xs:annotation>

- <xs:appinfo>

<Configuration provider="MySql .NET Data Provider" connectionstring="Host=poseidon.avansoft.com;Port=3306;Database=biztalk_dllo;Persist Security Info=False;Protocol=socket;Shared Memory Name=MYSQL;Allow Batch=True;Connect Timeout=15;Logging=False;Old Syntax=False;Round Zero Datetime=False;User Id=biztalk_dllo;Password=biztalk_dllo;Pooling=True;Connection Lifetime=0;Max Pool Size=100;Min Pool Size=0;" statement="select * from Customer" record="Customer" commandType="Table" xmlns="http://theenablergroup.com/btsutils/databases/properties" />
<b:schemaInfo root_reference="Customer" schema_name="Customer" standards_version="1.0.0" document_type="Customer" version="1.0.0" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" /> </xs:appinfo> </xs:annotation> </xs:schema>

(in reply to luisevalencia)

Post #: 2

RE: mysql To XML on a folder. Problems - 21 July 2005

luisevalencia

Posts: 4
Score: 0
Joined: 18 July 2005
Status: offline

It seems that is working now, it its dropping me the same file to the same folder. Now the problem is the following. I want to retrieve only new rows. How can I make this on orchestration.

Dont forget I am a newbie. Please teach me as a kid. After this question I wons answer stupid questions :)

(in reply to luisevalencia)

Post #: 3

RE: mysql To XML on a folder. Problems - 22 July 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

You will need to create a Receive Location as described in the Oracle Wlkthrough document and then bind it to the Orchestration

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to luisevalencia)

Post #: 4

RE: mysql To XML on a folder. Problems - 22 July 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Look at the error, the namespace that the document is being checked for is:

http://Customer#Customer.

The Namespace that you specified in your Schema is

targetNamespace="http://NS"

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to luisevalencia)

Post #: 5

RE: mysql To XML on a folder. Problems - 22 July 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Yu will need to apply some logic in the DB to do this. Have a look at the Locking Feature document to get a walkthrough on this.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to luisevalencia)

Post #: 6