-
1. Re: Getting an error in JBOSS AS 7.1
nickarls Dec 5, 2012 1:13 PM (in response to harjitdotsingh)More details reuquired. What DB type? persistence.xml? Datasource definition? Application structure etc...
-
2. Re: Getting an error in JBOSS AS 7.1
harjitdotsingh Dec 5, 2012 1:59 PM (in response to nickarls)The Database is SQL Server. Datasource definition is as follows
<datasource jndi-name="java:/SENTRYDATA" pool-name="SENTRYDATA" enabled="true" use-java-context="true">
<connection-url>jdbc:sqlserver://SQL1FC:1433;databaseName=Sentry126_RC1;DB_CLOSE_DELAY=-1</connection-url>
<driver>SQLDS</driver>
<security>
<user-name></user-name>
<password></password>
</security>
</datasource>
Application structure is as follows
I have a web application calling a REST BASED Service which actually does the call to the DB. Hope that helps
-
3. Re: Getting an error in JBOSS AS 7.1
nickarls Dec 5, 2012 2:18 PM (in response to harjitdotsingh)JPA? Datasource @Resource injection? Are you leaving locks behind in the database?
-
4. Re: Getting an error in JBOSS AS 7.1
harjitdotsingh Dec 5, 2012 2:30 PM (in response to nickarls)Here is the entry in the persistence.xml
<persistence-unit name="ceDataSessionData"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/SENTRYDATA</jta-data-source>
and here is how I'm instansiating it
emf = Persistence.createEntityManagerFactory("ceDataSessionData");
em = emf.createEntityManager();
-
5. Re: Getting an error in JBOSS AS 7.1
nickarls Dec 5, 2012 3:23 PM (in response to harjitdotsingh)And after some successful operations, are there any DB locks hanging around?
-
6. Re: Getting an error in JBOSS AS 7.1
harjitdotsingh Dec 5, 2012 3:30 PM (in response to nickarls)No there aren't any. Here is the scenario under which it starts happening. When I send normal string to search I do see results coming back. The moment I add any wildcards to the string data. I start seeing this. When I run the stored procedure with the same parameters it works fine and doesn't take long, its only that thru the rest based service I see this error.
-
7. Re: Getting an error in JBOSS AS 7.1
nickarls Dec 6, 2012 2:22 PM (in response to harjitdotsingh)Tried cranking up log levels so you can see what is causing the timeout?