Danish Araquei

Hi,

please modify your page in that way

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>


<%
String account=request.getParameter("ac");
String password=request.getParameter("pass");
String url="Jdbc:Odbc:Namrata";
String username="";
String pwd="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url,username,pwd);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from database1 where Account='"+account+"'and Password='"+password+"'");
if(rset.next())
{
%>
<jsp:forward page="welcome.jsp"/>
<%
}
else
{
%>
<jsp:forward page="welcome.jsp"/>
<%
}
}
catch(Exception e)
{
out.println("the exception is:"+e);
}
%>

please check your select query,it should be "select * from" instead of "select from"

Hi,

Go to Windows menu --> Preferences -->Java -- > Editor --> Installed JREs

Hi Preeti

User type="button" in place of type="Submit".

Danish

Hi Preeti,

please use this function with onClick event.


function fnHold(){
document.LAYOUTFORM.btHold.disabled=true;
document.LAYOUTFORM.btUnHold.disabled=false;
}

function fnUnHold(){
document.LAYOUTFORM.btHold.disabled=false;
document.LAYOUTFORM.btUnHold.disabled=true;
}

are we declare private integer variable at line 1 and also we can't same identifier name


public class Sample {
public static void main(String a[]){
int aa=1; // line 1
System.out.println("SomeText"); // line 2
}
}
[ October 30, 2008: Message edited by: Danish Araquei ]

Hi All,

while using websphere as application server when we communicate to database for any data,is any Encryption/decryption of request happen.

i want to say that when we request data through any query i.e. "select * from emp",is this code is Encryption/decryption by websphere.
[ September 15, 2008: Message edited by: Danish Araquei ]

hi peter

i got the solution ...thank you very much for your support

Hi Peter,

thanks for your reply and valuable suggestion

My Directory Structure is

com >> indussoft >> Jags >> Transactions >> QueryModule >> *.class
com >> indussoft >> Jags >> LSSystemException >> LSSystemException.class

peter i want to built ANT script for QueryModule Directory ,please suggest the valuable solution.

Hi Peter,

thanks for your reply and valuable suggestion

My Directory Structure is

com
|
|
indussoft
|
|
Jags
|
|---------------|
| |
Transactions LSExceptions
| |
| LSSystemException.class
QueryModule
|
*.class

peter i want to built ANT script for QueryModule Directory

Hi All ,

just want to add one more thing

in my build.xml code i try all the combination

<pathelement location="${IncludeDir}/com/indussoft/Jags/LSExceptions" />
<pathelement location="${IncludeDir}.com.indussoft.Jags.LSExceptions" />
<pathelement location="${IncludeDir}/com.indussoft.Jags.LSExceptions" />

but its not working.....

Hi All,

While executing build.xml i am getting following error




[javac]
[javac] D:\ABN\WSAbnjags\src\com\indussoft\Jags\Transactions\QueryModule\JTS
L_QMSessionBean.java:204: cannot resolve symbol
[javac] symbol : class LSSystemException
[javac] location: class com.indussoft.Jags.Transactions.QueryModule.JTSL_QMS
essionBean

Description

I want to create ANT script to compile java file which is located at
com\indussoft\Jags\Transactions\QueryModule folder

for that purpose i also have to extends one class name LSSystemException

Here is my ANT build.xml

<?xml version="1.0" ?>
<project name="Abn Jaguar" default="main" basedir=".">

<property name="srcDir" location="src/com/indussoft/Jags/Transactions/QueryModule"/>
<property name="distDir" location="src/com/indussoft/Jags/Transactions/QueryModule"/>
<property name="IncludeDir" location="src"/>
<property name="UtilitiesDir" location="src/com/indussoft/Jags/Utilities"/>
<property name="lib4" value="src/j2ee.jar"/>
<property name="lib5" value="src/poi-scratchpad-3.0-rc4-20070503.jar"/>
<property name="lib6" value="src/poi-contrib-3.0-rc4-20070503.jar"/>
<property name="lib7" value="src/poi-3.0-rc4-20070503.jar"/>



<target name="main" description="Compilation target">
<echo>
Compile Main Java .
</echo>

<javac srcdir="${srcDir}" destdir="${distDir}" >
<classpath>
<pathelement location="${IncludeDir}/com.indussoft.Jags.LSExceptions" />
<pathelement location="${UtilitiesDir}" />
<pathelement location="${lib4}" />
<pathelement location="${lib5}" />
<pathelement location="${lib6}" />
<pathelement location="${lib7}" />
</classpath>
</javac>
<echo>
Completed.
</echo>
</target>


</project>

Hi Rajesh

please check whether your coloum is of number datatype and you assign it with string datatype

Hi rajesh,

can you post code for our reference and also the scenario when you getting the error

Regards,
Danish

Hi All,

In our application i want computer name.

We are using the following step

1) Login to Our System(Browser).
2) From session bean we update one table,while updating that table one trigger is fired.
3)In trigger we update another table along with User-Name(Client name/Browser).In trigger we write following syntax to getting User Name

select sys_context('USERENV','TERMINAL') from dual;

but we are getting User name as null .

While debugging through pl/sql dev or executing that query we are getting USERNAME from which we logged to oracle.

Danish