Why would number columns' scale and/or precision differ in JDBC from Oracle 10 to 11? -

-

For our database development we have a complete schema DDL script in one hand, to install scratch, But sequential "delta" scripts are upgraded (each script is recorded as executed or not in the special database table).

To test it, we have an ant target which installs an older version, upgrades it and compares it to a newly created schema, to compare the schema to JDBC Metadata And it works very well with Oracle 10.

Now we have upgraded to Oracle 11 and have moved from ojdbc14.jar to ojdbc6.jar. The test still runs green on Oracle 10, but we get (two specific examples) on Oracle 11: 

  table & lt; Table X & gt; Column & lt; Column A & gt; & Lt; New schema & gt; In the form of no NUMBER (1,0), but as (& 0) advanced schema & gt; Does not have NUMBER (0,0) Table & lt; Table Y & gt; Column & lt; Column B & gt; As (0, -127) as NUMBER & lt; New schema & gt;, but not NUMBER (0,0) as & lt; Upgraded Schema & gt;

Almost looks (-127 is not a good scale now) Well, if we did something wrong, but a lot of files have been written earlier and here script statement:

DDL script: 

  create table & lt; Table X & gt; (... & lt; column B & gt; NUMBER (1) DEFAULT 0 zero, ...) Create a table & lt; Table Y & gt; (... & lt; column B & gt; NUMBER DEFAULT 1 zero, ...)

Delta script: 

  optional table & lt ; Table X & gt; Add (& lt; Column A & gt; NUMBER (1) DEFAULT 0 Faucet) Optional Table & lt; Table Y & gt;

And here is the JDBC metadata code: 

  column of the public class {string name; & Lt; Column B & gt; NUMBER DEFAULT 1 NOT NULL) Int scale; Integer accuracy; Boolean Nalabal; String type; Public column (resulting metadata metadata, at column) throws SQLException {name = metaData.getColumnName (column); Type = metaData.getColumnTypeName (column); Scale = metaData.getScale (column); Exact = metadata.jetpression (column); Totals = Metadata. Successful (column) == ResultantMatDataClallMon; } @ Override public string toasting () {return type + "(" + precise + "," + scale + ")" + (faucetable? "NULL": "NOT NULL"); }}

Yes, the column starts with index 1 and it is the toting value () which is used to compare different columns (above error is also used in the output is).

I have debug this code and as far as I can see, the Oracle JDBC driver receives these values ​​when "describing" the table to prepare metadata internally.

Note that both schemas are very similar to database examples and JDBC connections created by the same JDBC library. Similar discrepancies arise when using the old ojdbc14.jar, but never in Oracle 10.

Can anyone have this how can it be? I'm stuck and we have been left without a reliable test of our database upgrade script.

Please vote for this to be a bug in the ojdbc driver. He said, I could probably remove DDL I'll call the DBMS_METADATA package. ResultSetMetaData focuses more on determining the types in a result set, as opposed to determining the metadata of database objects themselves.


Comments

Post a Comment

Popular posts from this blog

oracle - The fastest way to check if some records in a database table? -

-
I have a big table to work with. I have to see that there are some records whose parent_id is equal to my passing value. Currently I do this by implementing "my_table using select count (*) where parent_id =: id"; If the result> 0, it means that they exist. Because this is a very large table, and I do not care what the actual number of records present, I just want to know if it exists, so I think count (*) Bit is disabled. How do I apply this requirement most quickly? I'm using Oracle 10. # Tips for Hibernation & amp; Tricks It suggests writing in such a way: Integer number = (integer) session .createQuery ("Select Count (*) to ...."). UniqueResult (); I do not know what is the magic of the unique rule? Why does it fast? To compare, select "1 from mytable where parent_id = passId and rowrum", which is more efficient? If you are not interested in the number of records, then there is an EXISTS query one: Select 'y'
Read more

php - multilevel menu with multilevel array -

-
Just ask someone to solve this problem? I want to create a multilevel menu I can not find the right solution generated with multilevel array, it always gets an array_push error My study came from the original idea But still my Can not match the need. This is my MySQL [code] ----- --------------------- --------------- | ID | PARENT_ID | Name | Link | Seq | 1 | 0 | Dashboad | Dashboard / | 1 | 2 | 0 | Menu 1 | Menu 1 / | 2 | 3 | 0 | Menu 2 | Menu 2 / | 3 | 4 | 0 | Menu 3 | Menu 3 / | 4 | 5 | 2 | Joint Add / | 1 | 6 | 3 | Joint Add / | 1 | 7 | 2 | Edit | Edit / | 2 | 8 | 4 | Joint Add / | 1 ------------------------------------------ [/ Code] I want to do something like this in my array array ('dashboard' = & gt; array ('id' = & gt; '' 'Dame' = & gt; 'Dashboard', 'Title' = & gt; 'Dashboard', 'MatchMin' = & gt; Base_URL (). 'Dashboard /', 'Active' => = & Gt; NULL), &
Read more

jQuery UI: Datepicker month format -

-
I am trying to change the format of the month that shows in the popup (not in the date that the picker actually I do not have any choice anywhere to do this, do I like to use a sub-string () or something else? What I normally display is Trying to change: Class = "ui-datepicker-title"> January & lt; / span & gt; ... & lt; / div & gt; Div>
Read more