You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@karaf.apache.org by "Jean-Baptiste Onofré (Jira)" <ji...@apache.org> on 2020/10/08 14:32:00 UTC
[jira] [Assigned] (KARAF-5730) pax jdbc does not create tables in
H2 database
[ https://issues.apache.org/jira/browse/KARAF-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jean-Baptiste Onofré reassigned KARAF-5730:
-------------------------------------------
Assignee: (was: Jean-Baptiste Onofré)
> pax jdbc does not create tables in H2 database
> ----------------------------------------------
>
> Key: KARAF-5730
> URL: https://issues.apache.org/jira/browse/KARAF-5730
> Project: Karaf
> Issue Type: Bug
> Components: karaf
> Affects Versions: 4.2.0
> Reporter: Olga Kulikova
> Priority: Critical
>
> Cannot create tables in H2 database. I tried the following with the freshly downloaded karaf 4.2.0:
> {{karaf@root()> feature:install transaction jndi jdbc pax-jdbc pax-jdbc-h2 pax-jdbc-config}}
> {{karaf@root()> jdbc:ds-list}}
> {{Name │ Product │ Version │ URL │ Status}}
> {{─────┼─────────┼─────────┼─────┼───────}}
> {{karaf@root()> jdbc:ds-create -dc org.h2.Driver -url "jdbc:h2:mem:~/test" test}}
> {{karaf@root()> jdbc:ds-list}}
> {{Name │ Product │ Version │ URL │ Status}}
> {{─────┼─────────┼──────────────────────┼────────────────────┼───────}}
> {{test │ H2 │ 1.3.172 (2013-05-25) │ jdbc:h2:mem:~/test │ OK}}
> {{karaf@root()> jdbc:tables test}}
> {{TABLE_CAT │ TABLE_NAME │ SELF_REFERENCING_COL_NAME │ TABLE_SCHEM │ TYPE_SCHEM │ TYPE_CAT │ TABLE_TYPE │ REMARKS │ REF_GENERATION │ TYPE_NAME │ SQL}}
> {{──────────┼───────────────────┼───────────────────────────┼────────────────────┼────────────┼──────────┼──────────────┼─────────┼────────────────┼───────────┼────}}
> {{TEST │ CATALOGS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLLATIONS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLUMNS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLUMN_PRIVILEGES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CONSTANTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CONSTRAINTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CROSS_REFERENCES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ DOMAINS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ FUNCTION_ALIASES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ FUNCTION_COLUMNS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ HELP │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ INDEXES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ IN_DOUBT │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ LOCKS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ RIGHTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ ROLES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SCHEMATA │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SEQUENCES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SESSIONS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SESSION_STATE │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SETTINGS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLE_PRIVILEGES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLE_TYPES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TRIGGERS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TYPE_INFO │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ USERS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ VIEWS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{karaf@root()> jdbc:execute test "CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255))"}}
> {{karaf@root()> jdbc:tables test}}
> {{TABLE_CAT │ TABLE_NAME │ SELF_REFERENCING_COL_NAME │ TABLE_SCHEM │ TYPE_SCHEM │ TYPE_CAT │ TABLE_TYPE │ REMARKS │ REF_GENERATION │ TYPE_NAME │ SQL}}
> {{──────────┼───────────────────┼───────────────────────────┼────────────────────┼────────────┼──────────┼──────────────┼─────────┼────────────────┼───────────┼────}}
> {{TEST │ CATALOGS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLLATIONS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLUMNS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ COLUMN_PRIVILEGES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CONSTANTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CONSTRAINTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ CROSS_REFERENCES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ DOMAINS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ FUNCTION_ALIASES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ FUNCTION_COLUMNS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ HELP │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ INDEXES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ IN_DOUBT │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ LOCKS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ RIGHTS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ ROLES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SCHEMATA │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SEQUENCES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SESSIONS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SESSION_STATE │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ SETTINGS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLE_PRIVILEGES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TABLE_TYPES │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TRIGGERS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ TYPE_INFO │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ USERS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
> {{TEST │ VIEWS │ │ INFORMATION_SCHEMA │ │ │ SYSTEM TABLE │ │ │ │}}
>
> The only records in the log (debug):
> {{13:47:56.834 DEBUG [Karaf local console user karaf] Executing command: 'jdbc:execute test "CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255))"'}}
> {{13:47:56.918 DEBUG [Karaf local console user karaf] Command: 'jdbc:execute test "CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255))"' returned 'null'}}
> {{13:47:59.793 DEBUG [Karaf local console user karaf] Executing command: 'jdbc:tables test'}}
> {{13:47:59.910 DEBUG [Karaf local console user karaf] Command: 'jdbc:tables test' returned 'null'}}
>
> If I try to do the same with derby (like in the documentation [http://karaf.apache.org/manual/latest/#_datasources_jdbc|http://karaf.apache.org/manual/latest/#_datasources_jdbc),]), the table is created, but jdbc:ds-list shows 2 datasources:
> {{karaf@root()> jdbc:ds-list}}
> {{Name │ Product │ Version │ URL │ Status}}
> {{─────┼─────────┼─────────┼─────┼───────}}
> {{karaf@root()> jdbc:ds-create -dn derby -url "jdbc:derby:test;create=true" test}}
> {{karaf@root()> jdbc:ds-list}}
> {{Name │ Product │ Version │ URL │ Status}}
> {{─────┼──────────────┼───────────────────────┼─────────────────┼───────}}
> {{test │ Apache Derby │ 10.13.1.1 - (1765088) │ jdbc:derby:test │ OK}}
> {{test │ Apache Derby │ 10.13.1.1 - (1765088) │ jdbc:derby:test │ OK}}
> From the log (info):
> {{14:01:54.701 INFO [CM Configuration Updater (Delete: pid=org.ops4j.datasource.a3c8e29e-cfbf-4283-85c4-ac53e2cc4cdb)] Obtained service dependency: (&(objectClass=org.osgi.service.jdbc.DataSourceFactory)(osgi.jdbc.driver.name=derby))}}
> {{14:01:54.702 INFO [CM Configuration Updater (Delete: pid=org.ops4j.datasource.a3c8e29e-cfbf-4283-85c4-ac53e2cc4cdb)] Found DataSourceFactory. Creating DataSource test}}
> {{14:01:54.703 INFO [CM Configuration Updater (Delete: pid=org.ops4j.datasource.a3c8e29e-cfbf-4283-85c4-ac53e2cc4cdb)] Obtained service dependency: (&(objectClass=org.osgi.service.jdbc.DataSourceFactory)(osgi.jdbc.driver.name=derby))}}
> {{14:01:54.703 INFO [CM Configuration Updater (Delete: pid=org.ops4j.datasource.a3c8e29e-cfbf-4283-85c4-ac53e2cc4cdb)] Found DataSourceFactory. Creating DataSource test}}
> {{14:02:04.571 WARN [pipe-jdbc:ds-list] Multiple JDBC datasources found with the same service ranking for test}}
> {{14:02:04.572 WARN [pipe-jdbc:ds-list] Multiple JDBC datasources found with the same service ranking for test}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)