> (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]"', 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]
> 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
--
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
