Home » Archived » BIRT » Error when running current BIRT from CVS
| Error when running current BIRT from CVS [message #15282] |
Mon, 07 March 2005 16:30  |
Eclipse User |
|
|
|
I've got the current BIRT checked out from CVS. I've added ojdbc14.jar to
org.eclipse.birt.report.data.oda.jdbc, and added jodbc14.jar to
odaconfig.xml in the same project. I'm able to create a data source and
start on a dataset, but I get the following error when trying to do anything
with the data set.
org.eclipse.birt.data.engine.core.DataException occurred
Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
Error Message:org.eclipse.birt.report.data.oda.jdbc.JDBCConnection Factory
cannot be found or cannot be instantiated.
Unable to create the ODA driver's connection factory.
org.eclipse.birt.report.data.oda.jdbc.JDBCConnectionFactory
Any ideas?
|
|
| | | | | | | |
| Re: Error when running current BIRT from CVS [message #16709 is a reply to message #16694] |
Wed, 09 March 2005 17:19  |
| Eclipse User |
|
|
|
Do you have any special characters in names?
Can you provide your query which fails?
I have the following and it works.
SELECT "DEMO"."DEPARTMENT"."DEPARTMENT_ID",
"DEMO"."DEPARTMENT"."NAME",
"DEMO"."DEPARTMENT"."LOCATION_ID",
"DEMO"."EMPLOYEE"."EMPLOYEE_ID",
"DEMO"."EMPLOYEE"."LAST_NAME",
"DEMO"."EMPLOYEE"."FIRST_NAME",
"DEMO"."EMPLOYEE"."MIDDLE_INITIAL",
"DEMO"."EMPLOYEE"."JOB_ID",
"DEMO"."EMPLOYEE"."MANAGER_ID",
"DEMO"."EMPLOYEE"."HIRE_DATE",
"DEMO"."EMPLOYEE"."SALARY",
"DEMO"."EMPLOYEE"."COMMISSION"
FROM ("DEMO"."DEPARTMENT" INNER JOIN "DEMO"."EMPLOYEE" ON
"DEMO"."DEPARTMENT"."DEPARTMENT_ID" = "DEMO"."EMPLOYEE"."DEPARTMENT_ID" )
Also file a bugzilla entry with the query so that somebody can look at
it to see whether it is a bug.
Roshan
Thierry Lach wrote:
> I'm not having the problem with SQL*Plus. It runs there just fine. The
> query is failing when run inside of BIRT.
>
>
> "Roshan" <rail@actuate.com> wrote in message
> news:d0l8v7$3b2$1@www.eclipse.org...
>
>>I think I know what your problem might be.
>>Did you put a semi colon at the end of the query.
>>If I remember correctly then sql plus expects a semi colon at the end.
>>If you pasted it directly then that might be the problem.
>>Remove the semi colon.
>>
>>
>>Roshan
>>
>>
>>
>>Thierry Lach wrote:
>>
>>>Further information. I can open the "Edit Data Set" window and take the
>>>query sql there and run it directly in Oracle's SQL*Plus tool, so the
>
> sql
>
>>>itself appears to be fine.
>>>
>>>
>>>"Thierry Lach" <thierry.lach@bbdodetroit.com> wrote in message
>>>news:d0l35b$7ba$1@www.eclipse.org...
>>>
>>>
>>>>It's a join. Non-join queries work fine (as you indicate). I'm using
>
> the
>
>>>>ojdbc14.jar that was bundled with the recent M1 release of BIRT (in the
>>>>engine jar).
>>>>
>>>>
>>>>"Roshan" <rail@actuate.com> wrote in message
>>>>news:d0l1p7$j3$1@www.eclipse.org...
>>>>
>>>>
>>>>>I can connect to oracle 9.0.1 using the thin driver and it seems to
>
> work
>
>>>>>without any issues.
>>>>>Try checking your query.
>>>>>The query I used was a simple one "select * from ITEMS".
>>>>>I used the thin driver in classes12.zip from
>>>>>
>>>>
> http://www.oracle.com/technology/software/tech/java/sqlj_jdb c/htdocs/jdbc901.html
>
>>>>>Maybe it fails with a different version of the database.
>>>>>It could also be a driver issue.
>>>>>I am not sure.
>>>>>
>>>>>Can you try the thin driver if you are not using it?
>>>>>If it fails only for specific queries then can you provide an example.
>>>>>
>>>>>
>>>>>Roshan
>>>>>
>>>>>
>>>>>
>>>>>Thierry Lach wrote:
>>>>>
>>>>>
>>>>>>OK that worked (sort of).
>>>>>>
>>>>>>It works fine for MYSQL. But under Oracle I get
>>>>>>
>>>>>>org.eclipse.birt.data.engine.core.DataException occurred
>>>>>>Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
>>>>>> Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
>>>>>> Error Message:Cannot get the result set metadata.
>>>>>> A JDBC Exception occured: ORA-00933: SQL command not properly ended
>>>>>>
>>>>>> ORA-00933: SQL command not properly ended
>>>>>>
>>>>>>I'm fairly confident that this is because oracle is not completely
>>>>
>>>>supported
>>>>
>>>>
>>>>>>yet, and I'd be willing to try to deal with that. But I'm not
>>>
>>>familiar
>>>
>>>
>>>>>>enough with the code to know where to start looking. Any suggestions?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>"Roshan" <rail@actuate.com> wrote in message
>>>>>>news:d0il4h$lpt$1@www.eclipse.org...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hi Thierry,
>>>>>>>
>>>>>>>The oda-config.xml file refers to the oda-jdbc.jar file.
>>>>>>>This jar file needs to be built before you run the application.
>>>>>>>You can build this by just running the build.xml under the
>>>>>>>org.eclipse.birt.report.data.oda.jdbc project.
>>>>>>>
>>>>>>>Alternatively you can run the viewer's build.xml file.
>>>>>>>This will build the jars for all the required projects and copy them
>>>>>>>over to the viewer as well so that you can run the preview.
>>>>>>>
>>>>>>>The full build instructions are at
>>>>>>>
>>>>>>> http://eclipse.org/birt/index.php?page=build/build_instr.htm l
>>>>>>>
>>>>>>>
>>>>>>>Roshan
>>>>>>>
>>>>>>>
>>>>>>>Thierry Lach wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>I've got the current BIRT checked out from CVS. I've added
>>>
>>>ojdbc14.jar
>>>
>>>
>>>>>>to
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>org.eclipse.birt.report.data.oda.jdbc, and added jodbc14.jar to
>>>>>>>>odaconfig.xml in the same project. I'm able to create a data source
>>>>
>>>>and
>>>>
>>>>
>>>>>>>>start on a dataset, but I get the following error when trying to do
>>>>>>
>>>>>>anything
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>with the data set.
>>>>>>>>
>>>>>>>>org.eclipse.birt.data.engine.core.DataException occurred
>>>>>>>>Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
>>>>>>>>Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
>>>>>>>>Error
>>>>>>
>>>>>> Message:org.eclipse.birt.report.data.oda.jdbc.JDBCConnection Factory
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>cannot be found or cannot be instantiated.
>>>>>>>>Unable to create the ODA driver's connection factory.
>>>>>>>>org.eclipse.birt.report.data.oda.jdbc.JDBCConnectionFactory
>>>>>>>>
>>>>>>>>Any ideas?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>
>
>
|
|
|
| Re: Error when running current BIRT from CVS [message #17518 is a reply to message #16709] |
Thu, 10 March 2005 10:05 |
| Eclipse User |
|
|
|
OK, one of the more recent changes must have fixed it. It runs now.
Just for reference:
SELECT "GENWEBREG11_QA"."ATTENDEE"."FIRST_NAME",
"GENWEBREG11_QA"."ATTENDEE"."LAST_NAME",
"GENWEBREG11_QA"."ATTENDEE"."MID_INITIAL",
"GENWEBREG11_QA"."ATTENDEE"."AGE",
"GENWEBREG11_QA"."REGISTRATION"."INVITATION_CD",
"GENWEBREG11_QA"."REGISTRATION"."REGISTRATION_ID"
FROM ("GENWEBREG11_QA"."REGISTRATION" INNER JOIN "GENWEBREG11_QA"."ATTENDEE"
ON "GENWEBREG11_QA"."REGISTRATION"."REGISTRATION_ID" =
"GENWEBREG11_QA"."ATTENDEE"."REGISTRATION_ID" )
"Roshan" <rail@actuate.com> wrote in message
news:d0ntef$6h2$1@www.eclipse.org...
> Do you have any special characters in names?
> Can you provide your query which fails?
> I have the following and it works.
>
> SELECT "DEMO"."DEPARTMENT"."DEPARTMENT_ID",
> "DEMO"."DEPARTMENT"."NAME",
> "DEMO"."DEPARTMENT"."LOCATION_ID",
> "DEMO"."EMPLOYEE"."EMPLOYEE_ID",
> "DEMO"."EMPLOYEE"."LAST_NAME",
> "DEMO"."EMPLOYEE"."FIRST_NAME",
> "DEMO"."EMPLOYEE"."MIDDLE_INITIAL",
> "DEMO"."EMPLOYEE"."JOB_ID",
> "DEMO"."EMPLOYEE"."MANAGER_ID",
> "DEMO"."EMPLOYEE"."HIRE_DATE",
> "DEMO"."EMPLOYEE"."SALARY",
> "DEMO"."EMPLOYEE"."COMMISSION"
> FROM ("DEMO"."DEPARTMENT" INNER JOIN "DEMO"."EMPLOYEE" ON
> "DEMO"."DEPARTMENT"."DEPARTMENT_ID" = "DEMO"."EMPLOYEE"."DEPARTMENT_ID" )
>
> Also file a bugzilla entry with the query so that somebody can look at
> it to see whether it is a bug.
>
>
>
> Roshan
>
>
> Thierry Lach wrote:
> > I'm not having the problem with SQL*Plus. It runs there just fine. The
> > query is failing when run inside of BIRT.
> >
> >
> > "Roshan" <rail@actuate.com> wrote in message
> > news:d0l8v7$3b2$1@www.eclipse.org...
> >
> >>I think I know what your problem might be.
> >>Did you put a semi colon at the end of the query.
> >>If I remember correctly then sql plus expects a semi colon at the end.
> >>If you pasted it directly then that might be the problem.
> >>Remove the semi colon.
> >>
> >>
> >>Roshan
> >>
> >>
> >>
> >>Thierry Lach wrote:
> >>
> >>>Further information. I can open the "Edit Data Set" window and take
the
> >>>query sql there and run it directly in Oracle's SQL*Plus tool, so the
> >
> > sql
> >
> >>>itself appears to be fine.
> >>>
> >>>
> >>>"Thierry Lach" <thierry.lach@bbdodetroit.com> wrote in message
> >>>news:d0l35b$7ba$1@www.eclipse.org...
> >>>
> >>>
> >>>>It's a join. Non-join queries work fine (as you indicate). I'm using
> >
> > the
> >
> >>>>ojdbc14.jar that was bundled with the recent M1 release of BIRT (in
the
> >>>>engine jar).
> >>>>
> >>>>
> >>>>"Roshan" <rail@actuate.com> wrote in message
> >>>>news:d0l1p7$j3$1@www.eclipse.org...
> >>>>
> >>>>
> >>>>>I can connect to oracle 9.0.1 using the thin driver and it seems to
> >
> > work
> >
> >>>>>without any issues.
> >>>>>Try checking your query.
> >>>>>The query I used was a simple one "select * from ITEMS".
> >>>>>I used the thin driver in classes12.zip from
> >>>>>
> >>>>
> >
http://www.oracle.com/technology/software/tech/java/sqlj_jdb c/htdocs/jdbc901.html
> >
> >>>>>Maybe it fails with a different version of the database.
> >>>>>It could also be a driver issue.
> >>>>>I am not sure.
> >>>>>
> >>>>>Can you try the thin driver if you are not using it?
> >>>>>If it fails only for specific queries then can you provide an
example.
> >>>>>
> >>>>>
> >>>>>Roshan
> >>>>>
> >>>>>
> >>>>>
> >>>>>Thierry Lach wrote:
> >>>>>
> >>>>>
> >>>>>>OK that worked (sort of).
> >>>>>>
> >>>>>>It works fine for MYSQL. But under Oracle I get
> >>>>>>
> >>>>>>org.eclipse.birt.data.engine.core.DataException occurred
> >>>>>>Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> >>>>>> Error Code:DATA_EXCEPTION_odaconsumer.CannotGetResultSetMetaData
> >>>>>> Error Message:Cannot get the result set metadata.
> >>>>>> A JDBC Exception occured: ORA-00933: SQL command not properly ended
> >>>>>>
> >>>>>> ORA-00933: SQL command not properly ended
> >>>>>>
> >>>>>>I'm fairly confident that this is because oracle is not completely
> >>>>
> >>>>supported
> >>>>
> >>>>
> >>>>>>yet, and I'd be willing to try to deal with that. But I'm not
> >>>
> >>>familiar
> >>>
> >>>
> >>>>>>enough with the code to know where to start looking. Any
suggestions?
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>"Roshan" <rail@actuate.com> wrote in message
> >>>>>>news:d0il4h$lpt$1@www.eclipse.org...
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>Hi Thierry,
> >>>>>>>
> >>>>>>>The oda-config.xml file refers to the oda-jdbc.jar file.
> >>>>>>>This jar file needs to be built before you run the application.
> >>>>>>>You can build this by just running the build.xml under the
> >>>>>>>org.eclipse.birt.report.data.oda.jdbc project.
> >>>>>>>
> >>>>>>>Alternatively you can run the viewer's build.xml file.
> >>>>>>>This will build the jars for all the required projects and copy
them
> >>>>>>>over to the viewer as well so that you can run the preview.
> >>>>>>>
> >>>>>>>The full build instructions are at
> >>>>>>>
> >>>>>>> http://eclipse.org/birt/index.php?page=build/build_instr.htm l
> >>>>>>>
> >>>>>>>
> >>>>>>>Roshan
> >>>>>>>
> >>>>>>>
> >>>>>>>Thierry Lach wrote:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>>I've got the current BIRT checked out from CVS. I've added
> >>>
> >>>ojdbc14.jar
> >>>
> >>>
> >>>>>>to
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>org.eclipse.birt.report.data.oda.jdbc, and added jodbc14.jar to
> >>>>>>>>odaconfig.xml in the same project. I'm able to create a data
source
> >>>>
> >>>>and
> >>>>
> >>>>
> >>>>>>>>start on a dataset, but I get the following error when trying to
do
> >>>>>>
> >>>>>>anything
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>with the data set.
> >>>>>>>>
> >>>>>>>>org.eclipse.birt.data.engine.core.DataException occurred
> >>>>>>>>Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
> >>>>>>>>Error Code:DATA_EXCEPTION_odaconsumer.OdaInitEntryNotFound
> >>>>>>>>Error
> >>>>>>
> >>>>>> Message:org.eclipse.birt.report.data.oda.jdbc.JDBCConnection Factory
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>>cannot be found or cannot be instantiated.
> >>>>>>>>Unable to create the ODA driver's connection factory.
> >>>>>>>>org.eclipse.birt.report.data.oda.jdbc.JDBCConnectionFactory
> >>>>>>>>
> >>>>>>>>Any ideas?
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>
> >
> >
|
|
|
Goto Forum:
Current Time: Sun Jul 27 04:40:36 EDT 2025
Powered by FUDForum. Page generated in 0.05326 seconds |
Home