Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » JDBC DRIVER CLASS(JDBC DRIVER CLASS)
JDBC DRIVER CLASS [message #677004] Tue, 07 June 2011 09:49 Go to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
HI ALL,


I AM USING BIRT TOOL. I AM TRYING TO USE JDBC DATASOURCE. THE CONNECTION IS SUCCESSFUL. BUT I AM GETTING ERROR SAYING THAT

"Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc."

I DON'T KNOW WHY THIS ERROR IS COMING. PLZ HELP ON THIS.

THANKS.
Re: JDBC DRIVER CLASS [message #677195 is a reply to message #677004] Tue, 07 June 2011 18:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Are you getting the error in the designer or when the report is deployed?

Jason

On 6/7/2011 5:49 AM, jeyinul wrote:
> HI ALL,
>
>
> I AM USING BIRT TOOL. I AM TRYING TO USE JDBC DATASOURCE. THE CONNECTION
> IS SUCCESSFUL. BUT I AM GETTING ERROR SAYING THAT
> "Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc."
>
> I DON'T KNOW WHY THIS ERROR IS COMING. PLZ HELP ON THIS.
>
> THANKS.
Re: JDBC DRIVER CLASS [message #677398 is a reply to message #677195] Wed, 08 June 2011 11:57 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Thanks Jason,

Thanks for your reply.

I am getting the error when the report is deployed.

Plz help.

Thanks,
Jeyinul.
Re: JDBC DRIVER CLASS [message #677536 is a reply to message #677398] Wed, 08 June 2011 18:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Do you have your jdbc driver copied to the runtime? If you are using
the viewer it should be in the
WebViewerExample\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
directory.

Jason

On 6/8/2011 7:57 AM, jeyinul wrote:
> Thanks Jason,
>
> Thanks for your reply.
>
> I am getting the error when the report is deployed.
>
> Plz help.
>
> Thanks,
> Jeyinul.
Re: JDBC DRIVER CLASS [message #677650 is a reply to message #677536] Thu, 09 June 2011 04:31 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Thanks Jason,

Thank you very much.

Its working fine.

Regards,
Jeyinul.
Re: JDBC DRIVER CLASS [message #677654 is a reply to message #677650] Thu, 09 June 2011 04:41 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
Dear Jason,

Now I am trying to use Drill-Through option in Hyperlink.

When i deployed the report i am getting error when i click the hyperlink saying that "Keys Manipulated"

i.e. First report is working fine. it displays correct records. in that records, one column is having hyperlink to connect another report.

here is the problem.

Can you help me on this.

Thanks,
Jeyinul.

[Updated on: Thu, 09 June 2011 10:07]

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677690 is a reply to message #677654] Thu, 09 June 2011 07:10 Go to previous message
jeyinul  is currently offline jeyinul Friend
Messages: 60
Registered: June 2011
Member
plz look on xml file


<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.5.0.v20090603 Build &lt;2.5.0.v20090617-0630></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="SearchParam" id="44">
<text-property name="promptText">Search</text-property>
<property name="valueType">static</property>
<expression name="sortByColumn">dataSetRow["PROJECTNAME"]</expression>
<property name="sortDirection">asc</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source1" id="25">
<method name="beforeOpen"><![CDATA[reportContext.getAppContext().put("OdaJDBCDriverClassPath","D:\oracle\product\10.2.0\db\jdbc\lib\ojdbc14.jar");]]></method>
<property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:mave_digite/mave_digite@127.0.0.1:1521:orcl</property>
<property name="odaUser">mave_digite</property>
<encrypted-property name="odaPassword" encryptionID="base64">bWF2ZV9kaWdpdGU=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="27">
<list-property name="columnHints">
<structure>
<property name="columnName">PROJECTID</property>
<property name="displayName">PROJECTID</property>
</structure>
<structure>
<property name="columnName">PROJECTNAME</property>
<property name="displayName">PROJECTNAME</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PROJECTID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PROJECTNAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source1</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PROJECTID</property>
<property name="nativeName">PROJECTID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PROJECTNAME</property>
<property name="nativeName">PROJECTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select projectid,projectname
from project]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table name="mydataelement" id="28">
<property name="backgroundColor">aqua</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PROJECTID</property>
<expression name="expression">dataSetRow["PROJECTID"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">PROJECTNAME</property>
<expression name="expression">dataSetRow["PROJECTNAME"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">like</property>
<expression name="expr">row["PROJECTNAME"]</expression>
<simple-property-list name="value1">
<value>'%'+params["SearchParam"].value + '%'</value>
</simple-property-list>
</structure>
</list-property>
<column id="38"/>
<column id="39"/>
<header>
<row id="29">
<cell id="30">
<label id="40">
<text-property name="text">PROJECTID</text-property>
</label>
</cell>
<cell id="31">
<label id="42">
<text-property name="text">PROJECTNAME</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="32">
<cell id="33">
<data id="41">
<property name="resultSetColumn">PROJECTID</property>
</data>
</cell>
<cell id="34">
<data id="43">
<property name="resultSetColumn">PROJECTNAME</property>
<structure name="action">
<property name="linkType">drill-through</property>
<property name="reportName">12201_12140_new_report_jdbc.rptdesign</property>
<expression name="targetBookmark">row["PROJECTNAME"]</expression>
<property name="targetBookmarkType">toc</property>
<property name="targetWindow">_self</property>
<property name="targetFileType">report-design</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">SearchParam</property>
<expression name="expression">row["PROJECTNAME"]</expression>
</structure>
</list-property>
</structure>
</data>
</cell>
</row>
</detail>
</table>
</body>
</report>
Previous Topic:Hyperlink/bookmark not working
Next Topic:Report viewer Export report option is not working properly
Goto Forum:
  


Current Time: Sat Dec 20 06:43:54 GMT 2014

Powered by FUDForum. Page generated in 0.06159 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software