java

installSqlDeveloper.sh

Get Oracle SQL Developer package
1. go to Homepage: http://www.oracle.com/technology/software/products/sql/index.html
2. accept the licence
3. login
4. download "Oracle SQL Developer for other platforms"

wget http://installit.googlecode.com/hg/install.sqldeveloper.sh -O - | bash -

#!/bin/bash

URL=$1
FILE=${URL##*/}
USER=$2

# install Java JDK
wget http://installit.googlecode.com/hg/install.java-jre.sh -O - | bash -

# get file
if [ ${URL:0:4} == "http" ]; then
  wget ${URL} -O /tmp/${FILE}
else
  cp ${URL} /tmp/${FILE}
fi

# extract
sudo unzip /tmp/${FILE} -d /usr/share/
sudo chmod +x /usr/share/sqldeveloper/sqldeveloper.sh
rm /tmp/sqldeveloper-*-no-jre.zip

# create startet
cat << EOF | sudo tee -a "/usr/share/applications/Oracle SQL Developer.desktop"
[Desktop Entry]
Version=1.0
Encoding=UTF-8
Name=Oracle SQL Developer
Type=Application
Terminal=false
Exec=/usr/share/sqldeveloper/sqldeveloper.sh
Icon=/usr/share/sqldeveloper/icon.png
Categories=Application;Development;
EOF

# create config dir
mkdir /home/${USER}/.sqldeveloper
cat <<EOF> /home/${USER}/.sqldeveloper/jdk
/usr/lib/jvm/java-6-sun/
EOF

# set owner
chown -R ${USER}:${USER} /home/${USER}/.sqldeveloper/

# ToDo
# use a repository
# configure global

Install Java JRE

wget http://installit.googlecode.com/hg/install.java-jre.sh -O - | bash -

#!/bin/bash

# install debconf
sudo apt-get install debconf-utils

# create answer file
sudo debconf-set-selections <<\EOF
sun-java6-bin shared/accepted-sun-dlj-v1-1 boolean true
EOF

# add repository
sudo add-apt-repository -y ppa:flexiondotorg/java

# update repository
sudo apt-get update -qq

# install
sudo apt-get install -y --force-yes sun-java6-jre sun-java6-plugin sun-java6-fonts

# set as default
sudo update-java-alternatives -s java-6-sun

Install MS SQL Server JDBC Driver

# get driver
wget http://netcologne.dl.sourceforge.net/project/jtds/jtds/1.2.5/jtds-1.2.5-dist.zip -P /tmp/
unzip /tmp/jtds-1.2.5-dist.zip -d /tmp/
sudo cp /tmp/jtds-1.2.5.jar /usr/share/java/

Eclipse > Build Path > Configure Build Path
Libraries > Add External JARs
/usr/share/java/jtds-1.2.5.jar

# fix tomcat
sudo cp /usr/share/java/jtds-1.2.5.jar /var/lib/tomcat6/webapps/builder3/WEB-INF/lib/

# Links
http://www.java-tips.org/other-api-tips/jdbc/how-to-connect-microsoft-sql-server-using-jdbc.html

Install Eclipse

wget http://installit.googlecode.com/hg/install.eclipse.sh -O - | bash -

#/bin/bash

# install Java JDK
wget http://installit.googlecode.com/hg/install.java-jdk.sh -O - | bash -

if [ "$(uname -m)" == "x86_64" ]; then
     # 64 bit
     URL=http://mirror.netcologne.de/eclipse/technology/epp/downloads/release/indigo/SR1/eclipse-java-indigo-SR1-linux-gtk-x86_64.tar.gz
else
     # 32 bit
     URL=http://mirror.netcologne.de/eclipse/technology/epp/downloads/release/indigo/SR1/eclipse-java-indigo-SR1-linux-gtk.tar.gz
fi

# install eclipse from repository
# sudo apt-get install -y eclipse

# download new eclipse release
wget ${URL} -P /tmp

# backup old release
sudo mv /usr/lib/eclipse/ /usr/lib/eclipse.$(date -I)

# install new release
sudo tar xzf /tmp/eclipse-java-*-linux-gtk*.tar.gz -C /usr/lib/

# set owner and permissions
sudo chown -R root:root /usr/lib/eclipse
sudo chmod -R +r /usr/lib/eclipse

# add executable to path
cat <<EOF> /tmp/eclipse
#!/bin/sh
export ECLIPSE_HOME="/usr/lib/eclipse"

\${ECLIPSE_HOME}/eclipse $*
EOF

sudo mv /tmp/eclipse /usr/bin/eclipse
sudo chmod 755 /usr/bin/eclipse


# create starter
cat <<EOF> /tmp/eclipse.desktop
[Desktop Entry]
Encoding=UTF-8
Name=Eclipse
Comment=Eclipse IDE
Exec=eclipse
Icon=/usr/lib/eclipse/icon.xpm
Terminal=false
Type=Application
Categories=GNOME;Application;Development;
StartupNotify=true
EOF

sudo mv /tmp/eclipse.desktop /usr/share/applications/eclipse.desktop
sudo chmod +r /usr/share/applications/eclipse.desktop

# FIXME: Google Web Toolkit Plugin installation dont work, wrong permissions?

Global settings
/usr/lib/eclipse/eclipse.ini

OPTIONAL: change editor line break to 240 char
Project > Properties
Configure Worksapece Settings
Edit
Line Wraping
Maximum line widht: 240

GWT Plugin
Help > Install new software
http://dl.google.com/eclipse/plugin/3.6 - Plugin for Eclipse (and SDKs)
http://dl.google.com/eclipse/inst/d2wbpro/beta/3.6 - Beta WindowBuilder
http://dl.google.com/eclipse/inst/d2gwt/latest/3.6 - Installing GWT Designer

Links
http://code.google.com/intl/de/eclipse/docs/install-eclipse-3.5.html
http://sourceforge.net/projects/shelled/

Install NetBeans

wget http://installit.googlecode.com/hg/install.netbeans.sh -O - | bash -

#!/bin/bash

# install Java JDK
wget http://installit.googlecode.com/hg/install.java-jdk.sh -O - | bash -

# download and install netbeans from homepage
URL=http://download.netbeans.org/netbeans/7.1/final/bundles/netbeans-7.1-ml-javase-linux.sh

wget ${URL} -O /tmp/netbeans-linux.sh
sudo bash /tmp/netbeans-linux.sh --silent

# fix permissions
sudo chmod o+r /usr/local/glassfish-*/glassfish/domains/domain1/config/*

OPTIONAL: install MySQL driver
apt-get install libmysql-java

# OLD
# fix ubuntu locale settings for german
#sed -i 's|en_US.UTF-8|de_DE.UTF-8|g' /etc/scim/global

# disable compiz effects (Visual Effects (System > Preferences > Appearance > Visual Effects => none)
metacity --replace &

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;

Install Java JDK

wget http://installit.googlecode.com/hg/install.java-jdk.sh -O - | bash -

#!/bin/bash

# install debconf
sudo apt-get install debconf-utils

# create answer file
sudo debconf-set-selections <<\EOF
sun-java6-bin shared/accepted-sun-dlj-v1-1 boolean true
EOF

# add repository
sudo add-apt-repository -y ppa:flexiondotorg/java

# update repository
sudo apt-get update -qq

# install
sudo apt-get install -y --force-yes sun-java6-jdk

# OPTIONAL: PPA repository
sudo add-apt-repository ppa:sun-java-community-team/sun-java6
sudo apt-get update
sudo apt-get install sun-java6

sudo update-alternatives --config java

HqEclipse

You can install the plugin using the Eclipse Update Manager:

Help > Install new Software
Work with: http://hge.javaforge.com/hgeclipse

[ OK ]
check HqEclipse
[ Next > ]
[ Next > ]
check "I accept the terms of the license agreement"
[ Finish ]
 
confirm Security Warnings dialog with [ OK ]
 
Restart your Eclipse
 
 
 
https://j2m.googlecode.com/hg/
https://hgeclipse-demo.googlecode.com/hg/
 
http://code.google.com/p/hgeclipse-demo/

Create Magento SOAP account

command line

wget http://www.panticz.de/sites/default/files/soap.txt -O /tmp/soap.sql
mysql -u magento -pmagento magento < /tmp/soap.sql

Create soap role
System > Web Services > Roles
[Add New Role]
Role name: API Full Access

Roles Resources
Resource Access: All

[Save Role]

Create soap user
System > Web Services > Users
[Add New User]
User Name: soap
First Name: soap
Last Name: soap
Email: soap@soap.com
Api Key: test123
Api Key Confirmation: test123
This account is: Active

User Role

Extend Magento Product Attribute Api

# OPTIONAL, install patch
apt-get install -y patch
 
# patch on command line
cd /var/www/
wget http://www.panticz.de/sites/default/files/api.xml_.diff -O /tmp/api.xml.diff
patch -p2 ./app/code/core/Mage/Catalog/etc/api.xml < /tmp/api.xml.diff
 
wget http://www.panticz.de/sites/default/files/Api.php_.diff -O /tmp/Api.php.diff
patch -p2 ./app/code/core/Mage/Catalog/Model/Product/Attribute/Api.php < /tmp/Api.php.diff
 
 
1. go to magento installation folder, for example /var/www/magento
 
2.

Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!


Syndicate content