Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Advanced Search
HSQL DDL generation, varbinay is mapped to longvarbinary  
Forum Index -> DB Visual ARCHITECT SQL (DB-VA SQL)
Author Message
sergey.zakharov


Joined: 2007/12/17
Messages: 2

Offline

During development of ER diagram I found that varbinay type is mapped to longvarbinary in case of HSQLDB DBMS. The result looks like:

create table TEST (ID bigint generated by default as identity (start with 1), IP_ADDRESS longvarbinary(16), primary key (ID));

This is wrong format for HSQLDB and it is resulted in: "Unexpected token in statement [create table....]"

////////////////////////////////////////

Sorry. This is wrong forum. Topic moved to:
http://forums.visual-paradigm.com/posts/list/0/2742.html
 
 
   Forum Index -> DB Visual ARCHITECT SQL (DB-VA SQL)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil