Misplaced Pages

Java Database Connectivity

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.

Java Database Connectivity ( JDBC ) is an application programming interface (API) for the Java programming language which defines how a client may access a database . It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation . It provides methods to query and update data in a database, and is oriented toward relational databases . A JDBC-to- ODBC bridge enables connections to any ODBC-accessible data source in the Java virtual machine (JVM) host environment.

#728271

70-662: Sun Microsystems released JDBC as part of Java Development Kit (JDK) 1.1 on February 19, 1997. Since then it has been part of the Java Platform, Standard Edition (Java SE). The JDBC classes are contained in the Java package java.sql and javax.sql . Starting with version 3.1, JDBC has been developed under the Java Community Process . JSR 54 specifies JDBC 3.0 (included in J2SE 1.4), JSR 114 specifies

140-529: A connection pool rather than obtained directly from the driver. When a Java application needs a database connection, one of the DriverManager.getConnection() methods is used to create a JDBC Connection . The URL used is dependent upon the particular database and JDBC driver. It will always begin with the "jdbc:" protocol, but the rest is up to the particular vendor. Starting from Java SE 7 you can use Java's try-with-resources statement to simplify

210-465: A 20% stake in Sun. UNIX System V Release 4 (SVR4) was jointly developed by AT&T and Sun. Sun used SVR4 as the foundation for Solaris 2.x, which became the successor to SunOS 4.1.x (later retroactively named Solaris 1.x). By the mid-1990s, the ensuing Unix wars had largely subsided, AT&T had sold off their Unix interests, and the relationship between the two companies was significantly reduced. In

280-402: A JDBC connection. JDBC represents statements using one of the following classes: PreparedStatement allows the dynamic query to vary depending on the query parameter. Update statements such as INSERT, UPDATE and DELETE return an update count indicating the number of rows affected in the database as an integer. These statements do not return any other information. Query statements return

350-411: A JDBC row result set. The row result set is used to walk over the result set . Individual columns in a row are retrieved either by name or by column number. There may be any number of rows in the result set. The row result set has metadata that describes the names of the columns and their types. There is an extension to the basic JDBC API in the javax.sql . JDBC connections are often managed via

420-416: A consistent design philosophy. Sun's first workstation shipped with UniSoft V7 Unix . Later in 1982 Sun began providing SunOS , a customized 4.2BSD Unix, as the operating system for its workstations. SunOS included suntools , an early GUI window system . In the late 1980s, AT&T tapped Sun to help them develop the next release of their branded UNIX, and in 1988 announced they would purchase up to

