problem connecting to h2 database

78 views
Skip to first unread message

Elena Aralla

unread,
May 14, 2021, 5:43:50 AM5/14/21
to H2 Database
Hi,

I have this error when I try to connect to H2 in embedded mode:

> 27sec 561ms > * > CLI v5.2.1 > 06:13 PM > ~/coldbox-examples/testApp/ > testApp (1.0.0) > lucee 5.3.7 (stopped) > > migrate up ERROR (5.2.1+00295) Unable to resolve com.h2database [106](R 106.0): missing requirement [com.h2database [106](R 106.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.5.0)) Unresolved requirements: [[com.h2database [106](R 106.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.5.0))] caused by: org.osgi.framework.BundleException Unable to resolve com.h2database [106](R 106.0): missing requirement [com.h2database [106](R 106.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.5.0)) Unresolved requirements: [[com.h2database [106](R 106.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.5.0))] /Users/elena/.CommandBox/cfml/modules/commandbox-migrations/modules/cfmigrations/modules/qb/models/Grammars/AutoDiscover.cfc: line 7 5: 6: function autoDiscoverGrammar() { 7: cfdbinfo( type = "Version", name = "local.dbInfo" ); 8: 9: switch ( dbInfo.DATABASE_PRODUCTNAME ) {

This are my settings:

"cfmigrations":{
"migrationsDirectory":"resources/database/migrations",
"schema":"INFORMATION_SCHEMA",
"connectionInfo":{
"bundleName":"com.h2database",
"bundleVersion":"1.4.200",
"password":"",
"connectionString":"jdbc:h2:/Users/elena/coldbox-examples/testApp/database/appDB;MODE=MySQL;DATABASE_TO_LOWER=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE;",
"class":"org.h2.Driver",
"username":""
},
"defaultGrammar":"AutoDiscover@qb"
}

I'm trying to init migration from command-box cli for my coldbox application.

has anyone ever had such a mistake?

Thank you,
Elena.


Bruno Oliveira

unread,
Jul 4, 2021, 12:50:07 PM7/4/21
to H2 Database
Hello! Is your project on github? Could I take a look at it?

Elena Aralla

unread,
Jul 4, 2021, 2:10:08 PM7/4/21
to h2-da...@googlegroups.com
Hi, 
My project ins’t on GitHub. 

I’ll move it on Github tomorrow morning (Italian time)

I will notify you as soon as possible!
Thank you.




--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/_fxv8ffgdBQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/74eb88da-949b-4861-a853-88513f81a1a3n%40googlegroups.com.

Elena Aralla

unread,
Jul 5, 2021, 1:04:10 PM7/5/21
to H2 Database
Hi,

my test project in on github now!

Thank you!

Elena Aralla

unread,
Jul 5, 2021, 1:05:11 PM7/5/21
to H2 Database
this is the url of test application:


thank you!

Il giorno domenica 4 luglio 2021 alle 20:10:08 UTC+2 Elena Aralla ha scritto:
Reply all
Reply to author
Forward
0 new messages