File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Interesting connection problem

 
Bill White
Ranch Hand
Posts: 82
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well to me atleast...
Suppose I want to connect to a database type (Oracle, mySql etc...) and then create a DB through JDBC. Is this even possible? After all I am not giving a DB name for the URL.
I feel this concept would be pretty powerful if it is possible.
Any ideas?
Thank You
 
SJ Adnams
Ranch Hand
Posts: 925
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
well, first off i don't know
But you connect to an 'instance' not the database, so if you can find a way to connect 'as sysdba' then i guess the rest should be easy?
 
Surendran Velath
Greenhorn
Posts: 19
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried this:
Create user ddd identified by ddd
through JDBC for Oracle database and it worked
But when I fired
Grant all privileges to ddd
I got an exception:
java.sql.SQLException: ORA-01003: no statement parsed
But I am able to create table etc, in that db
through JDBC and also Oracle SQL *Plus
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic