Integer into a List

[Prabha Dhandapani]

Hello everybody,
Below is the piece of code that needs a little attention.Is there a way to add a long type value into a List.If yes,please help me because it is very very urgent.Looking forward for help!

long seq = 10000;
if (!(trade_name == null || trade_name.trim().length() == 0))
  {
  trade_name = trade_name.trim();
  System.out.println("insertIntoAssocWordTable called for TRADE_NAME");
  insertIntoAssocWordTable(seq,trade_name,chemical_name,type);
  seq++;
  } 
private static void insertIntoAssocWordTable(
        long seq,
String assoc_word_root,
String assoc_word_alternate,
String type) {
StringBuffer insert = new StringBuffer();
insert.append("insert into assoc_word values(?,?,?,?)");
System.out.println("Inside insertIntoAssocWordTable method");
List parms = new ArrayList();
parms.add(seq); -------------- Error!
parms.add(assoc_word_root);
parms.add(assoc_word_alternate);
parms.add(type);
           DBBroker.executeUpdate(insert.toString(),parms);

the seq value that I am inserting into the table is a field of type NUMBER and NOT NULL.
Any help ASAP is appreciated.
Many Thanks in Advance,
Prabha

[Joe Ess]

It is polite to post the text of the error you are receiving. I take it that you are getting a complaint from the compiler that long argument is not an object. It is easy enough to wrap it in one:

parms.add(new Long(seq));

Most databases provide for some sort of autonumber or index field. It is a good idea to take advantage of it if you can. One less thing you need to do.

[Prabha Dhandapani]

Hello Mr.Joe,
Thanks for the help.It worked fine!I also appologize for not sounding polite.
Once again thanks for the help. We are planning to add a sequence to the table but as a temporary solution, we are doing it this way!
Thanks,
Prabha