Community
Participate
Working Groups
Build Identifier: 20110916-0149 Whenever we are trying to edit the driver definition in the Driver Definition preferences window, the editing information is not persisted in the connection URL of that particular driver while creating the new database connection in Data Source Explorer. Reproducible: Always Steps to Reproduce: 1.In any Data Studio product [ Rational Application Developer, InfoSphere Data Architect ..], open Windows --> Preferences --> Data management --> Driver Definitions. 2.Select a particular driver which you want and click Edit button, enter additional parameters and click Apply button. 3.Try to create new database connection. Actual Results: The editing information in the Driver Definition preferences window is not persisted in the connection URL of that particular driver. Expected Results: The editing information in the Driver Definition preferences window should be persisted in the connection URL of that particular driver.
Created attachment 209445 [details] This patches file contains 4 patches. Hi Brian, I have fixed this issue for RATLC00327075 defect. This patches file contains four individual patches for four plugins which are having changes, I did not increment any plugin version and feature version. I have to push these code changes into ds_const_8.5 and ds_const_3.0.3.6 constellation streams, for that is there any IES patches available? Please let me know on the same.
Created attachment 209514 [details] New patches in plain text format. Hi Brian, I have attached a new patch file which is in plain text format.
Created attachment 209515 [details] This is the first patch.
Created attachment 209516 [details] This is the second patch.
Created attachment 209517 [details] This is the third patch.
Created attachment 209518 [details] This is the fourth pathc.
Hi Brian, I have attached all the individual patches which are in the text/plain format. Thanks.
David, I ran into a problem when testing the fix. With the patch applied, on DB2 or LUW (the first platform I tested), then the database name gets appended to the end of the connection URL, which makes it invalid. Without the patch: jdbc:db2://9.30.68.165:50002/SAMPLE:retrieveMessagesFromServerOnGetMessage=true; With the patch: jdbc:db2://9.30.68.165:50002/SAMPLE:retrieveMessagesFromServerOnGetMessage=true;SAMPLE; When the connection is attempted, the Database gives this error message: com.ibm.db2.jcc.b.nm: [jcc][10165][10051][3.50.152] Invalid database URL syntax: jdbc:db2://9.30.68.165:50002/SAMPLE:retrieveMessagesFromServerOnGetMessage=true;SAMPLE;. ERRORCODE=-4461, SQLSTATE=42815 I did not specify any additional connection parameters. In fact I did not yet visit the database definition preference page. I cannot commit this patch as-is.
Created attachment 209808 [details] This is the patch for iSreies
Created attachment 209809 [details] This patch is for DB2 LUW
Created attachment 209810 [details] This is for ZSeries
Created attachment 209811 [details] This is for Informix
Created attachment 209812 [details] This is for Zseries
Hi Brian, I have modified that DB2 LUW code changes, and I have added all the patches once again. Could you please push the code changes by using the patches which I had added newly [ patch1.txt, patch2.txt, patch4.txt and patch5.txt]? Please ignore the patch patch3.txt, it is same as the patch patch5.tax, I have added again the same patch by mistakenly. Please let me know on the same. Thaks, David.
Hi David, the patch still doesn't test out properly. Before the patch, the Driver Properties page for an existing DB2 for LUW connection looks like this: Database: SAMPLE Host: 9.30.68.165 Port number: 50002 etc. After the patch, the Driver Properties page looks like this: Database: SAMPLE:retrieveMessagesFromServerOnGetMessage=true Host: 9.30.68.165 Port number: 50002 etc. and the Connection URL looks like this: jdbc:db2://9.30.68.165:50002/SAMPLE:retrieveMessagesFromServerOnGetMessage=true;retrieveMessagesFromServerOnGetMessage=true; That is, the default additional property is appended twice.
Created attachment 210641 [details] New_DB2 LUW patch
Created attachment 210642 [details] New_Informix patch
Hi Brian, Thanks for your help in finding the typical use case. I have found the same problem in Informix database driver also, I have fixed that problem in both DB2 LUW and Informix databases, i have attached new patches( New_DB2 LUW patch, New_Informix patch). Could you please test and push the code into open DTP? Please let me know if you have any concerns on the same. Thanks, David.
Created attachment 210711 [details] New_Informix patch
Created attachment 210712 [details] New_Informix patch
OK, I've finished testing the patches and have checked in the code. Here's the Git commit record: http://git.eclipse.org/c/datatools/org.eclipse.datatools.enablement.ibm.git/commit/?id=d8351c2428e7afa6ca041784d1fc3d4ae3c8bc56 I added //$NON-NLS-1$ tags to all the code lines with string literals and updated the plugin version in the MANIFEST.MF file.
