Skip to main content



      Home
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 Go to next message
Eclipse UserFriend
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
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 350 times)
Re: Problem with LDAP data [message #990754 is a reply to message #990559] Fri, 14 December 2012 01:09 Go to previous message
Eclipse UserFriend
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:
  


Current Time: Mon Jul 07 17:42:58 EDT 2025

Powered by FUDForum. Page generated in 0.03280 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top