Your feedback is highly appreciated! Let's make Vertabelo even better.
reverse engineering fails if any function-based index exists
Dzień dobry
- get reverse-engineering-1_6_9.jar
- oracle 11.2.0.4.0
- create a table that uses fbi (a function based index)
create table
AAA
(
x number
);
create index aaa_idx1 on AAA(upper(x));
4. call the reverse-engineering-tool
Exception in thread "main" com.vertabelo.reverse.nr: Column SYS_NC00002$ not found in AAA
Solution:
You use in your code
paramDatabaseMetaData.getString("COLUMN_NAME");
but you'll need to check if this column really exists via DatabaseMetaData.getColumns before doing that
Unfortunately, Vertabelo doesn't support this construction now - indexes may have only columns from the table. We have this feature on our roadmap, but it's not available yet.
I've fixed the problem in the reverse-engineering tool so that such indexes were ignored and listed at the end of the reverse-engineering operation. Here is a link to the JAR with this issue fixed: reverse-engineering-1_6_10.jar
Please, check if it works well now.
Regarding indexes with expressions, I'd suggest placing them manually in the "Additional SQL scripts" section in table properties. This way, they'll be present in the output SQL script.
I look forward to your feedback.
Vertabelo tutorial
1. Go to the diagram (open any of your models or create a new one).
2. In the top menu bar, click Help.
3. From the drop-down menu, choose Take application tour.
You can also watch our video tutorials:
How to manage large database diagrams in Vertabelo
How to create a reference in Vertabelo
How do I place a table in a subject area by editing the xml from the reverse engineering tool
Get versioned models using API
How to move a column up or down within a table
Please, switch my trial account to academic account
Copy relationships along with table shortcut
Share button is not active
I do believe this button was active at some point time ago
Inactive "share" button means that you are not the owner of the model and you can't invite new persons to share it.
If you'd like to check your role in the model, go to the "Model details" panel. For that particular model, your role is set as an editor.
I noticed that in your case the model had been shared with you by the owner who then closed his/her account. So at the moment the model doesn't have its owner.
If you would like to share it with other persons, first you must clone it. Once again, go to the "Model details" panel, then click the button "Clone model" on the right. Since you are the owner of the cloned model, you can share it with other persons.
I hope I helped you.
Best regards and enjoy Vertabelo!
Error in view builder using LEAD function
SELECT
Best regards and enjoy Vertabelo!
Служба підтримки клієнтів працює на UserEcho