490-595: A database management system, a transaction is a single unit of logic or work, sometimes made up of multiple operations. Any logical calculation done in a consistent mode in a database is known as a transaction. One example is a transfer from one bank account to another: the complete transaction requires subtracting the amount to be transferred from one account and adding that same amount to the other. A database transaction, by definition, must be atomic (it must either be complete in its entirety or have no effect whatsoever), consistent (it must conform to existing constraints in

560-454: A database or other data store. When this happens it is often important to ensure that all such processing leaves the database or data store in a consistent state. Examples from double-entry accounting systems often illustrate the concept of transactions. In double-entry accounting every debit requires the recording of an associated credit. If one writes a check for $ 100 to buy groceries, a transactional double-entry accounting system must record

630-497: A line of x64 systems that support not only Solaris, but also Linux and Microsoft Windows . In January 2007 Sun announced a broad strategic alliance with Intel . Intel endorsed Solaris as a mainstream operating system and as its mission critical Unix for its Xeon processor–based systems, and contributed engineering resources to OpenSolaris . Sun began using the Intel Xeon processor in its x64 server line, starting with

700-713: A net GAAP profit of $ 126 million on revenue of $ 3.337 billion for its fiscal second quarter. Shortly following that news, it was announced that Kohlberg Kravis Roberts (KKR) would invest $ 700 million in the company. Sun had engineering groups in Bangalore , Beijing , Dublin , Grenoble , Hamburg , Prague , St. Petersburg , Tel Aviv , Tokyo , Canberra and Trondheim . In 2007–2008, Sun posted revenue of $ 13.8 billion and had $ 2 billion in cash. First-quarter 2008 losses were $ 1.68 billion; revenue fell 7% to $ 12.99 billion. Sun's stock lost 80% of its value November 2007 to November 2008, reducing

770-682: A primary developer of the Berkeley Software Distribution (BSD), joined soon after and is counted as one of the original founders. The company was the second, after rival Apollo Computer , to specialize in workstations. The name "Sun" is derived from the initials of the Stanford University Network (SUN). Sun was profitable from its first quarter in July 1982. By 1983, Sun was known for producing 68k-based systems with high-quality graphics that were

SECTION 10

#1732772971729

840-437: A reputation as one of Microsoft 's most vocal antagonists, Sun entered into a joint relationship with them, resolving various legal entanglements between the two companies and receiving US$ 1.95 billion in settlement payments from them. Sun supported Microsoft Windows on its x64 systems, and announced other collaborative agreements with Microsoft, including plans to support each other's virtualization environments. In 2005,

910-691: A suite of software products, including the Solaris operating system , developer tools, Web infrastructure software, and identity management applications. Technologies included the Java platform and NFS . In general, Sun was a proponent of open systems, particularly Unix. It was also a major contributor to open-source software , as evidenced by its $ 1 billion purchase, in 2008, of MySQL , an open-source relational database management system . At various times, Sun had manufacturing facilities in several locations worldwide, including Newark, California ; Hillsboro, Oregon ; and Linlithgow, Scotland . However, by

980-423: A transaction, using a pattern similar to the following: A transaction commit operation persists all the results of data manipulations within the scope of the transaction to the database. A transaction rollback operation does not persist the partial results of data manipulations within the scope of the transaction to the database. In no case can a partial transaction be committed to the database since that would leave

1050-478: A variant of nested transactions where the sub-transactions take place at different levels of a layered system architecture (e.g., with one operation at the database-engine level, one operation at the operating-system level). Another type of transaction is the compensating transaction . Transactions are available in most SQL database implementations, though with varying levels of robustness. For example, MySQL began supporting transactions from early version 3.23, but

1120-484: A variety of pricing bases, including per-employee and per-socket. A 2006 report prepared for the EU by UNU-MERIT stated that Sun was the largest corporate contributor to open source movements in the world. According to this report, Sun's open source contributions exceed the combined total of the next five largest commercial contributors. Sun is best known for its Unix systems, which have a reputation for system stability and

1190-407: Is Solaris 10 1/13. Database transaction A database transaction symbolizes a unit of work , performed within a database management system (or similar system) against a database , that is treated in a coherent and reliable way independent of other transactions. A transaction generally represents any change in a database. Transactions in a database environment have two main purposes: In

1260-455: Is a DBMS that provides the ACID properties for a bracketed set of database operations (begin-commit). Transactions ensure that the database is always in a consistent state, even in the event of concurrent updates and failures. All the write operations within a transaction have an all-or-nothing effect, that is, either the transaction succeeds and all writes take effect, or otherwise, the database

1330-498: Is a code pattern that obviates this. Data is retrieved from the database using a database query mechanism. The example below shows creating a statement and executing a query. The following code is an example of a PreparedStatement query which uses conn and class from the first example: If a database operation fails, JDBC raises an SQLException . There is typically very little one can do to recover from such an error, apart from logging it with as much detail as possible. It

1400-518: Is an SMP capable version of UltraSPARC T2, available in 2 or 4 processor configurations. It was the first CoolThreads CPU with multi-processor capability and it made possible to build standard rack-mounted servers that could simultaneously process up to massive 256 CPU threads in hardware (Sun SPARC Enterprise T5440), which is considered a record in the industry. Since 2010, all further development of Sun machines based on SPARC architecture (including new SPARC T-Series servers, SPARC T3 and T4 chips)

1470-604: Is an increasing need to reduce power and air conditioning demands, much of which comes from the heat generated by CPUs. The T1 was followed in 2007 by the UltraSPARC T2 , which extended the number of threads per core from 4 to 8. Sun has open sourced the design specifications of both the T1 and T2 processors via the OpenSPARC project. In 2006, Sun ventured into the blade server (high density rack-mounted systems) market with

SECTION 20

#1732772971729

1540-572: Is brought to a state that does not include any of the writes of the transaction. Transactions also ensure that the effect of concurrent transactions satisfies certain guarantees, known as isolation level . The highest isolation level is serializability , which guarantees that the effect of concurrent transactions is equivalent to their serial (i.e. sequential) execution. Most modern relational database management systems support transactions. NoSQL databases prioritize scalability along with supporting transactions in order to guarantee data consistency in

1610-480: Is crucial, as it offers a virtually infinite pool of storage resources, accommodating a range of cloud-based data store classes with varying availability, scalability, and ACID properties. This integration is essential for achieving higher availability, lower response time, and cost efficiency in data-intensive applications deployed across cloud-based data stores. The Namesys Reiser4 filesystem for Linux supports transactions, and as of Microsoft Windows Vista ,

1680-509: Is done as a part of Oracle Corporation hardware division. In the late 1980s, Sun also marketed an Intel 80386 –based machine, the Sun386i ; this was designed to be a hybrid system, running SunOS but at the same time supporting DOS applications. This only remained on the market for a brief time. A follow-up "486i" upgrade was announced but only a few prototype units were ever manufactured. Sun's brief first foray into x86 systems ended in

1750-743: Is mostly a collection of interface definitions and specifications, it allows multiple implementations of these interfaces to exist and be used by the same application at runtime. The API provides a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager ( DriverManager ). DriverManager is used as a Connection factory for creating JDBC connections. JDBC connections support creating and executing statements. JDBC connections support update statements such as SQL's CREATE , INSERT , UPDATE and DELETE , or query statements such as SELECT . Additionally, stored procedures may be invoked through

1820-562: Is recommended that the SQLException be translated into an application domain exception (an unchecked one) that eventually results in a transaction rollback and a notification to the user. The following code is an example of a database transaction : For an example of a CallableStatement (to call stored procedures in the database), see the JDBC API Guide documentation. JDBC drivers are client-side adapters (installed on

1890-510: The InnoDB storage engine was not default before version 5.5. The earlier available storage engine, MyISAM does not support transactions. A transaction is typically started using the command BEGIN (although the SQL standard specifies START TRANSACTION ). When the system processes a COMMIT statement, the transaction ends with successful completion. A ROLLBACK statement can also end

1960-824: The SUN workstation for the Stanford University Network communications project as a personal CAD workstation . It was designed around the Motorola 68000 processor with an advanced memory management unit (MMU) to support the Unix operating system with virtual memory support. He built the first examples from spare parts obtained from Stanford's Department of Computer Science and Silicon Valley supply houses. On February 24, 1982, Scott McNealy , Andy Bechtolsheim , and Vinod Khosla , all Stanford graduate students, founded Sun Microsystems . Bill Joy of Berkeley,

2030-482: The Solaris operating system , ZFS , the Network File System (NFS), and SPARC microprocessors . Sun contributed significantly to the evolution of several key computing technologies, among them Unix , RISC processors , thin client computing, and virtualized computing . Notable Sun acquisitions include Cray Business Systems Division , Storagetek , and Innotek GmbH , creators of VirtualBox . Sun

2100-646: The Sun Blade (distinct from the Sun Blade workstation). In April 2007, Sun released the SPARC Enterprise server products, jointly designed by Sun and Fujitsu and based on Fujitsu SPARC64 VI and later processors. The M-class SPARC Enterprise systems include high-end reliability and availability features. Later T-series servers have also been badged SPARC Enterprise rather than Sun Fire. In April 2008, Sun released servers with UltraSPARC T2 Plus, which

2170-556: The Sun-1 through Sun-3 computer series. The Sun-1 employed a 68000 CPU, the Sun-2 series, a 68010 . The Sun-3 series was based on the 68020 , with the later Sun-3x using the 68030 . In 1987, the company began using SPARC , a RISC processor architecture of its own design, in its computer systems, starting with the Sun-4 line. SPARC was initially a 32-bit architecture (SPARC V7) until

Java Database Connectivity - Misplaced Pages Continue

2240-582: The dot-com bubble , Sun began making more money, with its stock rising as high as $ 250 per share. It also began spending much more, hiring workers and building itself out. Some of this was because of genuine demand, but much was from web start-up companies anticipating business that would never happen. In 2000, the bubble burst. Sales in Sun's important hardware division went into free-fall as customers closed shop and auctioned high-end servers. Several quarters of steep losses led to executive departures, rounds of layoffs, and other cost cutting. In December 2001,

2310-464: The ACID properties over multiple nodes, and might include systems such as databases, storage managers, file systems, messaging systems, and other data managers. In a distributed transaction there is typically an entity coordinating all the process to ensure that all parts of the transaction are applied to all relevant systems. Moreover, the integration of Storage as a Service (StaaS) within these environments

2380-554: The JDBC Rowset additions, and JSR 221 is the specification of JDBC 4.0 (included in Java SE 6). JDBC 4.1, is specified by a maintenance release 1 of JSR 221 and is included in Java SE 7. JDBC 4.2, is specified by a maintenance release 2 of JSR 221 and is included in Java SE 8. The latest version, JDBC 4.3, is specified by a maintenance release 3 of JSR 221 and is included in Java SE 9. Since JDBC ('Java Database Connectivity')

2450-797: The Japanese company's processor chips in mid-range and high-end Sun servers. These servers were announced on April 17, 2007, as the M-Series, part of the SPARC Enterprise series. In February 2005, Sun announced the Sun Grid , a grid computing deployment on which it offered utility computing services priced at US$ 1 per CPU/hour for processing and per GB/month for storage. This offering built upon an existing 3,000-CPU server farm used for internal R&D for over 10 years, which Sun marketed as being able to achieve 97% utilization. In August 2005,

2520-532: The LX50, based in part on previous Cobalt system expertise. This was also Sun's first system announced to support Linux as well as Solaris. In 2003, Sun announced a strategic alliance with AMD to produce x86/x64 servers based on AMD's Opteron processor; this was followed shortly by Sun's acquisition of Kealia, a startup founded by original Sun founder Andy Bechtolsheim , which had been focusing on high-performance AMD-based servers. The following year, Sun launched

2590-525: The Newark campus was put on the market. In 2004, Sun canceled two major processor projects which emphasized high instruction-level parallelism and operating frequency. Instead, the company chose to concentrate on processors optimized for multi-threading and multiprocessing , such as the UltraSPARC T1 processor (codenamed "Niagara"). The company also announced a collaboration with Fujitsu to use

2660-738: The Opteron-based Sun Fire V20z and V40z servers, and the Sun Java Workstation W1100z and W2100z workstations. In September 2005 Sun unveiled a new range of Opteron-based servers: the Sun Fire X2100, X4100 and X4200 servers. These were designed from scratch by a team led by Bechtolsheim to address heat and power consumption issues commonly faced in data centers. In July 2006, the Sun Fire X4500 and X4600 systems were introduced, extending

2730-544: The Sun Blade X6250 server module introduced in June 2007. In May 2008 AMD announced its Operating System Research Center (OSRC) was expanding its focus to include optimization to Sun's OpenSolaris and xVM virtualization products for AMD processors. Although Sun was initially known as a hardware company, its software history began with its founding in 1982; co-founder Bill Joy was one of the leading Unix developers of

2800-553: The above code: Once a connection is established, a Statement can be created. Note that Connection s, Statement s, and ResultSet s often tie up operating system resources such as sockets or file descriptors . In the case of Connection s to remote database servers, further resources are tied up on the server, e.g. cursors for currently open ResultSet s. It is vital to close() any JDBC object as soon as it has played its part; garbage collection should not be relied upon. The above try-with-resources construct

2870-596: The aim of building network appliances (single function computers meant for consumers). Sun also marketed a Network Computer (a term popularized and eventually trademarked by Oracle ); the JavaStation was a diskless system designed to run Java applications. Although none of these business initiatives were particularly successful, the Cobalt purchase gave Sun a toehold for its return to the x86 hardware market. In 2002, Sun introduced its first general purpose x86 system,

Java Database Connectivity - Misplaced Pages Continue

2940-576: The amounts indicated when the acquisition closed. For the first decade of Sun's history, the company positioned its products as technical workstations , competing successfully as a low-cost vendor during the Workstation Wars of the 1980s. It then shifted its hardware product line to emphasize servers and storage. High-level telecom control systems such as Operational Support Systems service predominantly used Sun equipment. Sun originally used Motorola 68000 family central processing units for

3010-479: The case of an internal JDBC driver, the JDBC client actually runs as part of the database being accessed, and so can access data directly rather than through network protocols. Sun Microsystems Sun Microsystems, Inc. ( Sun for short) was an American technology company that sold computers , computer components , software , and information technology services and created the Java programming language ,

3080-582: The classification scheme above, although it would likely resemble either a type 2 or type 4 driver (depending on whether the database itself is implemented in Java or not). An example of this is the KPRB (Kernel Program Bundled) driver supplied with Oracle RDBMS . "jdbc:default:connection" offers a relatively standard way of making such a connection (at least the Oracle database and Apache Derby support it). However, in

3150-559: The client machine, not on the server) that convert requests from Java programs to a protocol that the DBMS can understand. Commercial and free drivers provide connectivity to most relational-database servers. These drivers fall into one of the following types: Note also a type called an internal JDBC driver - a driver embedded with JRE in Java-enabled SQL databases. It is used for Java stored procedures . This does not fit into

3220-403: The company released Solaris 10. The new version included a large number of enhancements to the operating system, as well as very novel features, previously unseen in the industry. Solaris 10 update releases continued through the next 8 years, the last release from Sun Microsystems being Solaris 10 10/09. The following updates were released by Oracle under the new license agreement; the final release

3290-418: The company's current strategy. Sun's logo, which features four interleaved copies of the word sun in the form of a rotationally symmetric ambigram , was designed by professor Vaughan Pratt , also of Stanford. The initial version of the logo was orange and had the sides oriented horizontally and vertically, but it was subsequently rotated to stand on one corner and re-colored purple, and later blue. During

3360-472: The company's market value to $ 3 billion. With falling sales to large corporate clients, Sun announced plans to lay off 5,000 to 6,000 workers, or 15–18% of its work force. It expected to save $ 700 million to $ 800 million a year as a result of the moves, while also taking up to $ 600 million in charges. As of May 11, 2009, the following shareholders held over 100,000 common shares of Sun and at $ 9.50 per share offered by Oracle, they received

3430-434: The database in an inconsistent state. Internally, multi-user databases store and process transactions, often by using a transaction ID or XID. There are multiple varying ways for transactions to be implemented other than the simple way documented above. Nested transactions , for example, are transactions which contain statements within them that start new transactions (i.e. sub-transactions). Multi-level transactions are

3500-515: The database), isolated (it must not affect other transactions) and durable (it must get written to persistent storage). Database practitioners often refer to these properties of database transactions using the acronym ACID . Databases and other data stores which treat the integrity of data as paramount often include the ability to handle transactions to maintain the integrity of data. A single transaction consists of one or more independent units of work, each reading and/or writing information to

