Support Forum

[nbe]

Hello All,

We have installed TrackStudio on CentOS5. and we are facing some intermittent issues with it. Below are the errors from catalina log.
1. We get this error some time when we try to create user / ticket.
-----------------
error is Stack Trace:
org.hibernate.TransactionException: JDBC commit failed
at org.hibernate.transaction.JDBC
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:161)
at com.trackstudiokernel.lock.LockManager$LockTime.closeSession(LockManager.java:89)
at com.trackstudio.kernel.lock.LockManager.releaseWrite(LockManager.java:153)
at com.trackstudio.app.TriggerManager.createMessage(TriggerManager.java:103)

---------------------
2012-08-29 08:51:23,484 ERROR org.hibernate.transaction.JDBCTransaction:commit:155 - JDBC commit failed
java.sql.SQLException: Protocol violation

-----------------

2. Also while we are trying to stop the TrackStudio, we get below error and eventually we need to kill it as it never goes down.

---------------
org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/TrackStudio] appears to have started a thread named [pool-2-thread-17] but has failed to stop it. This is very likely to create a memory leak
--------------

Below is my configuration details

------------
OS -
[root@trackstudio packages]# cat /etc/redhat-release
CentOS release 5.7 (Final)
[root@trackstudio packages]# uname -a
Linux trackstudio 2.6.18-274.17.1.el5xen #1 SMP Tue Jan 10 18:06:37 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@trackstudio packages]#

Application -

TrackStudio_4016
jdk-7u5-linux-x64
apache-tomcat-7.0.29
oracle 11G
------------

Can anyone help me out in it? It is very very urgent for me at this stage .

[Petr]

Hello. What DB do you use?

[nbe]

Hello. What DB do you use?

Database version:Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Database major version:11
Database minor version:2
Database driver name:Oracle JDBC driver
Database driver version:11.1.0.7.0-Production
Database driver major version:11
Database driver minor version:1
Hibernate Dialect: org.hibernate.dialect.OracleDialect
Hibernate Driver: oracle.jdbc.OracleDriver

[Petr]

first of all you can try to replace jdbc driver which TrackStudio has on original jdbc driver which distributed with your Orable db. It must be located in a lib/jdbc folder.

[nbe]

Ok...I Tried with copping ojdbc jar file from oracle directory to /TrackStudio/app/tomcat/lib/ojdbc6.jar location and restarted the App. But it did not help me I still have the same error. What else can I try ?

[admin]

Ok...I Tried with copping ojdbc jar file from oracle directory to /TrackStudio/app/tomcat/lib/ojdbc6.jar location and restarted the App. But it did not help me I still have the same error. What else can I try ?

Please try to remove extra oracle jdbc drivers and put correct one to webapps/TrackStudio/WEB-INF/lib