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

  1. Foorum: Vertabelo
0
Fixed

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

Ilya Kharlamov 9 aastat tagasi • uuendaja anonymous 9 aastat tagasi • 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



Vasta
anonymous 9 aastat tagasi

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
Answered

Vertabelo tutorial

Mario Nardi 9 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 2
How can I watch Vertabelo tutorial again, I accidentally cancelled it!
Vasta
Jack Polkowski 9 aastat tagasi
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
Answered

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

Jason Ethridge 9 aastat tagasi • uuendaja Jarosław Błąd (CEO) 9 aastat tagasi • 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
Lõpetatud

Get versioned models using API

Raymond Roelands 10 aastat tagasi • uuendaja Rafał Strzaliński (Senior Engineer) 9 aastat tagasi • 5
It would be nice if the API also supports retrieving a specific version or tag of a model
0
Answered

How to move a column up or down within a table

Tanuj Nayanam 9 aastat tagasi • uuendatud 9 aastat tagasi • 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
Answered

Please, switch my trial account to academic account

Venkata Siva Sandeep Maddali 9 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 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 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 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
Answered

Share button is not active

Ganbayar Gansukh 9 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 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
Vasta
Jack Polkowski 9 aastat tagasi
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
Ülevaatamisel

Error in view builder using LEAD function

Kent Graziano 9 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 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
Answered

request for switching my account to the academic one

Wenyuan Gao 9 aastat tagasi • uuendaja Jack Polkowski 9 aastat tagasi • 1
Vasta
Jack Polkowski 9 aastat tagasi
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