Re: [jboss-user] [jBPM] - jBPM 4.4 on sybase
by Alejandro Guizar
Alejandro Guizar [http://community.jboss.org/people/alex.guizar%40jboss.com] replied to the discussion
"jBPM 4.4 on sybase"
To view the discussion, visit: http://community.jboss.org/message/558314#558314
--------------------------------------------------------------
Dino, this is an issue with the JConnect driver. Even though jBPM 4.4 is not tested with Sybase, jBPM 3.2 is, and I recognized the issue instantly. The problem is described in the heading comment of this http://anonsvn.jboss.org/repos/jbpm/jbpm3/branches/jbpm-3.2-soa/modules/c... source file:
> work around a "feature" in the jConnect driver when setting a text parameter to null.
> Specifically, the call:
>
> PreparedStatement st;
> st.setNull(index, Types.CLOB);
>
> throws an SQLException with SQL state "JZ0SL" and reason "Unsupported SQL type".
>
Unfortunately the workaround is not straightforward. On the one hand you can switch to http://jtds.sourceforge.net/ jTDS, unfortunately it http://community.jboss.org/wiki/jBPM32xonSybaseASE15#JDBC_drivers does not support XA transactions for Sybase. If that is not a problem for you, go ahead and try that driver. Otherwise, you can try the jBPM3 solution. Add SybaseTextType.java to your application. Next, create a Hibernate mapping file with the following content.
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
-//Hibernate/Hibernate Mapping DTD 3.0//EN
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd>
<hibernate-mapping>
<typedef name="text" class="org.jbpm.db.hibernate.SybaseTextType" />
</hibernate-mapping>
This will make any field/property mapped to a text column employ the SybaseTextType instead of the standard org.hibernate.type.TextType, thus avoiding the call that breaks jConnect. This solution will eventually make it to jBPM4 but in the meantime, please apply it yourself.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558314#558314]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
Re: [jboss-user] [Beginner's Corner] - Why am I still seeing the HouseKeepingMessage ?
by Mads Moelgaard Andersen
Mads Moelgaard Andersen [http://community.jboss.org/people/mda_dk] replied to the discussion
"Why am I still seeing the HouseKeepingMessage ?"
To view the discussion, visit: http://community.jboss.org/message/558298#558298
--------------------------------------------------------------
Hi
I've figured it out. After googling and googling and googling on the subject. I finally found a discussion on some forum that pointed me in the right direction. It lead me to organize my code like the following example
The method returns sql based on the sql passed to the database and data in the DB.
private String getGeneratedSql(String sql) throws Exception
{
logger.debug("Enter getGeneratedSql method.");
String result = null;
Connection conn = ds.getConnection();
try
{
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
try
{
stmt.setFetchSize(this.mFetchSize);
ResultSet rs = stmt.executeQuery(sql);
try
{
if (rs.first()) result = rs.getString(1);
else throw new Exception("Could not retrive generated sql.");
}
finally
{
rs.close();
}
}
finally
{
stmt.close();
}
}
finally
{
conn.close();
logger.debug("Exit getGeneratedSql method.");
}
return result;
}
What seems essential to avoid the "HouseKeeping" warning and what I cannot explain is that open/close has to happen within the same scope, i.e same method or compound statement.
Anyway, thanks to the discussion that pushed me in the right direction.
Best regards
Mads M Andersen
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558298#558298]
Start a new discussion in Beginner's Corner at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[JBoss Tools] - MyEclipse 8.6 + JBoos Tool installation Problem
by Christian Sislak
Christian Sislak [http://community.jboss.org/people/sissifd] created the discussion
"MyEclipse 8.6 + JBoos Tool installation Problem"
To view the discussion, visit: http://community.jboss.org/message/558294#558294
--------------------------------------------------------------
Hi there,
I´m using MyEclipse 8.6, Win XP and my problem occurs during the installation JBoss Tools.
I´m running into problems during the installation with the JBoss toolkit.
I´m installing from http://donwload.jboss.org/jbosstools/updates/stable/galileo http://donwload.jboss.org/jbosstools/updates/stable/galileo
The same happens installing via source. Downloading JBoss Tools 3.1 :: Eclipse 3.5.2 from http://www.jboss.org/tools/download/ http://www.jboss.org/tools/download/.
The Error occurd :
Software being installed: MyEclipse 8.6 New (Profile) 2.0.0.0000000004 (com.poweredbypulse.profile-1001599-rmb-1003621 2.0.0.0000000004)
Only one of the following can be installed at once:
Mozilla Xulrunner 1.9.0.7-me201003052220 (org.mozilla.xulrunner.win32.win32.x86 1.9.0.7-me201003052220)
Mozilla Xulrunner 1.9.1.2 (org.mozilla.xulrunner.win32.win32.x86 1.9.1.2)
Cannot satisfy dependency:
From: MyEclipse Enterprise Workbench 8.6.0.me201008061317-7a7w-A8ryXaAg65w1wu1kf4SN7k7 (com.genuitec.myeclipse.enterprise.workbench.feature.group 8.6.0.me201008061317-7a7w-A8ryXaAg65w1wu1kf4SN7k7)
To: org.mozilla.xulrunner.win32.win32.x86 [1.9.0.7-me201003052220]
Cannot satisfy dependency:
From: MyEclipse 8.6 New (Profile) 2.0.0.0000000004 (com.poweredbypulse.profile-1001599-rmb-1003621 2.0.0.0000000004)
To: com.genuitec.myeclipse.enterprise.workbench.feature.group [7.9.100,8.9.100)
Cannot satisfy dependency:
From: MyEclipse 8.6 New (Profile) 2.0.0.0000000004 (com.poweredbypulse.profile-1001599-rmb-1003621 2.0.0.0000000004)
To: org.jboss.tools.cdi.feature.feature.group 0.0.0
Cannot satisfy dependency:
From: Context and Dependency Injection Tools 1.0.1.v201006011046R-H111-GA (org.jboss.tools.cdi.feature.feature.group 1.0.1.v201006011046R-H111-GA)
To: org.jboss.tools.richfaces.feature.feature.group 3.1.0
Cannot satisfy dependency:
From: JBoss Tools RichFaces 3.1.1.v201006011046R-H111-GA (org.jboss.tools.richfaces.feature.feature.group 3.1.1.v201006011046R-H111-GA)
To: org.jboss.tools.xulrunner.feature.feature.group 0.0.0
Cannot satisfy dependency:
From: XULRunner 1.9.1.2_v201006011046R (org.jboss.tools.xulrunner.feature.feature.group 1.9.1.2_v201006011046R)
To: org.mozilla.xulrunner.win32.win32.x86 [1.9.1.2]
Whats wrong?
Thanks, Chris
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558294#558294]
Start a new discussion in JBoss Tools at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[JBoss Cache] - Getting inconsistence data from jboss cache using gridgain
by Kiran Kumar Donthula
Kiran Kumar Donthula [http://community.jboss.org/people/dkiran] created the discussion
"Getting inconsistence data from jboss cache using gridgain"
To view the discussion, visit: http://community.jboss.org/message/558291#558291
--------------------------------------------------------------
Hi,
We are using Gridgain 2.1.1 and jboss cache 3.1.1 with JDBM persistence,
I've One SlipIndex object is stored in jboss cache path '/application/male' and same instance is also stored in '/application/unknown'. The SlipIndex objects contain array of PrintIndex objects, this PrintIndex object array is sorted based on quality, when I run application with sequentially getting same instance of SlipIndex & PrintIndex objects and also PrintIndex objects are in sorted order, but when I run in grid gain with multiple jobs (each and every path is creating one job) getting worng results, In one job getting SlipIndex including PrintIndex objects sorted order but in other job (ex:'/application/unknown' ) not getting correct order.
o/p of PrintIndex object in differnt jobs
job1 getting : [com.cmc.facts.index.PrintIndex@7c9f, com.cmc.facts.index.PrintIndex@9ffb]
job2 getting : [com.cmc.facts.index.PrintIndex@9ffb, com.cmc.facts.index.PrintIndex@7c9f]
one more observation, if job1( i.e '/application/male') executed first getting correct results and other job2 getting wrong results, if suppose job2 (i.e '/application/unknown') executed first getting correct results and other job1 getting wrong results
Note:we are not modifying any thing only getting the data from jboss cache
Note: jboss cache is persistence using JDBM
Why this type of situation is happening using jboss cache and grid gain
-kiran
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558291#558291]
Start a new discussion in JBoss Cache at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
[EJB 3.0] - Securing EJB3 traffic with mutual authentication using certificates
by Glenn Bech
Glenn Bech [http://community.jboss.org/people/glenn.bech] created the discussion
"Securing EJB3 traffic with mutual authentication using certificates"
To view the discussion, visit: http://community.jboss.org/message/558279#558279
--------------------------------------------------------------
Hi,
I am atempting to secure traffic between an Oracle Weblogic 10 and JBOSS 5.1.0 server. Our project is required to both encrypt the traffic and provide mutual authentication.
I know that my aproach does not secure the JNDI lookup, and that it will configure the entire server, and not just my application. I think however that this is the fastest way to reach our deadline, withour having to add annotations and such to our beans.
So far I have done the following;
* Created a self signed server certificate using keytool: +keytool -genkey -alias server -keyalg RSA -keystore server.keystore+
* Configured the invokerLocator of the bean org.jboss.ejb3.RemotingConnector to use sslsocket transport.
<bean name="org.jboss.ejb3.RemotingConnector">
<property name="invokerLocator">
<value-factory bean="ServiceBindingManager"
method="getStringBinding">
<parameter>
jboss.remoting:type=Connector,name=DefaultEjb3Connector,handler=ejb3
</parameter>
<parameter>
<null />
</parameter>
<parameter>sslsocket://${jboss.bind.address}:${port}</parameter>
<parameter>
<null />
</parameter>
<parameter>3873</parameter>
</value-factory>
</property>
<property name="serverConfiguration">
<inject bean="ServerConfiguration" />
</property>
</bean>
* On the client side, I also generate a self signed certificate: keytool -genkey -alias client -keyalg RSA -keystore client.keystore
* I then establish mutual authentication
* I export the server certificate from the server keystore and import it into what becomes the client truststore
* I export the client certificate from the client keystore and import it into what becomes the server truststor
* I then configure both weblogic and JBOSS with the comamnd line arguments
-Djavax.net.ssl.keyStore
-Djavax.net.ssl.keyStorePassword
-Djavax.net.ssl.trustStore=
-Djavax.net.ssl.trustStorePassword
I have one-way SSL up and running. If I remove the server certificate from the Client trust store, the handshake
fails.
My problem is; JBOSS does not authenticate the client certificate and accepts all incoming traffic. It seems to be
ignoring the configured truststore. I have searched all documentation and have found nothing on EJB3 over SSL & mutual authentication
in JBOSS 5.1.0AS
Can anyone help?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558279#558279]
Start a new discussion in EJB 3.0 at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month
Re: [jboss-user] [jBPM] - Visualize workflow and it's current state
by Adwait Chitaley
Adwait Chitaley [http://community.jboss.org/people/achitaley] replied to the discussion
"Visualize workflow and it's current state"
To view the discussion, visit: http://community.jboss.org/message/558278#558278
--------------------------------------------------------------
To Eugene Dzhurinsky, HuiSheng Xu and other JBPM Users who desire to view the Current Status of a Process Instance in a Graphical Mode / PNG Image.
I have received a generous assistance of Roberto Harihar from Brazil, who has developed this code in viewing the Current Status of A Process Instance Graphically.
With the attached files and steps mentioned below, we can generate an Image of the Current Status of Process Instance. This can be integrated into our application as well.
1) Use the attached File (jbpm_image_sample.jar) and extract it. This JAR Contains the necessary code to generate PNG Image of Current Process Instance at Runtime. This also contains the required images to generate the PNG Image.
2) In addition to above, in the same package, create a Java Class File named *Render.java* and insert the following code in it:
import java.io.File;
import java.util.List;
import javax.imageio.ImageIO;
import org.jbpm.api.Configuration;
import org.jbpm.api.ProcessEngine;
import org.jbpm.api.model.OpenExecution;
import com.airsanchay.jbpm.JBPMUtilities;
import org.jbpm.api.ExecutionService;
import org.jbpm.api.HistoryService;
import org.jbpm.api.IdentityService;
import org.jbpm.api.ManagementService;
import org.jbpm.api.RepositoryService;
import org.jbpm.api.TaskService;
public class Render {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
String processInstanceId = "AIRSanchayWorkflow.1870001";
/** if you are running as a java application - outside a j2ee container */
ProcessEngine processEngine = new Configuration().setResource("jbpm.cfg.xml").buildProcessEngine();
List historyActivities = processEngine.getHistoryService().createHistoryActivityInstanceQuery().processInstanceId(processInstanceId).list();
RenderImage_JpdlModel jpdlModel = new RenderImage_JpdlModel(JBPMUtilities.class.getResourceAsStream("AIRSanchayWorkflow.jpdl.xml"), historyActivities);
ImageIO.write(new RenderImage_JpdlModelDrawer().draw(jpdlModel), "png", new File("/root/Desktop/myprocess.png"));
}
}
|
| |
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/558278#558278]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 1 month