| Author |
Message
|
| rameshtdp |
 Posted: Mon Jun 07, 2010 7:28 am Post subject: Connection from Message broker to MYSQL |
 |
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
By making catalog entries to remote DB2 database on message broker installed server to interact with remote DB2 database.
Can anybody tell what are the steps to connect from message broker (having DB2) and interact with MySQL dabase ?
I appreciate your help! |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Jun 07, 2010 7:57 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Use Java Compute node to connect with MySQL DB
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Mon Jun 07, 2010 12:01 pm Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
Thx. If you have code to connect MYSQL database, can you please provide that. I appreciate your help.
I did't get code anywhere. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jun 07, 2010 12:14 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Any JDBC code will work.
If you can't find JDBC code for connecting to mySQL... you're not looking very hard at all. |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Mon Jun 07, 2010 1:31 pm Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
| Thank you. I got the code for Java compute node. Here again one more question, it needs to have datasource name to be defined. If I define datasource connecting to MYSQL database from my system, how it recongnises from AIX server when I deploy the code. I think, datasource name to be defined from server where Message broker defined ? What is the way ? |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Jun 07, 2010 1:48 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you have to define the DSN in AIX server, AIX admins can help you out.
or have to go through AIX Admin manuals
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Tue Jun 08, 2010 11:53 am Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
Thank you for your inputs. To make DSN compatable to mySQL database, AIX server has to have mySQL connector/ODBC.
AIX server is already having UDB, is that ok to have mySQLConnector odbc driver along with that? My concern is that it should not affect current working environment. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jun 08, 2010 11:56 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can define a JDBC DSN.
You will not be supported using any ODBC driver other than the ones that ship with message broker, and message broker does not ship any ODBC drivers for mySQL.
Use JDBC. Use a JDBCProvider configurable service as your DSN. |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Tue Jun 08, 2010 12:17 pm Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
| ok. How to define JDBC Provider as a DSN connect to mySQL database |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jun 08, 2010 12:19 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Google Google every where...but you are not searching at all 
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Tue Jun 08, 2010 5:32 pm Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
Searching very hardly!.
To create JDBCService provider, there is a way; but it supports only if databases belongs to
IBM® DB2 Driver for JDBC and SQLJ Version 9.1 and 9.5
Microsoft SQL Server 2005 JDBC driver 1.1
Oracle 10gR2 or 11gR1 JDBC Driver
Sybase jConnect for JDBC 6.05
IBM Informix JDBC 3.00.JC3
Any suggestions for MYSQL database ? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jun 09, 2010 3:00 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Any JDBC Type 4 provider is supported.
The only examples given are for the databases you mention.
You can use the examples as a model for building your own JDBCProvider.
As a big hint in this: be *very* careful with the connectionUrlFormat. Construct it AS A PATTERN with *no* real data in it about the specific connection, just with instances of the appropriate tags - [server], [user], etc. - in the correct case. |
|
| Back to top |
|
|
| rameshtdp |
| Posted: Fri Jun 11, 2010 1:01 pm Post subject: |
|
|
Novice
Joined: 11 May 2007
Posts: 18
Location: India
|
Can you please guide me is this syntax correct or not for creatting JDBCProvider on AIX env.?
mqsireportproperties broker_name -c JDBCProviders -a -o AllReportableEntityNames
connectionURLFormat command needs to be used at runtime ? |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Fri Jun 11, 2010 1:16 pm Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jun 11, 2010 1:47 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| mqsireportproperties does not change anything, it only reports. |
|
| Back to top |
|
|
|
|
