[MDEV-11198] CONNECT engine table_type=JDBC with jtds driver won't pool Created: 2016-10-31 Updated: 2017-10-17 Resolved: 2017-10-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Connect |
| Affects Version/s: | 10.1.18 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Robert Dyas | Assignee: | Olivier Bertrand |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
centOS 7 |
||
| Description |
|
The ApacheInterface pooling setup seems to work for other JDBC drivers. java.lang.AbstractMethodError rc=0' from CONNECT Query is: SELECT DISTINCT `ms_jtdsTest`.`Id`, `ms_jtdsTest`.`Naam` FROM `ms_jtdsTest` ) #1296 If I use the JDBCInterface wrapper default it work without error. |
| Comments |
| Comment by Olivier Bertrand [ 2016-10-31 ] |
|
For JDBC tables, CONNECT calls a Java wrapper and if an error occurs, retrieves the Java error message and displays it. In this case it can be a bug in the Jtds driver, in the Apache pooling process, or simply that the Apache pool does not support all drivers, or even that this is an error which is platform dependant. In any case I would not rate it as Major since it works normally with the JdbcInterface wrapper, which by the way is currently the only one distributed with binary distribution. |
| Comment by Robert Dyas [ 2016-11-01 ] |
|
Sorry about the Major priority rating. I accepted the default but have now changed it. On a related (sort of) note, can you think of why when using the Microsoft provided JDBC driver the table names would come back as blank? I haven't posted anything here as I figure we must be doing something stupid. There is a row for each table name, and the open source jtds driver returns the table names correctly, but the MS JDBC driver has blank table names. I'm guessing this is some kind of character encoding problem as the numeric columns come back fine. Also, possibly related Works perfectly using MySQL jdbc with both local and connect databases using UTF8 if that helps. |
| Comment by Olivier Bertrand [ 2016-11-01 ] |
|
I'll been busy for a couple of days and look at these problems when I come back. Thanks for reporting. |
| Comment by Robert Dyas [ 2016-12-15 ] |
|
Any update on these? |
| Comment by Robert Dyas [ 2017-10-17 ] |
|
This is an older bug report that has superseded by others. This bug can be closed as a duplicate (even though the duplicate is newer than this one.) |