can u tell me update & delete query that i can use to connect jdatastore...
i use this query statements...but i got error
for delete:
appendPStmt = conn.prepareStatement("DELETE FROM \"info\" WHERE \"info\".\"name=\""+name);
appendPStmt.executeUpdate();
for update:
appendPStmt = conn.prepareStatement( "UPDATE \"info\" SET \"info\".\"password=\""+npwd+" WHERE \"info\".\"name=\""+name);
appendPStmt.executeUpdate();
appendPStmt = conn.prepareStatement("DELETE FROM info WHERE info.name="+name);
appendPStmt = conn.prepareStatement( "UPDATE info SET info.password="+npwd+" WHERE info.name="+name);
plz, post the error message you got because we can't guess it !
Try:
int result = 0;
String deleteSQL = "DELETE FROM info WHERE info.name= ?";
appendPStmt = conn.prepareStatement(deleteSQL);
appendPStmt.setString( 1, name );
result = appendPStmt.executeUpdate();
for update:
String updateSQL = "UPDATE info SET info.password= ? WHERE info.name= ?);
appendPStmt = conn.prepareStatement(updateSQL);
appendPStmt.setString( 1, npwd );
appendPStmt.setString( 2, name );
result = appendPStmt.executeUpdate();
If I run:
select count(*) from 'xtable'
Or if I substitute the double quotes for the single, I get table name does not exist.
Are you saying that the DB admin has control over the config of that - something I never see?
~Bill
correction ... it's "invalid tablename"
> If I run:
>
> select count(*) from 'xtable'
>
> Or if I substitute the double quotes for the single,
> I get table name does not exist.
>
The actual form is double quotes.
If you have a table name xtable in your database (presuming no quotes) then the following should actually return something.
select count(*) from "XTABLE"
> Are you saying that the DB admin has control
> over the config of that - something I never see?
Not sure what you mean, however I think SQL Server database setup can disallow the use of quoted identifiers. The default is to allow it. I don't believe Oracle allows for that. It could though.
Note again that this is part of ANSI SQL.
> > If I run:
> >
> > select count(*) from 'xtable'
> >
> > Or if I substitute the double quotes for the
> single,
> > I get table name does not exist.
> >
>
> The actual form is double quotes.
>
> If you have a table name xtable in your database
> (presuming no quotes) then the following should
> actually return something.
>
> select count(*) from "XTABLE"
NoGo ... I tried that and it does not matter (I can't retry anything now because I am no longer at work BTW) ... However, I tried wrapping it in single quotes (as I displayed), double quotes (as I said and as you displayed) and even three single quotes on each end. The result is always the same - 'Invalid tablename":
>
> > Are you saying that the DB admin has control
> > over the config of that - something I never see?
>
> Not sure what you mean, however I think SQL Server
> database setup can disallow the use of quoted
> identifiers. The default is to allow it. I don't
> believe Oracle allows for that. It could though.
>
What I meant is that, since I can't get the results from it that you mentioned above, I figured that perhaps there is some config the DBA can make to allow or disallow the use of what we're talking about - that's all
> Note again that this is part of ANSI SQL.
> > The actual form is double quotes.
> >
> > If you have a table name xtable in your database
> > (presuming no quotes) then the following should
> > actually return something.
> >
> > select count(*) from "XTABLE"
>
> NoGo
Maybe there is a way to turn it off then.
Here is the documentation, search for the following for examples "Nonquoted identifiers are not case sensitive. "
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements9a.htm
> > > The actual form is double quotes.
> > >
> > > If you have a table name xtable in your database
> > > (presuming no quotes) then the following should
> > > actually return something.
> > >
> > > select count(*) from "XTABLE"
> >
> > NoGo
>
> Maybe there is a way to turn it off then.
>
> Here is the documentation, search for the following
> for examples "Nonquoted identifiers are not case
> sensitive. "
>
> http://download-west.oracle.com/docs/cd/B10501_01/serv
> er.920/a96540/sql_elements9a.htm
Thank you sir! I did not need to use the link - just those two magic words (case sensitive) in your last post was all it took to straighten me out.
I had not even thought to try that before, but as soon as I keyed in the DB table name in upper-case and then placed the double quotes around it, it recognized it. I admit that I should have considered that in light of the quotes, but it did not click until then.
Good thing to know - thank you.
~Bill
>
> I had not even thought to try that before, but as
> soon as I keyed in the DB table name in upper-case
> and then placed the double quotes around it, it
> recognized it. I admit that I should have considered
> that in light of the quotes, but it did not click
> until then.
>
It gave you that weird error message just because the case was different?
