Mark Hissink Muller

All,

Kindly I would like to request help on accessing a 'security_role protected' EJB on WebSphere 4.0.x from a client-application.

Since currently I don't provide the correct credentials, I get a CSIException [1]

Can anyone point me to an example of how to provide the correct username/password for a particular role?

Thanks,
- Mark

[1] - com.ibm.websphere.csi.CSIException: SECJ0053E: Authorization failed for /UNAUTHENTICATED while invoking (Home)ejb/bean_name create:0 securityName: /UNAUTHENTICATED;accessID

Thanks for your thoughs Jeanne. I solved it like this:

public void testLoadDatabase() throws Exception { Connection connection = getConnection(); Statement statement = connection.createStatement(); String sql = readSqlFromFile("file.sql"); StringTokenizer semiColonTokenizer = new StringTokenizer(sql, ";"); int counter = 0; while (semiColonTokenizer.hasMoreTokens()) { String nextToken = (String)semiColonTokenizer.nextToken(); // prevent bogus queries from being added if (nextToken.length() > 10) { statement.addBatch(nextToken+";"); counter++; } } System.out.println("counter = "+counter); int[] result = statement.executeBatch(); statement.close(); connection.close(); }

Kindly I would like to ask what is the preferred way of loading a file containing multiple sql-statements (CREATEs and INSERTs) into a (MySQL) database?

In the setUp()-method of a JUnit-test, I would like to freshen up the test-database by dropping all tables and loading a new default state. Since some of the INSERT-statements contain quotes (") or other special characters, I cannot just load everything into a single Statement.

Is there a convenient way to encode the data so it can be used in a simple statement.executeQuery(sql)?

Thanks for your time,
Mark

All,
Kindly I would like to ask your help regarding a problem I have with a self-assembled EAR (using Ant), when testing under WSAD/WAS. Although I read Barry Searle's article at:
http://www7b.software.ibm.com/wsdd/library/techarticles/0203_searle/searle1.html
I would like to build the EAR-file completely detached from WSAD, with an Ant-script which automatically 'gets' from CVS, runs all the Unit-tests and if correct assembles the EAR. I've written a series of Ant-scripts which zip-up an EAR from all components, which I build separately.
(To my surprise) I've noticed that using a standard application.xml-file from another (exported) EAR doesn't do the job and gives me ClassNotFoundExceptions when starting the application. In some way a reference to the jar is missing. I suspect it might have to do with with the module_id in the application.xml which in some way doesn't match to id in the jar, but I could not find any info and I'm not 100% sure.
<module id="EjbModule_1063637237627">
<ejb>SomeEJB.jar</ejb>
</module>
Could anyone explain me what kind of issue I'm encountering and how to solve this?
Thanks for your insights.
Regards,
Mark Hissink Muller