|
Hi I have one production issue related to database connection.
Earlier it was a single threaded now other team migrated to Multithreaded application. After migration we have some production related to database connectivity when we perform more operations.
Please find the below logs and hibernate config xml file.
Could some one help me to fix this issue.
Error logs :----
2013-03-01 10:23:53,803 (pool-2-thread-5) [DEBUG] CacheTranscodeManagerImpl - files copied from /opt/transcode/transcode/cache/SN-API-COMCAST_NATIONAL-HD-NC/3DBE3E900937F028BE397C9158CF8510 to /opt/transcode/transcode/output/559311
2013-03-01 10:23:54,449 (pool-2-thread-5) [WARN ] JDBCExceptionReporter - SQL Error: 0, SQLState: null
2013-03-01 10:23:54,449 (pool-2-thread-5) [ERROR] JDBCExceptionReporter - Connection is closed.
2013-03-01 10:23:54,449 (pool-2-thread-5) [ERROR] AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.scrippsnetworks.transcode.model.TranscodeCache#248019]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:801)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:799)
at com.scrippsnetworks.transcode.dao.impl.TranscodeCacheDaoImpl.saveTranscodeCache(TranscodeCacheDaoImpl.java:36)
at com.scrippsnetworks.transcode.service.impl.TranscodeCacheManagerImpl.saveTranscodeCache(TranscodeCacheManagerImpl.java:22)
at com.scrippsnetworks.transcode.service.impl.CacheTranscodeManagerImpl.getTranscodeResult(CacheTranscodeManagerImpl.java:201)
at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:203)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
at $Proxy23.getTranscodeResult(Unknown Source)
at com.scrippsnetworks.transcode.service.CacheRunner.run(CacheRunner.java:42)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:183)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2354)
... 29 more
2013-03-01 10:23:54,452 (pool-2-thread-5) [ERROR] JDBCTransaction - Could not toggle autocommit
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardC
Hibernate config xml :-
<bean id="dataSourceTS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
<property name="driverClassName"><value>${jdbc.driver}</value></property>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>
thanks in advance.
Thanks
Ravindra Reddy
|
|
|
|
|
Hello,
try specifying the instance parameter in connection string. Following text is extracted from the JTDS FAQ. SQL Server can run multiple so-called "named instances" (i.e. different server instances, running on different TCP ports) on the same machine. When using Microsoft tools, selecting one of these instances is made by using "<host_name>\<instance_name>" instead of the usual "<host_name>". With jTDS you will have to split the two and use the instance name as a property.
Regards,
Prasad P. Khandekar
Knowledge exists, man only discovers it.
|
|
|
|
|
I have problem for creating invoice
like OpenERP invoice
any one can help me?
|
|
|
|
|
This is not a well framed question! We cannot work out what you are trying to do/ask from the post.
You need to elaborate and be specific on what are you trying to do and where are you stuck. Use the "Edit" link to edit your question and provide better information.
|
|
|
|
|
hi friends, please assist me with a game that has 5 marbles(balls)and marbles are hit with a paddle and roll on the panel and drop to a circular hole.......in java
thanks
|
|
|
|
|
What help exactly? If you are expecting someone to write this for you then you will be disappointed. If you are looking for useful samples then go to the CodeProject Articles section[^].
Use the best guess
|
|
|
|
|
 Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
