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 9 jaar geleden • bijgewerkt door anonymous 9 jaar geleden • 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



Antwoord
anonymous 9 jaar geleden

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
Beantwoord

Vertabelo tutorial

Mario Nardi 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 2
How can I watch Vertabelo tutorial again, I accidentally cancelled it!
Antwoord
Jack Polkowski 9 jaar geleden
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
Beantwoord

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

Jason Ethridge 9 jaar geleden • bijgewerkt door Jarosław Błąd (CEO) 9 jaar geleden • 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
Voltooid

Get versioned models using API

Raymond Roelands 10 jaar geleden • bijgewerkt door Rafał Strzaliński (Senior Engineer) 9 jaar geleden • 5
It would be nice if the API also supports retrieving a specific version or tag of a model
0
Beantwoord

How to move a column up or down within a table

Tanuj Nayanam 9 jaar geleden • bijgewerkt 9 jaar geleden • 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
Beantwoord

Please, switch my trial account to academic account

Venkata Siva Sandeep Maddali 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 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 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 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
Beantwoord

Share button is not active

Ganbayar Gansukh 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 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
Antwoord
Jack Polkowski 9 jaar geleden
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
Under review

Error in view builder using LEAD function

Kent Graziano 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 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
Beantwoord

request for switching my account to the academic one

Wenyuan Gao 9 jaar geleden • bijgewerkt door Jack Polkowski 9 jaar geleden • 1
Antwoord
Jack Polkowski 9 jaar geleden
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