Biztalk 2009 Oracle Adapter two Package Procedures with same schema/package name/function name in two different databases
Hi,
I have the same Schema.Package.Procedure on two different Oracle Database PDO.PO_CE_WS.PROCCESS_MESSAGE
Let's say one is Spain database and other Italy one.
When I generate an assembly for Italy and deploy everything goes well, when I deploy spain that uses the same procedure (but in his own database), even if they are in separate applications, as schema should be unique on Management Database I run into a problem that both schema namespace+rootnode generated from Oracle Adapter has the same matching type, so Italy assembly is load.
I tried to use Prefix and Generate Unique Schema names options on Oracle WCF Adapter generator with no luck....
Is there a configuration option or workaround I can apply to solve this, (final scenario handles up to six database with same use case)
Thank you so much- MovidoBen Cline1MVP, Moderadorsegunda-feira, 30 de novembro de 2009 5:05Related to adapters (From:BizTalk Server General)
Respostas
- Hi Abdul, I'm sorry to say that doesn't work on WCF Adapter.
We finally found a solution, check it out on this other thread:
http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/55be44ea-7cb6-4562-8abe-e46d43c699b2/
Using Oracle Synonyms you can work around this.
Thank you to all for their time!
jesus- Marcado como RespostaJesus Salas terça-feira, 1 de dezembro de 2009 8:21
Todas as Respostas
- I have not worked on oracle adapter but why not have 1 schema project and refer the same in other projects?
if your model doesnt like this then change the target namespace for each country(if adapter doesnt support then you can do it manually but I guess adapter will support that)
KiranMP - Hi Kiran
Obviously I can't do 1 schema and reference it on all projects. This is not a solution for my use case,
When you talk about to change the Target Namespace what do you mean? because WCF auto generate namespaces for send/response messages and you must adhere to them...
http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/package/PACKAGE_NAME#ObjectInputMessage
http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/package/PACKAGE_NAME#ObjectResponseMessage
If someone knows how to make adapter to modify this behavior I'll be happy to listen...
Thank you anyway
jesus - Hi,
I have blogged about this problem with its solutions on my blog. You can see the blog post http://abdulrafaysbiztalk.wordpress.com/2008/12/11/creating_biztalk_oracle_adapter_metadata/
Let me know if you have any questions.
Abdul Rafay http://abdulrafaysbiztalk.wordpress.com/ Please mark this as answer if it helps Hi Abdul,
Thank you very much for your blog post, it explain so well what the situation is, I know this is the most pragmatic solution, as how I see it is a workaround.
This not means is not a valid solution, of course it is!
But under our implementation strategy could be a killer to apply this strategy.
I would like, if possible that someone from Microsoft give us a formal answer for this use case, even if the solution is to apply the workaround you describe.
If solution is a workaround I think it should be nice if Microsoft give support for this scenario under WCF Adapters, so I'll try to found a way to suggest this improvement for next Adapters service pack or release...
Thank you very much for your support...
Jesus Salas- BTW
I'm going to move this question to Adapters forums, I post in on general but I think the best place is there... - In order to give strong naming types to your schema, you can set the polling id parameter in the adapter configuration connection properties. This will change the target namespace property when generating meta data.
Abdul Rafay http://abdulrafaysbiztalk.wordpress.com/ Please mark this as answer if it helps - Hi Abdul, I'm sorry to say that doesn't work on WCF Adapter.
We finally found a solution, check it out on this other thread:
http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/55be44ea-7cb6-4562-8abe-e46d43c699b2/
Using Oracle Synonyms you can work around this.
Thank you to all for their time!
jesus- Marcado como RespostaJesus Salas terça-feira, 1 de dezembro de 2009 8:21
