Re: (newbie) need some helpwith database access via jsp

[Carsten Heyl <heyl@nads.de>]

Hi anoop!

Please try version 1.0 (cvs snapshot) and read the notes 
regarding "jdbcbean(s)" in INSTALL.apache.
Thats the only version which is supported.
I guess you forgot to add the directory where you store your 
DataBaseSelect.class to the compile CLASSPATH.

>
>I'm new to this jsp stuff.  Does anyone have a simple jsp which accesses =
>a database that I can take a look at?
>
>I tried one I found on the web which has a DataBaseSelect.jsp page and a =
>DataBaseSelect.java(bean).
>
>But I keep getting the following response
>
>
>builtin-javac -classpath C:\Program Files\Apache Group\Apache=20
>JServ\ApacheJServ.jar;c:\jsdk2.0\lib\jsdk.jar;C:\gnujsp-0.9.10\lib\gnujsp=
>.jar;C:\jdk1.2.2\lib\tools.jar;C:\Program=20
>Files\Apache Group\Apache\htdocs\gnujsp -d C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp -deprecation C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java
>C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:13:=20
>Class=20
>_jsp._C_3a._Program_20Files._Apache_20Group._Apache._htdocs._jspPages.Dat=
>aBaseSelect=20
>not found.  DataBaseSelect select =3D null;  ^C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:15:=20
>Class=20
>_jsp._C_3a._Program_20Files._Apache_20Group._Apache._htdocs._jspPages.Dat=
>aBaseSelect=20
>not found.  if(request.getAttribute("select") instanceof=20
>DataBaseSelect) {                                               =
>^C:\Program=20
>Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:17:=20
>Class=20
>_jsp._C_3a._Program_20Files._Apache_20Group._Apache._htdocs._jspPages.Dat=
>aBaseSelect=20
>not found.   select =3D (DataBaseSelect) request.getAttribute("select");
>             ^C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:21:=20
>Class=20
>_jsp._C_3a._Program_20Files._Apache_20Group._Apache._htdocs._jspPages.Dat=
>aBaseSelect=20
>not found.    select =3D (DataBaseSelect)=20
>java.beans.Beans.instantiate(this.getClass().getClassLoader(),=20
>"DataBaseSelect");              ^C:\Program Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:29:=20
>Variable select may not have been initialized.   __propertyDescriptors =
>=3D=20
>java.beans.Introspector.getBeanInfo(select.getClass()).getPropertyDescrip=
>tors();
>                                                               =
>^C:\Program=20
>Files\Apache=20
>Group\Apache\htdocs\gnujsp\_jsp\_C_3a\_Program_20Files\_Apache_20Group\_A=
>pache\_htdocs\_jspPages\_dataBaseSelect_2ejsp.java:32:=20
>Exception java.beans.IntrospectionException is never thrown in the body =
>of the=20
>corresponding try statement.  } catch(java.beans.IntrospectionException=20
>introexc) {    ^
>
>
>I have gnujsp0.9.10, apache 1.3.9 , jserv1.0, NT4.0=20
>
>database is Interbase (access using Interclient type 3 driver)
>
>Thanks in advance for help.
>
>Anoop
>

Ciao,
	Carsten
alph@gjt.org