Jump to content

BIRT Developer Center Download


Photo
- - - - -

MS SQL Server - windows authentication


  • Please log in to reply
16 replies to this topic

#1 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 13 February 2012 - 06:20 AM

Hi,

i am very new @Birt and Eclipse and i have some big problems.
I tried to implement this code: http://wiki.eclipse....cute_(BIRT)_2.1
like that:
[Main]
	public static void main(String[] args)
	{
		Converter con = new Converter();
		
		try
		{
			con.executeReport();
		}
		catch (EngineException e)
		{
			e.printStackTrace();
		}

	}

[Converter]
package birt;

import java.util.logging.Level;

import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.EngineException;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
import org.eclipse.birt.report.engine.api.PDFRenderOption;

public class Converter
{
	public void executeReport() throws EngineException
	{
		IReportEngine engine = null;
		EngineConfig config = null;
		try
		{
			config = new EngineConfig();
			// config.setBIRTHome("C://Anlagendaten//Birt//birt-runtime-3_7_1//ReportEngine");
			config.setLogConfig("c:/temp/test/LOG", Level.FINEST);

			Platform.startup(config);
			IReportEngineFactory factory = (IReportEngineFactory) Platform
					.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
			engine = factory.createReportEngine(config);

			IReportRunnable design = null;
			// Open the report design
			design = engine
					.openReportDesign("C:/Anlagendaten/Birt/workspace/Birt_report/test.rptdesign");
			IRunAndRenderTask task = engine.createRunAndRenderTask(design);
			// task.setParameterValue("Top Count", (new Integer(5)));
			// task.validateParameters();

			// HTMLRenderOption options = new HTMLRenderOption();
			// options.setOutputFileName("output/resample/Parmdisp.html");
			// options.setOutputFormat("html");
			// options.setHtmlRtLFlag(false);
			// options.setEmbeddable(false);
			// options.setImageDirectory("C:\\test\\images");

			PDFRenderOption options = new PDFRenderOption();
			options.setOutputFileName("c:/temp/test/test.pdf");
			options.setOutputFormat("pdf");

			task.setRenderOption(options);
			task.run();
			task.close();
			engine.destroy();
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
		finally
		{
			Platform.shutdown();
		}
	}
}


I am using MS SQL Server 2005 with windows authentication.
If i run BIRT in eclipse i can see the result preview without any problems, but if i run my program i get strange error Messages:

Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl getConnectionProfile
Warnung: No connection profile is found by its specified name: null
Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log
Schwerwiegend: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
java.lang.IllegalStateException: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
	at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getDefaultStateLocation(ConnectivityPlugin.java:154)
	at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getStorageLocation(ConnectivityPlugin.java:175)
	at org.eclipse.datatools.connectivity.drivers.XMLFileManager.getStorageLocation(XMLFileManager.java:264)
	at org.eclipse.datatools.connectivity.drivers.XMLFileManager.loadPropertySets(XMLFileManager.java:204)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.loadAllInstances(DriverManager.java:75)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.resetDefaultInstances(DriverManager.java:589)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.<init>(DriverManager.java:117)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.getInstance(DriverManager.java:62)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:136)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:71)
	at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
	at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166)
	at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log
Schwerwiegend: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log
Schwerwiegend: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
java.lang.IllegalStateException: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
	at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getDefaultStateLocation(ConnectivityPlugin.java:154)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.wereDefaultDriversCreated(DriverManager.java:518)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.resetDefaultInstances(DriverManager.java:594)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.<init>(DriverManager.java:117)
	at org.eclipse.datatools.connectivity.drivers.DriverManager.getInstance(DriverManager.java:62)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:136)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:71)
	at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
	at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
	at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
	at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Feb 13, 2012 2:30:37 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log
Schwerwiegend: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.

I readed, that maybe the windows authentication is an problem. Also readed that i have maybe to use DTP, but i dont know how. Maybe someone can help me.

[UPDATED INFOS]
My Connection URL is:
jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true;

I use a standard JDBC connection with Microsoft SQL Server 2005 JDBC Driver and no Profil.
I use the option: JDBC Database Connection for Query Builder.



