JNDI seems to be overridden by JDBC in log file, so JNDI name is never attempted

Hello, 
 
I use birt 2.3.2 
 
I can't seem to get my JNDI naming to work, even though it used to work. 
 
I set the JNDI value to a parameter in my datasource as ... 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
FINE: Data Engine starts up
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINER: ENTRY LaborDataSources.PM
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINE: DataEngine.defineDataSource: OdaDataSourceDesign(Name : LaborDataSources.PM
ExtensionID : org.eclipse.birt.report.data.oda.jdbc
PrivateProperties : {}
PulicProperties : odaJndiName=java:PM1;odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_LaborDataSources.PM;odaDriverClass=oracle.jdbc.OracleDriver;odaURL=jdbc:oracle:thin:@blah.blah.blah.com:1521:WMPRD;odaUser=lol;
)
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
FINER: ENTRY org.eclipse.birt.data.engine.api.querydefn.OdaDataSourceDesign@a87a8 [object Object]
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
FINER: ENTRY org.eclipse.birt.data.engine.api.querydefn.OdaDataSourceDesign@a87a8 [object Object]
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime <init>
FINER: OdaDataSourceRuntime starts up
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
FINER: ENTRY LaborDataSources.pmFacility
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
FINE: DataEngine.defineDataSet: OdaDataSetDesign(Name : LaborDataSources.pmFacility
DataSourceName : LaborDataSources.PM
ResultSetHints : org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@1504a84,
org.eclipse.birt.data.engine.api.querydefn.ColumnDefinition@4c4ff8
ExtensionID : org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
QueryText : select distinct WHSE_KEY, WHSE_ID
from pm_d_whse
PrivateProperties : {}
PublicProperties : {queryTimeOut=null}
)
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINER: ENTRY LaborDataSources.PM
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINE: DataEngine.defineDataSource: OdaDataSourceDesign(Name : LaborDataSources.PM
ExtensionID : org.eclipse.birt.report.data.oda.jdbc
PrivateProperties : {}
PulicProperties : odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_LaborDataSources.PM;odaDriverClass=oracle.jdbc.OracleDriver;odaURL=jdbc:oracle:thin:@blah.blah.blah.com:1521:WMPRD;odaUser=lol;
)
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
FINER: ENTRY org.eclipse.birt.report.data.adapter.internal.adapter.OdaDataSourceAdapter@1644c9 [object Object]
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
FINER: ENTRY org.eclipse.birt.report.data.adapter.internal.adapter.OdaDataSourceAdapter@1644c9 [object Object]
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime <init>
FINER: OdaDataSourceRuntime starts up
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
FINER: RETURN
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
FINER: ENTRY LaborDataSources.pmFacility
</pre>
 
my question is it seems like its being overridden on the second call to the dataset. 
 
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource 
FINE: DataEngine.defineDataSource: OdaDataSourceDesign(Name : LaborDataSources.PM 
ExtensionID : org.eclipse.birt.report.data.oda.jdbc 
PrivateProperties : {} 
PulicProperties : odaJndiName=java:PM1;odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_LaborDataSources.PM;odaDriverClass=oracle.jdbc.OracleDriver;odaURL=jdbc:oracle:thin:@blah.blah.blah.com:1521:WMPRD;odaUser=lol; 
) 
 
then later... 
 
FINER: ENTRY LaborDataSources.PM 
Jul 29, 2009 9:23:22 PM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource 
FINE: DataEngine.defineDataSource: OdaDataSourceDesign(Name : LaborDataSources.PM 
ExtensionID : org.eclipse.birt.report.data.oda.jdbc 
PrivateProperties : {} 
PulicProperties : odaPassword=***;OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_LaborDataSources.PM;odaDriverClass=oracle.jdbc.OracleDriver;odaURL=jdbc:oracle:thin:@blah.blah.blah.com:1521:WMPRD;odaUser=lol; 
) 
 
I'm using the downloadable webviewer and this used to work, but for some reason, I seem to be getting this double call that is overwriting the jdbc datasource before it can run the odaJNDIname 
 
parts of my log and datasource file (they were both too large to upload) 
I''ve attached a log and my datasource library. 
 
Thanks for any help anyone can provide. 
 
Dave

Find more posts tagged with

Comments

Davolio

alright I figured out what Might have been wrong,

in my library datasource I had my JNDI url property = "java:" + params["p_CONN"] and passed the mapping in via report parameter.

This apparently wasn't working correctly for me in 2.3.2 SO what I did was I just hardcoded the mapping in as java:<mapname> in the JDBC section of the datasource JNDI url and my problem was solved because our mappings are static for each datasource anyways.

This solved the problem of the code resetting my odadatasource that the log above points to. I don't really get it but I thought I'd post my solution...

I should probably dive into the BIRT source so I have a better understanding of how all of the ODA stuff works.

Thanks and if any of you see anything weird or that I should do differently feel free point me in a different direction.

Dave