Glassfish

https://glassfish.java.net/download.html
http://download.oracle.com/glassfish/4.1/promoted/index.html

# parameter
grep pass /etc/init.d/glassfish
ASADMINOPTS="--user admin --passwordfile /opt/glassfish/pass"

#  asadmin
http://docs.oracle.com/cd/E19798-01/821-1758/6nmnj7pso/index.html
/opt/glassfish/bin/asadmin --user admin --passwordfile /opt/glassfish/conf/pass list-jvm-options | grep Dcom.sun.management.jmxremote.port
/opt/glassfish/bin/asadmin --user admin --passwordfile /opt/glassfish/conf/pass create-jvm-options -Dcom.sun.management.jmxremote.port=1234
/opt/glassfish/bin/asadmin --user admin --passwordfile /opt/glassfish/conf/pass delete-jvm-options -Dcom.sun.management.jmxremote.port=1234
/opt/glassfish/bin/asadmin --user admin --passwordfile /opt/glassfish/conf/pass list-applications

asadmin list-applications
asadmin list-applications customer-service-instance

# show system properties
list-system-properties

 get
/opt/glassfish/bin/asadmin --user admin --passwordfile /opt/glassfish/conf/pass get secure-admin.enabled

# remote
ssh foo@glassfish.example.com -t "bash -ic 'asadmin list-instances'"

# logs
tail -f /opt/glassfish/domains/domain1/logs/*.log

Alternatives
http://www.payara.fish/

Install SQL developer

VSCode addon
https://marketplace.visualstudio.com/items?itemName=Oracle.sql-developer

code --install-extension Oracle.sql-developer

Get Oracle SQL Developer package
http://www.oracle.com/technology/software/products/sql/index.html
https://www.oracle.com/database/sqldeveloper/technologies/download/

accept the licence
login
download "Oracle SQL Developer for other platforms"

Install

# download sqldeveloper-*-no-jre.zip archive
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-22.2.1.234.1810-no-jre.zip
https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-23.1.0.097.1607-no-jre.zip

# OPTIONAL: archive previous version
sudo mv  /opt/sqldeveloper{,.$(date -I)}

# extract
sudo unzip -q ~/Downloads/sqldeveloper-*-no-jre.zip -d /opt/

Configure JDK home / version

# find latest configuration file
SQL_DEVELOPER_COFIG=$(find ~/.sqldeveloper/*/product.conf | sort -V | tail -1)
#sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/default-java/|g' ${SQL_DEVELOPER_COFIG}
sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/java-1.17.0-openjdk-amd64/|g' ${SQL_DEVELOPER_COFIG}

Create starter

# Create desktop starter
cat <

<strong>Reduced memory usage</strong>
<code>
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf

Connect to MySQL server
https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer

sudo dpkg -i mysql-connector-java_8.0.26-1ubuntu21.04_all.deb 
# "Tools > Preferences > Database > Third Party JDBC Driver"
/usr/share/java/mysql-connector-java-8.0.26.jar

# DEP:
https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh

Install NetBeans

Instlal snap package
https://snapcraft.io/netbeans

sudo snap install netbeans --classic

Install binary
https://netbeans.apache.org/front/main/download/
https://www.apache.org/dyn/closer.lua/netbeans/netbeans/27/netbeans-27-bin.zip?action=download
[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.netbeans.sh]

# configure jdk
# echo netbeans_default_options="netbeans_default_options="--jdkhome" | sudo tee -a /opt/netbeans/etc/netbeans.conf
# Cannot find java. Please use the --jdkhome switch

Add git repository
https://www.youtube.com/watch?v=mzzAUEFS4vs
https://netbeans.org/kb/docs/ide/github_nb_screencast.html

OPTIONAL: install MySQL driver

sudo apt-get install libmysql-java

DEP: fix ubuntu locale settings for german

sed -i 's|en_US.UTF-8|de_DE.UTF-8|g' /etc/scim/global