PS: Sorry vor bad english ;)
PPS: BIRT is a damn good tool!

#2 jhelbling

jhelbling

    Junior Member

  • Members
  • PipPipPip
  • 42 posts

Posted 13 February 2012 - 07:41 AM

Not sure it will help but if you want to use the Windows authentication, you might have to add the integratedSecurity option to your JDBC connection string, like for example :

jdbc:sqlserver://localhost;integratedSecurity=true;

Hope it helps.

#3 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 13 February 2012 - 08:09 AM

Not sure it will help but if you want to use the Windows authentication, you might have to add the integratedSecurity option to your JDBC connection string, like for example :

jdbc:sqlserver://localhost;integratedSecurity=true;

Hope it helps.


I used that, but thanks for posting.

#4 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 13 February 2012 - 03:12 PM

Are you using connection profiles or a standard jdbc connection in BIRT? BTW Remove this line: config.setBIRTHome(".... If you are using the connection profile feature look at this: http://wiki.eclipse....ection_Profiles Jason

#5 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 14 February 2012 - 12:16 AM

I use a standard JDBC connection with Microsoft SQL Server 2005 JDBC Driver and no Profil.
I use the option: JDBC Database Connection for Query Builder.

[edit]
I removed the cofig.setBIRTHome()
and then i got this error message additional to the old:

Feb 14, 2012 9:31:55 AM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl getConnectionProfile
Warnung: No connection profile is found by its specified name: null

Edited by dome, 14 February 2012 - 12:35 AM.


#6 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 14 February 2012 - 07:42 AM

Can you try the text based query instead of the query builder? BTW did you set the dtp work space (should only be needed if using connection profiles)? Jason

#7 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 14 February 2012 - 11:40 PM

Can you try the text based query instead of the query builder? BTW did you set the dtp work space (should only be needed if using connection profiles)?

Jason


I tried it(JDBC Data Source) but then i got a message, that this driver isnt configured for Windows authentication. With the query builder i get connection, its strange.

Maybe i have to use DTP, but i have no idea how to manage this. I read the information side, but i dont know how and where set what up.

I have downloaded the dtp plugin and copied it in the eclipse folder.
But i am not sure what to do next? How to configure the eclipse and birt project?

Thx for helping.

#8 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 22 February 2012 - 05:56 AM

Can no one help me? Or is there an alternative to birt for creating reports for ms sql server? dome

#9 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 22 February 2012 - 09:45 AM

DTP is already part of the birt runtime. You should not have to download it. Can you try to use the JTDS driver as described here: http://www.eclipse.o...257/#msg_633257 Also when you run the report try with a text query (no connnection profile) and post the stack trace. Jason

#10 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 28 February 2012 - 02:49 AM

Hi,

i am now a little step further.

I used mssql 3.0 jdbc driver without connection profil and not the query builder.
The java application i runing without throwing an error, but creating a big log-file.
Birt preview works well. But if i debug birt i get following errors:
Feb 28, 2012 11:39:36 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer start
Information: [Server] client accepted
Feb 28, 2012 11:39:36 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
Information: [Server] enter request dispatching
Feb 28, 2012 11:39:36 AM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher configEngine
Information: User class path received: 
Feb 28, 2012 11:39:37 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
Schwerwiegend: Error happened while running the report.
java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext([B[I[BI[B[I[ZLjava/lang/String;ILjava/lang/String;Ljava/lang/String;Ljava/util/logging/Logger;)I
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext(Native Method)
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.GenerateClientContext(AuthenticationJNI.java:80)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2695)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2242)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2228)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5574)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1734)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1355)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1022)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:858)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1214)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:274)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:232)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:243)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
	at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
	at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
	at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
	at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
	at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
	at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
	at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:594)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:541)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:455)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:104)
	at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1386)

