Re: What is best JDBC driver for Informix

hi there, i've found that the openlink informix driver don't support this syntax. as of yet, the only driver i've seen which does is the JdbcOdbcDriver supplied by sun -- probably only because the odbc driver supports it. i don't know about intersolv, but i'm investigating both it and a suite from weblogic to see if they have this functionality... i need it! cheers ///daly Pavel Kazakov wrote: > > 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