3570-687: The early 1990s, Brian P. Dougherty , founder of Berkeley Softworks (which would go on to be re-incorporated as the GeoWorks Corporation ) accused the Java development team at Sun for studying GeoWorks's PC/GEOS operating system and incorporating features of PC/GEOS into their Unix-based operating system. Brian claimed that the object-oriented and flexible UI of PC/GEOS was "to this day the most sophisticated UI technology ever built into an OS". From 1992 Sun also sold Interactive Unix , an operating system it acquired when it bought Interactive Systems Corporation from Eastman Kodak Company. This

SECTION 50

#1732772971729

3640-402: The early 1990s, as it decided to concentrate on SPARC and retire the last Motorola systems and 386i products, a move dubbed by McNealy as "all the wood behind one arrowhead". Even so, Sun kept its hand in the x86 world, as a release of Solaris for PC compatibles began shipping in 1993. In 1997, Sun acquired Diba, Inc., followed later by the acquisition of Cobalt Networks in 2000, with

3710-405: The event of concurrent updates and accesses. In a database system, a transaction might consist of one or more data-manipulation statements and queries, each reading and/or writing information in the database. Users of database systems consider consistency and integrity of data as highly important. A simple transaction is usually issued to the database system in a language like SQL wrapped in

3780-441: The first commercial use of this grid was announced for financial risk simulations which were later launched as its first software as a service product. In January 2005, Sun reported a net profit of $ 19 million for fiscal 2005 second quarter, for the first time in three years. This was followed by net loss of $ 9 million on GAAP basis for the third quarter 2005, as reported on April 14, 2005. In January 2007, Sun reported

