oracle « Oracle « JPA Q&A





1. Hibernate findByCriteria strange behaviour    stackoverflow.com

I have a simple method that just does two lines and tries to return all objects in an oracle database table:

DetachedCriteria criteria = DetachedCriteria.forClass(Object.class);
return (Collection)getHibernateTemplate().findByCriteria(criteria);
However, I got an "ORA-01031: insufficient privileges" ...

2. oracle where in limitation to 1000 / hibernate    stackoverflow.com

Oracle knows the limitation to 1000 elements in the where a in (..) clause. Does this limitation also exist when using Hibernate in conjuction with Oracle?

3. Hibernate translation capabilities    stackoverflow.com

Our project must be able to run both in Oracle and SQL Server. The problem is we have a number of HQL + native queries with non-standard operators (i.e. bitand and ...

4. A couple of questions about the use of Hibernate and ORM with Oracle    stackoverflow.com

I am thinking of writing a tool that will list all the tables in an oracle database. Clicking on any of the links for each of the table will load the ...

5. How to build a change tracking system - not audit system    stackoverflow.com

I have a requirement in which I need to capture data changes (not auditing) and life cycle states on inventory. Technology: Jave, Oracle, Hibernate + JPA For the data changes, we have been given ...

6. Hibernate with HSQLDB and Oracle    stackoverflow.com

I have moved a group of tables to hsqldb for faster performance, however there are a few residual Many to 1 associations between the hsqldb tables and Oracle tables. Is ...

7. Hibernate does not create Java classes. What can I do?    stackoverflow.com

I am using NetBeans 6.5.1 and Hibernate 3.2.5. I stepped through this tutorial by using a different, existing database (Oracle 10g XE). The creation of the config file works fine, ...

8. Fast way to get results in hibernate?    stackoverflow.com

I currently have hibernate set up in my project. It works well for most things. However today I needed to have a query return a couple hundred thousand rows ...

9. Hibernate+oracle10g    coderanch.com





10. Hibernate + Oracle    coderanch.com

11. hibernate + oracle    coderanch.com

i have downloaded and installed oracle 9.2.04 for linux on one m/c downloaded and put the ojdbc14.jar in the lib directory along with other jar files.Do i need to have any other jar files?

17. JPA vs Oracle ADF    coderanch.com

18. use Restrictions.ilike with Oracle/Roman charactor    forum.hibernate.org

when I use Hibernate Restrictions.ilike I found that Hibernate pass Java String.toLowerCase() as value but use dialect.getLowercaseFunction() as column key if query value contains a roman charactor "", String.toLowerCase() will make it "",but oracle lower() still leave "" as "",this makes result set wrong. is this a bug or am I missed something? Thanks for help

19. Using Hibernate with Oracle Mutlimedia (OrdImage)    forum.hibernate.org

I am having trouble getting this to work. I am using Oracle 10g and have extended the Oracle10gDialect class as metioned in another post to get hibernate to recognixe the OrdImage datatype. I am able to get the image file uploaded from the client and parsed to a OrdHttpUploadFile object. I can't figure out how to get from this object to ...

20. Oracle + Hibernate question    forum.hibernate.org

Example I have Oracle table with CHAR and NUMBER fields. ID NUMBER(1) PASSWORD CHAR(3) NAME VARCHAR2(4) and data is ID PASSWORD NAME 1 passwd test When I execute following query by using hibernateTemplate.execute "select id, password, name from test_table" my return is "null" "null" "test" If I edit query like this "select trim(id), trim(password), trim(name) from test_table" This returns correct result ...

21. problem with the connexion to oracle10g    forum.hibernate.org

Good Morning, I am trying to connect to my database written with oracle10g through hibernate but while generating hbm.xml files after the mapping there are tables with none of its attributes even i am sure that i did put them in the script and really i don't know why so please if anyone could guess what's the cause i shall be ...

22. Hibernate problem with Oracle    forum.hibernate.org

23. what is the different between Oracle databse and hibernate    forum.hibernate.org

i am a student in my second year in the university and i heard that hibernate databse is replcacing oracle database , but i know that sound not true , so what is the differnt for example between using hibernate database and oracle database. i know one who is working in a company that develop products and the products were developed ...

25. oracle to hibernate    forum.hibernate.org

we are planning to convert our existing database into hibernate which is currently in oracle 10g. our database has queries with 5 or 6 joins and it and we are using struts . Our database is a payroll and hrms database with 30 to 35 tables and is moderate in size. Any ideas and suggestions on converting any material or guide ...

26. Oracle connectivity    forum.hibernate.org

27. Oracle Longs    forum.hibernate.org

I saw a message regarding this issue in the old Sourceforge forum but I didn't see a resolution. Here is a (partial) hibernate mapping: Code: ...

28. Oracle9i hangs    forum.hibernate.org

Hi I am using Oracle9i Release2, jdbc Driver for 9.2.0.1 for jdk 1.4- ojdbc14.jar. When I start tomcat, in my ContextListener, I try to create SessionFactory by doing new Configuration().configure("/hibernate_astronomy.cfg.xml").buildSessionFactory(); it just hangs, it never prints the println statement after this line. During debugging, I realised that Hibernate is trying to get the connection as it prints out this on command ...

29. Oracle9i part 2    forum.hibernate.org

Ok, thank to gloeglm, and epbernard, I am one step closer to trying out Hibernate. As you can see I am one step closer, so here is my problem. I am getting this exception when I try to update the schema on a Oracle9i database. This one looks ugly. java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) at ...

