SQL / ResultSet problem: "invalid arguments in call"

[vjh]

Hello all,

I posted this on the JDeveloper forum, but I think this forum may be more appropriate. Can anyone tell me what I'm doing wrong???

I'm attempting to use JDev to connect to and search an Oracle database. I seem to have finally made the connection, but now I can't seem to get any results. The SQL query I'm using is valid, so the problem is elsewhere...

Thanks for any suggestions.

The SQL Exception error I get is "invalid arguments in call".

The code I'm using is this:

try{
Class.forName("oracle.jdbc.driver.OracleDriver"
conn = DriverManager.getConnection("jdbcracle:thinoradb"
stmt = conn.createStatement();
String sqlqry = "SELECT id,name,sequence FROM tableA";

rs = stmt.executeQuery(sqlqry);

while (rs.next())
{
String tblId = rs.getString("id"
String tblName = rs.getString("name"
String tblSeq = rs.getString("sequence"

out.print(" - - - "
out.print("ID: " +tblId);
out.print("Name: " + tblName);
out.print("Sequence: " + tblSeq);

}
rs.close();
stmt.close();
conn.close();

}

catch (SQLException se)
{
out.print("SQL Exception: " + se.getMessage());
}
%>

 

[palbano]

>> conn = DriverManager.getConnection("jdbcracle:thinoradb"

Does your Oracle server require a login/password all ours do?


-pete
_{I just can't seem to get back my IntelliSense}

 

[vjh]

Now I feel like an idiot!

I had erased them in the pasted in text. But in fact that was the source of the problem. I had the wrong format for username/password.

Thanks.

 

[palbano]

>> Now I feel like an idiot!

welcome to the club i'm a charter member!

-pete
_{I just can't seem to get back my IntelliSense}