This error -

" failed searching database [query=from d in class class com.dynetics.vidrds.model.Driver order by employeeID]
java.lang.NullPointerException"

occurs when my code has this snippet:
public Singer findSingerByEmployeeID(String employeeID)
throws Exception {
final String QUERY =
"from s in class " + Singer.class +" where s.employeeID = ?";


Wondering what the error is....

Really not enough info, show more code. Note that the HQL syntax you are using is very deprecated.[/list]

That exception message does NOT come from Hibernate, it comes from your own code. So I conclude that you should do MUCH more digging and testing before posting here again. TIA

I dug further to see that my code is trying to access tables(actually objects) in two different databases.
My question is:could there be conflicts in trying to persist objects in this scenario....

You have to be more specific in your use case

my junit test has a setup method which tries creating the two objects below-(TestVehicle and Vehicle)using hibernate.
Vehicle is in database1 and TestVehicle in database2.
HibernateAdapter is the persistent class for the first one and hWHibernateAdapter is for the second class.

the skeleton code in these adapter classes is:

my error occurs at:factory.openSession();

JUnit code:

protected void setUp() {



this.vehicle =
new Vehicle(this.vin, variant, null, null, this.group);
this.vehicle.setOwner(this.customer);
HibernateAdapter.saveObject(this.vehicle);
dtestId1 = new DurabilityTestID("dtestID1");
DurabilityTest dtest1 = new DurabilityTest(dtestId1);
vehicle1 = new TestVehicle(testVehicleID1, this.vehicle,info1, dtest1);

hWHibernateAdapter.saveObject(vehicle1);
} catch (Exception e) {
//fail(e.getMessage());
e.printStackTrace();
System.out.println("*****Caught exception :" + e);
}
}

just as addendum to my previous post-
any special rules while trying to configure multiple databases and use them in java code using hibernate

Actually this may fail if the same objects are mapped into both DB, the unsaved-value has to be very carefully set.
Second mapping non-shared objects relationship is impossible. Hibernate doesn't abstract a multi DB datastore.
Third, you may need 2PC depending your business needs