Your feedback is highly appreciated! Let's make Vertabelo even better.

  1. Forum: Vertabelo
0
Fixed

​​reverse engineering fails if any function-based index exists

Ilya Kharlamov vor 9 Jahren • aktualisiert von anonymous vor 9 Jahren • 2

Dzień dobry

  1. get reverse-engineering-1_6_9.jar
  2. oracle 11.2.0.4.0
  3. 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

at com.vertabelo.reverse.ns.a(:1413)
at com.vertabelo.reverse.ns.a(:1392)
at com.vertabelo.reverse.ny.a(:317)
at com.vertabelo.reverse.ns.b(:550)
at com.vertabelo.reverse.ns.c(:412)
at com.vertabelo.reverse.ns.b(:185)
at com.vertabelo.reverse.Main.main(:491)


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



Antwort
anonymous vor 9 Jahren

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.

0
Beantwortet

Vertabelo tutorial

Mario Nardi vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 2
How can I watch Vertabelo tutorial again, I accidentally cancelled it!
Antwort
Jack Polkowski vor 9 Jahren
For other users who also need to run the 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



0
Beantwortet

How do I place a table in a subject area by editing the xml from the reverse engineering tool

Jason Ethridge vor 9 Jahren • aktualisiert von Jarosław Błąd (CEO) vor 9 Jahren • 3
I have a large database that I would like to pre-group via subject areas before I import the xml into Vertabelo. Is it possible to hand edit the reverse engineer xml to add several subject areas and then associate tables with those subject areas?
0
Fertiggestellt

Get versioned models using API

Raymond Roelands vor 10 Jahren • aktualisiert von Rafał Strzaliński (Senior Engineer) vor 9 Jahren • 5
It would be nice if the API also supports retrieving a specific version or tag of a model
0
Beantwortet

How to move a column up or down within a table

Tanuj Nayanam vor 9 Jahren • aktualisiert vor 9 Jahren • 4
Suppose I have 10 columns in my vertabelo table diagram. Now by mistake I have put the last column as Primary Key. Is there any way to move up that primary key column in the table diagram?
0
Beantwortet

Please, switch my trial account to academic account

Venkata Siva Sandeep Maddali vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 2
I am not able to convert my account to an academic one. Please help me.
0
Not a bug

Copy relationships along with table shortcut

Kent Graziano vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 5
When I do a copy and past shortcut for multiple tables that are related, it should automatically show the relationships between those tables. Now it looks like I must create a 2nd relationship between the shortcut tables.
0
Beantwortet

Share button is not active

Ganbayar Gansukh vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 2
I have an academic plan, and the share button is not active. Does academic plans not able to share the model?

I do believe this button was active at some point time ago
Antwort
Jack Polkowski vor 9 Jahren
Hi!
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!
0
Wird überprüft

Error in view builder using LEAD function

Kent Graziano vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 3
When I try to create a view using this SQL I get a parsing error:
SELECT
dbms_obfuscation_toolkit.md5(upper(trim(HC.COUNTRY_ABBRV))
|| '^'
|| TO_CHAR(SC.SAT_Load_DTS, 'YYYY-MM-DD')) AS DIM2_COUNTRY_KEY,
HC.COUNTRY_ABBRV,
SC.COUNTRY_NAME,
SC.SAT_Load_DTS AS EFFECTIVE_DTS,
LEAD(SC.SAT_Load_DTS) OVER (PARTITION BY SC.HUB_COUNTRY_KEY ORDER BY
SC.SAT_Load_DTS) AS EXPIRE_DTS,
SC.SAT_Rec_SRC AS REC_SRC
FROM
HUB_COUNTRY HC,
SAT_COUNTRIES SC
WHERE
HC.HUB_COUNTRY_KEY = SC.HUB_COUNTRY_KEY
0
Beantwortet

request for switching my account to the academic one

Wenyuan Gao vor 9 Jahren • aktualisiert von Jack Polkowski vor 9 Jahren • 1
Antwort
Jack Polkowski vor 9 Jahren
Hi! Your account has been switched to the academic one. After logging in, you'll be requested to complete the registration form.
Best regards and enjoy Vertabelo!


Customer support service by UserEcho