So, nun zum Fazit:

Fakturama 2.0.1 läuft nun seither auf seinem neuen RasPi Zuhause ohne weitere Probleme.
Nur war die Installation nicht auf jeder Himbeere so einfach möglich, obwohl das Grundsetup immer das selbe ist... :S

Auch der Import aus v1.9.6 war interessanter Weise ohne besonders große Probleme möglich.
Der Installer von v.2.0.1 hat die "com.sebulli.fakturama.rcp.prefs" allerdings fehlerhaft angelegt, so dass ich sie vor der Datenübernahme noch in folgende Form bringen musste:

GENERAL_WORKSPACE_REQUEST=pathtoFakt2
MIGRATE_OLD_DATA=pathtoFakt1.6.9
OLD_JDBC_URL=jdbc:hsqldb:hsql://localhost/fakturama
eclipse.preferences.version=1
javax.persistence.jdbc.driver=com.mysql.jdbc.Driver
javax.persistence.jdbc.password=PASSWORT
javax.persistence.jdbc.url=jdbc:mysql://IP-ADRESSE/fakturama
javax.persistence.jdbc.user=fakturama
jdbc_reconnect=true

Alles andere hatte keinen Erfolg (selbst die Portangabe hat ihn gestört ::o).

Fazit vom Fazit:
Den Installations-/Import Assistenten links liegen lassen und das ganze von Hand vorbereiten.
Geht schneller und sauberer (zumindest bei Kubuntu 16.04)

In diesem Sinne noch einen schönen Feiertag (Happy Cadaver)
Andrée

Hallo Andrée,
das finde ich aber sehr merkwürdig. Bei mir hat es in allen erdenklichen Konstellationen immer mit dem Assistenten geklappt, nicht nur aus der Entwicklungsumgebung heraus. Der Installer selber legt eigentlich nur die Programmdateien in den Programmpfad. Die Einstellungsdateien werden erst beim ersten Start von Fakturama erzeugt. Wenn da nichts da ist, gibt's auch den Migrationsdialog, ansonsten wird das alles übersprungen. In der pref-Datei etwas zuändern ist etwas heikel, weil man da ziemlich schnell etwas kaputt machen kann. Aber wenn's jetzt läuft ist es ja ok 🙂

Hier nochmal ein kleiner Nachtrag, warum der Konfigurationsassistent (bei mir) nicht funktioniert:

Passwort und DB_Url werden mit Assistent in folgender Form gespeichert:

javax.persistence.jdbc.password=HIER_STEHT_MEIN_PASSWORT
javax.persistence.jdbc.url=jdbc:mysql://HIER_DIE_IP/HIER_DER_DBNAME

Funktionieren tut es allerdings nur mit den Einträgen der Form:

javax.persistence.jdbc.password=HIER_STEHT_MEIN_PASSWORT
javax.persistence.jdbc.url=jdbc:mysql://HIER_DIE_IP/HIER_DER_DBNAME

Sprich: da haben sich irgendwie fiese, gemeine Backslashes eingemogelt, die zugegebener Maßen auch sooo garnicht im Assistenten auftauchen...

Und dann klappts auch mit dem Nachbarn Verbindungsaufbau! 😉

Gruß Andrée

Hallo Andrée,
das ist wirklich seltsam. Die Datei wird direkt von der Laufzeitumgebung geschrieben, das kann ich gar nicht beeinflussen. Ich habe gerade mal bei mir nachgesehen, da stehen vor den Doppelpunkten auch Backslashes. Das funktioniert komischerweise aber so. Ich hab das aber auch auf einem Windows-System laufen. Ich schau nochmal nach, wie das auf'm Mac oder unter Linux aussieht.

Hallo Andrée,

die Backslashes im URL Pfad werden unter Linux auch so gespeichert.

javax.persistence.jdbc.url=jdbc:mysql://DB_URL

Allerdings nicht beim Passwort. Beginnt dein Passwort vielleicht mit einem Sonderzeichen?
Dann stellt sich natürlich noch die Frage, warum es beim Einlesen dann nicht "demaskiert" wird.

Gruß
moped

Ich kann es euch auch nicht nicht stellvertretend für alle Linux Distributionen sagen...
Z.Z. nutze ich noch (K)ubuntu 16.04 LTS und selbstverständlich keine Sonderzeichen am Passwortanfang.

Besonders problematisch wird es wenn z.B. der Datenbankname Lerzeichen enthält. Hier wird, wie moped ja richtig schreibt, insb. in LX-Systemen eine Maskierung mit erfordelich.
- Hab ich schon versucht!
- Lösung: EINFACH KEINE LEERZEICHEN VERWENDEN!!!

Gruß Andrée

Hei,

ich hatte dasselbe Problem. Meine Lösung war, die Kollation meiner Datenbank in utf8_bin zu ändern und die Tabellen neu erstellen zu lassen.

Danach hat alles einwandfrei funktioniert.

Moin,

