473,326 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

DB2 8.2 JDBC Application --> CHARACTER and CHAR

Hi Everyone,

We recently migrated our database server from DB2 6.1 FP11 windows to
8.2 FP 8 windows. The migration was successful, without showing any
signs of failure of any sort.

We have a jdbc application which interacts with the db2 8.2 (ESE
windows) database through a DB2 6.1 windows Client.

Java Version --> JDK 1.4.2_07

In my application, I am using the following method to retrieve a
specific column's (CHAR based column) SQL datatype from the database:

ResultSetMetaData rsmd --> rsmd.getColumnTypeName(int column_number)
Earlier, when my client and server were both on 6.1, and whenever I was
executing the above method, it was returning the column datatype as
'CHARACTER'.

Now, ever since we migrated our server to 8.2, whenever we try to
execute the above method using a DB2 8.2 FP 8 client, that column's
datatype is retreived by JDBC as 'CHAR' and not 'CHARACTER'. The same
method still works as we expect it to be, when we use the DB2 6.1
client to connect to the database.

Any pointers on how to correct this?

regards,
dotyet

Nov 12 '05 #1
2 1569
dotyet wrote:
Hi Everyone,

We recently migrated our database server from DB2 6.1 FP11 windows to
8.2 FP 8 windows. The migration was successful, without showing any
signs of failure of any sort.

We have a jdbc application which interacts with the db2 8.2 (ESE
windows) database through a DB2 6.1 windows Client.

Java Version --> JDK 1.4.2_07

In my application, I am using the following method to retrieve a
specific column's (CHAR based column) SQL datatype from the database:

ResultSetMetaData rsmd --> rsmd.getColumnTypeName(int column_number)
Earlier, when my client and server were both on 6.1, and whenever I was
executing the above method, it was returning the column datatype as
'CHARACTER'.

Now, ever since we migrated our server to 8.2, whenever we try to
execute the above method using a DB2 8.2 FP 8 client, that column's
datatype is retreived by JDBC as 'CHAR' and not 'CHARACTER'. The same
method still works as we expect it to be, when we use the DB2 6.1
client to connect to the database.

Any pointers on how to correct this?

regards,
dotyet

CHAR and CHARACTER are synonyms. So it isn't broken.
Is the change a major issue for you? Just trying to find out whether
there is a problem or mere confusion.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
i understand that they are both the same. however my application is
currently looking for 'CHARACTER' and not 'CHAR'. So, if there is no
work around, then I am forced to make changes through the application
code, which will be a bit painful.
regards,
dotyet

Serge Rielau wrote:

CHAR and CHARACTER are synonyms. So it isn't broken.
Is the change a major issue for you? Just trying to find out whether
there is a problem or mere confusion.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Matt Garman | last post by:
What is the "best" way to copy a vector of strings to an array of character strings? By "best", I mean most elegantly/tersely written, but without any sacrifice in performance. I'm writing an...
4
by: Victor Hadianto | last post by:
Hi, If I have an XmlDocument DOM how do I insert <?mso-application progid="ProgId.Here"?> programmatically? -- Victor Hadianto http://www.synop.com/Products/SauceReader/
4
by: tommy | last post by:
hello everbody, i write a little asp-application with forms-authentication. i copy my aspx-files with web.config to my webspace and i get the error above... i tried to set the...
0
by: vdex42 | last post by:
Apologies if this has been asked before, but I haven't been able to find the answer to this yet: My problem is that .NET will not allow me to insert escaped '>' characters (i.e. &gt;) within the...
8
by: Marco Costa | last post by:
Hello all, I wrote a simple ODBC wrapper class that used code like this ( not real code, added types for clarification ): char** type bufs = new char* for( int i = 0 ; i < numberOfColumns ;...
2
by: hharry | last post by:
hello all, is there a quick way to convert a zipcode of type int, to a 5 character char value ? e.g. declare @zip int declare @czip char(5) select @zip = 2109 select @czip = convert(char,...
1
by: Pete Geraghty | last post by:
I want to use DatabaseMetadata to retrieve details of those stored procedures which belong to the current schema. How can I find out what is the current schema for an existing Connection? Or...
6
by: Andrew Wingorodov | last post by:
i have std::vector<stringarg; for dynamic program configuration. i need get const char* argv; for execv(3). how i can make its simple? there may be ready solutions? -- www.andr.ca
2
by: arjunapalghuna | last post by:
Is it required to set path in Environment Variable for Oracle database to run a JDBC application? If it is, what is the path for Oracle 10g?
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.