File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes SQLException:  invalid arguments in call?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLException:  invalid arguments in call??" Watch "SQLException:  invalid arguments in call??" New topic
Author

SQLException: invalid arguments in call??

carl varola
Ranch Hand

Joined: May 16, 2002
Posts: 59
Hi
I'm having the following error,also i included the sample code to access my local oracle database.
i have oracle on my c:\ drive.
Thanks for the help.
error:
=======================================
java.sql.SQLException: invalid arguments in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:803)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:175)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:251)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at attemptConnection.main(attemptConnection.java:16)
==================================
code:
===============================

[Bodie Minster - Removed the smiley's from the JDBC stuff]
[ May 17, 2002: Message edited by: Bodie Minster ]
[ Edited by Dave to format code ]
[ May 19, 2002: Message edited by: David O'Meara ]
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Two things:
1) This question is probably better suited to the JDBC forum. I'll transfer it there.
2) It's tough to tell because you have to include spaces to avoid the smileys, but I don't think you want any spaces in the string you are passing to getConnection().
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Make sure there are no spaces in your URL (there is one between your '@' and '171.164.139.78'):
secondly, you forgot to specify your username and password. Try this:

Jamie
[ May 21, 2002: Message edited by: Jamie Robertson ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQLException: invalid arguments in call??
 
Similar Threads
SQLException: invalid arguments in call??
ORA-12514: TNS:listener could not resolve SERVICE_NAME given?
PROBLEMS IN CONNECTING TO ORACLE
JDBC/Oracle access problem
Oracle Connectivity Error