ich versuche auch gerade, Fakturama in einer Windows-Umgebung auf eine SQL-Datenbank (MariaDB) umzuziehen. Die Datenbankverbindung an sich klappt auch, nur scheitere ich gerade daran, die Datenbankinhalte mittels dem Script wie hier beschrieben umzuziehen.

Ich gehe davon aus, dass ich die Pfade in den migration(x).grf-Dateien falsch gesetzt hab' - momentan sehen sie exemplarisch so aus:

Das bisherige Fakturama-Datenverzeichnis und die Datenbank liegen auf dem Netzlaufwerk I:Fakturama

Die Anleitung sagt: (Für Windows-Nutzer: Der Pfad ist mit Backslash "" anzugeben, wie gewohnt.) Muss der Pfad direkt auf die Datenbankdatei oder nur auf das Datenbank-Verzeichnis zeigen? Im Ordner Database gibt es keinen weiteren Ordner Database - zumindest in meiner Datenstruktur...

Irgendwie steh' ich grade auf dem Schlauch - könnte mich jemand erleuchten?

Tausend Dank!
MOS

Hallo MOS,
versuch mal das hier:

dbURL="jdbc:hsqldb:file:I:FakturamaDatabaseDatabase"

Hallo Ralf,

vielen Dank für deine Antwort - leider keine Besserung.
Ich habe den Konsolenoutput mal hineingepasted - kannst du was damit anfangen?

Vielen Dank und Grüße,
Daniel

C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAK>binclover.bat migration.gr
f
CLOVER_HOME=C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin...
CLOVER_CMD_LINE_ARGS=migration.grf
JAVA_CMD_LINE_ARGS=
USER_CLASSPATH=
"java.exe" -classpath ";;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAK
bin;;;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/annotat
ions.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/aws-j
ava-sdk-core-1.11.75.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKi
n.../lib/aws-java-sdk-kms-1.11.75.jar;C:UsersDWeberDesktopfakturama_sqlHS
QL2MYSQL4FAKin.../lib/aws-java-sdk-LICENSE.txt;C:UsersDWeberDesktopfaktu
rama_sqlHSQL2MYSQL4FAKin.../lib/aws-java-sdk-s3-1.11.75.jar;C:UsersDWeber
Desktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/cloveretl.engine.jar;C:Users
DWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/cloveretl.engine.src.z
ip;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/commons-cli
-1.2.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/commo
ns-codec-1.10.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../
lib/commons-collections-3.2.2.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYS
QL4FAKin.../lib/commons-collections4-4.1.jar;C:UsersDWeberDesktopfaktura
ma_sqlHSQL2MYSQL4FAKin.../lib/commons-compress-1.7.jar;C:UsersDWeberDesk
topfakturama_sqlHSQL2MYSQL4FAKin.../lib/commons-configuration-1.10.jar;C:
UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/commons-io-2.2.ja
r;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/commons-lang
-2.6.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/commo
ns-lang3-3.4.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../l
ib/commons-LICENSE.txt;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin
.../lib/commons-logging-1.2.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQ
L4FAKin.../lib/commons-net-3.3.jar;C:UsersDWeberDesktopfakturama_sqlHSQ
L2MYSQL4FAKin.../lib/commons-pool-1.6.jar;C:UsersDWeberDesktopfakturama_
sqlHSQL2MYSQL4FAKin.../lib/dom4j-1.6.1.jar;C:UsersDWeberDesktopfakturam
a_sqlHSQL2MYSQL4FAKin.../lib/ftp4j-1.7.2.jar;C:UsersDWeberDesktopfaktur
ama_sqlHSQL2MYSQL4FAKin.../lib/ftp4j-LICENSE.txt;C:UsersDWeberDesktopfa
kturama_sqlHSQL2MYSQL4FAKin.../lib/httpclient-4.5.2.jar;C:UsersDWeberDes
ktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/httpclient-LICENSE.txt;C:UsersD
WeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/httpcore-4.4.4.jar;C:Us
ersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/httpcore-LICENSE.tx
t;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/httpmime-4.5
.2.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/httpmim
e-LICENSE.txt;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/
icu4j-52_1.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib
/icu4j-LICENSE.html;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin..
./lib/icu4j-unicode-LICENSE.txt;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL
4FAKin.../lib/jackson-annotations-2.5.3.jar;C:UsersDWeberDesktopfakturam
a_sqlHSQL2MYSQL4FAKin.../lib/jackson-core-2.5.3.jar;C:UsersDWeberDesktop
fakturama_sqlHSQL2MYSQL4FAKin.../lib/jackson-databind-2.5.3.jar;C:UsersD
WeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/javolution.jar;C:Users
DWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/jaxen-1.1.6.jar;C:User
sDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/jcifs-1.3.17.jar;C:U
sersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/jms.jar;C:UsersD
WeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/joda-time-2.8.1.jar;C:U
sersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/jsch-0.1.54.jar;C:
UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/jxl.jar;C:Users
DWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/log4j-1.2.17.jar;C:Us
ersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/lz4-1.3.0.jar;C:Us
ersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/poi-3.12-20150511.j
ar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/poi-ooxml-3
.12-20150511.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../l
ib/poi-ooxml-schemas-3.12-20150511.jar;C:UsersDWeberDesktopfakturama_sqlHSQ
L2MYSQL4FAKin.../lib/sardine-5.0.2.jar;C:UsersDWeberDesktopfakturama_sql
HSQL2MYSQL4FAKin.../lib/signpost-commonshttp4-1.2.1.2.jar;C:UsersDWeberD
esktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/signpost-core-1.2.1.2.jar;C:Us
ersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/slf4j-api-1.7.2.jar
;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/slf4j-log4j12
-1.7.2.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/tru
ezip-driver-file-7.7.5.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAK
bin.../lib/truezip-driver-zip-7.7.5.jar;C:UsersDWeberDesktopfakturama_sql
HSQL2MYSQL4FAKin.../lib/truezip-file-7.7.5.jar;C:UsersDWeberDesktopfaktu
rama_sqlHSQL2MYSQL4FAKin.../lib/truezip-kernel-7.7.5.jar;C:UsersDWeberDe
sktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/truezip-path-7.7.5.jar;C:Users
DWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/truezip-swing-7.7.5.jar
;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin.../lib/xmlbeans-2.5.
0-modified-for-WSC.jar;C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin
.../lib/XmlSchema-1.4.7-modified-for-WSC.jar;C:UsersDWeberDesktopfakturama_
sqlHSQL2MYSQL4FAKin.../lib/XmlSchema-LICENSE.txt" "-Dclover.home=C:UsersD
WeberDesktopfakturama_sqlHSQL2MYSQL4FAKin..." org.jetel.main.runGraph -pl
ugins "C:UsersDWeberDesktopfakturama_sqlHSQL2MYSQL4FAKin...plugins" mi
gration.grf
INFO [main] - CloverETL, (c) 2002-2017 Javlin a.s.
INFO [main] - Running with CloverETL version 4.7.0 build#010 compiled 10/10/201
7 12:07:19
INFO [main] - Running on 4 CPU(s), OS Windows 7, architecture amd64, max availa
ble memory for JVM 6.285.312 KB
INFO [main] - Running on Java(TM) SE Runtime Environment, 10.0.1, Oracle Corpor
ation (JRE - runtime compilation is not available!)
INFO [main] - Loading default properties from: defaultProperties
DEBUG [main] - Plugin org.jetel.connection loaded.
id - org.jetel.connection
version - 4.7.0
provider-name - Javlin a.s.
connection { className = org.jetel.connection.jdbc.DBConnectionI
mpl; type = JDBC; }
connection { className = org.jetel.connection.jms.JmsConnection;
type = JMS; }

