StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJava PreparedStatement RETURN_GENERATED_KEYS not working
primarykey
Id
11105815
data
AcceptedAnswerId
14220990
AnswerCount
4
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2012-06-19T17:02:41.277
FavoriteCount
1
LastActivityDate
2015-02-17T16:34:09.520
LastEditDate
2012-06-19T17:24:38.567
LastEditorUserId
284750
OwnerUserId
284750
ParentId
0
PostTypeId
1
Score
1
ViewCount
7473
LastEditorDisplayName
text
Body
I am trying to get the identity column returned to my java program when doing a SQL insert. I am getting the following error when running the code <pre><code> Uncaught exception thrown in one of the service methods of the servlet: Cocoon. Exception thrown : java.lang.AbstractMethodError: java/sql /Connection.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement; </code></pre> Here is the code I am running. <pre><code>private void insertUserInputParameters(ReportData rptData){ UserInputParameters userParams = rptData.getUserInputData(); StringBuilder sql = new StringBuilder(); PreparedStatement pstmt = null; ResultSet rs = null; int userDataId = -1; //Get a database connection. sl = ServiceLocator.getInstance(); ds = sl.getDataSource("jdbc/collegeguide"); con = ds.getConnection(); con.setReadOnly(false); sql.append("insert into cpgusrdtaf (statecd, addr1, addr2, city, state, "); sql.append("zipcode, dependent, shdindic, marstatus, residency, prntatge, "); sql.append("fincome, mincome, pincome, taxspaid, taxreturn, elig1040, "); sql.append("gincome, pcash, inetwrth, bnetwrth, pbenefit, paddlinf, "); sql.append("puntax, pdslcwrk, smstatus, sresidncy, studtr, stud1040, "); sql.append("sadjinc, sincome, spincome, sdslcwrk, studtax, scash, "); sql.append("sinvest, snetwrth, saddlinf, suntax, househld, nmbrsch, "); sql.append("studact, studsat, schools, housing) "); sql.append("values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, "); sql.append("?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); //This line of code is where I get the error** pstmt = con.prepareStatement(sql.toString(), Statement.RETURN_GENERATED_KEYS); //If I remove the 'Statement.RETURN_GENERATED_KEYS' I do not get the error.** pstmt = con.prepareStatement(sql.toString()); setStatementValues(pstmt, userParams); pstmt.executeUpdate(); rs = pstmt.getGeneratedKeys(); if(rs.next()){ userDataId = rs.getInt(1); } </code></pre> I am not allowed to use stored procedures, so I cannot go that route. Any help would be greatly appreciated I am using java 1.5 Thanks in advance Doug
Tags
<java><sql><jdbc><insert><prepared-statement>
Title
Java PreparedStatement RETURN_GENERATED_KEYS not working
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDoug
UserOwnerUserId
1. USDoug
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.