|
|
|
|
|
|
Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
|
|
|
|
|
see my reply here ^
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
modified 6-Mar-13 10:59am.
|
|
|
|
|
Bonjour,
j'ai un projet qui doit obligatoirement utiliser le système immunitaire artificiel comme méthode de classification.
j'ai déjà posé mes questions sur d'autres forums, mais il n'y a pas grand nombres de personnes qui ont utilisé ce procédé.
Donc svp, quelqu'un à t-il déjà utilisé l'AIS ?
je depend de vos aides s'il vous plaît pour réaliser mon projet intitulé:
" Application du système immunitaire artificiel pour la reconnaissance de
formes'' l’Écriture arabe "
et merci
|
|
|
|
|
This is an English speaking website/forum. could you please translate that to English so that every one could understand and answer to your query.
|
|
|
|
|
لحن الأماني wrote: Hello,
I have a project that must use the artificial immune system as a method of classification.
I've asked my questions on other forums, but no large numbers of people who have used this method.
So please, someone he already used the AIS?
I depend on your support please for my project entitled:
"Application of the immune system for recognizing artificial
forms; the Arabic Script"
I'm not sure what you are asking here, but if you want someone to provide you with a ready made answer then you will be disappointed.
Je ne suis pas sûr de ce que vous demandez ici, mais si vous voulez quelqu'un pour vous donner une réponse toute faite, alors vous allez être déçu.
Use the best guess
|
|
|
|
|
A bit of googling around came up with the following research paper..
pdf
a book: cleveralgorithms.com/nature-inspired/immune/
Similar *research* (and publications) on artificial life can be found at santafe.edu
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
|
|
|
|
|
Interesting, but I didn't ask the question.
Use the best guess
|
|
|
|
|
Oops. My mistake. 
yikes he has multiple posts.
Q. Hey man! have you sorted out the finite soup machine?
A. Why yes, it's celery or tomato.
|
|
|
|
|
how we stored the data into collection class in java
|
|
|
|
|
|
Hey guys & gals.
I'm just asking a quick question about my end of year college project.
I've written an Android application which scans student ID's, gets the information from the barcode, sends that to a server which shows on screen via WiFi.
Now currently I have it set so when it receives the info it saves to a txt file.
I allready have an excel file with details in it e.g Student Number, days present, Submission.
Is it possible for me to use a button press on the Server GUI that will take the string e.g "ABC12345" from the txt file and run a check against "ABC12345" in the Excel file containing the students info? which will then do checks using "fuzzy" logic, e.g if they missed 4 days out of 20 they're OK and if they miss 15 out of 20 they're in trouble?
If it is possible to do, could you give me some guidance on how to go about checking the txt file string against the Excel and any tutorials I can read up on? 
Thanks in advance!
Mark.
|
|
|
|
|
There is a Java library (see here[^]) which allows you to read Excel files.
Use the best guess
|
|
|
|
|
Will give it a look and get back to you, cheers! 
|
|
|
|
|
hi every one
I need some help with my android app
I have been searching for tutorials to fined the nearest places
at my country and details about them ..
but I was surprised I haven't getting any useful results
would some one please help : (
|
|
|
|
|
|
thanks for your help
I have seen the androidHive tutorial and have been working on it
but Google places api returns no results when i use my own lat & lon
I am searching to use other web-providers like yahoo or something but still
face issues in learning 
|
|
|
|
|
Would someone please give me an example of a program that increments and decrements values with just the use of combo box and buttons, no other stuffs like a JDialog or even JTable. I'm having a hard time trying to understand complicated programs after all I'm just a newbie in java, so I need a very simple one that is easy to understand.
the code is this:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.Scanner;
public class EditStack {
private JComboBox comboBox = new JComboBox();
private JButton button = new JButton("Add Order");
private JButton button_1 = new JButton("Decrease Order");
JComboBox combo;
private static String z = "";
private static String w = "";
private static String x = "";
private static String a = "";
private int numClick = 0;
public EditStack() {
String mgaPagkainTo[] = {"PM1 (Paa/ Spicy Paa with Thigh part)","PM2 (Pecho)","PM3 (Pork Barbeque 4 pcs.)","PM4 (Bangus Sisig)","PM5 (Pork Sisig)","PM6 (Bangus Inihaw)","SM1 (Paa)","SM2 (Pork Barbeque 2 pcs.)","Pancit Bihon","Dinuguan at Puto","Puto","Ensaladang Talong","Softdrinks","Iced Tea","Halo-Halo","Leche Flan","Turon Split"};
JFrame frame = new JFrame("Mang Inasal Ordering System");
JPanel panel = new JPanel();
combo = new JComboBox(mgaPagkainTo);
combo.setBackground(Color.gray);
combo.setForeground(Color.red);
panel.add(combo);
panel.add(button);
panel.add(button_1);
frame.add(panel);
combo.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String str = (String)combo.getSelectedItem();
a = str;
EditLang messageOrder1 = new EditLang();
messageOrder1.ShowOrderPo();
}
});
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String selectedItem = (String) comboBox.getSelectedItem();
numClick++
}
}
);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setSize(300,250);
frame.setVisible(true);
}
public static void main(String[] args) {
Scanner inp = new Scanner(System.in);
boolean ulitinMoPows = true;
boolean tryAgain = true;
System.out.print("\nInput Customer Name: ");
String customerName = inp.nextLine();
w = customerName;
System.out.print("\nInput Cashier Name: ");
String user = inp.nextLine();
z = user;
do{
System.out.print("\nInput either Dine In or Take Out: ");
String dInDOut = inp.nextLine();
x = dInDOut;
if (x.equals("Dine In") || x.equals("Take Out")){
System.out.print("");
ulitinMoPows = false;
}
else{
JOptionPane.showMessageDialog(null, "Try again! Please input Dine In or Take Out only!","Error", JOptionPane.ERROR_MESSAGE);
ulitinMoPows = true;
System.out.print ("\f");
}
}while(ulitinMoPows);
do{
System.out.print("\nInput password: ");
String pass = inp.nextLine();
if(pass.equals("admin")){
EditLang messageShowMenu = new EditLang();
messageShowMenu.ShowMo();
tryAgain = false;
}
if(!pass.equals("admin")){
JOptionPane.showMessageDialog(null, "Try again! Invalid password!","Error Logging-In", JOptionPane.ERROR_MESSAGE);
tryAgain = true;
System.out.print ("\f");
}
}while(tryAgain);
EditStack j = new EditStack();
}
public static String kuhaOrder()
{
return a;
}
public static String kuhaUserName()
{
return z;
}
public static String kuhaCustomerName()
{
return w;
}
public static String kuhaSanKainPagkain()
{
return x;
}
}
public class EditLang {
public void ShowMo(){
String user = EditStack.kuhaUserName();
System.out.print("\n\n\t\tCashier: " +user);
String dInDOut = EditStack.kuhaSanKainPagkain();
System.out.print(" "+dInDOut);
String customerName = EditStack.kuhaCustomerName();
System.out.print("\n\t\tCustomer Name: " +customerName);
}
public void ShowOrderPo() {
String order = EditStack.kuhaOrder();
System.out.print("\t\t\t\t\n " +order);
}
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
