Bonjour,
Après avoir installé BIRT, je souhaite accéder à une base sybase.
Pour cela :
1. j'ai installé les drivers JDBC sybase (jconn2.jar) dans le répertoire
plugins/org.eclipse.birt.report.data.oda.jdbc_2.1.0.N20060628-1351/drivers
2. dans la définition du DATA SOURCE :
a) driver class = com.sybase.jdbc2.jdbc.SybDriver (v5.5) <-- il me retrouve bien mon driver
b) database url = jdbc:sybase:Tds:mon_serveur:5011/MA_BASE
c) renseignez login/pasword
Lorsque je test ma connexion, il me met
JZ00L : Echec de la connexion
si je valide quand même et que je veux créer un dataset, toujours la même erreur mais avec plus d'explications :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68 java.sql.SQLException: JZ00L: Echec de la connexion. Examinez les SQLWarnings associées à cette exception pour la ou les raisons suivantes : at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:547) at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3601) at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510) at com.sybase.jdbc2.tds.Tds.login(Tds.java:432) at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247) at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:223) at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198) at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132) at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179) at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:787) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:185) at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:120) at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.getConnection(DriverLoader.java:33) at org.eclipse.birt.report.data.oda.jdbc.ui.provider.JdbcMetaDataProvider.connect(JdbcMetaDataProvider.java:89) at org.eclipse.birt.report.data.oda.jdbc.ui.provider.JdbcMetaDataProvider.connect(JdbcMetaDataProvider.java:148) at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.connectMetadataProvider(SQLDataSetEditorPage.java:1285) at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.initJdbcInfo(SQLDataSetEditorPage.java:291) at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.createPageControl(SQLDataSetEditorPage.java:241) at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.createPageCustomControl(SQLDataSetEditorPage.java:210) at org.eclipse.datatools.connectivity.oda.design.ui.wizards.DataSetWizardPage.createControl(DataSetWizardPage.java:123) at org.eclipse.jface.wizard.Wizard.createPageControls(Wizard.java:180) at org.eclipse.jface.wizard.WizardDialog.createPageControls(WizardDialog.java:614) at org.eclipse.jface.wizard.WizardDialog.setWizard(WizardDialog.java:989) at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1041) at org.eclipse.jface.wizard.WizardDialog.access$2(WizardDialog.java:1038) at org.eclipse.jface.wizard.WizardDialog$4.run(WizardDialog.java:1028) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1026) at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:757) at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:351) at org.eclipse.jface.dialogs.Dialog$3.widgetSelected(Dialog.java:660) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.eclipse.birt.report.designer.ui.actions.NewDataSetAction.run(NewDataSetAction.java:123) at org.eclipse.jface.action.Action.runWithEvent(Action.java:499) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177) 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.core.launcher.Main.invokeFramework(Main.java:336) at org.eclipse.core.launcher.Main.basicRun(Main.java:280) at org.eclipse.core.launcher.Main.run(Main.java:977) at org.eclipse.core.launcher.Main.main(Main.java:952)
Merci de votre aide
Partager