Unable to find a driver that accepts jdbc:db2://db2.sb1.comp.com:50001/CMSDB

[kli...@gmail.com]

Jboss EAP 6.8

P6Spy added as a module and loaded in jboss-deployment-structure.xml ( works with datasources to mysql ) 

DB2 datasource : 

<datasource jta="true" jndi-name="java:/datasource/g4flight/cmsdbXASpyDS" pool-name="g4flight-cmsdbXASpyDS" enabled="true" use-java-context="false" spy="true" use-ccm="false">

                    <connection-url>jdbc:p6spy:db2://db2.sb1.comp.com:50001/CMSDB;</connection-url>

                    <driver>p6spy</driver>

                    <security>

                        <user-name>xxx</user-name>

                        <password>xxx</password>

                    </security>

                    <validation>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>false</background-validation>

                    </validation>

                    <timeout>

                        <set-tx-query-timeout>false</set-tx-query-timeout>

                        <blocking-timeout-millis>0</blocking-timeout-millis>

                        <idle-timeout-minutes>0</idle-timeout-minutes>

                        <query-timeout>0</query-timeout>

                        <use-try-lock>0</use-try-lock>

                        <allocation-retry>0</allocation-retry>

                        <allocation-retry-wait-millis>0</allocation-retry-wait-millis>

                    </timeout>

                    <statement>

                        <share-prepared-statements>false</share-prepared-statements>

                    </statement>

</datasource>

<drivers>

                    <driver name="db2" module="com.ibm.db2">

                        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

                        <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class>

                    </driver>

                    <driver name="p6spy" module="com.p6spy">

                        <driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>

                    </driver>

</drivers>

Getting this error : 

Caused by: java.sql.SQLException: Unable to find a driver that accepts jdbc:db2://db2.sb1.comp.com:50001/CMSDB;

at com.p6spy.engine.spy.P6SpyDriver.findPassthru(P6SpyDriver.java:119) [p6spy-2.1.4.jar:]

at com.p6spy.engine.spy.P6SpyDriver.connect(P6SpyDriver.java:94) [p6spy-2.1.4.jar:]

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:323)

[Peter Butkovic]

what p6spy version do you use?
moreover, does p6spy-free version work for you?

The last thing to look at would be using driverlist config, that should help in such a scenario, see: http://p6spy.readthedocs.io/en/latest/configandusage.html#driverlist

Dňa piatok, 11. novembra 2016 23:30:15 UTC+1 (neznáme) napísal(-a):

[kli...@gmail.com]

I did try : 

driverlist=com.mysql.jdbc.Driver,com.ibm.db2.jcc.DB2Driver

that did not help. 

I am using version 2.1.4

[butk...@gmail.com]

OK. Any chance for giving it a try with 3.0.0?

--
You received this message because you are subscribed to the Google Groups "p6spy users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to p6spy-users+unsubscribe@googlegroups.com.
To post to this group, send email to p6spy...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/p6spy-users/3b955fc8-1bee-4cdc-9eaf-0bc04bd8d029%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[kli...@gmail.com]

Updated to 3.0.0 but still same problem. 

Also tried with 

driverlist=com.mysql.jdbc.Driver,com.ibm.db2.jcc.DB2Driver

Caused by: java.sql.SQLException: Unable to find a driver that accepts jdbc:db2://db2.sb1.comp.com:50001/CMSDB:currentSchema=CMSDB;

at com.p6spy.engine.spy.P6SpyDriver.findPassthru(P6SpyDriver.java:116) [p6spy-3.0.0.jar:]

at com.p6spy.engine.spy.P6SpyDriver.connect(P6SpyDriver.java:91) [p6spy-3.0.0.jar:]

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:323)

... 28 more

[butk...@gmail.com]

Hey! Well, honestly speaking, we don't have DB2 set up for integration testing with app servers. Not sure how could we help here. As based on information provided things work just fine with another jdbc driver :( The way to go would probably be providing a sample project with full infrastructure (dockerized/vagrant/) for the environment to give it a try. Not sure about volunteers for that :(

--

You received this message because you are subscribed to the Google Groups "p6spy users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to p6spy-users+unsubscribe@googlegroups.com.
To post to this group, send email to p6spy...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/p6spy-users/93fb14a9-52bb-4d63-a5b8-cb4a238fa9a0%40googlegroups.com.