Search results for query: *

Hi, Has anyone heard about a way how to limit the number of service instances running in parallel? We have only a limited number of connections to other database and when too many service instances run at once, some fail with "The timeout period elapsed prior to obtaining a connection from the...

Which jars are required? I know only about the j2ee.jar. The documentation says, that jndi.jar should be required in versions up to 1.2. It is not included in the 1.3.1 installation at all. Thanks ija

Hi, I am new to JNDI and I started with a simple example in tutorial. The problem is that I keep getting the NoClassDefFoundError, which according to the tutorial is caused by missing jndi installation. BUT - jndi should be part of SDK v1.3 and above and I swear I use 1.3.1. Please help - what...

TO_DATE is affected by regional settings of the machine it is run on. This usually means the server. That is why you get an error when you convert a date in swedish format on a server with english settings. You can create a 'mask' using the translate function (translate(strYourDate...

Hi, I used following to minimize application to systray: "How to minimize an app as an Icon in taskbar" (thread222-178679). However, the application's header (first line with icon, application name and minimize/maximize/close buttons) is still visible just over the task bar. Please...

Have not tried, but it can give you at least an inspiration: select tab.name, tab.dep, tab.salary from ( Select dep, Max(Salary) as sal from Table Group by Dep) as maxs, table tab where tab.dep = maxs.dep and tab.salary = maxs.salary

Hi, Could anybody briefly explain, what needs to be done in order to make a table partitioned? I will not actually do the changes, so no details are needed. I only need to understand the consequences... We have a few very big tables with data from last 3 years. We would like to create...

It looks like we three are writing response at the sime time - funny... :-)

select froms.store_name as from_store, tos.store_name as to_store from stores froms, stores tos, sells int where froms.store_id = int.from_store_id and int.to_store_id = tos.store_id

The 'in' statement will look like: WHERE listitemid IN ('1,2,3,4') or like WHERE listitemid IN (''1','2','3','4'') In neither case it is what you wanted (the red parts are always a string). You should have a look in documentation or ask somebody about variable number of parameters. I...

If you mean to create constraint without making it active, try "DISABLE".

I wondered, why the DRIVING_SITE hint did not work. I mistyped it... Thanks, now it is quite fast.

The statement fails because of NOT NULL constraint. The company is replacing one system by another and unfortunatelly it is the master system for our system. So we need to change IDs in about a half of database. We first search for previous ID for each entity, which is stored in the NOT NULL...

When you declare the function, add this piece of code: PRAGMA RESTRICT_REFERENCES (GetPercent, WNDS, WNPS, RNDS, RNPS); It assures, that the conditions named by johnfuller360 are fullfilled. Compiler requires the pragma.

I am not sure, if I understood correctly. Your select may look like this: select * from Tab_A where id in ( select b2.id from Tab_B b1, Tab_B b2 where b1.rowid<>b2.rowid and b1.id=b2.id and b1.cat = '101' ) The statement ensures automatically, that there are at least...

Sem, johnfuller360, thanks a lot. This is still not what we need. We do not use any triggers, because they are slow, and we do not need this for debugging purposes, but for production conversion.

The problem is, that cursor is too slow for our purpose. We would like to replace it by updates of multiple rows.

Hi. Join on two tables in different databases is terribly slow. Some ideas, what to do? We have two tables in two different databases, each with about 4 milions records. When we do a select on them retrieving about 100 records from each (it is contact and address), it runs longer then we have...

Hi. Is there a way, how to identify, which row failed, if I try to update several? The background: we have a conversion tool with high requirements on performance. We convert entities record by record, because some may fail and we need to flag them. We use a cursor, which works fine, but is...

Ok. I tried and it works. Thanks a lot. :-) Do you have an idea how fast this is? Does it have the value from the last statement or runs it another query in the database?