{"id":657,"date":"2014-11-24T16:06:58","date_gmt":"2014-11-24T15:06:58","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=657"},"modified":"2015-01-27T16:30:33","modified_gmt":"2015-01-27T15:30:33","slug":"aqua-data-studio-15-0-11-running-in-pc-bsd-10-1","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=657","title":{"rendered":"Aqua Data Studio 15.0.11 running in PC-BSD 10.1"},"content":{"rendered":"

Know that kind of concerns? You bought really expensive license for great software…. changed operating system… and just rely that if it is written in Java, it can’t be problem to use it. Agreed.<\/p>\n

<\/p>\n

I’m far far for doing some advertisment – anyway I’m using AquaData Studio<\/a> for few years and I’m still excited by new features, community and developer’s approach (they are<\/strong> listening \ud83d\ude42 ). You can use this ultimate database tool (in a sense of wideness, not depth) for free for 14 days – if you are database fan, don’t hesitate. In Download section you can see packages for common platforms (Win,Mac,Linux). Indeed, we are running BSD system, which is not present (and dont wait for it \ud83d\ude00 ). Check „Other“<\/a> tab and download „JAVA Platform ENABLED OS – Compressed ZIP „.<\/p>\n

\"ads01\"<\/a><\/p>\n

Unzip file, datastudio directory appears. Don’t forget, that running script is written in bash in case you don‘ t want to rewrite it for csh (my default shell in system).
\n[crayon lang=“shell“]
\n[j@pcbsd-1433] ~% bash
\n[j@pcbsd-1433 ~]$ pwd
\n\/usr\/home\/j
\n[j@pcbsd-1433 ~]$ cd Downloads\/datastudio\/
\n[j@pcbsd-1433 ~\/Downloads\/datastudio]$ ls -la
\ntotal 151
\ndrwx\u2014\u2014 4 j j 31 Nov 24 15:51 .
\ndrwxr-xr-x 3 j j 5 Nov 24 15:51 ..
\n-rw-r\u2013r\u2013 1 j j 36675 Nov 13 14:03 License.txt
\n-rw-r\u2013r\u2013 1 j j 7758 Nov 13 14:03 datastudio-128\u00d7128.png
\n-rw-r\u2013r\u2013 1 j j 488 Nov 13 14:03 datastudio-16\u00d716.png
\n-rw-r\u2013r\u2013 1 j j 1077 Nov 13 14:03 datastudio-24\u00d724.png
\n-rw-r\u2013r\u2013 1 j j 1554 Nov 13 14:03 datastudio-32\u00d732.png
\n-rw-r\u2013r\u2013 1 j j 2513 Nov 13 14:03 datastudio-48\u00d748.png
\n-rw-r\u2013r\u2013 1 j j 1329 Nov 13 14:03 datastudio-bundled.bat
\n-rwxr-xr-x 1 j j 1466 Nov 19 16:26 datastudio-bundled.sh
\n-rw-r\u2013r\u2013 1 j j 9158 Nov 13 14:03 datastudio-compress.ico
\n-rw-r\u2013r\u2013 1 j j 9158 Nov 13 14:03 datastudio-image.ico
\n-rw-r\u2013r\u2013 1 j j 9158 Nov 13 14:03 datastudio-pdf.ico
\n-rw-r\u2013r\u2013 1 j j 9158 Nov 13 14:03 datastudio-sql.ico
\n-rw-r\u2013r\u2013 1 j j 9158 Nov 13 14:03 datastudio-studio.ico
\n-rw-r\u2013r\u2013 1 j j 1319 Nov 13 14:03 datastudio.bat
\n-rw-r\u2013r\u2013 1 j j 568 Nov 13 14:03 datastudio.gif
\n-rw-r\u2013r\u2013 1 j j 364726 Nov 13 14:03 datastudio.ico
\n-rw-r\u2013r\u2013 1 j j 1404 Nov 13 14:03 datastudio.sh
\n-rw-r\u2013r\u2013 1 j j 3967 Nov 13 14:03 krb5.ini.example
\ndrwx\u2014\u2014 25 j j 27 Nov 19 16:09 lib
\ndrwx\u2014\u2014 2 j j 36 Nov 19 16:09 license
\n-rw-r\u2013r\u2013 1 j j 1342 Nov 13 14:03 runfluidscript-bundled.bat
\n-rw-r\u2013r\u2013 1 j j 1411 Nov 13 14:03 runfluidscript-bundled.sh
\n-rw-r\u2013r\u2013 1 j j 1334 Nov 13 14:03 runfluidscript.bat
\n-rw-r\u2013r\u2013 1 j j 1393 Nov 13 14:03 runfluidscript.sh
\n-rw-r\u2013r\u2013 1 j j 1338 Nov 13 14:03 runscript-bundled.bat
\n-rw-r\u2013r\u2013 1 j j 1407 Nov 13 14:03 runscript-bundled.sh
\n-rw-r\u2013r\u2013 1 j j 1330 Nov 13 14:03 runscript.bat
\n-rw-r\u2013r\u2013 1 j j 1389 Nov 13 14:03 runscript.sh
\n[j@pcbsd-1433 ~\/Downloads\/datastudio]$<\/p>\n

[j@pcbsd-1433 ~\/Downloads\/datastudio]$ cat datastudio.sh
\n#!\/bin\/bash
\n#SET ADS_HOME to the root installation directory for DataStudio<\/p>\n

ADS_HOME=dirname $0<\/p>\n

CLASSES=$ADS_HOME\/lib\/ads.jar
\nCLASSES=$ADS_HOME\/lib\/aqua-lib.jar:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/antlr\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/apache\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/apple\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/aquafold\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/aspose\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/dnsjava\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/drivers\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/icepdf\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/infragistics\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/itext\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/java\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jgoodies\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jgraph\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jide\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jinterop\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jna\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/jogl\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/kryo\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/perforce\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/quartz\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/slf4j\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/snmp4j\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/ssh2\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/stndeditor\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/svnkit\/*:$CLASSES
\nCLASSES=$ADS_HOME\/lib\/thrift\/*:$CLASSES<\/p>\n

export LD_LIBRARY_PATH=$ADS_HOME:$ADS_HOME\/iany\/lib\/:$LD_LIBRARY_PATH<\/p>\n

java -Djsse.enableCBCProtection=false -Xmx756M -XX:MaxPermSize=192m -cp $CLASSES com.aquafold.datastudio.DataStudio
\n[\/crayon]<\/p>\n

In my case I’m changing just 2 lines – #!\/bin\/bash<\/span>\u00a0\u00a0 became #!\/usr\/local\/bin\/bash<\/span> (result of which bash<\/span> output). Second adjusting is about home ads directory = ADS_HOME=`dirname $0`<\/span> became ADS_HOME='\/usr\/home\/j\/Downloads\/datastudio'.<\/code><\/span><\/p>\n

And that’s all – we can now run DataStudio:
\n[crayon lang=“shell“]
\n[j@pcbsd-1433 ~\/Downloads\/datastudio]$ chmod +x datastudio.sh
\n[j@pcbsd-1433 ~\/Downloads\/datastudio]$ .\/datastudio.sh
\nOpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=192m; support was removed in 8.0
\n[\/crayon]
\nAll working now, nice antialiased fonts (half of linux distribution will fight with this for many years).<\/p>\n

Again – absolutely happy database user \ud83d\ude42<\/p>\n

\"ads02\"<\/a><\/p>\n

\"ads03\"<\/a><\/p>\n

\"all01\"<\/a><\/p>\n

-a-<\/p>\n

 <\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Know that kind of concerns? You bought really expensive license for great software…. changed operating system… and just rely that if it is written in Java, it can’t be problem to use it. Agreed.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,9],"tags":[],"_links":{"self":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/657"}],"collection":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=657"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/657\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}