Atul Darne

We are facing an strange issue in weblogic JDBC Connection. Daily for our application we run "End of Day" (EOD). This EOD includes several branches and tasks for Interest calculation branch wise.

We have around 150+ branches for which this tasks are scheduled and completes one by one. It is observerd that our EOD gets stuck and below error is observed in weblogic logs.

When we retry the job it continues, this happens daily now. we are not able to figure why this happens.

Sharing the log below, please assist if any one knows a solution here.

2019-03-30 03:12:05,399 ERROR [[ACTIVE] ExecuteThread: '55' for queue: 'weblogic.kernel.Default (self-tuning)'] [transaction-id=933b69d3e018eb33:1cb19089:169cb4de31b:-16c0|RequestConvId=933b69d3e018eb33X1cb19089X169cb4de31bX-16c1] JDBCExceptionReporter Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'ZONE_TIPLUS_PROD': XAER_RMERR : A resource manager error has occured in the transaction branch
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
at weblogic.jdbc.jta.DataSource.start(DataSource.java:811)
at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1250)

We are using weblogic 11g and our database is oracle 11 g version.

After providing the setter for the variable

you can use the following syntax which takes bool as string and will parse for you (it doesnt have any errors too)

In the java code

setter Tag
private String boole; public void setBool(String bool) { this.boole = bool; }

Usage
if(Boolean.valueOf(bool)) {syntax..} else { syntax }

in the TLD
<attribute> <name>boole</name> <required>true</required> <description>true or falset</description> </attribute>


JSP Tag

<%@ taglib uri="http://www.google.com/mytaglibrary-taglib" prefix="mytag" %>

Usage
<mytag:showdiv bool="false" >

Games :
Cut the Rope
Where is my water
3D Bowling
Bubble Shooter

Apps:
UC Browser
TOI
Facebook
Twitter
TrackID by sony
Talking TOm
What's App
Timescape by Sony for posting on FB

Hi,

I am given a task POC to check if we should use wml or xhtml for building a web mobile application , for data entry.

Any suggestions please.

Hi kunal,

thanks it worked - i made the following changes

String SQL_QUERY ="from Patient"; Query query = session.createQuery(SQL_QUERY); for(Iterator it=query.iterate();it.hasNext();) { Patient p =(Patient) it.next(); System.out.println("ID: " +p.getFirstname()); } session.close();

Hi Vijitha ,

I am adding the class

package com.myclinic.dao; import java.util.Date; public class Patient { private Long patientID; private String firstname; private String middlename; private String lastname; private int age; private int gender; private String add1; private String add2; private String city; private String state; private String zip; private String country; private String mobileno; private String phone; private String email; private String prescribtion; private Date visitdate; public Long getPatientID() { return patientID; } public void setPatientID(Long patientID) { this.patientID = patientID; } public String getFirstname() { return firstname; } public void setFirstname(String firstname) { this.firstname = firstname; } public String getMiddlename() { return middlename; } public void setMiddlename(String middlename) { this.middlename = middlename; } public String getLastname() { return lastname; } public void setLastname(String lastname) { this.lastname = lastname; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public int getGender() { return gender; } public void setGender(int gender) { this.gender = gender; } public String getAdd1() { return add1; } public void setAdd1(String add1) { this.add1 = add1; } public String getAdd2() { return add2; } public void setAdd2(String add2) { this.add2 = add2; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public String getState() { return state; } public void setState(String state) { this.state = state; } public String getZip() { return zip; } public void setZip(String zip) { this.zip = zip; } public String getCountry() { return country; } public void setCountry(String country) { this.country = country; } public String getMobileno() { return mobileno; } public void setMobileno(String mobileno) { this.mobileno = mobileno; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getPrescribtion() { return prescribtion; } public void setPrescribtion(String prescribtion) { this.prescribtion = prescribtion; } public Date getVisitdate() { return visitdate; } public void setVisitdate(Date visitdate) { this.visitdate = visitdate; } }

Hi,

I have acheived adding contents to a database table by using hibernate xml hbm file, now i wish to search any user in it - i am stucked with with an error in the code

Session session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction(); //Using from Clause String SQL_QUERY ="from patientdetails.id,patientdetails.firstname"; Query query = session.createQuery(SQL_QUERY); for(Iterator it=query.iterate();it.hasNext();) { Patient p =(Patient) it.next(); System.out.println("ID: " +p.getFirstname()); } session.close();


iam having the following function

public List<Patient> getAllPatients() { Session session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); List<Patient> result = (List<Patient>) session.createQuery("from firstname").list(); session.getTransaction().commit(); return result; }

cfg file

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.bytecode.use_reflection_optimizer">false</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/clinic</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.connection.password">password</property> <property name="show_sql">true</property> <property name="hibernate.hbm2ddl.auto">update</property> <mapping resource="patient.hbm.xml" /> </session-factory> </hibernate-configuration>

patient.hbm.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.myclinic.dao.Patient" table="patientdetails"> <id name="patientID" type="java.lang.Long"> <column name="id" /> <generator class="increment" /> </id> <property name="firstname" type="string"> <column name="firstname" length="255" /> </property> <property name="middlename" type="string"> <column name="middlename" length="255" /> </property> <property name="lastname" type="string"> <column name="lastname" length="255" /> </property> <property name="age" type="int"> <column name="age" /> </property> <property name="gender" type="int"> <column name="gender" /> </property> <property name="add1" type="string"> <column name="add1" /> </property> <property name="add2" type="string"> <column name="add2" /> </property> <property name="city" type="string"> <column name="city" /> </property> <property name="state" type="string"> <column name="state" /> </property> <property name="zip" type="string"> <column name="zip" /> </property> <property name="country" type="string"> <column name="country" /> </property> <property name="mobileno" type="string"> <column name="mobileno" /> </property> <property name="phone" type="string"> <column name="phone" /> </property> <property name="email" type="string"> <column name="email" /> </property> <property name="prescribtion" type="string"> <column name="prescribtion" /> </property> <property name="visitdate" type="java.util.Date"> <column name="patientvisitdate" /> </property> </class> </hibernate-mapping>


i get the below error

when i do a select query on the table

INFO: HHH000232: Schema update complete org.hibernate.hql.internal.ast.QuerySyntaxException: patientdetails.id is not mapped [from patientdetails.id,patientdeta ils.firstname] at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110) at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93)

