No, it seems that your uuid property starts with an underscore and
that Derby doesn't allow column names to start like that.
On 18-dec-05, at 21:03, F Baube wrote:
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_apach
e_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
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage, Belgium
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03
PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net
_______________________________________________
Rife-users mailing list
[email protected]
http://www.uwyn.com/mailman/listinfo/rife-users
