Questions asked by Alexis

How to connect To SystemDB using Windows-Authentification

Alexis — Wed, 05 Aug 2015 14:35:29 -0400

How do I connect to Ivy System DB using the Windows-Authentification?

SSO on Apache: not logged in to Ivy but in tomcat?

Alexis — Wed, 13 May 2015 09:04:14 -0400

Hello Ivy-Comunity!

When logged in to Apache (and to Tomcat) the User is not taken by Ivy.

In a testing environment I have the following constellation:

Linux environment with Ivy 5.1.3 attached to AD
Apache Server with Kerberos Login attached to the same AD
Ajp-Connector to Ivy-Tomcat
A jsp testing Page in the Ivy-Environment (applicationHome on the Application-wf-Page)

So this Page shows me by asking request.getRemoteUser() that this User is logged in: Hans.Tester@TESTENV.LOCAL and a HTTP Session request.getSession().getId(). But getting the Ivy-User by ivySession.getSessionUser() returns null. Except when Logged in manualy the result Hans.Tester for the Ivy-Session.

So why is that? Or how can I make shure, that the Session is taken correctly by ivy?

First guess is, that the username comes with the Environment (TESTENV.LOCAL). If it is the Issue, how to shut that down?

With further investigation I found out more:

In a Windows-Environment under IIS the UserName of the Tomcat-Session is in this format: TESTENV\Alexis.Suter
The Ivy-Session is not saved into Tomcat-request. (When only logging in to Ivy)

Thanks in advance!

How do I send html formated content in email step?

Alexis — Mon, 09 Feb 2015 18:56:24 -0500

Hello

How can I send formated emails? Assume I have an html-formated String and whant to bring it into my email. Problem here is that even this method will escape the String:

<%=ivy.html.getObject("in.mailString").toString()%>

Is there an other possibility to send the content of a JSP-Page?

Best regards

Alexis

Adding additional Libraries to Hibernate, e.g. Envers

Alexis — Tue, 27 Jan 2015 17:05:26 -0500

Hello Ivy-Developers!

Envers is a powerfull Library, that comes along with the Hibernate-Package and allows auto-Auditing for entities. (History-Tables etc.)

Update:

To insert the library I did as following: Added hibernate-envers-4.2.13.Final.jar to ivy-Hibernate-jar:

designer\plugins\ch.ivyteam.hibernate_5.1.0.201409121008.jar\lib\mvn\

made some changes in the ivy-Hibernate-jar: ',lib/mvn/hibernate-envers-4.2.13.Final.jar' added to MANIFEST.MF

in pom.xml I inserted a new dependency for hibernate-envers (see pom.xml)

When inserting this library this unusual way, there are no more errors accessing the persistence.

Adding @Audited to the Entity gives no error, but no auditing happens on merge.(Wich would usualy be the case)

Merging through the EntityManager (from createEntityManager()) does not work (Nothing happens, no error)

Trying to access the AuditReader will fail on a ClassNotFoundException: org.hibernate.envers.AuditReaderFactory

// switching contextClassLoader to ivy.request.getProject().getProjectClassLoader()
EntityManager em = entityManager.createEntityManager();
AuditReaderFactory.get(em);

As I understand this has been successfully implemented in the csc project.

So the questions are: How can I integrate this library into Ivy? If not possible, is there a way to detach Hibernate more from Ivy?

Installation as described in: Guide from Hibernate

Thanks in advance!

Greetings Alexis

Persistence Api - Catching NoResultException

Alexis — Tue, 25 Nov 2014 16:35:41 -0500

Hello

How do I catch a NoResultException after calling the getSingleResult() on a custom query, wich often doesn't return any result. Catching the NoResultException still logs an error (NoResultException: No entity found for query) and after that the Info is printed out. Happens both in the designer and on the server.

catch (NoResultException e) {
    Ivy.log().info("No Result has been found for Debitor '"+number+"'.");
}

haven't tested yet with other Exceptions like NonUniqueResultException.

Thank you in advance

Composite Primary Key in Persistence

Alexis — Tue, 18 Nov 2014 15:00:16 -0500

Is there any way to have multiple ID's in one Entity? Corresponding JPA it should be possible. But trying in the designer I get: Exaclty one 'Id' field per Entity Class must be used. Although it is not named 'Id'. Would be saving a lot of work, when this is enabled.

Best Regards

Alexis

Not visible Interface on persistence query

Alexis — Tue, 09 Sep 2014 14:41:36 -0400

Calling a query on a table with BLOBs (Files in Tables) using the jTDS-Driver I get a class-loader error:

java.lang.IllegalArgumentException: interface org.hibernate.engine.jdbc.WrappedBlob is not visible from class loader

My Solution was to switch to an other classloader:

  public synchronized void method() {

        Thread thread = Thread.currentThread();
        ClassLoader tempLoader = thread.getContextClassLoader();
        thread.setContextClassLoader(null);

        entityManager.createNativeQuery("select * from TSRPTBLB where TSBID = 1 ")
                       .getSingleResult();

        thread.setContextClassLoader(tempLoader);
  }

Will there be any other, cleaner way than switsching the classloader?

Thank you in advance

Generic classes in ivyscript

Alexis — Wed, 19 Feb 2014 13:18:14 -0500

Hello IvyTeam

Is there a simple way calling self made generic classes? Like the List.

Data:
dao Dao<item>

in Ivyscript:
calling dao.get(id) the response would be of type Item.

generic Class:
T get(int id)

It would be great if there is a solution.

Thanks for an answer and Greetings

Edit: Trying to extend a class with the Generic doesn't help any further.
In java code those objects return items as it should and in ivyscript Objects are still returned.

public class DaoItemTest extends Dao<Item> {
    public DaoItemTest() {
        super(Item.class);
    }
}

How to access Component dialogs

Alexis — Wed, 19 Feb 2014 10:21:51 -0500

Hello Ivy Team

I have some questions concerning the access of Components data, methods and updating in ivy-jsf.
Some points might not been implemented yet so consider these also as ideas or wishes.

In my example there is a main dialog which implements 2 components:

<ic:ch.itpoint.mms.care.ItemEdit startMethod="startNew" callback="#{logic}" />
<ic:ch.itpoint.mms.show.ItemList startMethod="start" />

There are two targets I want to reach:

Creating a Item or editing it should update the ItemList
Selecting an Item in the List should open the Object in the Item-Editor

One restriction is, that all that should be build up like described with components. Saving events will be handled first in the component, then in the main-page. Another might be to preferably stay away from self made javascripts.

I achieved, that I can save the Item and call a method (itemSaved()) via the callback on the main-page at the same time:

<p:commandButton value="#{ivy.cms.co('/lables/save')} - Callback"
actionListener="#{logic.saveItem}" action="#{cc.attrs.callback.itemSaved}" ajax="true" icon="ui-icon-disk" update="itemForm,:j_id_s:itemsListeForm" />

That's allready something, but I didn't find any way to access the List-Component.
In the end I would see these possibilities:

Having access to components methods / events, which also provoke an update in the view.
Having access to components data from main page. And some kind of dataChangeListener to update the view.

Two possible solutions I see:

An object of the compoenent in jsf (with possible access in the logic)
Same object in the logic (same as ULC-components)

An Update could exceptionally be fired by the update-Attribute :j_id_s:itemsListeForm in the brother-component (I don't know if it would work)

Thank you for your support!

Greetings
Alexis Suter