30. AdminApp and Oracle    forum.hibernate.org

31. Oracle limitation: large "where x in (....)'    forum.hibernate.org

I'm not sure if this option really exists. At least, I did not find anything about that. Besides that, Hibernate would then rely on a specific setting in the Oracle installation, which is not always feasible. By the way, the Jira issue HB-655 that I issued was closed as "Won't fix" without any further comments last year... Christian

32. oracle metadata    forum.hibernate.org

Hi, I looked through the FAQ and search around but could not find an answer to this question, which I'm sure must've come up before. When generating the mapping file using middlegen all varchar2 fields appears with columnlength * 4? Number "length" is picked up correctly. I double checked using desc in sqlplus when connected to the source database. I'm using ...

33. Hibernate and Oracle Cluster    forum.hibernate.org

I am not a developer, so please take it easy on me. We are implementing an Oracle 10.1.0.4 RAC cluster in the same timeframe that our application counterparts are moving to Hibernate from a home-grown solution. The application teams involved would like to know if there is any special configuration or customization that will be required in order for Oracle connection ...

34. set Bolb to Oracle    forum.hibernate.org

I am trying to save a PDF binary to oracle as Blob, here is my mapping /** @author Hibernate CodeGenerator */ public class ProposalDoc implements Serializable ...

35. Hibernate and Oracle optimizer    forum.hibernate.org

36. Oracle 8.0.5 compatibility    forum.hibernate.org

If you use the OracleDialect (not 9i but 8i) mostly it will work fine. You will not be able to use the query limits (setting min/max query results) unless you provide an alternate Dialect as the solution is 8i + specific. I cannot think of anything else you will have a problem with.

37. HQ oracle SUBSTR    forum.hibernate.org

marace wrote: But I've notice a stange thing: using MySQL (and mysql dialect) this query doesn't work! I recive an error message like this:"Alias undefined on query ..." (Query syntax in mysql is correct, using jdbc it works!) Can someone tell me the reason of this difference using Oracle and using MySQL? Thanks. Mara Each database dialect has a number of ...

39. Big problem with oracle 8i    forum.hibernate.org

40. oracle connecty by prior    forum.hibernate.org

41. Could I work with Hibernate and OR Features of Oracle?    forum.hibernate.org

