[fishjava]

i use jdbc can connect oracle9,but i can connect in Database Explorer ,i can connect mysql,how can i do it????
it prompt “error while logining to database”,my login message is correct!!
help!
help!

[fishjava]

myeclipse 4.0.2,eclipse 3.1.1

[Haris Peco]

fishjava,

It is better that you use version MyEclipse 4.1.1
However, send us connection info : your jdbc jar, url, driver class and error log (Windows – Preferences – Show View – Other – PDE Runtime-Error Log view)

Best

[fishjava]

thanks :::

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:96)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:534)

[fishjava]

i use “Oracle thin Driver” ,it cannot connect.
then i create new driver for Oracle,class12.jar,it is also wrong.

[fishjava]

” alt=””>

[fishjava]

[fishjava]

jdbc:oracle:thin:@192.168.1.231:1521:wind

i use it in jsp or hibernage.properties ,it works.

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver ——— ???? i create driver myself,but it cannont work

[Haris Peco]

Can you try with ojdbc14.jar – it is new driver for java >= 1.4.You can use last thin jdbc drivers with oracle9

From your error, MyEclipse can’t find driver class – it mean that you don’t set driver correct – you can do it with
Windows-Preferences-MyEclipse-Database Explorer-Drivers or with ‘Configure database driver’ link when you define connection profile – choose OracleThin driver – Edit and add jdbc jar with ‘Add jars’ – You can make new driver definition, but it isn’t necessary for oracle thin

Best

[fishjava]

it works!!
thanks! thanks!
i can work on,my god!
haha

[Haris Peco]

Fishjava,

You welcome.I’m glad.

Best

[fjuarez]

I can not connect to Oracle 10.1.0.4 ojdbc14.jar
I keep getting the following error:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-05-16 20:25:46.585
!MESSAGE Error while trying to login to database
!STACK 0
java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:382)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:342)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:375)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:590)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

[Haris Peco]

fjuarez ,

Please, send us details :

– jdbc driver version (or from what database version)
– database version
– eclipse and MyEclipse version
– connection and driver details (your driver class and url is mostly important)

Thanks

[fjuarez]

@support-snpe wrote:

fjuarez ,

Please, send us details :

– jdbc driver version (or from what database version)
– database version
– eclipse and MyEclipse version
– connection and driver details (your driver class and url is mostly important)

Thanks

The jdbc driver is the one that come with Oracle 10.1.0.2 ( then patched to 10.1.0.4 ).
Eclipse 3.1.1
MyEclipseIde 4.0.100

I am connection with the followign string :
jdbc:oracle:thin:@localhost:1521:cisco

Using oralce thin driver :
oracle.jdbc.driver.OracleDriver

Anything else I can provide ?

[fjuarez]

Thanks for your help. The problem was related to a setting on the TNSNAMES.ORA file.

[Author]

Posts