Hi:
Using a direct connection to the DB works fine with my hibernate config but when I change to JNDI with the following parameters I get the message "Table not Found in statement" although it does exist. Does anyone see anything obvious in the configuration that is a problem or has run into this themselves with Weblogic.
Thanks, Alex.
Hibernate version:
2.1.6
Mapping documents:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<!-- a SessionFactory instance listed as /jndi/name -->
<session-factory>
<!-- Use DataSource as defined by the target application server's JNDI configuration -->
<property name="hibernate.connection.datasource">jdbc/sivrDS</property>
<property name="hibernate.jndi.url">t3://142.178.51.48:27043/</property>
<property name="hibernate.jndi.class">weblogic.jndi.WLInitialContextFactory</property>
<!-- Optional parameters -->
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.pool_size">5</property>
<property name="use_outer_join">false</property>
<property name="show_sql">false</property>
<!-- Mapping of existing production routing tables -->
<mapping resource = "com/telus/ccs/adminRouting/model/po/RoutingUtilityAdmin.hbm.xml"/>
</session-factory>
</hibernate-configuration>~
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
Name and version of the database you are using:
Oracle9i
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
##PEM initializing class SessionFactoryObjectFactory
##PEM registered: 0e32b3b0090048f501090048f9880000 (unnamed)
##PEM Not binding factory to JNDI, no JNDI name configured
##PEM instantiated session factory
##PEM opened session
##PEM begin
##PEM current autocommit status:true
##PEM disabling autocommit
##PEM find: from com.telus.ccs.adminRouting.model.po.RoutingUtilityAdmin as cts where cts.keyType = :keyTy
pe
##PEM named parameters: {keyType=CLOSED_QUEUE_PROMPT_LIST}
##PEM compiling query
##PEM flushing session
##PEM Flushing entities and processing referenced collections
##PEM Processing unreferenced collections
##PEM Scheduling collection removes/(re)creates/updates
##PEM Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
##PEM Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
##PEM Dont need to execute flush
##PEM HQL: from com.telus.ccs.adminRouting.model.po.RoutingUtilityAdmin as cts where cts.keyType = :keyTyp
e
##PEM SQL: select routinguti0_.recordID as recordID, routinguti0_.keyType as keyType, routinguti0_.keyName
as keyName, routinguti0_.keyValue as keyValue, routinguti0_.description as descript5_ from RoutingUtilityAd
min routinguti0_ where (routinguti0_.keyType=? )
##PEM about to open: 0 open PreparedStatements, 0 open ResultSets
##PEM select routinguti0_.recordID as recordID, routinguti0_.keyType as keyType, routinguti0_.keyName as ke
yName, routinguti0_.keyValue as keyValue, routinguti0_.description as descript5_ from RoutingUtilityAdmin r
outinguti0_ where (routinguti0_.keyType=? )
##PEM preparing statement
##PEM SQL Exception
java.sql.SQLException: Table not found in statement [select routinguti0_.recordID as recordID, routinguti0_
.keyType as keyType, routinguti0_.keyName as keyName, routinguti0_.keyValue as keyValue, routinguti0_.descr
iption as descript5_ from RoutingUtilityAdmin routinguti0_ where (routinguti0_.keyType=? )
at org.hsqldb.jdbc.Util.throwError(Util.java:56)
Login
FAQ
Search
