Results 1 to 2 of 2
- 04-04-2010, 01:31 PM #1
Member
- Join Date
- Mar 2010
- Posts
- 23
- Rep Power
- 0
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00904: invalid column name
errors-
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00904: invalid column name
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt atement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO dbcStatement.java:253)
Help please! I've created a separate dsn using odbc sources. And I'm trying to connect using jdbc odbc bridge. Doesn't work.Java Code:private void jButton1MouseClicked(java.awt.event.MouseEvent evt) { String user= new String(jTextField1.getText()); String pass= new String(jPasswordField1.getPassword()); if(a<4) { Connection con = null; String driver="sun.jdbc.odbc.JdbcOdbcDriver"; String user1 = "scott"; String pass1 = "tiger"; try{ Class.forName(driver); con = DriverManager.getConnection("jdbc:odbc:login",user1,pass1); Statement s=con.createStatement(); ResultSet password=s.executeQuery("Select pass from login where username="+user); if(pass.contentEquals(password.getString(1))) { a=0; JOptionPane.showMessageDialog(rootPane, "Access Granted"); ResultSet access=s.executeQuery("Select access_power from login where username="+user); access_power=access.getString(1); new Exam_Season().setVisible(true); this.setVisible(false); } else { JOptionPane.showMessageDialog(rootPane, "Access Denied."); a++; } } catch(Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(rootPane, "Connection not successful."); } } else { JOptionPane.showMessageDialog(rootPane, "Too many attempts."); System.exit(0); } }
- 04-05-2010, 01:32 AM #2
Senior Member
- Join Date
- Jun 2008
- Posts
- 2,366
- Rep Power
- 7
Similar Threads
-
java.sql.SQLException: Closed Connection
By sunjavaboy in forum JDBCReplies: 4Last Post: 03-21-2012, 01:38 PM -
java.sql.SQLException: ORA-01722: invalid number
By balushanmukha in forum JDBCReplies: 0Last Post: 08-27-2008, 06:52 PM -
How to get column names for Oracle.sql.Datum Objects
By harikanth in forum JDBCReplies: 0Last Post: 11-08-2007, 08:48 AM -
[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
By leonard in forum JDBCReplies: 1Last Post: 08-06-2007, 09:24 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks