[JBoss-dev] xdoclet module patch
David, I've submitted patch XDT-423 to allow the jboss-service-template subtask to merge external mbeans. I'm assuming that you're the one that will merge the patch contents, so please let me know if you need anything from me. I'm not sure I generated the diff file correctly (it's my first try), so let me know if anything looks strange. Any idea if it looks good when it might be incorporated into xdoclet? Ryan --- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] Support for application clients
i'd just like to toss in my 2 cents and say that it'd be really nice if my web start clients could use the java:comp/env namespace. then i could use the xdoclet util classes that were generated with the logical ejb reference and not the phyisical one. -Original Message- From: Igor Fedorenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 11:26 AM To: [EMAIL PROTECTED] Subject: RE: [JBoss-dev] Support for application clients Although I did not try it, both WebSphere 5.0 and WebLogic 7.0 both claim to support it. The main advantage that I see is java:comp/env JNDI namespace on the client side. This way it becomes possible to share a lot of code between EJB and non-EJB parts of the app. -Original Message- From: Bill Burke [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 11:36 AM To: [EMAIL PROTECTED] Subject: RE: [JBoss-dev] Support for application clients What are the advantages of it? It would require a client container. I wonder if any other vendor supports it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Igor Fedorenko Sent: Tuesday, March 04, 2003 11:24 AM To: [EMAIL PROTECTED] Sourceforge. Net (E-mail) Subject: [JBoss-dev] Support for application clients Hi, JBoss 3.2 does not seem to support application clients as specified in J2EE Spec, v1.3, section 9. Is there any reason why this is not supported other than nobody has asked it? Igor Fedorenko Think smart. Think automated. Think Dynamics. www.thinkdynamics.com --- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] jbosscx rfe 677512
i posted this request about a week ago, and would like to know any developers thoughts on this. to summerize, i'd like to be able to force a datasource to timeout any connections in the pool after a period of time. we're running jboss 3.0.6 with oracle 8i and right now and we're constantly running into an error Maximum number of cursors exceeded. being able to timeout connections that have been used heavily to restore those cursors is the only idea i had to get around this error. unfortunately this is a MAJOR problem for us right now, since we can't get our application up with 24/7 reliability. it only takes a matter of minutes of heavy activity to exceed 300 cursors on oracle. if there is some other way to get around this error, i would appreciate any feedback. or, if this is a planned enhancement, when would it be integrated? thanks in advance. Ryan --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] jbosscx rfe 677512
thank you all for your reply, i'll try and clear some things up for all those that responded. mark: sorry if i sounded demanding. i am more than willing to contribute my knowledge (however limited) to help the jboss project continue to thrive. i've been an avid user of jboss for the past 2 years now, and just recently i've begun to dig into the actual code. that being said, i still consider myself a relative rookie, and my post was meant to ask advice, not demand service. again, sorry if my netiquete came off rude. david, igor: i'm using BMP beans and all of my database connections and prepared statements are being closed in finally blocks. my resulset's are not being closed at all, but isn't it stated somewhere that closing the statement, closes all resultsets? i will test if closing resultset's makes any difference. bill, luke: thank you for your ideas, i will be checking the oracle tables you mentioned to see if i can get some more information. thank you all again for your replies! Ryan -Original Message- From: Igor Fedorenko [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: RE: [JBoss-dev] jbosscx rfe 677512 -Original Message- From: Sonnek, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 11:50 AM To: '[EMAIL PROTECTED]' Subject: [JBoss-dev] jbosscx rfe 677512 i posted this request about a week ago, and would like to know any developers thoughts on this. to summerize, i'd like to be able to force a datasource to timeout any connections in the pool after a period of time. we're running jboss 3.0.6 with oracle 8i and right now and we're constantly running into an error Maximum number of cursors exceeded. being able to timeout connections that have been used heavily to restore those cursors is the only idea i had to get around this error. unfortunately this is a MAJOR problem for us right now, since we can't get our application up with 24/7 reliability. it only takes a matter of minutes of heavy activity to exceed 300 cursors on oracle. if there is some other way to get around this error, i would appreciate any feedback. or, if this is a planned enhancement, when would it be integrated? I am not sure I understand your problem. In RFE you are saying cached prepared statements stay alive and cause this error. What caches prepared statements? Did you explicitly enabled statement caching on oracle connections? I remember seeing this error message but it turned to be a problem in one of my SSBs which did not explicitly close java.sql.[Prepared]Statement. Well, strictly speaking it is a known JBoss bug/limitation -- Connection.close() does not close all opened [Prepared]Statement as it is supposed to -- but is has a reasonable workaround. --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] jboss 2.4 to 3.x migration error
migrating a small jsp app that uses an oracle database from jboss 2.4.6 to 3.0.6, the following error is recieved from a page that calls commit() after an insert/update/delete. You cannot commit with autocommit set! in 2.4, the commit was required to get any of our pages to work, and now they fail with this error. is there some way to configure a datasource in 3.x to have autocommit set to false, or in 2.4 to set it to true? thanks ahead of time. Ryan --- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] jboss 2.4 to 3.x migration error
doh! sorry! this should have been sent to the user list!! -Original Message- From: Sonnek, Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 5:08 PM To: '[EMAIL PROTECTED]' Subject: [JBoss-dev] jboss 2.4 to 3.x migration error migrating a small jsp app that uses an oracle database from jboss 2.4.6 to 3.0.6, the following error is recieved from a page that calls commit() after an insert/update/delete. You cannot commit with autocommit set! in 2.4, the commit was required to get any of our pages to work, and now they fail with this error. is there some way to configure a datasource in 3.x to have autocommit set to false, or in 2.4 to set it to true? thanks ahead of time. Ryan --- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] OracleLoginModule
out of curiosity, could you say how you did this? i'm assuming that you're authenticating to the DBA_USERS and DBA_USER_ROLES tables, and this is something that i tried a while back. i got stuck being able to hash my login modules password to match oracles. there was no documentation on what algorithm they were using, and so after trying a few, i gave up. this is something that i am HIGHLY interested in, and would love to take a look at. congratulations on the hard work. Ryan -Original Message-From: David Jencks [mailto:[EMAIL PROTECTED]]Sent: Monday, February 03, 2003 9:04 AMTo: [EMAIL PROTECTED]Subject: Re: [JBoss-dev] OracleLoginModule I'm very interested in this login module. Can you supply it as a "patch" in the sourceforge tracker? Otherwise I may lose track of it before I can review and commit it. Offhand it seems to me that the LoginModule should only work if the criteria was ByContainer. Are you calling ds.getConnection() or ds.getConnection(user, pw)? Can you check the code in XAManagedConnectionFactory.matchManagedConnection and BaseWrapperManagedConnectionFactory.getConnectionProperties to see if it is obvious why the match is failing? You might need to modify the OracleXAManagedConnectionFactory to provide more suitable matching behavior. (I'm looking at jboss head for these classes). thanks david jencks Hi guys, I wrote a login module specific for Oracle DataBase, that try to authenticate a user on Oracle DataSource and map Oracle Role on J2ee Role. I think it could be very interesting for guys that have jboss and Oracle together, because you could manage roles and user just in one enviroment. I tried it on my enviroment and seems to work only if I set in Oracle-xa-service.xml attribute name="Criteria"ByApplication/attribute If I set it to ByContainer I get this error: 15:14:02,562 WARN [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.adapter.jdbc.xa.oracle.XAOracleManagedConnection@462631 And connection still Opened on the DB. Could you please explain me what's happen. Thank you in advance BTW I attached my source, what about it? Couldn't it be useful for anyone? image.tiff OracleServerLoginModule.java
RE: [JBoss-dev] Oracle specific jca adapter
david, do you have any ideas on how i could implement this scenerio? Ryan -Original Message- From: Sonnek, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 10:21 AM To: '[EMAIL PROTECTED]' Subject: RE: [JBoss-dev] Oracle specific jca adapter thank you for all of your help david. i spent some time this weekend looking through the jca code in jboss-all and jboss-head, and i must admit i'm a bit overwhelmed. =) there's a lot more there than i expected. i was thinking it would be a simple extension of some base class and then resolving that class in the oracle-ds.xml, but i'm not so sure that's how it works now. i was hoping to be able and use the CallerIdentityLoginModule in order to have the user log in through JAAS (hopefully an ldap server), and then when getConnection() is called, extract that principal and call the stored procedure with that user name. the slightly misleading piece to this is that the actual connection to the database is still made as a generic accout specific in the oracle-ds.xml. here's the sequence of events that i'm trying to create (as i understand it). 1. user logs into JAAS login module to set principal (ldap in my case). 2. user queries database and BMP object calls getConnection(). 3. datasource is configured to connect to database as a specific account (using config-properties in the oracle-ds.xml) 4. before returning the connection to the BMP object, the following code needs to be executed: String sql = BEGIN contexts.set_username( ? ) ; END ;; stmt = connection.prepareCall(sql) ; stmt.setString(1, the_logged_in_username); stmt.execute(); return connection; if possible to use the CallerIdentityLoginModule, where can i intercept the getConnection() call and run this statement before returning the connection to the caller. if i have misunderstood how the JBossCX module operates, please feel free to clarify. thank you again. Ryan -Original Message- From: David Jencks [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 5:50 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Oracle specific jca adapter I would imagine this would need to be called whenever the user changes. This can be detected when getConnection is called on ManagedConnection. I'd check to see if the user has actually changed. If you implement this you should change the pooling parameter Criteria to ByNothing for this adapter because this basically means Oracle is supporting reauthentication. To actually use this feature you will need to do application managed security (bad idea IMO) (i.e. calling datasource.getConnection(user, pw)) or use a login module that supplies more than one Subject such as the CallerIdentityLoginModule. Good luck! I'll be mostly offline till monday or tuesday when I can probably answer more questions. david jencks --- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] Oracle specific jca adapter
thank you for all of your help david. i spent some time this weekend looking through the jca code in jboss-all and jboss-head, and i must admit i'm a bit overwhelmed. =) there's a lot more there than i expected. i was thinking it would be a simple extension of some base class and then resolving that class in the oracle-ds.xml, but i'm not so sure that's how it works now. i was hoping to be able and use the CallerIdentityLoginModule in order to have the user log in through JAAS (hopefully an ldap server), and then when getConnection() is called, extract that principal and call the stored procedure with that user name. the slightly misleading piece to this is that the actual connection to the database is still made as a generic accout specific in the oracle-ds.xml. here's the sequence of events that i'm trying to create (as i understand it). 1. user logs into JAAS login module to set principal (ldap in my case). 2. user queries database and BMP object calls getConnection(). 3. datasource is configured to connect to database as a specific account (using config-properties in the oracle-ds.xml) 4. before returning the connection to the BMP object, the following code needs to be executed: String sql = BEGIN contexts.set_username( ? ) ; END ;; stmt = connection.prepareCall(sql) ; stmt.setString(1, the_logged_in_username); stmt.execute(); return connection; if possible to use the CallerIdentityLoginModule, where can i intercept the getConnection() call and run this statement before returning the connection to the caller. if i have misunderstood how the JBossCX module operates, please feel free to clarify. thank you again. Ryan -Original Message- From: David Jencks [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 5:50 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Oracle specific jca adapter I would imagine this would need to be called whenever the user changes. This can be detected when getConnection is called on ManagedConnection. I'd check to see if the user has actually changed. If you implement this you should change the pooling parameter Criteria to ByNothing for this adapter because this basically means Oracle is supporting reauthentication. To actually use this feature you will need to do application managed security (bad idea IMO) (i.e. calling datasource.getConnection(user, pw)) or use a login module that supplies more than one Subject such as the CallerIdentityLoginModule. Good luck! I'll be mostly offline till monday or tuesday when I can probably answer more questions. david jencks --- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] Oracle specific jca adapter
i'm working on a project currently that is requiring that for each connection to the database, a set of database packages are called before any insert/update/select/delete commands are run. i'd like to do this by writing an extension to the existing JCA modules to execute these packages before returning the java.sql.Connection object to the caller. i've gone through the pay docs and examples but i must admit that i'm a bit lost on where to start. any suggestions on what classes i need to extend and what xml files are needed would be greatly appreciated. oracle is really pushing this context setting as their recommended method of enterprise connections, and i'd be more than happy to submit anything i get working to the jboss base code as a patch. i just to be pointed in the right direction. thank you for all of your input! Ryan J. Sonnek Brown Printing Company J2EE Application Developer 507.835.0803 mailto:[EMAIL PROTECTED] --- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] Oracle specific jca adapter
oracle suggests that the context be set for each user executing a query. my initial thought was that each time getConnection() was called, the current principal of the caller would be used for these oracle packages. but, now that you mention it, wouldn't it have to be done for each transaction? it's whole intent is that instead of using individual connections to the database, it uses a generic connection pool, but it extracts the JAAS principal and sets it in the oracle context for use with triggers. it makes scence in a way since you get the benifits of acurate audit information without the overhead of individual connections to the database. my question now is should this be done on the individual statement level, or the transaction level? i vaguely understand the process of when getConnection() is called for BMP classes, but i don't know when it's caled for CMP classes. i need to ensure that each statement run by a particular user has the context information set. Ryan -Original Message- From: David Jencks [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 5:00 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Oracle specific jca adapter When does Oracle want you to execute this stuff? Per statement? per getConnection? per tx Anyway, look in connector/src/main/org/jboss/resource/adapter/jdbc/ This contains the base classes and the local and xa specific subclasses are in the local and xa folders. There's an Oracle specific ManagedConnectionFactory for xa to work around some other oracle features. If you really need to do something whenever a connection handle is given to a user app, look in one of the ManagedConnection classes at getConnection. If you need to do something whenever a new physical connection is established to Oracle do it in the ManagedConnection constructor. You can intercept new statement and use-of-statement operations in the connection and statement wrappers. If you need to do them at the start of a transaction maybe you could wrap the XAResource?? thanks david jencks On Friday, January 17, 2003, at 04:43 PM, Sonnek, Ryan wrote: i'm working on a project currently that is requiring that for each connection to the database, a set of database packages are called before any insert/update/select/delete commands are run. i'd like to do this by writing an extension to the existing JCA modules to execute these packages before returning the java.sql.Connection object to the caller. i've gone through the pay docs and examples but i must admit that i'm a bit lost on where to start. any suggestions on what classes i need to extend and what xml files are needed would be greatly appreciated. oracle is really pushing this context setting as their recommended method of enterprise connections, and i'd be more than happy to submit anything i get working to the jboss base code as a patch. i just to be pointed in the right direction. thank you for all of your input! Ryan J. Sonnek Brown Printing Company J2EE Application Developer 507.835.0803 mailto:[EMAIL PROTECTED] --- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
