(Msg. 2) Posted: Fri Mar 14, 2008 6:44 pm
Post subject: Re: Derby & Oracle. [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Mr. X. wrote:
> What is the equivalent for Derby, that is in oracle.
>
> 1. Select 1 from dual.
SELECT 1 FROM SYSIBM.SYSDUMMY1
(yes - the IBM roots can be seen)
> 2. How can I create sequences ?
Derby uses identity columns like SQLServer and MySQL
not sequences like Oracle.
(Msg. 3) Posted: Sun Mar 16, 2008 12:21 pm
Post subject: Re: Derby & Oracle. [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
For you answers :
1. Thanks.
2. I am looking for an alternative that is much like sequence
(table + some scripts ...), please.
(Msg. 4) Posted: Sun Mar 16, 2008 12:21 pm
Post subject: Re: Derby & Oracle. [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Mr. X. wrote:
> For you answers :
> 1. Thanks.
> 2. I am looking for an alternative that is much like sequence
> (table + some scripts ...), please.
Create a table mysequence with one column that are marked as identity.
(Msg. 5) Posted: Thu Mar 20, 2008 6:52 pm
Post subject: Re: Derby & Oracle. [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Arne Vajhøj wrote in
@news.sunsite.dk:
> Mr. X. wrote:
>> For you answers :
>> 1. Thanks.
>> 2. I am looking for an alternative that is much like sequence
>> (table + some scripts ...), please.
>
> Create a table mysequence with one column that are marked as identity.
>
> Arne
>
(Msg. 6) Posted: Thu Mar 20, 2008 7:41 pm
Post subject: Re: Derby & Oracle. [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Donkey Hot wrote:
> Arne Vajhøj wrote in > @news.sunsite.dk:
>> Mr. X. wrote:
>>> For you answers :
>>> 1. Thanks.
>>> 2. I am looking for an alternative that is much like sequence
>>> (table + some scripts ...), please.
>> Create a table mysequence with one column that are marked as identity.
>
> There will not be NEXTVALUE or CURRENTVALUE, or will there?
You INSERT in that table and use IDENTITY_VAL_LOCAL().
Apache Derby performance disappointing - Hello, I am currently adding Derby support to an application that already has support for multiple DBMS via JDBC. I have found it to be significantly slower than SQL Server or MySQL when performing the same task. To provide this, I have created an..
what is the Difference between MySql and Oracle - i am new to computer science, i am interested in studying oracle, before that , i want to know what is the difference between other databases and oracle
SQLServer 2000 Driver for JDBC behaviour on SQL Server res.. - 1) My java code properly connects to the SQL Server DB via the SQL Server 2000 JDBC driver. 2) During one of our stress tests, we restarted the SQL Server to see how the code handles it. 3) My code doesn't really recognize that the SQL server is up and m...
Displaying contents from database in an applet - I have created a connection to an MSAccess database, but I am unable to display the results in an webbrowser. My question is therefore how do I retrieve and displaty the records of my database on a webpage? Kind regards Johan Reimers
Hibernate and log4j config under Tomcat. - "Under Tomcat 3.x and 4.x, you should place the log4j.properties under the WEB-INF/classes directory of your web-applications. Log4j will find the properties file and initialize itself. This is easy to do and it works." "The XML configu...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
)