DEBUG [main] - Plugin org.jetel.ctlfunction loaded.
id - org.jetel.ctlfunction
version - 4.7.0
provider-name - Javlin a.s.
ctlfunction { libraryName = math; className = org.jetel.ctl.exte
nsions.MathLib; }
ctlfunction { libraryName = date; className = org.jetel.ctl.exte
nsions.DateLib; }
ctlfunction { libraryName = string; className = org.jetel.ctl.ex
tensions.StringLib; }
ctlfunction { libraryName = convert; className = org.jetel.ctl.e
xtensions.ConvertLib; }
ctlfunction { libraryName = container; className = org.jetel.ctl
.extensions.ContainerLib; }
ctlfunction { libraryName = random; className = org.jetel.ctl.ex
tensions.RandomLib; }
ctlfunction { libraryName = util; className = org.jetel.ctl.exte
nsions.UtilLib; }
ctlfunction { libraryName = dynamic; className = org.jetel.ctl.e
xtensions.DynamicLib; }
ctlfunction { libraryName = string; className = org.jetel.ctl.ex
tensions.StringLibExt; }
ctlfunction { libraryName = mapping; className = org.jetel.ctl.e
xtensions.MappingLib; }
ctlfunction { libraryName = dynamic; className = org.jetel.ctl.e
xtensions.DynamicLibExt; }

