Re: What is best JDBC driver for Informix

Posted in 1998

Pavel Kazakov — Tue, 02 Jun 1998 17:39:20 -0700 — source: Informix-list mailing list archive (1991-1998)

jeffso@lucent.com wrote: > I have evaluated both JDBC drivers from Openlink and Intersolv. Both are quit > good in term of performance and setup. However, when working with openlink, my > development environment ( jbuilder ) hangs more often than when using > intersolv. However, Intersolv driver need to create 2 extra table per database > you connected to. Hi Jeff , Do you have any idea if syntax of callable statements is supported for Informix ? String SqlStmt = "{? =call InsertRow(?,?,?,?)}"; CallableStatement cst = Conn.prepareCall(SqlStmt); cst.registerOutParameter(1,InformixTypes.INTEGER); cst.setLong(2,inPar1); cst.setLong(3,inPar2); cst.setLong(4,inPar3); cst.setLong(5,inPar5); Is that syntax supported ? Thank a lot for you help,Pavel