Home » Archived » BIRT » SQL Error with jndi connection but not birt created connection
| SQL Error with jndi connection but not birt created connection [message #203776] |
Wed, 29 November 2006 13:19  |
Eclipse User |
|
|
|
This is a multi-part message in MIME format.
--------------010206080100080604090105
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
I am using a fairly complex sql (see end) that works just fine with a birt created connection in
both the report designer and the webserver (Similar integration as Servlet Example). When I instead
change to a jndi supplied connection (or the pass through connection example from Jason), I get
errors. The success and fail logs are attached. It looks to me like the metadata that is being
returned is different in each case.
Does anyone have any clue what is going on here?
jboss datasource definition:
<datasources>
<no-tx-datasource>
<jndi-name>env/ReportDS</jndi-name>
<connection-url>jdbc:jtds:sybase://tca-db01:5000/Risk;tds=5.0;lastupdatecount=true</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class >
<user-name>XXXX</user-name>
<password>XXXX</password>
<min-pool-size>15</min-pool-size>
<max-pool-size>30</max-pool-size>
<idle-timeout-minutes>30</idle-timeout-minutes>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<check-valid-connection-sql>select count(*) from sysusers</check-valid-connection-sql>
</no-tx-datasource>
</datasource>
SQL statement:
DECLARE @id_result NUMERIC(10,0)
select @id_result = ?
create table #BUCKETS (
label char(10) not null,
minVal float(16) not null,
maxVal float(16) not null
)
INSERT IGNORE INTO #BUCKETS VALUES('< 10', 0, .10)
INSERT IGNORE INTO #BUCKETS VALUES('10 - 25',.10,.25)
INSERT IGNORE INTO #BUCKETS VALUES('25 - 50',.25,.50)
INSERT IGNORE INTO #BUCKETS VALUES('50 - 100',.50,1.00)
INSERT IGNORE INTO #BUCKETS VALUES('> 100',1.00,1E9)
create table #R_SUMMARY (
MDVRangeOrder float not null,
Side varchar(20) not null,
TotalNames int not null,
TotalValuePerc float(16) null,
TotalShares float(16) null,
AvgShares float(16) null,
AvgMDVPerc float(16) null,
AvgMktCap float(16) null,
AvgPrice float(16) null,
AvgSpread float(16) null,
AvgCost float(16) null,
AvgCostPS float(16) null,
AvgCostPSBp float(16) null
)
INSERT IGNORE INTO #R_SUMMARY
SELECT B.minVal as MDVRangeOrder, A.fl_buy_sell as Side,
count(*) as TotalNames,
sum(n_trade_value_percent) as TotalValuePerc,
sum(n_shares)/1000.0 as TotalShares,
sum(n_shares)/count(*)/1000.0 as AvgShares,
sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
FROM R_ITGRISK_RESULTS A, #BUCKETS B
WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and A.n_volume_percent < B.maxVal
GROUP BY B.minVal, A.fl_buy_sell
INSERT IGNORE INTO #R_SUMMARY
SELECT B.minVal as MDVRangeOrder, 'Total' as Side,
count(*) as TotalNames,
sum(n_trade_value_percent) as TotalValuePerc,
sum(n_shares)/1000.0 as TotalShares,
sum(n_shares)/count(*)/1000.0 as AvgShares,
sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
FROM R_ITGRISK_RESULTS A, #BUCKETS B
WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and A.n_volume_percent < B.maxVal
GROUP BY B.minVal
select B.minVal as MDVRangeOrder, B.label as MDVRange, A.code_summary_type as Side, C.TotalNames,
C.TotalValuePerc, C.TotalShares,
C.AvgShares, C.AvgMDVPerc, C.AvgMktCap, C.AvgPrice, C.AvgSpread,
C.AvgCost, C.AvgCostPS, C.AvgCostPSBp
from R_ITGRISK_SUMMARY A
JOIN #BUCKETS B on 1=1
LEFT OUTER JOIN #R_SUMMARY C on (A.code_summary_type = C.Side AND B.minVal = C.MDVRangeOrder)
WHERE A.id_result = @id_result
ORDER BY B.MDVRangeOrder, A.code_summary_type
DROP TABLE #BUCKETS
DROP TABLE #R_SUMMARY
--------------010206080100080604090105
Content-Type: text/plain;
name="success.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline;
filename="success.log"
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.engine.api.impl.ReportEng=
ine openReportDesign
FINE: ReportEngine.openReportDesign: name=3DTradelistMDVRange.rptdesign, =
designStream=3Djava.io.ByteArrayInputStream@618533=20
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice asc
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice DataSet
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice hide
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice if-realized
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice hyperlink
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice inner
Nov 29, 2006 9:35:45 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice static
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice single
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice scroll
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0%
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0%
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice repeat
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice left
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0em
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice block
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1.25in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1.25in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0.5pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice asc
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice size-to-image
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice horizontal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice scroll
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0%
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0%
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice repeat
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice left
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0em
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice block
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice asc
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1.25in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1.25in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice horizontal
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 0.5pt
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice static
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice size-to-image
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice single
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice none
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice NoChange
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice hyperlink
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice DataSet
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice asc
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice hide
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice inner
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice eq
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice any
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice if-realized
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice auto
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice in
Nov 29, 2006 9:35:46 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: I=
TGLogic.printTheme
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice in
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: p=
rintTheme
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice static
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice text-box
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: R=
isk Db
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice integer
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: R=
isk Db
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice integer
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: R=
isk Db
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice integer
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ElementRef=
PropertyType validateValue
FINE: Validate the value of the element reference property as a string: R=
isk Db
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice decimal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice string
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice integer
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice float
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 16777215
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 11px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 0
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 10px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice bold
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 0
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice left
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 16119285
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 0
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice right
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 11px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice normal
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 13158600
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice solid
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 1px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyType validateXml
FINE: return dimension value with user defined unit 2px
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice right
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ChoiceProp=
ertyType validateXml
FINE: return internal name for choice nowrap
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.ColorPrope=
rtyType validateXml
FINE: The validated color property value 7310750
Nov 29, 2006 9:35:47 AM org.eclipse.birt.report.model.metadata.DimensionP=
ropertyTyp
|
|
|
| Re: SQL Error with jndi connection but not birt created connection [message #203820 is a reply to message #203776] |
Wed, 29 November 2006 15:40  |
| Eclipse User |
|
|
|
Update: If I provided a connection from a manually created apache dbcp pool it worked properly. It
appears to be an integration issue between birt and the jboss pooling mechanism.
Ryan Barker wrote:
> I am using a fairly complex sql (see end) that works just fine with a
> birt created connection in both the report designer and the webserver
> (Similar integration as Servlet Example). When I instead change to a
> jndi supplied connection (or the pass through connection example from
> Jason), I get errors. The success and fail logs are attached. It looks
> to me like the metadata that is being returned is different in each case.
>
> Does anyone have any clue what is going on here?
>
> jboss datasource definition:
> <datasources>
> <no-tx-datasource>
> <jndi-name>env/ReportDS</jndi-name>
> <connection-url>jdbc:jtds:sybase://tca-db01:5000/Risk;tds=5.0;lastupdatecount=true</connection-url>
>
> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class >
> <user-name>XXXX</user-name>
> <password>XXXX</password>
> <min-pool-size>15</min-pool-size>
>
> <max-pool-size>30</max-pool-size>
> <idle-timeout-minutes>30</idle-timeout-minutes>
> <blocking-timeout-millis>5000</blocking-timeout-millis>
> <check-valid-connection-sql>select count(*) from
> sysusers</check-valid-connection-sql>
> </no-tx-datasource>
> </datasource>
>
>
> SQL statement:
>
> DECLARE @id_result NUMERIC(10,0)
> select @id_result = ?
>
> create table #BUCKETS (
> label char(10) not null,
> minVal float(16) not null,
> maxVal float(16) not null
> )
> INSERT IGNORE INTO #BUCKETS VALUES('< 10', 0, .10)
> INSERT IGNORE INTO #BUCKETS VALUES('10 - 25',.10,.25)
> INSERT IGNORE INTO #BUCKETS VALUES('25 - 50',.25,.50)
> INSERT IGNORE INTO #BUCKETS VALUES('50 - 100',.50,1.00)
> INSERT IGNORE INTO #BUCKETS VALUES('> 100',1.00,1E9)
>
> create table #R_SUMMARY (
> MDVRangeOrder float not null,
> Side varchar(20) not null,
> TotalNames int not null,
> TotalValuePerc float(16) null,
> TotalShares float(16) null,
> AvgShares float(16) null,
> AvgMDVPerc float(16) null,
> AvgMktCap float(16) null,
> AvgPrice float(16) null,
> AvgSpread float(16) null,
> AvgCost float(16) null,
> AvgCostPS float(16) null,
> AvgCostPSBp float(16) null
> )
> INSERT IGNORE INTO #R_SUMMARY
> SELECT B.minVal as MDVRangeOrder, A.fl_buy_sell as Side,
> count(*) as TotalNames,
> sum(n_trade_value_percent) as TotalValuePerc,
> sum(n_shares)/1000.0 as TotalShares,
> sum(n_shares)/count(*)/1000.0 as AvgShares,
> sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
> sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
> sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
> sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
> sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
> sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
> sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
> FROM R_ITGRISK_RESULTS A, #BUCKETS B
> WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and
> A.n_volume_percent < B.maxVal
> GROUP BY B.minVal, A.fl_buy_sell
>
> INSERT IGNORE INTO #R_SUMMARY
> SELECT B.minVal as MDVRangeOrder, 'Total' as Side,
> count(*) as TotalNames,
> sum(n_trade_value_percent) as TotalValuePerc,
> sum(n_shares)/1000.0 as TotalShares,
> sum(n_shares)/count(*)/1000.0 as AvgShares,
> sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
> sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
> sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
> sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
> sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
> sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
> sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
> FROM R_ITGRISK_RESULTS A, #BUCKETS B
> WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and
> A.n_volume_percent < B.maxVal
> GROUP BY B.minVal
>
> select B.minVal as MDVRangeOrder, B.label as MDVRange,
> A.code_summary_type as Side, C.TotalNames, C.TotalValuePerc, C.TotalShares,
> C.AvgShares, C.AvgMDVPerc, C.AvgMktCap, C.AvgPrice, C.AvgSpread,
> C.AvgCost, C.AvgCostPS, C.AvgCostPSBp
> from R_ITGRISK_SUMMARY A
> JOIN #BUCKETS B on 1=1
> LEFT OUTER JOIN #R_SUMMARY C on (A.code_summary_type = C.Side AND
> B.minVal = C.MDVRangeOrder)
> WHERE A.id_result = @id_result
> ORDER BY B.MDVRangeOrder, A.code_summary_type
>
> DROP TABLE #BUCKETS
> DROP TABLE #R_SUMMARY
>
>
|
|
|
| Re: SQL Error with jndi connection but not birt created connection [message #203885 is a reply to message #203820] |
Wed, 29 November 2006 20:59 |
| Eclipse User |
|
|
|
Ryan,
Can you log a bug entry on this?
Jason
"Ryan Barker" <barker@itgssi.com> wrote in message
news:ekkr82$27d$1@utils.eclipse.org...
> Update: If I provided a connection from a manually created apache dbcp
> pool it worked properly. It appears to be an integration issue between
> birt and the jboss pooling mechanism.
>
>
> Ryan Barker wrote:
>
>> I am using a fairly complex sql (see end) that works just fine with a
>> birt created connection in both the report designer and the webserver
>> (Similar integration as Servlet Example). When I instead change to a jndi
>> supplied connection (or the pass through connection example from Jason),
>> I get errors. The success and fail logs are attached. It looks to me
>> like the metadata that is being returned is different in each case.
>>
>> Does anyone have any clue what is going on here?
>>
>> jboss datasource definition:
>> <datasources>
>> <no-tx-datasource>
>> <jndi-name>env/ReportDS</jndi-name>
>> <connection-url>jdbc:jtds:sybase://tca-db01:5000/Risk;tds=5.0;lastupdatecount=true</connection-url>
>> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class >
>> <user-name>XXXX</user-name>
>> <password>XXXX</password>
>> <min-pool-size>15</min-pool-size>
>>
>> <max-pool-size>30</max-pool-size>
>> <idle-timeout-minutes>30</idle-timeout-minutes>
>> <blocking-timeout-millis>5000</blocking-timeout-millis>
>> <check-valid-connection-sql>select count(*) from
>> sysusers</check-valid-connection-sql>
>> </no-tx-datasource>
>> </datasource>
>>
>>
>> SQL statement:
>>
>> DECLARE @id_result NUMERIC(10,0)
>> select @id_result = ?
>>
>> create table #BUCKETS (
>> label char(10) not null,
>> minVal float(16) not null,
>> maxVal float(16) not null
>> )
>> INSERT IGNORE INTO #BUCKETS VALUES('< 10', 0, .10)
>> INSERT IGNORE INTO #BUCKETS VALUES('10 - 25',.10,.25)
>> INSERT IGNORE INTO #BUCKETS VALUES('25 - 50',.25,.50)
>> INSERT IGNORE INTO #BUCKETS VALUES('50 - 100',.50,1.00)
>> INSERT IGNORE INTO #BUCKETS VALUES('> 100',1.00,1E9)
>>
>> create table #R_SUMMARY (
>> MDVRangeOrder float not null,
>> Side varchar(20) not null,
>> TotalNames int not null,
>> TotalValuePerc float(16) null,
>> TotalShares float(16) null,
>> AvgShares float(16) null,
>> AvgMDVPerc float(16) null,
>> AvgMktCap float(16) null,
>> AvgPrice float(16) null,
>> AvgSpread float(16) null,
>> AvgCost float(16) null,
>> AvgCostPS float(16) null,
>> AvgCostPSBp float(16) null
>> )
>> INSERT IGNORE INTO #R_SUMMARY
>> SELECT B.minVal as MDVRangeOrder, A.fl_buy_sell as Side,
>> count(*) as TotalNames,
>> sum(n_trade_value_percent) as TotalValuePerc,
>> sum(n_shares)/1000.0 as TotalShares,
>> sum(n_shares)/count(*)/1000.0 as AvgShares,
>> sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
>> sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
>> sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
>> sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
>> sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
>> sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
>> sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
>> FROM R_ITGRISK_RESULTS A, #BUCKETS B
>> WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and
>> A.n_volume_percent < B.maxVal
>> GROUP BY B.minVal, A.fl_buy_sell
>>
>> INSERT IGNORE INTO #R_SUMMARY
>> SELECT B.minVal as MDVRangeOrder, 'Total' as Side,
>> count(*) as TotalNames,
>> sum(n_trade_value_percent) as TotalValuePerc,
>> sum(n_shares)/1000.0 as TotalShares,
>> sum(n_shares)/count(*)/1000.0 as AvgShares,
>> sum(n_volume_percent * n_shares)/sum(n_shares) as AvgMDVPerc,
>> sum(n_market_cap * n_shares)/sum(n_shares)/1E9 as AvgMktCap,
>> sum(n_close_price * n_shares)/sum(n_shares) as AvgPrice,
>> sum(n_spread * n_shares)/sum(n_shares) as AvgSpread,
>> sum(n_cost_total * n_shares)/sum(n_shares)/1000.0 as AvgCost,
>> sum(n_cost_per_share * n_shares)/sum(n_shares) as AvgCostPS,
>> sum(n_cost_per_share_bp * n_shares)/sum(n_shares) as AvgCostPSBp
>> FROM R_ITGRISK_RESULTS A, #BUCKETS B
>> WHERE id_result = @id_result and A.n_volume_percent >= B.minVal and
>> A.n_volume_percent < B.maxVal
>> GROUP BY B.minVal
>>
>> select B.minVal as MDVRangeOrder, B.label as MDVRange,
>> A.code_summary_type as Side, C.TotalNames, C.TotalValuePerc,
>> C.TotalShares,
>> C.AvgShares, C.AvgMDVPerc, C.AvgMktCap, C.AvgPrice, C.AvgSpread,
>> C.AvgCost, C.AvgCostPS, C.AvgCostPSBp
>> from R_ITGRISK_SUMMARY A
>> JOIN #BUCKETS B on 1=1
>> LEFT OUTER JOIN #R_SUMMARY C on (A.code_summary_type = C.Side AND
>> B.minVal = C.MDVRangeOrder)
>> WHERE A.id_result = @id_result
>> ORDER BY B.MDVRangeOrder, A.code_summary_type
>>
>> DROP TABLE #BUCKETS
>> DROP TABLE #R_SUMMARY
>>
|
|
|
Goto Forum:
Current Time: Sun Sep 14 01:09:58 EDT 2025
Powered by FUDForum. Page generated in 0.04327 seconds |
Home