DEBUG [main] - Plugin org.jetel.engine loaded.
id - org.jetel.engine
version - 4.7.0
provider-name - Javlin a.s.
dictionaryType { className = org.jetel.graph.dictionary.StringDi
ctionaryType; type = string; }
dictionaryType { className = org.jetel.graph.dictionary.ObjectDi
ctionaryType; type = object; }
dictionaryType { className = org.jetel.graph.dictionary.Readable
ChannelDictionaryType; type = readable.channel; }
dictionaryType { className = org.jetel.graph.dictionary.Writable
ChannelDictionaryType; type = writable.channel; }
dictionaryType { className = org.jetel.graph.dictionary.IntegerD
ictionaryType; type = integer; }
dictionaryType { className = org.jetel.graph.dictionary.LongDict
ionaryType; type = long; }
dictionaryType { className = org.jetel.graph.dictionary.DecimalD
ictionaryType; type = decimal; }
dictionaryType { className = org.jetel.graph.dictionary.NumberDi
ctionaryType; type = number; }
dictionaryType { className = org.jetel.graph.dictionary.DateDict
ionaryType; type = date; }
dictionaryType { className = org.jetel.graph.dictionary.BooleanD
ictionaryType; type = boolean; }
dictionaryType { className = org.jetel.graph.dictionary.ByteDict
ionaryType; type = byte; }
dictionaryType { className = org.jetel.graph.dictionary.ListDict
ionaryType; type = list; }
dictionaryType { className = org.jetel.graph.dictionary.MapDicti
onaryType; type = map; }
tlCompiler { className = org.jetel.ctl.TLCompiler; type = simple
.compiler; }
ctlfunction { libraryName = record; className = org.jetel.ctl.ex
tensions.IntegralLib; }
urlResolver { className = org.jetel.util.file.SMBPathResolver; t
ype = SMB; }
urlResolver { className = org.jetel.util.protocols.amazon.S3Path
Resolver; type = S3; }
authorityProxy { className = org.jetel.graph.runtime.PrimitiveAu
thorityProxy; type = PrimitiveAuthorityProxy; priority = 0; }

