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

0
Started

Image is not shown in blog post

Tomás 4 years ago updated by Rafał Strzaliński (Senior Engineer) 4 years ago 3
0
Answered

Reverse Engineering Error - Unable to initialize main class

aftab najib 5 years ago updated by naila123 naila123 4 years ago 4

Hi, I have just signed up to using Vertabelo and I am looking to use the reverse engineering tool to bring in all my tables from my database.

My Java is all setup and I have downloaded the latest version of the reverse engineering files version 19.4.0.

I have put all my files in one folder with the ojdbc6.jar and reverse-engineering.jar files.

When I run the following command in cmd:

java -cp .;reverse-engineering.jar;ojdbc6.jar com.vertabelo.reverse.Main -url "jdbc:oracle:thin:@//localhost:1521/xe" -user USERNAME -password password1234 -o localhost_file

I get the error:

Error: Unable to initialize main class com.vertabelo.reverse.Main
Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXBException

I have tried to search the forums, but I haven't found anyone coming up with this issue, so would really appreciate if any one could advise on how I could resolve this issue.

0
Answered

oracle identity ?

Ugo Peltier 4 years ago updated by Rafał Strzaliński (Senior Engineer) 4 years ago 1

Hi,


Starting v12c of Oracle, we can add identity column to tables, here is an explanation:

https://www.oracletutorial.com/oracle-basics/oracle-identity-column/#:~:text=Introduction%20to%20Oracle%20identity%20column,the%20surrogate%20primary%20key%20column.

How can I add this to the ERD definition in vertabelo ?

0
Answered

Using Subject area in reverse engineering

Ashwini Bhoite 4 years ago updated by Rafał Strzaliński (Senior Engineer) 4 years ago 3

I have imported a large database into Vertabelo and would like to group tables in subject areas. I can see the options in Subject area we have are only for creating new tables. I am trying a tedious process of dragging tables into subject area in the workspace section manually but because the database has a lot of tables, it is geting more time consuming. Am I missing an easy way to add tables to Subject area during reverse engineering?

0
Completed

Model subtypes using descriminator

Bo Bell 4 years ago updated 4 years ago 2

Any plans of implementing this ?

Its common approach for modelling subtypes. It does not influence generated table structures, but are a great help in understanding the model.

Descriminator.PNG

Answer

Hello,


This is possible in a logical database model. However with a little bit different notation. Moreover you can choose different generation strategies for an inheritance hierarchy that can be applied during generation of a physical model from a logical model. 

We don't plan to introduce such notation for physical database models as these models should reflect real physical objects in a database.

0
Completed

how to set foreign key

Anik Chowdhury 10 years ago updated by victor maricato 4 years ago 6
0

Reverse Engineering tool installation issues

Ashwini Bhoite 4 years ago updated by Daniel Sobotka 4 years ago 7

My java version is : openjdk version "11.0.2" 2019-01-15

and when I run the command

java --add-modules java.xml.bind -cp .;reverse-engineering.jar;ojdbc6.jar com.vertabelo.reverse.Main -url "jdbc:oracle:thin:@//localhost:1521/xe" -user USERNAME -password 
password1234 -o localhost_file

I get error : Error occurred during initialization of boot layer
java.lang.module.FindException: Module java.xml.bind not found

Is my java version not comaptible?

0
Completed

How can I delete my account?

BOHDAN HECHA 4 years ago updated by Rafał Strzaliński (Senior Engineer) 4 years ago 1

How can I delete my account?Because I have registered it not correctly, cause i am a student and it shows me that my trial period is ended.So as I understood I need to registrate it as a student.pls help me

0
Completed

Table should have primary key

Vidar567 4 years ago updated 4 years ago 3

Hello,

I have really weird problem. For some weeks of my work everything was alright, but today when I would like to create some projects vertabelo doesn't work well.

It gives me a warning message "Table should have primary key". Weeks ago my projects work well, but now warnings are in every project.


Image 990

Image 991

It has primary keys, but system doesn't see it.