there is already jdbc pallet , why do we need adb adapter?

Pros and cons of JDBC and ADB Adapter:

1) JDBC activity Supports Transaction (available in GROUPING)
whereas ADB doesn't support it.
2) Using JDBC activities you can invoke a procedure/function,
dynamically construct queries using these activities.
3) Schema should be equal to the table structure in ADB,
otherwise you can’t handle a table.
You need not to define a schema while using JDBC activities.
4) In ADB whenever there is a table structure/field change this
will reflected easily by clicking on
refresh button
5) In ADB you can map to the particular table. Once it is mapped
you have to point to another table by using another ADB
activity, where as in JDBC you can easily point to any database
table (select * from ). Need not to configure prior
to the execution.
6) In ADB you have supporting table so that you can easily get
the status of the message to be published or not.
7) For high load/performance use ADB Adapter.

Where we will go for ADB adapter and JDBC Activities?

ADB adapter is a technology adapter, which is is used to trigger a process at some event.And this sends message to ESB at Queue or Topic when an insert or update occur on the given table.And a message is sent to the Queue or Topic.
Whereas, JDBC palletes are simple pallete whcich are used fo JDBC Queries and and JDBC Insert statments or Stored Procedures in the database.

--------------------------

There is a huge difference between ADB adapter and JDBC palette.
JDBC palette activities are used during process design in designer in order to perform various operation related to database like basic insert , update , select queries etc.
whereas the ADB adapter a tool that can be used for event based communication between database and the ESB. If the adapter has been configured for some database event (i.e insertion of a row in some table) , then the adapter will notify ESB about this event and vice versa ..

-------------------------

There is a lot a functional advantages and disadvantages between those two.
If you have the data load some where between low to medium, then u should go for JDBC paletttes otherwise go for ADB adapter, basically it is well designed to handle medium to high data loads.
if you use ADB adapter, the data load will be on the adapter archive instance running on the admin not the process archive..
more over u cannot implement roll-back mechanism just like JDBC transaction group, whereas JDBC palettes handles this scenario much better way..

What is the difference between sqldirect and other jdbc activities?

tibco faq

1. What is the difference between sqldirect and other jdbc activities?

2. What is the difference between shared variable, jobshared variable, process variables and global variables?

3. What are the archive files in .ear?

4.  Where we will go for ADB adapter and JDBC Activities?

5.  What is the difference between Filepoller and file adapter?

6.  What is persistant, nonpersistant queue in EMS?

8.  What is static queue, dynamic queue and temporary queue?

7. What are the transactions in tibco?

8. What is the difference between parsed xml and render xml?

9. Explain some errors in while deployment the .ear?

10. Explain error handling mechanism?

12. What is the difference between RV (rendezvous) and jms?

13. How to install tibco software components (sequence to install the components)?

14. What is the role of tra?

15. What is the difference between parse data and render data?

16. What is the use of spawn option in called process?

17. What is the use of transaction?

18. Explain critical section group?

20. What is the difference between queues and topics?

21. What is the use of bridges in ems?

22. What is the difference between reliable, certified, distributed queues in RV?

23. What Abstract wsdl and concrete wsdl?

24. What is the use of ESB BUS?

25.  What is difference between publish by value, publishby reference modes in ADB adapter?

26.   What is the use of confirm activity, checkpoint and how to use?

27. What is the difference between SOAP Event Source and Service Activity?

28. What is the purpose of “Retrieve Resource” activity?

29.  What is use of HAWK and what are the components present in HAWK?

30. What is the use of Query Builder in JDBC query Activity?

31. What is the use of “Override Transaction behavior” option in JDBC Activities?

32. What are the properties that we can set to a queue or topic?

33. What are the protocols that RV and EMS use?

34. What is fault tolerance and Load Balancing in tibco EMS and where to configure?

35. What are the configuration files present in TIBCO/EMS/bin?

36. What is force deployment?

37. Where we define error schema for generate error activity?

38. What is Generate Error, Catch, and Rethrow activities?

39. What are the other tibco components that automatically comes along with tibco tra installation?

40. What are the acknowledgement modes available in tibco EMS?

