Eclipse Community Forums: BIRT » Problem with LDAP data

Home » Archived » 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

Eclipse User

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

Attachment: Screen Shot 2012-12-11 at 3.41.31 PM.png
(Size: 317.59KB, Downloaded 303 times)

Re: Problem with LDAP data [message #990358 is a reply to message #990341]

Wed, 12 December 2012 02:10

Eclipse User

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?

Re: Problem with LDAP data [message #990559 is a reply to message #990358]

Thu, 13 December 2012 02:32

Eclipse User

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 351 times)

Re: Problem with LDAP data [message #990754 is a reply to message #990559]

Fri, 14 December 2012 01:09

Eclipse User

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?

Previous Topic:	master with two sibling details from an XML data source
Next Topic:	JSON Library in birt?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 10:00:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter