Eclipse Community Forums: BIRT » Problem with LDAP data

Home » Eclipse Projects » BIRT » Problem with LDAP data(Using JDBC/LDAP driver - Getting "Cannot get the native data type name for column:")

Show: Today's Messages :: Show Polls :: Message Navigator

Problem with LDAP data [message #990341]

Tue, 11 December 2012 23:43

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

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

Report message to a moderator

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

Wed, 12 December 2012 07:10

Michael Williams

Messages: 1925
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

Developer Evangelist, Silanis

Report message to a moderator

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

Thu, 13 December 2012 07:32

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