Re: EJBs & CMP with real database users

From: Jon Martin Solaas (jonmartin.solaas_at_mail.link.no)
Date: 08/27/04

  • Next message: tch: "HSQLDB Server NullPointerException with custom function"
    Date: Fri, 27 Aug 2004 08:28:19 GMT
    
    

    Fredrik Bertilsson wrote:

    >>How do you propose database-access not using j2ee? Remember jdbc is part
    >>of j2ee ...
    >
    > JDBC (java.sql and javax.sql) is a part of J2SE not J2EE.

    No. JDBC is described in version 1.4 J2EE.2.6.6. Also, JNDI is
    J2EE.2.6.8. Both are distributed as enterprise features in J2SE, though,
    along with a couple of other J2EE features as well.

    >
    >
    >>It also makes sense
    >>to persist the per-user-connection throughout the session in a pool
    >>instead of re-connecting each time the database needs to be accessed.
    >
    > Correct. I didn't say that the connection should be closed after every server call.
    >

    So why do you absolutely not want to use a connection pool for this
    purpose? You'll have the opportunity to let each user have more than one
    connection at a time, the pool will handle the connection for you
    automatically, you won't have to re-connect if the connection closes for
    you and so on. Sounds much better to me ... writing code to handle such
    standard stuff is just a waste and opens up for nasty bugs nobody really
    needs (unless those who write debuggers, ofcourse :-)

    -- 
    jonmartin.solaas¤h0tm4i1
    

  • Next message: tch: "HSQLDB Server NullPointerException with custom function"

    Relevant Pages

    • RE: Connection pooling
      ... Connection Pooling with SQL Server 2000 Analysis Services ... the Microsoft XML for Analysis Provider to develop scalable client and Web ... applications for Microsoft SQL Server 2000 Analysis Services. ... Balancing and Shrinking the Connection Pool ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL Compact Edition - Connection Pool --> Slow!
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
      (microsoft.public.sqlserver.ce)
    • Re: SQL Compact Edition - Connection Pool --> Slow!
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
      (microsoft.public.sqlserver.ce)
    • Re: ASP.NET SQL Processes
      ... Microsoft Online Support ... when we use the ADO.NET's connection ... | connection pool, when we create SqlConnections, the ADO.NET will retrieve ... | | SQL server doesn't keep any processes attached to the application. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: SQL Compact Edition - Connection Pool --> Slow!
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... The question I have is related to connection together with multithreading. ... the connection pool for Compact Edition 3.1. ...
      (microsoft.public.sqlserver.ce)