DEP: disable compiz effects (Visual Effects (System > Preferences > Appearance > Visual Effects => none)

metacity --replace &

Fix bold fonts under Linux

sudo apt-get remove -y fonts-unfonts-core

Ansible role

git clone https://github.com/panticz/ansible.git /tmp/ansible
cd /tmp/ansible/
export ANSIBLE_ROLES_PATH=$(pwd)/roles
ansible-playbook -K /dev/stdin <
https://github.com/panticz/ansible/tree/master/roles/netbeans

<strong>Links</strong>
http://www.techytalk.info/netbeans-cannot-find-java-please-use-jdkhome-switch/ - HowTo (re)configure JAVA JDK
http://wiki.netbeans.org/NBPackagingPlan

Connect to MySQL DB 

# ubuntu package
sudo apt-get install -y libmysql-java

path: /usr/share/java/mysql-connector-java.jar

# download
wget http://ftp.gwdg.de/pub/misc/mysql/Downloads/Connector-J/mysql-connector-java-5.1.12.tar.gz -P /tmp

# extract
tar xzf /tmp/mysql-connector-java-5.1.12.tar.gz -C /tmp/

# copy to your classpath
cp /tmp/mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar ~/NetBeansProjects/classpath/

# Netbeans
add Library / Jar File
select 
~/NetBeansProjects/classpath/mysql-connector-java-5.1.12-bin.jar

# create tatabase
create database java;
CREATE USER dbo_java IDENTIFIED BY 'java_test';
grant all on java.* to 'dbo_java'@'%' identified by "java_test"

# configure your mysql to allow acces from network
http://www.panticz.de/mysql


FIX missing driver
cp /usr/share/java/jtds-1.2.5.jar /var/lib/tomcat6/webapps/YOUR_APP/WEB-INF/lib/

Links
http://www.mysql.de/downloads/connector/j/
http://www.kitebird.com/articles/jdbc.html

LibreOffice

User Java config file in Libreoffice 4.3

/home/${USER}/.config/libreoffice/4/user/config/javasettings_Linux_X86_64.xml

Configure default paper size

echo "a4" > /etc/papersize

enable uno listener

sudo apt-get install -y patch
#wget http://www.panticz.de/sites/default/files/Setup.xcu_.diff -P /tmp/
#patch -p2 /usr/lib/openoffice/share/registry/data/org/openoffice/Setup.xcu < /tmp/Setup.xcu_.diff

add path to java

wget http://www.panticz.de/sites/default/files/javasettingsunopkginstall.xml_.diff -P /tmp/
sudo patch -p2 /usr/lib/openoffice/share/config/javasettingsunopkginstall.xml < /tmp/javasettingsunopkginstall.xml_.diff
# on OpenOffice 3.1
sudo patch -p2 /usr/lib/openoffice/basis3.1/share/config/javasettingsunopkginstall.xml < /tmp/javasettingsunopkginstall.xml_.diff

configure database source

wget http://www.panticz.de/sites/default/files/DataAccess.xcu_.diff -P /tmp/
patch -p2 /usr/lib/openoffice/share/registry/data/org/openoffice/Office/DataAccess.xcu < /tmp/DataAccess.xcu_.diff
# on OpenOffice 3.1
patch -p2 /usr/lib/openoffice/basis3.1/share/registry/data/org/openoffice/Office/DataAccess.xcu < /tmp/DataAccess.xcu_.diff

v2
mv ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu.org
wget http://www.panticz.de/sites/default/files/DataAccess.xcu -O ~/.openoffice.org/3/user/registry/data/org/openoffice/Office/DataAccess.xcu

check files java files

sudo apt-get install ure
/usr/lib/ure/share/java/juh.jar
/usr/lib/ure/share/java/jurt.jar
/usr/lib/ure/share/java/ridl.jar

sudo apt-get install ure
/usr/lib/ure/share/java/unoloader.jar

sudo apt-get install libreoffice-java-common
/usr/lib/libreoffice/program/classes/unoil.jar

sudo apt-get install libreoffice-officebean
/usr/lib/libreoffice/program/classes/officebean.jar

Run listener

ooffice "-accept=socket,host=localhost,port=8100;urp" -quickstart -nologo -nodefault

Check uno

Java

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.java-jre.sh]

Configure default java version

# lista available versiions
ll /usr/lib/jvm/default-java/
update-java-alternatives -l
update-alternatives --config java

javaws

https://www.java.com/en/download/linux_manual.jsp
tar xf Downloads/jre-8u421-linux-x64.tar.gz -C /tmp/

/tmp/jre1.8.0_421/bin/ControlPanel

/tmp/jre1.8.0_421/bin/javaws Downloads/jviewer.jnlp

Using the Java Persistence API in Desktop Applications
http://java.sun.com/developer/technicalArticles/J2SE/Desktop/persistenceapi/

Building a Java Desktop Database Application
http://www.netbeans.org/kb/60/java/gui-db.html

NetBeans
http://www.netbeans.org/community/releases/
http://www.netbeans.org/community/releases/roadmap.html
http://www.netbeans.org/download/flash/netbeans_6_gui_builder/netbeans_6_gui_builder.html

Database Gui
http://www.netbeans.org/kb/docs/java/gui-db-custom.html - Creating a Custom Java Desktop Database Application
http://www.netbeans.org/kb/docs/web/jsf-jpa-crud-code2.html - http://www.netbeans.org/kb/docs/web/jsf-jpa-crud-code2.html

Configure Glashfish (old)
copy c:\temp\ojdbc14.jar c:\Programme\glassfish-v2-b53\lib

Code Examples
http://exampledepot.com/

Stored procedures
http://www.ibm.com/developerworks/data/library/techarticle/dm-1209storedprocedures/
http://archive.oreilly.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2

Send Email from Java
http://www.rgagnon.com/javadetails/java-0538.html

Librarys
http://code.google.com/p/gchartjava/ - gchartjava is a free Java charts & graphs library
http://code.google.com/p/google-api-translate-java/ - simple, unofficial, Java client API for using Google Translate

PDF create with iText
http://itextpdf.com/download.php
http://sourceforge.net/projects/itext/files/latest/download - Download

java