Home > Default > Remain case for table column name

Remain case for table column name

October 11Hits:0
Advertisement
Hello, i am a java developer. I had helped my company to develop a java application all the while and before this we are using ms sql server database. Recently, we want to migrate the database to oracle database. The problem is, in our application, we use the resultsetmetadata to retrieve all the table column name and respective data and store in hashtable, but in ms sql server the table column name is not all in uppercase. When our application try to get the data using hashtable.get("aColumnName"), it will fail because in oracle the column name is all in uppercase. There are more than 1000 jsp page and java code that used the same method to get data, so if i want to change all the code to uppercase, it will consume a lot of unproductive time, is there any way to solve this?

Answers

I assume that your code builds an SQL statement like "select * from ??? where table_name = '????';".
If this is correct just wrap the table_name in UPPER(table_name).
If my assumption is incorrect then please give more information.
James.

Read other 2 answers

Tags:

Related Articles

  • Remain case for table column nameOctober 11

    Hello, i am a java developer. I had helped my company to develop a java application all the while and before this we are using ms sql server database. Recently, we want to migrate the database to oracle database. The problem is, in our application, w

  • How to check if data is stored in UPPER case in table columns?November 30

    What is the SQL statement/command to check that the data in a table column is stored as UPPER case??Try the following, where ename is the column you want to check. select * from emp where ename != UPPER(ename)Read other 2 answers

  • BUG: Export DDL and Data fails for mixed case table/column namesNovember 30

    Hi there, I have found a bug in SQL Developer. See details below. Description: When "Export DDL and Data) function is used on a table/columns not named in UPPERCASE, sql generated by SQL Developer is invalid. Steps to reproduce: - open SQL Developer,

  • Moving table columns is very slowNovember 30

    In my application moving table columns is very slow, with the rendering of table cells dragging behind the rendering of the table cell (using Java 1.5). I use a custom table cell renderer that subclasses a JPanel and contains a JTextField. I checked

  • Which option to use to search text in multiple table columnsOctober 11

    Hi, I have a case where I have 4 db tables. On the UI there is an option to search a keyword from some columns of these 4 tables. Table1 = summary, description are the columns user can search on Table2 = project_name is the column user can search on

  • Problem with LinkToURL in a table columnOctober 11

    Hi, let's say we have a LinkToURL element with a text and an image. Then a click on the text OR a click on the image navigates to the given URL. This behaviour changes if you put the LinkToURL element in a table column. In that case the link is execu

  • How to stop table columns widths from driftingOctober 11

    I discovered that all the columns widths of my tables change on their own, leading me with tables of different columns widths where I wanted to maintain a strong cohesion of presentation among them. Here is a scenario to reproduce and understand the

  • Nested Composite Component Doesn't work for table columnOctober 11

    I have reported this issue as defect 1541 but I'm hoping someone my have a suggestion on a work around for this. Here is the issue I am attempting to use composites to represent a table column. I have tried this with both IceFaces and the standard im

  • Require sum value of one table to be inserted into another table columnOctober 11

    Hi I have a table which contains a list of parts and their prices required for an assembly. I am trying to calculate the total from this part lists and put into the total price column for the assembly (another table column). My method was to calculat

  • How to use selectOneList in a updateable data table columnOctober 11

    Hi, Could someone tell me how to use selectOneList (source from a vo X) in an updateable data table column (from another vo Y)? I successfully created a page with the data table. However, strange things happened: 1) the values populated on the select

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.632 s.