Hi,
I use this snippet to get a connection?
ServletContext servletContext = (ServletContext)
FacesContext.getCurrentInstance().getExternalContext().getContext();
CayenneRuntime cayenneRuntime = WebUtil.getCayenneRuntime(servletContext);
ServerRuntime serverRuntime = (ServerRuntime)cayenneRuntime;
try {
Connection conn =
serverRuntime.getDataDomain().getNode("nodeName").getDataSource().getConnection();
} catch (SQLException e) {}
Meex
2013/2/19 Sampath Uppula <su0064...@techmahindra.com>
> Thanks Andrus for new version of cayenne.
>
> I have requirement,
> Is it possible to get the connection object from the ObjectContext? In
> some cases I want run the queries for reporting using the JDBC connectivity
> which requires the Connection object.
> Right now I had created the connection pool separately and reading the
> connection from the Pool this is seems to be a redundant pool.
> If I get connection object from the ObjectContext there is no need to
> maintain the separate Connection pool and I can directly use cayenne
> connection pool.
>
> Any thoughts?
>
> Thanks,
> Sampath Uppula.
>
>
>
> -----Original Message-----
> From: Andrus Adamchik [mailto:and...@objectstyle.org]
> Sent: Monday, February 18, 2013 9:40 PM
> To: user@cayenne.apache.org
> Subject: [ANN] Cayenne 3.1B2 released
>
> A second Beta of Cayenne 3.1 is available. This beta release includes more
> complete documentation (still work in progress ... the web site contains
> even better docs), and more than 20 bug fixes to the Modeler and the
> runtime framework. This release goes a long way in stabilizing and
> improving 3.1 for an average user. Very likely this will be the last beta
> before we make a "release candidate" and 3.1 "final". Most of the remaining
> 3.1 work will now focus on user documentation.
>
> B2 is a recommended upgrade for 3.1 users. We also certainly encourage
> everyone else to upgrade to 3.1 right now and tell us if you find any
> problems.
>
> Cayenne can be downloaded from http://cayenne.apache.org/download.html
>
> A full list of changes in this release:
>
> * CAY-1737 ObjectContexts listening to DataChannel events must be
> non-blocking
> * CAY-1753 remove light-superclass.vm class template
> * CAY-1754 Modeler suggested URL for SQLServer should start with
> 'jdbc:sqlserver:' instead of 'jdbc:microsoft:sqlserver:'
> Bug fixes in this release:
>
> * CAY-957 Deadlock in nested contexts
> * CAY-1689 [PATCH] LOB*QueryBuilders do not check
> isQuotingSQLIdentifiers
> * CAY-1701 Modeler cannot undo pasting of obj (db) entity
> * CAY-1708 Modeler error when pasting datamap with EJBQL query
> * CAY-1713 Inconsistent property name:
> "cayenne.rop.service.timeout"
> * CAY-1714 ROP: Cayenne tries to build a query for non committed
> object when using more than 2 nested contexts
> * CAY-1715 Passing parameters to mapped EJBQL queries
> * CAY-1721 Writing blobs fails (Oracle)
> * CAY-1725 NullPointerException from call to removeToManyTarget
> * CAY-1727 Modeler thinks entity is using inheritance when it
> doesn't
> * CAY-1729 PersistentDescriptor must have predictable property
> iteration order
> * CAY-1735 Serializable IncrementalFaultList
> * CAY-1738 Tutorial cayenne-rop-server should be packaged as a war
> * CAY-1739 Cayenne ROP server resets session on every request if
> BASIC auth is used
> * CAY-1741 Serializable DataObjectBaseProperty
> * CAY-1742 CAY-1742 ObjRelationship inspector says "ObjAttribute
> Inspector"
> * CAY-1744 Unexpected read-only relationships in vertical
> inheritance mapping
> * CAY-1749 NPE on simple nested context commit
> * CAY-1755 FaultFailureException resolving relationships to UNIQUE
> non-PK columns
> * CAY-1757 ROP: Faulting entity relationship resets uncommitted
> modifications made to its reverse relationship
> * CAY-1774 EhCacheQueryCache.get(QueryMetadata,
> QueryCacheEntryFactory) returns null if EhCache instance for group is not
> present
> * CAY-1783 JdbcPkGenerator.longPkFromDatabase would throw an
> exception if the PK value exceeds a range of Java int
>
>
> Andrus
>
> ============================================================================================================================Disclaimer:
> This message and the information contained herein is proprietary and
> confidential and subject to the Tech Mahindra policy statement, you may
> review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> http://tim.techmahindra.com/tim/disclaimer.html";>
> http://tim.techmahindra.com/tim/disclaimer.html</a> internally within
> Tech
> Mahindra.============================================================================================================================
>
--
*Markus Reich*
Moosbach 28/2
6392 St. Jakob i.H.
www.markusreich.at / www.meeximum.at
markus.re...@markusreich.at
