Eclipse Community Forums: BIRT » JDBC DRIVER CLASS

Help

Home

Home » Archived » BIRT » JDBC DRIVER CLASS(JDBC DRIVER CLASS)

Show: Today's Messages :: Show Polls :: Message Navigator

JDBC DRIVER CLASS [message #677004]

Tue, 07 June 2011 09:49

jeyinul

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.

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677195 is a reply to message #677004]

Tue, 07 June 2011 18:02

Jason Weathersby

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.

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677398 is a reply to message #677195]

Wed, 08 June 2011 11:57

jeyinul

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.

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677536 is a reply to message #677398]

Wed, 08 June 2011 18:35

Jason Weathersby

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.

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677650 is a reply to message #677536]

Thu, 09 June 2011 04:31

jeyinul

Messages: 60
Registered: June 2011

Member

Thanks Jason,

Thank you very much.

Its working fine.

Regards,
Jeyinul.

Report message to a moderator

Re: JDBC DRIVER CLASS [message #677654 is a reply to message #677650]

Thu, 09 June 2011 04:41

jeyinul

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

jeyinul

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 <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>

Report message to a moderator

Previous Topic:	The viewing session is not available or has expired
Next Topic:	Report viewer Export report option is not working properly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:38:32 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter