Hi !!!
i'm a newby with JBoss, so i'm testing it by executing the Gangster ReadAheadTest,
supplied with the buied documentation.
I'm using for this test postgreSQL and i need to keep no more than 4 connection (later
in production i'm forced to use Microsoft Desktop Engine)
This i my postgres-ds.xml :
<datasources>
| <local-tx-datasource>
| <jndi-name>PostgresDS</jndi-name>
| <connection-url>jdbc:postgresql://192.168.10.17:5432/gangster</connection-url>
| <driver-class>org.postgresql.Driver</driver-class>
| <user-name>postgres</user-name>
| <password></password>
| <min-pool-size>2</min-pool-size>
| <max-pool-size>4</max-pool-size>
| <idle-timeout-minutes>1</idle-timeout-minutes>
| </local-tx-datasource>
| </datasources>
I've put 500 gangster in gangster table, then for test purpose i've launched 8 process
testing the application, in this way:
ant readhead &
| ant readhead &
| ant readhead &
| ant readhead &
| ant readhead &
| ant readhead &
| ant readhead &
| ant readhead &
the last process invoked by ant will produce the following error
java.lang.Exception: org.jboss.util.NestedSQLException:
| No ManagedConnections available within configured blocking timeout ( 30000 [ms] );
| - nested throwable: (javax.resource.ResourceException:
| No ManagedConnections available within configured blocking timeout ( 10000 [ms] )):
| Get Access Level from Database error!
So i've added the following line to my postgres-ds.xml:
<blocking-timeout-millis>3600000</blocking-timeout-millis>
Then i've relaunched the test, but, during execution of last test (read-ahead with
user transaction) four of the eight test process
fail with this error:
18:19:49,549 ERROR [LogInterceptor] EJBException, causedBy:
| org.jboss.util.NestedSQLException:
| Interrupted while requesting permit! Waited 214326 ms, invocation time:
1089735589522; - nested throwable:
| (javax.resource.ResourceException: Interrupted while requesting permit! Waited
214326 ms, invocation time: 1089735589522)
| at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
Are userTransaction, used in this way:
public String createGangsterHtmlTable_with_tx() throws FinderException {
| UserTransaction tx = null;
| try {
| InitialContext ctx = new InitialContext();
| tx = (UserTransaction) ctx.lookup("UserTransaction");
| tx.begin();
|
| String table = createGangsterHtmlTable_no_tx();
|
| if(tx.getStatus() == Status.STATUS_ACTIVE) {
| tx.commit();
| }
| ...
blocking my connection ?
Can anyone help me, or suggest another user transaction usage ?
Thanks
[EMAIL PROTECTED]
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3841999#3841999
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3841999
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
