Hi!!.
I install the anyware.war application in a tomcat server 5.5.9 with jdk 1.5.0_04
I put some driver (ORacle, informix and Mysql) in the appropriate directory.
But when I try to create a connection, i have this error in my browser
excepcin
javax.servlet.ServletException: could not insert: [org.sqlanyware.model.hibernate.ConnectionDesc#x2ifx1]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.sqlanyware.struts.ConnectionFilter.doFilter(ConnectionFilter.java:60)
[2005-09-20 15:21:03,671] [INFO] [org.sqlanyware] - HTTP Session Created
[2005-09-20 15:21:21,109] [ERROR] [org.sqlanyware] - Error while loading com.mysql.jdbc.integration.c3p0.MysqlConnectionTester
java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/QueryConnectionTester
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at org.sqlanyware.utilities.ZipFilesClassLoader.loadClassFromZip(ZipFilesClassLoader.java:109)
at org.sqlanyware.utilities.ZipFilesClassLoader.loadClass(ZipFilesClassLoader.java:82)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.sqlanyware.utilities.ExtendedClassLoader.findClassImplementing(ExtendedClassLoader.java:69)
at org.sqlanyware.model.DirectoryDriverManager.getDriverClassNames(DirectoryDriverManager.java:184)
at org.sqlanyware.model.DirectoryDriverManager.getDriverArchiveDescs(DirectoryDriverManager.java:345)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185)
at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772)
at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801)
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:1008)
at org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:232)
at org.apache.jsp.drivermanager_jsp._jspService(org.apache.jsp.drivermanager_jsp:168)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.sqlanyware.struts.ConnectionFilter.doFilter(ConnectionFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi!!.
I install the anyware.war application in a tomcat server 5.5.9 with jdk 1.5.0_04
I put some driver (ORacle, informix and Mysql) in the appropriate directory.
But when I try to create a connection, i have this error in my browser
excepcin
javax.servlet.ServletException: could not insert: [org.sqlanyware.model.hibernate.ConnectionDesc#x2ifx1]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.sqlanyware.struts.ConnectionFilter.doFilter(ConnectionFilter.java:60)
causa raz
net.sf.hibernate.exception.SQLGrammarException: could not insert: [org.sqlanyware.model.hibernate.ConnectionDesc#x2ifx1]
net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1332)
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:474)
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:438)
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2260)
net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
org.sqlanyware.model.hibernate.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:200)
org.sqlanyware.model.hibernate.base._BaseRootDAO.save(_BaseRootDAO.java:629)
org.sqlanyware.model.hibernate.base.BaseConnectionDescDAO.save(BaseConnectionDescDAO.java:72)
org.sqlanyware.struts.actions.CommitEditConnectionAction.execute(CommitEditConnectionAction.java:68)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.sqlanyware.struts.ConnectionFilter.doFilter(ConnectionFilter.java:60)
And This in my log file
[2005-09-20 15:21:03,671] [INFO] [org.sqlanyware] - HTTP Session Created
[2005-09-20 15:21:21,109] [ERROR] [org.sqlanyware] - Error while loading com.mysql.jdbc.integration.c3p0.MysqlConnectionTester
java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/QueryConnectionTester
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at org.sqlanyware.utilities.ZipFilesClassLoader.loadClassFromZip(ZipFilesClassLoader.java:109)
at org.sqlanyware.utilities.ZipFilesClassLoader.loadClass(ZipFilesClassLoader.java:82)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.sqlanyware.utilities.ExtendedClassLoader.findClassImplementing(ExtendedClassLoader.java:69)
at org.sqlanyware.model.DirectoryDriverManager.getDriverClassNames(DirectoryDriverManager.java:184)
at org.sqlanyware.model.DirectoryDriverManager.getDriverArchiveDescs(DirectoryDriverManager.java:345)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1185)
at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772)
at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801)
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:1008)
at org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:232)
at org.apache.jsp.drivermanager_jsp._jspService(org.apache.jsp.drivermanager_jsp:168)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.sqlanyware.struts.ConnectionFilter.doFilter(ConnectionFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)