We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:
- Encode data on the Qnx box
- Send over bridge to Windows box
- Decodes from bridge on Unix box
- Goes through Windows “Master” driver
- Goes through Oracle Drive on Windows box
- Then, goes over network in some Net-8 format to the Oracle server
box
Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?
THanks
Bruce (not a database guy) Gilland
<gilland@cs.colorado.edu> wrote in message
news:3ce5172e.1341989@inn.qnx.com…
We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:
- Encode data on the Qnx box
- Send over bridge to Windows box
- Decodes from bridge on Unix box
- Goes through Windows “Master” driver
- Goes through Oracle Drive on Windows box
- Then, goes over network in some Net-8 format to the Oracle server
box
Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?
We ported MySQL’s interface library to talk across the network to
a MySQL server running in Linux. The interface will work with any
MySQL server. It uses TCP/IP directly. I have no (recent)
experience with Oracle’s interface, so I don’t know whether a
similar approach will work. It certainly would be a lot faster than
the roundabout route you are using now.
Cheers,
Andrew
Andrew Thomas <andrew@cogent.ca> wrote:
We ported MySQL’s interface library to talk across the network to
a MySQL server running in Linux. The interface will work with any
MySQL server. It uses TCP/IP directly. I have no (recent)
experience with Oracle’s interface, so I don’t know whether a
similar approach will work. It certainly would be a lot faster than
“similar approach” will require source?
I believe the reason you could do it with mysql is because you
have mysql source.
the roundabout route you are using now.
Cheers,
Andrew
<nospam@nospam.nospam.com> wrote in message news:aclp8i$1fj$1@inn.qnx.com…
Andrew Thomas <> andrew@cogent.ca> > wrote:
We ported MySQL’s interface library to talk across the network to
a MySQL server running in Linux. The interface will work with any
MySQL server. It uses TCP/IP directly. I have no (recent)
experience with Oracle’s interface, so I don’t know whether a
similar approach will work. It certainly would be a lot faster than
“similar approach” will require source?
I believe the reason you could do it with mysql is because you
have mysql source.
No, but I do have the mysql client API. I remember that Oracle
also has an API that works on a single machine, but I don’t know
if it has an API for making a connection to another machine. True,
to do this in QNX, you would need the API source, or a specification
for the API protocol, if such a remote protocol even exists for Oracle.
Cheers,
ANdrew
Would some form of ODBC driver perhaps be the ticket? There’s a free one at
http://www.jepstone.net/FreeODBC/.
Kris
“Andrew Thomas” <andrew@cogent.ca> wrote in message
news:ad0cam$l99$1@inn.qnx.com…
nospam@nospam.nospam.com> > wrote in message
news:aclp8i$1fj$> 1@inn.qnx.com> …
Andrew Thomas <> andrew@cogent.ca> > wrote:
We ported MySQL’s interface library to talk across the network to
a MySQL server running in Linux. The interface will work with any
MySQL server. It uses TCP/IP directly. I have no (recent)
experience with Oracle’s interface, so I don’t know whether a
similar approach will work. It certainly would be a lot faster than
“similar approach” will require source?
I believe the reason you could do it with mysql is because you
have mysql source.
No, but I do have the mysql client API. I remember that Oracle
also has an API that works on a single machine, but I don’t know
if it has an API for making a connection to another machine. True,
to do this in QNX, you would need the API source, or a specification
for the API protocol, if such a remote protocol even exists for Oracle.
Cheers,
ANdrew
gilland@cs.colorado.edu wrote:
We need to be able to send fairly high rate data from a QNX system to
an Oracle (or other SQL) database. To date, the only option we have
found is to use software from a company called EasySoft that (I think)
allows for the following to occur:
- Encode data on the Qnx box
- Send over bridge to Windows box
- Decodes from bridge on Unix box
- Goes through Windows “Master” driver
- Goes through Oracle Drive on Windows box
- Then, goes over network in some Net-8 format to the Oracle server
box
Has anyone needed to interface with an SQL (preferably Oracle)
database before, and if so, can anyone give me some pointers as to
where to start?
FreeTDS could be an option:
http://www.freetds.org/
If you are not bound to Oracle … look for SQLite (has transaction
processing, mySQL dosn’t have it …) SQLite is very easy to port …
Armin
Armin Steinhoff wrote:
If you are not bound to Oracle … look for SQLite (has transaction
processing, mySQL dosn’t have it …) SQLite is very easy to port …
The latest stable version of MySQL comes as either
“normal” MySQL, which has no transaction processing,
or as MySQL-max, which uses either innodb or Berkeley
DB as a transaction processing layer. I have no
comment on this functionality, as I haven’t used it,
but it claims to exist. For what it’s worth, I have
not succeeded in getting a running MySQL with
innodb support, and haven’t tried with Berkeley yet
on QNX6.
Cheers,
Andrew
Andrew Thomas wrote:
Armin Steinhoff wrote:
If you are not bound to Oracle … look for SQLite (has transaction
processing, mySQL dosn’t have it …) SQLite is very easy to port …
The latest stable version of MySQL comes as either
“normal” MySQL, which has no transaction processing,
or as MySQL-max, which uses either innodb or Berkeley
DB as a transaction processing layer. I have no
comment on this functionality, as I haven’t used it,
but it claims to exist. For what it’s worth,
Every professional data base supports commitments for fixpoints and
the possibillity to rollback changes if a transaction aborts or has been
aborted. Also … transaction logging is important for recovery action
after
a data base crash.
gadfly (Python) and SQLite have these features …
Cheers
Armin
I have
not succeeded in getting a running MySQL with
innodb support, and haven’t tried with Berkeley yet
on QNX6.
Cheers,
Andrew