41. What are file based and process based ledgers in TIBCO RVCM?

42. What is the role of domain utility?

43. What is webservice and what protocol it uses?

44. What is the difference between SOAP Over JMS/HTTP?

45.  What is the use of durable subscribers?

46. What is file based storage and database storage in TIBCO EMS and where we will configure it?

47. What is difference between GUI Mode, Console Mode and Silent mode of installation?

48. How to define security to EMS sever Or use of SSL in tibco EMS?

49. List the X-path functions that you recently used?

50. What is difference between Render XML activity and tib: renderxml X-path function?

51. What is the use of SSL and HTTPS?

52. What is flow limit and max jobs?

53. What is lock object and where it is used?

54. What is the use of pick first and critical section?

55. What protocol that RV uses and explain about UDP and TRDB protocol?

What is the default Axis in XPath ?

Child axis- What this means is that when you select "BOOK" from the current context, it selects a child node with that name, not a sibling with that name. Other axes are parent , self , sibling etc.

What are the output formats for XSLT?

• XML
• HTML
• Text

What does ' Success if no matching condition' transition mean ?

Lets say between two nodes N1 and N2, there are 3 success transitions with condition and there is no success transition without condition. If none of the conditions match then a 'Success if no matching condition' transition can be used. Also if there is a success transition and also success transitions with condition and if the condition matches then both the success transition (no condition) as well as the transition(s) with matching conditions are followed. So you can use 'Success if no matching condition' to prevent duplicate paths of execution.

What are the different types of Transactions TIBCO provides?

TIBCO BusinessWorks offers a variety of types of transactions that can be used in different situations. You can use the type of transaction that suits the needs of your integration project. When you create a transaction group, you must specify the type of transaction. TIBCO BusinessWorks supports the following types of transactions:

• JDBC
• Java Transaction API (JTA) UserTransaction
• XA Transaction

What are the TIBCO BW activities that can participate in transactions?

Not all TIBCO BusinessWorks activities can participate in a transaction. Only the following types of activities have transactional capabilities:

• JDBC activities
• JMS activities
• ActiveEnterprise Adapter activities that use JMS transports
• EJB activities
• TIBCO iProcess BusinessWorks Connector activities

What is vcrepo.dat?

TIBCO Designer creates a file named vcrepo.dat in the project root directory when you first save the project. This file is used to store properties such as display name, TIBCO Rendezvous encoding, and description. This file can be used for identification in place of the project root directory and can be used as the repository locator string (repoUrl).

What are the different modes of service invocation?

Services can be invoked in several ways.

• A one-way operation is executed once and does not wait for a response.
• A request-response operation is executed once and waits for one response. In a request-response service, communication flows in both directions. The complete interaction consists of two point-to-point messages—a request and a response. The interaction is only considered complete after the response has arrived.
• Publication (notification) means an operation sends information on an as-needed basis, potentially multiple times.
• Subscription means incoming information is processed on an as-needed basis, potentially multiple times.

What are the revision control system options available in TIBCO designer?

• File sharing
• VSS
• Perforce
• XML Canon
• ClearCase
• iPlanet
• PVCS

What is the role of TRA?

TRA stands for TIBCO Runtime Agent. The TRA has two main functions:

Supplies an agent that is running in the background on each machine.

The agent is responsible for starting and stopping processes that run on a machine according to the deployment information.

The agent monitors the machine.

That information is then visible via TIBCO Administrator.

Supplies the run-time environment, that is, all shared libraries including third-party libraries.

What is Tibco ?

Tibco makes integration server software for enterprises.

An integration server allows a company to mix packaged applications, custom software, and legacy software for use across internal and external networks.

Tibco's patented approach is called Information Bus (TIB)and

Tibco says that it has been used in financial services, telecommunications, electronic commerce, transportation, manufacturing, and energy.

Active Enterprise is Tibco's integration server package that supports both message-bus and hub-and-spoke integration server models.

The message-bus model connects the different applications to a common backbone using application adapters.

The hub-and-spoke model connects all applications to a central server.

Tibco's latest addition to Active Enterprise is Business Works, which uses Web Services technology.