-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 10 posts ] 
Author Message
 Post subject: Bad SQL grammer
PostPosted: Wed Sep 21, 2005 7:16 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
I'm using JDBC with spring and hibernate to connect to a Progress 9.1E database, when I execute a query i get the following error, stack trace:

10:21:39,984 INFO [SpringhibController] returning SpringhibController view
10:21:40,140 INFO [STDOUT] Hibernate: select country0_.CTLNAM as col_0_0_ from
XMCTRY0 country0_ where country0_.CTISO=AE
10:21:40,140 WARN [JDBCExceptionReporter] SQL Error: -20005, SQLState: 42S02
10:21:40,140 ERROR [JDBCExceptionReporter] [JDBC Progress Driver]:Table/View/Syn
onym not found (7519)
10:21:40,140 WARN [JDBCExceptionReporter] SQL Error: -20005, SQLState: 42S02
10:21:40,140 ERROR [JDBCExceptionReporter] [JDBC Progress Driver]:Table/View/Syn
onym not found (7519)
10:21:40,140 ERROR [DispatcherServlet] Could not complete request
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not
execute query; bad SQL grammar [select country0_.CTLNAM as col_0_0_ from XMCTRY0
country0_ where country0_.CTISO=AE]; nested exception is java.sql.SQLException:
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
java.sql.SQLException: [JDBC Progress Driver]:Table/View/Synonym not found (7519
)
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.ja
va:6644)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:68
37)
at com.progress.sql.jdbc.JdbcProgress.SQLUTFPrepare(JdbcProgress.java:46
10)
at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcPro
gressConnection.java:586)
at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcPro
gressConnection.java:552)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:396)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:334)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:766)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:315)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:757)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:749)
at db.CountryManagerDaoImpl.getList(CountryManagerDaoImpl.java:38)
at bus.CountryManager.getCountries(CountryManager.java:32)
at web.SpringhibController.handleRequest(SpringhibController.java:39)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha
ndle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(Frame
workServlet.java:386)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl
et.java:346)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356
)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:514)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.jboss.jetty.Jetty.service(Jetty.java:459)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
201)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)

I'm pretty sure that my Hibernate mapping files are correct, the statement I'm trying to execute is:

getHibernateTemplate().find("select c.DESCRIPTION from bus.Country c where c.ISOCODE=AE");

But thats seems to be mapping to SQL:

"select country0_.CTLNAM as col_0_0_ from XMCTRY0 country0_ where country0_.CTISO=AE"

Why are my columns being prefixed with country0_, this is not how they are defined in my database

Surely this is a very basic query and should have no trouble, any help would be greatly appreciated

Thanks.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 21, 2005 7:27 am 
Newbie

Joined: Wed Sep 21, 2005 5:51 am
Posts: 3
Hope i'm not missing something, but shouldn't be it:

Code:
....where country0_.CTISO='AE'


instead of:

Code:
CTISO=AE


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 21, 2005 7:31 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
I really wish it were that simple, unfortunately not, there probably should be apostrophers but I get the same error either way


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 21, 2005 10:30 am 
Beginner
Beginner

Joined: Mon Aug 16, 2004 6:15 am
Posts: 24
Perhaps this part of the stack trace is more pertinent

java.sql.SQLException: [JDBC Progress Driver]:Table/View/Synonym not found (7519)


This would seem to indicate that the table XMCTRY0 doesn't exist in the schema you have connected to.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 21, 2005 10:33 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
I see what your saying but the table most definitely does exist and is accessible from outside my code, I think it must be a DB connection problem, possibly with the URL I'm specifing


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 21, 2005 1:59 pm 
Pro
Pro

Joined: Fri Sep 02, 2005 4:21 am
Posts: 206
Location: Vienna
gavkearney wrote:
Why are my columns being prefixed with country0_, this is not how they are defined in my database

This is just a synonym (from XMCTRY0 country0_ defines country0_ as a synonym for XMCTRY0).

Have you tried to enter
Code:
select country0_.CTLNAM as col_0_0_ from XMCTRY0 country0_ where country0_.CTISO=AE

interactively?

In any case, could you post the create script for XMCTRY0 and the Hibernate mapping?

