@Id @GeneratedValue (strategy=GenerationType.IDENTITY)@Column(name = "REJ_CDN")int id;@Id@GeneratedValue(generator = "autoincrement")@GenericGenerator(strategy = "increment", name = "autoincrement")@Column(name = "MYID")Integer id;
LoadModule proxy_module modules/mod_proxy.soLoadModule proxy_connect_module modules/mod_proxy_connect.soLoadModule proxy_ftp_module modules/mod_proxy_ftp.soLoadModule proxy_http_module modules/mod_proxy_http.soLoadModule proxy_ajp_module modules/mod_proxy_ajp.soInclude conf/vhosts.d/*.conf<Location /wiki > AuthType Basic AuthName "Restricted Files" AuthUserFile /etc/apachepasswd Require user wiki ProxyPass ajp://localhost:8009/JSPWiki ProxyPassReverse ajp://localhost:8009/JSPWiki allow from all</Location><Location /gestion > ProxyPass ajp://localhost:8009/gestion ProxyPassReverse ajp://localhost:8009/ allow from all</Location>Autrement, il est aussi possible de créer un fichier worker.properties # worker "worker1" will talk to Tomcat listening on machine www.x.com at port 8007 using 2 lb factorworker.list=worker1worker.worker1.host=myhostworker.worker1.port=9009worker.worker1.lbfactor=2# Update this path to match your conf directory location (put workers.properties next to httpd.conf)JkWorkersFile /etc/httpd/conf/worker.properties# Where to put jk shared memory# Update this path to match your local state directory or logs directoryJkShmFile /var/log/httpd/mod_jk.shm# Where to put jk logs# Update this path to match your logs directory location (put mod_jk.log next to access_log)JkLogFile /var/log/httpd/mod_jk.log# Set the jk log level [debug/error/info]JkLogLevel info# Select the timestamp log formatJkLogStampFormat "[%a %b %d %H:%M:%S %Y] "# Send everything for context /examples to worker named worker1 (ajp13)JkMount /ft-jobs/* worker1ProxyPass /hudson/ http://vm04:8080/hudson/
On accedera à hudson par l'url http://vm01/hudson/
Faire du load balancing
Solution n°1
<Location /jonas>ProxyPass balancer://mycluster/ProxyPassReverse balancer://mycluster/Allow From All</Location><Proxy balancer://mycluster>BalancerMember ajp://localhost:9009/myappBalancerMember ajp://localhost:8009/myapp</Proxy>
Solution n°2
ProxyPass http://localhost/myapp/ProxyPassReverse /myapp/Allow From AllJkWorkersFile /etc/httpd/conf/worker.propertiesJkShmFile /var/log/httpd/mod_jk.shmaccess_log)JkLogFile /var/log/httpd/mod_jk.logJkLogLevel infoJkLogStampFormat "[%a %b %d %H:%M:%S %Y] "JkMount /myapp/* worker1
mardi 21 octobre 2008
No Dialect mapping for JDBC type: -1
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
Was provoked by :
String query = "SELECT * FROM MYTABLE WHERE MYID=? "+ "AND MYCRITERIA >= ?";SQLQuery sqlQuery;sqlQuery = session.createSQLQuery(query);sqlQuery.setString(0, code);sqlQuery.setDate(1, date);List<string> ports = sqlQuery.list();
The cause was I could not to use the *, I had to specify each field instead.
How to copy a file on webdav using common-httpclient ?
Webdav technology allow sharing files with internet. WebDav is a filesytem interface relying on http protocol, a non transactionnal. Webdav manages files whithout locking and work using a versionning system in order to continue working for multiple users. A tricky mecanism for holding concurrent versions lay behind the scene, but if you plan to use WebDav like you'd use a samba filesytem, you may not care understanding of the hidden processes.
If your on a local network, you'd still prefer more standard file system for convenience.
In java, you can use the generic http client commons-httpclient to put your files on a webdav server. I give you a sample code that let you create a file on the server and then DELETE it. Somme more sophisticated operations can be performed with the jackrabbit-webdav library, it will provide you with more operations.
HostConfiguration hostConfig = new HostConfiguration();hostConfig.setHost("targetserver");HttpConnectionManager connectionManager = new MultiThreadedHttpConnectionManager();HttpConnectionManagerParams params = new HttpConnectionManagerParams();int maxHostConnections = 20;params.setMaxConnectionsPerHost(hostConfig, maxHostConnections);connectionManager.setParams(params);HttpClient client = new HttpClient(connectionManager);Credentials creds = new UsernamePasswordCredentials("username","password");client.getState().setCredentials(AuthScope.ANY, creds);client.setHostConfiguration(hostConfig);PutMethod putMethod = new PutMethod( "http://targetserver:8080/webdav/targetfilename");FileInputStream is = new FileInputStream("myfile.pdf");InputStreamRequestEntity requestEntity = new InputStreamRequestEntity(is);putMethod.setRequestEntity(requestEntity);client.executeMethod(putMethod);System.out.println(putMethod.getStatusCode() + " " + putMethod.getStatusText());
You could have to sort of status code :
201 Created (A file has been created)
204 No data(The http response has no data, but the operation has performed correctly)
And to delete a file :
DeleteMethod deleteMethod = new DeleteMethod( "http://targetserver:8080/webdav/targetfilename");client.executeMethod(deleteMethod);System.out.println(putMethod.getStatusCode() + " " + putMethod.getStatusText());mvn javancss:report| Program NCSS | NCSS average | CCN average | Javadocs average |
|---|---|---|---|
| 2,766.00 | 3.86 | 2.02 | 0.46 |
find /var/backupreposvn/ -atime +60 -type f|xargs rm -fexport BACKUPDIR=$HOME/backup/mkdir $BACKUPDIRexport SRCFILE=$HOME/backup/`date +%Y%m%d`.tgztar -cvzf $SRCFILE $HOME/.gvfs/documents\ sur\ ls-wsglbc3/export COMBIEN=`ls $BACKUPDIR|wc -l`if [[ $COMBIEN>3 ]]then find $HOME/backup/ -mtime +30 -exec rm -f {} \;else echo "Pas de fichier à supprimer"fimysqldump -uroot -pjt ft_jobs_val|gzip >/var/backup/ft_jobs_val_`date +%Y%m%d`.dump.gzmysqldump -uroot -pjt ft_jobs_val_int|gzip >/var/backup/ft_jobs_val_int_`date +%Y%m%d`.dump.gzmysqldump -uroot -pjt jira1|gzip >/var/backup/ft_jobs_jira1_`date +%Y%m%d`.dump.gzmysqldump -uroot -pjt jira2|gzip >/var/backup/ft_jobs_jira2_`date +%Y%m%d`.dump.gzfind /var/backup/ -mtime +30 -exec rm -f {} \;mv /home/myhome/apr-util-XXX/ /home/myhome/subversion-XXX/apr-util/mv /home/myhome/apr-XXX/ /home/myhome/subversion-XXX/apr/mv /home/myhome/neon-XXX/ /home/myhome/subversion-XXX/neon/./configure --prefix=/usrmake installSQLQuery query = session .createSQLQuery("SELECT count(*) FROM MATABLE WHERE MACOL1=? AND MACOL2=?");query.addScalar("NOMBRE", Hibernate.FLOAT);query.setDate(0, dateFinMois);query.setInteger(1, commande.getId());Float consommeEnFinDeMois = (Float) query.list().get(0);