| Database Drivers fighting [message #86196] |
Tue, 01 November 2005 10:55  |
Eclipse User |
|
|
|
Originally posted by: m.n.com
I know this is not specific to BIRT,
but ..
I am trying to do BIRT and Hibernate Tools in the same IDE. Sadly when one
loads the database driver, the other can't. So I have to restart Eclipse.
But if the plugin doesn't load the driver itself, then it can't find it.
This is not specific to just these plugins. :(
Anyone have any idea on how to solve this?
|
|
|
|
|
| Re: Database Drivers fighting [message #86272 is a reply to message #86257] |
Tue, 01 November 2005 13:02  |
| Eclipse User |
|
|
|
Mark,
If you download the Report Engine you can deploy them to Tomcat or another
J2EE server, which should be in another JVM. Launching two instances of
eclipse doesnt work?
Jason Weathersby
BIRT PMC
"Mark" <m@n.com> wrote in message news:dk85fk$vik$1@news.eclipse.org...
>I don't think so. The driver is being loaded via a scripted dataset.
>
> Also, the problem I am getting is with a dll - I am using DB2 app driver.
>
> If I connect to a session in Hibernate first I get this in the report when
> I preview it:
> "Script engine error: Wrapped
> org.hibernate.exception.JDBCConnectionException: Cannot open connection
> (DataSet:MEM.open#39)"
>
> If I preview the report first I get this in Hibernate Tools:
> "org.hibernate.console.HibernateConsoleRuntimeException: Problems while
> loading database driverclass (COM.ibm.db2.jdbc.app.DB2Driver)
> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
> classloader
> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
> classloader
> "
>
> I've had this issue with other tools, but I have been able to live with
> it. The problem now is that I am going to have Report Writers building the
> reports and eventually doing some HQL development. I don't think they can
> or will deal with the issue.
>
> Is there an easy way to preview/run the reports externally to Eclipse - so
> it runs in another JVM? Just for the real data. They can build the
> reports with dummy objects (like in the demo).
>
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:dk843c$tgq$1@news.eclipse.org...
>> Mark,
>>
>> I am not sure how to solve this, partly because I didnt think this would
>> be an issue, but does making a copy of it and using the Manage Drivers
>> button in the Data Source connection wizard make a difference?
>>
>> Jason Weathersby
>> BIRT PMC
>>
>> "Mark" <m@n.com> wrote in message news:dk834v$s61$1@news.eclipse.org...
>>>I know this is not specific to BIRT,
>>>
>>> but ..
>>>
>>> I am trying to do BIRT and Hibernate Tools in the same IDE. Sadly when
>>> one loads the database driver, the other can't. So I have to restart
>>> Eclipse. But if the plugin doesn't load the driver itself, then it can't
>>> find it. This is not specific to just these plugins. :(
>>>
>>> Anyone have any idea on how to solve this?
>>>
>>
>>
>
>
|
|
|
| Re: Database Drivers fighting [message #86318 is a reply to message #86272] |
Tue, 01 November 2005 14:59 |
| Eclipse User |
|
|
|
Originally posted by: m.n.com
I was looking into installing the viewer in tomcat. Looks pretty easy.
Yes, I could open another instance of Eclipse. That is what I have done
before. But memory becomes an issue. And the report writers might not have
as powerful machines.
I believe, for now, the solution will be that the report writers won't be
doing any Hibernate Developement. Just using the code created by the
developers. Long term, I would like to see them involved.
"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:dk8ajg$7i9$1@news.eclipse.org...
> Mark,
>
> If you download the Report Engine you can deploy them to Tomcat or another
> J2EE server, which should be in another JVM. Launching two instances of
> eclipse doesnt work?
>
> Jason Weathersby
> BIRT PMC
>
>
> "Mark" <m@n.com> wrote in message news:dk85fk$vik$1@news.eclipse.org...
>>I don't think so. The driver is being loaded via a scripted dataset.
>>
>> Also, the problem I am getting is with a dll - I am using DB2 app driver.
>>
>> If I connect to a session in Hibernate first I get this in the report
>> when I preview it:
>> "Script engine error: Wrapped
>> org.hibernate.exception.JDBCConnectionException: Cannot open connection
>> (DataSet:MEM.open#39)"
>>
>> If I preview the report first I get this in Hibernate Tools:
>> "org.hibernate.console.HibernateConsoleRuntimeException: Problems while
>> loading database driverclass (COM.ibm.db2.jdbc.app.DB2Driver)
>> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
>> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
>> classloader
>> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
>> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
>> classloader
>> "
>>
>> I've had this issue with other tools, but I have been able to live with
>> it. The problem now is that I am going to have Report Writers building
>> the reports and eventually doing some HQL development. I don't think they
>> can or will deal with the issue.
>>
>> Is there an easy way to preview/run the reports externally to Eclipse -
>> so it runs in another JVM? Just for the real data. They can build the
>> reports with dummy objects (like in the demo).
>>
>>
>> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
>> news:dk843c$tgq$1@news.eclipse.org...
>>> Mark,
>>>
>>> I am not sure how to solve this, partly because I didnt think this would
>>> be an issue, but does making a copy of it and using the Manage Drivers
>>> button in the Data Source connection wizard make a difference?
>>>
>>> Jason Weathersby
>>> BIRT PMC
>>>
>>> "Mark" <m@n.com> wrote in message news:dk834v$s61$1@news.eclipse.org...
>>>>I know this is not specific to BIRT,
>>>>
>>>> but ..
>>>>
>>>> I am trying to do BIRT and Hibernate Tools in the same IDE. Sadly when
>>>> one loads the database driver, the other can't. So I have to restart
>>>> Eclipse. But if the plugin doesn't load the driver itself, then it
>>>> can't find it. This is not specific to just these plugins. :(
>>>>
>>>> Anyone have any idea on how to solve this?
>>>>
>>>
>>>
>>
>>
>
>
|
|
|
| Re: Database Drivers fighting [message #86729 is a reply to message #86257] |
Wed, 02 November 2005 13:45 |
| Eclipse User |
|
|
|
This is a rather common issue when using Type-2 JDBC driver which loads a
native DLL. JVM can't handle the same DLL being loaded by two different
classloaders.
If a Java-native (type 4) JDBC driver is out of the question, try this and
see if it helps: add your JDBC driver to the system class path of the JVM
used by Eclipse. This way the driver class is loaded only once by the system
class loader.
Gary Xue
"Mark" <m@n.com> wrote in message news:dk85fk$vik$1@news.eclipse.org...
> I don't think so. The driver is being loaded via a scripted dataset.
>
> Also, the problem I am getting is with a dll - I am using DB2 app driver.
>
> If I connect to a session in Hibernate first I get this in the report when
I
> preview it:
> "Script engine error: Wrapped
> org.hibernate.exception.JDBCConnectionException: Cannot open connection
> (DataSet:MEM.open#39)"
>
> If I preview the report first I get this in Hibernate Tools:
> "org.hibernate.console.HibernateConsoleRuntimeException: Problems while
> loading database driverclass (COM.ibm.db2.jdbc.app.DB2Driver)
> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
> classloader
> java.sql.SQLException: java.lang.UnsatisfiedLinkError: Native Library
> C:\Program Files\SQLLIB\bin\db2jdbc.dll already loaded in another
> classloader
> "
>
> I've had this issue with other tools, but I have been able to live with
it.
> The problem now is that I am going to have Report Writers building the
> reports and eventually doing some HQL development. I don't think they can
or
> will deal with the issue.
>
> Is there an easy way to preview/run the reports externally to Eclipse - so
> it runs in another JVM? Just for the real data. They can build the
reports
> with dummy objects (like in the demo).
>
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:dk843c$tgq$1@news.eclipse.org...
> > Mark,
> >
> > I am not sure how to solve this, partly because I didnt think this would
> > be an issue, but does making a copy of it and using the Manage Drivers
> > button in the Data Source connection wizard make a difference?
> >
> > Jason Weathersby
> > BIRT PMC
> >
> > "Mark" <m@n.com> wrote in message news:dk834v$s61$1@news.eclipse.org...
> >>I know this is not specific to BIRT,
> >>
> >> but ..
> >>
> >> I am trying to do BIRT and Hibernate Tools in the same IDE. Sadly when
> >> one loads the database driver, the other can't. So I have to restart
> >> Eclipse. But if the plugin doesn't load the driver itself, then it
can't
> >> find it. This is not specific to just these plugins. :(
> >>
> >> Anyone have any idea on how to solve this?
> >>
> >
> >
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.05873 seconds
Home