Fwd: SoceketFactory class Error : connect database using JIQL by JDBC driver

[rajeev jha]

Hi ,
 I am trying to connect a database using JIQL which is jdbc wrapper
with following URL :

String url = "jdbc:jiql:https://myAppsName.appspot.com/jiqlservlet";
also try with following URL without SSL :
String url = "jdbc:jiql:http://myAppsName.appspot.com/jiqlservlet";

and am getting the following error ...

/jiql.jsp
java.lang.NoClassDefFoundError: javax.net.SocketFactory is a
restricted class. Please see the Google App Engine developer's guide
for more details.
       at javax.net.SocketFactory.<clinit>(SocketFactory.java)
       at
org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:
82)
       at
org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:
127)
       at
org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:
707)
       at
org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:
387)
       at
org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:
171)
       at
org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:
397)
       at
org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:
323)
       at org.jiql.JiqlClient.execute(JiqlClient.java:148)
       at org.jiql.jdbc.Statement.execute(Statement.java:107)
       at org.apache.jsp.jiql_jsp._jspService(jiql_jsp.java:83)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
       at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)
       at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)
       at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
       at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
       at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
       at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)
       at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
       at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
       at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)
       at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
418)
       at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
       at org.mortbay.jetty.Server.handle(Server.java:326)
       at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
       at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:923)
       at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
       at
com.google.net.rpc.impl.BlockingApplicationHandler.handleRequest(BlockingApplicationHandler.java:
24)
       at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java:
435)
       at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java:
572)
       at com.google.tracing.TraceContext$TraceContextRunnable
$1.run(TraceContext.java:448)
       at com.google.tracing.TraceContext.runInContext(TraceContext.java:
688)
       at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:
326)
       at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:
318)
       at com.google.tracing.TraceContext
$TraceContextRunnable.run(TraceContext.java:446)
       at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:
1110)
       at java.util.concurrent.ThreadPoolExecutor
$Worker.run(ThreadPoolExecutor.java:603)
       at java.lang.Thread.run(Thread.java:636)

Please suggest if something i am missing and need to update my apps.

Thanks in Advance !

Rajeev Jha.

[Gabriel Wong]

Are you calling from within the same Google App. If so then you should
be using the local
connection instead of trying to establish a remote connection.

On Dec 27, 5:09 am, rajeev jha <rajeevjha...@gmail.com> wrote:
> Hi ,
>  I am trying to connect a database using JIQL which is jdbc wrapper
> with following URL :
>
> String url = "jdbc:jiql:https://myAppsName.appspot.com/jiqlservlet";
> also try with following URL without SSL :

> String url = "jdbc:jiql:http://<http://bigtable-apps.appspot.com/jiqlservlet>
> myAppsName <https://myappsname.appspot.com/jiqlservlet>.
> appspot.com/jiqlservlet";