3850-441: The following two entries to cover the single transaction: A transactional system would make both entries pass or both entries would fail. By treating the recording of multiple entries as an atomic transactional unit of work the system maintains the integrity of the data recorded. In other words, nobody ends up with a situation in which a debit is recorded but no associated credit is recorded, or vice versa. A transactional database

3920-431: The four-processor SPARCserver 600MP. This was followed by the 8-processor SPARCserver 1000 and 20-processor SPARCcenter 2000, which were based on work done in conjunction with Xerox PARC . In 1995 the company introduced Sun Ultra series machines that were equipped with the first 64-bit implementation of SPARC processors ( UltraSPARC ). In the late 1990s the transformation of product line in favor of large 64-bit SMP systems

3990-627: The introduction of the SPARC V9 architecture in 1995, which added 64-bit extensions. Sun developed several generations of SPARC-based computer systems, including the SPARCstation , Ultra , and Sun Blade series of workstations, and the SPARCserver, Netra , Enterprise , and Sun Fire line of servers. In the early 1990s the company began to extend its product line to include large-scale symmetric multiprocessing servers, starting with

4060-526: The most powerful, enterprise class high-end CC-NUMA servers developed by Sun, such as the Sun Fire E15K and the Sun Fire E25K . In November 2005, Sun launched the UltraSPARC T1 , notable for its ability to concurrently run 32 threads of execution on 8 processor cores. Its intent was to drive more efficient use of CPU resources, which is of particular importance in data centers , where there