I would like to know information about Hibernate support for Oracle. Could I work with Hibernate and OR Features of Oracle? For example, Oracle allows us to define types similar to the types of SQL. The syntax is CREATE TYPE t AS OBJECT ( list of attributes and methods ); Types can also be relation schemas.. etc. Well, is there a ...

42. Problems with oracle and hibernate    forum.hibernate.org

Hallo, I'm starting with Hibernate but I'm unable to store a object into database, this is my code, mapping element and console stackTrace Some help please. Hibernate version: hibernate 2 Mapping documents: ...

43. Good match? Hibernate & Oracle Apps    forum.hibernate.org

Our company uses Oracle Applications for all of its enterprise data (customers, orders, etc). I'm pretty new to Hibernate so please forgive the possible stupid newbie question. Oracle Apps uses "interface" tables that are used when data is inserted. That is, clients would only insert data into these interface tables and not the "real" tables. So when adding a customer I ...

44. keyword name clash with oracle    forum.hibernate.org

Hello, I am trying to retrieve a row from a oracle 9 db that is synthetisied by oracle for a compound key. This row is always called "rowid". The problem is that 'rowid' is also a key word and because of this, hibernates fails miserably. Every thing would be fine if the generated SQL were select a2uebergan0_.rowid, a2uebergan0_.verk_to as verk_to, a2uebergan0_.sec_von ...

45. Trouble with Oracle and Hibernate docs    forum.hibernate.org

I've just been reading section 8 of the Hibernate reference (2.1.7) It mentions three ways of mapping objects to a relational database, but doesn't say anything about databases (such as Oracle and PostgresQL) that can support object storage and polymorphism natively. Can someone please add something to the manual and/or FAQ to state Hibernate's attitude to this type of database? Does ...

46. java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsol    forum.hibernate.org

Hi, friends... I,m getting the following error java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole at oracle.jdbc.driver.DMSFactory.(DMSFactory.java:27) at oracle.jdbc.driver.OracleConnection.createDMSSensors(OracleConnection.java:506) at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:330) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:485) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:337) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101) at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73) at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789) at work.AmigoDAO.(AmigoDAO.java:16) at work.Listar.lista(Listar.java:31) at work.TesteAmigo.main(TesteAmigo.java:54) Exception in thread "main" I had copy all files from an stand-alone application that was working fine, and insert into an application under Eclipse ...

47. oracle 7 and hibernate    forum.hibernate.org

Currently full support requires 8i and above since these are the dialects available. On the surface 8 (and thus 7) should (partially) work but the JDBC driver will dictate that. Its the driver that providing the connection meta data. If you can get connected etc then some adjustments to the dialect should be able to be created to cover most remaining ...

48. Hibernate v2.1 and Oracle v10, Is It Possible?    forum.hibernate.org

Greetings Fellow Hibernate Users, On the occasion of my 1st post, allow me to say something most here already know, namely that Hibernate rocks! By way of a brief introduction, I'm an application and tool developer, working mostly in Java, primarily w/ applications that interface w/ ERP systems such as SAP & P3e. I'm fairly new to Hibernate, I've been spending ...

49. Oracle SequenceNextValString in Hibernate    forum.hibernate.org

50. Oracle Soundex and Hibernate    forum.hibernate.org

Hi, Kind of new to Hibernate. Planning to use the latest HB3. Here is the question: I have a search form that searches the DB for people based on different information, including their last/first name. The user can specify last/first name % match, so that Oracle Soundex package can return names of people that "sound" the same to a certain % ...

51. SerializationException during deserialization with Oracle    forum.hibernate.org

