[somsahi]

i have a sql file but i am not able to run it.how to run it.
i have set
classpath are
1)for databse explorer
myeclispe-databse explorer-driver-oraclethin driver
example url jdbc:oracle:thin:@mo:1521:m
extra class path -d:\oracle\jdbc\lib\ojdbc14.jar
d:\oracle\jdbc\lib\classes12.jar
d:\oracle\jdbc\lib\classes12.jar
driver class name-oracle.jdbc.driver.OracleDriver
2)myeclipse application server jboss4 path
append to classpath-
d:/oracle/ora92/jdbc/lib
similarly ojdbc.classes.zip and zar
append to library path
d:/oracle/ora92/jdbc/lib
d:/oracle/92
d:/oracle/ora92/bin
Also added tools.jar in myeclipse-j2ee project library set
also added oracle home in java build path
even then also bookstore is not able to create databse connections

[Riyad Kalla]

If you switch to the Database perspective, open a SQL Editor window and paste your SQL file contents in, can’t you run it?

[Author]

Posts