4130-632: The new UltraSPARC CPUs based on the SPARC V9 architecture. Within the next four years, the successors Solaris 8 and Solaris 9 were released in 2000 and 2002 respectively. Following several years of difficult competition and loss of server market share to competitors' Linux-based systems, Sun began to include Linux as part of its strategy in 2002. Sun supported both Red Hat Enterprise Linux and SUSE Linux Enterprise Server on its x64 systems; companies such as Canonical Ltd. , Wind River Systems and MontaVista also supported their versions of Linux on Sun's SPARC-based systems. In 2004, after having cultivated

4200-464: The only computers other than DEC 's VAX to run 4.2BSD . It licensed the computer design to other manufacturers, which typically used it to build Multibus -based systems running Unix from UniSoft . Sun's initial public offering was in 1986 under the stock symbol SUNW , for Sun Workstations (later Sun Worldwide ). The symbol was changed in 2007 to JAVA ; Sun stated that the brand awareness associated with its Java platform better represented

4270-481: The start and the commit or rollback . After starting a transaction, database records or objects are locked, either read-only or read-write. Reads and writes can then occur. Once the transaction is fully defined, changes are committed or rolled back atomically , such that at the end of the transaction there is no inconsistency . Database systems implement distributed transactions as transactions accessing data over multiple nodes. A distributed transaction enforces

