Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 273 Next 30 Older Entries

Displaying posts with tag: Java (reset)

Java Generics in Oracle
+0 Vote Up -0Vote Down

Somebody posed the question about using a Comparator in the sorting examples provided in this earlier post on Updating Table View Columns (columns using a Varray or Nested Table of a single scalar data type). It seems the individual thought that you can’t use Java Generics inside an Oracle Database 11g’s Java libraries. It’s seems odd since they’ve been around since Java 5.

You can use Generics like those shown in the following example. It builds on explanation from the prior post. If you want to get the whole set of facts click the link above but you should have all the code you need in this post.

An example like this requires you first define a collection of strings in the database. This one uses the following

  [Read more...]
Connector/J extension points – exception interceptors
Employee_Team +0 Vote Up -0Vote Down

A third built-in extension point for MySQL Connector/J is the ExceptionInterceptor interface.  This is the third extension point covered in my recent JavaOne and Silicon Valley Code Camp presentations, and is very useful for diagnosing specific Exceptions encountered without modifying application-side code. This corresponds to slide #60 in my slide deck, and there are two Java files we’ll reference from my demo code:

      [Read more...]
    Connector/J extension points – statement interceptors
    Employee_Team +1 Vote Up -0Vote Down

    Continuing the review of MySQL Connector/J’s built-in extension points from my recent JavaOne and Silicon Valley Code Camp presentations, this blog posting will focus on the StatementInterceptor extension point.  As the name suggests, this allows you to hook into statement execution and alter behavior – without changing application-side code.  This corresponds to slide #59 in my slide deck, and there are two Java files we’ll reference:

    • demo.connectorj.StatementInterceptorExample
    • demo.connectork.plugins.ExampleStatementInterceptor

    To

      [Read more...]
    451 CAOS Links 2011.08.31
    +0 Vote Up -0Vote Down

    MapR and Funambol raise funding. VMware virtually supports PostgreSQL. And more.

    # MapR raised $20m series B for its Hadoop distribution from Redpoint Ventures, Lightspeed Venture Partners and NEA.

    # Funambol raised $3m in funding from previous investors HIG Ventures, Pacven Walden Ventures and Nexit Infocom.

    # VMware launched vFabric Postgres as part of vFabric Data Director database-as-a-service launch.

    # Citrix released a new edition of CloudStack, making the

      [Read more...]
    Creating JDBC Connections Doesn't Have To Be Slow (or "not the reason to be using a pool")
    Employee +4 Vote Up -0Vote Down

    Hanging out in #mysql on freenode the other day, I overheard someone saying that the reason to use connection pools with MySQL is because JDBC connections are expensive to create. That is true out of the box, but mostly because the out of the box behavior of MySQL's JDBC driver is to be standards-compliant. If you know that your DBA and your developers aren't doing crazy things with the database (changing configurations without letting the developers know, going around the "standard" API calls to start/end transactions, etc), then you can get to the point where connection setup is no slower than any other API. Does this mean you shouldn't use a connection pool? NO! (more on this next week).

    Here's an iterative overview of the changes made in configuration, and how they affect what queries the driver does on initialization.

    First, asking the

      [Read more...]
    451 CAOS Links 2011.08.12
    +1 Vote Up -0Vote Down

    Couchbase raises $14m. AppFog raises $8m. Much ado about Percona Live MySQL Conference and Expo. And more.

    # Couchbase raised $14m in series C funding for its NoSQL database.

    # AppFog raised $8m series B funding for its PHP-based platform-as-a-service.

    # Percona announced its plans to host a Percona Live MySQL Conference and Expo on April 10-12, effectively replacing the O’Reilly MySQL Conference and Expo.

    # The announcement sparked some rumblings of discomfort around the MySQL community with Giuseppe Maxia and

      [Read more...]
    On Password Strength
    +6 Vote Up -0Vote Down
    XKCD (as usual) makes a very good point – this time about password strength, and I reckon it’s something app developers need to consider urgently. Geeks can debate the exact amount of entropy, but that’s not really the issue: insisting on mixed upper/lower and/or non-alpha and/or numerical components to a user password does not really improve security, and definitely makes life more difficult for users. So basically, the functions that do a “is this a strong password” should seriously reconsider their approach, particularly if they’re used to have the app decide whether to accept the password as “good enough” at all. Update: Jeff Preshing has written an   [Read more...]
    MariaDB now available as a hosted database via Jelastic cloud platform
    +5 Vote Up -0Vote Down

    About Jelastic:

    Jelastic is the next generation of Java Platforms as a Service.

    Unlike previous cloud platforms, Jelastic:

    • Can run any Java application and so does not require developers to change their code or get locked-into the platform,
    • Can scale any application up and down by automatically adding or removing memory and CPU units depending on the application load,
    • Takes all configuration and management worries away: developers simply specify the application stack and database options they need and Jelastic creates, configures, and maintains the environment for them
    • Supports a wide range of application server stacks including Tomcat, JBoss, Jetty, and GlassFish
    • Out of the box, allows users to get a preconfigured instance of MariaDB up and running and available to the application.

    A beta

      [Read more...]
    Developer Week in Review: Lion drops pre-installed MySQL
    +1 Vote Up -1Vote Down


    A busy week at Casa Turner, as the infamous Home Renovations of Doom wrap up, I finish the final chapters of "Developing Enterprise iOS Applications" (buy a copy for all your friends, it's a real page turner!), pack for two weeks of vacation with the family in California (Palm Springs in August, 120 degrees, woohoo!), and celebrate both a birthday and an anniversary.



    But never fear, WIR fans, I'll continue to supply the news, even as my MacBook melts in the sun and the buzzards start to circle overhead.

    The law of unintended consequences

    If you decide to install Lion Server, you may notice something





      [Read more...]
    Oracle at fisl12 (Porto Alegre, Brazil, 2011-06-29/2011-07-02)
    Employee +1 Vote Up -0Vote Down

    fisl12 is likely the largest free and open source software event in Latin America. This year, it takes place in Porto Alegre, Brazil, from June 29th to July 2nd. Oracle is a gold sponsor of the event and I will attend it as a speaker. I feel honoured and excited to be there – for me it will be the first visit to the South American continent.

    They already have over 3000 registered attendees, so this definitely is going to be a great conference. There is quite a number of well-known names on the speaker roster and I look forward to meeting a lot of familar faces there.

    The

      [Read more...]
    Connection Pool: MySQL Communications link failure
    +0 Vote Up -0Vote Down
    The Problem And The Solution While using a MySQL connection pool in Java, I received a MySQL Communications link failure Exception (see below). In order to solve communication link failure exception: I have removed JDBC property autoReconnect=true and put only the JDBC property autoReconnectForPools=true I have added the connection properties: testOnBorrow testWhileIdle timeBetweenEvictionRunsMillis minEvictableIdleTimeMillis See [...]
    Connection Pool: MySQL connection closed exception
    +0 Vote Up -0Vote Down
    The Problem While using a MySQL connection pool in Java, I received a MySQL Connection Closed Exception (see below). The problem was that the JDBC driver was not compatible to the MySQL server version. I have used version 5.05a for both JDBC and MySQL and it solved the problem The problem is that the connection [...]
    Oracle at LinuxTag 2011 in Berlin, Germany
    Employee +1 Vote Up -0Vote Down

    Linuxtag is likely one of the oldest and largest Linux/OSS events in Germany. I remember having been there to represent SuSE Linux while it still took place at the University of Kaiserslautern, using tables and chairs from the lecture rooms as exhibition stands (this must have been around 1998 or 1999). This year it will take place in Berlin again, and the session schedule looks very promising. I'll be there from Wednesday till Friday and I feel that I will have a hard time deciding which presentations I should attend...

    I'll be speaking about What's new in MySQL 5.5 on Friday, 13th of May, at 15:00. If you haven't updated to MySQL

      [Read more...]
    Another Attempt At Python
    +0 Vote Up -1Vote Down

    I tried Python out a while ago, but stopped trying it to learn it after some major frustrations. Maybe I didn’t dig deep enough into it. I found the documentation hard to read, and the module layout seemed a little random at times. For some reason I found executing an external process and getting the results to be a little convoluted. (Since then I’ve learned to use popen(..).communicate())

    I ended up messing with other languages to try to find one that suits my tastes, like Erlang and

      [Read more...]
    How to set up a MySQL connection pool in Java
    +6 Vote Up -0Vote Down
    MySQL connection pool A MySQL connection pool is a pool of connections to MySQL database. Opening and maintaining a database connection for each process (or thread), is time costly (connection creation time) and wastes resources (connections). Connection pool increase the performance of (Java) applications that needs to connect to the database by reusing the connections. [...]
    Some Transactional Debugging Enhancements in MySQL Connector/J 5.1.15 You Should Know About
    Employee +5 Vote Up -0Vote Down
    
    

    If you're using Innodb and transactions with JDBC and your MySQL application, you should know about a couple of debugging features that made their way into MySQL Connector/J 5.1.15.

    First, by adding "includeThreadNamesAsStatementComment=true" to your JDBC URL, you will get the current Java thread's name that is executing SQL on a given connection as a statement comment, visible in SHOW FULL PROCESSLIST output:


    mysql> show full processlist;
    +------+------+-----------------+------+---------+------+----------+------------------------------------------------------+
    | Id   | User | Host            | db   | Command | Time | State    | Info                                                 |
    +------+------+-----------------+------+---------+------+----------+------------------------------------------------------+
    ...

      [Read more...]
    Developer Week in Review
    +0 Vote Up -1Vote Down

    This is your Developer Week in Review, I'm Casey Kasem. Our first letter comes from a software developer in New England who writes, "Dear Casey. My wife just got accepted into the Experimental Psych doctoral program at UNH, and I'd like you to play something appropriate for the occasion." Well, going out especially for you, here's "I'll be Proofreading Your Papers for the Next Five Years, 'Cause I'll Never Split (Our Infinitive)" (Seriously, congratulations Bonnie!)

    And you thought that Justin Bieber tickets were hard to score ...

    What's the matter, pal? You say you had your heart set on going to Google I/O, but the tickets sold out in

      [Read more...]
    Is Apple Good for Innovation?
    +0 Vote Up -0Vote Down
    Just about everyone on the planet agrees that Apple products are the soul of innovative design.  But are they good for innovators?  For me the answer is "not so much."

    I have been using Apple laptops and iPhones for years.  As a software developer, I have a list of annoyances with Mac OS X starting with Apple's incomprehensible management of Java.  However, Mac OS X is far more productive than MS Windows, with its viruses, crummy OS releases, and bloatware.  iPhones are close to worthless as telephones in the area where I live in large part due to ATT's network.  But you can now switch to Verizon, so that's not such a problem either.

    The real problem with Apple is that their products are closed.  Want to install a new file system?  Not here.  Want to pick a different motherboard to play around with power



      [Read more...]
    Cluster/J - Document-oriented approach on MySQL Cluster
    +2 Vote Up -0Vote Down
    In a project Severalnines is engaged in, we are developing a realtime application based on Cluster/J. To start with, I must say cluster/j is fantastic and so far I am very happy with it and beaten our expectations big time. It is quite new however and we stumbled on a couple of issues, but those were fixed very fast by the Cluster/J developers. The bugs we encountered were:
    Both which were worked around, and really we never did need to have a binary or a varbinary as the PK, we used a

    Performance is great - we have two data nodes (nehalem, 32GB RAM, 146GB SAS 10K disk, 2x4 core 2.4GHz (E5620) ) and two application hosts (same spec, less RAM as data



      [Read more...]
    451 CAOS Links 2011.01.25
    +0 Vote Up -1Vote Down

    VMware grows 41%. Evidence of Java infringement disputed. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
    “Tracking the open source news wires, so you don’t have to.”

    # VMware announced full year revenue growth of 41% to $2.9bn.

    # Alleged evidence of infringing Java code in Android disputed.

    # Oracle nominated SouJava, the Brazilian Java User Group, to a seat in the JCP Executive Committee.

    # The Document Foundation launched LibreOffice 3.3.

    # JasperSoft


      [Read more...]
    Amazon moves into PaaS with Elastic Beanstalk, Java as 1st class citizen
    Employee_Team +0 Vote Up -0Vote Down

    Amazon's EC2 and its sister S3 service have been indisputable leaders in IaaS for a long while now and GlassFish and more generally J2EE/JavaEE took advantage of it starting in 2008 (see here and here), with documented how-to's and significant production references.

    Just yesterday, AWS's Evangelist Jeff Barr announced

      [Read more...]
    A last look at 2010... and what's in sight?
    +0 Vote Up -0Vote Down

    For a few years, I've tried to recap here some events I've found notable over the past year and offering some guesses on what might be ahead of us. I'm somewhat late on these things this year, due to being busy with other stuff, but I didn't want to break the tradition, no matter how silly my wrong guesses might seem later. And again, others have covered generals, so I'll try to focus on specifics, in particular as they relate to what I do. For a look at what we achieved for Habbo, see my recap post on the Sulake blog.

    This time last year Oracle still had not successfully completed the Sun acquisition due to some EC silliness, but that finally happened over the 2010. It seems to be

      [Read more...]
    CAOS Theory Podcast 2010.12.10
    +0 Vote Up -0Vote Down

    Topics for this podcast:

    *Oracle, Java, the Apache Software Foundation and open source
    *An update on some open source database and data management players
    *CorraTech grows with support for open source application alternatives
    *Red Hat-Makara acquisition analysis and impact
    *Linux kernel report shows strong support, but what now for Novell?

    iTunes or direct download (29:31, 5.1MB)

    Adopting RAD in the Enterprise: The 14 Biggest Misconceptions
    +0 Vote Up -0Vote Down

    Rapid Application Development (RAD) is a way of developing computer software applications with less effort than the traditional means.

    RAD tools focus on providing code generation and automated testing capabilities with the use of convention over configuration to provide a streamlined workflow to create applications.

    Even with the most advanced and easiest to use RAD tools, there are times which the traditional enterprise and the business software development vendors which are having their own implementations and in-house built frameworks are continuously refusing to adopt them.

    Most of the misconceptions on the RAD are based on FUD (Fear, Uncertainty

      [Read more...]
    Developer Week in Review
    +0 Vote Up -2Vote Down

    If you live in the U.S., this is the week to gorge on turkey. I wondered out loud last night to my wife if Thanksgiving is the day of the year when the most people eat the same meal. Can any of our overseas readers add to the conversation? Is there a holiday in your country where everyone eats pretty much the same thing? Anyway, before American brains shut down from an overdose of stuffing, here's some developer news you can use.

    Oracle announces Plan B for Java

    The Java language has continued to evolve over the years, adding features such as Generics. There's an ambitious wishlist of things that developers would like to see in Java 7, but apparently not enough time to do it all and still get a timely release out. As a result, the JCP has decided to forego

      [Read more...]
    Developer Week in Review
    +0 Vote Up -1Vote Down

    Here's what's new for the trendy developer this week:

    Java's future on Apple: Slightly less in doubt

    Last week, it looked like Apple was all "You're not welcome here, Java." In the changeable world that is Jobsland, this week Apple was offering to marry the language, reiterating their support for Java in OS X, and indicating that they would be supplying code and resources to the OpenJDK project.

    As I've noted before, this makes sense for Apple, because it gets them out of the JVM business, and makes Oracle the one-stop shopping solution for all your JDK and JRE needs. It also means that the Mac can be added as a regression-tested target for a new version of Java, hopefully

      [Read more...]
    Java mutiny in the making
    +2 Vote Up -0Vote Down

    The Apache Software Foundation’s latest statement on the Java Community Process highlights continued dissatisfaction and dissent from Oracle’s stewardship and involvement in open source software.

    This comes after some ups and downs for Oracle and its oversight of Java and other open source software that was previously under the auspices of Sun Microsystems. Oracle started off on a rough path when it sued Google over its implementation of Java in Android without preemptively or clearly stating that it was not attacking open source. At about the same time, it let OpenSolaris die a slow, somewhat confusing

      [Read more...]
    451 CAOS Links 2010.11.02
    +0 Vote Up -1Vote Down

    JCP election results. Funding for Acquia and Continuent. Fedora 14. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
    “Tracking the open source news wires, so you don’t have to.”

    # The Java Community Process election results are in.

    # Acquia closed an $8.5m series C funding round and announced that it has tripled its customer base in 2010.

    # Continuent appointed Robert Hodges CEO and confirmed details of $5m funding from Aura Capital.

    # Red Hat announced the


      [Read more...]
    451 CAOS Links 2010.10.05
    +0 Vote Up -0Vote Down

    Microsoft sues Motorola. Oracle says no to LibreOffice. Time to fork Java? And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
    “Tracking the open source news wires, so you don’t have to.”

    # Microsoft is suing Motorola over alleged Android patent infringements.

    # Oracle confirmed to SJVN that it will not be working with the Document Foundation on LibreOffice.

    # Sean Michael Kerner reported that Red Hat has settled an alleged patent infringement case with IP firm Acacia Research.

    # Greg Luck asked if it


      [Read more...]
    Oracle OpenWorld 2010 Wrap-Up – from an #ODTUG Perspective
    +0 Vote Up -0Vote Down

    Oracle OpenWorld 2010 is over!  While I had to leave early Tuesday (the paying job takes precedence over the volunteer job), there are many things to talk about that happened while I was at OpenWorld this year.  I’ll attempt to cover a few of them in this posting.

    Saturday Night, the ODTUG Board and YCC staff got together to discuss our plans and obligations for the week.  With Sunday User Forum, MySQL Sunday, and Oracle Develop to attend to during the week, along with many other meetings, this was an important start to the week.  It was nice for everyone to see everyone again, and to recharge and energize for the tasks ahead during the week.  Below is a picture of fellow Board Members Barbara Morris and Monty Latiolais at the dinner at Annabelle’s Bar and Bistro.

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 273 Next 30 Older Entries

    Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.