Hi, I am receiving a SerializationException (during deserialization) when trying to load an object in Hibernate 3.0.1. I am using Oracle 10g. The class I have is very simple: Code: public class ResourceAttribute { private String name; private String value; private Serializable data; ... public Serializable getData() { return data; } ...

52. Hibernate benchmark, Oracle problems    forum.hibernate.org

There are some levels in my database (data structure is hierarchical) : 1 level - one record 2nd level - 364 3rd level - 729 4. level 500 records 5 level 10000 Im getting from database explicit one record (elemen level 1) and than through lazy initialization i go down my structure. During my experiment I want to visit every element ...

53. Problem using Hibernate 3.0.4 on Oracle    forum.hibernate.org

java.lang.NoSuchMethodError: java.sql.DatabaseMetaData: method getDatabaseMajorVersion()I not found at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:75) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004) at cat.euro.server.util.hbm.HibernateUtil.(HibernateUtil.java:44) at cat.euro.server.util.hbm.HibernateUtil.(HibernateUtil.java:33) at cat.euro.server.util.hbm.HbmBaseDAO.getSession(HbmBaseDAO.java:31) at cat.eur.da.absenteism.dao.SecurityDAO.getSecurity(SecurityDAO.java:45) at cat.eur.da.absenteism.service.SecurityService.getRules(SecurityService.java:46) at cat.eur.da.absenteism.service.AbsentService.getUser(AbsentService.java:273) at cat.euro.test.TestEmployeeReport.testReportMove(TestEmployeeReport.java:94)

54. Oracle Configuration    forum.hibernate.org

I am wasting a lot of time looking for the proper information to put in the hibernate.properties file to configure it for oracle. Does anyone know what I need to use? Or maybe where I can find this info? Here is what I have so far, but it won't work: hibernate.dialect=net.sf.hibernate.dialect.OracleDialect hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:bsadir.BSADIRECT hibernate.connection.username=system hibernate.password=xxxxxxxxxx I get a connection refused error ...

55. Problem porting hibernate impl from Oracle to SQL Server    forum.hibernate.org

I'm experiencing problems porting a hibernate dao implementation from Oracle to SQL Server. In many of the mapping files I have the generator for an id declared as "native". Some of them have a sequence param for Oracle. Shouldn't SQL Server ignore the sequence param and use it's native auto increment? It's failing because Hibernate is building sql referencing "dual" to ...

56. How to call Funtion in Oracle?    forum.hibernate.org

Thanks Snpesnpe. I was looking for more hibernate way to call Oracle Function but concluded with following code: Code: // get connection through SessionFactory & DataSource SessionFactory sessionFactory = getHibernateTemplate().getSessionFactory(); DataSource dataSource = SessionFactoryUtils.getDataSource(sessionFactory); Connection connection = DataSourceUtils.getConnection(dataSource); try{ // call the function ...

57. Hibernate with Oracle PKG's / PRC's    forum.hibernate.org

58. Hibernate problem with Oracle    forum.hibernate.org

I am using Hibernate 3 and Oracle 9 i. When I am trying to run my hibernate queries against Hypersonic database it works fine with all relationships. But when running these with Oracle I am getting various exceptions. Following are the properties I am using in hibernate.cfg.xml file Code: jdbc:oracle:thin:@database url

59. Swing + Hibernate + Oracle. Is it possible ?    forum.hibernate.org

60. setComment() on Oracle not working?    forum.hibernate.org

61. Oracle tablespace    forum.hibernate.org

62. How to deploy hibernate app under Oracle Content Management    forum.hibernate.org

Hi All, I have a hibernate application which is perfectly working in Tomcat Server. I need to deploy the application under an OC4J Instance of Oracle Content Management SDK. But when I run the application under Oracle CMSDK Server, some errors are coming. The error is given below. javax.faces.FacesException: Error calling action method of component with id _id32:_id45 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) at ...

63. How to make Hibernate quering given oracle partitions only?    forum.hibernate.org

Hibernate version: 3 Name and version of the database you are using: Oracle 9 We have an application where users can log in and see some information about themselves. A part of the information is in a big table. The table is divided into many partitions according to "inserted" field. Each partition corespondes one month (BIGTABLEMMYY: BIGTABLE0106, BIGTABLE0206 and so on). ...

64. Can not gernerate code from oracle with hibernate tool    forum.hibernate.org

