- Topia-devel - mailman.cloud.codelutin.com

Gestion des blob via topia et hibernate
by Eric Chatellier Sept. 20, 2012

Sept. 20, 2012

Bonjour, J'ai fait un peu de recherche pour gérer des blob dans topia/hibernate. Le besoin étant de stocké les fichiers dans la base de données pour faciliter la gestion. Solution 1 ========== La première solution que j'ai testé à consister à représenter les données binaire dans le modèle uml via : java.lang.byte[] et a changer le type hibernate via model.tagvalue.java.lang.byte[]=binary ca fonctionnais, mais par contre, le binary a une taille limitée Solution 2 ========== Même méthode que la solution 1, mais en changeant la tagvalue en model.tagvalue.java.lang.byte[]=blob Mais cela ne fonctionne pas non plus: Caused by: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob at org.hibernate.type.descriptor.java.BlobTypeDescriptor.areEqual(BlobTypeDescriptor.java:47) at org.hibernate.type.AbstractStandardBasicType.isEqual(AbstractStandardBasicType.java:184) at org.hibernate.type.AbstractStandardBasicType.isSame(AbstractStandardBasicType.java:169) at org.hibernate.type.AbstractStandardBasicType.isDirty(AbstractStandardBasicType.java:214) at org.hibernate.type.AbstractStandardBasicType.isDirty(AbstractStandardBasicType.java:210) at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:295) Solution 3 ========== La solution actuelle à laquelle je suis arrivée mais qui a des inconvénients de modélisation est la suivante: * modélisation UML en type : java.sql.Blob * tag value : model.tagvalue.java.sql.Blob=blob Mais : * à l'enregistrement, le code métier doit manipuler des blob via l’implémentation fournit par hibernate: is = new FileInputStream(file); // create blob object Blob blob = Hibernate.createBlob(is); // code déprécié is.close(); entity.setData(blob); * à la lecture (download), actuellement c'est même l'ui struts qui dépent de la couche sql à cause d'un throws: public InputStream getInputStream() { InputStream inputStream = null; try { inputStream = analyzeFile.getData().getBinaryStream(); } catch (SQLException ex) { // damned throws } return inputStream; } Voilà, j'ai pas de solution plus propre que ca pour le moment. -- Éric Chatellier <chatellier(a)codelutin.com> Tel: 02.40.50.29.28 http://www.codelutin.com

1 0

[ANN] - ToPIA 2.7 released
by nuiton.org Release Notification Sept. 14, 2012

Sept. 14, 2012

The ToPIA team is pleased to announce the topia-2.7 release! Tools for Portable and Independent Architecture : Framework de persistance et de distribution d'application. Documentation of the project can be found here: http://maven-site.nuiton.org/topia Important note -------------- Due to http://nuiton.org/issues/2313, there is some incompatible api in DAO on findAllbyPage method. You will have to use now the TopiaPagerBean to fix this. Changes ------- Changes in this version include: New features: o Add methods findAllLazyByQuery on TopiaDAO to iterate on result by a lazy mecanism Issue: 2301. Thanks to Tony Chemit. Resolved by tchemit. o Improve entity visitor to export as csv files Issue: 2311. Thanks to Tony Chemit. Resolved by tchemit. o Use new PageBean API from nuiton-utils Issue: 2313. Thanks to Tony Chemit. Resolved by tchemit. o Add a new method to import a talbe and return imported entities Issue: 2309. Thanks to Tony Chemit. Resolved by tchemit. o Add progress model while importing data Issue: 2310. Thanks to Tony Chemit. Resolved by tchemit. Fixed Bugs: o TopiaCsvExport should use as incoming source Iterable not List Issue: 2302. Thanks to Tony Chemit. Resolved by tchemit. o CsvFileImportResult does not give back correct entities number Issue: 2306. Thanks to Tony Chemit. Resolved by tchemit. Changes: o Updates to nuiton-utils 2.6.2 Issue: 2314. Thanks to Tony Chemit. Resolved by tchemit. Downloads --------- No release file deployed. (all files are deployed in the maven repository) Maven artifacts --------------- Artifacts are deployed in Maven Central Repository http://repo1.maven.org/maven2/ Find us at * http://search.maven.org/#artifactdetails|org.nuiton|topia|2.7|jar Have fun! -ToPIA team

1 0

Jenkins build became unstable: topia-2.6.x #41
by admin+hudson＠codelutin.com Aug. 30, 2012

Aug. 30, 2012

See <http://ci.nuiton.org/jenkins/job/topia-2.6.x/41/changes>

1 2

Jenkins build became unstable: topia-2.6.x » ToPIA :: Service Security #41
by admin+hudson＠codelutin.com Aug. 30, 2012

Aug. 30, 2012

See <http://ci.nuiton.org/jenkins/job/topia-2.6.x/org.nuiton.topia$topia-service…>

1 2

[ANN] - ToPIA 2.6.13 released
by nuiton.org Release Notification Aug. 27, 2012

Aug. 27, 2012

The ToPIA team is pleased to announce the topia-2.6.13 release! Tools for Portable and Independent Architecture : Framework de persistance et de distribution d'application. Documentation of the project can be found here: http://maven-site.nuiton.org/topia Changes ------- Changes in this version include: New features: o Add clearCache method on topia context to clear hibernate cache Issue: 2284. Thanks to Éric Chatellier. Resolved by echatellier. Downloads --------- No release file deployed. (all files are deployed in the maven repository) Maven artifacts --------------- Artifacts are deployed in Maven Central Repository http://repo1.maven.org/maven2/ Find us at * http://search.maven.org/#artifactdetails|org.nuiton|topia|2.6.13|jar Have fun! -ToPIA team

1 0

Vidage automatique du cache hibernate
by Eric Chatellier Aug. 27, 2012

Aug. 27, 2012

Bonjour, Nous avons trouvé dans une application utilisant topia une fuite mémoire due au cache hibernate. En effet, comme le confirme la documentation [1], il n'est pas libéré tant que la session n'est pas close: "The Session caches every object that is in a persistent state (watched and checked for dirty state by Hibernate). If you keep it open for a long time or simply load too much data, it will grow endlessly until you get an OutOfMemoryException. One solution is to call clear() and evict() to manage the Session cache, but you should consider a Stored Procedure if you need mass data operations. Some solutions are shown in Chapitre 14, Traitement par lot. Keeping a Session open for the duration of a user session also means a higher probability of stale data." Dans le cas de notre application, il faudrait que après chaque commit, un session.clear() soit fait automatiquement. Le ticket a été créé dans ce but: http://www.nuiton.org/issues/2284 [1] : http://docs.jboss.org/hibernate/orm/3.5/reference/fr-FR/html/transactions.h… -- Éric Chatellier <chatellier(a)codelutin.com> Tel: 02.40.50.29.28 http://www.codelutin.com

1 2

[ANN] - ToPIA 2.6.12 released
by nuiton.org Release Notification Aug. 23, 2012

Aug. 23, 2012

The ToPIA team is pleased to announce the topia-2.6.12 release! Tools for Portable and Independent Architecture : Framework de persistance et de distribution d'application. Documentation of the project can be found here: http://maven-site.nuiton.org/topia Changes ------- Changes in this version include: New features: o Adds a method to compute the association table name for two different entity contract Issue: 2265. Thanks to Tony Chemit. Resolved by tchemit. o Add GET_TOPIA_ID function into TopiaId class (at last) Issue: 2264. Thanks to Tony Chemit. Resolved by tchemit. o Add deleteAll method on TopiaDAO Issue: 2276. Thanks to Tony Chemit. Resolved by tchemit. o Introduce a TopiaPersistenceHelper Issue: 2278. Thanks to Tony Chemit. Resolved by tchemit. o Add some api about import / export in csv format Issue: 2266. Thanks to Tony Chemit. Resolved by tchemit. o Add new methods to TopiaDAO to do search without using TopiaQuery Issue: 2272. Thanks to Tony Chemit. Resolved by tchemit. o Add a metadata package in persistence Issue: 2260. Thanks to Tony Chemit. Resolved by tchemit. o Add method name() on TopiaEntityEnum Issue: 2262. Thanks to Tony Chemit. Resolved by tchemit. Fixed Bugs: o not null are not generated in XXXEntityEnum is not in naturalId Issue: 2257. Thanks to Tony Chemit. Resolved by tchemit. Changes: o updates to mavenpom 3.3.6 Issue: 2255. Thanks to Tony Chemit. Resolved by tchemit. o updates to eugene 2.5 Issue: 2256. Thanks to Tony Chemit. Resolved by tchemit. o Improve TopiaDAO javadoc Issue: 2274. Thanks to Tony Chemit. Resolved by tchemit. o Deprecate TopiaQuery Issue: 2271. Thanks to Tony Chemit. Resolved by tchemit. o updates to nuiton-utils 2.6 Issue: 2261. Thanks to Tony Chemit. Resolved by tchemit. Downloads --------- No release file deployed. (all files are deployed in the maven repository) Maven artifacts --------------- Artifacts are deployed in Maven Central Repository http://repo1.maven.org/maven2/ Find us at * http://search.maven.org/#artifactdetails|org.nuiton|topia|2.6.12|jar Have fun! -ToPIA team

1 0

Jenkins build became unstable: topia-2.6.x #39
by admin+hudson＠codelutin.com Aug. 23, 2012

Aug. 23, 2012

See <http://ci.nuiton.org/jenkins/job/topia-2.6.x/39/changes>

1 1

Jenkins build became unstable: topia-2.6.x » ToPIA :: Service Security #39
by admin+hudson＠codelutin.com Aug. 23, 2012

Aug. 23, 2012

See <http://ci.nuiton.org/jenkins/job/topia-2.6.x/org.nuiton.topia$topia-service…>

1 1

Jenkins build became unstable: topia-2.6.x #37
by admin+hudson＠codelutin.com Aug. 22, 2012

Aug. 22, 2012

See <http://ci.nuiton.org/jenkins/job/topia-2.6.x/37/changes>

1 1