File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to create schema in MyEclipse Derby

 
udaykiran pulipati
Greenhorn
Posts: 12
Hibernate Java MyEclipse IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I want create a new schema in myeclipse derby but gives an error when datatype int is used.

here is my code:



I need PHONENO column with size 10 and PINCODE column with size 6
 
Anthony Roberts
Greenhorn
Posts: 14
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Datatype INT or INTEGER doesn't take a parameter. Different numeric types can hold numeric values between certain ranges. For INTEGER, it is -2147483648 to 2147483647. If you actually want to store the numeric characters, then use one of the character types, not numeric types. However, given the names of your columns, phoneno and pincode, I would guess that you really need to use character data, anyway, as they won't be used as integers.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic