| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| JDBC with MYSQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| kotagiriaashish |
 Posted: Sat Dec 03, 2011 10:03 am Post subject: JDBC with MYSQL |
 |
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
I have configured the MYsql Details as shown below
| Code: |
>mqsicreateconfigurableservice MB7BROKER -c JDBCProviders -o MYSQL
>mqsisetdbparms MB7BROKER -n jdbc::mySecurityIdentity -u root -p miracle
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n securityIdentity -v mySecurityIdentity
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n connectionUrlFormat -v "jdbc:mysql://localhost:3306/test?user=root&password=miracle&database=test;"
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n databaseName -v test
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n jarsURL -v C:\MYSQL
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n portNumber -v 3306
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n type4DriverClassName -v com.mysql.jdbc.Driver
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n serverName -v localhost
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n databaseType -v mysql
>mqsichangeproperties MB7BROKER -c JDBCProviders -o MYSQL -n databaseVersion -v 5.5
|
and when i look at the properties they look fine
| Code: |
mqsireportproperties MB7BROKER -o MYSQL -c JDBCProviders -r
type4DriverClassName
JDBCProviders
MYSQL
connectionUrlFormat='jdbc:mysql://localhost:3306/test?user=root&password=miracle&database=test;'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='test'
databaseType='mysql'
databaseVersion='5.5'
description='default_Description'
environmentParms='default_none'
jarsURL='C:\MYSQL'
portNumber='3306'
securityIdentity='mySecurityIdentity'
serverName='localhost'
type4DatasourceClassName='default_Type_Four_Datasource_Class_Name'
type4DriverClassName='com.mysql.jdbc.Driver'
|
but i endup in a error while trying to connect to DB
| Code: |
| Connection con = this.getJDBCType4Connection("MYSQL",JDBC_TransactionType.MB_TRANSACTION_AUTO); |
the error is
| Code: |
Text:CHARACTER:Failed to obtain JDBC Connection
Insert
Type:INTEGER:5
Text:CHARACTER:Java Compute
Insert
Type:INTEGER:5
Text:CHARACTER:MYSQL
Insert
Type:INTEGER:5
Text:CHARACTER:java.lang.reflect.InvocationTargetException
Insert
Type:INTEGER:5
Text:CHARACTER:No Details
|
i wonder what the NO DETAILS means 
Please help!! |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Sat Dec 03, 2011 6:04 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You have completely failed to configure the DSN correctly.
You have made the very typical mistake of misunderstanding the name of "ConnectionURLFormat". it's a Pattern, not a Format.
You have manually updated the ConnectionURLFormat to replace the text that Broker is expecting to replace.
That is, for example, you have replaced the exact text '[user]' with the actual user name.
DO NOT DO THAT.
Delete your DSN and try again, making sure to leave all of the '[string]' strings in place as is including the brackets. If there is not a sample ConnectionURLFormat for mySQL, then you need to very carefully construct one USING THE BRACKTED TEXT. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Dec 03, 2011 6:55 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
In other words: If you have the connection URL in the connectionURLFormat field, you have it all wrong. The connectionURLFormat field supplies a way to build the connectionURL with specific fields intended for substitution by the broker runtime based on the configurable service parameters.
So your connectionURLFormat should probably look something like this:
| Code: |
| connectionUrlFormat='jdbc:[databaseType]://[serverName]:[portNumber]/[databaseName]?user=[user]&password=[password]&database=[databaseName];' |
Read up and have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Sat Dec 03, 2011 7:22 pm Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| Thanks guys shall try and update |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Sun Dec 04, 2011 5:10 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
First of all thanks fjb_saper & mqjeff for pointing out the blunder.. 
i have tried but with no success with the following urls
as you said the broker itself fills in the values at runtime so i attached the user name and password in the extra attributes space as shown
| Code: |
MYSQL
connectionUrlFormat='jdbc:[databaseType]://[serverName]:[portNumber]/[databaseName]'
connectionUrlFormatAttr1='root'
connectionUrlFormatAttr2='miracle'
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='test'
databaseType='mysql'
databaseVersion='5.5'
description='default_Description'
environmentParms='default_none'
jarsURL='C:\MYSQL'
portNumber='3306'
securityIdentity='mySecurityIdentity'
serverName='localhost'
type4DatasourceClassName='default_Type_Four_Datasource_Class_Name'
type4DriverClassName='com.mysql.jdbc.Driver'
|
| Code: |
jdbc:[databaseType]://[serverName]:[portNumber]/[databaseName][?user]=[connectionUrlFormatAttr1][?password]=[connectionUrlFormatAttr2]
|
| Code: |
jdbc:[databaseType]://[serverName]:[portNumber]/[databaseName]
|
but i end up with the same error... NO DETAILS!! should i be doing something else other than running commands against the Broker Runtime or am i Missing something?? I just dont get ti?!!? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Dec 04, 2011 4:00 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you tried with the connectionURLFormat exactly as I put it? cut and paste?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Sun Dec 04, 2011 7:24 pm Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| Ya. .... exact as you stated in your previous reply but same errror ...more over should I be setting dbparams |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Dec 04, 2011 9:21 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| kotagiriaashish wrote: |
| Ya. .... exact as you stated in your previous reply but same errror ...more over should I be setting dbparams |
PMR time? You might want to reference this thread...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Sun Dec 04, 2011 9:35 pm Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Mon Dec 05, 2011 10:31 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
just out of curiosity i have configured my neighbors DB2 against my broker runtime...
let me make sure that the three only things i am doing are
1: configured this [nothing less nothing more ]
| Code: |
C:\Program Files\IBM\MQSI\6.1>mqsireportproperties WBRK61_DEFAULT_BROKER -c JDBCProviders -o DB2 -r
JDBCProviders
DB2
connectionUrlFormat='jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='test'
databaseType='DB2 Universal Database'
databaseVersion='9.1'
description='default_Description'
environmentParms='default_none'
jarsURL='C:\Program Files\IBM\SQLLIB\java'
portNumber='50000'
securityIdentity='DB2SEC'
serverName='172.17.3.113'
type4DatasourceClassName='com.ibm.db2.jcc.DB2XADataSource'
type4DriverClassName='com.ibm.db2.jcc.DB2Driver'
BIP8071I: Successful command completion.
C:\Program Files\IBM\MQSI\6.1>
|
2: Creates a security profile with user name and password
| Code: |
mqsisetdbparms WBRK61_DEFAULT_BROKER -n jdbc::DB2SEC -u miracle -p miracle
|
3: ran the java code..
| Code: |
Connection con = getJDBCType4Connection("DB2",JDBC_TransactionType.MB_TRANSACTION_AUTO);
|
4: and got this annoying exception
| Code: |
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:6233
Text:CHARACTER:Failed to obtain JDBC Connection
Insert
Type:INTEGER:5
Text:CHARACTER:JavaCompute
Insert
Type:INTEGER:5
Text:CHARACTER:DB2
Insert
Type:INTEGER:5
Text:CHARACTER:java.lang.reflect.InvocationTargetException
Insert
Type:INTEGER:5
Text:CHARACTER:No Details
|
seriously??!!!??!!!! |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Dec 05, 2011 10:33 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Take a startup trace.
You are, for example, restarting the broker after each time you adjust the configurable service, right? |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Mon Dec 05, 2011 10:39 am Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
| mqjeff wrote: |
Take a startup trace.
You are, for example, restarting the broker after each time you adjust the configurable service, right? |
yes...but let me restart the box just to be sure... |
|
| Back to top |
|
|
| kotagiriaashish |
| Posted: Mon Dec 05, 2011 12:40 pm Post subject: |
|
|
Disciple
Joined: 06 Aug 2011
Posts: 165
|
THe log is insanely large 27mb!! so i put only some of it... which has the mysql part.
| kotagiriaashish wrote: |
| mqjeff wrote: |
Take a startup trace.
You are, for example, restarting the broker after each time you adjust the configurable service, right? |
yes...but let me restart the box just to be sure... |
| Quote: |
default trace
2011-12-05 12:28:40.328880 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Dynamic Folder Resource Map size= ' , 1
2011-12-05 12:28:40.328914 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Resource Name= ' , 'MYSQL', ' Prop map size = ', 17
2011-12-05 12:28:40.328945 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormat', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.328987 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormat'
2011-12-05 12:28:40.329113 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.329151 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormat', ' Value=', 'jdbc:mysql://[serverName]:[portNumber]/[databaseName]'
2011-12-05 12:28:40.329185 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormatAttr1', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.329219 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormatAttr1'
2011-12-05 12:28:40.329319 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.329353 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormatAttr1', ' Value=', 'root'
2011-12-05 12:28:40.329387 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormatAttr2', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.329421 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormatAttr2'
2011-12-05 12:28:40.329521 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.329570 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormatAttr2', ' Value=', 'miracle'
2011-12-05 12:28:40.329605 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormatAttr3', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.329639 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormatAttr3'
2011-12-05 12:28:40.329734 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.329769 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormatAttr3', ' Value=', ''
2011-12-05 12:28:40.329811 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormatAttr4', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.329841 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormatAttr4'
2011-12-05 12:28:40.329936 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.329971 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormatAttr4', ' Value=', ''
2011-12-05 12:28:40.330005 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'connectionUrlFormatAttr5', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.330039 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'connectionUrlFormatAttr5'
2011-12-05 12:28:40.330131 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.330169 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormatAttr5', ' Value=', ''
2011-12-05 12:28:40.330200 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'databaseName', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.330234 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'databaseName'
2011-12-05 12:28:40.330333 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.330368 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'databaseName', ' Value=', '172.17.3.113'
2011-12-05 12:28:40.330402 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'databaseType', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.330436 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'databaseType'
2011-12-05 12:28:40.330558 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.330596 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'databaseType', ' Value=', 'mysql'
2011-12-05 12:28:40.330635 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'databaseVersion', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.330669 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'databaseVersion'
2011-12-05 12:28:40.330764 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.330799 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'databaseVersion', ' Value=', '5.5'
2011-12-05 12:28:40.330833 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'description', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.330867 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'description'
2011-12-05 12:28:40.330963 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.330997 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'description', ' Value=', 'default_Description'
2011-12-05 12:28:40.331031 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'environmentParms', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.331066 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'environmentParms'
2011-12-05 12:28:40.331161 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.331195 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'environmentParms', ' Value=', 'default_none'
2011-12-05 12:28:40.331230 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'jarsURL', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.331264 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'jarsURL'
2011-12-05 12:28:40.331356 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.331390 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'jarsURL', ' Value=', 'C:\MYSQL'
2011-12-05 12:28:40.331432 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'portNumber', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.331466 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'portNumber'
2011-12-05 12:28:40.331573 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.331607 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'portNumber', ' Value=', '3306'
2011-12-05 12:28:40.331642 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'securityIdentity', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.331676 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'securityIdentity'
2011-12-05 12:28:40.331771 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.331806 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'securityIdentity', ' Value=', 'default_User@default_Server'
2011-12-05 12:28:40.331840 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'serverName', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.331874 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'serverName'
2011-12-05 12:28:40.331966 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.332004 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'serverName', ' Value=', 'localhost'
2011-12-05 12:28:40.332038 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'type4DatasourceClassName', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.332069 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'type4DatasourceClassName'
2011-12-05 12:28:40.332164 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.332199 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'type4DatasourceClassName', ' Value=', 'default_Type_Four_Datasource_Class_Name'
2011-12-05 12:28:40.332241 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Retrieving the value of property ' , 'type4DriverClassName', ' belonging to Resource ', 'MYSQL', ' under folder ', 'UserDefined'
2011-12-05 12:28:40.332271 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty , 'UserDefined', 'MYSQL', 'type4DriverClassName'
2011-12-05 12:28:40.332366 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::getNamedResourceRegistryProperty
2011-12-05 12:28:40.332405 5324 ImbExternalResourceRegistryBranch::loadFromRegistryBranch 'Obtained the following from the registry :' , ' Resource=', 'MYSQL', ' Property=', 'type4DriverClassName', ' Value=', 'com.mysql.jdbc.Driver'
2011-12-05 12:28:40.332435 5324 } ImbExternalResourceRegistryBranch::loadFromRegistryBranch , true
2011-12-05 12:28:40.332477 5324 { ImbExternalResourceRegistryBranchPlatformSpecific::~ImbExternalResourceRegistryBranchPlatformSpecific
2011-12-05 12:28:40.332511 5324 } ImbExternalResourceRegistryBranchPlatformSpecific::~ImbExternalResourceRegistryBranchPlatformSpecific
2011-
|
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Dec 05, 2011 12:53 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
So you found the part where it loads the configurable service information.
Now you have to find the part where it tries to create a connection from that, and fails. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Dec 05, 2011 12:54 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Ok so we have
| Code: |
' Resource=', 'MYSQL', ' Property=', 'connectionUrlFormat', ' Value=',
'jdbc:mysql://[serverName]:[portNumber]/[databaseName]'
' Resource=', 'MYSQL', ' Property=', 'databaseName', ' Value=', '172.17.3.113'
' Resource=', 'MYSQL', ' Property=', 'databaseType', ' Value=', 'mysql'
' Resource=', 'MYSQL', ' Property=', 'portNumber', ' Value=', '3306'
' Resource=', 'MYSQL', ' Property=', 'securityIdentity', ' Value=', 'default_User@default_Server'
' Resource=', 'MYSQL', ' Property=', 'serverName', ' Value=', 'localhost'
|
Looks like databaseName and securityIdentity do not have the expected values.... you need to fix that.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
  |
Goto page 1, 2 Next |
Page 1 of 2 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