SECTION 60

#1732772971729

4340-402: The stock fell to the 1998, pre-bubble level of about $ 100. It continued to fall, faster than many other technology companies. A year later, it had reached below $ 10 (a tenth of what it was in 1990), but it eventually bounced back to $ 20. In mid-2004, Sun closed their Newark, California , factory and consolidated all manufacturing to Hillsboro, Oregon and Linlithgow, Scotland. In 2006, the rest of

4410-547: The time the company was acquired by Oracle Corporation , it had outsourced most manufacturing responsibilities. On April 20, 2009, it was announced that Oracle would acquire Sun for US$ 7.4 billion. The deal was completed on January 27, 2010. The initial design for what became Sun's first Unix workstation , the Sun-1 , was conceived by Andy Bechtolsheim when he was a graduate student at Stanford University in Palo Alto , California. Bechtolsheim originally designed

4480-736: The time, having contributed the vi editor, the C shell , and significant work developing TCP/IP and the BSD Unix OS. Sun later developed software such as the Java programming language and acquired software such as StarOffice , VirtualBox and MySQL . In February 1991, the company established SunSoft, Inc., a wholly owned division of Sun dedicated to the development of operating systems and application software. Sun used community-based and open-source licensing of its major technologies, and for its support of its products with other open source technologies. GNOME -based desktop software called Java Desktop System (originally code-named "Madhatter")

