|
Re: COM.ibm.db2.jdbc.net.DB2Driver (v8.1) - for db2 [message #897402 is a reply to message #897334] |
Tue, 24 July 2012 01:51 |
|
what is the column type? If you select * from the first table only do
you get results?
Jason
On 7/23/2012 11:53 AM, Carlos Ferrer wrote:
> Database: DB2 for Z/OS ver 9.1
> BIRT ver 3.7.2
> JDBC Driver: COM.ibm.db2.jdbc.net.DB2Driver (v8.1)
>
> I have been successful in using COM.ibm.db2.jdbc.net.DB2Driver (v8.1) to access a stored proc from BIRT. It is bringing back data in preview results. from the stored proc
>
> Then I tried doing a plain sql to bring back id nos to demo BIRT to other developers who will be using BIRT. I saved my changes and had my settings set to only bring back 10 records. There is data, because I used Quantum DB to make sure data was out there using the same jdbc driver . So I executed the sql from BIRT via the preview results.
>
> The preview results indicates it returned 10 records. The preview shows the Column name but the data for the 10 records found isn't being displayed. I have uploaded the results. This only happens with this driver.
>
> Thanks for your help.
>
|
|
|
|
Re: COM.ibm.db2.jdbc.net.DB2Driver (v8.1) - for db2 [message #898629 is a reply to message #898543] |
Thu, 26 July 2012 22:09 |
|
Carlos
Is your error similar to:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=346673
Jason
On 7/26/2012 10:42 AM, Carlos Ferrer wrote:
> Sorry, was out 2 days.
> The column type is char(08). There are valid records, because when I
> run the same sql with a type 2 jdbc driver, the 10 records come back
> with data when I do a preview. I am trying to make sure we stick to one
> jdbc driver instead of having to mix 2 jdbc drivers.
> I can't use the type 2 across the board because I get a stored procedure
> error that I don't get with tye type 3 jdbc driver.
>
> Thanks.
|
|
|
Powered by
FUDForum. Page generated in 0.02303 seconds