Feb 28, 2012 11:39:37 AM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher renderReport
Schwerwiegend: Engine exception
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
	at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2265)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:190)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:594)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:541)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:455)
	at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:104)
	at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext([B[I[BI[B[I[ZLjava/lang/String;ILjava/lang/String;Ljava/lang/String;Ljava/util/logging/Logger;)I
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext(Native Method)
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.GenerateClientContext(AuthenticationJNI.java:80)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2695)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2242)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2228)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5574)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1734)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1355)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1022)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:858)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1214)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:274)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:232)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:243)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
	at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
	at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
	at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
	at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
	at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
	at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
	at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	... 19 more

Feb 28, 2012 11:39:37 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
Warnung: [Server] client disconnected


here the log-file:
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.api.impl.ReportEngine <init>
Fein: ReportEngine created. EngineConfig: EngineConfig: org.eclipse.birt.report.engine.api.EngineConfig.scriptObjects={};BIRT_HOME=C://Anlagendaten//Birt//birt-runtime-3_7_1//ReportEngine;logLevel=FINEST;org.eclipse.birt.report.engine.api.EngineConfig.emitterConfigs={html=org.eclipse.birt.report.engine.api.HTMLEmitterConfig@265e47};logDest=c:/temp/test/LOG; 
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.reportitemGeneration
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadGenerationExtensionDefns
Fein: Load generation extension: Chart
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.reportitemPresentation
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadPresentationExtensionDefns
Fein: Load prsentation extension: Chart
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.reportitemQuery
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadQueryExtensionDefns
Fein: Load query extension: Chart
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.emitters
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load html emitter org.eclipse.birt.report.engine.emitter.html
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load pdf emitter org.eclipse.birt.report.engine.emitter.pdf
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load postscript emitter org.eclipse.birt.report.engine.emitter.postscript
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load ppt emitter org.eclipse.birt.report.engine.emitter.ppt
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load xls emitter org.eclipse.birt.report.engine.emitter.prototype.excel
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load doc emitter org.eclipse.birt.report.engine.emitter.word
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load odp emitter org.eclipse.birt.report.engine.emitter.odp
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load ods emitter org.eclipse.birt.report.engine.emitter.prototype.ods
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
Fein: Load odt emitter org.eclipse.birt.report.engine.emitter.odt
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.reportEventHandler
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.reportItemPreparation
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.dataExtraction
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadDataExtractionExtensions
Fein: Load data extraction extension: org.eclipse.birt.report.engine.dataextraction.csv
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
Fein: Start load extension point: org.eclipse.birt.report.engine.extendedItemFactory
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
Fein: Load extendedItem extension: Crosstab
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
Fein: Load extendedItem extension: CrosstabCell
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
Fein: Load extendedItem extension: AggregationCell
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.api.impl.ReportEngine openReportDesign
Fein: ReportEngine.openReportDesign: designName=C:/Anlagendaten/Birt/workspace/Birt_report/test.rptdesign 
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.model.util.XMLParserPoolImpl createParser
Am feinsten: created a new SAX parser
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.model.util.XMLParserPoolImpl createParser
Am feinsten: created a new SAX parser
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.api.impl.ReportEngine createRunAndRenderTask
Fein: ReportEngine.createRunAndRenderTask: reportRunnable=org.eclipse.birt.report.engine.api.impl.ReportRunnable@1cef8be 
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.api.impl.EngineTask setAppContext
Fein: EngineTask.setAppContext: context=
Feb 28, 2012 11:44:15 AM org.eclipse.birt.report.engine.api.impl.EngineTask loggerParamters
Fein: Running the report with paramters: 
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.api.DataEngineContext DataEngineContext
Feiner: ENTRY 3 [object Object] null null org.eclipse.birt.report.engine.executor.ApplicationClassLoader@b6e204
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.api.DataEngineContext DataEngineContext
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl DataEngineImpl
Feiner: ENTRY org.eclipse.birt.data.engine.api.DataEngineContext@462fce
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineSession DataEngineSession
Feiner: ENTRY org.eclipse.birt.data.engine.impl.DataEngineImpl@bfcbfa
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineSession DataEngineSession
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl DataEngineImpl
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl <init>
Feiner: Data Engine starts up
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
Feiner: ENTRY Data Source
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
Feiner: DataEngine.defineDataSource: OdaDataSourceDesign(Name : Data Source
ExtensionID : org.eclipse.birt.report.data.oda.jdbc
PrivateProperties : {contentBidiFormatStr=ILYNN, metadataBidiFormatStr=ILYNN}
 PulicProperties : OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_Data Source;odaURL=jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true;;odaDriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver;
)
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
Feiner: ENTRY org.eclipse.birt.report.data.adapter.internal.adapter.OdaDataSourceAdapter@b3d73d [object Object]
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataSourceRuntime DataSourceRuntime
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
Feiner: ENTRY org.eclipse.birt.report.data.adapter.internal.adapter.OdaDataSourceAdapter@b3d73d [object Object]
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime OdaDataSourceRuntime
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.OdaDataSourceRuntime <init>
Feiner: OdaDataSourceRuntime starts up
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSource
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.report.data.adapter.impl.ModelAdapter adaptDataSet
Fein: handle type: org.eclipse.birt.report.model.api.OdaDataSetHandle
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
Feiner: ENTRY Data Set
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
Feiner: DataEngine.defineDataSet: OdaDataSetDesign(Name : Data Set
DataSourceName : Data Source
ResultSetHints : org.eclipse.birt.report.data.adapter.internal.adapter.ColumnAdapter@1ba9eea, 
	org.eclipse.birt.report.data.adapter.internal.adapter.ColumnAdapter@1173763
ExtensionID : org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
QueryText : select dbo.View_MStillstand_A.ID_Machine, SUM( dbo.View_MStillstand_A.Laufmeter)
from dbo.View_MStillstand_A
GROUP BY dbo.View_MStillstand_A.ID_Machine
PrivateProperties : {}
PublicProperties : {rowFetchSize=null, queryTimeOut=null}
)
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl defineDataSet
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
Feiner: ENTRY QueryDefinition(DataSetName : Data Set
ResultSetExpressions : {ID_Machine=org.eclipse.birt.data.engine.api.querydefn.Binding@2c184103, UNNAMED_2=org.eclipse.birt.data.engine.api.querydefn.Binding@72c30fd3}
MaxRows : 0

Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
Fein: Start to prepare query: QueryDefinition(DataSetName : Data Set
ResultSetExpressions : {ID_Machine=org.eclipse.birt.data.engine.api.querydefn.Binding@2c184103, UNNAMED_2=org.eclipse.birt.data.engine.api.querydefn.Binding@72c30fd3}
MaxRows : 0

Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery PreparedDataSourceQuery
Feiner: ENTRY org.eclipse.birt.data.engine.impl.DataEngineImpl@bfcbfa org.eclipse.birt.data.engine.api.querydefn.QueryDefinition@dbb8cf org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@13ff34d {org.eclipse.datatools.connectivity.oda.util_consumerResourceIds=org.eclipse.datatools.connectivity.oda.util.ResourceIdentifiers@17e5f8a, PDF_RENDER_CONTEXT=org.eclipse.birt.report.engine.api.PDFRenderContext@1b29b56}
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedQuery PreparedQuery
Feiner: PreparedQuery starts up.
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggregateTable AggregateTable
Feiner: ENTRY
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggregateTable AggregateTable
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggregateTable AggregateTable
Feiner: ENTRY C:\DOKUME~1\KEK\LOKALE~1\Temp\DataEngine_12569594_1\ [object Object] []
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggregateTable AggregateTable
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedQuery <init>
Fein: Start to prepare a PreparedQuery.
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggrRegistry AggrRegistry
Feiner: ENTRY 0 -1 true org.eclipse.birt.core.script.ScriptContext@14043b3
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.aggregation.AggrRegistry AggrRegistry
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.expression.ColumnReferenceExpression ColumnReferenceExpression
Feiner: ENTRY ID_Machine
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.expression.ColumnReferenceExpression ColumnReferenceExpression
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.expression.ColumnReferenceExpression ColumnReferenceExpression
Feiner: ENTRY UNNAMED_2
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.expression.ColumnReferenceExpression ColumnReferenceExpression
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.GroupBindingColumn GroupBindingColumn
Feiner: ENTRY null 0 {ID_Machine=org.eclipse.birt.data.engine.api.querydefn.Binding@2c184103, UNNAMED_2=org.eclipse.birt.data.engine.api.querydefn.Binding@72c30fd3}
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.GroupBindingColumn GroupBindingColumn
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedQuery <init>
Fein: Finished preparing the PreparedQuery.
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery PreparedDataSourceQuery
Feiner: RETURN
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery PreparedOdaDSQuery
Feiner: RETURN [Ljava.lang.Object;@138fe2b
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
Fein: Finished preparing query.
Feb 28, 2012 11:44:16 AM org.eclipse.birt.data.engine.impl.DataEngineImpl prepare
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.DataSetRuntime DataSetRuntime
Feiner: ENTRY org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@13ff34d null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.DataSetRuntime DataSetRuntime
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime OdaDataSetRuntime
Feiner: ENTRY org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@13ff34d null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime OdaDataSetRuntime
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime <init>
Feiner: OdaDataSetRuntime starts up
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.ParameterUtil ParameterUtil
Feiner: ENTRY null org.eclipse.birt.data.engine.impl.OdaDataSetRuntime@daf3bc org.eclipse.birt.data.engine.api.querydefn.QueryDefinition@dbb8cf [object Object]
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.ParameterUtil ParameterUtil
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.QueryExecutor QueryExecutor
Feiner: ENTRY [object Object] org.eclipse.birt.data.engine.api.querydefn.QueryDefinition@dbb8cf org.eclipse.birt.data.engine.impl.aggregation.AggregateTable@5afb90 org.eclipse.birt.data.engine.impl.DataEngineSession@139d113
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.QueryExecutor QueryExecutor
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.PreparedQuery doPrepare
Feiner: Start to prepare the execution.
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.DataSetRuntime DataSetRuntime
Feiner: ENTRY org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@13ff34d org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor@cd445b
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.DataSetRuntime DataSetRuntime
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime OdaDataSetRuntime
Feiner: ENTRY org.eclipse.birt.data.engine.impl.OdaDataSetAdapter@13ff34d org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor@cd445b
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime OdaDataSetRuntime
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.OdaDataSetRuntime <init>
Feiner: OdaDataSetRuntime starts up
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.ParameterUtil ParameterUtil
Feiner: ENTRY null org.eclipse.birt.data.engine.impl.OdaDataSetRuntime@1f2e609 org.eclipse.birt.data.engine.api.querydefn.QueryDefinition@dbb8cf [object Object]
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.impl.ParameterUtil ParameterUtil
Feiner: RETURN
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager getInstance
Feiner: ENTRY
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager getInstance
Feiner: RETURN org.eclipse.birt.data.engine.odaconsumer.ConnectionManager@1f2fb11
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
Feiner: ENTRY org.eclipse.birt.report.data.oda.jdbc {odaDriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver, odaURL=jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true;, OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_Data Source, contentBidiFormatStr=ILYNN, metadataBidiFormatStr=ILYNN}
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.DriverManager getDriverHelper(String,boolean,Map)
Feiner: ENTRY org.eclipse.birt.report.data.oda.jdbc false
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.Driver Driver
Feiner: ENTRY org.eclipse.birt.report.data.oda.jdbc
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.Driver Driver
Feiner: RETURN org.eclipse.birt.data.engine.odaconsumer.Driver@104e65
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.DriverManager getDriverHelper(String,boolean,Map)
Feiner: RETURN org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver@b8a16c
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager addProfileProviderService( Map )
Feiner: Added default property service: org.eclipse.datatools.connectivity.oda.profile.connectionPropertyService
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.DriverManager getExtensionDataSourceId
Feiner: ENTRY org.eclipse.birt.report.data.oda.jdbc
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.DriverManager getExtensionDataSourceId
Feiner: RETURN org.eclipse.birt.report.data.oda.jdbc
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.OdaJdbcDriver getConnection
Am feinsten: JDBCConnectionFactory.getConnection( ) connectionClassName=org.eclipse.birt.report.data.oda.jdbc
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.Connection open
Fein: Connection.open(Properties). connProperties = OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_Data Source;odaURL=jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true;odaDriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver;contentBidiFormatStr=ILYNN;metadataBidiFormatStr=ILYNN;
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.Connection close
Am feinsten: Connection closed.
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager JDBCDriverManager
Fein: JDBCDriverManager starts up
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
Fein: Request JDBC Connection: driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver; url=jdbc:sqlserver://localhost\3DA82F6B8F534B4\GRAPHPIC:1433;databaseName=GP8;integratedSecurity=true; jndi name url=null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions
Information: Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions
Information: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.hive.HiveDriver, connectionFactory=null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions
Information: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver, connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadAndRegisterDriver
Fein: Loading JDBC driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
Information: Driver class not in class path: com.microsoft.sqlserver.jdbc.SQLServerDriver. Trying to locate driver in drivers directory
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$DriverClassLoader constructor()
Feiner: ENTRY
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
Schwerwiegend: DriverClassLoader failed to load class: com.microsoft.sqlserver.jdbc.SQLServerDriver
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
	at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:188)
	at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:156)
	at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:151)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadExtraDriver(JDBCDriverManager.java:949)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:760)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:903)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:885)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:248)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:214)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
	at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
	at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
	at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
	at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
	at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
	at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1905)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
	at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at birt.Converter.executeReport(Converter.java:52)
	at birt.Main.main(Main.java:17)

Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
Schwerwiegend: refreshUrlsWhenFail: true
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
Schwerwiegend: driverClassPath: null
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
Schwerwiegend: Registered URLs: 
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
Feiner: Driver class not found in drivers directory: com.microsoft.sqlserver.jdbc.SQLServerDriver
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
Warnung: Failed to load JDBC driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.data.oda.jdbc.JDBCException JDBCException
Fein: odajdbc.CannotLoadDriverClass
Feb 28, 2012 11:44:17 AM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
Schwerwiegend: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver.
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:782)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:903)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:885)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:248)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:214)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
	at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
	at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
	at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
	at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
	at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
	at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
	at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1905)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
	at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at birt.Converter.executeReport(Converter.java:52)
	at birt.Main.main(Main.java:17)

Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory loadFontMappingConfig
Information: load font config in jar:file:/C:/Anlagendaten/Birt/birt-runtime-3_7_1/ReportEngine/lib/org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar!/fontsConfig.xml cost 15ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/ja/X11/fonts/TT cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_13/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/ru.ansi-1251/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_15/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in d:/windows/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in C:/windows/fonts cost:203ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X11R6/lib/X11/fonts/truetype cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/ar/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in e:/WINNT/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /var/lib/defoma/x-ttcidfont-conf.d/dirs/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in C:/WINNT/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_2/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X11R6/lib/X11/fonts/tt cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/th_TH/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_8/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_7/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X11R6/lib/X11/fonts/TTF cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/truetype cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in f:/WINNT/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/ko.UTF-8/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in g:/WINNT/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_5/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in f:/windows/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in d:/WINNT/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/ko/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh_TW/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in e:/windows/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/zh_TW/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/ja/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh_CN.GB18030/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/default/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X/lib/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/euro_fonts/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/hi_IN.UTF-8/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh.GBK/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X11R6/lib/X11/fonts/OTF cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/iso_8859_9/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/X11R6/lib/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh_TW.BIG5/X11/fonts/TT cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/ko/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh_HK.BIG5HK/X11/fonts/TT cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/KOI8-R/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/openwin/lib/locale/zh/X11/fonts/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in /usr/share/fonts/zh_CN/TrueType cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory$2 run
Information: register fonts in g:/windows/fonts cost:0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory loadFontMappingConfig
Information: load font config in jar:file:/C:/Anlagendaten/Birt/birt-runtime-3_7_1/ReportEngine/lib/org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar!/fontsConfig_win32.xml cost 0ms
Feb 28, 2012 11:44:17 AM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory loadFontMappingConfig
Information: load font config in jar:file:/C:/Anlagendaten/Birt/birt-runtime-3_7_1/ReportEngine/lib/org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar!/fontsConfig_pdf.xml cost 0ms
Feb 28, 2012 11:44:18 AM DataEngineImpl shutdown
Feiner: ENTRY
Feb 28, 2012 11:44:18 AM org.eclipse.birt.data.engine.impl.DataEngineImpl shutdown
Fein: Data engine shuts down
Feb 28, 2012 11:44:18 AM org.eclipse.birt.data.engine.impl.DataEngineImpl shutdown
Feiner: RETURN
Feb 28, 2012 11:44:18 AM org.eclipse.birt.report.engine.api.impl.ReportEngine destroy
Fein: ReportEngine.destroy


