PlanetMysql.ru – информация о СУБД MySQL

There are many questions that arise out of Oracle’s copyright and patent infringement complaint against Google regarding its use of Java in Android. There are several things that make the suit significant to the entire industry: it centers not just on software copyright, but also software patents (an increasingly and hotly debated issue), the quickly-expanding smartphone market and open source software. The first question is: what is Oracle doing?

Many are speculating that this is simply an effort to further and more effectively monetize Java, a storied program language that has move more toward openness and survived several supposed death sentences as newer languages arrived. Still, with all of the open source parts — GlassFish application server, MySQL database, OpenOffice.org suite — is Java the most significant to Oracle? It may be, but regardless of what Oracle is doing, its legal moves here may certainly have an impact on the many other open source projects from Sun that are now under Oracle’s umbrella.

Oracle may also simply be initiating an IP licensing effort around Java, but as Microsoft has found, this can be a delicate endeavor to say the least. Another possibility is that Oracle, not typically mentioned or meaningful when we discuss the hot market of smartphones, wants to make sure the world knows its Java code is in many of that Android technology. Still, there are more constructive ways to go about that, I would think.

We have questioned Oracle’s full appreciation for open source software before, but its latest action simply brings more questions to mind.

The smartphone market is seeing incredible opportunity, competition and innovation right now? In addition, with waves of iPhone and more recently Android popularity, the smartphone market might even be poised for a slow in growth (even though it is by many accounts the fastest growing technology market). Still, if there is some slowing that was part of the natural market cycle, will Oracle take some or even all of the blame?

Given that Google is adept at software development and using open source, we also have to wonder about the impact of any and all major workarounds. Plans may already be well underway to circumvent the use of Java in Android and any range of other devices or markets where it has managed to stay relevant despite its age. This could finally make Java less relevant, or at the least have a negative effect on Java development going forward.

One thing seems clear, Oracle’s move makes all that software patent discussion and debate more relevant and more real. We have sensed a coming storm over software patents, but we did not anticipate a first shot from Oracle, frankly. One of the biggest questions now is what kind of reaction will this trigger from the likes of the Open Invention Network, Linux Foundation (of which Oracle is a Platinum member and Google is a Gold member) or others with resources and interest in legally defending Linux and open source software?

PlanetMySQL Voting: Vote UP / Vote DOWN

There are signals of continued problems and dysfunction — namely lack of support, organization and communication — in the OpenSolaris community. This follows on a deterioration of the OS leadership and support since Oracle bought Sun Microsystems, including the elimination of OpenSolaris CDs, one of the things that made the open source version of Solaris more like Linux.

We had speculated on the fate of Sun open source software under Oracle and while we acknowledged Oracle’s participation in, contribution and commitment to and opportunity from open source software, we questioned its appreciation of open source software communities beyond code and customers. It appears the OpenSolaris community and thus the OS itself, which we believe is key to advancing development of the more popular, proprietary cousin Solaris — are not a priority for Oracle.

The same cannot be said for all open source from Sun, and there’s a lot of it, now at Oracle. Amid the struggles of the OpenSolaris community, one of the other open source keystones from Sun, MySQL, seems to be doing well, despite persisting claims Oracle purchased Sun and MySQL simply to keep it from competing with Oracle database products. According to a Jaspersoft survey of customers/developers, there is a lack of awareness or concern of Oracle’s involvement in MySQL (59 percent were not aware Oracle reorganized and established a separate MySQL business unit apart from Oracle’s traditional RDBMS business …). Another 43% of Jaspersoft’s respondents said MySQL development and innovation would improve under Oracle.

The Jaspersoft survey found even more love for Java under Oracle, with 80 percent of respondents indicating they believe the Java process will improve or stay the same under Oracle. The related GlassFish application server also appears to be healthy with both community and commercial versions recently released.

The OpenOffice community appears also to be continuing forward supported and unfettered by Oracle (perhaps because it was typically fettered by Sun?), but it may also me failing to fully seize the opportunity.

It has also been interesting to see how Sun’s cloud computing technology has helped give Oracle new love for the term and the market.

There are a number of key open source projects and pieces from Sun, those listed above as well as many others, that may be on the line right now (or may have already been branded ’stay’ or ’stop’). We will be watching to see how Sun’s open source continues to shine or to set at Oracle.

PlanetMySQL Voting: Vote UP / Vote DOWN

Here are some tips that have been recently published on Java EE 6 & GlassFish:

