MS SQL Server - windows authentication

Hi, 
 
i am very new @Birt and Eclipse and i have some big problems. 
I tried to implement this code: <a class='bbc_url' href='http://wiki.eclipse.org/Simple_Execute_(BIRT)_2.1'>http://wiki.eclipse.org/Simple_Execute_(BIRT)_2.1</a> 
like that: 
[Main] 
<pre class='_prettyXprint _lang-auto _linenums:0'>
public static void main(String[] args)
{
Converter con = new Converter();

try
{
con.executeReport();
}
catch (EngineException e)
{
e.printStackTrace();
}

}</pre>
 
[Converter] 
<pre class='_prettyXprint _lang-auto _linenums:0'>
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();
}
}
}
</pre>
 
 
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: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
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.
</pre>
 
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 **** good tool!

Find more posts tagged with

Comments

jhelbling

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.

dome

<blockquote class='ipsBlockquote' data-author="'jhelbling'" data-cid="95997" data-time="1329147680" data-date="13 February 2012 - 08: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. </blockquote>
 
I used that, but thanks for posting.

JasonW

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.org/Birt_3.7_Migration_Guide#Connection_Profiles

Jason

dome

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: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>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</pre>

JasonW

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

dome

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="96062" data-time="1329234167" data-date="14 February 2012 - 08: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 </blockquote>
 
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.

dome

Can no one help me?

Or is there an alternative to birt for creating reports for ms sql server?

dome

JasonW

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.org/forums/index.php/m/633257/#msg_633257

Also when you run the report try with a text query (no connnection profile) and post the stack trace.

Jason

dome

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: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
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

</pre>
 
here the log-file: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
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

</pre>
 
Some hint whats now wrong? 
 
greetings 
dome

JasonW

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

Jason

dome

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="97064" data-time="1330623776" data-date="01 March 2012 - 10:42 AM">
Does the dirver contain more than one Jar? When you are getting this error where do you have the jdbc driver? 
 
Jason </blockquote>
 
Hi, 
 
the driver contains only one Jar. 
i use now ms sql jdbc driver 4.0 and now i get a strange error message: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
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)
</pre>
 
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

JasonW

Can you try the JTDS driver described here:
http://www.eclipse.org/forums/index.php/m/633257/#msg_633257

Jason

dome

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="98217" data-time="1332532972" data-date="23 March 2012 - 01:02 PM">
Can you try the JTDS driver described here: 
<a class='bbc_url' href='http://www.eclipse.org/forums/index.php/m/633257/#msg_633257'>http://www.eclipse.org/forums/index.php/m/633257/#msg_633257</a> 
 
Jason </blockquote>
 
Hi i tried that now. I choosed other driver 2005 and added the jdts-file. 
My connection url is: <pre class='_prettyXprint _lang-auto _linenums:0'>jdbc:jtds:sqlserver://localhost/KEK-PRODOPTI/GRAPHPIC/GP8;useNTLMv2=true</pre>
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.

dome

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: 
<pre class='_prettyXprint _lang-auto _linenums:0'>jdbc:jtds:sqlserver://localhost/GP8;useNTLMv2=true</pre>

JasonW

Thanks for the update.

Jason

manpreet12

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 Singh6145999880