It must be a very simple error - so simple none of use sees it...

Erik


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 22, 2005 4:20 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
It works if I leave out the "as col_0_0_" part, if i leave it in i get an Invalid datatype exception.

Here's the mapping file:

Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

        <class name="bus.Country" table="XMCTRY0">

                <id name="COUNTRY" column="CTCCDE" type="string">
                        <generator class="increment"/>
                </id>

                <property name="DESCRIPTION" column="CTLNAM" type="string"/>
            <property name="SHORTDESCRIPTION" column="CTSNAM" type="string"/>
            <property name="ECONOMICGROUP" column="CTEGRP" type="string"/>
            <property name="ECCNGROUP" column="CTECCNG" type="string"/>
            <property name="IMPORTGROUP" column="CTCCIM" type="string"/>
              <property name="EXPORTGROUP" column="CTCCEX" type="string"/>
              <property name="DOMESTICINBOUNDGROUP" column="CTCCDX" type="string"/>
              <property name="DOMESTICOUTBOUNDGROUP" column="CTCCDI" type="string"/>
              <property name="VATPREFIXNUMBER" column="CTVATP" type="string"/>
              <property name="NATIONALITY" column="CTNATD" type="string"/>
              <property name="ALTERNATIVECODE" column="CTACDE" type="string"/>
              <property name="MARKET" column="CTGRP" type="string"/>
              <property name="DATEFORMAT" column="CTDATF" type="string"/>
              <property name="DECIMALFORMAT" column="CTDECF" type="string"/>
              <property name="ISOCODE" column="CTISO" type="string"/>
              <property name="ISONUMERICCODE" column="CTISON" type="string"/>
              <property name="FORINTRASTATREPORTING" column="CTINTR" type="string"/>
            <property name="ZONE" column="CTPZON" type="string"/>
            <property name="ZONEFORMAT" column="CTZNFM" type="string"/>
            <property name="POSTALCODEFORMAT" column="CTPCFM" type="string"/>
            <property name="FOREIGNTRADEZONE" column="CTFTZC" type="string"/>
            <property name="PRIMARYLANGUAGEONDOCUMENTS" column="CTLAN" type="string"/>
            <property name="ADDRESSLAYOUTTYPE" column="CTADRK" type="string"/>
            <property name="CHARGECLASS" column="CTGLAC" type="string"/>
            <property name="EUCLASSIFICATION" column="CTEUCL" type="string"/>
            <property name="REFUNDABLE" column="CTRFND" type="string"/>
            <property name="USERDEFINED1" column="CTUDEF01" type="string"/>
            <property name="USERDEFINED2" column="CTUDEF02" type="string"/>
            <property name="USERDEFINED3" column="CTUDEF03" type="string"/>   

        </class>
</hibernate-mapping>


Here's my build.xml file, hope this is what you were looking for

Code:
<?xml version="1.0"?>