DEBUG [main] - Plugin org.jetel.jdbc loaded.
id - org.jetel.jdbc
version - 4.8.0.
provider-name - Javlin a.s.
jdbcSpecific { database = GENERIC; name = Generic; class = org.j
etel.connection.jdbc.specific.impl.DefaultJdbcSpecific; }
jdbcSpecific { database = HSQLDB; name = HSQLDB; class = org.jet
el.connection.jdbc.specific.impl.DefaultJdbcSpecific; }
jdbcSpecific { database = REDSHIFT; name = Amazon Redshift; clas
s = org.jetel.connection.jdbc.specific.impl.RedshiftSpecific; }
jdbcSpecific { database = DB2; name = DB2; class = org.jetel.con
nection.jdbc.specific.impl.DB2Specific; }
jdbcSpecific { database = DERBY; name = Derby; class = org.jetel
.connection.jdbc.specific.impl.DerbySpecific; productName = Apache Derby; }
jdbcSpecific { database = EXASOLUTION; name = EXASolution; class
= org.jetel.connection.jdbc.specific.impl.ExasolSpecific; }
jdbcSpecific { database = FIREBIRD; name = Firebird; class = org
.jetel.connection.jdbc.specific.impl.FirebirdSpecific; }
jdbcSpecific { database = GENERICODBC; name = Generic ODBC; clas
s = org.jetel.connection.jdbc.specific.impl.GenericODBCSpecific; }
jdbcSpecific { database = HIVE; name = Hive; class = org.jetel.c
onnection.jdbc.specific.impl.HiveSpecific; }
jdbcSpecific { database = INFORMIX; name = Informix; class = org
.jetel.connection.jdbc.specific.impl.InformixSpecific; }
jdbcSpecific { database = MSACCESS; name = Microsoft Access ODBC
; class = org.jetel.connection.jdbc.specific.impl.MSAccessSpecific; }
jdbcSpecific { database = MSACCESSJAVA; name = Microsoft Access;
class = org.jetel.connection.jdbc.specific.impl.MSAccessPureJavaSpecific; }
jdbcSpecific { database = MSSQL; name = MS SQL Server 2008-2012;
class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific; productName = Mi
crosoft SQL Server; }
jdbcSpecific { database = MSSQL2005; name = MS SQL Server 2000-2
005; class = org.jetel.connection.jdbc.specific.impl.MSSQLSpecific2005; }
jdbcSpecific { database = MYSQL; name = MySQL; class = org.jetel
.connection.jdbc.specific.impl.MySQLSpecific; productName = MySQL; }
jdbcSpecific { database = ORACLE; name = Oracle; class = org.jet
el.connection.jdbc.specific.impl.OracleSpecific; productName = Oracle; }
jdbcSpecific { database = PERVASIVE; name = Pervasive; class = o
rg.jetel.connection.jdbc.specific.impl.PervasiveSpecific; }
jdbcSpecific { database = POSTGRE; name = PostgreSQL; class = or
g.jetel.connection.jdbc.specific.impl.PostgreSpecific; }
jdbcSpecific { database = SYBASE; name = Sybase; class = org.jet
el.connection.jdbc.specific.impl.SybaseSpecific; }
jdbcSpecific { database = SQLITE; name = SQLite; class = org.jet
el.connection.jdbc.specific.impl.SQLiteSpecific; }
jdbcSpecific { database = VERTICA; name = Vertica; class = org.j
etel.connection.jdbc.specific.impl.VerticaSpecific; }
jdbcDriver { database = MYSQL; urlHint = jdbc:mysql://hostname:3
306/database; jdbc.zeroDateTimeBehavior = convertToNull; name = MySQL; driverLib
rary = lib/mysql/mysql-connector-java-5.1.26-bin.jar; jdbcSpecific = MYSQL; dbDr
iver = org.gjt.mm.mysql.Driver; }
jdbcDriver { database = HSQLDB; urlHint = jdbc:hsqldb:hsql://hos
tname:9001/database; jdbc.zeroDateTimeBehavior = convertToNull; name = HSQLDB; d
riverLibrary = lib/hsqldb/hsqldb.jar; jdbcSpecific = HSQLDB; dbDriver = org.hsql
db.jdbc.JDBCDriver; }
jdbcDriver { database = ORACLE; urlHint = jdbc:***@cluster-alias
:1521/service_name,jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PRO
TOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)
)(CONNECT_DATA=(SERVICE_NAME=service_name))),jdbc:oracle:thin:@(DESCRIPTION=(ADD
RESS=(PROTOCOL=TCP)(HOST=cluster_alias)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=s
ervice_name))),jdbc:oracle:thin:@host:1521/service_name; name = Oracle; driverLi
brary = lib/oracle/ojdbc6.jar; jdbcSpecific = ORACLE; dbDriver = oracle.jdbc.Ora
cleDriver; }
jdbcDriver { database = POSTGRE; urlHint = jdbc:postgresql://hos
tname/database; name = PostgreSQL; driverLibrary = lib/postgre/postgresql-9.3-11
02.jdbc41.jar; jdbcSpecific = POSTGRE; dbDriver = org.postgresql.Driver; }
jdbcDriver { database = REDSHIFT; urlHint = jdbc:redshift://clus
ter_id.redshift.amazonaws.com:5439/database; name = Amazon Redshift; driverLibra
ry = lib/redshift/RedshiftJDBC41-1.1.17.1017.jar; jdbcSpecific = REDSHIFT; dbDri
ver = com.amazon.redshift.jdbc41.Driver; }
jdbcDriver { database = MSSQL; urlHint = jdbc:jtds:sqlserver://h
ostname:1433/database;instance=instanceName,jdbc:jtds:sqlserver://hostname:1433/
database; name = Microsoft SQL Server; driverLibrary = lib/jtds/jtds-1.2.8.jar;
jdbcSpecific = MSSQL; dbDriver = net.sourceforge.jtds.jdbc.Driver; }
jdbcDriver { database = GENERICODBC; urlHint = jdbc:odbc:dsn_sou
rce;; name = Generic ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpe
cific = GENERICODBC; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; }
jdbcDriver { database = MSACCESS; urlHint = jdbc:odbc:driver={Mi
crosoft Access Driver (*.mdb)};DBQ=database_file,jdbc:odbc:driver={Microsoft Acc
ess Driver (*.mdb, *.accdb)};DBQ=database_file,jdbc:odbc:odbc_source_name; name
= Microsoft Access ODBC; driverLibrary = sun.jdbc.odbc.JdbcOdbcDriver; jdbcSpeci
fic = MSACCESS; dbDriver = sun.jdbc.odbc.JdbcOdbcDriver; }
jdbcDriver { database = MSACCESSJAVA; urlHint = jdbc:ucanaccess:
//database_file,jdbc:ucanaccess://database_file;newdatabaseversion=V2010; name =
Microsoft Access; driverLibrary = lib/msaccess/ucanaccess-4.0.2.jar;lib/msacces
s/jackcess-2.1.6.jar;lib/msaccess/hsqldb.jar; jdbcSpecific = MSACCESSJAVA; dbDri
ver = net.ucanaccess.jdbc.UcanaccessDriver; }
jdbcDriver { database = SYBASE; urlHint = jdbc:jtds:sybase://hos
tname:7100/database; name = Sybase; driverLibrary = lib/jtds/jtds-1.2.8.jar; jdb
cSpecific = SYBASE; dbDriver = net.sourceforge.jtds.jdbc.Driver; }
jdbcDriver { database = SQLITE; urlHint = jdbc:sqlite:C:/databas
e; name = SQLite; driverLibrary = lib/sqlite/sqlite-jdbc-3.6.20.1.jar; jdbcSpeci
fic = SQLITE; dbDriver = org.sqlite.JDBC; }
jdbcDriver { database = DERBY; urlHint = jdbc:derby://hostname:1
527/derby.db; name = Derby; driverLibrary = lib/derby/derbyclient-10.11.1.1.jar;
jdbcSpecific = DERBY; dbDriver = org.apache.derby.jdbc.ClientDriver; }
jdbcDriver { database = FIREBIRD; urlHint = jdbc:firebirdsql:loc
alhost/3050:/firebird/test.gdb; name = Firebird; driverLibrary = lib/firebird/ja
ybird-full-2.2.1.jar; jdbcSpecific = FIREBIRD; dbDriver = org.firebirdsql.jdbc.F
BDriver; }
jdbcDriver { database = VERTICA70; urlHint = jdbc:vertica://host
name:5433/database; name = Vertica 7.0; driverLibrary = lib/vertica/vertica-jdbc
-7.0.2-1.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; }
jdbcDriver { database = VERTICA71; urlHint = jdbc:vertica://host
name:5433/database; name = Vertica 7.1; driverLibrary = lib/vertica/vertica-jdbc
-7.1.1-0.jar; jdbcSpecific = VERTICA; dbDriver = com.vertica.jdbc.Driver; }

