[
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)
