[JBoss JIRA] Commented: (JBAS-3029) DatabaseServerLoginModule improvement
by Felix Ho?feld (JIRA)
[ http://jira.jboss.com/jira/browse/JBAS-3029?page=comments#action_12356443 ]
Felix Ho?feld commented on JBAS-3029:
-------------------------------------
This is unnecessary because you can simply change your query:
SELECT * FROM (
SELECT 'User', 'Roles' FROM USERS
UNION
SELECT 'Administrator','Roles' FROM ADMINISTRATORS)
WHERE username=?
The query optimizer of any sane database will notice the where clause and apply it to each select statement so there is no perfomance impact.
I vote against this issue and suggest it is closed.
Regards
Felix
> DatabaseServerLoginModule improvement
> -------------------------------------
>
> Key: JBAS-3029
> URL: http://jira.jboss.com/jira/browse/JBAS-3029
> Project: JBoss Application Server
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Security
> Reporter: YCS WYW
> Priority: Optional
>
> I would like to configure "org.jboss.security.auth.spi.DatabaseServerLoginModule" with complex SQL statements on "principalsQuery" and "rolesQuery"
> (like: SELECT 'User', 'Roles' FROM USERS WHERE username=?
> UNION SELECT 'Administrator','Roles' FROM ADMINISTRATORS WHERE username=? )
> But the SQL statements are executed by "java.sql.PreparedStatement" with only 1 parameter value for the first "?" (username). And the SQL statements that contains more than 1 "username" parameter doesn't work.
> I may be solved with the next modifications:
> In class "org.jboss.security.auth.spi.Util" :
> -----------------------------------------------------------------
> Changing "ps.setString(1, username);" of third "getRoleSets" method with these other statements:
> int index = 0;
> int param = 1;
> while( (index = rolesQuery.indexOf("?", index)) >= 0) {
> ps.setString(param++, username);
> index++;
> }
> And in class "org.jboss.security.auth.spi.DatabaseServerLoginModule":
> ---------------------------------------------------------------------------------------------------------------
> Changing "ps.setString(1, username);" of method "getUsersPassword" with these other statements:
> int index = 0;
> int param = 1;
> while( (index = principalsQuery.indexOf("?", index)) >= 0) {
> ps.setString(param++, username);
> index++;
> }
> Thanks.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
19 years, 3 months
[JBoss JIRA] Created: (JBAS-4208) Manifest Class-Path ignored in packaged EAR file, used in exploded EAR file
by John Cater (JIRA)
Manifest Class-Path ignored in packaged EAR file, used in exploded EAR file
---------------------------------------------------------------------------
Key: JBAS-4208
URL: http://jira.jboss.com/jira/browse/JBAS-4208
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: ClassLoading
Affects Versions: JBossAS-5.0.0.Beta1
Reporter: John Cater
Assigned To: Scott M Stark
I am attaching a sample project that shows this issue.
In short, a packaged EAR file that contains a JAR, which uses the Class-Path entry in the JAR's MANIFEST.MF file, will not correctly load the JAR's Class-Path entries, and instead throw NoClassDefFoundErrors. The same EAR, when exploded, loads properly.
To test: in the attached project, run 'ant explode-ear'. Attempt to load first the exploded ear, then the packaged ear, into JBoss.
in the JMX Control panel, look for the test.ear:name=TestService MBean. Execute the 'createThing' operation. This can be validated with the 'seeThing' operation.
In the correctly-working exploded EAR, createThing works properly. In the packaged EAR, createThing fails with a NoClassDefFoundError.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
19 years, 3 months
[JBoss JIRA] Created: (JBPM-902) JBPM-Timer cannot be started
by Prem Kosta (JIRA)
JBPM-Timer cannot be started
----------------------------
Key: JBPM-902
URL: http://jira.jboss.com/jira/browse/JBPM-902
Project: JBoss jBPM
Issue Type: Feature Request
Reporter: Prem Kosta
Assigned To: Tom Baeyens
Hey,
I'm new to jBPM.
Could you please tell me how to start a timer? Is a Scheduler needed for this?
I have define a process definition :
<?xml version="1.0"?>
<process-definition name="MyProcess">
<start-state name="start">
<task name="start">
<assignment pooled-actors="testP0"></assignment>
</task>
<transition name="to_P0" to="p0">
</transition>
</start-state>
<task-node name="p0">
<task name="task1">
<assignment pooled-actors="testP0"></assignment>
<event type="task-start">
<action class="com....MyAction">
<name>"#{workflowAction.nr}"</name>
</action>
</event>
</task>
<transition name="to_P1" to="P1"></transition>
</task-node>
<task-node name="P1">
<task name="task1">
<assignment pooled-actors="testP0"></assignment>
<event type="task-start">
<action class="com....MyAction">
<name>#{workflowAction.nr}</name>
</action>
</event>
</task>
<transition name="zu_P2" to="P2" />
</task-node>
<task-node name="P2">
<task name="task2">
<assignment pooled-actors="testP0"></assignment>
<timer name="QuarzTimer2" duedate="30 seconds"
repeat="60 seconds">
<action class="com.....TimerAction"/>
</timer>
</task>
<transition name="to_P3" to="P3"></transition>
</task-node>
<task-node name="P3">
<task name="task3"></task>
<transition name="to_P4" to="P4"></transition>
</task-node>
........
2 problems :
-First ,the variable "name" cannot be stored correctly.
-Second:My Timer cannot be started
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
19 years, 3 months
[JBoss JIRA] Created: (JBAS-4101) Authorization Interceptor throws ClassCastException
by Anil Saldhana (JIRA)
Authorization Interceptor throws ClassCastException
---------------------------------------------------
Key: JBAS-4101
URL: http://jira.jboss.com/jira/browse/JBAS-4101
Project: JBoss Application Server
Issue Type: Sub-task
Security Level: Public (Everyone can see)
Components: JMX, Security
Affects Versions: JBossAS-4.0.5.GA
Reporter: Anil Saldhana
Assigned To: Anil Saldhana
Fix For: JBossAS-4.2.0.GA
env.put(Context.SECURITY_CREDENTIALS, pass);
env.put(Context.SECURITY_PRINCIPAL, user);
...
MBeanServerConnection mbsc = (MBeanServerConnection) context.lookup("jmx/invoker/RMIAdaptor");
ObjectName dynMBeanName = new ObjectName("com.jboss.jmx.xmbeans:service=XFormatDateActually");
mbsc.setAttribute(dynMBeanName, new Attribute("Format", "DD/MM/YY"));
...
and the error is:
java.lang.ClassCastException: javax.management.Attribute
at org.jboss.jmx.connector.invoker.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:110)
at org.jboss.jmx.connector.invoker.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:108)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
19 years, 3 months