| DB2 Problem [message #94667] |
Mon, 28 November 2005 09:33  |
Eclipse User |
|
|
|
Originally posted by: josemcca.ie.ibm.com
Hi, I've just installed BIRT 1.0.1, and I can connect to the sample =
database and create the sample reports without any problems. However, I =
=
cannot create a JDBC connection to DB2. In the Data Sources wizard, I've=
=
added in the db2java.zip file to the list of JAR files and the drivers =
appear in the list of drivers, but not all of them appear when I try to =
=
create the Data Source, the app driver is missing, but the net driver is=
=
present. When I do try the net driver, Eclipse freezes up and I have to =
=
kill the eclipse process and restart it.
Has anyone had similar problems and know how to solve it?
I've done any number of searches to try and find a solution, but no luck=
Joe
|
|
|
| Re: DB2 Problem [message #94680 is a reply to message #94667] |
Mon, 28 November 2005 10:20  |
| Eclipse User |
|
|
|
josemcca@ie.ibm.com wrote:
> Hi, I've just installed BIRT 1.0.1, and I can connect to the sample
> database and create the sample reports without any problems. However, I
> cannot create a JDBC connection to DB2. In the Data Sources wizard, I've
> added in the db2java.zip file to the list of JAR files and the drivers
> appear in the list of drivers, but not all of them appear when I try to
> create the Data Source, the app driver is missing, but the net driver is
> present. When I do try the net driver, Eclipse freezes up and I have to
> kill the eclipse process and restart it.
> Has anyone had similar problems and know how to solve it?
> I've done any number of searches to try and find a solution, but no luck
> Joe
Hi Joe;
I'd encourage you to use the DB2 type 4 driver (db2cc.jar - don't forget
the license file too). We have had no issues with setup/config.
I have had a number of issues with db2java.zip, but got around most of
them by renaming the db2java.zip file to db2java.jar. This seems to make
alot of apps (including BIRT and Tomcat) much happier.
Pete H
|
|
|
| Re: DB2 Problem [message #95381 is a reply to message #94680] |
Tue, 29 November 2005 14:30 |
| Eclipse User |
|
|
|
Originally posted by: m.n.com
Pete H wrote:
> josemcca@ie.ibm.com wrote:
>
>> Hi, I've just installed BIRT 1.0.1, and I can connect to the sample
>> database and create the sample reports without any problems. However,
>> I cannot create a JDBC connection to DB2. In the Data Sources wizard,
>> I've added in the db2java.zip file to the list of JAR files and the
>> drivers appear in the list of drivers, but not all of them appear
>> when I try to create the Data Source, the app driver is missing, but
>> the net driver is present. When I do try the net driver, Eclipse
>> freezes up and I have to kill the eclipse process and restart it.
>> Has anyone had similar problems and know how to solve it?
>
>
>> I've done any number of searches to try and find a solution, but no luck
>
>
>> Joe
>
>
> Hi Joe;
> I'd encourage you to use the DB2 type 4 driver (db2cc.jar - don't forget
> the license file too). We have had no issues with setup/config.
> I have had a number of issues with db2java.zip, but got around most of
> them by renaming the db2java.zip file to db2java.jar. This seems to make
> alot of apps (including BIRT and Tomcat) much happier.
> Pete H
>
>
Pete, does db2cc.jar require any processes to be running on the DB2
server like the .Net driver does?
|
|
|
|
|
| Re: DB2 Problem [message #99947 is a reply to message #99918] |
Thu, 15 December 2005 19:40 |
| Eclipse User |
|
|
|
Originally posted by: garry.espe.chsinc.com
I am answering my own post. I copied the sole jar file to the BIRT jdbc
driver folder in eclipse. Then I restarted eclipse. Even though I see
all the other drivers from the db2java.zip file -- which no longer is
linked to the BIRT plugin, the type 4 driver now works. The dataset
preview displays the sql results. The simple, tabular report, however,
does not show the results. The dataset is bound to the report table. Is
there a log file I can check?
|
|
|
Powered by
FUDForum. Page generated in 0.05022 seconds
Home