I try to gernerate codes from oracle 8.17. I followed every step your movie taught. But when I create the reverse config file , I refreshed many times,the table in oracle still not display. I checked out my connection code and so on. All are right. Besides I tried that with mysql,it works. how to solve this problem? please help

65. Can't work with Oracle's synonyms!!!    forum.hibernate.org

Hello, I can't work with Oracle's synonyms. I can only see synonyms for system's schema! ... when I use synonyms, the return is an oracle's error : table or view does not exist ; It seems that rights on the synonyms are well granted for the user for the schema that I want ...

66. Oracle very strange behaviour in AbstractBatcher    forum.hibernate.org

Dear, I noticed Hibernate was doing very poor with large resultsets. After a long debugging session including the hibernate source I came to the following rather bizar conclusion. In our application we have mapped 151 tables using Hibernate and 15 views. The views are mapped 1 object per view (one on one, no relationship whatsoever). In certain cases we have to ...

67. working with Oracle varrays    forum.hibernate.org

Hi, I try to use (OracleCallableStatement), but got the following error. It seems the case is still fail. And I also use "OracleConnection conn = (OracleConnection) session.connection();", but it got $ProxyXX error too. Code: org.hibernate.SessionFactory sessionFactory = getHibernateTemplate().getSessionFactory(); org.hibernate.Session session = sessionFactory.openSession(); String[] javaArray1 = {"AAAA","BBB"}; OracleCallableStatement stmt = (OracleCallableStatement) session.connection().prepareCall("SELECT * FROM table WHERE name IN (SELECT * FROM TABLE ...

68. Oracle lower()    forum.hibernate.org

69. Using hypersonic for development and oracle for production    forum.hibernate.org

Hi, We are planning on using hibernate and spring on a new project. In our development environment we are planning on using hypersonic as our database but in our production environment we will be using oracle. In oracle we plan to use "sequence" as the generator for primary keys and for hypersonic we plan to use "identity" (both options are not ...

70. oracle ocp exams guide ?    forum.hibernate.org

71. Hibernate synchronizer problem with Oracle    forum.hibernate.org

72. Two problems with ORACLE    forum.hibernate.org

Newbie Joined: Thu Aug 17, 2006 8:59 am Posts: 7 Hibernate version: 3.1 Hi. I mapped id like this: Code: Sediste_id_SEQ ...

73. Moving From SQL Server to Oracle    forum.hibernate.org

I have a java web app deployed through JBOSS (v. 3.2.7). I am using Hibernate versions 3.1.3 with a SQL Server 2000. I am thinking of moving the back end to an Oracle Database instead of the SQL Server 2000. So i am trying to figure out what changes have to be done configuration files and the mapping files, and any ...

74. Oracle Light    forum.hibernate.org

75. Problem with Oracle    forum.hibernate.org

76. Problem with JPA with Hibernate + Oracle and Firebird    forum.hibernate.org

When the application is ran, it looks for META-INF/persistence.xml in the classpath. Make sure your META-INF/persistence.xml is accessible at runtime. If this is a stand-alone project, with the output stored in folder "bin", copy the META-INF directory into "bin". If this is a web-application, make sure your WAR file has META-INF/persistence.xml in it.

77. Oracle packages    forum.hibernate.org

Does hibernate support Oracle packages or has it provided any alternative to oracle packages? For e.g; I have a business logic which works with Oracle. Now I want to implement the same with MySQL. Oracle supports packages whereas MySQL doesn't. How can work out the same business logic with Oracle and MySQL?

78. Translating Oracle's (+) to hibernate    forum.hibernate.org

To be more precise, the original Oracle-SQL query looks like: Code: select R.orden as Orden, Max(R.fichero) as Fichero, Max(R.msgid) as MsgId, max(R.timestamp) as timestamp, Max(R.idusuario) as IdUsuario, Max(R.msgidreenviado) as MsgIdReenviado, Max(AO.orden) as ordenAudO, Max(AO.codigoexplotacion) as CodigoExplotacionAudO, Max(AO.valorsignifictrans) as ValorSignificTransAudO, Max(AO.estado) as EstadoAudO, Max(AO.tipoapunte) as TipoApunteAudO, Max(AO.timestamp) as TimeStampAudO, Max(AO.msgId) as MsgIdAudO, Max(AO.codigointerfaz) as CodigoInterfazAudO, ...

79. How to configure 2 different databse( Oracle & MSSQL S)    forum.hibernate.org

Hi, Folks, I had all data in MSSQL server, I setup hibernate.cfg.xml. but right now my customer wants put part of data in Oracle 10g. so I need to configure the one hibernate.cfg.xml for both Oracle and MSSql server. all data objects are still in the same application. How to do it? Please help. Chwang

80. Using Oracle's DBMS_CRYPTO with Hibernate    forum.hibernate.org

Hibernate version: 3.2 Hi I would like to encrypt some database columns that stores sensitive information. Now I know that there is a Jasypt library that I can use for this but I need a solution that works in the database. Oracle has a database package called DBMS_CRYPTO that you can use to encrypt and decrypt values. How can I create ...

81. Hibernate and Oracle Timestamps    forum.hibernate.org

Hibernate version: 3.05 Ouch, such a headache! When I initially set out my Hibernate mappings, I decided to map Date-Time type data as Calendar on the java side and their Timestamp counterpart on the database side (Oracle). I thought I was sitting pretty, but now I'm not so sure. My thinking was that a Calendar was at bottom a number of ...

82. Comptability with Linux and Oracle10g    forum.hibernate.org

Newbie Joined: Mon Dec 03, 2007 10:04 am Posts: 1 For the following problem, I think I've searched the whole Internet, but I have not found any clue whatsoever. An application uses Hibernate 2 to persist data on an Oracle9i and Oracle10g server. When this application is deployed on WinXP, everything works like a charm. However, when this application is deployed ...

83. Hibernate does not work after Oracle is restarted    forum.hibernate.org

Hibernate version: 3.2.5 Code between sessionFactory.openSession() and session.close(): List result; Session session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Query q = session .createQuery("from ApplGrpPrvVu agp where " + "agp.id.appl.applGn=:applGn and " + "agp.id.grp.grpGn=:grpGn"); q.setBigDecimal("applGn", appl.getApplGn()); q.setString("grpGn", grp.getGrpGn()); result = q.list(); session.getTransaction().commit(); Full stack trace of any exception that occurs: 10:26:56,360 WARN JDBCExceptionReporter:77 - SQL Error: 17002, SQLState: null 10:26:56,370 ERROR JDBCExceptionReporter:78 - 10:26:56,401 ERROR ...

84. Hibernate and Oracle VPD. Can it be that easy    forum.hibernate.org

85. Oracle - Cannot open connectino    forum.hibernate.org

Sometimes I get this error message... Cannot open connection Code: oracle.jdbc.driver.OracleDriver ...

86. Unable to configure Oracle for Hibernate    forum.hibernate.org

Hi, If you look at the Exception that is generated it tells you what the problem is: TransactionFactory class not found: net.sf.hibernate.transaction.JTATransactionFactory Try the following hibernate mapping file: Code: org.hibernate.dialect.Oracle10gDialect ...

87. Hibernate and Oracle Stored Procs in Packages.    forum.hibernate.org

Hello, I have been Googling around for some information regarding Hibernate and its support of stored procedures in Oracle packages. My team is thinking of moving to a Java data layer and would like to replace the data layer we have crafted ourselves (C#). Currently we treat the database packages as the db interface and would like to be able to ...

88. Hibernate + Oracle problem    forum.hibernate.org

Hi all, I'm having a problem trying to make my application work with a combination of hibernate and Oracle database. My Spring configuration indicates: The value of the property "hibernate.hbm2ddl.auto" is "create". And the result is that the database is recreated on each server startup, which results with the deletion of all data in the database which was there prior to ...

89. Statelesssession and Oracle    forum.hibernate.org

90. Supporting Oracle and SQL Server    forum.hibernate.org

true SEQ_TABLE_NAME_PK ...

91. Hibernate with Oracle    forum.hibernate.org

Hello friends of the forum ... I am developing a Web application with Java + Hibernate and Oracle BD. Everything goes well. The problem is when I leave for a good time (2 or 3 hours) without doing anything that I get the following error: [WARN] SQL Error: 17002, SQLState: null [ERROR] Excepcin de E/S: Connection timed out [INFO] ERROR LOG ...

92. Problem many to many with oracle    forum.hibernate.org

Newbie Joined: Tue Jun 17, 2008 4:55 am Posts: 1 Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:[ 3/b] [b]Mapping documents: 3 Code between sessionFactory.openSession() and session.close(): Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not get or update next value at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:41) at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:187) at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:43) at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:51) at org.hibernate.id.TableGenerator.generate(TableGenerator.java:94) at org.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:62) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) ...