Some hint whats now wrong?

greetings
dome

#11 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 01 March 2012 - 09:42 AM

Does the dirver contain more than one Jar? When you are getting this error where do you have the jdbc driver? Jason

#12 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 23 March 2012 - 02:50 AM

Does the dirver contain more than one Jar? When you are getting this error where do you have the jdbc driver?

Jason


Hi,

the driver contains only one Jar.
i use now ms sql jdbc driver 4.0 and now i get a strange error message:
com.microsoft.sqlserver.jdbc.SQLServerException: Fehler bei der integrierten Authentifizierung. ClientConnectionId:9389ff8f-6a8d-4ce0-89fc-fa6987c4cbf0
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
	at com.microsoft.sqlserver.jdbc.AuthenticationJNI.GenerateClientContext(AuthenticationJNI.java:85)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2691)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:214)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
	at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
	at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
	at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

I read, that i have to add "sqljdbc_auth.dll" in "system32" Folder for using windows authentication. I did that, but then i get the error-message which i posed here.

Some idea whats now wrong?


greetings
dome

#13 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 23 March 2012 - 12:02 PM

Can you try the JTDS driver described here: http://www.eclipse.o...257/#msg_633257 Jason

#14 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 26 March 2012 - 02:14 AM

Can you try the JTDS driver described here:
http://www.eclipse.o...257/#msg_633257

