You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@karaf.apache.org by "Sergey (JIRA)" <ji...@apache.org> on 2015/09/07 12:48:45 UTC
[jira] [Commented] (KARAF-3976) Broken compatibility with 3.x jdbc
DataSources
[ https://issues.apache.org/jira/browse/KARAF-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14733533#comment-14733533 ]
Sergey commented on KARAF-3976:
--------------------------------
Also,
{code}
karaf@root()> jdbc:query --help
DESCRIPTION
jdbc:query
Execute a SQL query on a JDBC datasource
SYNTAX
jdbc:query datasource query
ARGUMENTS
datasource
The JDBC datasource to use
query
The SQL query to execute
karaf@root()> jdbc:query jdbc/fidbDataSource "select DB_NAME()"
Error executing command jdbc:query: too many arguments specified
{code}
This one worked in 3.x. Exactly 2 arguments specified.
> Broken compatibility with 3.x jdbc DataSources
> ----------------------------------------------
>
> Key: KARAF-3976
> URL: https://issues.apache.org/jira/browse/KARAF-3976
> Project: Karaf
> Issue Type: Bug
> Components: karaf-jdbc
> Affects Versions: 4.0.1
> Reporter: Sergey
>
> 1st of all, current documentaion is wrong, because command names was changed to jdbc:ds-info, for example, but http://karaf.apache.org/manual/latest/users-guide/jdbc.html still contains jdbc:info command names.
> Most important compatibility breaking change was another one: in karaf 3.x I was able to deploy DataSource using spring-dm xml or blueprint, and it was registered as a service and in jndi, and was listed using jdbc:datasources command. Right now no datasources are listed.
> {code}
> karaf@root()> jndi:names
> JNDI Name | Class Name
> ------------------------------------------------------------------------------------------
> osgi:service/jdbc/zeusDataSource | net.sourceforge.jtds.jdbcx.JtdsDataSource
> osgi:service/jdbc/arenaDS | net.sourceforge.jtds.jdbcx.JtdsDataSource
> osgi:service/jdbc/tomsDS | net.sourceforge.jtds.jdbcx.JtdsDataSource
> osgi:service/jdbc/cofDS | com.sybase.jdbc3.jdbc.SybDataSource
> osgi:service/jdbc/fidbDataSource | net.sourceforge.jtds.jdbcx.JtdsDataSource
> osgi:service/jdbc/murexDS | com.sybase.jdbc3.jdbc.SybDataSource
> osgi:service/jdbc/gpDataSource | org.postgresql.ds.PGPoolingDataSource
> karaf@root()> jdbc:ds-info jdbc/fidbDataSource
> Property | Value
> ---------------------------------------------------------------------
> driver.version | 1.2.2
> db.version | 10.50.4000
> db.product | Microsoft SQL Server
> url | jdbc:jtds:sqlserver:
> driver.name | jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
> username | ...
> karaf@root()> jdbc:ds-list
> Name | Product | Version | URL | Status
> ---------------------------------------
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)