Re: AW: svc-query-jdbc queryresult

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
> <query-sql id="ListCaseMasterFilingsByDate" logger="occa" >
>   <dbpool>oscn-dbpool</dbpool>
>   <dbtype>oscn-dbtype</dbtype>
>   <criteria name="caseMasterId" descrip="fk for casemaster table"/>
>   <result name="id" descrip="Key for occa_filing table" />
>   <result name="action_id" descrip="" />
>   <result name="status_id" descrip="" />
>   <result name="filing_type_id" descrip="" />
>   <result name="DateFiled" descrip="" />
>   <result name="ScreenMsg" descrip="" />
>   <result name="dockettext" descrip="" />
>   <sql><![CDATA[
> 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]]>
>   </sql>
> </query-sql>
> 
> 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