<project name="springhib" basedir="." default="usage">
    <property file="build.properties"/>

    <property name="src.dir" value="src"/>
    <property name="web.dir" value="war"/>
    <property name="build.dir" value="${web.dir}/WEB-INF/classes"/>
    <property name="name" value="springhib"/>
    <property name="target.dir" value="bin"/>
    <property name="deploy.path" value="e:/traxi3/itrax/jj/server/default/deploy"/>
    <property name="appserver.home" value="e:/traxi3/itrax/jj/server/default"/>
    <property name="codegen.dir" value="data"/>
    <property name="config.dir" value="config"/>
   
    <!-- Write the schema to a text file -->
    <property name="hibernate.args" value="--output=schema.ddl"/>
    <!-- Change this to suite your desired dialect -->
    <property name="hibernate.dialect" value="org.hibernate.dialect.ProgressDialect"/>
    <!-- This property should be the fully qualified class name of your JDBC driver -->
    <property name="hibernate.conn.driver_class" value="com.progress.sql.jdbc.JdbcProgressDriver"/>
    <!-- Update these properties to reflect your database -->
    <property name="hibernate.conn.url" value="jdbc:JdbcProgress:T:pslpc354:xttraxprog60dbedujdbc:xttrax;wa=536870912"/>
    <property name="hibernate.conn.username" value="sysprogress"/>
    <property name="hibernate.conn.password" value="sysprogress"/>

    <path id="master-classpath">

        <fileset dir="${appserver.home}/lib">
            <include name="*.jar"/>
        </fileset>
        <fileset dir="E:/workarea/lib/spring">
           <include name="*.jar"/>
        </fileset>
       <fileset dir="E:/Java/eclipse/plugins/org.apache.ant_1.6.5/lib">
          <include name="ant.jar"/>
       </fileset>
        <fileset dir="E:/TRAXi3/iTRAX/lib/ws">
            <include name="*.jar"/>
        </fileset>
        <fileset dir="E:/workarea/Common/bin">
            <include name="**/*"/>
        </fileset>
        <fileset dir="E:/workarea/iTRAX/bin">
            <include name="**/*"/>
        </fileset>
    </path>
   
    <!-- Hibernate mapping files -->
    <fileset id="hibernate.mapping.files" dir="${src.dir}">
        <include name="**/*.hbm.xml" />
    </fileset>

    <target name="usage">
        <echo message=""/>
        <echo message="${name} build file"/>
        <echo message="-----------------------------------"/>
        <echo message=""/>
        <echo message="Available targets are:"/>
        <echo message=""/>
        <echo message="build     --> Build the application"/>
        <echo message="deploy    --> Deploy application as directory"/>
        <echo message="deploywar --> Deploy application as a WAR file"/>
        <echo message=""/>
    </target>

    <target name="build" description="Compile main source tree java files">
        <mkdir dir="${build.dir}"/>

        <javac destdir="${build.dir}" target="1.3" debug="true"
               deprecation="false" optimize="false" failonerror="true">
            <src path="${src.dir}"/>
            <classpath refid="master-classpath"/>
        </javac>
    </target>

    <target name="deploywar" depends="build" description="Deploy application as a WAR file">
      <delete>
         <fileset dir=".">
             <include name="*.war"/>
         </fileset>
      </delete>
       
        <war destfile="${name}.war"
             webxml="${web.dir}/WEB-INF/web.xml">
            <fileset dir="${web.dir}">
                <include name="**/*.*"/>
            </fileset>
        </war>
        <copy todir="${deploy.path}" preservelastmodified="true">
            <fileset dir=".">
                <include name="*.war"/>
            </fileset>
        </copy>
    </target>
   
    <target name="schemaexport">
    <taskdef name="schemaexport"
        classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
        classpathref="master-classpath"/>
   
       <schemaexport
           quiet="true"
           text="true"
           drop="false"
           delimiter=";"
           output="data/schema-export.sql"
          properties="config/hibernate.properties">
           <fileset dir="${src.dir}">
               <include name="**/*.hbm.xml"/>
           </fileset>
       </schemaexport>
   </target>


<target name="gen-classes" description="Generate .java from .hbm files]">
    <pathconvert refid="hibernate.mapping.files"
             property="hibernate.mappings" pathsep=" "/>
       <java classname="net.sf.hibernate.tool.hbm2java.CodeGenerator">
             <classpath refid="master-classpath"/>
           <arg line="--output=${codegen.dir}"/>
           <arg line="${hibernate.mappings}"/>
     </java>
</target>

   
    <target name="copy-resources">
       <copy todir="${target.dir}">
         <fileset dir="${src.dir}">
            <exclude name="**/*.java"/>
         </fileset>
      </copy>
       <copy todir="war/WEB-INF/classes/bus">
          <fileset dir="src/bus">
             <include name="country.hbm.xml"/>
          </fileset>
       </copy>
    </target>
   
</project>
   



I really appreciate any help you can give me on this


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 22, 2005 9:18 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
ok I got that problem fixed by prefixing the table xmctry0 with pub to give pub.xmctry0 in the hibernate mapping file.

But now I'm getting an error which I fear may be more serious and driver related, all thoughts and ideas are very welcome, heres my stack trace:

Code:
14:04:48,263 INFO  [SpringhibController] returning SpringhibController view
14:04:49,248 INFO  [STDOUT] Hibernate: select country0_.CTLNAM as col_0_0_, coun
try0_.CTEGRP as col_1_0_ from pub.XMCTRY0 country0_ where country0_.CTISO='AE'
14:04:49,263 WARN  [AbstractBatcher] exception clearing maxRows/queryTimeout
java.sql.SQLException: [JDBC Progress Driver]:Optional feature not implemented.
        at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.ja