DEBUG [main] - Plugin org.jetel.lookup loaded.
id - org.jetel.lookup
version - 4.7.0
provider-name - Javlin a.s.
lookup { className = org.jetel.lookup.SimpleLookupTable; type =
simpleLookup; }
lookup { className = org.jetel.lookup.DBLookupTable; type = dbLo
okup; }
lookup { className = org.jetel.lookup.RangeLookupTable; type = r
angeLookup; }

DEBUG [main] - Plugin org.jetel.sequence loaded.
id - org.jetel.sequence
version - 4.7.0
provider-name - Javlin a.s.
sequence { className = org.jetel.sequence.SimpleSequence; type =
SIMPLE_SEQUENCE; }
sequence { className = org.jetel.sequence.PrimitiveSequence; typ
e = PRIMITIVE_SEQUENCE; }

DEBUG [main] - Plugin org.jetel.component loaded.
id - org.jetel.component
version - 4.7.0
provider-name - Javlin a.s.
component { className = org.jetel.component.DataReader; name = U
niversalDataReader; type = DATA_READER; }
component { className = org.jetel.component.DataWriter; name = U
niversalDataWriter; type = DATA_WRITER; }
component { className = org.jetel.component.DataReader; name = F
latFileReader; type = FLAT_FILE_READER; }
component { className = org.jetel.component.DataWriter; name = F
latFileWriter; type = FLAT_FILE_WRITER; }
component { className = org.jetel.component.DelimitedDataReader;
name = DelimitedDataReader; type = DELIMITED_DATA_READER; }
component { className = org.jetel.component.DelimitedDataWriter;
name = DelimitedDataWriter; type = DELIMITED_DATA_WRITER; }
component { className = org.jetel.component.SimpleCopy; name = S
impleCopy; type = SIMPLE_COPY; }
component { className = org.jetel.component.Concatenate; name =
Concatenate; type = CONCATENATE; }
component { className = org.jetel.component.SimpleGather; name =
SimpleGather; type = SIMPLE_GATHER; }
component { className = org.jetel.component.Reformat; name = Ref
ormat; type = REFORMAT; }
component { className = org.jetel.component.DBInputTable; name =
DBInputTable; type = DB_INPUT_TABLE; }
component { className = org.jetel.component.Sort; name = Sort; t
ype = SORT; }
component { className = org.jetel.component.DBOutputTable; name
= DBOutputTable; type = DB_OUTPUT_TABLE; }
component { className = org.jetel.component.FixLenDataWriter; na
me = FixLenDataWriter; type = FIXLEN_DATA_WRITER; }
component { className = org.jetel.component.Dedup; name = Dedup;
type = DEDUP; }
component { className = org.jetel.component.FixLenDataReader; na
me = FixLenDataReader; type = FIXLEN_DATA_READER; }
component { className = org.jetel.component.Merge; name = Merge;
type = MERGE; }
component { className = org.jetel.component.CrossJoin; name = Cr
ossJoin; type = CROSS_JOIN; }
component { className = org.jetel.component.MergeJoin; name = Me
rgeJoin; type = MERGE_JOIN; }
component { className = org.jetel.component.MergeJoin; name = Ex
tMergeJoin; type = EXT_MERGE_JOIN; }
component { className = org.jetel.component.MergeJoin; type = SO
RTED_JOIN; }
component { className = org.jetel.component.Trash; name = Trash;
type = TRASH; }
component { className = org.jetel.component.Trashifier; type = T
RASHIFIER; }
component { className = org.jetel.component.DBExecute; name = DB
Execute; type = DB_EXECUTE; }
component { className = org.jetel.component.HashJoin; name = Has
hJoin; type = HASH_JOIN; }
component { className = org.jetel.component.HashJoin; name = Ext
HashJoin; type = EXT_HASH_JOIN; }
component { className = org.jetel.component.CheckForeignKey; nam
e = CheckForeignKey; type = CHECK_FOREIGN_KEY; }
component { className = org.jetel.component.DBFDataReader; name
= DBFDataReader; type = DBF_DATA_READER; }
component { className = org.jetel.component.DBFDataWriter; name
= DBFDataWriter; type = DBF_DATA_WRITER; }
component { className = org.jetel.component.ExtFilter; name = Fi
lter; type = EXT_FILTER; }
component { className = org.jetel.component.ExtSort; name = ExtS
ort; type = EXT_SORT; }
component { className = org.jetel.component.SortWithinGroups; na
me = SortWithinGroups; type = SORT_WITHIN_GROUPS; }
component { className = org.jetel.component.Partition; name = Pa
rtition; type = PARTITION; }
component { className = org.jetel.component.DataIntersection; na
me = DataIntersection; type = DATA_INTERSECTION; }
component { className = org.jetel.component.Aggregate; name = Ag
gregate; type = AGGREGATE; }
component { className = org.jetel.component.SystemExecute; name
= SystemExecute; type = SYS_EXECUTE; }
component { className = org.jetel.component.RunGraph; name = Run
Graph; type = RUN_GRAPH; }
component { className = org.jetel.component.HttpConnector; name
= HTTPConnector; type = HTTP_CONNECTOR; }
component { className = org.jetel.component.KeyGenerator; name =
KeyGenerator; type = KEY_GEN; }
component { className = org.jetel.component.AproxMergeJoin; name
= ApproximativeJoin; type = APROX_MERGE_JOIN; }
component { className = org.jetel.component.DBJoin; name = DBJoi
n; type = DBJOIN; }
component { className = org.jetel.component.XLSReader; name = XL
SDataReader; type = XLS_READER; }
component { className = org.jetel.component.XLSWriter; name = XL
SDataWriter; type = XLS_WRITER; }
component { className = org.jetel.component.CloverDataWriter; na
me = CloverDataWriter; type = CLOVER_WRITER; }
component { className = org.jetel.component.CloverDataReader; na
me = CloverDataReader; type = CLOVER_READER; }
component { className = org.jetel.component.StructureWriter; nam
e = StructuredDataWriter; type = STRUCTURE_WRITER; }
component { className = org.jetel.component.Normalizer; name = N
ormalizer; type = NORMALIZER; }
component { className = org.jetel.component.Denormalizer; name =
Denormalizer; type = DENORMALIZER; }
component { className = org.jetel.component.Rollup; name = Rollu
p; type = ROLLUP; }
component { className = org.jetel.component.JmsReader; name = JM
SReader; type = JMS_READER; }
component { className = org.jetel.component.JmsWriter; name = JM
SWriter; type = JMS_WRITER; }
component { className = org.jetel.component.LookupJoin; name = L
ookupJoin; type = LOOKUP_JOIN; }
component { className = org.jetel.component.LookupTableReaderWri
ter; name = LookupTableReaderWriter; type = LOOKUP_TABLE_READER_WRITER; }
component { className = org.jetel.component.DataGenerator; name
= DataGenerator; type = DATA_GENERATOR; }
component { className = org.jetel.component.SequenceChecker; nam
e = SequenceChecker; type = SEQUENCE_CHECKER; }
component { className = org.jetel.component.TextTableWriter; typ
e = TEXT_TABLE_WRITER; }
component { className = org.jetel.component.XmlXPathReader; name
= XMLXPathReader; type = XML_XPATH_READER; }
component { className = org.jetel.component.XMLExtract; name = X
MLExtract; type = XML_EXTRACT; }
component { className = org.jetel.component.JsonExtract; name =
JSONExtract; type = JSON_EXTRACT; }
component { className = org.jetel.component.XmlReader; name = XM
LReader; type = XML_READER; }
component { className = org.jetel.component.SpeedLimiter; name =
SpeedLimiter; type = SPEED_LIMITER; }
component { className = org.jetel.component.SpeedLimiter; name =
Sleep; type = SLEEP; }
component { className = org.jetel.component.JavaExecute; name =
JavaExecute; type = JAVA_EXECUTE; }
component { className = org.jetel.component.GenericComponent; na
me = CustomJavaReader; type = GENERIC_READER; }
component { className = org.jetel.component.GenericComponent; na
me = CustomJavaWriter; type = GENERIC_WRITER; }
component { className = org.jetel.component.GenericComponent; na
me = CustomJavaTransformer; type = GENERIC_TRANSFORMER; }
component { className = org.jetel.component.GenericComponent; na
me = CustomJavaComponent; type = GENERIC_COMPONENT; }
component { className = org.jetel.component.XmlWriter; name = XM
LWriter (deprecated); type = XML_WRITER; }
component { className = org.jetel.component.ExtXmlWriter; name =
XMLWriter; type = EXT_XML_WRITER; }
component { className = org.jetel.component.XSLDataTransformer;
name = XSLTransformer; type = XSL_TRANSFORMER; }
metadata { id = UniversalDataReader_Error; }
metadata { id = HTTPConnector_Request; }
metadata { id = HTTPConnector_Response; }
metadata { id = HTTPConnector_Error; }
metadata { id = RunGraph_Input; }
metadata { id = RunGraph_Output; }

