Does anyone have Oracle working with Jyve?  I fixed on problem in the
oratables_schema.sql file (Project ID), but it doesn't seem to have the
same data that the mysql generated file has.  When I try to connect, I
get the following error below which leads me to believe that it is a
problem with the schema.  Any ideas?  Where can I find what column it is
trying to query?

Thanks,

Eric



Exception: java.sql.SQLException: ORA-00904: invalid column name

        at 
        at 
        at 
        at 
        at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
        at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
        at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)
        at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
        at
org.apache.jyve.screens.DisplayProjects.doBuild(DisplayProjects.java:120)
        at org.apache.turbine.modules.Screen.build(Screen.java:88)
        at
org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:117)
        at org.apache.jyve.screens.MainMenu.doBuild(MainMenu.java:110)
        at org.apache.turbine.modules.Screen.build(Screen.java:88)
        at
org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:117)
        at
org.apache.jyve.layouts.DefaultLayout.doBuild(DefaultLayout.java:92)
        at org.apache.turbine.modules.Layout.build(Layout.java:81)
        at
org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:111)
        at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:134)
        at org.apache.turbine.modules.Page.build(Page.java:81)
        at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:111)
        at Turbine.doGet(Turbine.java:322)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
        at
org.apache.jserv.JServConnection.run(JServConnection.java:188)
        at java.lang.Thread.run(Thread.java)

--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]

Reply via email to