Re: [h2] Make backup relative to the current location

['Christoph Läubrich' via H2 Database]

Thanks that works like a charm :-)

Am 14.05.21 um 11:42 schrieb Noel Grandin:



On 2021/05/13 8:07 pm, 'Christoph Läubrich' via H2 Database wrote:
I'm writing an upgrade script and like to make a backup from withing 
thatscript.


Is it possible to get the name of the current database location to use 
for something like this:




DATABASE_PATH() is the function you want:

http://h2database.com/html/functions.html#database_path





--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/4e090bea-269f-2f07-0126-72d5f654b517%40googlemail.com.

[h2] problem connecting to h2 database

[Elena Aralla]

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.


-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/d845b01a-91c4-4745-8edd-f37fefc67357n%40googlegroups.com.

Re: [h2] Make backup relative to the current location

[Noel Grandin]

On 2021/05/13 8:07 pm, 'Christoph Läubrich' via H2 Database wrote:

I'm writing an upgrade script and like to make a backup from withing that 
script.

Is it possible to get the name of the current database location to use for 
something like this:



DATABASE_PATH() is the function you want:

http://h2database.com/html/functions.html#database_path



--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/16273586-f095-5170-c4fb-099be0cf7759%40gmail.com.