wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes How to create schema in MyEclipse Derby Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to create schema in MyEclipse Derby" Watch "How to create schema in MyEclipse Derby" New topic
Author

How to create schema in MyEclipse Derby

udaykiran pulipati
Greenhorn

Joined: Dec 21, 2012
Posts: 12

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


UdayKiran Pulipati
Anthony Roberts
Greenhorn

Joined: Aug 29, 2011
Posts: 14
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to create schema in MyEclipse Derby
 
Similar Threads
mySQL INTEGER == LONG in Java and ....???
Hypersonic DB question
Create table error
Issue while update the parent recored and removed some child records
SQL Query for this?