Connecting to a oracle database with GWT

Bruno Henrique

unread,

Jul 20, 2011, 12:08:47 PM7/20/11

to google-web-toolkit

Hi people,

Can someone give an example how to configure and call a oracle db connection using GWT.

I know that it must be done in the server side and I can get the data in client side using RPC. But I don't know where to add the oracle library and make the calls.

Tks!!!

Kevin Anderson

unread,

Jul 20, 2011, 12:17:58 PM7/20/11

to google-we...@googlegroups.com

http://www.java-forums.org/java-tips/6116-using-jdbc-connect-oracle-database.html

This is more of a java question then a GWT question. But the above gives you an example of how to do it. Though I personally prefer using something like spring to handle the oracle connection and then in my services just inject the connection.

Kayode Odeyemi

unread,

Jul 20, 2011, 12:20:35 PM7/20/11

to google-we...@googlegroups.com

There's ODK4Spring connector. Download it and you are up to speed.

> --
> You received this message because you are subscribed to the Google Groups
> "Google Web Toolkit" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/google-web-toolkit/-/8k6xhdQKwY0J.
> To post to this group, send email to google-we...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-web-tool...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/google-web-toolkit?hl=en.
>
>

--
Odeyemi 'Kayode O.
http://www.sinati.com. t: @charyorde

Bruno Henrique

unread,

Jul 20, 2011, 1:47:59 PM7/20/11

to google-we...@googlegroups.com

I have no problems with jdbc...I've already worked with this in desktop and web applications (jsp, jsf)...my problem is using it with GWT...I don't know how to do it...where I have to add the oracle library...

2011/7/20 Kevin Anderson <kev...@gmail.com>

http://www.java-forums.org/java-tips/6116-using-jdbc-connect-oracle-database.html

This is more of a java question then a GWT question. But the above gives you an example of how to do it. Though I personally prefer using something like spring to handle the oracle connection and then in my services just inject the connection.

--

Jeff Larsen

unread,

Jul 20, 2011, 1:55:32 PM7/20/11

to google-we...@googlegroups.com

with GWT you have client and server code. The question you're asking is similar to asking where to put the oracle library when using JQuery. GWT compiles to javascript and while it has some server side plumbing, that is there just to facilitate client/server communication. The answer is you put the oracle jar inside your server and only reference it from your server side classes.

Bruno Henrique

unread,

Jul 20, 2011, 2:02:06 PM7/20/11

to google-we...@googlegroups.com

Can someone give an simple example how to use oracle with GWT, using RPC?

I tried to do something here, but I got the error:

java.lang.NoClassDefFoundError: java.net.Socket is a restricted class. Please see the Google App Engine developer's guide for more details.

at com.google.appengine.tools.development.agent.runtime.Runtime.reject(

Runtime.java:51)

at oracle.net.nt.TcpNTAdapter.connect(Unknown Source)

at oracle.net.nt.ConnOption.connect(Unknown Source)

at oracle.net.nt.ConnStrategy.execute(Unknown Source)

at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)

at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)

at oracle.net.ns.NSProtocol.connect(Unknown Source)

at oracle.jdbc.ttc7.TTC7Protocol.connect(

TTC7Protocol.java:1774)

at oracle.jdbc.ttc7.TTC7Protocol.logon(

TTC7Protocol.java:215)

at oracle.jdbc.driver.OracleConnection.<init>(

OracleConnection.java:362)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(

OracleDriver.java:536)

at oracle.jdbc.driver.OracleDriver.connect(

OracleDriver.java:328)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.carriers.chartapplication.server.indicador.banco.IndicadorBanco.buscarIndicadorBanco(

IndicadorBanco.java:75)

at com.carriers.chartapplication.server.indicador.negocio.IndicadorNegocio.<init>(

IndicadorNegocio.java:44)

at com.carriers.chartapplication.server.GreetingServiceImpl.<init>(

GreetingServiceImpl.java:16)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(

Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.mortbay.jetty.servlet.Holder.newInstance(

Holder.java:153)

at org.mortbay.jetty.servlet.ServletHolder.initServlet(

ServletHolder.java:428)

at org.mortbay.jetty.servlet.ServletHolder.getServlet(

ServletHolder.java:339)

at org.mortbay.jetty.servlet.ServletHolder.handle(

ServletHolder.java:487)