• Migrating JSF 1.2 + RichFaces 3.x to Java EE 6 / GlassFish v3 • Mercurial and OpenSolaris and GlassFish • How do I setup a DataSource in Embedded GlassFish when using Arquillian? • Learning GlassFish v3 Command Line Administration Interface (CLI) • Java EE 6: Understanding Contexts and Dependency Injection (CDI), Part 1 - (in Japanese) • Example of EJB 3.1 Stateful Session Bean and Servlet • Message Driven Bean Example with Servlet Client • EJB 3.1 Timer Simple Example • How to set up an Ubuntu, Glassfish, MySQL, Java stack • GlassFish 3.1 Milestone 1 - Clustering and App Versioning, Screencast #1 and #2

Let us know if you have seen or published a detailed tip like shown above and we'll be happy to share them.
PlanetMySQL Voting: Vote UP / Vote DOWN

Install and Run Apache Roller 4.01 on GlassFish and OpenSolaris
Dave Koelmeyer has posted Detailed Instructions on how to install Apache Roller 4.01 on GlassFish v2.1 using MySQL 5.1 for storage.  He uses OpenSolaris snv_134, the subject of a tea-leaf-reading thread.

Slides and Code Samples on Jersey and JAX-RS
The Slides and code from Paul Sandoz's presentation at Presentation at AlpesJug on Jersey, JAX-RS and Atmosphere are now now available.  The actual presentation was in French, but the slides are in English, and the code is... code.

Invoke OSGi Service from JAX-WS Endpoint
Arun has published yet another TOTD (Tip Of The Day), with complete instructions and code.  This one is  TOTD #130: Invoking a OSGi service from a JAX-WS Endpoint. Arun's approach is to document the demos he gives at his presentations through the TOTDs.  Quite a bit of work, but it makes the content useful to a world-wide audience.

WAS V7 - Inching Towards JavaEE 6
IBM has recently been using a "Feature Pack" approach in upgrading its WebSphere AppServer; it seems to work pretty well for them and they released two packs for WAS V7: Feature Pack for OSGi and JPA 2.0 and Feature Pack for SCA.  IBM is, of course, one of the Java Licensees; WAS v7 is one of the JavaEE 5 Compatible App Servers, the feature pack aproach helps it move towards the JavaEE 6 list.

VirtualBox at Oracle
One of the challenges during Hands-On-Labs is setting up: the attendees usually bring their own laptops but each of them is different and requires slighlty different setup.  Asking for prep work before attending is not always successful.  A solution now being used in some DB HOLs at Oracle is to Use VirtualBox. Which is the same approach that both Arun and Alexis had advocated for a new series of GlassFish HOLs being planned.

GlassFish CLI
Masoud has a detailed post - actually a book chapter - that you should read to Learn the GlassFish v3 Command Line Administration Interface (CLI)

JavaOne 2010
This year's JavaOne is the first under Oracle and will coincide with Oracle OpenWorld.  Some things will be different, but others are mostly the same - including how the content is being selected - see Sharat Chander's interview by Tori Wieldt for some answers; others will evolve as we get closer to the event.

PlanetMySQL Voting: Vote UP / Vote DOWN

Financial services on the go - GlassFish for Fundamo and profit
Alexis recently published a new Adoption Story on how Fundamo uses GlassFish v2 and OpenMQ for its Enterprise Platform. Overview at stories entry, details in questionnaire, and an overview in this earlier short video interview.
We are always interested in more GlassFish adoption stories, both from (non-paying) users and from (paying) customers.   Stories come from all industries and around the world, the last few entries are PSA Peugeot Citroën (France/Auto), iVox (Belgium/Print), NHIH (US/Gov-Health Care) and Suncorp (Australia/Finantial).

OSGi/JMS/MDB Example
Sahoo's latest post describes a hybrid OSGi/JavaEE example that uses JMS and Message Driven Beans and leverages GlassFish v3.  Post includes source code and detailed description.

Siebel CRM Support for the iPad
Oracle shows how to use their server-side REST APIs and the iPad SDK to provide access to Siebel CRM from the iPad.   Devices like the iPad (and the iPhone) seem a very good match for the Oracle Fusion Applications. 

Innovating at Warp-Speed: Monitis Announces Java Monitoring from the Cloud
Monitis announces Java Application Monitoring, a cloud-based monitoring solution for JMX-based applications, including GlassFish containers.  More details in announcement and product page.

EJB 3.1 Asynchronous Session Beans
From Paris, with love... Patrick Champion provides a short example of using EJB 3.1's @Asynchronous annotation.  More benefits of JavaEE 6!

Alfresco community 3.3 installation on Glassfish
A short but detailed description of how to install Alfresco Community 3.3 with GlassFish v2.1 and MySQL.

Getting started with Glassfish V3 and SSL
The JavaDude provides a tutorial on how to use GlassFish v3 with SSL.

PlanetMySQL Voting: Vote UP / Vote DOWN

Taking TOTD #121 forward, this blog explains how to create a JPA Persistence Unit for a MySQL sample database and package it as a library. This JAR file can then be easily included in other web applications.