Hi Benjamin,

You can refer this tutorial webpage

thanks i updated an entry in .bashrc script by editing

i set the path by

export PATH=/usr/java/jdk1.6.0_25/bin:$PATH

i need to configure this startup

Hi,

i have a linux machine which has a Open JDK installed.

i downloaded a sun jdk and installed, it, now i want the system to use the sun jdk how do i configure it ??

i have the following

[root@localhost opt]# find / -name java
/usr/share/swig/1.3.40/java
/usr/share/mysql-gui/common/java
/usr/share/javadoc/java-1.6.0-openjdk/api/org/omg/stub/java
/usr/share/javadoc/java-1.6.0-openjdk/api/java
/usr/share/javadoc/java-1.6.0-openjdk/jre/api/plugin/dom/com/sun/java
/usr/share/javadoc/java
/usr/share/java
/usr/share/doc/db4-devel-4.7.25/java
/usr/share/doc/db4-devel-4.7.25/ref/java
/usr/bin/java
/usr/java
/usr/java/jdk1.6.0_25/bin/java
/usr/java/jdk1.6.0_25/jre/bin/java
/usr/lib/jvm-exports/java
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/bin/java
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/bin/java
/usr/lib/jvm/java
/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre/bin/java
/usr/lib/java
/opt/sun/javadb/demo/programs/scores/java
/opt/sun/javadb/demo/programs/vtis/java
/var/lib/alternatives/java
/etc/alternatives/java
/etc/pki/java
/etc/java
[root@localhost opt]# clear
[root@localhost opt]# find / -name java
/usr/share/swig/1.3.40/java
/usr/share/mysql-gui/common/java
/usr/share/javadoc/java-1.6.0-openjdk/api/org/omg/stub/java
/usr/share/javadoc/java-1.6.0-openjdk/api/java
/usr/share/javadoc/java-1.6.0-openjdk/jre/api/plugin/dom/com/sun/java
/usr/share/javadoc/java
/usr/share/java
/usr/share/doc/db4-devel-4.7.25/java
/usr/share/doc/db4-devel-4.7.25/ref/java
/usr/bin/java
/usr/java
/usr/java/jdk1.6.0_25/bin/java
/usr/java/jdk1.6.0_25/jre/bin/java
/usr/lib/jvm-exports/java
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/bin/java
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/bin/java
/usr/lib/jvm/java
/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre/bin/java
/usr/lib/java
/opt/sun/javadb/demo/programs/scores/java
/opt/sun/javadb/demo/programs/vtis/java
/var/lib/alternatives/java
/etc/alternatives/java
/etc/pki/java
/etc/java
[root@localhost opt]#

this is an old way to add the JSP script to the page itself..
you must use a framework like struts and hibernate

i am from mumbai

how do we know which jar has this class ?

thanks sandeep