va:6644)
        at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:68
37)
        at com.progress.sql.jdbc.JdbcProgress.SQLGetStmtOption(JdbcProgress.java
:4174)
        at com.progress.sql.jdbc.JdbcProgressStatement.getStmtOption(JdbcProgres
sStatement.java:1286)
        at com.progress.sql.jdbc.JdbcProgressStatement.getQueryTimeout(JdbcProgr
essStatement.java:755)
        at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatche
r.java:205)
        at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatche
r.java:143)
        at org.hibernate.loader.Loader.doQuery(Loader.java:433)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:218)
        at org.hibernate.loader.Loader.doList(Loader.java:1593)
        at org.hibernate.loader.Loader.list(Loader.java:1577)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:271)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
        at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:766)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:315)
        at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:757)
        at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:749)
        at db.CountryManagerDaoImpl.getList(CountryManagerDaoImpl.java:31)
        at bus.CountryManager.getCountries(CountryManager.java:32)
        at web.SpringhibController.handleRequest(SpringhibController.java:39)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha
ndle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(Frame
workServlet.java:386)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl
et.java:346)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356
)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:514)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)
        at org.mortbay.http.HttpServer.service(HttpServer.java:879)
        at org.jboss.jetty.Jetty.service(Jetty.java:459)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
201)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)
14:04:49,279 ERROR [DispatcherServlet] Could not complete request
java.lang.ClassCastException
        at db.CountryManagerDaoImpl.getList(CountryManagerDaoImpl.java:31)
        at bus.CountryManager.getCountries(CountryManager.java:32)
        at web.SpringhibController.handleRequest(SpringhibController.java:39)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha
ndle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(Frame
workServlet.java:386)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl
et.java:346)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356
)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:514)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)
        at org.mortbay.http.HttpServer.service(HttpServer.java:879)
        at org.jboss.jetty.Jetty.service(Jetty.java:459)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
201)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)
14:04:49,279 WARN  [jbossweb] WARNING: Exception for /springhib/hello.htm
java.lang.ClassCastException
        at db.CountryManagerDaoImpl.getList(CountryManagerDaoImpl.java:31)
        at bus.CountryManager.getCountries(CountryManager.java:32)
        at web.SpringhibController.handleRequest(SpringhibController.java:39)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha
ndle(SimpleControllerHandlerAdapter.java:44)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:684)
        at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:625)
        at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(Frame
workServlet.java:386)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl
et.java:346)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356
)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:514)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)
        at org.mortbay.http.HttpServer.service(HttpServer.java:879)
        at org.jboss.jetty.Jetty.service(Jetty.java:459)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
201)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)



Any ideas, thanks


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 14, 2005 1:48 pm 
Newbie

Joined: Mon Nov 14, 2005 12:46 pm
Posts: 10
hi gavkearney
i'm looking for anyone that is working with hibernate + progress db
i'm trying to develop a prototype using both but accessing the progress db through their application server. not jdbc.
what are your impressions on using hibernate + progress?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 15, 2005 5:52 am 
Newbie

Joined: Tue Sep 13, 2005 4:44 am
Posts: 7
Hibernate by itself is good, not so sure of how good it is with progress. My advice is if you can use another database, do. As you can see from the last stack trace that i posted i there are many db compliance version problems.
I'm not currently working with Hibernate, my work was only investigatory. Hibernate is a very good and userful technology and i highly recommend it, however, as I far I can see Progress is dated and I think if possible you should leave it behind.

if you have no choice on the DB matter and want to pursue hibernate, thenn by all means try it out. Once you get the hang of it, it's pretty easy and there's also 3 or 4 plugins for eclipse. You may however, need to modify the JDBC driver files, (or maybe progress have released another driver), anyway, ik would definitely suggest you try out the examples, there's plenty on the web, just be patient.
FYI we do not currently use Hibernate where I work but this is because itdoesn't really fit our system setup right now, but maybe in the future.

Any more problems don't hesitate to ask


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 10 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.