execute « SQL « JPA Q&A





1. Execute SQL on Deploy - JPA Project    forums.netbeans.org

I have a Netbeans project using Java Web Services, Java Persistence Top Link with a MySQL server, deploying to Glassfish 2.1.1. For testing purposes I would like to execute a bunch ...

2. Execute Sql Script while at stratup    forum.hibernate.org

I want to execute sql script at my application startup , i have idea about the import.sql file but it works only the hb2ddl.auto=create mode only , i can not use that because it will empty my other table also . I have another option also like write the whole script in my dao then execute it but the script is ...

3. Throwing Null Pointer Exception while executing native SQL    forum.hibernate.org

Newbie Joined: Thu Jul 22, 2010 5:37 am Posts: 3 I am using two formula field in my POJO class. When I am using native SQL query to get information Null Pointer Exception is throwing. Same SQL query is working fine if I executing that SQL in SQL Prompt. HQL query is working fine. Issue is with SQL query only. Please ...

4. Is HibernateCallback best for executing SQL/procedures    forum.hibernate.org

I'm working on a web based application that belongs to an automobil manufacturer, developed in Spring-Hibernate with MS SQL Server 2005 database. There are three kind of use cases: 1) Through this application, end users can request for creating a Car, Bus, Truck etc through web based interfaces. When a user logs in, a HTML form gets displayed for capturing technical ...

5. Executing multiple native SQL queris in one go?    forum.hibernate.org

Hi guys, I'm (rather) new to Hibernate. I've got a medium-sized project going on at university where we're using Hibernate 3.0 (we had little choice here) and we also had to use the javax.persistence-annotations - so a very restricted environment. Our program requires a rather complex logic when it comes to deleting objects / entries on the underlying MySQL database, so ...

6. execute straight SQL?    forum.hibernate.org

Build your own objects ? may I ask why ? And do you know the implications for it ? (I know a couple of reasons - but I would like to hear yours ;) Options you got: 1. session.connection().putYourFavoriteJDBCStuffHere() 2. session.createSQLQuery(); 3. HQL new() syntax ...like "select new PersonDTO(p.name, p.address) from Person p 4. HQL report queries like "select p.name, p.address ...

7. Record executed SQL?    forum.hibernate.org

Hello, is it possible to record (programatically) all executed SQL statements (incl. bind variables) for a transaction? Why: we're currently developing a master data editor for a billing application. The editor works on a staging application (mimicking the production deployment). If the changes work in the staging environment, we want to replicate the changes to the production environment (using the recorded ...

8. Executing Native SQL    forum.hibernate.org

Hibernate version: 2.1.3 and 2.1.6 Name and version of the database: Oracle 9i The issue: I have seen a few more complex scenarios than the issue i am facing, but i could not find the posting of a solution in the instance of invalid column name SQLExceptions occuring when trying to retrieve a list of organisations filtering upon the columns I ...

9. Wierd problem, sql not executing    forum.hibernate.org

Newbie Joined: Fri Oct 22, 2004 4:43 pm Posts: 2 I have a problem that is causing me quite a bit of grief. I am developing in WSAD 5.0 (jdk1.3) and deploying to a HPUx WebSphere environment running WAS 5.1.1.1 (jdk1.4). It seems that for whatever reason, I have a retrieval that returns nothing when run on my server. The local ...





10. Error when executing Native SQL.    forum.hibernate.org

This is what I am getting... I am trying to execute a native SQL query as given below... I am running hibernate 3.x and oracle 9.x database. Could one of you please help, what I am doing wrong... ? SELECT companyinf5_.NAME as impName docket2_.DOCKET_YEAR as docketYear, docket2_.DOCKET_SEQ as docketSeq, docket2_.GAS_TYPE as gasType, companyinf7_.NAME as suppName, to_char(quarterlyt1_.ARRIVAL_DATE, 'yyyy-mm') as arrivalDate , sum(quarterlyt1_.VOLUME) ...

11. Executing sql code    forum.hibernate.org

12. java.sql.SQLException: No suitable driver executing ant eg    forum.hibernate.org

Newbie Joined: Mon Sep 18, 2006 6:34 am Posts: 18 Hi all, I've seen this post a few times on the forum and it seems that most people get it sorted by adding the jdbc driver classes to the hibernate lib directory or else including them in the classpath. I've done both and still have no joy running the example. I'm ...

13. Execute SQL statements    forum.hibernate.org

14. Need help in executing sql server2005 procedure in hibernate    forum.hibernate.org

hi, iam newbie to hibernate and sql server 2005. i want to know how do we execute sql server 2005 stored procedure in hibernate. Below is my database tables: Database tables: CREATE TABLE CL_USER_DETAILS( USER_ID INT IDENTITY (1,1) PRIMARY KEY, USER_NAME NVARCHAR(20) UNIQUE NOT NULL, USER_SSN NVARCHAR(100) UNIQUE NOT NULL, USER_SALUTATION NVARCHAR(5) NOT NULL, USER_FIRST_NAME NVARCHAR(50) NOT NULL, USER_LAST_NAME NVARCHAR(50) NOT ...

15. How to execute native SQL function.    forum.hibernate.org

16. Profiling sql sent to the db via BasicExecutor.execute()    forum.hibernate.org

Hi, I'd like to start profiling all the SQL statements being sent via hibernate to the database, basically to get a total execution + transport time for every db call. I've played around with the Interceptor and EventListener interfaces and I can capture most statements via flushEvents or postFlush()/preFlush() interception, but I can't seem to find a way to intercept arbitrary ...