Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00911:invalid character problem

843853Jul 5 2001 — edited Nov 2 2005
Hi

I am able to make a connection to the Oracle DB but when I try to execute a simple SQL statement I get a
"ORA-00911:invalid character problem"

code is below
try {
ds = DataSourceFactory.getDataSource (ApplicationConfig.DATA_SOURCE);
connection = ds.getConnection(ApplicationConfig.DATA_SOURCE_PROPS);
}
catch (Exception e) {
if(DEBUG)System.out.println(e.toString());
}
try{
Statement stat = connection.createStatement();
String sql = "Select * from language_table;";
ResultSet rs = stat.executeQuery(sql);
catch (Exception e) {
if(DEBUG)System.out.println(e.toString());
}
the first part is OK, and the second part creates the exception. When I run the sql statement in the SQL_PLUS client it runs perfectly.
I am at a loss as to what to try next.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2005
Added on Jul 5 2001
4 comments
346 views