Hi Andrey,
thanks a lot. I will study these links...I have basic ideas, that I have
generators for API (Oracle Stored procedures), and now I would like to
generate restfull api above it via some scalable technology (performance
and scalability is needed).
I'm not professional in web, only on database and data :o).
Have a nice day
Petr
Dne čtvrtek, 3. ledna 2013 15:02:20 UTC+1 Андрей Листочкин napsal(a):
>
>
> (metadata driven generator for server side source code based on metadata,
> no manual coding.
>
>
> Since JavaScript is a dynamic language there's no need to generate @Entity
> type definitions for your model. Given a table User with id, name, and
> email, you'll be able to do the following (not tied to any particular API,
> just peudo-code):
>
> sql('select * from User where email = "[email protected] <javascript:>"',
> function (err, user) {
> if (err) return;
> console.log(user.id, user.name);
> });
>
> Please, Oracle DB is have to requirment, no other database (MySQL, SQL
> Lite and other). It's for corporate company.
>
>
> Seems like there are quite a few options already:
>
> https://github.com/mariano/node-db-oracle
> http://rockycode.com/blog/connect-nodejs-oracle-say-what/
>
>
> http://barton-notestomyself.blogspot.com/2011/12/nodejs-oracle-db-not-so-bad-union.html
> https://github.com/bartonhammond/OraclePubSub
>
> I would suggest you do DB connectivity layer in Java instead. JAX-RS API
> is very pretty and the db bindings for Oracle are mature, fast, complete,
> and well supported. You sure can use Node.js for other parts of your
> application.
>
> Andrey
>
> On Jan 3, 2013, at 11:05 , Petr Simbera wrote:
>
> Hi all,
> I have problem with preparation architecture for one of my project.
> Architecture:
> client - web browser with node.js
> app server - simple fully generated restfull api - only interface for
> getting/setting data from oracle database. no business logic, only call
> oracle stored procedures (return JSON strings, save data into tables-
> parsing json input, validate etc...). no transaction support needed (state
> less).
> db - oracle XE or SE ONE 11g - (we have generator which create procedures
> with included business logic, which provide secure access to data -
> get/set). We would like use JSON on input (or input array, JSON output for
> read only queries).
> I read some information about using node.js on server side, I like it, but
> I don't have any real tutorial, how to connect node.js as server side
> engine connect into Oracle DB and call procedures and queries. (search all
> oracle-db, and other module in node module library), but I don't understand
> this. I have idea as simplicity as JDBC...persistent connection pool on
> server side.
> Please, Oracle DB is have to requirment, no other database (MySQL, SQL
> Lite and other). It's for corporate company.
>
> I would like generate simple rest full API which use data in Oracle
> database (metadata driven generator for server side source code based on
> metadata, no manual coding...).
> I thing, that the same problem had certainly been solved
>
> Do you have experience or relevant know-how ?
>
> Thanks for your post
>
> Have a nice day
> Petr
>
>
> --
> Job Board: http://jobs.nodejs.org/
> Posting guidelines:
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> You received this message because you are subscribed to the Google
> Groups "nodejs" group.
> To post to this group, send email to [email protected] <javascript:>
> To unsubscribe from this group, send email to
> [email protected] <javascript:>
> For more options, visit this group at
> http://groups.google.com/group/nodejs?hl=en?hl=en
>
>
>
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