93. Oracle UserTypes    forum.hibernate.org

My issue has been solved but I would like to know if there is another (easier) way I could have handled it. There is an oracle table, mytable, that has several fields, varchar2 and integers. It also has a usertype field that contains an object, myobj. Myobj contains 4 fields of various types. I was able to successfully read this table. ...

94. hibernate + oracle + nvarchar2    forum.hibernate.org

Hi.. let me apologize for asking maybe banal question but I'm trying to solve this for at least 5 hours and I'm getting little bit desperate.. I'm trying to map pojo to oracle 10g database table which contains nvarchar2 fields. I'm getting Wrong column type, expected: nvarchar error.. I hope I'm close to solution - I found that it can be ...

95. Making Hibernate retry on node failure with Oracle FCF    forum.hibernate.org

I'm working on an Oracle 11g RAC. We're going to start using FCF. It's my understanding, that in order to make a node failure invisible to the application, the application must detect that the node failed while the application is doing work on the connection, and retry its work. When it gets a new connection from the pool, it will be ...

96. Hibernate 3.1.3, Oracle 10.2.0.1, "Protocol violation&q    forum.hibernate.org

Newbie Joined: Thu Apr 02, 2009 4:53 am Posts: 1 Hi, I am using Hibernate 3.1.3 with Spring. We are using "AnnotationSessionFactoryBean" for hibernate bean configuration. Also we are using Spring 2.0.2. I have a DAO class: ActionHistoryDAOImpl with a method: class ActionHistoryDAOImpl extends HibernateDAOSupport implements ActionHistoryDAO { @Override public void addActionHistory(ActionHistory actionHistory) { getHibernateTemplate().saveOrUpdate(actionHistory); } } Bean declaration in spring's ...

