I have an adapter (update notification) in serverONE and it works perfectly, but when i try to install it in another server and i try to enable it in the serverTWO:5555 → jbdc adapter → notification i have an error with this message (in the serverTWO:
the way i install the package is:
loggon serverONE:5555
release package
create release package
select elements of the “update notification”
create package release
copy package release created in serverONE to the path …/integrationServer/Inbound/ of serverTWO
I must to say that the serverONE and serverTWO have same configurations: (same db name and tables, connection, flow services services) for the package that i want to install, obviously the conexion with different IPadress for de data base.
Can someone guide me to find why this error?
How can I fix it?
And another thing, when i try to install the same package in a serverTHREE this error never happend, and yes, serverTHREE has exactly the same configuration than serverONE and serverTWO
Please make sure the server TWO has the exact same configuration as the ONE AND THREE…definetly something shows missing in the target db or the IS resource itself…you may also contact the target DBA as well on the ORA issue.
server ONE, TWO and THREE have the same configuration, i mean in JDBC connection, polling notification, data base name, table name, user, pass, i must say something, server one is “development”, server three “test”, server two “production”.
You may have to check more in your production env what piece is missing source IS or target DB side before you enable the notification objects and the mentioned checks from the other users.
Hi did u copy class14.jar file in in u r servers c:/softwareag/Integration server/lib/jar
u need download and copy the class14.jar file in above path an restart u r server hope its gonna work pls update me .
Are you doing service development by using Developer (deprecated since wM 8.2.x and has been removed in wM 9.x+) or Designer (recommended for wM 8.2.x resp. required for wM 9.x+)?
For the database parts you should ask your database team.
Depending on the IS-Version (and therefor the used JVM) and the Dtabase version there are several different driver jars for Oracle DBs (these can be downloaded for free from Oracle Technology Network [free registration required]):
JVM 1.5: ojdbc5.jar
JVM 1.6: ojdbc6.jar
JVM 1.7: ojdbc6.jar (for Oracle 11g and before)
ojdbc7.jar (for Oracle 12c and newer)
These jars are backwards compatible down to Oracle 9i R2 for those running on an old database.
For Oracle Database driver it is sufficient to place the jar in IntegrationServer/packages/WmJDBCAdapter/code/jars and reload the Adapter-Package and all depending packages.
The connection should specify “driverType=thin” in the “Other Properties” field.
Oracle 12c is currently not officially supported for the webMethods Suite.
I am working on this type of services for several years now and have worked with all of the mentioned combinations (and some others no longer supported by SAG and Oracle).
Therefor it is very easy for me to recap these informations from my experience.
I can’t show my original code, but i attach an example
when i create my new adapter notification with 2 tables with 1 join on t1.ORDER_ID = t2.ORDER_ID and i change the name in the “Output Field” of the expression t2.ORDER_ID by ORDER_ID_2 and i try to enable the notification i have one error:
note: this is from a virtual machine in SQL not in oracle but i have the same result in oracle
[color=red]
[/color]
But if I change the name without _2 and 2 … i can enable the notification
why i can’t?
by the way, i have another adapter notification (and all development), with the same configuration “ORDER_ID_2” and “TRANSACTION_ID2”, and guess what… it works!, i can disable and enable the adapter every time… why?
i’m working on IS 7.1, and… i don’t have access to Server TWO and THREE u.u
Did you focus more on these ORA errors and try with your DBA help? I believe its nothing to do in the IS/Developer as it complains more of the DB table perspective invalid columns etc…
Yes, i’ve validated the talbes and db’s, the problem here is that the objects: “table bufer”, “trigger table” and “secuence table”, from the adapter notification, are generated automatically by the tool and not in manual way =S.
But, if i change (alter/modify) those objects the problem now is the SQL instruction with the error, i dont know where lives this SQL instrucction of the adapter notification in the server.
(U.u)
The most curious thing here is, why one adapter works (older development) and why a new adapter don’t work?.. interesting.
I’m going keep searching of this issue, but any ideas are wellcome.
All the Adapter framework Notification metadata depends on the WmART package frame work.
“why one adapter works (older development) and why a new adapter don’t work?..”
From your above statement:
What is your older development and newer can you clarify you mean IS versions changed and the JDBC Adapter and ART fix levels different than old vs new?
I had the same issue with an adapter notification using a join between 2 tables.
The way i was able to resolve it was to rename the output field from the first table (t1) not the second one (t2) for some reason that way the adapter it does starts.
i you want to use complex expressions (subquerys) you need to define it at the begining of the column list, otherwise the result is a messy query generated by the IS
En español:
Yo tuve el mismo problema con un adapter notification usando un join entre 2 tablas.
La manera en que lo pude resolver fue cambiando el nombre al output field de la primera tabla del join (sobre la que te pide notificarte en update) es decir la t1, en lugar de sobre la segunda, es decir la t2, de esa forma el adapter si se habilita.
Si quisieras usar una expression compleja (con querys internos o algo asi) necesitarías definirlo al principio de la lista de columnas, de otra manera el resultado es un query dificil de leer generado por el IS.
