Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ija
  • Content: Threads
  • Order by date
  1. ija

    Limiting number of instances

    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...
  2. ija

    JNDI NoClassDefFoundError

    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...
  3. ija

    Hi, I used following to minimize

    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...
  4. ija

    change table to partitioned one

    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...
  5. ija

    remote query - join is slow

    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...
  6. ija

    Update several rows, one failes - which one?

    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...
  7. ija

    number of rows beeing updated?

    How can I get number of rows, which were updated (or inserted) by a statement? You might get a better insight into my problem, when you have a look on the following statement: update MYTAB set ROW_STAT = 'SOME STATUS' where KEY = 'SOME KEY' returning count(*) into Cnt; This statement does not...
  8. ija

    I have a problem with foreign key c

    I have a problem with foreign key contraint. Please have a look at the following log. It creates two tables and adds a foreign key constraint to the second one. [tt] -- create parent table CREATE TABLE PARENT_TABLE ( AP_ID VARCHAR2 (10) NOT NULL, OWNER_ID NUMBER (9) )...
  9. ija

    typed dataset with calculated column and GetChanges

    Hi. I use a typed dataset with one calculated column with a simple expression (like "colA*colB"). When I call the GetChanges() method, something happens in the dataset, which in the end causes an error. Here is output from the immediate window: ?dsDataset1.GetChanges() {"Cannot...

Part and Inventory Search

Back
Top