Search Results

Search found 14416 results on 577 pages for 'oracle ucm'.

Page 550/577 | < Previous Page | 546 547 548 549 550 551 552 553 554 555 556 557  | Next Page >

• Any good SQL Anywhere database schema comparison tools?

  - by Lurker Indeed

  Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly. I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any options to change that.

  Read the article

• Year dropdown range - when do we stop?

  - by Andrew Heath

  I attended a payroll software demo yesterday wherein the year dropdowns throughout the software ran from 2000 to 2200. Now, we've all been down this road before with 2 digit shortsight, but honestly - a 200 year service life for a Java & Oracle payroll system? Our Board of Directors would be thrilled if the company was even solvent for 1/4th that long. When forced to use a dropdown year select, where do you draw the line?

  Read the article

• Is it allowed to load Swing classes in non-EDT thread?

  - by ddimitrov

  After the introduction of Java Memory Model, the Swing guidelines were changed to state that any Swing components need to be instantiated on the EDT in order to avoid non-published instance state. What I could not find anywhere is whether the classloading is also mandated to be on the EDT or can we pre-load key Swing classes in a background thread? Is there any official statement from Sun/Oracle on this? Are there any classes that are known to hold non-threadsafe static state, hence need to be loaded on EDT?

  Read the article

• How do I detect unicode characters in a Java string to resolve sax parser exception

  - by Madhumita

  Suppose I have a string that contains '¿'. How would I find all those unicode characters? Should I test for their code? How would I do that? I want to detect it to avoid sax parser exception which I am getting it while parsing the xml saved as a clob in oracle 10g database. Exception javax.servlet.ServletException: org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8 sequence.

  Read the article

• dbunit, can same XML representation of database file be used for different databases

  - by changed

  Hi I am trying to do unit testing of database access layer of my project. But thing is i need to test this layer using apache derby database and during production testing i need to do it on oracle. So can i use same xml representation of database to do so using dbunit ?

  Read the article

• Is it possible to run Weblogic with 8gb heap size in a 64bit java/linux environment

  - by Per Arneng

  Setup: 64bit Linux 64bit SUN Jvm 1.6.0_20 Weblogic 10.3 Is it possible to run Weblogic 10.3 in this setup with a maximum heap size of 8gb? We have recived answers from oracle support that states that it might not be possible to address more than 4gb with this setup. Please submit any official links that support any statements that it is possible to run this setup with more than 4gb of heap size. We can not find any documentation of any limits of heap size when running with this setup. Thanx

  Read the article

• How to use stored procedure or function in iBatis 3 (with annotation)

  - by yjacket

  I want to use Oracle stored procedure or function via 'iBATIS 3 for Java' with annotation. But I can't find any sample codes. Can anyone help me? I need a simple sample code.

  Read the article

• Are there any general guidelines for increasing the generation of reports?

  - by David Thielen

  Yes a lot of what you need to do is specific not only to the vendor you use, but also to the specific reports you are creating. However, there are also good general rules that hold for most reports. Vendor Best Practices BIRT Best Practices (more why you need a 3 day class to learn all of them) Crystal Reports Best Practices Microsoft Sql Server Best Practices Oracle B.I. Publisher Best Practices Windward Reports Best Practices General tips on designing a report Note: posted to self answer

  Read the article

• best sql server client tool and refresh managment studio edit window ?

  - by Tony

  After using other gui tools for databases like oracle sql developer , plsql editor ..., I don't quite comfortable with sql server management studio,so I want to ask: Is there any better client tools for sql server? In management studio ,if I've already opened edit window, how to refresh the data in the window ?

  Read the article

• Sql Server string to date conversion

  - by JosephStyons

  I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, I would say this: TO_DATE('10/15/2008 10:06:32 PM','MM/DD/YYYY HH:MI:SS AM') This question implies that I must parse the string into one of the standard formats, and then convert using one of those codes. That seems ludicrous for such a mundane operation. Is there an easier way?

  Read the article

• SNMP: OID to use when writing custom MIBs

  - by justcatchingrye

  If you are writing your own MIB for a bespoke application, is there a 'best practice' for which branch you should use. I'm thinking of something analogous to private IP addresses, that can be used within enterprises, without conflicting with Registered IP addresses I have been asked to make a suggestion, as I advised Application Developers that they should not use OIDs under .1.3.6.1.4.1.111 - This is the Oracle branch

  Read the article

• What is the best framework for developing a Java CRUD for an existent database?

  - by Otavio

  We have a Java application with lots of config tables on the database (Oracle). We'd like to have Web-based GUIs for setting up these tables, that we currently update via SQL queries. What is the simplest way to develop CRUDs for a subset of our database? Is there any Java-based framework for doing this?

  Read the article

• How to run SQL that contains bind variables in the ODT Query Window?

  - by dnorthut

  How do you run SQL that contains one or more bind variables in the Oracle Developer Tools for Visual Studio Query Window? For example, the following works fine in SQL*Plus: variable x NUMBER; BEGIN :x := 0; END; / SELECT 1 FROM DUAL WHERE :x <> 1; When executed in the ODT Query Window, the following exception is raised in the Query output pane: ERROR ORA-01008: not all variables bound

  Read the article

• mirror link for JavaEE 6 tutorial Example

  - by ManWard

  hi Oracle [Sun] don't let downloading anything from their websites for people from iran.[sad story for us because we are students and Researcher...] i need to samples of this tutorial : http://java.sun.com/javaee/6/docs/tutorial/doc/gexaj.html#gexba anybody can help me for finding mirror link for these samples or uploading samples ? I appreciate you. thanks

  Read the article

