db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yarono <yar...@il.ibm.com>
Subject Re: running ij commands from a code in c
Date Thu, 14 Jun 2007 11:09:59 GMT

That is obviously a solution, but I was looking for something more elegant.

If I won't find anything better, then I'll write an external ij-script and
run it using exec.


Thomas Nielsen - Sun Microsystems - Trondheim, Norway wrote:
> yarono,
> If Tonys suggestion of looking at org.apache.derby.impl.tools.ij doesn't 
> give you what you need, then your last resort would probably be to fork 
> a new process running ij with a command script (that does what you do at 
> the ij prompt today) to do your db creation / shutdown. Check the 
> exitvalue and/or parse the output from the process to deduce success or 
> failure the create/shutdown steps.
> Cheers,
> Thomas
> yarono wrote:
>> What I'm trying to do is to create DB's and shut them down - all from my
>> code
>> in c.
>> My current status is that I'm able to perform the above functions
>> (meaning
>> create DB and shutdown) via the ij prompt, run my code to perform table
>> creation, insertions, etc.. The shutdown and creation of the db's is done
>> through the ij prompt, while the rest of my code is in c.
>> I want the whole thing to be done in c.
>> Thomas Nielsen - Sun Microsystems - Trondheim, Norway wrote:
>>> hi yarono,
>>> What exactly do you want to do?
>>> - fork a new process to run ij (with or without a SQL script)?
>>> - execute SQL commands from C?
>>> If you are trying to fork a new process running ij, then please refer to 
>>> a suitable OS programmers guide on how to do this.
>>> If you are trying to execute SQL in C, then you're looking for a ODBC 
>>> driver. Derby does not come with a (free) ODBC driver, so your options 
>>> are to buy a (DRDA capable) ODBC driver, or use a ODBC-JDBC bridge 
>>> driver with the Derby JDBC driver. Not aware of any free ODBC-JDBC 
>>> bridge drivers off the top of my head if free is what you are looking
>>> for.
>>> Hope this helps :)
>>> Cheers,
>>> Thomas
>>> yarono wrote:
>>>> Is there a way to run the 'ij commands' in my code (written in c), just
>>>> as I
>>>> execute SQL statements?
>>> -- 
>>> Thomas Nielsen
> -- 
> Thomas Nielsen

View this message in context: http://www.nabble.com/running-ij-commands-from-a-code-in-c-tf3897645.html#a11118170
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message