Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problem with LDAP data(Using JDBC/LDAP driver - Getting "Cannot get the native data type name for column:")
Problem with LDAP data [message #990341] Tue, 11 December 2012 18:43 Go to next message
Steve Bistline is currently offline Steve Bistline
Messages: 2
Registered: December 2012
Junior Member
Hi,

I am using a JDBC/LDAP driver which connects find and pulls in the LDAP info fine (see attached).

When I try to Preview the report I get the following error...


The following items have errors:

Table (id = 4):
+ Cannot get the native data type name for column: 1
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get the column type name.
SQL error #1:Illegal Type
;
java.sql.SQLException: Illegal Type (Element ID:4)


Any help would be most appreciated.



Thanks,

Steve
Re: Problem with LDAP data [message #990358 is a reply to message #990341] Wed, 12 December 2012 02:10 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Can you click on the '+' sign and expand the error and post the entire stack, in here? Also, what is the data type for column 1?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Problem with LDAP data [message #990559 is a reply to message #990358] Thu, 13 December 2012 02:32 Go to previous messageGo to next message
Steve Bistline is currently offline Steve Bistline
Messages: 2
Registered: December 2012
Junior Member
Here is the full error detail and I attached a screen shot of the data columns:


org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:135)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:97)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:49)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:336)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the native data type name for column: 1
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get the column type name.
SQL error #1:Illegal Type
;
java.sql.SQLException: Illegal Type
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:55)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:96)
at org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.getColumnNativeTypeName(ResultSetMetaData.java:179)
at org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init>(ProjectedColumns.java:58)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetProjectedColumns(PreparedStatement.java:433)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:378)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetMetaData(PreparedStatement.java:347)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:563)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:964)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:428)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1142)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:177)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultMetaData(QueryResults.java:132)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:169)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:126)
... 5 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get the column type name.
SQL error #1:Illegal Type
;
java.sql.SQLException: Illegal Type
at org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getColumnTypeName(ResultSetMetaData.java:245)
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiResultSetMetaData.getColumnTypeName(BidiResultSetMetaData.java:68)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSetMetaData.getColumnTypeName(OdaResultSetMetaData.java:193)
at org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.getColumnNativeTypeName(ResultSetMetaData.java:175)
... 18 more
Caused by: java.sql.SQLException: Illegal Type
at com.octetstring.jdbcLdap.sql.JdbcLdapMetaData.getColumnTypeName(JdbcLdapMetaData.java:88)
at org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getColumnTypeName(ResultSetMetaData.java:241)
... 21 more
  • Attachment: BIRT_LDAP.png
    (Size: 324.86KB, Downloaded 62 times)
Re: Problem with LDAP data [message #990754 is a reply to message #990559] Fri, 14 December 2012 01:09 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

It's having an issue with the DN column. If you disclude that column, does the error go away? Is that field of type string in your database?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:master with two sibling details from an XML data source
Next Topic:JSON Library in birt?
Goto Forum:
  


Current Time: Sat Jul 26 09:19:59 EDT 2014

Powered by FUDForum. Page generated in 0.02241 seconds