Thread: Ultradev and PostgreSQL on SuSE

Ultradev and PostgreSQL on SuSE

From
Peter Blajev
Date:
Hi

I'm using JDBC driver to connect Ultradev to postgresql database and
everything works fine but when I try to open the index.jsp file with
a web browser I get these:

Error: 500

Location: /phone_book/index.jsp

Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for
JSP/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:99:
Undefined variable: all_table_isEmpty
                if (all_table_isEmpty) {
                    ^
/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:104:
Undefined variable: all_table_numRows
                if (all_table_numRows == 0) {
                    ^
/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:105:
Undefined variable: all_table_numRows
                  all_table_numRows = 1;
                  ^
....
   < a lot of errors similar to these >
....

30 errors

        at org.apache.jasper.compiler.Compiler.compile(Compiler.java)
        at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java)
        at org.apache.jasper.servlet.JasperLoader.loadJSP(JasperLoader.java)
        at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java)
        at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java)
        at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java)
        at org.apache.tomcat.core.Handler.service(Handler.java)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java)
        at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java)
        at java.lang.Thread.run(Thread.java:484)

I'm not sure where to look at to fix the problem.
Any help is highly appreciate.

Thanks
Peter

Re: Ultradev and PostgreSQL on SuSE

From
"Nick Fankhauser"
Date:
Peter-

Have you looked at Tony Grant's page describing his install of Ultradev &
PGSQL? It might help:

http://www.animaproductions.com/ultra.html

Regards,

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Peter Blajev
> Sent: Tuesday, November 13, 2001 8:52 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Ultradev and PostgreSQL on SuSE
>
>
> Hi
>
> I'm using JDBC driver to connect Ultradev to postgresql database and
> everything works fine but when I try to open the index.jsp file with
> a web browser I get these:
>
> Error: 500
>
> Location: /phone_book/index.jsp
>
> Internal Servlet Error:
>
> org.apache.jasper.JasperException: Unable to compile class for
> JSP/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002e
> jspindex_jsp_0.java:99:
> Undefined variable: all_table_isEmpty
>                 if (all_table_isEmpty) {
>                     ^
> /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejsp
> index_jsp_0.java:104:
> Undefined variable: all_table_numRows
>                 if (all_table_numRows == 0) {
>                     ^
> /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejsp
> index_jsp_0.java:105:
> Undefined variable: all_table_numRows
>                   all_table_numRows = 1;
>                   ^
> ....
>    < a lot of errors similar to these >
> ....
>
> 30 errors
>
>         at org.apache.jasper.compiler.Compiler.compile(Compiler.java)
>         at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java)
>         at
> org.apache.jasper.servlet.JasperLoader.loadJSP(JasperLoader.java)
>         at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java)
>         at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNeces
> sary(JspServlet.java)
>         at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Jsp
> Servlet.java)
>         at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java)
>         at org.apache.tomcat.core.Handler.service(Handler.java)
>         at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java)
>         at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java)
>         at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java)
>         at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.process
> Connection(Ajp12ConnectionHandler.java)
>         at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java)
>         at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java)
>         at java.lang.Thread.run(Thread.java:484)
>
> I'm not sure where to look at to fix the problem.
> Any help is highly appreciate.
>
> Thanks
> Peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Re: Ultradev and PostgreSQL on SuSE

From
tony
Date:
On Wed, 2001-11-14 at 02:52, Peter Blajev wrote:
> Hi
>
> I'm using JDBC driver to connect Ultradev to postgresql database and
> everything works fine but when I try to open the index.jsp file with
> a web browser I get these:
>
> Error: 500
>
> Location: /phone_book/index.jsp
>
> Internal Servlet Error:
>
> org.apache.jasper.JasperException: Unable to compile class for
> JSP/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:99:
> Undefined variable: all_table_isEmpty
>                 if (all_table_isEmpty) {
>                     ^
> /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:104:
> Undefined variable: all_table_numRows
>                 if (all_table_numRows == 0) {
>                     ^
> /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:105:
> Undefined variable: all_table_numRows
>                   all_table_numRows = 1;

You haven't defined your variables...

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


Re: Ultradev and PostgreSQL on SuSE

From
Peter Blajev
Date:
Thanks to Toni and Nick for their responds.
I understand that these variables has to be defined but the page was
generated from Ultradev and it shouldn't be necessary to make any additional
changes. It seems to me that these variables/functions are part of some
standard library that I don't have or this library is not "include"
properly or so.
Also I get the same error in Ultradev when I click on View/LiveData but
if I test the Recordset (Data Bindings tab) I can see the real data got from
the database.
What is wrong?

Please help
Peter

tony wrote:
>
> On Wed, 2001-11-14 at 02:52, Peter Blajev wrote:
> > Hi
> >
> > I'm using JDBC driver to connect Ultradev to postgresql database and
> > everything works fine but when I try to open the index.jsp file with
> > a web browser I get these:
> >
> > Error: 500
> >
> > Location: /phone_book/index.jsp
> >
> > Internal Servlet Error:
> >
> > org.apache.jasper.JasperException: Unable to compile class for
> > JSP/opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:99:
> > Undefined variable: all_table_isEmpty
> >                 if (all_table_isEmpty) {
> >                     ^
> > /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:104:
> > Undefined variable: all_table_numRows
> >                 if (all_table_numRows == 0) {
> >                     ^
> > /opt/jakarta/work/localhost_8080%2Fphone_book/_0002findex_0002ejspindex_jsp_0.java:105:
> > Undefined variable: all_table_numRows
> >                   all_table_numRows = 1;
>
> You haven't defined your variables...
>
> Cheers
>
> Tony Grant
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia UltraDev with PostgreSQL
> http://www.animaproductions.com/ultra.html

Re: Ultradev and PostgreSQL on SuSE

From
tony
Date:
On Wed, 2001-11-21 at 22:12, Peter Blajev wrote:
> Thanks to Toni and Nick for their responds.
> I understand that these variables has to be defined but the page was
> generated from Ultradev and it shouldn't be necessary to make any additional
> changes. It seems to me that these variables/functions are part of some
> standard library that I don't have or this library is not "include"
> properly or so.
> Also I get the same error in Ultradev when I click on View/LiveData but
> if I test the Recordset (Data Bindings tab) I can see the real data got from
> the database.
> What is wrong?

Do the Ultradev tutorial.

All your questions will be answered!

Cheers

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html