| Author |
Message |
 Topic: ETL - Synchronization |
marco
Replies: 2
Views: 5176
|
 Forum: IBM MQ File Transfer Edition Posted: Wed Aug 11, 2010 4:34 am Subject: ETL - Synchronization |
Hi,
MQFTE is new to me
I have 2 questions about it :
1. can it be used as an ETL, together with the WMB ?
If not, does someone have experience with a good ETL
2. can it be used to kee ... |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 23, 2009 3:55 am Subject: getJDBCType4Connection - MSSQLServer |
Ive tried like this :
JDBCProviders
TEST
connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];DatabaseName=[databaseName];user=[user]; ... |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 22, 2009 5:35 am Subject: getJDBCType4Connection - MSSQLServer |
| what do you mean with inside the broker code ? |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 22, 2009 4:27 am Subject: getJDBCType4Connection - MSSQLServer |
sorry
I changed this ofcourse :
type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource' |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 22, 2009 4:02 am Subject: getJDBCType4Connection - MSSQLServer |
this is the new config :
JDBCProviders
TEST
connectionUrlFormat='jdbc:sqlserver://<ip>:1433;databaseName=TEST;User=user;Password=pwd'
connectionUrlFormatAttr1=''
... |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 21, 2009 11:48 pm Subject: getJDBCType4Connection - MSSQLServer |
This is the result : (sorry for the ugly formatting)
Timestamps are formatted in local time, 120 minutes past GMT.
Trace written by version ; formatter version 6103
2009-09-22 09:45:17. ... |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 21, 2009 6:51 am Subject: getJDBCType4Connection - MSSQLServer |
"Failed to obtain JDBC Connection" is the only thing I'm afraid.
How would I be able to get more info ? |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 21, 2009 3:31 am Subject: getJDBCType4Connection - MSSQLServer |
Hi,
sorry for the lack of information :
Broker version : v6.1
JDBCProvider config :
TEST
connectionUrlFormat='jdbc:sqlserver://<ip-address>:1433;databaseName=TEST;User ... |
| Topic: getJDBCType4Connection - MSSQLServer |
marco
Replies: 16
Views: 22258
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 17, 2009 6:50 am Subject: getJDBCType4Connection - MSSQLServer |
Hi,
I've created a JDBCProvider for my database and successfully retreived data from it using the DatabaseRetrieve Node.
Now I'm trying to do the same using a JavaCompute node, but this fails.
... |
| Topic: SQL Server Polling |
marco
Replies: 5
Views: 4279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 17, 2009 1:53 am Subject: SQL Server Polling |
Ok,
just to make sure I got this right.
1. create ODBC connection to MS SQLServer Db
2. mqsisetdbparms
3. SELECT or PASSTHRU in ESQL.
What would be the difference in doing this with JDBC ... |
| Topic: SQL Server Polling |
marco
Replies: 5
Views: 4279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 16, 2009 7:06 am Subject: SQL Server Polling |
Tx for the fast reply !
I will get around the triggering issue for sure. I'm not really trying to initiate it from a SQL Event (would be interesting if it was possible though)
what standard bro ... |
| Topic: SQL Server Polling |
marco
Replies: 5
Views: 4279
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 16, 2009 6:52 am Subject: SQL Server Polling |
Hi,
I have a request to pull data from an MS SQLServer 2005 table.
Has anybody done this before ?
I'm trying to create an Adapter config using CWYBC_JDBC.rar, but I have no luck in this approac ... |
| Topic: SAP Nodes - library problem |
marco
Replies: 0
Views: 1736
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 19, 2009 3:10 am Subject: SAP Nodes - library problem |
Hi,
I'm on a 64bit HP-Ux system, but with 32 bit execution groups.
so I downloaded version 2.1.8 of the SAP libraries and copied them to a folder mqmdata/mqsi/SAPJCo.
next I ran mqsichangepro ... |
| Topic: Failure handling on SAPInput |
marco
Replies: 4
Views: 2791
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 16, 2009 11:54 pm Subject: Failure handling on SAPInput |
Solution :
detaching the failure terminal keeps the message on SAP with a "javax.ResourceException" ... which is good enough for me. |
| Topic: Failure handling on SAPInput |
marco
Replies: 4
Views: 2791
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 16, 2009 11:50 pm Subject: Failure handling on SAPInput |
I attached both catch and failure terminals.
But it gets a parsing error because it does not find the BO def :
"Business object definition not found"
The message is gone in sm58, so for S ... |
