Re: AW: svc-query-jdbc queryresult

That helps, and the explanation makes sense.  Thanks for looking at this.
 
Gene

Aleksandar Vidakovic <[email protected]> wrote:
Maybe the below code is a little bit better in case the values are null:

[code]

actionstr =
SuperString.notNull( String.valueOf(oneRSRecord.get("action_id")) );
^^^^^^^^^^^^^^
[/code]

Aleks

On Fri, 2005-09-23 at 10:15 -0500, Gene McCullough wrote:
> How i typically used it:
> query defined as
> 
> oscn-dbpool
> oscn-dbtype
> 
> 
> 
> 
> 
> 
> 
> 
> > SELECT o.id , o.action_id, o.status_id, o.filing_type_id, d.DateFiled,
> c.ScreenMsg, d.dockettext FROM occa_filing o left JOIN docket d
> ON d.DocketID = o.docket_id left join codes c on d.LineCodeID = c.CodesID
> WHERE o.casemaster_id = $caseMasterId
> order by d.DateFiled]]>
> 
> 
> 
> code...
> 
> List filings = null;
> Query myDefaultQuery = (Query) req.getService(Query.ROLE,
> "ListCaseMasterFilingsByDate");
> myDefaultQuery.setCriteria("caseMasterId", caseMasterID);
> filings = myDefaultQuery.getQueryResults();
> ...
> Iterator i = filings.iterator();
> Map oneRSRecord = null;
> while (i.hasNext()) {
> currentRecordNumber++;
> oneRSRecord = (Map) i.next();
> try {
> Id = String.valueOf(oneRSRecord.get("id"));
> log.debug( "id is => " + Id);
> 
> actionstr = SuperString.notNull( (String)
> oneRSRecord.get("action_id") );
> statusstr = SuperString.notNull( (String)
> oneRSRecord.get("status_id") );
> }catch(Exception e){
> log.fatalError("Now what???" + e.getMessage());
> }
> }
> 
> which produces in log
> Now what???java.lang.Long
> 
> This code worked without fail previously without the try catch block, i
> added that after the updates to keep the model from bombing completely.
> Any help appreciated, because I use the svc throughout the project.
> 
> thanks,
> gene
> 
> Vidakovic, Aleksandar wrote:
> > Salut Gene,
> > 
> > I'm using svc-query-jdbc quite extensively... and if there are problems it's me who produced them, because I committed some changes some time ago. Send me more of your code (or at least the query) so that I can see if I can fix this. Running the unit tests didn't cause any problems. I'll look into it tonight or tomorrow...
> > 
> > Cheers,
> > 
> > Aleks
> > 
> > -----Ursprüngliche Nachricht-----
> > Von: Gene McCullough [mailto:[email protected]]
> > Gesendet: Freitag, 23. September 2005 00:59
> > An: Keel Developers List
> > Betreff: [Keelgroup] svc-query-jdbc queryresult
> > 
> > 
> > Anybody else using svc-query-jdbc? After updating the module, I get
> > cast exceptions trying to get data from the QueryResult (a List of Map
> > objects).
> > 
> > Before the last code change to the project I was able to get all data like:
> > 
> > code = SuperString.notNull( (String) oneRSRecord.get("ScreenMsg") );
> > 
> > where oneRSRecord is a nested Map from the List. Now seems the "fields"
> > are typed in a manner that doesn't convert to a String. 
> > 
> > I may have migrated to java 1.5 in there also (I was pulled from dev for
> > several months). Seems like there were lots of changes to DefaultQuery,
> > am I the only person having this problem. Any suggestions, besides
> > changing all instances to expect a certain data type?
> > 
> > TIA,
> > gene
> > http://keelframework.org/documentation.shtml
> > Keelgroup mailing list
> > [email protected]
> > http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> > http://keelframework.org/documentation.shtml
> > Keelgroup mailing list
> > [email protected]
> > http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> > 
> http://keelframework.org/documentation.shtml
> Keelgroup mailing list
> [email protected]
> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> 

http://keelframework.org/documentation.shtml
Keelgroup mailing list
[email protected]
http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com