[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Helped Me! Thanks very much! View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3938625#3938625 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3938625 --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Certainly helped me out. You'd think such a simple solution would have been presented much earlier by those in the know. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3904257#3904257 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3904257 --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
[EMAIL PROTECTED] wrote : Now the don't abuse the procedure to get attention is over. :-) | | For future reference, | (in the unlikely event that somebody finds this issue rather than the 1000+ | similar stupid questions) | the problem is like any other ClassCastException. | You have two different versions of the class. | | Rather than looking at the implementation class look at the interface classes | (OracleConnection is an interface after all) | Class.getInterfaces(); | and where they are loaded from | Class.getClassLoader(); | Class.getProtectionDomain().getCodeSource() Adrian, I posted in the bug report that I already did such things and the class is some sort of wrapper, because when I call the class.getName() it returns the oracle.sql.ARRAY. It works fine in JBoss 3.2.5, but not 4.0.3, same exact configuration on my part, sounds like some sort of bug to me. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3900159#3900159 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3900159 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
[EMAIL PROTECTED] wrote : Now the don't abuse the procedure to get attention is over. :-) | | For future reference, | (in the unlikely event that somebody finds this issue rather than the 1000+ | similar stupid questions) | the problem is like any other ClassCastException. | You have two different versions of the class. | | Rather than looking at the implementation class look at the interface classes | (OracleConnection is an interface after all) | Class.getInterfaces(); | and where they are loaded from | Class.getClassLoader(); | Class.getProtectionDomain().getCodeSource() Ok, you were correct (though I wish in a nicer way - similar stupid questions). I guess the classloader changed between 3.2.5 and 4.0.3, because in 3.2.5 I had the oracle drivers in both the server/lib and my WEB-INF/lib and it worked fine. However, in 4.0.3, I had to remove the oracle drivers from WEB-INF/lib in order for it to work. Sorry for my stupid question, but I hope this solution helps someone else out, since obviously other people had such stupid questions as well. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3900162#3900162 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3900162 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Now the don't abuse the procedure to get attention is over. :-) For future reference, (in the unlikely event that somebody finds this issue rather than the 1000+ similar stupid questions) the problem is like any other ClassCastException. You have two different versions of the class. Rather than looking at the implementation class look at the interface classes (OracleConnection is an interface after all) Class.getInterfaces(); and where they are loaded from Class.getClassLoader(); Class.getProtectionDomain().getCodeSource() View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3900061#3900061 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3900061 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
I opened a bug on this, it seems related to a proxy/wrapper with the JCA that is interfering with some operations: http://jira.jboss.com/jira/browse/JBAS-2343 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3899942#3899942 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3899942 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Your bug report has been deleted since it is not a bug. http://wiki.jboss.org/wiki/Wiki.jsp?page=HelpBugReport I'm not going to tell you what is wrong either because I don't want to encourage you to ME TOO or jump the help queue by posting bug reports to get attention. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3899948#3899948 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3899948 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Rhetorical question: Why do think this original question was ignored by me if I thought there bug lurking here? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3899949#3899949 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3899949 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
I'm getting the same problem, any luck in fixing this without modifying source code? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3899719#3899719 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3899719 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
Here's my stacktrace: 19:11:01,056 WARN [OracleValidConnectionChecker] Unexpected error in pingDatabase java.lang.IllegalArgumentException: object is not an instance of declaring class at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.i sValidConnection(OracleValidConnectionChecker.java:54) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.i sValidConnection(BaseWrapperManagedConnectionFactory.java:377) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkVal id(BaseWrapperManagedConnection.java:212) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.m atchManagedConnections(LocalManagedConnectionFactory.java:186) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge tConnection(InternalManagedConnectionPool.java:167) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP ool.getConnection(JBossManagedConnectionPool.java:529) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage dConnection(BaseConnectionManager2.java:410) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo nnection(TxConnectionManager.java:342) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC onnection(BaseConnectionManager2.java:462) at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio nManagerProxy.allocateConnection(BaseConnectionManager2.java:894) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp erDataSource.java:73) Here's my ds.xml to show it's configured correctly (this is working fine with JBoss 3.2.5, I'm now trying to move up to 4.0.2 or 4.0.3 both are giving this error): local-tx-datasource jndi-namejdbc/MyDS/jndi-name connection-urljdbc:oracle:thin:APP/APP@//mybox:1521/MYDB/connection-url driver-classoracle.jdbc.OracleDriver/driver-class min-pool-size20/min-pool-size max-pool-size400/max-pool-size !-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -- valid-connection-checker-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker/valid-connection-checker-class-name !-- Checks the Oracle error codes and messages for fatal errors -- exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter/exception-sorter-class-name !-- Make a large statement cache size for increased performance -- prepared-statement-cache-size100/prepared-statement-cache-size !-- Checks for idle connections retrieved from the pool and times them out -- !-- This should be set to the same value as the auto-logout property -- idle-timeout-minutes30/idle-timeout-minutes /local-tx-datasource I've also noticed now that in some of my queries that then cast results back to oracle.sql.Array type, that is also throwing a ClassCastException. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3899741#3899741 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3899741 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: problem w/ OracleValidConnectionChecker
A bit more info - I added some debug to the OracleValidConnectionChecker. It appears that the Connection that is getting passed to the isValidConnection(Connection c) method is not, in fact, an oracle.jdbc.driver.OracleConnection but rather a JBoss proxy of some kind. The top of the isValidConnection method does: log.info( checking valid connection: + c ); |log.info( connection is: + c.getClass().getName() ); |log.info( ping method: + ping ); |log.info( ping method declaring class: + ping.getDeclaringClass().getName() ); 2005-07-06 14:55:00,444 INFO [MyOracleValidConnectionChecker] checking valid connection: [EMAIL PROTECTED] 2005-07-06 14:55:00,444 INFO [MyOracleValidConnectionChecker] connection is: $Proxy47 2005-07-06 14:55:00,445 INFO [MyOracleValidConnectionChecker] ping method: public int oracle.jdbc.driver.OracleConnection.pingDatabase(int) throws java.sql.SQLException 2005-07-06 14:55:00,446 INFO [MyOracleValidConnectionChecker] ping method declaring class: oracle.jdbc.driver.OracleConnection View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3883910#3883910 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3883910 --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
