lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rzoao <jo.carvalh...@gmail.com>
Subject Bad Request (Solr + Weblogic + Oracle DB)
Date Thu, 02 Feb 2012 12:59:09 GMT
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.

Mime
View raw message