Jump to content

  • Creating a Loaded Hibernate Session Connection

    tof.pelissier

    By tof.pelissier

     Share
    CategoryBug report
    PriorityUrgent
    ReproducibilityAlways
    ResolutionOpen
    SeverityBlock
    StatusNew
    Versionv6.3

    I have the problem but with connection hibernate session. I use the database PostgreSQL and the last version of JasperSoft Studio 6.3.

     

    net.sf.jasperreports.engine.JRException: java.lang.reflect.InvocationTargetException

    at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:129)

    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:105)

    at com.jaspersoft.studio.data.DataAdapterEditorPart$1.widgetSelected(DataAdapterEditorPart.java:170)

    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)

    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)

    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)

    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)

    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)

    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)

    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)

    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)

    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)

    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

    at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:99)

    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)

    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)

    at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

    Caused by: java.lang.reflect.InvocationTargetException

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:108)

    ... 29 more

    Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

    at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)

    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)

    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)

    ... 34 more

    Caused by: java.sql.SQLException: No suitable driver found for jdbc:postgresql://198.81.158.57:5432/projectdev

    at java.sql.DriverManager.getConnection(DriverManager.java:689)

    at java.sql.DriverManager.getConnection(DriverManager.java:208)

    at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)

    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

    ... 38 more

     Share
    Go to bugs

    User Feedback

    Recommended Comments

    cadlg

    Changed Reproducibility from N/A to Always

    I have the exact same problem connecting to an Oracle 11gR2 database.The resources, hibernate configuration files, mapped classes and Oracle JDBC driver are all in the project's classpath, but Jaspersoft Studio complains that there is no suitable driver to connect to the database.If a JDBC adapter is created in the same project, using the same JDBC driver, the connection is successful.I'm using Jaspersoft Studio Community ver 6.4.0.finalOracle Database Express Edition Version 11.2.0.2.0 - 64bitOracle JDBC Driver Version 11.2.0.2.0 (ojdbc6.jar)This is the stacktrace:net.sf.jasperreports.engine.JRException: java.lang.reflect.InvocationTargetException at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:138) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122) at com.jaspersoft.studio.data.DataAdapterEditorPart$1.widgetSelected(DataAdapterEditorPart.java:166) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4418) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4236) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3824) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:693) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:610) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148) at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:91) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610) at org.eclipse.equinox.launcher.Main.run(Main.java:1519)Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:119) ... 29 moreCaused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) ... 34 moreCaused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:XE at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 38 moreThis was reported more than a year ago.It is unbelievable that it has not received any kind of comment, assignment or status change.If any kind of additional information, source files, test project or anything else necessary, please do let me know.Somebody please take a look and advise.
    Link to comment
    Share on other sites

×
×
  • Create New...

© 2023 Cloud Software Group,
Inc. All rights reserved

Products

Explore