OFBiz 4.0 -----Original Message----- From: Jacques Le Roux [mailto:[email protected]] Sent: 2009年3月27日 18:13 To: [email protected] Subject: Re: OFBiz's jdbc driver
Which version of OFBiz are you using ? Jacques From: "Jack Liu" <[email protected]> > OFBiz uses ofbiz-minerva.jar > > -----Original Message----- > From: Jack Liu [mailto:[email protected]] > Sent: 2009年3月27日 17:18 > To: [email protected] > Subject: OFBiz's jdbc driver > > Hi, all > > What driver does OFBiz use to connect db server? > For mysql's official jdbc driver,for example, > mysql-connector-java-5.1.7.jar > I can do the following: > > PreparedStatement ps = null; > > ps = _connection.prepareStatement( "insert into clients (cid,cname) > values (?,?)"); > ps.setInt(1, 11); > ps.setString(2, "test"); > System.out.println(ps.toString()); > ps.executeUpdate(); > > through ps.toString I can get the sql sentence which will be sent to db > server > insert into clients (cid,cname) values (11,'test'); > > While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString > doesn't work. > System.out.println(_ps.toString()) > It gets: org.ofbiz.minerva.pool.jdbc.preparedstatementinp...@1e07d3e > > I tested a few cases and found out that when insert,update and delete > ,ofbiz use it own driver, while select, it uses > mysql-connector-java-5.1.7. > > Who can tell me why? > > Thank you ! > >
