lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From preetesh dubey <dubeypreet...@gmail.com>
Subject Re: Bad Request (Solr + Weblogic + Oracle DB)
Date Thu, 02 Feb 2012 13:11:01 GMT
Instead of CommonHttpSolrServer, I am using StreamingUpdateSolrServer and
just doing "server.add(solrInputDocument)".
/**
StreamingUpdateSolrServer  server = new StreamingUpdateSolrServer(solrurl,
2, indexingThreads);
server.add(solrInputDocument);
**/

On Thu, Feb 2, 2012 at 6:29 PM, rzoao <jo.carvalho88@gmail.com> wrote:

> Hello all,
>
> I'm new to solr and I'm having a hard time trying to configure the
> schema.xml for a simple table.
>
> I'm using WebLogic with standard configs and Oracle Database. I have a
> simple table with the following fields
>
> Fase varchar
> Campo varchar
> Antes varchar
> Depois varchar
> Regras varchar
>
> My schema.xml is like this:
>
>        <field name="fase" type="text_general" indexed="true"
> stored="true"/>
>        <field name="campo" type="text_general" indexed="true"
> stored="true"/>
>        <field name="antes" type="text_general" indexed="true"
> stored="true"/>
>        <field name="depois" type="text_general" indexed="true"
> stored="true"/>
>        <field name="regras" type="text_general" indexed="true"
> stored="true"/>
>
> My publish class in Java is like that:
>
> package br.com.trateme.solr;
>
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.Statement;
>
> import org.apache.solr.client.solrj.SolrServer;
> import org.apache.solr.client.solrj.impl.CommonsHttpSolrServer;
> import org.apache.solr.client.solrj.request.AbstractUpdateRequest;
> import org.apache.solr.client.solrj.request.UpdateRequest;
> import org.apache.solr.client.solrj.response.UpdateResponse;
> import org.apache.solr.common.SolrInputDocument;
>
> public class Publish {
>
>        /**
>         * @param args
>         */
>        public static void main(String[] args) {
>
>                String solrUrl = "http://localhost:7001/solr/";
>
>                Connection connection = null;
>                Statement stmt = null;
>
>                try {
>
>                        SolrServer server = new
> CommonsHttpSolrServer(solrUrl);
>
>                        String driverName =
> "oracle.jdbc.driver.OracleDriver";
>                        Class.forName(driverName);
>
>                        String url = "jdbc:oracle:thin:@(DESCRIPTION =
> (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = 123.0.0.10)(PORT = 1521)))(CONNECT_DATA =
> (SERVICE_NAME = OTEX)))";
>                        String username = "teste_solr";
>                        String password = "teste_solr";
>                        connection = DriverManager.getConnection(url,
> username, password);
>
>                        stmt = connection.createStatement();
>                        ResultSet rs = stmt
>                                        .executeQuery("select * from
> trateme");
>                        while (rs.next()) {
>                                String fase = rs.getString("FASE");
>                                String campo = rs.getString("CAMPO");
>                                String antes = rs.getString("ANTES");
>                                String depois = rs.getString("DEPOIS");
>                                String regras = rs.getString("REGRAS");
>
>                                System.out.println(fase);
>                                System.out.println(campo);
>                                System.out.println(antes);
>                                System.out.println(depois);
>                                System.out.println(regras);
>
>
>                                System.out.println("-------");
>
>                                SolrInputDocument documento = new
> SolrInputDocument();
>                                documento.addField("fase", fase);
>                                documento.addField("campo", campo);
>                                documento.addField("antes", antes);
>                                documento.addField("depois", depois);
>                                documento.addField("regras", regras);
>
>                                UpdateRequest req = new UpdateRequest();
>
>  req.setAction(AbstractUpdateRequest.ACTION.COMMIT, false,
>                                                false);
>                                req.add(documento);
>                                UpdateResponse rsp = req.process(server);
>                                System.out.println(rsp);
>
>                        }
>                } catch (Exception e) {
>                        e.printStackTrace();
>                } finally {
>                        if (stmt != null) {
>                                try {
>                                        stmt.close();
>                                } catch (Exception e) {
>                                        e.printStackTrace();
>                                }
>                        }
>                        if (connection != null) {
>                                try {
>                                        connection.close();
>                                } catch (Exception e) {
>                                        e.printStackTrace();
>                                }
>                        }
>                }
>
>        }
> }
>
> *StackTrace:*
>
>
> Bad Request
>
> request:
>
> http://localhost:7001/solr/update?commit=true&waitFlush=false&waitSearcher=false&wt=javabin&version=2
>        at
>
> org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:432)
>        at
>
> org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:246)
>        at
>
> org.apache.solr.client.solrj.request.AbstractUpdateRequest.process(AbstractUpdateRequest.java:105)
>        at br.com.trateme.solr.Publish.main(Publish.java:69)
>
>
> I've seen other topics about Bad Request and I really tried to spot my
> error, but I'm not finding it. Can anyone point me to the right direction,
> please?
>
> Thank you very much to all,
>
> Joao
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Bad-Request-Solr-Weblogic-Oracle-DB-tp3709763p3709763.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 
Thanks & Regards
Preetesh Dubey

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message