Home » Archived » BIRT » How to configure datasource in BIRT Viewer
| How to configure datasource in BIRT Viewer [message #252365] |
Tue, 14 August 2007 16:18  |
Eclipse User |
|
|
|
Originally posted by: kale.anuradha.gmail.com
Hi,
I have integrated BIRT viewer with JBoss application server.
I have also created *.rptdesign file.
My .rptdesign file contains
1. DataSource
2. Dataset
3. Few input parameters
4. Result grids and tables
My requirement is that i want to create BIRT datasources dynamically
depending on inputs from one properties file.
In simple words, I don't want to hard code dababase connection information
inside .rptdesign file.
Please let me know how to configure datasource for the .rptdesign file which
has dataset ready in it?
Regards,
Anuradha.
|
|
| |
| Re: How to configure datasource in BIRT Viewer [message #252386 is a reply to message #252378] |
Tue, 14 August 2007 17:32  |
| Eclipse User |
|
|
|
Originally posted by: kale.anuradha.gmail.com
Thank you Don.
But I also want to read the database name, username and password for
database from properties file instead of hardcoding it here in .rptdesign
file.
Please provide me inputs on how I can achieve that.
Regards,
Anuradha.
"Don Bergstrom" <monsterdon@gmail.com> wrote in message
news:f9sier$l2e$1@build.eclipse.org...
> 1. Define the JNDI URL in your reports (The .rptdesign file).
> 2. Configure the corresponding JNDI datasource in you JBoss application
> server.
>
>
> Anuradha wrote:
>> Hi,
>> I have integrated BIRT viewer with JBoss application server.
>> I have also created *.rptdesign file.
>>
>> My .rptdesign file contains
>> 1. DataSource
>> 2. Dataset
>> 3. Few input parameters
>> 4. Result grids and tables
>>
>> My requirement is that i want to create BIRT datasources dynamically
>> depending on inputs from one properties file.
>> In simple words, I don't want to hard code dababase connection
>> information inside .rptdesign file.
>>
>>
>> Please let me know how to configure datasource for the .rptdesign file
>> which has dataset ready in it?
>>
>> Regards,
>> Anuradha.
>>
>>
>>
|
|
|
| Re: How to configure datasource in BIRT Viewer [message #252398 is a reply to message #252386] |
Tue, 14 August 2007 18:11 |
 Don Bergstrom
Messages: 24
Registered: July 2009 |
Junior Member |
|
|
The JNDI URL parametere will override the parameters you have defined
for Driver Class, Database URL, User Name, and Password. All of our
reports have different values for those parameters depending on which
developed designed the report. You need to define them when you are
creating you report in order to test it.
When you define a JNDI URL parameter, the report viewer to look for a
corresponding JNDI definition in you application server configuration.
There are several ways to define a JNDI datasoure, you will need to
determine the best way for your particular implementation.
Example:
We are deploying the report viewer on an apache/tomcat instance. All of
our reports have the JNDI URL defined as java:comp/env/jdbc/MYDB. We
deploy the report viewer as a war file and in the
tomcat/conf/Catalina/localhost directory we have a file "reportview.xml"
that corresponds to our reportviewer.war file. in the xml file we have
the following definition:
<Context
className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper"
cookies="true"
crossContext="false"
debug="10"
displayName="Report Viewer"
mapperClass="org.apache.catalina.core.StandardContextMapper "
path="/reportviewer"
privileged="false"
reloadable="false"
swallowOutput="false"
useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
<Resource name="jdbc/MYDB"
auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="25" maxWait="10000"
username="DB_USER" password="DB_PASSWORD"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@DB_SERVER:1521:DB_NAME"/>
</Context>
Also, this has been discussed before in previous posts. Look for the
JNDI discussions.
Anuradha wrote:
> Thank you Don.
> But I also want to read the database name, username and password for
> database from properties file instead of hardcoding it here in .rptdesign
> file.
>
> Please provide me inputs on how I can achieve that.
>
> Regards,
> Anuradha.
>
> "Don Bergstrom" <monsterdon@gmail.com> wrote in message
> news:f9sier$l2e$1@build.eclipse.org...
>> 1. Define the JNDI URL in your reports (The .rptdesign file).
>> 2. Configure the corresponding JNDI datasource in you JBoss application
>> server.
>>
>>
>> Anuradha wrote:
>>> Hi,
>>> I have integrated BIRT viewer with JBoss application server.
>>> I have also created *.rptdesign file.
>>>
>>> My .rptdesign file contains
>>> 1. DataSource
>>> 2. Dataset
>>> 3. Few input parameters
>>> 4. Result grids and tables
>>>
>>> My requirement is that i want to create BIRT datasources dynamically
>>> depending on inputs from one properties file.
>>> In simple words, I don't want to hard code dababase connection
>>> information inside .rptdesign file.
>>>
>>>
>>> Please let me know how to configure datasource for the .rptdesign file
>>> which has dataset ready in it?
>>>
>>> Regards,
>>> Anuradha.
>>>
>>>
>>>
>
|
|
|
| Re: How to configure datasource in BIRT Viewer [message #252509 is a reply to message #252386] |
Wed, 15 August 2007 11:23 |
| Eclipse User |
|
|
|
Originally posted by: Nobert.aol.com
Hi,
to achieve this, I've created a new DataSourceEventAdapter as separate
project and implemented some property file read code within the "BeforeOpen"
event.
I also set the database properties here:
<example>
dataSource.setExtensionProperty("odaUser", <Username
from properties>);
String decodedPassword = decodeString(<Encrypted
password from properties>);
dataSource.setExtensionProperty("odaPassword",
decodedPassword);
dataSource.setExtensionProperty("odaURL", <URL from
properties>);
</example>
The translated adapter (.JAR) has to be placed within the ScriptLib
directory of the WebViewer.
Works fine for me...
Regards
Norbert
"Anuradha" <kale.anuradha@gmail.com> schrieb im Newsbeitrag
news:f9sldb$hh1$1@build.eclipse.org...
> Thank you Don.
> But I also want to read the database name, username and password for
> database from properties file instead of hardcoding it here in .rptdesign
> file.
>
> Please provide me inputs on how I can achieve that.
>
> Regards,
> Anuradha.
>
> "Don Bergstrom" <monsterdon@gmail.com> wrote in message
> news:f9sier$l2e$1@build.eclipse.org...
>> 1. Define the JNDI URL in your reports (The .rptdesign file).
>> 2. Configure the corresponding JNDI datasource in you JBoss application
>> server.
>>
>>
>> Anuradha wrote:
>>> Hi,
>>> I have integrated BIRT viewer with JBoss application server.
>>> I have also created *.rptdesign file.
>>>
>>> My .rptdesign file contains
>>> 1. DataSource
>>> 2. Dataset
>>> 3. Few input parameters
>>> 4. Result grids and tables
>>>
>>> My requirement is that i want to create BIRT datasources dynamically
>>> depending on inputs from one properties file.
>>> In simple words, I don't want to hard code dababase connection
>>> information inside .rptdesign file.
>>>
>>>
>>> Please let me know how to configure datasource for the .rptdesign file
>>> which has dataset ready in it?
>>>
>>> Regards,
>>> Anuradha.
>>>
>>>
>>>
>
|
|
|
| Re: How to configure datasource in BIRT Viewer [message #252558 is a reply to message #252398] |
Wed, 15 August 2007 16:45 |
| Eclipse User |
|
|
|
Originally posted by: kale.anuradha.gmail.com
Hi,
Thank you for your inputs.
1. I tried to use JNDI name by putting the JNDI datasource name as
"java:Local_DS" in the JNDI url textbox of my BIRT datasource. Let's say
this points to DATABASE 1.
I could see the output report (data is from DATABASE 1).
2. As said by Don in earlier post,
The JNDI URL parametere will override the parameters you have defined for
Driver Class, Database URL, User Name, and Password.
So for the testing purpose I put Driver Class, Database URL, User Name, and
Password to point to say DATABASE 2.
I did this b'coz I want to verify whether JNDI url in Birt datasource is
really being used and not the Driver Class, Database URL, User Name, and
Password attributes.
But I am getting the following warning.
INFO: Sampledb plugin starts up. Current startCount=0
11:27:02,661 INFO [STDOUT] Aug 15, 2007 11:27:02 AM
org.eclipse.birt.report.data.oda.sampledb.Sampl
edbPlugin init
INFO: Creating Sampledb database at location
C:\DOCUME~1\ak\LOCALS~1\Temp\/BIRTSampleDB_118719522266
1_10a1543
11:27:19,636 WARN [JBossManagedConnectionPool] Destroying connection that
could not be successfully
matched:
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@96d2c2[
state=NORMAL
mc= org.jboss.resource.adapter.jdbc.local.LocalManagedConnection @816436
handles=0 lastUs
e=1187195209753 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.JBossManagedCo
nnectionPool$OnePool@da2e1a
context=org.jboss.resource.connectionmanager.InternalManaged ConnectionPo
ol@8ee06]
11:27:20,197 WARN [JBossManagedConnectionPool] Throwable while attempting
to get a new connection:
null
org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (java.sq
l.SQLException: ORA-01017: invalid username/password; logon denied
)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnection Factory.createManagedConnecti
on(LocalManagedConnectionFactory.java:161)
at
org.jboss.resource.connectionmanager.InternalManagedConnecti onPool.createConnectionEventL
istener(InternalManagedConnectionPool.java:508)
at
org.jboss.resource.connectionmanager.InternalManagedConnecti onPool.getConnection(Internal
ManagedConnectionPool.java:207)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionP ool$BasePool.getConnection(JB
ossManagedConnectionPool.java:534)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2. getManagedConnection(BaseConn
ectionManager2.java:396)
at
org.jboss.resource.connectionmanager.TxConnectionManager.get ManagedConnection(TxConnectio
nManager.java:299)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2. allocateConnection(BaseConnec
tionManager2.java:448)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ ConnectionManagerProxy.alloca
teConnection(BaseConnectionManager2.java:838)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnect ion(WrapperDataSource.java:12
2)
at
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getData SourceConnection(JndiDataSour
ce.java:159)
at
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getConn ection(JndiDataSource.java:13
3)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getJ ndiDSConnection(JDBCDriverMan
ager.java:215)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:
172)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.j
ava:146)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:150)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:111)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.j
ava:235)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManag
er.java:149)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:134)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:121)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.j
ava:214)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:265)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:210)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:486)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery
..java:161)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:142)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessi
onImpl.java:423)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:1
49)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:1
15)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.jav
a:178)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.ja
va:1678)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.
java:82)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:
61)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(W
rappedReportItemExecutor.java:45)
at
org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execut
e(SuppressDuplicateItemExecutor.java:42)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(W
rappedReportItemExecutor.java:45)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute
(LocalizedReportItemExecutor.java:33)
at
org.eclipse.birt.report.engine.layout.content.BlockStackingE xecutor.getNextChild(BlockSta
ckingExecutor.java:48)
at
org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM .traverseChildren(PDFBlockSta
ckingLM.java:86)
at
org.eclipse.birt.report.engine.layout.pdf.PDFStackingLM.layo utChildren(PDFStackingLM.java
:118)
at
org.eclipse.birt.report.engine.layout.pdf.PDFPageLM.layout(P DFPageLM.java:212)
at
org.eclipse.birt.report.engine.layout.pdf.PDFReportLayoutEng ine.layoutReport(PDFReportLay
outEngine.java:64)
at
org.eclipse.birt.report.engine.layout.pdf.PDFReportLayoutEng ine.layout(PDFReportLayoutEng
ine.java:87)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:148)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:71)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source)
at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source
)
at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unk
nown Source)
at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
S
ource)
at
org.eclipse.birt.report.presentation.aggregation.layout.RunF ragment.doService(Unknown
Sou
rce)
at
org.eclipse.birt.report.presentation.aggregation.layout.Fram esetFragment.service(Unknown
Source)
at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(Unknow n
Source)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doGet(Unknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.j
ava:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:157)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.j
ava:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal (StandardContextValve.java:19
8)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:66)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.ja
va:153)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:54)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte r.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11P
rotocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password;
logon denied
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(Oracle Driver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:31 4)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnection Factory.createManagedConnecti
on(LocalManagedConnectionFactory.java:151)
... 89 more
Please let me know if anybody knows the cause of this.
Regards,
Anuradha.
"Don Bergstrom" <monsterdon@gmail.com> wrote in message
news:f9sre0$92c$1@build.eclipse.org...
> The JNDI URL parametere will override the parameters you have defined for
> Driver Class, Database URL, User Name, and Password. All of our reports
> have different values for those parameters depending on which developed
> designed the report. You need to define them when you are creating you
> report in order to test it.
>
> When you define a JNDI URL parameter, the report viewer to look for a
> corresponding JNDI definition in you application server configuration.
> There are several ways to define a JNDI datasoure, you will need to
> determine the best way for your particular implementation.
>
> Example:
> We are deploying the report viewer on an apache/tomcat instance. All of
> our reports have the JNDI URL defined as java:comp/env/jdbc/MYDB. We
> deploy the report viewer as a war file and in the
> tomcat/conf/Catalina/localhost directory we have a file "reportview.xml"
> that corresponds to our reportviewer.war file. in the xml file we have the
> following definition:
>
> <Context
> className="org.apache.catalina.core.StandardContext"
> cachingAllowed="true"
> charsetMapperClass="org.apache.catalina.util.CharsetMapper"
> cookies="true"
> crossContext="false"
> debug="10"
> displayName="Report Viewer"
> mapperClass="org.apache.catalina.core.StandardContextMapper "
> path="/reportviewer"
> privileged="false"
> reloadable="false"
> swallowOutput="false"
> useNaming="true"
> wrapperClass="org.apache.catalina.core.StandardWrapper">
>
> <Resource name="jdbc/MYDB"
> auth="Container" type="javax.sql.DataSource"
> maxActive="100" maxIdle="25" maxWait="10000"
> username="DB_USER" password="DB_PASSWORD"
> driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@DB_SERVER:1521:DB_NAME"/>
> </Context>
>
> Also, this has been discussed before in previous posts. Look for the JNDI
> discussions.
>
>
>
>
> Anuradha wrote:
>> Thank you Don.
>> But I also want to read the database name, username and password for
>> database from properties file instead of hardcoding it here in .rptdesign
>> file.
>>
>> Please provide me inputs on how I can achieve that.
>>
>> Regards,
>> Anuradha.
>>
>> "Don Bergstrom" <monsterdon@gmail.com> wrote in message
>> news:f9sier$l2e$1@build.eclipse.org...
>>> 1. Define the JNDI URL in your reports (The .rptdesign file).
>>> 2. Configure the corresponding JNDI datasource in you JBoss application
>>> server.
>>>
>>>
>>> Anuradha wrote:
>>>> Hi,
>>>> I have integrated BIRT viewer with JBoss application server.
>>>> I have also created *.rptdesign file.
>>>>
>>>> My .rptdesign file contains
>>>> 1. DataSource
>>>> 2. Dataset
>>>> 3. Few input parameters
>>>> 4. Result grids and tables
>>>>
>>>> My requirement is that i want to create BIRT datasources dynamically
>>>> depending on inputs from one properties file.
>>>> In simple words, I don't want to hard code dababase connection
>>>> information inside .rptdesign file.
>>>>
>>>>
>>>> Please let me know how to configure datasource for the .rptdesign file
>>>> which has dataset ready in it?
>>>>
>>>> Regards,
>>>> Anuradha.
>>>>
>>>>
>>>>
>>
|
|
|
Goto Forum:
Current Time: Fri Apr 26 00:19:17 GMT 2024
Powered by FUDForum. Page generated in 0.03381 seconds |
] 
Search
Help
Register
Login
Home
