Jian Yi

thanks so much

Hi,

I'm new to Ruby. Does anyone know how to use Ruby to write an Http test client?

What I want is, I want a test script which can automatically fill in the form variables on my web site and do tests automatically. Is Ruby capable of doing that?

Thanks!
J.

Never mind. I got it working.

Here is the whole error message:
[junit] Running com.manning.hq.ch03.TestEventManager [junit] ------1------- [junit] ------2------- [junit] ------3------- [junit] org.hibernate.exception.SQLGrammarException: could not get next sequence value [junit] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) [junit] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [junit] at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96) [junit] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:98) [junit] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) [junit] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) [junit] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98) [junit] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) [junit] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) [junit] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) [junit] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495) [junit] at com.manning.hq.ch03.EventManager.save(Unknown Source) [junit] at com.manning.hq.ch03.TestEventManager.testSave(Unknown Source) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [junit] at java.lang.reflect.Method.invoke(Method.java:324) [junit] at junit.framework.TestCase.runTest(TestCase.java:154) [junit] at junit.framework.TestCase.runBare(TestCase.java:127) [junit] at junit.framework.TestResult$1.protect(TestResult.java:106) [junit] at junit.framework.TestResult.runProtected(TestResult.java:124) [junit] at junit.framework.TestResult.run(TestResult.java:109) [junit] at junit.framework.TestCase.run(TestCase.java:118) [junit] at junit.framework.TestSuite.runTest(TestSuite.java:208) [junit] at junit.framework.TestSuite.run(TestSuite.java:203) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:297) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:672) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:567) [junit] Caused by: java.sql.SQLException: ORA-02289: sequence does not exist [junit] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) [junit] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) [junit] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) [junit] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626) [junit] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182) [junit] at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500) [junit] at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942) [junit] at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532) [junit] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037) [junit] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905) [junit] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946) [junit] at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75) [junit] ... 25 more [junit] ------4------- [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 10.547 sec

Oops, sent out by mistake.

I mean to add the code and table here:

1. Event.java:
public class Event { private Long id; private String name; private Date startDate; private int duration; private Set speakers; private Set attendees; private Location location; public void setId(Long id) { this.id = id; } public Long getId() { return id; } ...

2. Event mapping file:
<hibernate-mapping package="com.manning.hq.ch03"> <class name="Event" table="events"> <id name="id" column="id" type="long" unsaved-value="null"> <generator class="native"/> </id> <property name="name" type="string" length="100"/> <property name="startDate" column="start_date" type="date"/> <property name="duration" type="integer"/> <many-to-one name="location" column="location_id" class="Location"/> <set name="speakers" cascade="all"> <key column="event_id"/> <one-to-many class="Speaker"/> </set> <set name="attendees" cascade="all"> <key column="event_id"/> <one-to-many class="Attendee"/> </set> </class> </hibernate-mapping>

3. events table:

CREATE TABLE events ( id number(10) default 0 not null primary key, name varchar2(255), start_date date, duration number(10), location_id number(10) references locations ) ; CREATE SEQUENCE yinj.EVENTS_KEY START WITH 1 MAXVALUE 9999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER events_BIU_TRG BEFORE INSERT OR UPDATE ON yinj.events REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE W_SEQ NUMBER; BEGIN IF :-o LD.id IS NULL THEN SELECT events_KEY.NEXTVAL INTO W_SEQ FROM DUAL; :NEW.id := W_SEQ; END IF; END; /

Anything else I should post here to be helpful to answer my question?

Thanks!
Jenny

Hi everyone,

I'm new to Hibernate. I tried to use the examples in book 'Hibernate Quickly', but using Oracle instead of MySQL. However I got the error:
org.hibernate.exception.SQLGrammarException: could not get next sequence value at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

So that means XMLHttp is not a safe method to use because users may disable the ActiveX controls? Does it mean it's better to use the hidden frame technique?

Thanks!
Jenny

I've developed a web site which uses XMLHttp for Ajax implementation. However, I read it some where that, XMLHttp is depending upon ActiveX controls to be enabled. My question is, how can my users disable ActiveX controls?

Thanks!
Jenny

Okay, bad boy, giddy-up!

Thank you both. There are so many nice experts out here!

I think I know why my program is wrong. The returned xml document can only have one root element. I should return something like this:

<?xml version="1.0" ?>
<Root>
<Entry>
<Dealer>407209</Dealer>
<Device>33333</Device>
</Entry>
<Entry>
<Dealer>405A11</Dealer>
<Device>33334</Device>
</Entry>
</Root>

Am I correct? If so, I need some assistance to parse this document. Does anyone have some sample code snippets?

Thanks!
Yi

Hi,

I'm new to Ajax. Does Ajax have a limit on how big the xml document returned by the jsp should be? I have this weird problem... My Jsp returns an xml document like this:

<?xml version="1.0" ?>
<Entry>
<Dealer>407209</Dealer>
<Device>33333</Device>
</Entry>
<Entry>
<Dealer>405A11</Dealer>
<Device>33334</Device>
</Entry>

And FireBug gave me an error:

junk after document element

<Entry> ^

This <Entry> refers to the second <Entry> element. Why is this happening? How can I fix it?

Thanks,
Yi

P.S. my jsp looks like this:

<%@ page contentType="text/xml"%> <%@ page language="java" import="java.util.*,com.vw.dlrvas.util.*" %> <%! private WASConnectionPool getPool(){ return (WASConnectionPool)getServletConfig(). getServletContext().getAttribute("dbPool"); } %> <% String allDevices = request.getParameter("allDevices"); Vector dealerDevices = new DbUtil().getRegisteredDevices(allDevices, getPool()); StringBuffer xmlMessage = new StringBuffer("<?xml version=\"1.0\" ?>\n"); for (int i = 0; i < dealerDevices.size(); i = i + 2) { xmlMessage.append("<Entry>\n"); xmlMessage.append("<Dealer>").append((String)dealerDevices.get(i)).append("</Dealer>\n"); xmlMessage.append("<Device>").append((String)dealerDevices.get(i+1)).append("</Device>\n"); xmlMessage.append("</Entry>\n"); } response.setContentType("text/xml"); response.setHeader("Cache-Control", "no-cache"); response.getWriter().write(xmlMessage.toString()); response.getWriter().flush(); %>

Would you please help me? Where can I find the doc for deploying ear in Websphere 5 admin console?

Thanks!

Hi all,

I want to thank all the people here who have helped to nail this exam. I got 85% on 10/8/05. However, until now, I haven't received the 'real' certificate from Sun. Does anybody know what number I should call for this issue?

Thanks!
Jenny

Thanks, guys, for your reply.

I'm not going to write my own wsdd or wsdl. I have complex return types in my methods. Java2WSDL can generate them in a snap!