java - Connecting to database with Jetty and JNDI/JPA -

-

i trying migrate glassfish jetty. trying setup connection pools within jetty access oracle database jpa. when have connection information in persistence.xml, connection works , can access database know database drivers working. apps use jndi lookup data source example below.

when run entitymanager null @ em.createnativequery(querystring, config.class).getresultlist();.

persistence.xml:

<?xml version="1.0" encoding="utf-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"> <persistence-unit name="data_source" transaction-type="jta">     <jta-data-source>testdata</jta-data-source>     <exclude-unlisted-classes>false</exclude-unlisted-classes>     <properties>         <property name="eclipselink.cache.shared.default" value="false"/>     </properties> </persistence-unit>

java:

@managedbean(name = "configdao") @applicationscoped public class configdao implements serializable {      @persistencecontext()     private entitymanager em;     @resource     private usertransaction utx;      public string getgroupemaillist() {         return getconfigbyname(fileutils.email_list).getconfigvalue();     }      public config getconfigbyname(string configname) {         string querystring = "select * config config_name = '" + configname + "'";         list<config> configlist = em.createnativequery(querystring, config.class).getresultlist();          if (configlist != null && !configlist.isempty()) {             return configlist.get(0);         }          return null;     }  }

in jetty.xml in $jetty_home/etc

<new id="testdata" class="org.eclipse.jetty.plus.jndi.resource">     <arg/>     <arg>testdata</arg>     <arg>         <new class="oracle.jdbc.pool.oracledatasource">             <set name="url">jdbc:oracle:thin:@server:1521:data</set>             <set name="user">user</set>             <set name="password">password</set>             <set name="connectioncachingenabled">true</set>             <set name="connectioncacheproperties">                 <new class="java.util.properties">                     <call name="setproperty">                         <arg type="java.lang.string">inactivitytimeout</arg>                         <arg type="java.lang.string">300</arg>                     </call>                     <call name="setproperty">                         <arg type="java.lang.string">abandonedconnectiontimeout</arg>                         <arg type="java.lang.string">600</arg>                     </call>                     <call name="setproperty">                         <arg type="java.lang.string">timetolivetimeout</arg>                         <arg type="java.lang.string">600</arg>                     </call>                     <call name="setproperty">                         <arg type="java.lang.string">initiallimit</arg>                         <arg type="java.lang.string">10</arg>                     </call>                     <call name="setproperty">                         <arg type="java.lang.string">maxstatementslimit</arg>                         <arg type="java.lang.string">50</arg>                     </call>                     <call name="setproperty">                         <arg type="java.lang.string">minlimit</arg>                         <arg type="java.lang.string">20</arg>                     </call>                 </new>             </set>         </new>     </arg> </new>


Comments

Post a Comment

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md...
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s...
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more