Lets get started!

1. Configure GlassFish for using the MySQL sample database (sakila) as described in TOTD #121.
2. Add the GlassFish instance in NetBeans IDE using "Services" panel.
3. Create JPA entities using NetBeans IDE.
   1. Create a Java class library:
      
      
      
      Our ultimate goal is to create a reusable JAR file and that's why this project type is chosen.
      
   2. Specify the name of project as "SakilaPU":
      
      
      
   3. Right-click on the project and select "New", "Entity Classes from Database ..." to initiate the process of entity generation:
      
      
   4. Choose the database connection as:
      
      
      
      If not configured, then can be easily done by clicking on "New Database Connection ..." in the list box.
      1. Click on "Add All >>" to generate the mapped JPA entities for all tables and views.
      2. The views do not have primary keys and will need to be appropriately annotated (described later).
      3. Click on "Next >".
         
   5. Give the package name as:
      
      
      
      and specify the package name as "sakila". Click on "Create Persistence Unit ...".
   6. Change the default PU name from "SakilaPUPU" to "SakilaPU":
      
      
      
      and click on "Finish". Notice that "EclipseLink", the Reference Implementation of JPA 2.0, is used as the persistence library.
   7. Add "@javax.persistence.Id" annotation to the following class/field combination:

      Class	Field
      sakila.SalesByFilmCategory	category
      sakila.ActorInfo	actorId
      sakila.FilmList	fid
      sakila.CustomerList	id
      sakila.NicerButSlowerFilmList	fid
      sakila.StaffList	id
      sakila.SalesByStore	store

      
      This is required because none of the "views" are defined with a primary key.

   8. Right-click on the project and select "Clean & Build". This generates "dist/SakilaPU.jar" and the structure looks like:

      

This JAR file can now be included in any web application. The pre-built JAR file can also be downloaded here. The key items to note about this pre-built JAR:

• Persistence Unit Name: "SakilaPU"
• All classes are in "sakila.*" package.
• Each class has a pre-defined "<CLASS-NAME>.findAll" named query that returns all elements from the underlying view/table.
• Can be easily added in "WEB-INF/lib" directory of your web application.

Even though this blog uses a MySQL sample database, these steps can be easily followed for any other database such as Oracle or JavaDB.

Technorati: totd javaee glassfish v3 jpa eclipselink persistenceunit mysql sakila netbeans

PlanetMySQL Voting: Vote UP / Vote DOWN

This blog clearly explains how to configure the MySQL sample database (sakila) with GlassFish. Even though the instructions use a specific database but should work for other databases (such as Oracle, JavaDB, PostgreSQL, and others) as well. The second half of the blog provide specific syntax for the Oracle sample database.

1. Download sakila sample database and unzip the archive.
2. Install the database as described here - basically load and run "sakila-schema.sql" and "sakila-data.sql" extracted from the archive.
3. Create a new MySQL user account using MySQL CLI Admin and assign the privileges
   1. Using "root" user (sudo mysql --user root)
      

      CREATE USER glassfish IDENTIFIED BY 'glassfish';
      GRANT ALL PRIVILEGES ON *.* TO 'glassfish'@'localhost' IDENTIFIED BY 'glassfish';
      FLUSH PRIVILEGES;
      

   2. Using "glassfish" user (sudo mysql --user glassfish)

      source sakila-schema.sql;
      source sakila-data.sql;
      

4. Download Connector/J, unzip and copy "mysql-connector-java-5.x.x-bin.jar" to "glassfish/domains/domain1/lib/ext" directory.
5. Start GlassFish server as:

   asadmin start-domain
   
   

6. Create a JDBC resource
   1. Create JDBC connection pool as:

      asadmin create-jdbc-connection-pool --datasourceclassname com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource --restype javax.sql.DataSource --property "User=glassfish:Password=glassfish:URL=jdbc\:mysql\://localhost/sakila" jdbc/sakilaPool
      

   2. Test the JDBC connection pool as:

      asadmin ping-connection-pool jdbc/sakilaPool
      

   3. Create the JDBC resource as:

      asadmin create-jdbc-resource --connectionpoolid jdbc/sakilaPool jdbc/sakila
      

That's it!

Creating a JDBC resource for any other database requires the following updates to the steps mentioned above. Lets consider modifying these steps for the Oracle sample database.

1. Use the client interface SQL*PLus and connect as:
   

   sqlplus "/ as sysdba"
   

   
   create user and grant the privileges as:
   

   CREATE USER glassfish IDENTIFIED BY glassfish DEFAULT tablespace users TEMPORARY tablespace temp;
   GRANT CONNECT TO glassfish IDENTIFIED BY glassfish;
   GRANT UNLIMITED TABLESPACE TO glassfish;
   GRANT CREATE TABLE TO glassfish;
   GRANT CREATE SEQUENCE TO glassfish;
   

