[JBoss-user] [Persistence & CMP/JBoss] - Datasource Username/Password

2004-04-07 Thread michaellee
Hi, If a datasource contain confidential information, i feel better not to specify username/password in the datasource configure file and request the application to provide this information when getConnection(). By doing this, just getting the JNDI name of the datasource cannot retrieve informa

[JBoss-user] [Security & JAAS/JBoss] - Re: userid/password for CMP

2004-04-06 Thread michaellee
Actually, i am new to J2EE Application server and just develop a simple application. What i am thinking is: In the development environment, jmx-console is not protected and each programmer can use the JNDIViewer to obtain the JNDI name defined for the datasource. Afterward, a simple JSP may be

[JBoss-user] [Security & JAAS/JBoss] - Re: userid/password for CMP

2004-04-06 Thread michaellee
Martin, Thanks for your information. Using the proposed method, the database password can be encrypted and not readable in the config file. However, by using JNDI lookup for the datasource, then call getConnection using the return datasource, a connection will be created to access the databas

[JBoss-user] [Security & JAAS/JBoss] - userid/password for CMP

2004-04-05 Thread michaellee
Hi, I have successfully deployed CMP entity bean using hardcoded userid and password in database connection setup. (in my case, it is sybase-service.xml). I have set security control on the ejb-jar.xml so that only user with specified role can access and manipulate the bean. Every thing seems o

[JBoss-user] [EJB/JBoss] - static JNDI lookup for Session Bean

2004-04-02 Thread michaellee
Hi, I have created an stateless session bean. This bean will access 3 other entity bean on the same application. I would like to use 3 static (class) variables to store the home interface of the related entity bean. something like : private static OperatorLocalHome operatorHome; private

[JBoss-user] [Persistence & CMP/JBoss] - Re: Syntax Error on Generated SQL

2004-04-02 Thread michaellee
Thank you for the suggestion. Using , the problem is fixed. Regadrs, Michael View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828985#3828985 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828985 ---

[JBoss-user] [Persistence & CMP/JBoss] - Syntax Error on Generated SQL

2004-04-02 Thread michaellee
Hi, The sql generated from my ejbSelect method is as follows: SELECT t0_r.name FROM operator t1_o, roleTable t0_r WHERE t1_o.name = ? AND (EXISTS (SELECT t3_o_roles_RELATION_TABLE.projectID, t3_o_roles_RELATION_TABLE.roleName FROM operatorRoles t3_o_roles_RELATION_TABLE WHERE t1

[JBoss-user] [EJB/JBoss] - access ejb-local-ref in Web.xml

2004-04-01 Thread michaellee
Hi, I have deployed an session bean with both local and remote interface on Jboss 3.0.6. When access the EJB on another Web application, if i use in web.xml and access remote interface, it work. (with jndi specified in jboss-web.xml). If using , naming exception throw when deploy the web appli

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-07 Thread michaellee
Dear SG, I have extracted orcale-xa-ds from 3.2.3 and modified it for sybase. I have not tested it (since 3.2 not setup) but i think it should work (may be after some minor change). Please try it out (with parameter modified to suit you environment) and inform me the result. Regards, Michael

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-07 Thread michaellee
Dear SG, AFAIK, the XML format for 3.2 and 3.0 is different (may be totally). Since i am using 3.0.6, i do not know what should be changed to make it work on 3.2. However, if you refer to the sample sybase -ds xml provided with jboss (not xa), you should get some hint to perform the amendment.

[JBoss-user] [Datasource Configuration] - Re: Sybase XADataSource

2004-03-02 Thread michaellee
The sybase-xa-service.xml seem to be corrupted during cut and pate. Following is the content. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | jdbc/SybaseFMS

[JBoss-user] [Datasource Configuration] - Sybase XADataSource

2004-03-02 Thread michaellee
I have just set up an XADataSource for ASE 12.5 using jConnect 5.5 on Jboss 3.0.6. Since it is not so straightforward, i would like to share it with anyone interested. Following modification is required: . ra.xml inside jboss-xa.rar - for 3.0.6, there is a problem (seem to be a bug and should

[JBoss-user] [Datasource Configuration] - Wrong Database used

2004-03-01 Thread michaellee
Hi, I am using Jboss 3.0.6 with sybase ase 12.5 (JConnect 5.5). When backend database restart (after failure), connection to the database server is allowed but individual database cannot be accessed until recovery complete. Under such a situation, the "master" database is used (a warning messag