[birt-dev] Problems Generating report from Java with connection to Oracl

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

[birt-dev] Problems Generating report from Java with connection to Oracle 10g

From: Johnny Gonzalez <johnnygonzalezl@xxxxxxxx>
Date: Mon, 21 Aug 2006 17:46:24 +0200 (CEST)
Delivered-to: birt-dev@xxxxxxxxxxx
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.es; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=SoC8srK6Mqpb3GdjBIL6rJuRJMFpJATXQvPA5h0cU9VblGCGTx/A63qgjxKZ1/T5ihPjF8WtbdhnNUO8zAgj04GDOawsUYL6AHS1uhpn/dXYGQrn1ueH2kYbh9f8S2QfZaqC7+0a1LGesmeRCDQcnu00+5iMSpr7eSHzgk01uyY= ;
List-archive: <http://eclipse.org/pipermail/birt-dev>
List-help: <mailto:birt-dev-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/birt-dev>, <mailto:birt-dev-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/listinfo/birt-dev>, <mailto:birt-dev-request@eclipse.org?subject=unsubscribe>

Hello everybody, I posted a question last week but I didn't get any response, so I'm writting again.

I have done 6 reports that must connect to an Oracle 10g DB, but I have noticed a couple of strange behaviours:

1. after creating datasource I installed the required driver, and the connection test succeeds without problems, info in datasource config is:

Driver Class: oracle.jdbc.OracleDriver (v10.2)

Database URL: jdbc:oracle:thin:@localhost:1521:SEC

User name: system

Password: **********

- In dataset config I have set my query, but I have noticed that in the Available Items section don't appear all tables that I have in my DB, there only appear 2 of the about 8 tables I have, why??

- If I go to the Preview Results Section I don't get any output, but If I try the same Query directly in Oracle's 10g SQLPlus, I get the results as expected, Why it doesn't work from Eclipse BIRT plugin?

2. The first time I did my report design I had this structure at the beginning of the file:

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build <20051201-1157></property>
    <property name="units">in</property>
    <template-parameter-definitions>
        <template-parameter-definition name="NuevoTemplateParameterDefinition" id="33">
            <property name="allowedType">Text</property>
            <text-property name="description">Reporte Usuarios Registrados a la Fecha</text-property>
            <default>
                <text id="34">
                    <property name="fontFamily">Bitstream Vera Sans</property>
                    <property name="fontSize">12pt</property>
                    <property name="fontWeight">bold</property>
                    <property name="textAlign">right</property>
                    <property name="contentType">plain</property>
                </text>
            </default>
        </template-parameter-definition>
    </template-parameter-definitions>
<list-property name="propertyBindings">
        <structure>
            <property name="name">odaDriverClass</property>
            <property name="id">4</property>
            <_expression_ name="value">oracle.jdbc.OracleDriver (v10.2)

</_expression_>
        </structure>
        <structure>
            <property name="name">odaURL</property>
            <property name="id">4</property>
            <_expression_

name="value">jdbc:oracle:thin:@localhost:1521:SEC</_expression_>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">4</property>
            <_expression_ name="value">system</_expression_>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">4</property>
            <_expression_ name="value">password</_expression_>
        </structure>
        <structure>
            <property name="name">odaJndiName</property>
            <property name="id">4</property>
        </structure>
    </list-property>

    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Fuente de datos" id="4">
            <property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
            <property name="odaURL">jdbc:oracle:thin:@localhost:1521:SEC</property>
            <property name="odaUser">system</property>
            <encrypted-property name="odaPassword">cGFzc3dvcmQ=</encrypted-property>
            <property name="odaJndiName">secdb</property>
        </oda-data-source>
    </data-sources>
    <data-sets>

If I execute this report from Java, I get an error like this:

The following items have errors:

OdaDataSource Fuente de datos:

- Error evaluating _javascript_ _expression_. Script engine error: ReferenceError: "password" is not defined.
Script source: property binding, line: 0, text:
password

birt.core._javascript_Error ( 1 time(s) )  detail : org.eclipse.birt.core.exception.CoreException: Error evaluating _javascript_ _expression_. Script engine error: ReferenceError: "password" is not defined.
 Script source: property
 binding, line: 0, text:
password
 at org.eclipse.birt.core.script._javascript_EvalUtil.wrapRhinoException(_javascript_EvalUtil.java:280)
 at org.eclipse.birt.core.script._javascript_EvalUtil.evaluateRawScript(_javascript_EvalUtil.java:104)
 at org.eclipse.birt.core.script._javascript_EvalUtil.evaluateScript(_javascript_EvalUtil.java:136)
 at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.evaluatePropertyBindingExpr(ModelDteApiAdapter.java:274)
 at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.newOdaDataSource(ModelDteApiAdapter.java:321)
 at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.createDataSourceDesign(ModelDteApiAdapter.java:179)
 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:152)
 at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:101)
 at
 org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:38)
 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:68)
 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:187)
 at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source)
 at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source)
 at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source)
 at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source)
 at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
 at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source)
 at
 org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source)
 at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source)
 at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:595)
Caused by: org.mozilla._javascript_.EcmaError: ReferenceError: "password" is not defined.
 at org.mozilla._javascript_.ScriptRuntime.constructError(ScriptRuntime.java:3240)
 at org.mozilla._javascript_.ScriptRuntime.constructError(ScriptRuntime.java:3230)
 at
 org.mozilla._javascript_.ScriptRuntime.notFoundError(ScriptRuntime.java:3303)
 at org.mozilla._javascript_.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1632)
 at org.mozilla._javascript_.ScriptRuntime.name(ScriptRuntime.java:1571)
 at org.mozilla._javascript_.gen.c57._c0(property binding:0)
 at org.mozilla._javascript_.gen.c57.call(property binding)
 at org.mozilla._javascript_.ContextFactory.doTopCall(ContextFactory.java:304)
 at org.mozilla._javascript_.ScriptRuntime.doTopCall(ScriptRuntime.java:2769)
 at org.mozilla._javascript_.gen.c57.call(property binding)
 at org.mozilla._javascript_.gen.c57.exec(property binding)
 at org.eclipse.birt.core.script._javascript_EvalUtil.evaluateRawScript(_javascript_EvalUtil.java:97)
 ... 52 more

why?

I had to remove the tag <list-property name="propertyBindings">, Now I don't get any errors when I execute the report, but I don't get any results in the report output either :(

Any help would be very appreciated,

Johnny

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

Prev by Date: [birt-dev] Checkin: fix bug 154498: Name of new data column binding title and default column name
Next by Date: [birt-dev] Problems with ouput to CSV format from java
Previous by thread: [birt-dev] Checkin: fix bug 154498: Name of new data column binding title and default column name
Next by thread: [birt-dev] Problems with ouput to CSV format from java
Index(es):
- Date
- Thread

Breadcrumbs