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

  1. Fòrum: Vertabelo
0
Fixed

SQLite Autoincrement

Javier Tejedor fa 9 anys • updated by hepeyowa fa 6 anys • 3

Hello, I have exported the SQL for a SQLite Database. In the tables, I have PRIMARY_KEY and AUTOINCREMENT.


CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL AUTOINCREMENT,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

Using this format, SQLite is throwing an error due the AUTOINCREMENT is not declared as PRIMARY KEY yet (it is being done in the CONSTRAINT). I am using the java sqlite-jdbc-3.8.11.2.jar driver from org.xerial


SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)


A possible correct syntax (regarding to the SQLite documentation https://www.sqlite.org/autoinc.html ) for the previous example would be:


CREATE TABLE CSS_AT_RULES (	
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT,	
    css_version varchar(10) NOT NULL,	
    syntax_id integer NOT NULL
);

Could you please confirm if I am right?


Regards,

Javier.

Answer
anonymous fa 9 anys

Hello,

Yes, it is a bug.
I think, the correct syntax is (as sqlite's faq mentions https://www.sqlite.org/faq.html#q1):

CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

If column has type 'integer' and 'primary key' then has also 'autoincrement'.

In this case, the fastes solution is to unset an autoincrement option.


I hope this helps.


0
Declined

Is posible to share tables between diagrams?

Toni Aracil Sobrino fa 6 anys • updated by Adam Mościcki fa 6 anys • 1

I need to share tables between diagrams. Because I need a change in one entity be replicated to table shared table with other diagram. Is that possible?


Thanks.

+1
Under review

Please add adjustable rules for all of us anal-retentive people

Eric Norcross fa 9 anys • updated by Joana PhotoshopSupply fa 6 anys • 3

I spend waaaaay too much time trying to align and make boxes the same size

0
Under review

how to use the reverse Reverse engineering to? 14?

mo aarab fa 9 anys • updated by Rafał Strzaliński (Senior Engineer) fa 6 anys • 4

is it possible to get an example to SQL Server 14? I'm don't know anything of java

Answer
Adam Mościcki fa 9 anys

Please:
1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar
2. Download jdbc driver https://www.microsoft.com/en-us/download/details.aspx?id=11774 (exe file should install jar somewhere)
3. In the download folder do:


java -cp .:reverse-engineering-1_6_12.jar:sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] -user USERNAME -password PASSWORD -o OUTPUT_FILENAME


I hope this helps.


Best regards,

Adam Mościcki

0
Respost

Getting error trying to use reverse engineering tool

Kent Graziano fa 10 anys • updated by Yomiyu Malifu fa 6 anys • 11
I am using this command line on Windows 8:
java -cp .;reverse-engineering-1_6_9; com.vertabelo.reverse.Main -url jdbc:oracle:thin:@//localhost:1521/xe -user dv -password xx -o dv_demo

But get the error: Could not find or load main class com.vertabelo.reverse.Main
I am running in my \vertabelo directory. I downloaded the .jar file to that folder.

I am very bad at command line so have no idea how to fix this.
0
Completat

login history

Samir Agarwal fa 9 anys • updated by Jeffrey E fa 6 anys • 1

I need the login history of employees also like google docs if you can show history with changes made by employees

+1
Under review

Need for in-house version

shepel oleksiy fa 6 anys • updated by Jarosław Błąd (CEO) fa 6 anys • 1

Hi guys,

Do you plan to develop desktop version of Vertabelo modeling tool, since there is no modern analogs of Erwin which is almost obsolete?

0
Under review

FK tag in "properties" column of auto-generated documentation

Luka Čubelić fa 6 anys • updated by Mariusz Zakrzewski fa 6 anys • 1

Is it possible to add the "FK" in the "properties" column of the fields that are foreign keys in some table, just like it says "PK" for the primary key?

+1
Planned

Add data type support for PostgreSQL

Matthew Weber fa 6 anys • updated by Rafał Strzaliński (Senior Engineer) fa 6 anys • 1

This is the datatype recommended by PG to use but it isn't supported.

Likewise Serial2 would be a nice addition

0
Respost

How to create a query joining tables

Fabien SARFATI fa 6 anys • updated by Adam Mościcki fa 6 anys • 1

Hello all,


I have existing tables in a database, in a star schema.

I would like a visual tool to create a query joining all tables of the star schema.

Can I do this with Vertabelo ?

Thank you very much


Answer
Adam Mościcki fa 6 anys

Hello,

No, you can't. There is no such option.

Best regards,
Adam



Customer support service by UserEcho