Jason


Hi i tried that now. I choosed other driver 2005 and added the jdts-file.
My connection url is:
jdbc:jtds:sqlserver://localhost/KEK-PRODOPTI/GRAPHPIC/GP8;useNTLMv2=true
But i cant create a new connection profil because i have no user and passwort but i need them to finsh the window-dialog. I add a pic for better understanding.
Attached File  driver.png   71.25KB   0 downloads


EDIT:
If i use not the query builder then i got these error message:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property..
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:304)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:206)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:782)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:703)
	at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)
	at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)
	at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:156)
	at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:715)
	at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$7(JDBCSelectionPageHelper.java:683)
	at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$7.widgetSelected(JDBCSelectionPageHelper.java:606)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
	at org.eclipse.jface.window.Window.open(Window.java:801)
	at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:126)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
	at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
	at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
	at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
	at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

EDIT2:
I think te JTDS is the right way. There i get i error-message to work with. I tried to get connection with openoffice base tool. it trows a simular error:
SQL-Status: 08S01

I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.


#15 dome

dome

    Member

  • Members
  • PipPip
  • 12 posts

Posted 26 March 2012 - 04:13 AM

IT WORKS!
I use the JTDS driver. I only have to add the file "ntlmauth.dll" from jdts/x86/SSO into /jre/bin folder and restart the machine.

The connection-url was wrong too. In my special case it was:
jdbc:jtds:sqlserver://localhost/GP8;useNTLMv2=true


#16 JasonW

JasonW

    Senior Member

  • Members
  • 2505 posts

Posted 30 March 2012 - 08:23 AM

Thanks for the update. Jason

#17 manpreet12

manpreet12

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 18 December 2013 - 07:30 AM

Hi

 

Where did you find DLL File "ntlmauth.dll"? I am also facing the same issue but could not able to locate ntlmauth.dll. Can you please let me know. Thank you.

 

Manpreet Singh

6145999880