Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Madhi Krishnan
> > > PreparedStatement ps = > > connection.prepareStatement(rawSQLQuery1); > > ResultSet rs = ps.executeQuery(); > > while (rs.next()) { > > //put you logic here with resultSet data > > } > > catch(Exception e){ > > //Handle Exception > > } > > > > On 9/20/2018 1:18 PM, Madhi Krishnan wrote: > > > Hey all can anyone please tell me how to use raw sql query in ofbiz.. > > > If you have any sources or example it will be better.. > > > Thank You > > > > > > > >

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Aditya Sharma
while (rs.next()) { > //put you logic here with resultSet data > } > catch(Exception e){ > //Handle Exception > } > > On 9/20/2018 1:18 PM, Madhi Krishnan wrote: > > Hey all can anyone please tell me how to use raw sql query in ofbiz.. > > If you have any sources or example it will be better.. > > Thank You > > > >

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Chandrabhan Pal
          PreparedStatement ps = connection.prepareStatement(rawSQLQuery1);                     ResultSet rs = ps.executeQuery();                     while (rs.next()) {                        //put you logic here with resultSet data                     } catch(Exception e){ //Handle Exception } On 9/20

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Nicolas Malin
nyone please tell me how to use raw sql query in ofbiz.. If you have any sources or example it will be better.. Thank You

How to use Raw sql query in ofbiz

2018-09-20 Thread Madhi Krishnan
Hey all can anyone please tell me how to use raw sql query in ofbiz.. If you have any sources or example it will be better.. Thank You