DEBUG [main] - Plugin org.jetel.bulkloader loaded.
id - org.jetel.bulkloader
version - 4.7.0
provider-name - Javlin a.s.
component { className = org.jetel.component.OracleDataWriter; na
me = OracleDataWriter; type = ORACLE_DATA_WRITER; }
component { className = org.jetel.component.DB2DataWriter; name
= DB2DataWriter; type = DB2_DATA_WRITER; }
component { className = org.jetel.component.InformixDataWriter;
name = InformixDataWriter; type = INFORMIX_DATA_WRITER; }
component { className = org.jetel.component.MsSqlDataWriter; nam
e = MSSQLDataWriter; type = MS_SQL_DATA_WRITER; }
component { className = org.jetel.component.MysqlDataWriter; nam
e = MySQLDataWriter; type = MYSQL_DATA_WRITER; }
component { className = org.jetel.component.PostgreSqlDataWriter
; name = PostgreSQLDataWriter; type = POSTGRESQL_DATA_WRITER; }
component { className = org.jetel.component.InfobrightDataWriter
; name = InfobrightDataWriter; type = INFOBRIGHT_DATA_WRITER; }

DEBUG [main] - Plugin org.jetel.hadoop loaded.
id - org.jetel.hadoop
version - 4.7.0
provider-name - Javlin a.s.
connection { className = org.jetel.hadoop.connection.HadoopConne
ction; type = HADOOP; }
component { className = org.jetel.hadoop.component.HadoopWriter;
name = HadoopWriter; type = HADOOP_WRITER; }
component { className = org.jetel.hadoop.component.HadoopReader;
name = HadoopReader; type = HADOOP_READER; }
urlResolver { className = org.jetel.hadoop.service.filesystem.Ha
doopPathResolver; type = HADOOP_HDFS; }

