Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

sql loader

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

nmax

Post subject: sql loader

Posted: Tue Jan 28, 2014 1:01 pm

Newbie

Joined: Tue Jan 28, 2014 12:51 pm
Posts: 2

Hi!

Is it possible to invoke sql loader from within hibernate?

Now the following code

Code:

CallableStatement cs;

String insertScript = "host sqlldr userid=someUserId/someDb control = someFile.dat";
cs = connection.prepareCall(insertScript);
cs.execute();

produce SQLSyntaxErrorException: ORA-00900: invalid SQL statement
I'd tried a number of variations with single and double quotes as well as

Code:

host ls
host sqlldr
sqlldr

with the same error.

Top

CDillinger

Post subject: Re: sql loader

Posted: Wed Jan 29, 2014 2:05 am

Senior

Joined: Tue Oct 28, 2008 10:39 am
Posts: 196

Why do you expected that any application that's does not care about running external applications outside it's own scope should interpret a shell command as an SQL-string?

Top

nmax

Post subject: Re: sql loader

Posted: Wed Jan 29, 2014 3:58 am

Newbie

Joined: Tue Jan 28, 2014 12:51 pm
Posts: 2

I expect nothing, just curious whether it is possible or not.
The command "host" allows to run external applications from sql plus and sql developer, but it is not an sql command. I wonder if hibernate supports this command.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum