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.carvalh...@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
