Oracle data-source problem with struts 1.1
Hi, I recently upgraded my struts setup to the 1.1 release version. Now I find that the data source used by my application to connect to the database no longer works: data-sources data-source key=db.user set-property property=url value=jdbc:oracle:thin:user/[EMAIL PROTECTED]:1521:milk/ set-property property=autoCommit value=false/ set-property property=description value=Taco User Account/ !-- set-property property=driverClass value=oracle.jdbc.driver.OracleDriver/ -- set-property property=driverClass value=oracle.jdbc.pool.OracleConnectionPoolDataSource / set-property property=maxCountvalue=5/ set-property property=minCountvalue=2/ /data-source /data-sources If left like this, the container (tomcat) fails to start with the exception: java.lang.NullPointerException at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:258) at java.lang.ClassLoader.loadClass(ClassLoader.java:255) at org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source) at org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source) at org.apache.struts.util.RequestUtils.applicationClass(RequestUtils.java:163) at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:187) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:813) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:389) at javax.servlet.GenericServlet.init(GenericServlet.java) at org.apache.catalina.core.StandardWrapper.loadServlet(Unknown Source) at org.apache.catalina.core.StandardWrapper.load(Unknown Source) I've tried adding type=oracle.jdbc.pool.OracleConnectionPoolDataSource to the data source element. This causes the following exception: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130) at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:966) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:134) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:108) at taco.struts.GetCourseWorkAction.execute(GetCourseWorkAction.java:39) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264) I've tried giving the URL without the username/password and setting them in properties. Nothing seems to work. Any suggestions would be very much appreciated. As I said, all this worked before upgrading the struts jars. Richard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Oracle data-source problem with struts 1.1
Hi, I stumbled upon the same thing.. The property url is URL (all uppercase) with the OracleDataSource ;-) HTH, Yann I recently upgraded my struts setup to the 1.1 release version. Now I find that the data source used by my application to connect to the database no longer works: data-sources data-source key=db.user set-property property=url value=jdbc:oracle:thin:user/[EMAIL PROTECTED]:1521:milk/ set-property property=autoCommit value=false/ set-property property=description value=Taco User Account/ !-- set-property property=driverClass value=oracle.jdbc.driver.OracleDriver/ -- set-property property=driverClass value=oracle.jdbc.pool.OracleConnectionPoolDataSource / set-property property=maxCountvalue=5/ set-property property=minCountvalue=2/ /data-source /data-sources If left like this, the container (tomcat) fails to start with the exception: java.lang.NullPointerException at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:258) at java.lang.ClassLoader.loadClass(ClassLoader.java:255) at org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source) at org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown Source) at org.apache.struts.util.RequestUtils.applicationClass(RequestUtils.java:163) at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:18 7) at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j ava:813) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:389) at javax.servlet.GenericServlet.init(GenericServlet.java) at org.apache.catalina.core.StandardWrapper.loadServlet(Unknown Source) at org.apache.catalina.core.StandardWrapper.load(Unknown Source) I've tried adding type=oracle.jdbc.pool.OracleConnectionPoolDataSource to the data source element. This causes the following exception: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130) at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:966) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:134) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:108) at taco.struts.GetCourseWorkAction.execute(GetCourseWorkAction.java:39) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:449) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264) I've tried giving the URL without the username/password and setting them in properties. Nothing seems to work. Any suggestions would be very much appreciated. As I said, all this worked before upgrading the struts jars. Richard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
data-source problem
Hi, I have a problem with data-source usage in Struts 1.1 When we had data-source defined in struts-config.xml without key attribute is working just fine: data-sources data-source set-property property=driverClass value=com.sybase.jdbc2.jdbc.SybDriver / set-property property=url value=jdbc:sybase:Tds:server:port/db / set-property property=maxCount value=10 / set-property property=minCount value=1 / set-property property=user value=user / set-property property=password value=pass / /data-source /data-sources In this case I established connection to default data-source using Action.DATA_SOURCE_KEY: ServletContext context = servlet.getServletContext(); DataSource dataSource = (DataSource) context.getAttribute(Action.DATA_SOURCE_KEY); Connection conn = dataSource.getConnection(); But as soon as I add key attribute to datasource: data-source key=ds1 ... /data-source and trying to getAttribute by key: ... DataSource dataSource = (DataSource) context.getAttribute(ds1); ... I have NullPointer Exception on any DB call I have. I would appreciate any advise/suggestion on this. Thank you, Eugene - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: data-source problem
Are u using an Action if so try getDatasource( httpServletRequest , ds1 ); as the Action has a method for getting a datasource On Friday 21 March 2003 2:32 pm, Eugene Volynskiy wrote: Hi, I have a problem with data-source usage in Struts 1.1 When we had data-source defined in struts-config.xml without key attribute is working just fine: data-sources data-source set-property property=driverClass value=com.sybase.jdbc2.jdbc.SybDriver / set-property property=url value=jdbc:sybase:Tds:server:port/db / set-property property=maxCount value=10 / set-property property=minCount value=1 / set-property property=user value=user / set-property property=password value=pass / /data-source /data-sources In this case I established connection to default data-source using Action.DATA_SOURCE_KEY: ServletContext context = servlet.getServletContext(); DataSource dataSource = (DataSource) context.getAttribute(Action.DATA_SOURCE_KEY); Connection conn = dataSource.getConnection(); But as soon as I add key attribute to datasource: data-source key=ds1 ... /data-source and trying to getAttribute by key: ... DataSource dataSource = (DataSource) context.getAttribute(ds1); ... I have NullPointer Exception on any DB call I have. I would appreciate any advise/suggestion on this. Thank you, Eugene - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: data-source problem
Unfortunately still does not work. Same error.Any other ideas? -Original Message- From: Stephen Smithstone [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 11:24 AM To: Struts Users Mailing List Subject: Re: data-source problem Are u using an Action if so try getDatasource( httpServletRequest , ds1 ); as the Action has a method for getting a datasource On Friday 21 March 2003 2:32 pm, Eugene Volynskiy wrote: Hi, I have a problem with data-source usage in Struts 1.1 When we had data-source defined in struts-config.xml without key attribute is working just fine: data-sources data-source set-property property=driverClass value=com.sybase.jdbc2.jdbc.SybDriver / set-property property=url value=jdbc:sybase:Tds:server:port/db / set-property property=maxCount value=10 / set-property property=minCount value=1 / set-property property=user value=user / set-property property=password value=pass / /data-source /data-sources In this case I established connection to default data-source using Action.DATA_SOURCE_KEY: ServletContext context = servlet.getServletContext(); DataSource dataSource = (DataSource) context.getAttribute(Action.DATA_SOURCE_KEY); Connection conn = dataSource.getConnection(); But as soon as I add key attribute to datasource: data-source key=ds1 ... /data-source and trying to getAttribute by key: ... DataSource dataSource = (DataSource) context.getAttribute(ds1); ... I have NullPointer Exception on any DB call I have. I would appreciate any advise/suggestion on this. Thank you, Eugene - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Multiple Data-Source Problem
How do access multiple data-sources' in an application. Here are may data-source's data-sources data-source set-property property=key value=MRA/ set-property property=driverClass value =oracle.jdbc.driver.OracleDriver/ set-property property=url value=jdbc:oracle:thin: @147.101.104.63:1524:common/ set-property property=user value=MRA/ set-property property=password value=mralog/ /data-source data-source set-property property=key value=PHONE_DB/ set-property property=driverClass value =oracle.jdbc.driver.OracleDriver/ set-property property=url value=jdbc:oracle:thin: @oid:1521:infoprd/ set-property property=user value=info_user/ set-property property=password value=info_user/ /data-source /data-sources Thank you Tim Bachta Information Technology MC 48 816-997-7137 -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: data-source problem
Look at your servlet engine log (servlet.log if you are using Tomcat with the default setup). Most likely the ActionServlet associated with your web app is not loading because the data source initialization is failing. The mappings aren't there because the initialization failed. The error message will (hopefully) tell you why. Make sure that you have the Oracle JDBC driver jar in your application's WEB-INF/lib. slickdev wrote: I have a problem with the data-source properties in struts-config.xml This is for the sample email portal application. I configured the properties to use my localhost oracle installation, which does work with jdbc from command-line java apps as well as with sql*plus. Here is the suspect layout: data-sources data-source set-property property=autoCommit value=false/ set-property property=description value=Oracle Data Source Configuration/ set-property property=maxCount value=4/ set-property property=minCount value=2/ set-property property=driverClass value=oracle.jdbc.driver.OracleDriver/ set-property property=url value=jdbc:oracle:thin:@localhost:1521:oracle/ set-property property=user value=system/ set-property property=password value=manager/ /data-source /data-sources PROBLEM When clicking the initial logon link to invoke logon.jsp, an exception occurs: javax.servlet.ServletException: Cannot find ActionMappings orActionFormBeans collection at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:460) at logon_1._jspService(logon_1.java:691) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java) --- --- --- The exception does not occur if the stuff between data-source --- /data-source is commented out. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
data-source problem
I have a problem with the data-source properties in struts-config.xml This is for the sample email portal application. I configured the properties to use my localhost oracle installation, which does work with jdbc from command-line java apps as well as with sql*plus. Here is the suspect layout: data-sources data-source set-property property=autoCommit value=false/ set-property property=description value=Oracle Data Source Configuration/ set-property property=maxCount value=4/ set-property property=minCount value=2/ set-property property=driverClass value=oracle.jdbc.driver.OracleDriver/ set-property property=url value=jdbc:oracle:thin:localhost:1521:oracle/ set-property property=user value=system/ set-property property=password value=manager/ /data-source /data-sources PROBLEM When clicking the initial logon link to invoke logon.jsp, an exception occurs: javax.servlet.ServletException: Cannot find ActionMappings orActionFormBeans collection at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:460) at logon_1._jspService(logon_1.java:691) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java) --- --- --- The exception does not occur if the stuff between data-source --- /data-source is commented out.
RE: data-source problem
have u got this declaration just before the form-beans ... /form-beans declaration! -Original Message- From: slickdev [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 June 2002 12:12 PM To: Struts Users Mailing List Subject: data-source problem I have a problem with the data-source properties in struts-config.xml This is for the sample email portal application. I configured the properties to use my localhost oracle installation, which does work with jdbc from command-line java apps as well as with sql*plus. Here is the suspect layout: data-sources data-source set-property property=autoCommit value=false/ set-property property=description value=Oracle Data Source Configuration/ set-property property=maxCount value=4/ set-property property=minCount value=2/ set-property property=driverClass value=oracle.jdbc.driver.OracleDriver/ set-property property=url value=jdbc:oracle:thin:@localhost:1521:oracle/ set-property property=user value=system/ set-property property=password value=manager/ /data-source /data-sources PROBLEM When clicking the initial logon link to invoke logon.jsp, an exception occurs: javax.servlet.ServletException: Cannot find ActionMappings orActionFormBeans collection at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:460) at logon_1._jspService(logon_1.java:691) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java) --- --- --- The exception does not occur if the stuff between data-source --- /data-source is commented out.