> Oracle has advertised on this
> list that Berkeley Db attaches to backend SQLite databases. Based on the
> Oracle concepts summarily presented; use Berkeley Db to connect Oracle
> to SQLite to achieve your targets if you cannot Attach.
Whoa!!! Please don't misguide poor Simon and read Oracle's
press-releases more carefully. Your interpretation of it is completely
incorrect.
> "As you may have already heard, the latest release of Oracle Berkeley DB
> now supports SQL, via integration with the SQLite API."
Note: SQLite *API*, nobody says about databases. These words from
press-release basically say that now Berkeley DB "back end" has
SQLite's "front end", i.e. you can work with BDB database through the
same set of functions as with SQLite database. But you cannot mix them
with each other and of course you cannot mix both of them with Oracle
database. It's 3 different technologies and if you want any bridges
between them you have to write them yourself.
@Simon: to be honest I don't understand where the roots of the
question are. Either you're too lazy to implement it yourself or for
some reason you believe that SQLite could do some magic and could
transfer data from Oracle without copying anything into local memory.
That's impossible, computers don't work that way. If you know how to
work with Oracle and how to work with SQLite then you can quickly
write your application to execute this kind of data transfer. The
pseudo code for that follows:
issue select statement A to Oracle
while there's record returned by statement
issue insert statement B to SQLite with data retrieved from Oracle
move to the next row in statement A
end of while
I'm pretty sure that if SQLite could do what you want, Simon, it would
do it exactly like this.
Pavel
On Thu, Jun 3, 2010 at 2:59 PM, Gary_Gabriel
<gabrielrobert.qu...@googlemail.com> wrote:
> Simon Hax wrote:
>> I don't know what JET is.
>> I testet ADO. That works.
>> But it'is slow and you have to write some (to much) code.
>>
>> Much more better would be a solution like a direct LINK (like an Oracle
>> Database Link).
>>
>> as shown in my first email:
>>
>> insert into sqlitetable_columA select ColX from ta...@oracledb
>>
>> If you have 2 OracleDBs you can define a LINK from one OracleDB to the other,
>> which allows you then to do .....
> Hi Simon, As you demonstrated in your email, it is relatively easy to
> remain in a homogeneous environment. Within this environment you should
> post any questions to the provider being Oracle. The provider interfaces
> the necessary connections. When these connections no longer suffice;
> external links may solve your problem. But normally you have to acquire
> the know-how.
>
> As you have not explained the reasons why Oracle cannot fulfill your
> requirements and why you are trying to link to SQLite; any answers
> remain superficial. SQLite attaches dbs very easily and in the manner
> you indicated. Use Attach. If Oracle and SQLite were compatible you
> could simply attach dbs.
>
> As your example shows; Oracle and SQLite are two entirely different
> technologies offering diametrically opposed technologies. However it
> makes sense to connect these environments. Oracle has advertised on this
> list that Berkeley Db attaches to backend SQLite databases. Based on the
> Oracle concepts summarily presented; use Berkeley Db to connect Oracle
> to SQLite to achieve your targets if you cannot Attach. Unless you
> provide more information; this should keep you within homogeneous
> interfaces and fulfill your requirements. See the links at the bottom of
> this email for what Oracle advertises as solutions.
>
> - Gary Gabriel
>
> Oracle links from Oracle sources:
>
> "As you may have already heard, the latest release of Oracle Berkeley DB
> now supports SQL, via integration with the SQLite API."
>
> You can read the press release
> <http://www.oracle.com/us/corporate/press/063695>, review the
> documentation
> <http://www.oracle.com/technology/documentation/berkeley-db/db/index.html>
> or download
> <http://www.oracle.com/technology/software/products/berkeley-db/index.html>
> the release from the Oracle web site. You can get technical assistance
> on the Berkeley DB Forum
> <http://forums.oracle.com/forums/forum.jspa?forumID=271> or directly
> from Oracle Support
> <https://support.oracle.com/CSP/ui/flash.html#tab=SRHome%28page=SRHome&id=g1txr1mm%28%29%29>
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
