Forum Discussion
Hey mrdwprice
Can you clarify a bit - where does ReadyAPI! give you the warning?
Reason I ask is that I've just added in another row to my JDBC preferences which corresponds to your second jdbc url. I already have a SQLServer connection setup and I didn't get any problems?
The db driver .jars are registered as REadyAPI! boots - but you don't link them to a specfic row in that JDBC Config preferences - just to be clear - the name you specify in the 'Driver' editable field when creating a new connection - you could call the driver name 'Steve' and it would work - admittedly that was for a different database using a different JDBC driver file with different setup.
So - I've just looked in the .jar file and there is a 'java.sql.Driver' file that contains the value 'com.microsoft.sqlserver.jdbc.SQLServerDriver' so I thought maybe this was the problem
HOWEVER - I changed the name of the 'Driver' field for my SQLServer connection - first I changed it to
MSSQL(MicrosoftDriver2)/com.microsoft.sqlserver.jdbc.SQLServerDriver, then I ran a query using the driver and it worked fine.
I then changed the value again to MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver2, then I ran a query using the driver and it worked fine.
From the evidence above - I'd just add in an extra entry into the JDBC config, the second one with a Driver value of MSSQL(MicrosoftDriver2)/com.microsoft.sqlserver.jdbc.SQLServerDriver and the connection url of
jdbc:sqlserver://<HOST>:<PORT:1433>;databaseName=<DB>;IntegratedSecurity=true
However - youre saying this wont work.
So, can you clarify where you get the warning? I've tried reproducing but I can't
Cheers
rich
Thanks very much for the reply. These are the steps I'm doing:
File>Preferences>JDBC Drivers
Click the green + icon
Add Driver name:
MSSQL(MicrosoftDriver - uniquenamehere)/com.microsoft.sqlserver.jdbc.SQLServerDriver
Add Connection String template:
jdbc:sqlserver://<HOST>:<PORT:1433>;databaseName=<DB>;IntegratedSecurity=true
Click OK
The following warning is given:
"The existing database connections may be damaged by these changes.
Are you sure you want to change the selected driver's template?"
- richie5 years agoCommunity Hero
- mrdwprice5 years agoContributor
I have tested on 2.7.0 and on 3.4.0 (same ReadyAPI project file). I get the same on both.
The Project has lots of existing connections that use this template:
jdbc:sqlserver://<HOST:127.0.0.1>:<PORT:1433>;databaseName=<DB>;user=<USER>;password=<PASSWORD>These connections over time will be migrated to use Integrated Security instead:
jdbc:sqlserver://<HOST>:<PORT:1433>;databaseName=<DB>;IntegratedSecurity=trueI was hoping to have 2 Connection String Template's for the same driver during this migration process.
- richie5 years agoCommunity HeroHey mrdwprice,
I appreciate your situation i just dont understand why youre getting the warning when i dont.
As i said before...i cant reproduce what youre doing.
Can you reset to readyapi! defaults jdbc settings and then run through exactly what youre doing step by step? I think thats the only way to nail this down as i cant get the warning you get and we're working on the same version.
Ta
Rich
Related Content
- 6 years ago
- 9 years ago
Recent Discussions
- 12 days ago
- 15 days ago