How to map h2 database with oracle using java

[Harry]

Hello Friends,

             How can I map h2 database with oracle using java code. I already created one database in oracle and I want to map it with h2 database using java.

Looking forward to your reply.

Thanks

[Jitendra Jain]

Hi Harry,

 

   I'm also struggling with this. I posted this query yesterday but nobody has yet replied. Moreover, there is no adequate help available on the net related to this. Please help as this is very urgent .

 

   Thanks.

JJain

--

You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[Sergi Vladykin]

Hi,
you should provide more info what exactly you want to do. I don't
understand what does it mean to "map h2 database with oracle using
java code".

[Jitendra Jain]

Thanks Sergi for the reply.

 

 Actually we already had Oracle database. As per the documents provided by H2 team that it is compatible with Oracle. Now without touching the Oracle database we want to load the h2 driver and data should be pulled from Oracle database( again, H2 is compatible with Oracle). Hope this makes everything clear. Let me know if not.

[Nitai @ Razuna]

We are using H2 only in Oracle mode. But your question somehow implies
that you think you can "hook" up H2 to a Oracle database and it
"pulls" data from it.......

Compatible with Oracle means that all your queries don't need to be
rewritten when working with H2, but H2 is not able to connect to a
Oracle database and "import" data from it. Either you make a
export/import or get your data into H2 with some other method.

If I'm mistaken, then please excuse.

Kind Regards,
Nitai

--
See for yourself how easy it is to manage files today. Join the revolution!

Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
http://www.razuna.com/

Razuna - Open Source Digital Asset Management
http://www.razuna.org/

Follow us on Twitter
http://twitter.com/razunahq

[Sergi Vladykin]

Yes, compatibility mode is only about syntax and behavior in some
special cases.
See http://h2database.com/html/features.html#compatibility
You want to move database from oracle to h2 or you want to have access
to oracle database from h2?
You can access external databases from H2 using linked tables or using
stored procedures.
See http://h2database.com/html/advanced.html#linked_tables
http://h2database.com/html/features.html#user_defined_functions

[Jitendra Jain]

Thanks Sergi and Nitai. Your inputs are valid. I'm worng and iam trying to hook h2 with Oracle.. Every database is little differ from each other and that's why h2 asks for the parameter MODE. Now every picture is clear.

 

Thanks again to both of yu.