• microsoft sql server management studio Incorrect syntax near '|'

  - by user3679099

  SELECT IPD.Task_grp "Task Group", TASK.STARTW "Starting Area", TASK.ENDW "Destination Area", IPD.Nxt_Work_Grp,IPD.Nxt_Work_Area "Drop Area", IPD.Prty "Priority", IPD.Stat_Code "Status" FROM int_path_defn IPD, (SELECT start_curr_work_grp || start_curr_work_area StartW, start_dest_work_grp ||start_dest_work_area EndW FROM task_hdr WHERE task_id='332800') TASK WHERE IPD.CURR_WORK_GRP || IPD.Curr_Work_Area=TASK.StartW AND IPD.Dest_Work_Grp || IPD.Dest_Work_Area=TASK.ENDW I am getting Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '|'. Please help what could be the wrong. same query executed successfully in oracle sql developer

  Read the article

• version of database

  - by saumitra

  Oracle Database 10g Release 10.2.0.3.0 - 64bit Production PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for Solaris: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production in above result what is the database version

  Read the article

• SQL optimization: deletes taking a long time

  - by Will

  I have an Oracle SQL query as part of a stored proc: DELETE FROM item i WHERE NOT EXISTS (SELECT 1 FROM item_queue q WHERE q.n=i.n) AND NOT EXISTS (SELECT 1 FROM tool_queue t WHERE t.n=i.n); A bit about the tables: item contains about 10k rows with an index on the n column item_queue contains about 1mil rows also with index on n column tool_queue contains about 5mil rows indexed as well I am wondering if the query/subqueries can be optimized somehow to make them run faster, I thought that deletes were generally fairly fast

  Read the article

• Error in Netbeans(?): attribute column name (length) is a reserved Java Persistence QL keyword

  - by Tgorton

  I have a column named length in an Oracle database. I cannot change the column name. When I use the @Column(name="length") in a JPA Entity I get the following error: attribute column name (length) is a reserved Java Persistence QL keyword I am using the Netbeans 6.8 IDE. Any ideas on this? Thanks

  Read the article

• Whats a good API for generating reports for a java web application?

  - by Ahmad

  I have a J2EE application that has a lot of reports, the situation now is the following: Report filters' values are sent to the application over DWR mainly, the data are retrieved from Oracle DB throw DB procedures and returned back to the client. However, some customization is required every now and then (new data filters, columns, ordering, ...), and these changes are painful to implement since we need to modify the JSPs, DB Procedures, the application itself, ... What API do you recommend to use for such reports?

  Read the article

• SQL Insert into ... values ( SELECT ... FROM ... )

  - by Shadow_x99

  I am trying to insert into a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL-Engine of the day (MySQL, Oracle, SQLServer, Informix, DB2). I've been wondering if there is a silver-bullet syntax coming from an SQL Standards (For example, SQL92) that would allow me to insert the values without worrying about the underlying database.

  Read the article

• Which of one is more important to a career: Certification(s) or a Master Degree?

  - by Pedro Ghilardi

  Which of one is more important to a career: Certifications like Java, Oracle and Linux or a Master Degree on computer science? I know that if I go to the academic area the Master Degree would be better, but a Master Degree will be valued by my company too. Both are good for the curriculum. So, what is more important?

  Read the article

• On-demand refresh mode for indexed view (=Materialized views) on SQL Server?

  - by MOLAP

  I know Oracle offers several refreshmode options for their materialized views (on demand, on commit, periodically). Does Microsoft SQLServer offer the same functions for their indexed views? If not, how can I else use indexed views on SQLServer if my purpose is to export data on a daily+ on-demand basis, and want to avoid performance overhead problems? Does a workaround exist?

  Read the article

• How to convert an application to be a database independent app ?

  - by Eslam

  I have a java web application that has informix DB as it's back end database , now i take a decision to make my app work with SqlServer so i changed all the informix related syntax into SqlServer, and i may take a decision in the future to switch into oracle so the pain will be repeated again and again, as a result i decided to make my application a DataBase independent one that's able to work with any DB vendor smoothly, but i have no idea till now about how to do that, so your ideas is welcomed.

  Read the article

• Determine precision and scale of particular number in Python

  - by jrdioko

  I have a variable in Python containing a floating point number (e.g. num = 24654.123), and I'd like to determine the number's precision and scale values (in the Oracle sense), so 123.45678 should give me (8,5), 12.76 should give me (4,2), etc. I was first thinking about using the string representation (via str or repr), but those fail for large numbers: >>> num = 1234567890.0987654321 >>> str(num) = 1234567890.1 >>> repr(num) = 1234567890.0987654

  Read the article

• What is the equivalent of REGEXP_SUBSTR in mysql?

  - by KandadaBoggu

  I want to extract a word from a string column of a table. description =========================== abc order_id: 2 xxxx yyy aa mmm order_id: 3 nn kk yw Expected result set order_id =========================== 2 3 Table will at most have 100 rows, text length is ~256 char and column always has one order_id present. So performance is not an issue. In Oracle, I can use REGEXP_SUBSTR for this problem. How would I solve this in MySQL?

  Read the article

< Previous Page | 546 547 548 549 550 551 552 553 554 555 556 557  | Next Page >