How to get OracleConnection for storing JGeometry to Oracle DB
I am trying store JGeometry to Oracle database with the following code:
@PersistenceContext
private EntityManager entityManager;
...
Session session = entityManager.unwrap(Session.class);
session.doWork(new Work() {
@Override
public void execute(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement("UPDATE SAMPLE_AREA SET GEOMETRY=? WHERE ID = " + sampleAreaId + " AND SAMPLE_ID = " + sampleId);
System.out.println(connection); // prints: org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler@321ca777[valid=true]
System.out.println(connection.getClass().getName()); // prints: com.sun.proxy.$Proxy125
STRUCT obj = JGeometry.store(jGeometry, connection);
ps.setObject(1, obj);
ps.execute();
}
});
I am getting java.lang.ClassCastException: com.sun.proxy.$Proxy125 cannot be cast to oracle.jdbc.OracleConnection when calling JGeometry.store.
How can I get OracleConnection?
I am using "hibernate.dialect = org.hibernate.dialect.Oracle10gDialect"
java oracle hibernate exception
asked Nov 14 '18 at 13:42
JRMJRM
114
add a comment |
I am trying store JGeometry to Oracle database with the following code:
@PersistenceContext
private EntityManager entityManager;
...
Session session = entityManager.unwrap(Session.class);
session.doWork(new Work() {
@Override
public void execute(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement("UPDATE SAMPLE_AREA SET GEOMETRY=? WHERE ID = " + sampleAreaId + " AND SAMPLE_ID = " + sampleId);
System.out.println(connection); // prints: org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler@321ca777[valid=true]
System.out.println(connection.getClass().getName()); // prints: com.sun.proxy.$Proxy125
STRUCT obj = JGeometry.store(jGeometry, connection);
ps.setObject(1, obj);
ps.execute();
}
});
I am getting java.lang.ClassCastException: com.sun.proxy.$Proxy125 cannot be cast to oracle.jdbc.OracleConnection when calling JGeometry.store.
How can I get OracleConnection?
I am using "hibernate.dialect = org.hibernate.dialect.Oracle10gDialect"
java oracle hibernate exception
asked Nov 14 '18 at 13:42
JRMJRM
114
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07
add a comment |
I am trying store JGeometry to Oracle database with the following code:
@PersistenceContext
private EntityManager entityManager;
...
Session session = entityManager.unwrap(Session.class);
session.doWork(new Work() {
@Override
public void execute(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement("UPDATE SAMPLE_AREA SET GEOMETRY=? WHERE ID = " + sampleAreaId + " AND SAMPLE_ID = " + sampleId);
System.out.println(connection); // prints: org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler@321ca777[valid=true]
System.out.println(connection.getClass().getName()); // prints: com.sun.proxy.$Proxy125
STRUCT obj = JGeometry.store(jGeometry, connection);
ps.setObject(1, obj);
ps.execute();
}
});
I am getting java.lang.ClassCastException: com.sun.proxy.$Proxy125 cannot be cast to oracle.jdbc.OracleConnection when calling JGeometry.store.
How can I get OracleConnection?
I am using "hibernate.dialect = org.hibernate.dialect.Oracle10gDialect"
java oracle hibernate exception
asked Nov 14 '18 at 13:42
JRMJRM
114
I am trying store JGeometry to Oracle database with the following code:
@PersistenceContext
private EntityManager entityManager;
...
Session session = entityManager.unwrap(Session.class);
session.doWork(new Work() {
@Override
public void execute(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement("UPDATE SAMPLE_AREA SET GEOMETRY=? WHERE ID = " + sampleAreaId + " AND SAMPLE_ID = " + sampleId);
System.out.println(connection); // prints: org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler@321ca777[valid=true]
System.out.println(connection.getClass().getName()); // prints: com.sun.proxy.$Proxy125
STRUCT obj = JGeometry.store(jGeometry, connection);
ps.setObject(1, obj);
ps.execute();
}
});
I am getting java.lang.ClassCastException: com.sun.proxy.$Proxy125 cannot be cast to oracle.jdbc.OracleConnection when calling JGeometry.store.
How can I get OracleConnection?
I am using "hibernate.dialect = org.hibernate.dialect.Oracle10gDialect"
java oracle hibernate exception
java oracle hibernate exception
asked Nov 14 '18 at 13:42
JRMJRM
114
asked Nov 14 '18 at 13:42
JRMJRM
114
asked Nov 14 '18 at 13:42
JRMJRM
114
asked Nov 14 '18 at 13:42
JRMJRM
114
asked Nov 14 '18 at 13:42
JRMJRM
114
114
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07
add a comment |
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07
add a comment |
1 Answer
1
active
oldest
votes
I figured out the solution. Instead of using Connection as parameter to JGeometry.store one needs to use OracleConnection. That can be unwrapped from Connection. I think I tried this before, but most likely I had wrong import, correct is oracle.jdbc.OracleConnection.
import oracle.jdbc.OracleConnection;
...
OracleConnection oracleConnection = connection.unwrap( OracleConnection.class );
STRUCT obj = JGeometry.store(jGeometry, oracleConnection);
answered Nov 16 '18 at 6:42
JRMJRM
114
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53301647%2fhow-to-get-oracleconnection-for-storing-jgeometry-to-oracle-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I figured out the solution. Instead of using Connection as parameter to JGeometry.store one needs to use OracleConnection. That can be unwrapped from Connection. I think I tried this before, but most likely I had wrong import, correct is oracle.jdbc.OracleConnection.
import oracle.jdbc.OracleConnection;
...
OracleConnection oracleConnection = connection.unwrap( OracleConnection.class );
STRUCT obj = JGeometry.store(jGeometry, oracleConnection);
answered Nov 16 '18 at 6:42
JRMJRM
114
add a comment |
I figured out the solution. Instead of using Connection as parameter to JGeometry.store one needs to use OracleConnection. That can be unwrapped from Connection. I think I tried this before, but most likely I had wrong import, correct is oracle.jdbc.OracleConnection.
import oracle.jdbc.OracleConnection;
...
OracleConnection oracleConnection = connection.unwrap( OracleConnection.class );
STRUCT obj = JGeometry.store(jGeometry, oracleConnection);
answered Nov 16 '18 at 6:42
JRMJRM
114
add a comment |
I figured out the solution. Instead of using Connection as parameter to JGeometry.store one needs to use OracleConnection. That can be unwrapped from Connection. I think I tried this before, but most likely I had wrong import, correct is oracle.jdbc.OracleConnection.
import oracle.jdbc.OracleConnection;
...
OracleConnection oracleConnection = connection.unwrap( OracleConnection.class );
STRUCT obj = JGeometry.store(jGeometry, oracleConnection);
answered Nov 16 '18 at 6:42
JRMJRM
114
I figured out the solution. Instead of using Connection as parameter to JGeometry.store one needs to use OracleConnection. That can be unwrapped from Connection. I think I tried this before, but most likely I had wrong import, correct is oracle.jdbc.OracleConnection.
import oracle.jdbc.OracleConnection;
...
OracleConnection oracleConnection = connection.unwrap( OracleConnection.class );
STRUCT obj = JGeometry.store(jGeometry, oracleConnection);
answered Nov 16 '18 at 6:42
JRMJRM
114
answered Nov 16 '18 at 6:42
JRMJRM
114
answered Nov 16 '18 at 6:42
JRMJRM
114
answered Nov 16 '18 at 6:42
JRMJRM
114
114
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53301647%2fhow-to-get-oracleconnection-for-storing-jgeometry-to-oracle-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Or is there some other way to store geometry in to ORACLE database?
– JRM
Nov 15 '18 at 9:07