Reporting orinetDB

kae

unread,

Jun 20, 2012, 2:23:46 AM6/20/12

to orient-...@googlegroups.com

Hello,

i am looking for a Reportingtool for OrinetDB. I think for the graphpart we can use gephi, but for a simple list what's the best Tool.
me favorit will be Jasper.
There are a other tool how works with Orinetdb.

Thank's in adwance for help and idee's

Karl

Artem Orobets

unread,

Jun 20, 2012, 5:58:47 AM6/20/12

to orient-...@googlegroups.com

Hi Karl!

OrientDB has JDBC driver (https://github.com/robfrank/orientdb-jdbc), so JasperReports can be used.

If your report requires complicated data processing that can't be done by single orient SQL query execution, you can create custom JRDataSource.

Best regards,

Artem Orobets

2012/6/20 kae <karl.es...@gmail.com>

Luca Garulli

unread,

Jun 20, 2012, 6:06:11 AM6/20/12

to orient-...@googlegroups.com

Hi,

Roberto do you've a place where JDBC driver is built using continuous integration? If yes, it could be useful to provide in the GitHub homepage a link to download the JAR without build by your own.

WDYT?

Lvc@

kae

unread,

Jun 20, 2012, 10:44:44 AM6/20/12

to orient-...@googlegroups.com

Hi Artem,
i work with wm and birt. Now i create a Datasource if i connetc then i have an error:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: The selected driver cannot parse the given url.
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:701)
    at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
    at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)
    at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:156)
    at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:729)
    at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$8(JDBCSelectionPageHelper.java:697)
    at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:620)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
    at org.eclipse.jface.window.Window.open(Window.java:801)
    at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)
    at org.eclipse.birt.report.designer.data.ui.actions.EditDataSourceAction.doAction(EditDataSourceAction.java:69)
    at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1022)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:916)
    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)
    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:585)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:540)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
have you a idee?

Thank's karl

Luca Garulli

unread,

Jun 20, 2012, 10:53:14 AM6/20/12

to orient-...@googlegroups.com

What is the url you've used?

Lvc@

kae

unread,

Jun 20, 2012, 10:56:49 AM6/20/12

to orient-...@googlegroups.com

192.168.1.48/OrientDB/databases/persondb
i want to report table person
the Db is remote

Luca Garulli

unread,

Jun 20, 2012, 11:05:37 AM6/20/12

to orient-...@googlegroups.com

Hi,

you have to use the OrientDB URL syntax: http://code.google.com/p/orient/wiki/Concepts#Database_URL

So your could be:

jdbc:orient:remote:192.168.1.48:2480/persondb

For more information: https://github.com/robfrank/orientdb-jdbc

Lvc@

kae

unread,

Jun 20, 2012, 12:41:10 PM6/20/12

to orient-...@googlegroups.com

yes it work for a half, the table property did'nt show.
I cann't read any tble ind the DB

kae

unread,

Jun 20, 2012, 12:56:02 PM6/20/12

to orient-...@googlegroups.com

Sorry now it works without metadaten.
jdbc:orient:remote:192.168.1.48/OrientDB/databases/persondb
the error:
A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:4.2.0.v20120612
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Error on parsing the query
;
java.sql.SQLSyntaxErrorException: Error on parsing the query

Roberto Franchini

unread,

Jun 20, 2012, 5:31:08 PM6/20/12

to orient-...@googlegroups.com

On Wed, Jun 20, 2012 at 6:56 PM, kae <karl.es...@gmail.com> wrote:
> Sorry now it works without metadaten.
> jdbc:orient:remote:192.168.1.48/OrientDB/databases/persondb
> the error:
> A BIRT exception occurred.
> Plug-in Provider:Eclipse BIRT Project
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:4.2.0.v20120612
> Error Code:odaconsumer.CannotGetResultSetMetaData
> Error Message:Cannot get the result set metadata.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
> not return a ResultSet object.
> SQL error #1:Error on parsing the query
> ;
> java.sql.SQLSyntaxErrorException: Error on parsing the query

Hi,
can you post the query?
Is a Orientt-SQL query?
The driver accepts only query in Orient-SQL.
FRANK

--
Roberto Franchini
The impossible is inevitable.
Be smart: http://goo.gl/LqgRY
http://www.celi.it
http://www.blogmeter.it
Tel +39.011.562.71.15
jabber:ro.fra...@gmail.com skype:ro.franchini

kae

unread,

Jun 21, 2012, 4:01:01 AM6/21/12

to orient-...@googlegroups.com

Frank,

it was CR insite the sql. Now it's work.

Luca Garulli

unread,

Jun 21, 2012, 4:16:38 AM6/21/12

to orient-...@googlegroups.com

Hi,

good to know: Roberto do you process the text in any way or just send it to the OrientDB engine? In the latter case I can manage this fix in the engine.

Lvc@

--

kae

unread,

Jun 21, 2012, 7:13:14 AM6/21/12

to orient-...@googlegroups.com

one more information.
i have two table one create with orientstudio one with java and jdbc.
if i connect to the db with birt only the table create with jave the column are visible. The with studio create no column are visible.

kae

unread,

Jun 21, 2012, 8:50:06 AM6/21/12

to orient-...@googlegroups.com

it is only, if the column has no value also null, then metainformation will not be transfered from jdbc driver.

Luca Garulli

unread,

Jun 21, 2012, 9:32:37 AM6/21/12

to orient-...@googlegroups.com

Have you created the classes AND properties in OrientDB? Working in schema-full mode allow you to use the JDBC driver far better.

Lvc@

--

Roberto Franchini

unread,

Jun 21, 2012, 9:40:10 AM6/21/12

to orient-...@googlegroups.com

On Thu, Jun 21, 2012 at 2:50 PM, kae <karl.es...@gmail.com> wrote:
>
> it is only, if the column has no value also null, then metainformation
> will not be transfered from jdbc driver.
>

So, you created two tables (aka classes in OrientDB jargon), one from
JDBC and one from the studio.
Can you send more details such as or even a dump of the database schema:

http://code.google.com/p/orient/wiki/ConsoleCommandExport

Cheers,

Reply all

Reply to author

Forward