2. Copy the appropriate JDBC driver (ojdbc6.jar).
3. Create the JDBC resource as:
   

   asadmin create-jdbc-connection-pool --datasourceclassname oracle.jdbc.pool.OracleDataSource --restype javax.sql.DataSource --property "User=hr:Password=hr:URL=jdbc\:oracle\:thin\:@localhost\:1521\:orcl" jdbc/hr
   asadmin ping-connection-pool jdbc/hr
   asadmin create-jdbc-resource --connectionpoolid jdbc/hr jdbc/hr
   

   
   as explained in TOTD #108.

Here are a few other related entries:

• RESTful representation of sakila using NetBeans and GlassFish

• JPA + Servlet 3.0 Application using Sakila in Eclipse

• JSF + JPA + EJB Application using Oracle, NetBeans, and GlassFish

Technorati: totd javaee glassfish v3 jpa mysql sakila oracle

PlanetMySQL Voting: Vote UP / Vote DOWN

Topics for this podcast:

*Matt Asay moves from Alfresco to Canonical
*GPL fade fuels heated discussion
*Apple’s iPad and its enterprise and open source impact
*Open source in data warehousing and storage
*Our perspective on Oracle’s plans for Sun open source

iTunes or direct download (32:50, 9.2 MB)

PlanetMySQL Voting: Vote UP / Vote DOWN

This running entry collects key announcements related to Oracle's Acquisition of Sun; some from the Jan 27th event, some from companion webcasts, and some later announcements. The main theme of the acquisition is "We're Changing the Way you Buy, Run and Manage Business Systems".

Main Entry Points:

• Sun Acquisition
• Jan 27th Strategy Event. Includes webcast, highlights and presentations. 5 hours but worth it.
• Strategy Webcast Series.

From the Software Segment of the Strategy Webcast Series:

• Jeet & Hasan on Java Strategy. Covers JavaFX, JavaSE, Blu-Ray, GlassFish, JavaCard, Developer Sites, JCP, JavaOne Java For Business.
• Hasan Rizvi on Application Server. GlassFish, WebLogic, protecting investment in existing products, Oracle Application Grid, Grid Architecture, jRockit, Coherence, Tuxedo, OpenMQ, GlassFish WebStack and GF SpaceServer - and Liferay, Sun WebServer, Portal Server, Oracle WebCenter. Check slide 12 (and 6'12") for current level of details on WebLogic/GlassFish alignment.
• Richard Sarwal and Steve Wilson on Oracle Enterprise Manager and xVM OpsCenter. Combined story covers discovery, provisioning, updating, monitoring - including for virtualized assets. Application-to-disk management.
• OpenOffice, with Michael Bemmer. Open Source, name changes, Oracle value proposition, Web-Based version, JDeveloper support, Extensions, ODF-support, integration with other Oracle products.
• Cloud with Richard Sarwal. A pretty good presentation covering IAAS, PAAS, SAAS; Private and Public Clouds; range from Silo > Grid > Private Cloud > Hybrid including Private and Public Cloud; cloud-in-a-box. Discontinuing the Sun public cloud offering but leveraging Sun's technology, including Q-Layer team for Oracle products that provide flexible, self-service, dynamic services.
• Operating Systems by Edward Screven.

From the Systems Segment of the Strategy Webcast Series:

• Storage with Mike Shapiro, including OpenStorage and Flash products. Blade Server and x86 Rack Server are covered by Ali Alasti; Archival (tapes) by Jim Cates, and SPARC Servers by Masood Heydari.

Other Links:

• Overview and FAQ for Developer Community - Covers SDN, Java.Net, Java.Sun.Com, BigAdmin, Kenai, JavaOne and more.
• Developer Tools FAQ
• Post on Public Site To Be Removed.

Additional Information - Oracle continues to update their site; see also:

• Middleware Home

Press, Analysts, Friends, Others:

• @Redmonk - Cote and Stephen.
• Savio Rodrigues (IBM/Geronimo) and Mark Little (JBoss - he really should wait for more data).
• NYtimes, WSJ, PCWorld, MercuryNews, and many more...

PlanetMySQL Voting: Vote UP / Vote DOWN

Oracle has updated their page on Oracle and Sun and it now includes a PDF entitled "Oracle and Sun Overview and FAQ".  Check it out for comments on many topics covering Sun's Hardware (SPARC, Storage, x86) and Software offerings, including NetBeans, OpenOffice, MySQL, OpenSource, VirtualBox and GlassFish.

PlanetMySQL Voting: Vote UP / Vote DOWN