Hello Mark, Here it is what we did in details:
1) Install plugin into C:\Firebird_Java\fbjava-1.0.0-alpha-1. 2) Create Environment Variable FBJAVA_ROOT= C:\Firebird_Java\fbjava-1.0.0-alpha-1 3) CD to C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example 4) call mvn clean package 5) Follow the instructions in C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\README. 6) Make sure all tests complete as described in README. Specifically, make sure that C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\db.log is present and contains data. Up to this point everything is fine. Next steps. 1) Modify C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\util\createdb.bat: @echo off setlocal set FB_BIN=%FIREBIRD% set FBJAVA_BIN=%FBJAVA_ROOT%\bin set THIS_DIR=%~dp0 pushd %THIS_DIR%.. set EXAMPLES_ROOT=%cd% popd set DB=%EXAMPLES_ROOT%\db.fdb REM Create an empty database. del %DB% echo create database '%EXAMPLES_ROOT%\db.fdb' default character set utf8; | %FB_BIN%\isql -u SYSDBA -q REM Create the metadata. %FB_BIN%\isql -u SYSDBA -q %DB% -i %THIS_DIR%\database.sql %FB_BIN%\isql -u SYSDBA -q %DB% -i %THIS_DIR%\code.sql 2) Run createdb.bat to produce new C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\DB.FDB 3) Copy C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\target\fbjava-example-1.0.0-alpha-1.jar to C:\Firebird_Java\fbjava-1.0.0-alpha-1\jar 4) Copy C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\target\dependency\logback-classic-1.1.3.jar to C:\Firebird_Java\fbjava-1.0.0-alpha-1\jar 5) Copy C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\target\dependency\logback-core-1.1.3.jar to C:\Firebird_Java\fbjava-1.0.0-alpha-1\jar 6) Copy C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\target\dependency\postgresql-8.3-603.jdbc4.jar to C:\Firebird_Java\fbjava-1.0.0-alpha-1\jar 7) Copy C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\target\dependency\slf4j-api-1.7.13.jar to C:\Firebird_Java\fbjava-1.0.0-alpha-1\jar 8) Run tests described in C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\README 9) Make sure all tests complete as described in README. Specifically, make sure that C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\db.log is present and contains data. Results: all tests complete successfully, but C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fbjava-example\db.log is missing. Please let me know if any additional information is required. Thanks, Vlad -----Original Message----- From: Mark Rotteveel <m...@lawinegevaar.nl> Sent: Friday, May 18, 2018 7:58 AM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] FBJava plugin issues On 16-5-2018 16:47, Chmakov, Vladimir wrote: > Hello Mark, > > Thank you for your reply! > > Yes, the documentation recommends placing JARs inside the DB, but the > "external" deployment better suits our software deployment policies. > My expectation would be that regardless of the JAR deployment model all JAR > components exposed onto the class path would be visible for the plugin. It > doesn't seem to be the case, as in the provided example it is obvious, that > logback.xml is being ignored or not visible when JAR deployed "externally". Could you please describe the exact layout of your deployment, which files are where? eg: is that logback.xml in a jar file in the <fbjava-root>/jar/ directory, or did you deploy it separately (which is not going to work)? > We also tried to push our own JARs into the DB, but ended up getting tons of > "PK violation" errors. Please describe in more detail what you did and what error you get. The fbjava plugin probably hasn't seen a lot of use, so unless you describe exactly what you did, it will be harder to replicate what you did and either point out what you did wrong, or what is wrong with the current plugin so it can be fixed. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
