VGaur
Contributor
Joined 11 years ago
User Profile
User Widgets
Contributions
Unable to use sql functions JDBC steps
Hey, I am trying to write a JDBC query to insert/update a location field in a table but seems like Ready!API is not able to insert/update record.The connection settings to the database are good but query doesn't seems to work. Here is a sample/random query that I ma trying to run. Got it from here . I don't believe that is the sql version problem at our end because sql management tool is able to run it. Any clues? Query - DECLARE @g geography SET @g = geography::STGeomFromText('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + CAST([Latitude] AS VARCHAR(20)) + ')', 4326) SELECT @g.ToString() Error - Error getting response for [JDBC Request]; com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1. Thanks1.6KViews0likes2CommentsRe: Readyapi & Jenkins (slaves) issue.
Thanks for the response. But correct me I am wrong. Are you implying that since each slave require one license to execute testcase - machine username == readyapi username == slave running as username ?? or readyapi username == slave running as username(here slave could be run by any service user in active directory)?? Cheers1.5KViews0likes0CommentsReadyapi & Jenkins (slaves) issue.
Hey, This could be a potential duplicate but since I am not able to figure out the solution yet.So, I am just digging this issue out from it's grave. Smart Bear has given clear instructions here about how to solve the issue but in my cases I have couple of slaves running on s separate box hosting jenkins server and jenkins by itself doesn't run with and particular user. So if I have to solve this issue should I be having readyapi license username same as the user/group account under which slaves are running??? Jenkins running as Local system account and slave triggered by windows task scheduler which has the same user/group account that we use to log into the box hosting jenkins. It's a false belief that updating the readyapi version would solve this issue. Any help is appreciated??1.5KViews0likes2CommentsRe: Enhance how Soapui NG saves testcase in xml file
Hey, Is there an outcome on this yet?This is the biggest pain point and a reason for us to rethink about other options. When you are providing integration with version control systems then this is fairly understandable changing test environment will cause changes to the file and version control system will start tracking it as change. Can you please take some action on it. And merry christmas to you guys.:smileyvery-happy: Cheers, VGaur4.4KViews0likes0CommentsRe: active database connection
Hey nmrao, You are right except for JDBC step, knowing what db connection you are working on doesn't make sense. But you can set and inquire the connection using groovy script. That's what I want to know - I am passing the context,testRunner,log to my external script and setting up database connections using the physical name of the connection defined in ReadyAPI tool. Some of my test cases are failing and I suspect that sql query that executes in the external script does not point to correct database and I want to know whether the connections I am setting are actually good or not. 1. I have tried to query databasecontainer class but because I m using "testRunner" to access it gives me the default connection setup against my service and not what I am pointing to. 2. def conn= utils.getJdbcConnection("physical Name of connection") , checked Connection Interface (http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html?is-external=true) it doesn't exposed any method that would let me pull out the connection string. At last the only workaround that I have put in place is get the activeEnvironment in the external script and set it again using setActiveEnvironment. Please let me know if you have any question. Cheers1.1KViews0likes0Commentsactive database connection
Hello, Like getActiveEnvironmentName() , is there a way to get the active database connection string? I have a script external to soapui tool and I call that script using groovy and pass (testRunner,Context and log) to it. I am using "com.eviware.soapui.support.GroovyUtilsPro(context)" class to establish connection. I want to see the connection details in this context. Cheers1.2KViews0likes2Comments