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
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
# 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
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/
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 &
# 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;
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
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/
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
# 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.