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

Report message to a moderator

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: 823
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?

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

Report message to a moderator

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: 823
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?

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 10:05:32 EDT 2013

Powered by FUDForum. Page generated in 0.01660 seconds