This page contains an archived post to the Java Answers Forum made prior to February 25, 2002.
If you wish to participate in discussions, please visit the new
Artima Forums.
Message:
Remote Exception EJB with Mysql
Posted by najmi on March 27, 2001 at 6:01 AM
I am working on a class project and am having a problem connecting between the J2EE Reference Implementation Server and MySql. I have set-up the defualt.properties file for MySql # JDBC Driver Examples: # Oracle thin driver: oracle.jdbc.driver.OracleDriver # Merant driver: intersolv.jdbc.sequelink.SequeLinkDriver # Cloudscape driver: COM.cloudscape.core.RmiJdbcDriver # MySQL driver: org.gjt.mm.mysql.Driver # #jdbc.drivers=org.gjt.mm.mysql.Driver #jdbc.drivers=COM.cloudscape.core.RmiJdbcDriver jdbc.drivers=org.gjt.mm.mysql.Driver|COM.cloudscape.core.RmiJdbcDriver
# JDBC URL Examples: # Oracle thin driver: # jdbc:oracle:thin:@:: # Cloudscape RMI driver: # jdbc:cloudscape:rmi:;create=true # Merant driver: # jdbc:sequelink://:/[SQLServer];Database= # # MySQL driver: # jdbc:mysql://:/ #jdbc.datasources=jdbc/Cloudscape|jdbc:cloudscape:rmi:CloudscapeDB;create=true #jdbc.datasources=jdbc/Mysql|jdbc:mysql://localhost:3306/ThePackED? #jdbc.datasources=jdbc/Cloudscape|jdbc:cloudscape:rmi:CloudscapeDB;create=true jdbc.datasources=jdbc/mysql|jdbc:mysql://localhost:3306/ThePackED|jdbc/Cloudscape|jdbc:cloudscape:rmi:CloudscapeDB;create=true Here is the code in a sample EJB for making a connection /** * a logical database name to be used to access data * this will be remove after we are able to use * the connection manager. */ private String dbName = "java:comp/env/jdbc/ThePackED"; /** * make a connection with the MySQL database via a Application Server */ private void makeConnection() throws NamingException, SQLException { InitialContext ic = new InitialContext(); DataSource ds = (DataSource)ic.lookup(dbName); conn = ds.getConnection(); } And here is the client information public class GenerateDocumentListClient { public static void main(String[] args) { try { Context initial = new InitialContext(); Object objref = initial.lookup("GenerateDocumentListBean"); GenerateDocumentListHome home = (GenerateDocumentListHome)PortableRemoteObject.narrow(objref, GenerateDocumentListHome.class); GenerateDocumentList aGenerateDocumentList = home.create(); // write your test code here System.out.println("aGenerateDocumentList = " + aGenerateDocumentList); System.out.println(aGenerateDocumentList.getProjectListTable()); aGenerateDocumentList.remove(); } catch (Exception ex) { System.err.println("Caught an unexpected exception!"); ex.printStackTrace(); } } } Here is what the application tells me // this is the value of aGenerateDocumentList after the home.create method call aGenerateDocumentList =IOR:0000000000000034524d493a7265706f7274696e672e47656e6572617465446f63756d656e744c6973743a30303030303030303030303030303030000000000100000000000000de000101000000000e3139322e3136382e312e3130320004de00000021afabcafe00000020b25dc41b000000020000000d0000000004000000040000000100000000000002000000010000001400000000000100200000000000010100000000000000001900000076000000000000006e66696c653a2f633a2f6a3273646b6565312e322e312f7265706f7369746f72792f57323030302f6170706c69636174696f6e732f5265706f7274696e67436c69656e742e6a617220687474703a2f2f57323030303a393139312f5265706f7274696e67436c69656e742e6a61720 when I try to execute the business method getProjectList I get this: Caught an unexpected exception! java.rmi.ServerException: RemoteException occurred in server thread; nested exception is: java.rmi.RemoteException: Unknown Exception/Error thrown by EJB method.; nested exception is: javax.ejb.EJBException java.rmi.RemoteException: Unknown Exception/Error thrown by EJB method.; nested exception is: javax.ejb.EJBException javax.ejb.EJBException <> If anyone could tell me whats wrong or give me an example or sample code for setting up the bean, client I would greatly appreciate it! Thanks! najmi
Replies:
- JDBC chris Long July 23, 2001 at 5:16 AM
(0)
|