You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
We would like to upgrade our DT server wich is at version 4.8. Our installation uses MS SQL database with case sensitive collation. We tried to upgrade with latest release, but runing of v4123Updater.java failed with errors on missing objects. This is because of our db has system view objects with small case letters, but in the v4123Updater.java upgarde script they are written with upper case letters. I'm not a developer, but I would like to solve this problem, so I spent a lot of time with it. I've tried to modify this SQL command and rebuild the dependency-track-bundled.jar, but it failed on tests. Finally, I turn to the community for help. Could someone create a dependency-track-bundled.jar with a modified v4123Updater.java with this SQL command in line 156?
SELECT OBJ."name" AS TABLE_NAME
, COL."name" AS COLUMN_NAME
, CON."name" AS NAME
, CON."definition" AS DEFINITION
FROM sys.check_constraints AS CON
LEFT JOIN sys.objects AS OBJ
ON OBJ.object_id = CON.parent_object_id
LEFT JOIN sys.all_columns AS COL
ON COL.column_id = CON.parent_column_id
AND COL.object_id = CON.parent_object_id
WHERE OBJ."name" IN ('COMPONENT', 'PROJECT')
AND COL."name" = 'CLASSIFIER'
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Hello,
We would like to upgrade our DT server wich is at version 4.8. Our installation uses MS SQL database with case sensitive collation. We tried to upgrade with latest release, but runing of v4123Updater.java failed with errors on missing objects. This is because of our db has system view objects with small case letters, but in the v4123Updater.java upgarde script they are written with upper case letters. I'm not a developer, but I would like to solve this problem, so I spent a lot of time with it. I've tried to modify this SQL command and rebuild the dependency-track-bundled.jar, but it failed on tests. Finally, I turn to the community for help. Could someone create a dependency-track-bundled.jar with a modified v4123Updater.java with this SQL command in line 156?
SELECT OBJ."name" AS TABLE_NAME
, COL."name" AS COLUMN_NAME
, CON."name" AS NAME
, CON."definition" AS DEFINITION
FROM sys.check_constraints AS CON
LEFT JOIN sys.objects AS OBJ
ON OBJ.object_id = CON.parent_object_id
LEFT JOIN sys.all_columns AS COL
ON COL.column_id = CON.parent_column_id
AND COL.object_id = CON.parent_object_id
WHERE OBJ."name" IN ('COMPONENT', 'PROJECT')
AND COL."name" = 'CLASSIFIER'
Beta Was this translation helpful? Give feedback.
All reactions