December 2010 - jboss-user - Jboss List Archives

[Datasource Configuration] - When and why does JBoss open more database connections than the maximum requested?

by Glauber Ribeiro

Glauber Ribeiro [http://community.jboss.org/people/theglauber] created the discussion "When and why does JBoss open more database connections than the maximum requested?" To view the discussion, visit: http://community.jboss.org/message/573910#573910 -------------------------------------------------------------- I have a data source configured like this: <datasources> <ha-local-tx-datasource> <datasources> <ha-local-tx-datasource> ... <min-pool-size>25</min-pool-size> <max-pool-size>30</max-pool-size> <validate-on-match>true</validate-on-match> <background-validation>true</background-validation> <background-validation-minutes>17</background-validation-minutes> <prefill>true</prefill> <set-tx-query-timeout>true</set-tx-query-timeout> <query-timeout>60</query-timeout> </ha-local-tx-datasource> </datasources> In my interpretation, his should mean: * start with 25 connections * grow to 30 if needed * but not more than 30 I have seen in several occasions the number of open connections go higher than 30. Some times i could correlate this with high activity, but not always. I've heard the number of connections went once to over 100 with no apparent provocation. Is this a known problem or feature? What triggers it? JBoss version: [4.3.0.GA_CP03 (build: SVNTag=JBPAPP_4_3_0_GA_CP03 date=200810241616)] Thank you for any help or ideas. glauber -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/573910#573910] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

2
3
0 / 0

[Datasource Configuration] - one data source with multiple Oracle database users

by Nicolas Kaczmarski

Nicolas Kaczmarski [http://community.jboss.org/people/pekka_x] created the discussion "one data source with multiple Oracle database users" To view the discussion, visit: http://community.jboss.org/message/568176#568176 -------------------------------------------------------------- Dear All, I have 2 application using 2 differents datasources : <?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>TooWsDataSource</jndi-name> <connection-url>jdbc:oracle:thin:@172.25.225.40:1521:paid</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>Too</user-name> <password>too</password> <metadata> <type-mapping>Oracle10g</type-mapping> </metadata> </local-tx-datasource>  <local-tx-datasource> <jndi-name>TooWsDataSourcePt</jndi-name> <connection-url>jdbc:oracle:thin:@172.25.225.40:1521:paid</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>Too2</user-name> <password>too</password> <metadata> <type-mapping>Oracle10g</type-mapping> </metadata> </local-tx-datasource> </datasources> But when the second application do an sql request the user used is "Too" instead of "Too2". Have you ideas? -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/568176#568176] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

2
1
0 / 0

[Datasource Configuration] - Re: DeploymentException: Error: can't find data source: Partha

by Nicolas Davyt

Nicolas Davyt [http://community.jboss.org/people/nicolasdavyt1234] created the discussion "Re: DeploymentException: Error: can't find data source: Partha" To view the discussion, visit: http://community.jboss.org/message/574272#574272 -------------------------------------------------------------- Try whith generate a Partha-datourceDS.xml with this: <datasources> <local-tx-datasource> <jndi-name>Partha</jndi-name> <connection-url>jdbc:sqlserver://Partha_server:1433;databasename=Partha</connection-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <user-name>Partha</user-name> <password>123456</password> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <idle-timeout-minutes>5</idle-timeout-minutes> </local-tx-datasource> </datasources> And put the file Partha-datourceDS.xml in Path > C:/jboss-5.1.0.GA/server/default/deploy/ -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574272#574272] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[Datasource Configuration] - Re: Datasource security

by Nicolas Davyt

Nicolas Davyt [http://community.jboss.org/people/nicolasdavyt1234] created the discussion "Re: Datasource security" To view the discussion, visit: http://community.jboss.org/message/574268#574268 -------------------------------------------------------------- Maybe you cant try with define 2 or 3 <jndi-name> with diferent username and password with respective privileges defined at the database. (only select, full acces, etc) *<local-tx-datasource> <jndi-name>TradeTestOracle_ONLY_SELECT_DS</jndi-name> <connection-url>jdbc:oracle:thin:@trmpd_pkg.bankers.com:1521:trmpd</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <max-pool-size>100</max-pool-size> <user-name>boatradeONLY_SELECT</user-name> <password>test1</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>Oracle9i</type-mapping> </metadata> </local-tx-datasource>* *<local-tx-datasource> <jndi-name>TradeTestOracle_ALL_ACCESS_DS</jndi-name> <connection-url>jdbc:oracle:thin:@trmpd_pkg.bankers.com:1521:trmpd</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <max-pool-size>100</max-pool-size> <user-name>boatrade**_ALL_ACCESS_**</user-name> <password>test1</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>Oracle9i</type-mapping> </metadata> </local-tx-datasource>* And in you code like for example: (in your dataBase Connection class.) public static Connection getConnection( User user) ...... if (user.equals("Bob")) ds = (DataSource) iniCtx.lookup("*TradeTestOracle_ONLY_SELECT_DS"*); else if (user.equals("John")) ds = (DataSource) iniCtx.lookup("*TradeTestOracle_ALL_ACCESS_DS**"*); ....... -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574268#574268] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[jBPM] - Re: jBPM 4.4 demo.setup.tomcat (task -> install.jbpm.into.tomcat)

by Andrzej Kulakowski

Andrzej Kulakowski [http://community.jboss.org/people/zigfryd] created the discussion "Re: jBPM 4.4 demo.setup.tomcat (task -> install.jbpm.into.tomcat)" To view the discussion, visit: http://community.jboss.org/message/574265#574265 -------------------------------------------------------------- Problem with jBPM Signavio designer - solved, it doesn't function correct under both Chrome nor IE9 Beta browsers, Firefox remains the sole way here. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574265#574265] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[JBoss Web Services] - Re: Error: Unsupported Java encoding for writing wsdl file: 'ISO8859_15'.

by Michał Minicki

Michał Minicki [http://community.jboss.org/people/Valgoerad] created the discussion "Re: Error: Unsupported Java encoding for writing wsdl file: 'ISO8859_15'." To view the discussion, visit: http://community.jboss.org/message/574252#574252 -------------------------------------------------------------- Add following line to run.conf in jboss-4.2.3/bin: set JAVA_OPTS=-Dfile.encoding=UTF-8 %JAVA_OPTS% -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574252#574252] Start a new discussion in JBoss Web Services at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[JBoss Portal] - Urgent work: Portal in Jboss portal

by leila trabelsi

leila trabelsi [http://community.jboss.org/people/leila.trabelsi25] created the discussion "Urgent work: Portal in Jboss portal" To view the discussion, visit: http://community.jboss.org/message/574241#574241 -------------------------------------------------------------- I am a student beginner in java, I am currently developing a portal for furniture and design, I found the solution jboss portal but I could not configure it. I work with l4IDE Eclipse and JBoss server. Please give me the simplified steps to work. My goal is to have my portal. Thank you in advance. Please can you answer me at this address leila.trabelsi25 @ gmail.com -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574241#574241] Start a new discussion in JBoss Portal at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[EJB3] - Dinamically switch DataSource in EJB3 application

by Sergei Makarov

Sergei Makarov [http://community.jboss.org/people/sergerus] created the discussion "Dinamically switch DataSource in EJB3 application" To view the discussion, visit: http://community.jboss.org/message/574221#574221 -------------------------------------------------------------- Is there a way to dinamically switch EntityManager's DataSource to working with more then one datanase? For this time I found only way described here: http:// http://community.jboss.org/message/356772 +" mailto:bill.burke@jboss.com bill.burke(a)jboss.com" wrote: deploy your entities as you would but assign them a JNDI name(see docs). In your EJB interceptor pick the appropriate JNDI name of the EntityManager you want to access. Either inject the ENtityManager into the field of your bean using a custom annotation, or stuff the chosen entity manager into a java.lang.ThreadLocal. This way you still get the automatic session management that the EJB/Java Persistence integration gives you. Following me?+ -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574221#574221] Start a new discussion in EJB3 at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

2
1
0 / 0

[JBoss Web Services] - Re: Maven wsconsume fails

by Alessio Soldano

Alessio Soldano [http://community.jboss.org/people/alessio.soldano%40jboss.com] created the discussion "Re: Maven wsconsume fails" To view the discussion, visit: http://community.jboss.org/message/574223#574223 -------------------------------------------------------------- I just tried simply creating a folder with your wsdl and pom.xml (of course created src/main/resources and src/main/java dirs), updated the pom.xml to use java 1.6 (basically specified maven-compiler-plugin with source and target 1.6) and ran 'mvn clean package'. The wsconsume plugin successfully generated the sources. Try googling on the sax parse exception you get, I this for instance: http://www.mail-archive.com/users@cxf.apache.org/msg02985.html http://www.mail-archive.com/users@cxf.apache.org/msg02985.html mailto://www.mail-archive.com/users@cxf.apache.org //www.mail-archive.com/users(a)cxf.apache.org/msg02985.html In any case this is strange, generally speaking, the wsconsume tooling is a facade over the Sun/Oracle wsimport tooling, so unless you get issues reated to classloading, the same behaviour should be expected... -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/574223#574223] Start a new discussion in JBoss Web Services at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

1
0
0 / 0

[JBoss Web Services] - Re: Receiving Compressed WebService Requests

by Baradon Terendil

Baradon Terendil [http://community.jboss.org/people/baradon] created the discussion "Re: Receiving Compressed WebService Requests" To view the discussion, visit: http://community.jboss.org/message/573871#573871 -------------------------------------------------------------- Hi all, I would like to push this topic a bit: I'm struggling with the same issue and haven't found any answer yet. Is it possible to configure JBoss to accept compressed SOAP requests? Response is no problem, but we also sometimes have large amount of data to be sent to the server. Or, alternatively, is it possible to add a special request handler or whatever, which uncompresses the data before forwarding it to the parser? Any suggestion welcome. Heiner -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/573871#573871] Start a new discussion in JBoss Web Services at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]

14 years, 3 months

2
1
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

jboss-user December 2010