Would it be possible to accomplish this in Jython instead of Java?
def testSPCall():
#java.lang.Object
#org.python.core.PyObject
from com.ziclix.python.sql.Procedure import zxJDBC
#create database connection
d,u,p,v = "jdbc:sqlserver://10.15.4.246\SQLEXPRESS", "sa", "password123", "com.microsoft.sqlserver.jdbc.SQLServerDriver"
db = zxJDBC.connect(d,u,p,v)
#Go get my table
#Pull out Array 1, Array 2, Array 3 to be used as input parameters
#Open a cursur
c = db.cursor()
c.callproc(("SensorManufacturing","dbo","dbo.UpsertRecipe"), ["Array1","Array2","Array3"])
#close connection
c.close()
In the IA manual it mentions other datatypes like Other, Java-Object and Array. So I’m thinking this might be possible.
IA manual CreateSProcCall()