[Persistence] - How to use 2 different Oracle drivers in same server?
by ran488
We are using Jboss AS 4.2.2-GA and have hit a snag. One application needs to connect to an older Oracle 8 database, so we need to use the older Oracle JDBC driver. For all of our other applications, we need to use the newer Oracle JDBC driver.
But the classnames for the drivers are the same, so we can't figure a way to tell one *-ds.xml file to deploy under the early driver and everything else to use the newer driver.
We tried adding the older driver JAR file and the *-ds.xml file right in our application EAR file, but when deploying it picked up the newer Oracle driver from the server's lib directory anyways. This puzzled me as we are using ear-scoped classloaders.
Both applications are SEAM applications using EJB3/Hibernate. We can get one or the other to work depending on which Oracle driver we put in lib/ but can't get both to work at once.
I've been searching Google and the Jboss forums and wiki for the past 2 hours, and find lots of newbie "this is how to deploy a datasource" stuff, but nothing on 2 conflicting versions of a vendor's driver. HELP!
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4261367#4261367
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4261367
16 years, 8 months
[jBPM Users] - Re: how to programatically list actitities from one activity
by kadrim
Interesting.... Thanks rams.rapo for your time...
But this means I have to use some classes of internal pvm, for instance :
org.jbpm.pvm.internal.cmd.GetOutcomes.java , and GetOutComes needs an instance of Environment in its execute method...
"...
public Set execute(Environment environment) {
..."
I've been looking at the code of org.jbpm.pvm.internal.cmd and it seems simple to use. Besides, I've been reading the developer's guide and this enlightment came to me:
"...
JbpmConfiguration jbpmcfg = new JbpmConfiguration();
ProcessEngine proceng = jbpmcfg.buildProcessEngine();
EnvironmentImpl envimpl = jbpmcfg.openEnvironment();
GetOutcomes goc = new GetOutcomes( )
Set outcome = goc.execute( envimpl );
..."
Is this what you've tried to tell me?
Also, I've got some questions about this:
1) Is the order of statements correct? I mean :
JbpmConfiguration jbpmcfg = new JbpmConfiguration();
ProcessEngine proceng = jbpmcfg.buildProcessEngine();
EnvironmentImpl envimpl = jbpmcfg.openEnvironment();
2) I'm supposing I can do the same with commands that make reads to the database like: GetStartActivityNamesCmd.java, is this right?
3) Will there be any problems in this way because I'm not using the User API directly? With problems I mean: exceptions, runtime exceptions, logic errors made by jbpm. It's obvious that this will change in future.
Any comments would be appreciated.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4261365#4261365
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4261365
16 years, 8 months
[Beginner's Corner] - Re: 'table does not exist' error after changing default data
by bwalker55
I have turned on audiiting in Oracle. The results are:
OWNER OBJ_NAME ACTION_NAME
-------------------------------------------------
JBOSS JMS_USERS CREATE TABLE
JBOSS JMS_ROLES CREATE TABLE
JBOSS JMS_SUBSCRIPTIONS CREATE TABLE
JBOSS JMS_ROLES SESSION REC
JBOSS JMS_USERS SESSION REC
JBOSS JMS_TRANSACTIONS SELECT
It would appear that the table that is missing is JMS_TRANSACTIONS.
Note that the other three tables have a CREATE TABLE attempt (which will only be successful the first time), then a SELECT.
JMS_TRANSACTIONS is never created, so the SELECT statement always fails.
I have verified this by created a dummy JMS_TRANSACTIONS table.
The error in the log file has changed to:
...
Caused by: java.sql.SQLException: ORA-00904: "TXID": invalid identifier
...
So obviously TXID is at least one of the column names in JMS_TRANSACTIONS.
Can someone please post the schema for JMS_TRANSACTIONS.
Thanks, Bob.
PS Might also want to raise this issue in the appropriate place to get a CREATE TABLE statement added.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4261364#4261364
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4261364
16 years, 8 months