Hy Eldo,



you might use the remote ip address and the system time in milliseconds and convert them into a String. I usually do so when implementing my own Session-classes.



Holly

Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

You can create a sequence with :

CREATE SEQUENCE
schema.your_sequence_name start with 1
increment by 1;



to select the next id from this sequence :

select your_sequence_name.NEXTVAL from DUAL;

or to select the current val :

select your_sequence_name.CURRVAL from DUAL;



you can use next id directly in your insert statement

insert EMPLOYEE(ID,NAME)values(your_sequence_name.NEXTVAL,"JOHNN");


or you can use it a WHERE clause too.


Good luck.

Hi,

There are few solutions, and based on the type of technology (i.e.: EJB) you need to use you could choose the better one.

With an J2EE you can apply one of the common patterns that you can find on the net. Interesting examples are CMP Primary Key Sequence Generated By Bean Self Cache or HIGH/LOW Singleton+Session Bean Universal Object ID Generator or Sequence and CMP or even GUIDs without Singletons and Databases.

These are all good solutions for a J2EE environment, but the logic could be applied also to a not-J2EE environment. The simplest solution could be:

create a simple table with just one single row and one single field. Then every time you need a new Id, you select the value from the table and then you update it. You can speed up the process in many ways (threading solution for the update, caching the values, etc). Once I saw a system that was providing an alphanumeric ID that was the current time in millis plus a counter... very simple 'no database' solution.

Take a look at those patterns and you can have great suggestions.