97. OutOfMemoryException using scroll() and Oracle10g    forum.hibernate.org

Newbie Joined: Tue May 26, 2009 2:17 am Posts: 3 The forums already contain a large number of posts on the topic of scrolling through a large data set. Unfortunately I have not been able to find an answer. Our problem is that we experience OutOfMemoryException when we try to iterate through a large data set. The problem seems to be ...

98. proper place for Oracle annoyance fix    forum.hibernate.org

I'm trying to find the right place to add some code to deal with an Oracle annoyance in a seam/ejb web app. I've got some columns of type "TIMEZONE WITH LOCAL TIMESTAMP" and because of this I need to call setSessionTimezone on the underlying OracleConnection (mentioned in docs here) to set the connection's timezone to TimeZone.getDefault().getID() (way to go setting appropriate ...

99. oracle10g hibernate problem    forum.hibernate.org

Beginner Joined: Wed Oct 03, 2007 9:46 pm Posts: 37 when my app startup, i get error like below, can anyone elaborate what i missed out? the app running fine when using mysql. do i miss out any extra parameter in config.xml file? Quote: 2009-08-17 11:32:12,294 [main] INFO [info.jtrac.config.DataSourceFactoryBean] - Not using embedded HSQLDB or JNDI datasource, switching on Apache DBCP ...