> You probably have to put it in the 'endorsed' dir.

I placed them in CATALINE_HOME/common/lib/ and those errors went away.

Now I find that I cannot use a GQM to create a table.

It appears that Rife is creating SQL statements with incorrect syntax.

Is there any info I could provide that would help debug this ? 

Here is a stack trace:

com.uwyn.rife.database.exceptions.ExecutionErrorException: Error while 
executing the SQL 'CREATE TABLE evntbean (_uuid INTEGER, code VARCHAR(32672), 
contentReferentCID VARCHAR(32672), contentReferentCTyp VARCHAR(32672), 
contentReferentClsNm VARCHAR(32672), createdT BIGINT, desk VARCHAR(32672), 
eventTime BIGINT NOT NULL, eventType INTEGER NOT NULL, id INTEGER NOT NULL 
GENERATED ALWAYS AS IDENTITY, inactiveT BIGINT, lastmodT BIGINT, long 
VARCHAR(32672), owningGroup VARCHAR(32672), username VARCHAR(20) NOT NULL, 
ussnUuid INTEGER NOT NULL, visibility INTEGER, PRIMARY KEY (id), CHECK 
(username != ''))'.
        at 
com.uwyn.rife.database.DbStatement.executeUpdate(DbStatement.java:648)
        at 
com.uwyn.rife.database.DbStatement.executeUpdate(DbStatement.java:675)
        at 
com.uwyn.rife.database.DbQueryManager.executeUpdate(DbQueryManager.java:175)
        at 
com.uwyn.rife.database.querymanagers.generic.databasedrivers.org_apache_derby_jdbc_EmbeddedDriver.install(org_apache_derby_jdbc_EmbeddedDriver.java:66)
        at wa.DRecords.install(DRecords.java:349)
        at wa.admin.ReinstallDB.doConfirmation(ReinstallDB.java:31)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at 
com.uwyn.rife.engine.ElementContext.processContext(ElementContext.java:594)
        at com.uwyn.rife.engine.RequestState.service(RequestState.java:217)
        at com.uwyn.rife.engine.Gate.handleRequest(Gate.java:422)
        at com.uwyn.rife.engine.Gate.handleRequest(Gate.java:240)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.uwyn.rife.servlet.RifeFilter.doFilter(RifeFilter.java:112)
        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:868)
        at 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
        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(Thread.java:595)
Caused by: SQL Exception: Syntax error: Encountered "_" at line 1, column 24.
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown 
Source)
        at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
Source)
        at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown 
Source)
        at 
com.uwyn.rife.database.DbStatement.executeUpdate(DbStatement.java:640)
        ... 32 more

_______________________________________________
Rife-users mailing list
[email protected]
http://www.uwyn.com/mailman/listinfo/rife-users

Reply via email to