2:30 p.m.
The following sentences are taking directly from the user guide:
/ 'Person.age' : (new com.yourco.DataHelper()).getListOfAges()
This assumes you have a class called "DataHelper" which has a method
"getListOfAges()" which returns a List of strings (and is on the classpath).
You can of course mix these "dynamic" enumerations with fixed lists. You
could for example load from a database using JDBC. The data enumerations are
loaded the first time you use the guided editor in a session./
Now, I would like to know how guvnor would connect to the database ?
Inside the getListOfAges(), I want to hit the database and get the list of
ages, put it inside a Map<String, List<String>>.
The example that is shown in the user guide is again hard coding the values.
From the user guide :
/public class SampleDataSource2 {
public Map<String>, List<String> loadData() {
Map data = new HashMap();
List d = new ArrayList();
d.add("value1");
d.add("value2");
data.put("Fact.field", d);
return data;
}
}/
AFAIK, the jar of this class SampleDataSource2 will be uploaded to guvnor,
so should I keep the connection details to database inside the same class ?
If yes,
1. How will guvnor be able to directly connect to the database ?
2. Should I add the jars for database connectivity as well ?
3. Is keeping the connection details inside the jar, not a security threat ?
I am not sure if I understand completely how this enumeration works, please
feel free to guide me, if I am wrong somewhere.
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
3 p.m.
There may be better ways of doing it in newer versions of Guvnor, but the way I did it for
for 5.3 made use of Spring. Unfortunately, this did not work in 5.5.
Your code will need to do all of its database connectivity itself. Therefore it does need
to include the DB connectivity jars. I ensured that this was as easy as possible by using
the Maven Shade plugin to build a jar which contained all of my dependencies. If your
connection details are in a properties file, then it’s easy enough to reference that
outside the application Jar.
The code below is extracted from an application I wrote to do this using Spring. Possibly
if you are using Seam throughout your application then as long as you are using the same
version that Guvnor is built upon, then it might be easier.
public List<String> isoCodes() {
List<String> values = new ArrayList<String>();
for (Currency ccy : finder().findCurrencies()) {
values.add(ccy.getISO());
}
Collections.sort(values);
return values;
}
private static CurrencyFinder finder() {
return (CurrencyFinder)
GuvnorEnumContext.getContext().getBean("currencyFinder");
}
/**
* Maintains a static reference to a Spring {@link ApplicationContext}, and a
* static getContext() method, which will initialize the context if necessary.
*/
public class GuvnorEnumContext {
private static ApplicationContext ctx = null;
GuvnorEnumContext() {
}
GuvnorEnumContext(ApplicationContext applicationContext) {
ctx = applicationContext;
}
public static ApplicationContext getContext() {
if (ctx == null) {
ctx = new AnnotationConfigApplicationContext(GuvnorEnumConfig.class);
}
return ctx;
}
}
/**
* This configuration class is used by the Guvnor enumeration services to set up
* annotation-based injection of beans throughout the application.
*/
@EnableSpringConfigured
@Configuration
@ComponentScan("com.yourcompany")
public class GuvnorEnumConfig {
}
On 7 Jan 2014, at 13:30, abhinay_agarwal <abhinay_agarwal(a)infosys.com> wrote:
The following sentences are taking directly from the user guide:
/ 'Person.age' : (new com.yourco.DataHelper()).getListOfAges()
This assumes you have a class called "DataHelper" which has a method
"getListOfAges()" which returns a List of strings (and is on the classpath).
You can of course mix these "dynamic" enumerations with fixed lists. You
could for example load from a database using JDBC. The data enumerations are
loaded the first time you use the guided editor in a session./
Now, I would like to know how guvnor would connect to the database ?
Inside the getListOfAges(), I want to hit the database and get the list of
ages, put it inside a Map<String, List<String>>.
The example that is shown in the user guide is again hard coding the values.
> From the user guide :
/public class SampleDataSource2 {
public Map<String>, List<String> loadData() {
Map data = new HashMap();
List d = new ArrayList();
d.add("value1");
d.add("value2");
data.put("Fact.field", d);
return data;
}
}/
AFAIK, the jar of this class SampleDataSource2 will be uploaded to guvnor,
so should I keep the connection details to database inside the same class ?
If yes,
1. How will guvnor be able to directly connect to the database ?
2. Should I add the jars for database connectivity as well ?
3. Is keeping the connection details inside the jar, not a security threat ?
I am not sure if I understand completely how this enumeration works, please
feel free to guide me, if I am wrong somewhere.
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
3:12 p.m.
Why doesn't this approach work in 5.5 ?
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
5:31 p.m.
Basically, none of my enumeration methods were being called. It appeared to be a bug,
which I raised in Jira. Mike Anstis tested it in 5.6 quite a while back (maybe a year
ago), and whatever was wrong seems to have been fixed.
If you want to try it, I’d recommend creating a minimal enumeration class, with hard-coded
values and no external dependencies first. As long as that gets called and you see the
results in Guvnor, you should be able to add in the database connectivity.
On 7 Jan 2014, at 14:12, abhinay_agarwal <abhinay_agarwal(a)infosys.com> wrote:
Why doesn't this approach work in 5.5 ?
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
3:28 p.m.
Hi Stephen,
One quick question, what is the best approach to add these java classes into
guvnor. I am able to work it out by adding the class files into the
WEB-INF/classes folder. Is there any other easy way out, because I will be
adding a lot of files. The properties file, if used, should also be placed
inside the war ? It that practically correct ?
N.B. I have practically no idea how Maven Shade plugin works.
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
4:52 p.m.
The Maven Shade plugin is relatively simple to use. Below is the XML in my pom.xml.
Basically, it finds all of the jars which are required by your project and bundles all of
the classes (and other resources) from them into a single big fat jar. This means that
keeping track of what you have added to the Guvnor class path is much simpler.
You then put the shaded jar in the WEB-INF/lib folder inside the exploded Guvnor WAR and
restart Guvnor.
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-shade-plugin</artifactId>
<version>1.4</version>
<executions>
<execution>
<phase>package</phase>
<goals>
<goal>shade</goal>
</goals>
<configuration>
<transformers>
<transformer
implementation="org.apache.maven.plugins.shade.resource.AppendingTransformer">
<resource>META-INF/spring.handlers</resource>
</transformer>
<transformer
implementation="org.apache.maven.plugins.shade.resource.AppendingTransformer">
<resource>META-INF/spring.schemas</resource>
</transformer>
</transformers>
<filters>
<filter>
<artifact>*:*</artifact>
<excludes>
<exclude>META-INF/*.SF</exclude>
<exclude>META-INF/*.DSA</exclude>
<exclude>META-INF/*.RSA</exclude>
</excludes>
</filter>
</filters>
</configuration>
</execution>
</executions>
</plugin>
On 8 Jan 2014, at 14:28, abhinay_agarwal <abhinay_agarwal(a)infosys.com> wrote:
Hi Stephen,
One quick question, what is the best approach to add these java classes into
guvnor. I am able to work it out by adding the class files into the
WEB-INF/classes folder. Is there any other easy way out, because I will be
adding a lot of files. The properties file, if used, should also be placed
inside the war ? It that practically correct ?
N.B. I have practically no idea how Maven Shade plugin works.
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
4:58 p.m.
btw - I keep properties files in a “conf” folder at the root of my tomcat instance.
my-tomcat-instance
conf
my-props.properties
webapps
guvnor
This way, my properties stay the same between deployments of updated code.
On 8 Jan 2014, at 15:52, Stephen Masters <stephen.masters(a)me.com> wrote:
The Maven Shade plugin is relatively simple to use. Below is the XML
in my pom.xml. Basically, it finds all of the jars which are required by your project and
bundles all of the classes (and other resources) from them into a single big fat jar. This
means that keeping track of what you have added to the Guvnor class path is much simpler.
You then put the shaded jar in the WEB-INF/lib folder inside the exploded Guvnor WAR and
restart Guvnor.
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-shade-plugin</artifactId>
<version>1.4</version>
<executions>
<execution>
<phase>package</phase>
<goals>
<goal>shade</goal>
</goals>
<configuration>
<transformers>
<transformer
implementation="org.apache.maven.plugins.shade.resource.AppendingTransformer">
<resource>META-INF/spring.handlers</resource>
</transformer>
<transformer
implementation="org.apache.maven.plugins.shade.resource.AppendingTransformer">
<resource>META-INF/spring.schemas</resource>
</transformer>
</transformers>
<filters>
<filter>
<artifact>*:*</artifact>
<excludes>
<exclude>META-INF/*.SF</exclude>
<exclude>META-INF/*.DSA</exclude>
<exclude>META-INF/*.RSA</exclude>
</excludes>
</filter>
</filters>
</configuration>
</execution>
</executions>
</plugin>
On 8 Jan 2014, at 14:28, abhinay_agarwal <abhinay_agarwal(a)infosys.com> wrote:
> Hi Stephen,
>
> One quick question, what is the best approach to add these java classes into
> guvnor. I am able to work it out by adding the class files into the
> WEB-INF/classes folder. Is there any other easy way out, because I will be
> adding a lot of files. The properties file, if used, should also be placed
> inside the war ? It that practically correct ?
>
> N.B. I have practically no idea how Maven Shade plugin works.
>
> Regards,
> Abhinay
>
>
>
> --
> View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
> Sent from the Drools: User forum mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
5:46 p.m.
All data access has to be "black boxed" inside your helper class. The
example simply sets up some static data but could equally read the data
from a database. The implementation would be entirely up to your own
imvention.
Sent on the move
On 7 Jan 2014 13:31, "abhinay_agarwal" <abhinay_agarwal(a)infosys.com>
wrote:
The following sentences are taking directly from the user guide:
/ 'Person.age' : (new com.yourco.DataHelper()).getListOfAges()
This assumes you have a class called "DataHelper" which has a method
"getListOfAges()" which returns a List of strings (and is on the
classpath).
You can of course mix these "dynamic" enumerations with fixed lists. You
could for example load from a database using JDBC. The data enumerations
are
loaded the first time you use the guided editor in a session./
Now, I would like to know how guvnor would connect to the database ?
Inside the getListOfAges(), I want to hit the database and get the list of
ages, put it inside a Map<String, List<String>>.
The example that is shown in the user guide is again hard coding the
values.
>From the user guide :
/public class SampleDataSource2 {
public Map<String>, List<String> loadData() {
Map data = new HashMap();
List d = new ArrayList();
d.add("value1");
d.add("value2");
data.put("Fact.field", d);
return data;
}
}/
AFAIK, the jar of this class SampleDataSource2 will be uploaded to guvnor,
so should I keep the connection details to database inside the same class ?
If yes,
1. How will guvnor be able to directly connect to the database ?
2. Should I add the jars for database connectivity as well ?
3. Is keeping the connection details inside the jar, not a security threat
?
I am not sure if I understand completely how this enumeration works, please
feel free to guide me, if I am wrong somewhere.
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
4:33 p.m.
Hi Mantis,
Can't I establish a database connection for enumerations and authentication
in guvnor, without making any code change in the war ?
Because, code change always makes the application less stable and is less
preferred. So, it would be great if these functionality are provided before
hand by drools. :)
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
6:29 p.m.
Your helper class can be in a JAR in the web-containers classpath (I.e.
/lib). No need to change the WAR.
Guvnor does not use a database and has no notion of a database connection.
Guvnor uses JCR (for Guvnor 5.5 and lower).
Your helper class/JAR would need to handle all connectivity to perform what
you need.
Sent on the move
On 8 Jan 2014 15:33, "abhinay_agarwal" <abhinay_agarwal(a)infosys.com>
wrote:
Hi Mantis,
Can't I establish a database connection for enumerations and authentication
in guvnor, without making any code change in the war ?
Because, code change always makes the application less stable and is less
preferred. So, it would be great if these functionality are provided before
hand by drools. :)
Regards,
Abhinay
--
View this message in context:
http://drools.46999.n3.nabble.com/Using-Advanced-Enumeration-Concepts-in-...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
3769
days inactive
3770
days old
9 comments
3 participants
participants (3)
-
abhinay_agarwal -
Michael Anstis -
Stephen Masters