Dain Sundstrom wrote:
> There are to things that are hard. T
>
> he first is mapping the output columns to the result object. This is
> complicated by the fact that a cmp field can map to more then one column.
> You will have to add error handling to assure that all of the properties of
> a field are loaded. I don't think my helper methods will work because they
> assume a certain order to the columns (the helpers create both the queries
> and the load the results).
>
Agreed.
> The second one is somewhat related. Since a field (really an object type /
> class) maps to more then one column you will have an issue with query input
> parameters. I suggest something like ?1.prop.prop (more like ejb-ql) or
> {1.prop.prop} (I like this one, more like old jaws style, easier to parse).
> I was going to write some helpers to extract properties based on a doted
> structure, but haven't gotten to it yet.
>
Hmmm.. I was thinking that you would pass the whole sql command through,
execute it as is and then grab the metadata for the result set and then
try and fill the object. The problem with properties is when you are
doing dynamic queries you don't know how many input parameters you are
dealing with. If your input parameters are static then could you not use
delared-sql ?
> So given that there are 48-60 hours in a weekend it is doable, but I would
> shoot for 2 weekends. One to get the results half and the other for
> parameters.
>
Ouch... Love a challenge though ...
> -dain
>
>
>>-----Original Message-----
>>From: Dave Smith [mailto:[EMAIL PROTECTED]]
>>Sent: Friday, October 19, 2001 3:57 PM
>>To: [EMAIL PROTECTED]
>>Subject: [JBoss-dev] Raw-sql
>>
>>
>>I am trying to use the raw-sql feature of jbosscmp-jdbc.xml.
>>Now as far
>>as I can see it looks like it is not implemented. The
>>JDBCRawSqlQueryMetaData does not store the query in the .xml
>>file only
>>the method. The JDBCFindEntitiesCommand only checks for
>>JDBCDeclaredQueryMetaData,,JDBCQlQueryMetaData types as known finders.
>>
>>I am assuming that you would specify raw-sql and then pass in the sql
>>command you with to execute as the only argument to the finder method.
>>It does not look that hard to add, extend JDBCFinderCommand, add an
>>entry in JDBCFindEntitiesCommand and a Factory method in
>>JDBCCommandFactory. I could do it this weekend or am I way
>>off base here?
>>
>>
>>_______________________________________________
>>Jboss-development mailing list
>>[EMAIL PROTECTED]
>>https://lists.sourceforge.net/lists/listinfo/jboss-development
>>
>>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
