I am trying to develop a CMP Entity bean and I am having lots of problems.
When I try to start up my JRun server that has my deployed EJB it won't
start. Here is the error in the event log.
11/13 08:28:17 error (JRun) The ejb service failed to load. Please verify
that you are using a Java Virtual Machine version 1.2 or higher.
11/13 08:28:17 error (JRun) JRun Aborting! [javax.servlet.ServletException:
The url cannot be null]
[2]java.sql.SQLException: The url cannot be null
at java.sql.DriverManager.getConnection(DriverManager.java:494)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at allaire.ejipt._ejb._DataSource._createConnection
(_DataSource.java:203)
at allaire.ejipt._ejb._ConnectionPool._getConnection
(_ConnectionPool.java:147)
at allaire.ejipt._ejb._DataSource.<init>(_DataSource.java:345)
at allaire.ejipt._ejb._DataSource._createSources(_DataSource.java:78)
at allaire.ejipt.Ejipt.<init>(Ejipt.java:335)
at allaire.jrun.ejb.EjbServer.<init>(EjbService.java:171)
at allaire.jrun.ejb.EjbService.init(EjbService.java:71)
at allaire.jrun.ServletService.init(ServletService.java:66)
at allaire.jrun.ServletService.init(ServletService.java:31)
at
allaire.jrun.servlet.JRunServletLoader.loadServletInstance(JRunServletLoader.java:236)
at allaire.jrun.servlet.JRunSE.initServices(JRunSE.java:620)
at allaire.jrun.servlet.JvmContext.initServices(JvmContext.java:96)
at allaire.jrun.servlet.JRunSE.init(JRunSE.java:187)
at allaire.jrun.servlet.JvmContext.init(JvmContext.java:35)
at allaire.jrun.ServletService.init(ServletService.java:66)
at allaire.jrun.ServletService.init(ServletService.java:31)
at JRun.main(JRun.java:154)
[1]javax.servlet.ServletException: The url cannot be null
at allaire.jrun.ejb.EjbService.init(EjbService.java:83)
at allaire.jrun.ServletService.init(ServletService.java:66)
at allaire.jrun.ServletService.init(ServletService.java:31)
at
allaire.jrun.servlet.JRunServletLoader.loadServletInstance(JRunServletLoader.java:236)
at allaire.jrun.servlet.JRunSE.initServices(JRunSE.java:620)
at allaire.jrun.servlet.JvmContext.initServices(JvmContext.java:96)
at allaire.jrun.servlet.JRunSE.init(JRunSE.java:187)
at allaire.jrun.servlet.JvmContext.init(JvmContext.java:35)
at allaire.jrun.ServletService.init(ServletService.java:66)
at allaire.jrun.ServletService.init(ServletService.java:31)
at JRun.main(JRun.java:154)
[0]javax.servlet.ServletException: The url cannot be null
at allaire.jrun.ServletService.init(ServletService.java:33)
at
allaire.jrun.servlet.JRunServletLoader.loadServletInstance(JRunServletLoader.java:236)
at allaire.jrun.servlet.JRunSE.initServices(JRunSE.java:620)
at allaire.jrun.servlet.JvmContext.initServices(JvmContext.java:96)
at allaire.jrun.servlet.JRunSE.init(JRunSE.java:187)
at allaire.jrun.servlet.JvmContext.init(JvmContext.java:35)
at allaire.jrun.ServletService.init(ServletService.java:66)
at allaire.jrun.ServletService.init(ServletService.java:31)
at JRun.main(JRun.java:154)
I have defined the datasource in the JMC as StoneDB. I have tested this
DataSource with the test function in the JMC. The test works properly.
Here is how I have defined my deploy.properties. I don't know if the
problem is in how I defined the deploy.properties or some where else. I
don't feel that they have given us very good documentation on the subject
of CMP EJBs. If anyone could shed some light I would appreciate it.
ejipt.jdbcSources=StoneDB
ejipt.isCreateSilent=false
ejipt.createSQL=SELECT (name, password) FROM infocus_users WHERE userid
\= ?
ejipt.createSQL.params=id
ejipt.createSQL.fields=name, password
ejipt.createSQL.paramTypes=INTEGER
ejipt.createSQL.source=StoneDB
ejipt.postCreateSQL=INSERT INTO infocus_users (userid, name, password)
VALUES (?,?,?)
ejipt.postCreateSQL.params=id,name,password
ejipt.postCreateSQL.paramTypes=INTEGER,STRING,STRING
ejipt.postCreateSQL.source=StoneDB
ejipt.loadSQL=SELECT (name, password) FROM infocus_users WHERE userid \= ?
ejipt.loadSQL.params=id
ejipt.loadSQL.paramTypes=INTEGER
ejipt.loadSQL.fields=name,password
ejipt.loadSQL.source=StoneDB
ejipt.storeSQL=UPDATE infocus_users SET name \= ?, password \= ? WHERE
userid \= ?
ejipt.storeSQL.params=name,password
ejipt.storeSQL.paramTypes=STRING, STRING
ejipt.storeSQL.source=StoneDB
Thanks for any help,
Adam
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
