05-12-2023 10:13 AM
driver_manager = spark._sc._gateway.jvm.java.sql.DriverManager
connection = driver_manager.getConnection(mssql_url, mssql_user, mssql_pass)
connection.prepareCall("EXEC sys.sp_tables").execute()
connection.close()
The above code works fine but however I am unable to capture the output Params from Stored Procedure
Can someone please share the snippet to capture output value
05-12-2023 02:42 PM
I think there is an `executeQuery()` function that also works and returns a resultset. Something like this (I have not tested though):
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
sql = "SELECT * FROM mytable";
rs = stmt.executeQuery(sql);
05-12-2023 02:42 PM
I think there is an `executeQuery()` function that also works and returns a resultset. Something like this (I have not tested though):
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
sql = "SELECT * FROM mytable";
rs = stmt.executeQuery(sql);
05-13-2023 03:15 AM
If I print(rs) I am not receiving the expected result
06-09-2023 09:48 AM
Can you provide more details on the output? I am not entirely sure if the print statement would show the value of rs as it may just show the type of the python object since it is not a string variable.
11-03-2023 04:59 AM
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.