DEBUG [main] - Plugin org.jetel.smb2 loaded.
id - org.jetel.smb2
version - 4.7.0
provider-name - Javlin a.s.
urlResolver { className = org.jetel.util.protocols.smb2.SMB2Path
Resolver; type = SMB2; }

DEBUG [main] - Plugin com.cloveretl.tableau.TableauWriter loaded.
id - com.cloveretl.tableau.TableauWriter
version - 4.7.0
provider-name - Javlin, a.s.
component { className = com.cloveretl.tableau.TableauWriter; nam
e = TableauWriter; type = TABLEAU_WRITER; }

DEBUG [main] - Plugin org.jetel.thirdparty loaded.
id - org.jetel.thirdparty
version - 4.7.0
provider-name - Javlin a.s.
component { className = org.jetel.component.Filter; name = Filte
r; type = FILTER; }
component { className = com.linagora.component.LdapReader; name
= LDAPReader; type = LDAP_READER; }
component { className = com.linagora.component.LdapWriter; name
= LDAPWriter; type = LDAP_WRITER; }

Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/JAXBEx
ception
at org.jetel.component.ComponentFactory.init(ComponentFactory.java:71)
at org.jetel.plugin.Plugins.init(Plugins.java:178)
at org.jetel.plugin.Plugins.init(Plugins.java:147)
at org.jetel.plugin.Plugins.init(Plugins.java:98)
at org.jetel.graph.runtime.EngineInitializer.initEngine(EngineInitialize
r.java:74)
at org.jetel.main.runGraph.main(runGraph.java:346)
Caused by: java.lang.ClassNotFoundException: javax.xml.bind.JAXBException
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown So
urce)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(U
nknown Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
... 6 more

Hallo,
die JAXB-Klassen fehlen vermutlich. Welches Java hast Du installiert? Hast Du ein JDK oder ein JRE verwendet?

Hallo Ralf,

tatsächlich war's so - auf meinem Rechner läuft das JDK 8 Update 181 - auf einem anderen Rechner hat's dann funktioniert.

Vielen Dank für die schnelle Hilfe!
MOS

Hallo zusammen,

ich bin noch recht neu in der Fakturama Software unterwegs, einen Test Mandanten habe ich angelegt auf eine Maria DB und dieser funktioniert auch wunderbar.

Wenn ich jetzt das Arbeitsverzeichnis wechsel wird aber kein Datenbank wechsel vorgenommen sondern alle Daten in die bereits angelegte Datenbank geschrieben.

Ich fand den Gedanken recht Charmant darüber verschiedene Rechnungen für verschiedene Firmen zu schreiben.

Gibt die Möglichkeit bei wechsel des Arbeitsverzeichnisses auch auf eine andere Datenbank zuzugreifen?

Hallo!

Ich greife hier mal diesen Thread auf, da ich auch gerade versuche die Datenbank von hsqldb auf mysql zu bringen.
Mein Problem ist, dass die mysql Datenbank wohl eine Begrenzung von 65535 hat.
Die Datenbank wird erfolgreich erstellt. Und dann läuft ja der Skript, welcher die Groesse der Felder nochmal anpasst.
Und da erhalte ich den folgenden Fehler:

20191119 12:27:54.663 | ERROR | LOG | Change Set /changelog/db.changelog-2.0.xml::20180104-001::rheydenr (generated) failed. Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE `fakturama`.`FKT_PAYMENT` MODIFY `PAIDTEXT` VARCHAR(4096)]

Das ganze laeuft unter Windows und mysql unter XAMPP.
Weiss jemand ob man es anders konfigurieren kann?

Danke,
Leo

Moin Leo, hab den Thread irgendwie übersehen... Man kann das wohl im MySQL konfigurieren. Ich habe dazu diesen Thread gefunden: https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large. Kannst Du das mal ausprobieren? Ich habe's bei mir auch unter mySQL laufen, da hatte ich aber diese Probleme nicht.