| Author |
Message
|
| SandiSan |
 Posted: Tue Mar 11, 2008 11:32 am Post subject: WBI JDBC Adapter and WBIMB Configuration |
 |
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
Hi,
I am trying to configure WBI JDBC Adapter v2.6 with Websphere Business Integration Message Broker V 6.
I Have done the following configuration
1. Created the BO using ODA.
2. Configured the connector.
3. Created necessary Queues ,event table and trigger.
Now when i insert a data in my table (EMP) nothing is happening.I was assuming that a message will sit in the one of the queues.
Pl suggest |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Mar 11, 2008 11:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you deploy the BOs to the adapter?
Did you configure the adapter to poll your table?
Did you start the adapter?
Did the adapter start successfully?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SandiSan |
| Posted: Tue Mar 11, 2008 12:25 pm Post subject: |
|
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
- I created the BO and kept the .xsd file in the following path C:\IBM\WebSphereAdapters\repository.
- I am able to start the Connector.
I am pasting the Standard Properties And Connector Specific Properties
Standard Properties
AdminInQueue JDBCCONNECTOR/ADMININQUEUE
AdminOutQueue JDBCCONNECTOR/ADMINOUTQUEUE
AgentTraceLevel 0
ApplicationName JDBCConnector
BiDi.Transformation false
BrokerType WMQI
CharacterEncoding ascii7
CommonEventInfrastructure false
ContainerManagedEvents
DeliveryQueue JDBCCONNECTOR/DELIVERYQUEUE
DeliveryTransport JMS
DuplicateEventElimination false
FaultQueue JDBCCONNECTOR/FAULTQUEUE
jms.FactoryClassName CxCommon.Messaging.jms.IBMMQSeriesFactory
jms.MessageBrokerName WBRK6_DEFAULT_QUEUE_MANAGER
jms.NumConcurrentRequests 10
jms.Password ********
jms.UserName administrator
Locale en_US
MessageFileName JDBCConnector.txt
PollEndTime HH:MM
PollFrequency 10000
PollStartTime HH:MM
RepositoryDirectory C:\IBM\WebSphereAdapters\repository
RequestQueue JDBCCONNECTOR/REQUESTQUEUE
ResponseQueue JDBCCONNECTOR/RESPONSEQUEUE
RestartRetryCount 1
RestartRetryInterval 1
ResultsSetEnabled false
RFH2MessageDomain mrm
SynchronousRequestQueue JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE
SynchronousRequestTimeout 0
SynchronousResponseQueue JDBCCONNECTOR/SYNCHRONOUSRESPONSEQUEUE
TivoliMonitorTransactionPerformance false
WireFormat CwXML
XMLNameSpaceFormat short
Connector Specific Properties
ApplicationPassword passw0rd
ArchiveProcessed True
ArchiveTableName xworlds_archive_events
AutoCommit False
CheckForEventTableInInit True
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID NONE
DatabaseURL jdbc:db2://localhost:50000/DVCL0L00
DateFormat MM/dd/yyyy HH:mm:ss
DriverConnectionProperties
MaximumDatabaseConnections 2
PingQuery
PollQuantity 1
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession
RDBMSVendor DB2
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName
UniqueIDTableName xworlds_uid
UseDefaults False
UseDefaultsForCreatingChildBOs False
UseDefaultsWhenPolling True
UseDefaultsForRetrieve False
DriverSupportForLong True
EventKeyDel ;
EventOrderBy
EventQueryType Fixed
EventTableName xworlds_events
JDBCDriverClass com.ibm.db2.jcc.DB2Driver
ApplicationUserName administrator |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Mar 11, 2008 1:12 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you adding rows to the xworlds_events table?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SandiSan |
| Posted: Tue Mar 11, 2008 1:46 pm Post subject: |
|
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
| Yes i am adding row to event table. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Mar 12, 2008 1:05 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
did you export the BO to WBIMB, (did you create the corresponding Message set at MB side)
if so, Adapter is not polling the data?
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Mar 12, 2008 3:07 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you install the adapter in standalone mode? or does it think that it needs ICS?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SandiSan |
| Posted: Wed Mar 12, 2008 12:06 pm Post subject: |
|
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
| Can you please clarify what you mean by standalone mode. While installing the JDBC Adapter i asked about ICS Broker name i didn't fill anything there and just pressed next button. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Mar 12, 2008 12:09 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should have chosen to install it with WebSphere MQ Broker as the Broker, NOT ICS.
You need to reinstall.
EDIT: Hrm. I might have misread what you said. 
It should have asked you if you were using WebSphere Message Broker as your Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SandiSan |
| Posted: Wed Mar 12, 2008 12:29 pm Post subject: |
|
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
| While configuring the new Connector it ask to choose Integration Broker type there i selected 'Websphere Message Broker'. |
|
| Back to top |
|
|
|
|