4550-446: The transaction has ended. At the lowest level ( READ UNCOMMITTED ), which may occasionally be used to ensure high concurrency, such changes will be immediately visible. Relational databases are traditionally composed of tables with fixed-size fields and records. Object databases comprise variable-sized blobs , possibly serializable or incorporating a mime-type . The fundamental similarities between Relational and Object databases are

4620-452: The transaction, undoing any work performed since BEGIN . If autocommit was disabled with the start of a transaction, autocommit will also be re-enabled with the end of the transaction. One can set the isolation level for individual transactional operations as well as globally. At the highest level ( READ COMMITTED ), the result of any operation performed after a transaction has started will remain invisible to other database users until

4690-519: Was a popular Unix variant for the PC platform and a major competitor to market leader SCO UNIX . Sun's focus on Interactive Unix diminished in favor of Solaris on both SPARC and x86 systems; it was dropped as a product in 2001. Sun dropped the Solaris 2.x version numbering scheme after the Solaris 2.6 release (1997); the following version was branded Solaris 7. This was the first 64-bit release, intended for

4760-635: Was accelerated by the acquisition of Cray Business Systems Division from Silicon Graphics. Their 32-bit, 64-processor Cray Superserver 6400 , related to the SPARCcenter, led to the 64-bit Sun Enterprise 10000 high-end server (otherwise known as Starfire or E10K). In September 2004, Sun made available systems with UltraSPARC IV which was the first multi-core SPARC processor. It was followed by UltraSPARC IV+ in September 2005 and its revisions with higher clock speeds in 2007. These CPUs were used in

4830-523: Was distributed for the Solaris operating system, and at one point for Linux. Sun supported its Java Enterprise System (a middleware stack) on Linux. It released the source code for Solaris under the open-source Common Development and Distribution License , via the OpenSolaris community. Sun's positioning includes a commitment to indemnify users of some software from intellectual property disputes concerning that software. It offers support services on

4900-581: Was founded on February 24, 1982. At its height, the Sun headquarters were in Santa Clara, California (part of Silicon Valley ), on the former west campus of the Agnews Developmental Center . Sun products included computer servers and workstations built on its own RISC -based SPARC processor architecture , as well as on x86 -based AMD Opteron and Intel Xeon processors. Sun also developed its own storage systems and

#728271