RE: offtopic question
It seems that now the latest MySql version (v.3.23.39) supports transactions. I have just tested it and everything seems to work fine. Regards, Vilavanh -Message d'origine- De : Lorenz, Manfred [mailto:[EMAIL PROTECTED]] Envoyé : 12 juillet, 2001 11:43 À : '[EMAIL PROTECTED]' Objet : AW: offtopic question You're not right. In the documentation about mysql i found the following: By default, MySQL runs in autocommit mode. This means that as soon as you execute an update, MySQL will store the update on disk. If you are using transactions safe tables (like BDB, InnoDB, you can put MySQL into non-autocommit mode with the following command: SET AUTOCOMMIT=0 After this you must use COMMIT to store your changes to disk or ROLLBACK if you want to ignore the changes you have made since the beginning of your transaction. If you want to switch from AUTOCOMMIT mode for one series of statements, you can use the BEGIN or BEGIN WORK statement: BEGIN; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; COMMIT; Note that if you are using non-transaction-safe tables, the changes will be stored at once, independent of the status of the autocommit mode. If you do a ROLLBACK when you have updated a non-transactional table you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning. All transactional safe tables will be restored but any non-transactional table will not change. If you are using BEGIN or SET AUTOCOMMIT=0, you should use the MySQL binary log for backups instead of the older update log. Transactions are stored in the binary log in one chunk, upon COMMIT, to ensure that transactions which are rolled back are not stored. See section 23.4 The Binary Log. There are some alternative table formats, with which you can have transactions with mysql nowadays. Regards Manfred -Ursprüngliche Nachricht- Von: Renzo Toma [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 12. Juli 2001 10:46 An: [EMAIL PROTECTED]; Aapo Laakkonen; [EMAIL PROTECTED] Betreff: RE: offtopic question You're right: MySQL does not have transactional support and does only do table locking (no row-locking like the big boys). -Original Message- From: Aapo Laakkonen [mailto:[EMAIL PROTECTED]] Sent: woensdag 11 juli 2001 18:45 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: offtopic question > message: transaction isolation levels not supported. > > That let me suppose that both MS Access and MySql jdbc drivers do not > support yet well the rowset package. I think that access and mysql doesn't support transactions or they do not support the isolation level that was requested by your application. ANSI SQL defines 4 isolation levels and if application wants to have let's say committed read isolation level and db doesn't support it or doens't support higher isolation levels (e.g. repeatable read or serializable) then they need to abort the transaction. Access is kind of one man db and it doesn't support transactions I think, but I'm not sure about MySQL, but what I can remember is that it doesn't support transactions.
offtopic question
Hi all, I am currently building a web application with Struts and I am facing the following problem. I am using the CachedRowSet class to retrieve data from my database. Actually, I have no trouble when I perform a SELECT query. However, when I perform an UPDATE, DELETE or INSERT query, I get the following error message: transaction isolation levels not supported. This exception seems to be thrown only with MS Access and MySql databases. With Oracle, no exception is thrown and everything seems to work fine ... That let me suppose that both MS Access and MySql jdbc drivers do not support yet well the rowset package. Has anyone ever had such experience of this issue ? or could anyone give me some explanations ? Thanks in advance, Vilavanh Messien
RE: i18n - stand for?
I18N stands for internationalization et 18 is the number of letters between I and N. Vilavanh -Message d'origine- De : mmuchnik [mailto:mmuchnik]De la part de Maya Muchnik Envoyé : 12 février, 2001 17:29 À : [EMAIL PROTECTED] Objet : i18n - stand for? It is simple question. I18N - what is it means? (Internationalization...) Thanks, Maya
Fruit Glaze Example
Hi ! I'm interested in getting the Fruit Glaze Example. Unfortunately, it is not available anymore on Ted's website. Is there anyone who could send me the zip file of this example ? (maybe Ted ... :-) ) Thanks in advance. Vilavanh Messien -Message d'origine- De : Ted Husted [mailto:[EMAIL PROTECTED]] Envoyé : 27 janvier, 2001 15:22 À : Struts List Objet : Re: Who is Craig ? >And, speak at various conferences, including ApacheCon and JavaOne. Don't imagine there's streaming media of that anyplace? -T.
RE: Sruts Mailing List Archive
Here you are : http://archive.covalent.net/ -Message d'origine- De : Evan Vaala [mailto:[EMAIL PROTECTED]] Envoyé : 6 décembre, 2000 12:39 À : [EMAIL PROTECTED] Objet : Sruts Mailing List Archive Is there a Struts Mailing List Archive somewhere? Thanks! Evan Vaala
RE: Example for Internationalization
Hi, I'm quite interested in your example. Can you post me your code ? Thanks -Message d'origine- De : Aditya Kapur [mailto:[EMAIL PROTECTED]] Envoyé : 6 décembre, 2000 12:22 À : Struts-User (E-mail) Objet : Example for Internationalization Hi All, I was building some prototype for my company and I have modified the Struts out-of-box example to add a language drop down on the Login page (which just displays English and German) and if the user logs in after selecting the language as German all the screens are in German. If anybody is interested I can post the modified example and the code. Aditya Kapur Office (248) 699 3275
RE: User error (mine)! Can't find application resource file?
You must indicate the complete path to ApplicationRessources.properties In the struts example, it is : org.apache.struts.example.ApplicationResources It means if your ApplicationResources is located in the package project/example, you should write something like this: project.example.ApplicationResources -Message d'origine- De : Mike Campbell [mailto:[EMAIL PROTECTED]] Envoyé : 28 novembre, 2000 12:52 À : [EMAIL PROTECTED] Objet : User error (mine)! Can't find application resource file? I've written a very small app using struts, and am stuck on the following problem. (See error log.) I think my setup is as close to the example (which works), and yet I can't seem to get past this. My ApplicationResources.properties is in /WEB-INF/classes/ApplicationResources.properties. My web.xml file lists: action org.apache.struts.action.ActionServlet application ApplicationResources config /WEB-INF/action.xml debug 9 The JSP file contains: <%@ taglib uri="/WEB-INF/struts.tld" prefix="struts" %> The first line in the ApplicationResources.properties is: enter.name.title=Enter Username And when I hit the app with the web browser, I get the following error. Any idea here? Internal Servlet Error: javax.servlet.ServletException: Missing resources attribute org.apache.struts.action.MESSAGE at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:453) at _0002fEnterName_0002ejspEnterName_jsp_5._jspService(_0002fEnterName_0002ejsp EnterName_jsp_5.java:291) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 9) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:745) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) Root cause: javax.servlet.jsp.JspException: Missing resources attribute org.apache.struts.action.MESSAGE at org.apache.struts.taglib.MessageTag.doStartTag(MessageTag.java:360) at _0002fEnterName_0002ejspEnterName_jsp_5._jspService(_0002fEnterName_0002ejsp EnterName_jsp_5.java:65) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 9) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:745) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484)
RE: need some explanations
Actually, I'm using Tomcat 3.2. If the prob comes from Tomcat, why the struts example has no trouble with it ? -Message d'origine- De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Envoyé : 24 novembre, 2000 16:00 À : [EMAIL PROTECTED] Objet : Re: need some explanations Vilavanh Messien wrote: > If I understand, destroy() should be called when the servlet container (i.e > Tomcat) is shutdown. > But, in my small application, destroy() seems not to be called so that > information cannot be > written database.xml. > I didn't manage to find where my error is. > Tomcat 3.2, right? There was a bug in Tomcat that causes this. It was recently fixed, and will work correctly in the upcoming final release. > > Thanks > Craig > > -Message d'origine- > De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] > Envoyé : 24 novembre, 2000 15:33 > À : [EMAIL PROTECTED] > Objet : Re: need some explanations > > Vilavanh Messien wrote: > > > I analyzed the struts example in order to develop my own small > application. > > Unfortunatelaty, I don't really understand how the user's information are > > saved > > in the "database.xml" file. > > The DatabaseServlet must write the information in the "database.xml" when > > the destroy() method > > is called. > > My question is how to make the destroy() method perform ? > > > > The destroy() method is called by the servlet container, when it removes > this > servlet from service or when the application is shut down. Typically, > server > shutdown is the *only* time that a servlet is removed and destroy() is > called. > > > > > How can I do to pass some arguments to the DatabaseServlet ? > > > > This is done by adding entries in the WEB-INF/web.xml file. > See > the Servlet API Specification, version 2.2, for the details -- you can > download > it at: > > http://java.sun.com/products/servlet/download.html > > There are also a growing number of articles and books covering the servlet > 2.2 > API that discusses this kind of thing. I would try looking for "web.xml" in > your favorite search engine, as a starting point. > > > > > Thanks > > > > Vilavanh > > Craig McClanahan
RE: need some explanations
If I understand, destroy() should be called when the servlet container (i.e Tomcat) is shutdown. But, in my small application, destroy() seems not to be called so that information cannot be written database.xml. I didn't manage to find where my error is. Thanks -Message d'origine- De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Envoyé : 24 novembre, 2000 15:33 À : [EMAIL PROTECTED] Objet : Re: need some explanations Vilavanh Messien wrote: > I analyzed the struts example in order to develop my own small application. > Unfortunatelaty, I don't really understand how the user's information are > saved > in the "database.xml" file. > The DatabaseServlet must write the information in the "database.xml" when > the destroy() method > is called. > My question is how to make the destroy() method perform ? > The destroy() method is called by the servlet container, when it removes this servlet from service or when the application is shut down. Typically, server shutdown is the *only* time that a servlet is removed and destroy() is called. > > How can I do to pass some arguments to the DatabaseServlet ? > This is done by adding entries in the WEB-INF/web.xml file. See the Servlet API Specification, version 2.2, for the details -- you can download it at: http://java.sun.com/products/servlet/download.html There are also a growing number of articles and books covering the servlet 2.2 API that discusses this kind of thing. I would try looking for "web.xml" in your favorite search engine, as a starting point. > > Thanks > > Vilavanh Craig McClanahan
RE: need some explanations
Thanks for your advice ! Nevertheless, I'd like to understand the mechanism used in the example. The load() method of DatabaseServlet is called during the init(). Thats'ok. But I don't know how to pass my parameters to the servlet in order to store them in a file. Could you explain me how it works ? -Message d'origine- De : Jim Richards [mailto:[EMAIL PROTECTED]] Envoyé : 23 novembre, 2000 20:40 À : [EMAIL PROTECTED] Objet : Re: need some explanations It's really only for an example. It you want real object persistence, you'll need to develop your owne layer. Something like EJB's will make this much, much easier. Or some direct JDBC code perhaps. Vilavanh Messien wrote: > > I analyzed the struts example in order to develop my own small application. > Unfortunatelaty, I don't really understand how the user's information are > saved > in the "database.xml" file. > The DatabaseServlet must write the information in the "database.xml" when > the destroy() method > is called. > My question is how to make the destroy() method perform ? > > How can I do to pass some arguments to the DatabaseServlet ? > > Thanks > > Vilavanh
need some explanations
I analyzed the struts example in order to develop my own small application. Unfortunatelaty, I don't really understand how the user's information are saved in the "database.xml" file. The DatabaseServlet must write the information in the "database.xml" when the destroy() method is called. My question is how to make the destroy() method perform ? How can I do to pass some arguments to the DatabaseServlet ? Thanks Vilavanh
RE: Struts/Java/Tomcat/Digester error?
I've already had this problem. I think it comes from the version of Struts you're using. Try with Tomcat 3.2b7 and Struts-20001114 build. It should work. Vilavanh Messien -Message d'origine- De : Mike Campbell [mailto:[EMAIL PROTECTED]] Envoyé : 15 novembre, 2000 16:24 À : struts; [EMAIL PROTECTED] Cc : Eric Baelen (E-mail); [EMAIL PROTECTED] Objet : Struts/Java/Tomcat/Digester error? All, When trying to run the struts example, it dies. We think here it's a lower level problem than struts, but are at a loss to figure out what. It SEEMS the Digester.getParser() dies whenever an XML file is trying to be read (the database.xml file can't be read and the action.xml file seems to have problems being read also). Tomcat is installed to the point where it CAN run servlets and JSP's successfully. I'm using it on NT in standalone mode (no apache). When Tomcat starts, here's the error. Anyone have any ideas here? Thanks. Digester.getParser: java.lang.SecurityException: sealing violation at java.net.URLClassLoader.defineClass(URLClassLoader.java:234) at java.net.URLClassLoader.access$100(URLClassLoader.java:56) at java.net.URLClassLoader$1.run(URLClassLoader.java:195) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:297) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286) at java.lang.ClassLoader.loadClass(ClassLoader.java:253) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:120) at javax.xml.parsers.SAXParserFactory.newInstance(SAXParserFactory.java:92) at org.apache.struts.digester.Digester.getParser(Digester.java:284) at org.apache.struts.digester.Digester.parse(Digester.java:748) at org.apache.struts.action.ActionServlet.initMapping(ActionServlet.java:619) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:291) at javax.servlet.GenericServlet.init(GenericServlet.java:258) at org.apache.tomcat.core.ServletWrapper.initServlet(ServletWrapper.java:315) at org.apache.tomcat.core.ServletWrapper.loadServlet(ServletWrapper.java:276) at org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartup Interceptor.java:132) at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:227) at org.apache.tomcat.core.ContextManager.init(ContextManager.java:201) at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:156) at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:163) -- Mike Campbell, R&D, Norcross, GA mailto: [EMAIL PROTECTED] +678.421.4641
RE: Help !!!
Actually, I've tried with Tomcat 3.2 and Struts 0.5 and it seems to work fine. I also tried with the example of Struts2000-11-10 and it didn't work. -Message d'origine- De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Envoyé : 11 novembre, 2000 20:05 À : [EMAIL PROTECTED] Objet : Re: Help !!! Vilavanh Messien wrote: > I think I've found the origin of my error. > The path to the "database.xml" file seems to be wrong. > Actually, it looks like : > "D:\Utils Java\jakarta-tomcat\webapps\struts-example\/WEB-INF/database.xml" > > As you can see, there's a prob in the path with the character "/" and "\". > > N.B: I work under Win98 OS. > Tomcat 3.1 also had problems with paths that have spaces in them. You'd be much better served running under Tomcat 3.2. Craig > > -Message d'origine- > De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] > Envoyé : 11 novembre, 2000 19:38 > À : [EMAIL PROTECTED] > Objet : Re: Help !!! > > Vilavanh Messien wrote: > > > Hi everybody !!! > > > > In order to test Struts framework, I've just downloaded > > and installed Tomcat 3.1 and Struts 0.5. > > > > I don't manage to install the struts example correctly. > > However, I've followed well all the instructions. > > I've copied struts-documentation.war and struts-example.war > > in tomcat/webapps directory and then I've restarted Tomcat server. > > > > Apparently, there's no prob with struts-documentation.war because > > I can browse the documentation of struts correctly with IE 5. > > > > Unfortunately, I still have some trouble with the struts example. > > I get an SecurityException each time I restart Tomcat. > > > > Can anyone help me ? > > > > Please post the log files and error traceback that you get. Without > those, it is not possible to know what is really going on. > > > > > Thanks a lot > > > > Vilavanh Messien > > Craig > > > Name: servlet.log >servlet.logType: unspecified type (application/octet-stream) > Encoding: quoted-printable > > Name: jasper.log >jasper.logType: unspecified type (application/octet-stream) > Encoding: quoted-printable > > Name: tomcat.log >tomcat.logType: unspecified type (application/octet-stream) > Encoding: quoted-printable
RE: Help !!!
I think I've found the origin of my error. The path to the "database.xml" file seems to be wrong. Actually, it looks like : "D:\Utils Java\jakarta-tomcat\webapps\struts-example\/WEB-INF/database.xml" As you can see, there's a prob in the path with the character "/" and "\". N.B: I work under Win98 OS. -Message d'origine- De : Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Envoyé : 11 novembre, 2000 19:38 À : [EMAIL PROTECTED] Objet : Re: Help !!! Vilavanh Messien wrote: > Hi everybody !!! > > In order to test Struts framework, I've just downloaded > and installed Tomcat 3.1 and Struts 0.5. > > I don't manage to install the struts example correctly. > However, I've followed well all the instructions. > I've copied struts-documentation.war and struts-example.war > in tomcat/webapps directory and then I've restarted Tomcat server. > > Apparently, there's no prob with struts-documentation.war because > I can browse the documentation of struts correctly with IE 5. > > Unfortunately, I still have some trouble with the struts example. > I get an SecurityException each time I restart Tomcat. > > Can anyone help me ? > Please post the log files and error traceback that you get. Without those, it is not possible to know what is really going on. > > Thanks a lot > > Vilavanh Messien Craig servlet.log jasper.log tomcat.log
Help !!!
Hi everybody !!! In order to test Struts framework, I've just downloaded and installed Tomcat 3.1 and Struts 0.5. I don't manage to install the struts example correctly. However, I've followed well all the instructions. I've copied struts-documentation.war and struts-example.war in tomcat/webapps directory and then I've restarted Tomcat server. Apparently, there's no prob with struts-documentation.war because I can browse the documentation of struts correctly with IE 5. Unfortunately, I still have some trouble with the struts example. I get an SecurityException each time I restart Tomcat. Can anyone help me ? Thanks a lot Vilavanh Messien